SQLite format 3@  - X=( b  ( ,OC) d''tablesurvey_imagessurvey_imagesCREATE TABLE "survey_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "imageable_id" integer, "imageable_type" varchar(255), "position" integer, "photo_file_name" varchar(255), "photo_content_type" varchar(255), "photo_file_size" integer, "caption" varchar(255), "created_at" datetime, "updated_at" datetime)~KtablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "details" text NOT NULL, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime, "questionnaire_id" integer)E)indexindex_questionnaires_on_namequestionnairesCREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name")))gtablequestionnairesquestionnairesCREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL)K%)indexindex_user_answers_on_answer_iduser_answersCREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id") G%!indexindex_user_answers_on_user_iduser_answersCREATE INDEX "index_user_answers_on_user_id" ON "user_answers" ("user_id")Z %%wtableuser_answersuser_answers CREATE TABLE "user_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "answer_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime) Q5indexindex_scores_on_survey_property_idscores CREATE INDEX "index_scores_on_survey_property_id" ON "scores" ("survey_property_id")n ?indexindex_scores_on_answer_idscores CREATE INDEX "index_scores_on_answer_id" ON "scores" ("answer_id")m 5tablescoresscores CREATE TABLE "scores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer NOT NULL, "survey_property_id" integer NOT NULL, "value" integer NOT NULL, "created_at" datetime, "updated_at" datetime)M//Itablesurvey_propertiessurvey_properties CREATE TABLE "survey_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime)xEindexindex_answers_on_question_idanswersCREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id")s=tableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer NOT NULL, "details" text, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime)StablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARS9indexindex_questions_on_questionnaire_idquestionsCREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)rCtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) ^p^ )20111213185612)20111211180011)20111211175604)20111211175518)20111208181449)20111208181429)20111208181414)20111208181247)20111010112000 U{hU)20111213185612 )20111211180011)20111211175604)20111211175518)20111208181449)20111208181429)20111208181414)20111208181247)20111010112000