development.sqlite3 in survey_says-0.0.2

- old
+ new
@@ -1,12 +1,12 @@
-SQLite format 3@  -â
3š
á
9d
-ð
-		níqš‚d''…tablesurvey_imagessurvey_imagesCREATE 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)iƒ!tablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "details" text, "active" boolean, "position" integer, "created_at" datetime, "updated_at" datetime, "questionnaire_id" integer)
E)indexindex_questionnaires_on_namequestionnairesCREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name")))gtablequestionnairesquestionnaires
CREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL)K%)indexindex_user_answers_on_answer_iduser_answersCREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id")
-G%!indexindex_user_answers_on_user_iduser_answersCREATE 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)rCtableusersusers	CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))R‚tablescoresscoresCREATE TABLE "scores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer, "survey_property_id" integer, "value" integer, "created_at" datetime, "updated_at" datetime)D//‚7tablesurvey_propertiessurvey_propertiesCREATE TABLE "survey_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)^ƒtableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "details" text, "active" boolean, "position" integer, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)>‚itablequestionsquestionsCREATE TABLE "questions"S9indexindex_questions_on_questionnaire_idquestionsCREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id")=//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)20111010112000)20111208181449)20111208181429)20111208181414)20111208181247
-	U¡íÚÇ´Ž{hU)20111213185612	)20111211180011)20111211175604)20111211175518)20111010112000)20111208181449)20111208181429)20111208181414)20111208181247
²²L)AATest 1, 2 , 3?2011-12-09 18:20:17.2230732011-12-13 19:59:20.639857
šñäÍÁ­š'survey_images)questionnaires
-scores/survey_propertiesanswers
questions
]¡Aè£]DAAtest2f2011-12-13 20:54:52.1739002011-12-13 20:54:52.173900CAAtestf2011-12-13 20:46:43.4749112011-12-13 20:46:43.474911W=AADo you like the picture?f2011-12-13 20:41:39.2948652011-12-13 20:41:39.294865^KAAMy second answer in position 1.t2011-12-10 17:20:34.0070512011-12-10 18:01:23.414393]IAAMy first answer in position 2.t2011-12-10 17:10:51.3566532011-12-10 17:11:21.682678
ì¹s2ìD#AATraditional2011-12-10 21:46:00.5275622011-12-10 21:46:00.527562?AATrendy2011-12-10 21:45:41.5128552011-12-10 21:45:41.512855D#AADark Colors2011-12-10 21:45:19.8170112011-12-10 21:45:19.817011E%AALight Colors2011-12-10 21:44:10.1304802011-12-10 21:44:10.130480
€À€@À€>AA	2011-12-13 20:46:43.4769802011-12-13 20:46:43.476980>AA2011-12-13 20:42:30.5803812011-12-13 20:42:30.580381>AA2011-12-11 04:44:15.7149722011-12-11 04:44:15.714972>AA2011-12-11 04:44:15.7101372011-12-11 04:44:15.710137>AA2011-12-10 21:51:56.9790612011-12-10 21:51:56.979061>AA
-2011-12-10 21:51:56.9779522011-12-10 21:51:56.977952


+SQLite format 3@  -â

XÁ=(bè
+(	¸	,OÌCª)
«Á‚d''…tablesurvey_imagessurvey_imagesCREATE 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)~ƒKtablequestionsquestionsCREATE 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_namequestionnairesCREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name")))gtablequestionnairesquestionnairesCREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL)K%)indexindex_user_answers_on_answer_iduser_answersCREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id")
G%!indexindex_user_answers_on_user_iduser_answersCREATE 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)	Q5indexindex_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)xEindexindex_answers_on_question_idanswersCREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id")sƒ=tableanswersanswersCREATE 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)SƒtablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARS9indexindex_questions_on_questionnaire_idquestionsCREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)rCtableusersusersCREATE 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íÚÇ´¡Ž{hU)20111213185612	)20111211180011)20111211175604)20111211175518)20111208181449)20111208181429)20111208181414)20111208181247)20111010112000




+


 
-
÷÷test
-÷÷test
-úú
3›3f!!AAAnswerdelete.pngimage/png–ugly image2011-12-13 20:54:52.1766962011-12-13 20:54:52.176696c#!AAAnswerimage01.jpgimage/jpeg¬ƒtest2011-12-13 20:42:30.5824782011-12-13 20:42:30.582478
+

+
+

+
+

\ No newline at end of file