spec/dummy/db/development.sqlite3 in active_metadata-0.6.1 vs spec/dummy/db/development.sqlite3 in active_metadata-0.6.2
- old
+ new
@@ -1,26 +1,20 @@
-SQLite format 3 @ d % d -! SytablesectionssectionsCREATE TABLE "sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "document_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)l'tabledocumentsdocumentsCREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "surname" varchar(255), "keep_alive" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" va
21
- 21
z Aj AAAndrea2012-01-31 14:49:49.7032332012-01-31 14:49:49.703233? AAJohn2012-01-31 14:50:00.2239502012-01-31 14:50:00.223950
#attachments #attachments historiesjdocuments
-notes_watchers users sections $Ot+ P G
#AAnew sectionP2012-01-31 14:42:45.4070912012-01-31 14:42:45.407091G #AAnew section<2012-01-31 14:40:22.7737252012-01-31 14:40:22.773725G #AAnew section 2012-01-31 14:40:13.5591542012-01-31 14:40:13.559154G
- #AAnew section 2012-01-31 14:40:13.2865432012-01-31 14:40:13.286543G #AAnew section 2012-01-31 11:01:56.3890802012-01-31 11:01:56.389080G #AAnew section 2012-01-31 11:01:43.6991472012-01-31 11:01:43.699147G #AAnew section 2012-01-31 11:01:42.7140162012-01-31 11:01:42.714016G #AAnew section 2012-01-31 10:50:25.5561952012-01-31 10:50:25.556195F #AAnew sectionZ2012-01-31 10:50:17.6115852012-01-31 10:50:17.611585F #AAnew sectionS2012-01-31 10:50:17.2687662012-01-31 10:50:17.268766F #AAnew section?2012-01-31 10:49:29.9652642012-01-31 10:49:29.965264F #AAnew section 2012-01-31 10:49:21.2460032012-01-31 10:49:21.246003F #AAnew section2012-01-31 10:49:20.8509342012-01-31 10:49:20.8 #
%k.2 E R )AAemail@email.itJohnsmith2012-01-31 11:01:45.2480532012-01-31 11:01:45.248053; AA2012-01-31 11:01:40.7683012012-01-31 11:01:40.768301Z
- +!AAemail2@email.itGeorgeWashington2012-01-31 10:50:18.2514172012-01-31 10:50:18.251417R )AAemail@email.itJohnsmith2012-01-31 10:50:18.2464182012-01-31 10:50:18.246418R )AAemail@email.itJohnsmith2012-01-31 10:50:18.1815762012-01-31 10:50:18.181576R )AAemail@email.itJohnsmith2012-01-31 10:50:18.1221582012-01-31 10:50:18.122158; AA2012-01-31 10:50:15.4854112012-01-31 10:50:15.485411Z +!AAemail2@email.itGeorgeWashington2012-01-31 10:49:21.9180862012-01-31 10:49:21.918086R )AAemail@email.itJohnsmith2012-01-31 10:49:21.9129482012-01-31 10:49:21.912948R )AAemail@email.itJohnsmith2012-01-31 10:49:21.8468572012-01-31 10:49:21.846857R )AAemail@email.itJohnsmith2012-01-31 10:49:21.7814502012-01-31 10:49:21.781450; AA2012-01-31 10:49:19.0382442012-01-31 10:49 " !
_* q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l'tabledocumentsdocumentsCREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "surname" varchar(255), "keep_alive" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)SytablesectionssectionsCREATE TABLE "sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "document_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
$ $
E f+tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "firstname" varchar(255), "lastname" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)5Itablenotesnotes
-CREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note" text, "label" varchar(255), "document_class" varchar(255), "document_id" integer, "created_by" integer, "updated_by" integer, "starred" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)pAindexindex_notes_on_document_idnotesCREATE INDEX "index_notes_on_document_id" ON "notes" ("document_id")] 5}indexindex_notes_on_labelnotesCREATE INDEX "index_notes_on_label" ON "notes" ("label")m
-?indexindex_notes_on_updated_atnotes
CREATE INDEX "index_notes_on_updated_at" ON "notes" ("updated_at")yG!indexindex_notes_on_document_classnotesCREATE INDEX "index_notes_on_document_class" ON "notes" ("document_class")
P P \D ' ^] % AAsurname notesurnameDocumentf2012-01-31 14:49:58.0956752012-01-31 14:49:58.095675U_ AAnote_2nameDocumentf2012-01-31 14:50:00.2863652012-01-31 14:50:00.286365U^ AAnote_1nameDocumentf2012-01-31 14:50:00.2551352012-01-31 14:50:00.255135
- ]_^
- surname] name_ name^
- A2012-01-31 14:49:58.095675]A2012-01-31 14:50:00.286365_A2012-01-31 14:50:00.255135^
-
Document]
Document_
Document^
R R AAname 2nameDocument2012-01-31 14:49:42.7997572012-01-31 14:49VX #AA498document_idDocument2012-01-31 14:49:51.1562772012-01-31 14:49:51.156277XW #AAnew sectiontitleDocument2012-01-31 14:49:51.1543202012-01-31 14:49:51.154320Pj AAJohnnameDocument2012-01-31 14:50:00.2261732012-01-31 14:50:00.226173
t ) }G!indexindex_histories_on_created_athistoriesCREATE INDEX "index_histories_on_created_at" ON "histories" ("created_at")n=
indexindex_histories_on_labelhistoriesCREATE IND tablehistorieshistoriesCREATE TABLE "histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" text, "label" varchar(255), "document_class" varchar(255), "document_id" integer, "created_by" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
I%indexindex_histories_on_document_idhistoriesCREATE INDEX "index_histories_on_document_id" ON "histories" ("document_id")n=
indexindex_histories_on_labelhistoriesCREATE INDEX "index_histories_on_label" ON "histories" ("label")}G!indexindex_histories_on_created_athistoriesCREATE INDEX "index_histories_on_created_at" ON "histories" ("created_at") O1indexindex_histories_on_document_classhistoriesCREATE INDEX "index_histories_on_document_class" ON "histories" ("document_class")
- XWj
- #document_idX
-titleW namej
- A2012-01-31 14:49:42.799757A2012-01-31 14:49:51.156277XA2012-01-31 14:49:51.154320WA2012-01-31 14:50:00.226173j
-
Document
DocumentX
DocumentW
Documentj
pM )+AAAsurnameDocumentpdf_test_2.pdfapplication/pdf/2012-01-31 14:50:00.147429f2012-01-31 14:50:00.1847052012-01-31 14:50:00.184705 )+AAAsurnameDocumentpdf_test_1.pdfapplication/pdf/2012-01-31 14:49:56.075439f2012-01-31 14:49:56.0780362012-01-31 14:49:56.078036 )+AAAnameDocumentpdf_test_2.pdfapplication/pdf/2012-01-31 14:50:00.267297f2012-01-31 14:50:00.2711152012-01-31 14:50:00.271115 )+AAAnameDocumentpdf_test_1.pdfapplication/pdf/2012-01-31 14:50:00.238963f2012-01-31 14:50:00.2405852012-01-31 14:50:00.240585
`c L##_tableattachmentsattachmentsCREATE TABLE "attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "document_id" integer, "document_class" varchar(255), "created_by" integer, "updated_by" integer, "counter" integer, "attach_file_name" varchar(255), "attach_content_type" varchar(255), "attach_file_size" integer, "attach_updated_at" datetime, "starred" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)M#-indexindex_attachments_on_document_idattachmentsCREATE INDEX "index_attachments_on_document_id" ON "attachments" ("document_id")vA#indexindex_attachments_on_labelattachmentsCREATE INDEX "index_attachments_on_label" ON "attachments" ("label")Y#Eindexindex_attachments_on_attach_updated_atattachmentsCREATE INDEX "index_attachments_on_attach_updated_at" ON "attachments" ("attach_updated_at")
-
- surnamesurname name name
- A2012-01-31 14:50:00.147429A2012-01-31 14:49:56.075439A2012-01-31 14:50:00.267297 A2012-01-31 14:50:00.238963
-
Document
Document
Document
Document
j; indexindex_watchers_on_labelyEindexindex_watchers_on_created_atwatchers CREATE INDEX "index_watchers_on_created_at" ON "watchers" ("created_at")S#9indexindex_attachments_on_document_classattachmentsCREATE INDEX "index_attachments_on_document_class" ON "attachments" ("document_class")_tablewatcherswatchersCREATE TABLE "watchers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "label" varchar(255), "document_class" varchar(255), "document_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|G!indexindex_watchers_on_document_idwatchersCREATE INDEX "index_watchers_on_document_id" ON "watchers" ("document_id")j; indexindex_watchers_on_labelwatchersCREATE INDEX "index_watchers_on_label" ON "watchers" ("label")sAindexindex_watchers_on_owner_idwatchersCREATE INDEX "index_watchers_on_owner_id" ON "watchers" ("owner_id")
K AAnameDocument2012-01-31 14:49:43.0633872012-01-31 14:49:43.063387
-
- name
-
- A2012-01-31 14:49:43.063387
E ok.2 E R )AAemail@email.itJohnsmith2012-01-31 11:01:45.2480532012-01-31 11:01:45.248053; AA2012-01-31 11:01:40.7683012012-01-31 11:01:40.768301Z
- +!AAemail2@email.itGeorgeWashington2012-01-31 10:50:18.2514172012-01-31 10:50:18.251417R )AAemail@email.itJohnsmith2012-01-31 10:50:18.2464182012-01-31 10:50:18.246418R )AAemail@email.itJohnsmith2012-01-31 10:50:18.1815762012-01-31 10:50:18.181576R )AAemail@email.itJohnsmith2012-01-31 10:50:18.1221582012-01-31 10:50:18.122158; AA2012-01-31 10:50:15.4854112012-01-31 10:50:15.485411Z +!AAemail2@email.itGeorgeWashington2012-01-31 10:49:21.9180862012-01-31 10:49:21.918086R )AAemail@email.itJohnsmith2012-01-31 10:49:21.9129482012-01-31 10:49:21.912948R )AAemail@email.itJohnsmith2012-01-31 10:49:21.8468572012-01-31 10:49:21.846857R )AAemail@email.itJohnsmith2012-01-31 10:49:21.7814502012-01-31 10:49:21.781450; AA2012-01-31 10:49:19.0382442012-01-31 10:49:19.038244
. Xkg* . R )AAemail@email.itJohnsmith2012-01-31 14:42:46.3090482012-01-31 14:42:46.309048R )AAemail@email.itJohnsmith2012-01-31 14:42:46.2538692012-01-31 14:42:46.253869R )AAemail@email.itJohnsmith2012-01-31 14:42:46.1976042012-01-31 14:42:46.197604; AA2012-01-31 14:42:43.2820342012-01-31 14:42:43.282034Z +!AAemail2@email.itGeorgeWashington2012-01-31 14:40:14.1924762012-01-31 14:40:14.192476R )AAemail@email.itJohnsmith2012-01-31 14:40:14.1850682012-01-31 14:40:14.185068R )AAemail@email.itJohnsmith2012-01-31 14:40:14.1228442012-01-31 14:40:14.122844R )AAemail@email.itJohnsmith2012-01-31 14:40:14.0639602012-01-31 14:40:14.063960; AA2012-01-31 14:40:10.7627082012-01-31 14:40:10.762708Z +!AAemail2@email.itGeorgeWashington2012-01-31 11:01:45.3950642012-01-31 11:01:45.395064R )AAemail@email.itJohnsmith2012-01-31 11:01:45.3887552012-01-31 11:01:45.388755R
)AAemail@email.itJohnsmith2012-01-31 11:01:45.3217312012-01-31 11:01:45.321731
P p(Ot+ P G
#AAnew sectionP2012-01-31 14:42:45.4070912012-01-31 14:42:45.407091G #AAnew section<2012-01-31 14:40:22.7737252012-01-31 14:40:22.773725G #AAnew section 2012-01-31 14:40:13.5591542012-01-31 14:40:13.559154G
- #AAnew section 2012-01-31 14:40:13.2865432012-01-31 14:40:13.286543G #AAnew section 2012-01-31 11:01:56.3890802012-01-31 11:01:56.389080G #AAnew section 2012-01-31 11:01:43.6991472012-01-31 11:01:43.699147G #AAnew section 2012-01-31 11:01:42.7140162012-01-31 11:01:42.714016G #AAnew section 2012-01-31 10:50:25.5561952012-01-31 10:50:25.556195F #AAnew sectionZ2012-01-31 10:50:17.6115852012-01-31 10:50:17.611585F #AAnew sectionS2012-01-31 10:50:17.2687662012-01-31 10:50:17.268766F #AAnew section?2012-01-31 10:49:29.9652642012-01-31 10:49:29.965264F #AAnew section 2012-01-31 10:49:21.2460032012-01-31 10:49:21.246003F #AAnew section2012-01-31 10:49:20.8509342012-01-31 10:49:20.850934
n% G #AAnew section2012-01-31 14:49:51.1523762012-01-31 14:49:51.152376G #AAnew section2012-01-31 14:49:40.7929322012-01-31 14:49:40.792932G #AAnew section2012-01-31 14:49:40.5380452012-01-31 14:49:40.538045G #AAnew section2012-01-31 14:42:54.7243782012-01-31 14:42:54.724378G #AAnew sectionW2012-01-31 14:42:45.6920372012-01-31 14:42:45.692037
gk ; AA2012-01-31 15:57:31.1430612012-01-31 15:57:31.143061; AA2012-01-31 15:56:59.4756262012-01-31 15:56:59.475626Z +!AAemail2@email.itGeorgeWashington2012-01-31 14:49:43.0578732012-01-31 14:49:43.057873R )AAemail@email.itJohnsmith2012-01-31 14:49:43.0517532012-01-31 14:49:43.051753R )AAemail@email.itJohnsmith2012-01-31 14:49:42.9953682012-01-31 14:49:42.995368R )AAemail@email.itJohnsmith2012-01-31 14:49:42.9413082012-01-31 14:49:42.941308; AA2012-01-31 14:49:38.6440432012-01-31 14:49:38.644043Z +!AAemail2@email.itGeorgeWashington2012-01-31 14:42:46.3156572012-01-31 14:42:46.315657
+SQLite format 3 @ "