SQLite format 3@ .~X z `N+~"Y3Eindexindex_rapidfire_questions_on_survey_idrapidfire_questionsCREATE INDEX "index_rapidfire_questions_on_survey_id" ON "rapidfire_questions" ("survey_id")~33#tablerapidfire_questionsrapidfire_questionsCREATE TABLE "rapidfire_questions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "survey_id" integer, "type" varchar, "question_text" varchar, "default_text" varchar, "placeholder" varchar, "position" integer, "answer_options" text, "validation_rules" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)M1Mindexindex_rapidfire_attempts_on_userrapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_user" ON "rapidfire_attempts" ("user_type", "user_id")Ao1oindexindex_rapidfire_attempts_on_user_id_and_user_typerapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_user_id_and_user_type" ON "rapidfire_attempts" ("user_id", "user_type") W1Aindexindex_rapidfire_attempts_on_survey_idrapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_survey_id" ON "rapidfire_attempts" ("survey_id") 119tablerapidfire_attemptsrapidfire_attempts CREATE TABLE "rapidfire_attempts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "survey_id" integer, "user_type" varchar, "user_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) Y/Eindexindex_rapidfire_answers_on_question_idrapidfire_answers CREATE INDEX "index_rapidfire_answers_on_question_id" ON "rapidfire_answers" ("question_id") W/Aindexindex_rapidfire_answers_on_attempt_idrapidfire_answers CREATE INDEX "index_rapidfire_answers_on_attempt_id" ON "rapidfire_answers" ("attempt_id") //?tablerapidfire_answersrapidfire_answers CREATE TABLE "rapidfire_answers" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "attempt_id" integer, "question_id" integer, "answer_text" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)ckIindexindex_active_storage_variant_records_uniquenessactive_storage_variant_records CREATE UNIQUE INDEX "index_active_storage_variant_records_uniqueness" ON "active_storage_variant_records" ("blob_id", "variation_digest")hIIKtableactive_storage_variant_recordsactive_storage_variant_recordsCREATE TABLE "active_storage_variant_records" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "blob_id" bigint NOT NULL, "variation_digest" varchar NOT NULL)O5?indexindex_active_storage_blobs_on_keyactive_storage_blobsCREATE UNIQUE INDEX "index_active_storage_blobs_on_key" ON "active_storage_blobs" ("key")]55]tableactive_storage_blobsactive_storage_blobsCREATE TABLE "active_storage_blobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "filename" varchar NOT NULL, "content_type" varchar, "metadata" text, "service_name" varchar NOT NULL, "byte_size" bigint NOT NULL, "checksum" varchar, "created_at" datetime(6) NOT NULL)ccA/indexindex_active_storage_attachments_uniquenessactive_storage_attachmentsCREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id")8cAYindexindex_active_storage_attachments_on_blob_idactive_storage_attachmentsCREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)0AAktableactive_storage_attachmentsactive_storage_attachmentsCREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) NOT   !Iactive_storage_variant_recordsAactive_storage_attachments      N  | r kE'q7 `ccA/indexindex_active_storage_attachments_uniquenessactive_storage_attachmentsCREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id")8cAYindexindex_active_storage_attachments_on_blob_idactive_storage_attachmentsCREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id")AA7tableactive_storage_attachmentsactive_storage_attachmentsCREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_c3b3935057" FOREIGN KEY ("blob_id") REFERENCES "active_storage_blobs" ("id") )3EtableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)//etablerapidfire_surveysrapidfire_surveysCREATE TABLE "rapidfire_surveys" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "introduction" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "after_survey_content" text, "active" boolean)"Y3Eindexindex_rapidfire_questions_on_survey_idrapidfire_questionsCREATE INDEX "index_rapidfire_questions_on_survey_id" ON "rapidfire_questions" ("survey_id")~33#tablerapidfire_questionsrapidfire_questionsCREATE TABLE "rapidfire_questions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "survey_id" integer, "type" varchar, "question_text" varchar, "default_text" varchar, "placeholder" varchar, "position" integer, "answer_options" text, "validation_rules" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)M1Mindexindex_rapidfire_attempts_on_userrapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_user" ON "rapidfire_attempts" ("user_type", "user_id")Ao1oindexindex_rapidfire_attempts_on_user_id_and_user_typerapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_user_id_and_user_type" ON "rapidfire_attempts" ("user_id", "user_type") W1Aindexindex_rapidfire_attempts_on_survey_idrapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_survey_id" ON "rapidfire_attempts" ("survey_id") 119tablerapidfire_attemptsrapidfire_attempts CREATE TABLE "rapidfire_attempts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "survey_id" integer, "user_type" varchar, "user_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) Y/Eindexindex_rapidfire_answers_on_question_idrapidfire_answers CREATE INDEX "index_rapidfire_answers_on_question_id" ON "rapidfire_answers" ("question_id") W/Aindexindex_rapidfire_answers_on_attempt_idrapidfire_answers CREATE INDEX "index_rapidfire_answers_on_attempt_id" ON "rapidfire_answers" ("attempt_id") //?tablerapidfire_answersrapidfire_answers CREATE TABLE "rapidfire_answers" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "attempt_id" integer, "question_id" integer, "answer_text" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)kIindexindex_active_storage_variant_records_uniquenessactive_storage_variant_records CREATE UNIQUE INDEX "index_active_storage_variant_records_uniqueness" ON "active_storage_variant_records" ("blob_id", "variation_O5?indexindex_active_storage_blobs_on_keyactive_storage_blobsCREATE UNIQUE INDEX "index_active_storage_blobs_on_key" ON "active_storage_blobs" ("key")]55]tableactive_storage_blobsactive_storage_blobsCREATE TABLE "active_storage_blobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "filename" varchar NOT NULL, "content_type" varchar, "metadata" text, "service_name" varchar NOT NULL, "byte_size" bigint NOT NULL, "checksum" varchar, "created_at" datetime(6) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)            1[= 3 MQ1T55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsckIindexindex_active_storage_variant_records_uniquenessactive_storage_variant_recordsCREATE UNIQUE INDEX "index_active_storage_variant_records_uniqueness" ON "active_storage_variant_records" ("blob_id", "variation_digest")NIItableactive_storage_variant_recordsactive_storage_variant_recordsCREATE TABLE "active_storage_variant_records" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "blob_id" bigint NOT NULL, "variation_digest" varchar NOT NULL, CONSTRAINT "fk_rails_993965df05" FOREIGN KEY ("blob_id") REFERENCES "active_storage_blobs" ("id") )ccA/indexindex_active_storage_attachments_uniquenessactive_storage_attachmentsCREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id")8cAYindexindex_active_storage_attachments_on_blob_idactive_storage_attachmentsCREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id")AA7tableactive_storage_attachmentsactive_storage_attachmentsCREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_c3b3935057" FOREIGN KEY ("blob_id") REFERENCES "active_storage_blobs" ("id") )3EtableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)//etablerapidfire_surveysrapidfire_surveysCREATE TABLE "rapidfire_surveys" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "introduction" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "after_survey_content" text, "active" boolean)"Y3Eindexindex_rapidfire_questions_on_survey_idrapidfire_questionsCREATE INDEX "index_rapidfire_questions_on_survey_id" ON "rapidfire_questions" ("survey_id")    L & RccA/indexindex_active_storage_attachments_uniquenessactive_storage_attachmentsCREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id")8cAYindexindex_active_storage_attachments_on_blob_idactive_storage_attachmentsCREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id")AA7tableactive_storage_attachmentsactive_storage_attachmentsCREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_c3b3935057" FOREIGN KEY ("blob_id") REFERENCES "active_storage_blobs" ("id") )3EtableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)//etablerapidfire_surveysrapidfire_surveysCREATE TABLE "rapidfire_surveys" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "introduction" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "after_survey_content" text, "active" boolean)"Y3Eindexindex_rapidfire_questions_on_survey_idrapidfire_questionsCREATE INDEX "index_rapidfire_questions_on_survey_id" ON "rapidfire_questions" ("survey_id")~33#tablerapidfire_questionsrapidfire_questionsCREATE TABLE "rapidfire_questions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "survey_id" integer, "type" varchar, "question_text" varchar, "default_text" varchar, "placeholder" varchar, "position" integer, "answer_options" text, "validation_rules" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)M1Mindexindex_rapidfire_attempts_on_userrapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_user" ON "rapidfire_attempts" ("user_type", "user_id")Ao1oindexindex_rapidfire_attempts_on_user_id_and_user_typerapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_user_id_and_user_type" ON "rapidfire_attempts" ("user_id", "user_type") W1Aindexindex_rapidfire_attempts_on_survey_idrapidfire_attemptsCREATE INDEX "index_rapidfire_attempts_on_survey_id" ON "rapidfire_attempts" ("survey_id") 119tablerapidfire_attemptsrapidfire_attempts CREATE TABLE "rapidfire_attempts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "survey_id" integer, "user_type" varchar, "user_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) Y/Eindexindex_rapidfire_answers_on_question_idrapidfire_answers CREATE INDEX "index_rapidfire_answers_on_question_id" ON "rapidfire_answers" ("question_id") )20130502170733)20170701191411)20170701191422)20190701274749)20230402174122 )20130502170733)20170701191411)20170701191422)20190701274749) 20230402174122 HHl#]AAschema_sha119d44fcb9df491b41700d6578f54e434df9ee7672024-11-21 19:29:14.0285132024-11-21 19:29:14.028514H#AAenvironmenttest2024-11-21 19:29:14.0282602024-11-21 19:29:14.028261 #schema_sha1# environment