spec/dummy/db/test.sqlite3 in active_metadata-0.6.9 vs spec/dummy/db/test.sqlite3 in active_metadata-0.7.0

- old
+ new

@@ -1,38 +1,30 @@ -SQLite format 3@ .%c.-"%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 "sch$#  21 -21 z&NFAApippoGarden2012-02-22 09:46:27.4766592012-02-22 09:46:27.476659FAApippoGarden2012-02-22 09:46:27.3811332012-02-22 09:46:27.381133FAApippoGarden2012-02-22 09:46:27.2248082012-02-22 09:46:27.224808FAApippoGarden2012-02-22 09:46:27.1669642012-02-22 09:46:27.166964FAApippoGarden2012-02-22 09:46:27.0954152012-02-22 09:46:27.095415FAApippoGarden2012-02-22 09:46:27.0380992012-02-22 09:46:27.038099FAApluAoAAAndrea2012-03-23 10:28:03.2000612012-03-23 10:28:03.200061?AAJohn2012-03-23 10:28:17.9326552012-03-23 10:28:17.932655 PPp"active_metadat,active_/active_met%?active_metadata_histories:7active_metadata_notes@ Cactive_metadata_attachments9 users users=active_metadata_watchersdocuments sections Mp(MG#AAnew section2012-03-23 10:28:04.8161492012-03-23 10:28:04.816149G#AAnew section2012-03-23 10:28:02.4719152012-03-23 10:28:02.471915G#AAnew section2012-03-23 10:27:55.6767772012-03-23 10:27:55.676777F#AAnew section}2012-03-23 09:23:31.3581822012-03-23 09:23:31.358182F#AAnew sectionl2012-03-23 09:23:28.6649182012-03-23 09:23:28.664918F#AAnew sectionE2012-03-23 09:23:22.7028092012-03-23 09:23:22.702809[My<; AA2012-03-23 09:18:59.4997132012-03-23 09:18:59.499713; AA2012-03-23 09:17:35.2843592012-03-23 09:17:35.284359; -AA2012-03-23 09:15:49.9722022012-03-23 09:15:49.972202X 5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.4931412012-02-22 09:46:27.493141X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.3931512012-02-22 09:46:27.393151X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.2390562012-02-22 09:46:27.239056X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.1790942012-02-22 09:46:27.179094X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.1080072012-02-22 09:46:27.108007X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.0483702012-02-22 09:46:27.048370X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:26.9420702012-02-22 09:46:26.942070X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:26.8946932012-02-22 09:46:26.894693;AA2012-02-22 09:46:26.0421872012-02-22 09:46! :Iq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexuniqq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=/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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)+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) pM7)+AAAsurname Documentpdf_test_1.pdfapplication/pdf/2012-03-23 10:28:17.541903f2012-03-23 10:28:17.5801562012-03-23 10:28:17.5801566)+AAAsurname Documentpdf_test_2.pdfapplication/pdf/2012-03-23 10:28:15.479419f2012-03-23 10:28:15.5230292012-03-23 10:28:15.523029 9)+AAAname -Documentpdf_test_2.pdfapplication/pdf/2012-03-23 10:28:17.661224f2012-03-23 10:28:17.6628562012-03-23 10:28:17.662856 8)+AAAname -Documentpdf_test_1.pdfapplication/pdf/2012-03-23 10:28:17.636077f2012-03-23 10:28:17.6381172012-03-23 10:28:17.638117 P\" '^> %AAsurname notesurnameDocument f2012-03-23 10:28:13.4682972012-03-23 10:28:13.468297U@ AAnote_2nameDocument -f2012-03-23 10:28:17.6753492012-03-23 10:28:17.675349U? AAnote_1nameDocument -f2012-03-23 10:28:17.6516602012-03-23 10:28:17.651660 - Document> Document@ Document? - > -@ -? - surname> name@ name? -A2012-03-23 10:28:13.468297>A2012-03-23 10:28:17.675349@A2012-03-23 10:28:17.651660? -A2012-03-23 10:28:17.5419037A2012-03-23 10:28:15.4794196A2012-03-23 10:28:17.6612249A2012-03-23 10:28:17.6360778 R\ +SQLite format 3@ 5V'c5V-"%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 "sch$#  21 +21 z&NFAApippoGarden2012-02-22 09:46:27.4766592012-02-22 09:46:27.476659FAApippoGarden2012-02-22 09:46:27.3811332012-02-22 09:46:27.381133FAApippoGarden2012-02-22 09:46:27.2248082012-02-22 09:46:27.224808FAApippoGarden2012-02-22 09:46:27.1669642012-02-22 09:46:27.166964FAApippoGarden2012-02-22 09:46:27.0954152012-02-22 09:46:27.095415FAApippoGarden2012-02-22 09:46:27.0380992012-02-22 09:46:27.038099FAApluA>AAAndrea2012-04-17 14:45:14.4276762012-04-17 14:45:14.427676?bAAJohn2012-04-17 14:45:30.0565272012-04-17 14:45:30.056527 [{["active_metadat,active_/active_met%+active?active_metadata_histories users87active_metadata_notes Cactive_metadata_attachments=active_metadata_watchersdocuments sections rp(MrG #AAnew section2012-04-17 14:45:16.0763142012-04-17 14:45:16.076314G#AAnew section2012-04-17 14:45:13.6776812012-04-17 14:45:13.677681G#AAnew section2012-04-17 14:45:07.2077762012-04-17 14:45:07.207776G#AAnew section2012-03-23 10:28:04.8161492012-03-23 10:28:04.816149G#AAnew section2012-03-23 10:28:02.4719152012-03-23 10:28:02.471915G#AAnew section2012-03-23 10:27:55.6767772012-03-23 10:27:55.676777F#AAnew section}2012-03-23 09:23:31.3581822012-03-23 09:23:31.358182F#AAnew sectionl2012-03-23 09:23:28.6649182012-03-23 09:23:28.664918F#AAnew sectionE2012-03-23 09:23:22.7028092012-03-23 09:23:22.702809'My<; AA2012-03-23 09:18:59.4997132012-03-23 09:18:59.499713; AA2012-03-23 09:17:35.2843592012-03-23 09:17:35.284359; +AA2012-03-23 09:15:49.9722022012-03-23 09:15:49.972202X 5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.4931412012-02-22 09:46:27.493141X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.3931512012-02-22 09:46:27.393151X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.2390562012-02-22 09:46:27.239056X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.1790942012-02-22 09:46:27.179094X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.1080072012-02-22 09:46:27.108007X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.0483702012-02-22 09:46:27.048370X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:26.9420702012-02-22 09:46:26.942070X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:26.8946932012-02-22 09:46:26.894693;AA2012-02-22 09:46:26.0421872012-0&7(! :Iq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexuniqq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=/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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)+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) OM)+AAAsurnameDocument4pdf_test_1.pdfapplication/pdf/2012-04-17 14:45:29.211332f2012-04-17 14:45:29.2547292012-04-17 14:45:29.254729 )+AAAnameDocument44pdf_test_1.pdfapplication/pdf/2012-04-17 14:45:29.702945t2012-04-17 14:45:29.6417852012-04-17 14:45:29.705140 )+AAAnameDocument4pdf_test_2.pdfapplication/pdf/2012-04-17 14:45:29.670170f2012-04-17 14:45:29.6720622012-04-17 14:45:29.672062)+AAAnameDocument4pdf_test_1.pdfapplication/pdf/2012-04-17 14:45:29.638984t2012-04-17 14:45:29.6417852012-04-17 14:45:29.641785 Pj7 AAAnot starred note for titletitl^L %AAsurname notesurnameDocument4f2012-04-17 14:45:25.1740742012-04-17 14:45:25.174074UT AAnote_2nameDocument4f2012-04-17 14:45:29.6867082012-04-17 14:45:29.686708US AAnote_1nameDocument4t2012-04-17 14:45:29.6575062012-04-17 14:45:29.657506 + Document Document Document + + surname name name +A2012-04-17 14:45:25.174074A2012-04-17 14:45:29.686708A2012-04-17 14:45:29.657506 +A2012-04-17 14:45:29.211332A2012-04-17 14:45:27.187500A2012-04-17 14:45:29.670170A2012-04-17 14:45:29.702945 R\ b dT AAGardensurnameDocument2012-02-22 09:46:27.1706162012-02-22 09:46:27.170616P - AApipponameDocument2012-02-22 09:46:27.1688862012-02-22 09:46:27.168886T AAGardensurnameDocument2012-02-22 09:46:27.0994762012-02-22 09:46:27.099476P AApipponameDocument2012-02-22 09:46:27.0976292012-02-22 09:46:27.097629T AAGardensurnameDocument2012-02-22 09:46:27.0415332012-02-22 09:46:27.041533P AApipponameDocument2012-02-22 09:46:27.0397772012-02-22 09:46:27.039777P AAplutonameDocument2012-02-22 09:46:26.9609062012-02-22 09:46:26.960906R AAname 2nameDocument2012-03-23 10:28:02.8567962012-03-23 10:28V" #AA247document_idDocument2012-03-23 10:28:04.8198052012-03-23 10:28:04.819805X! #AAnew sectiontitleDocument2012-03-23 10:28:04.8181402012-03-23 10:28:04.818140P: AAJohnnameDocument2012-03-23 10:28:17.9344032012-03-23 10:28:17.934403 + AApipponameDocument2012-02-22 09:46:27.1688862012-02-22 09:46:27.168886T AAGardensurnameDocument2012-02-22 09:46:27.0994762012-02-22 09:46:27.099476P AApipponameDocument2012-02-22 09:46:27.0976292012-02-22 09:46:27.097629T AAGardensurnameDocument2012-02-22 09:46:27.0415332012-02-22 09:46:27.041533P AApipponameDocument2012-02-22 09:46:27.0397772012-02-22 09:46:27.039777P AAplutonameDocument2012-02-22 09:46:26.9609062012-02-22 09:46:26.960906Rp AAname 2nameDocument42012-04-17 14:45:14.0636872012-04-17 14:45V #AA454document_idDocument42012-04-17 14:45:16.0812232012-04-17 14:45:16.081223X #AAnew sectiontitleDocument42012-04-17 14:45:16.0788082012-04-17 14:45:16.078808P AAJohnnameDocument42012-04-17 14:45:30.0581772012-04-17 14:45:30.058177 eF'mN/A2012-02-22 09:46:27.485379A2012-02-22 09:46:27.482309A2012-02-22 09:46:27.386359A2012-02-22 09:46:27.383560A2012-02-22 09:46:27.230465 A2012-02-22 09:46:27.227042 A2012-02-22 09:46:27.170616 A2012-02-22 09:46:27.168886 -A2012-02-22 09:46:27.099476 A2012-02-22 09:46:27.097629A2012-02-22 09:46:27.041533A2012-02-22 09:46:27.039777A2012-02-22 09:46:26.960A2012-03-23 10:28:02.856796A2012-03-23 10:28:04.819805"A2012-03-23 10:28:04.818140!A2012-03-23 10:28:17.934403: +A2012-02-22 09:46:27.099476 A2012-02-22 09:46:27.097629A2012-02-22 09:46:27.041533A2012-02-22 09:46:27.039777A2012-02-22 09:46:26.960A2012-04-17 14:45:14.063687A2012-04-17 14:45:16.081223A2012-04-17 14:45:16.078808A2012-04-17 14:45:30.058177 ~qdWJ=0# Document Document Document Document Document Document Document Document - Document Document Document Document Docum Document Document" Document! Document: h8JAA nameDocument2012-02-22 09:46:27.4984762012-02-22 09:46:27.498476JAAnameDocument2012-02-22 09:46:27.3987002012-02-22 09:46:27.398700JAAnameDocument2012-02-22 09:46:27.2453602012-02-22 09:46:27.245360JAAnameDocument2012-02-22 09:46:27.1847362012-02-22 09:46:27.184736JAAnameDocument2012-02-22 09:46:27.1150122012-02-22 09:46:27.115012JAAnameDocument2012-02-22 09:46:27.0534952012-02-22 09:46:27.053495JAAnameDocument2012-02-22 09:46:26.9506342012-02-22 09:46:26.95063KAAnameDocument 2012-03-23 10:28:17.8605882012-03-23 10:28:17.860588 MMM+@|CCtableactive_metadata_attachmentsactive_metadata_attachments CREATE TABLE "active_metadata_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)ZyCindexindex_active_metadata_attachments_on_attach_updated_atactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_attach_updated_at" ON "active_metadata_attachments" ("attach_updated_at")QsCyindexindex_active_metadata_attachments_on_document_classactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_class" ON "active_metadata_attachments" ("document_class") + Document Document Document Document Docum Document Document Document Document h8JAA nameDocument2012-02-22 09:46:27.4984762012-02-22 09:46:27.498476JAAnameDocument2012-02-22 09:46:27.3987002012-02-22 09:46:27.398700JAAnameDocument2012-02-22 09:46:27.2453602012-02-22 09:46:27.245360JAAnameDocument2012-02-22 09:46:27.1847362012-02-22 09:46:27.184736JAAnameDocument2012-02-22 09:46:27.1150122012-02-22 09:46:27.115012JAAnameDocument2012-02-22 09:46:27.0534952012-02-22 09:46:27.053495JAAnameDocument2012-02-22 09:46:26.9506342012-02-22 09:46:26.95063KAA7nameDocument2012-04-17 14:45:29.9809312012-04-17 14:45:29.980931 MMM+@|CCtableactive_metadata_attachmentsactive_metadata_attachments CREATE TABLE "active_metadata_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)ZyCindexindex_active_metadata_attachments_on_attach_updated_atactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_attach_updated_at" ON "active_metadata_attachments" ("attach_updated_at")QsCyindexindex_active_metadata_attachments_on_document_classactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_class" ON "active_metadata_attachments" ("document_class")     - "!: - Document7 Document6 Document9 Document8 -eF'A2012-02-22 09:46:27.498476A2012-02-22 09:46:27.398700A2012-02-22 09:46:27.245360A2012-02-22 09:46:27.184736A2012-02-22 09:46:27.115012A2012-02-22 09:46:27.053495A2012-02-22 09:46:26.950634A2012-03-23 10:28:17.860588 -  - 7 6 -9 -8 -namenamenamenamenamenamenamename -  PP!|CCtableactive_metadata_attachmentsactive_metadata_attachments CREATE TABLE "active_metadata_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)ZyCindexindex_active_metadata_attachments_on_attach_updated_atactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_attach_updated_at" ON "active_metadata_attachments" ("attach_updated_at")QsCyindexindex_active_metadataZ+!AAemail2@email.itGeorgeWashington2012-03-23 10:28:17.8536992012-03-23 10:28:17.853699R)AAemail@email.itJohnsmith2012-03-23 10:28:17.8467732012-03-23 10:28:17.846773 - |jCCtableactive_metadata_attachmentsactive_metadata_attachments CREATE TABLE "active_metadata_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)ZkyCindexindex_active_metadata_attachments_on_attach_updated_atactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_attach_updated_at" ON "active_metadata_attachments" ("attach_updated_at")QlsCyindexindex_active_metadata_attachments_on_document_classactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_class" ON "a surname7 surname6 name9 name8 <i[My<; AA2012-03-23 09:18:59.4997132012-03-23 09:18:59.499713; AA2012-03-23 09:17:35.2843592012-03-23 09:17:35.284359; +  + Document Document Document Document +eF'A2012-02-22 09:46:27.498476A2012-02-22 09:46:27.398700A2012-02-22 09:46:27.245360A2012-02-22 09:46:27.184736A2012-02-22 09:46:27.115012A2012-02-22 09:46:27.053495A2012-02-22 09:46:26.950634A2012-04-17 14:45:29.980931 + + +namenamenamenamenamenamenamename + 7 7P\h+t7;(AA2012-04-17 14:08:46.4417402012-04-17 14:08:46.441740;'AA2012-04-17 14:07:44.4658732012-04-17 14:07:44.465873;&AA2012-04-17 14:06:29.5554322012-04-17 14:06:29.555432;%AA2012-04-17 14:00:22.1601032012-04-17 14:00:22.160103;$AA2012-04-17 13:42:55.0948052012-04-17 13:42:55.094805;#AA2012-04-17 13:24:53.7531392012-04-17 13:24:53.753139;"AA2012-04-17 13:07:30.2956412012-04-17 13:07:30.295641;!AA2012-04-17 13:04:50.0133722012-04-17 13:04:50.013372; AA2012-04-17 13:03:42.3839142012-04-17 13:03:42.383914;AA2012-04-17 13:03:16.6255892012-04-17 13:03:16.625589;AA2012-04-17 12:57:22.7755042012-04-17 12:57:22.775504;AA2012-04-17 12:56:38.6900372012-04-17 12:56:38.690037;AA2012-04-17 12:54:31.8711272012-04-17 12:54:31.871127Z+!AAemail2@email.itGeorgeWashington2012-03-23 10:28:17.8536992012-03-23 10:28:17.853699R)AAemail@email.itJohnsmith2012-03-23 10:28:17.8467732012-03-23 10:28:17.846773 + |jCCtableactive_metadata_attachmentsactive_metadata_attachments CREATE TABLE "active_metadata_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)ZkyCindexindex_active_metadata_attachments_on_attach_updated_atactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_attach_updated_at" ON "active_metadata_attachments" ("attach_updated_at")QlsCyindexindex_active_metadata_attachments_on_document_classactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_class" ON "a surname surname name name <i[My<; AA2012-03-23 09:18:59.4997132012-03-23 09:18:59.499713; AA2012-03-23 09:17:35.2843592012-03-23 09:17:35.284359; AA2012-03-23 09:15:49.9722022012-03-23 09:15:49.972202X 5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.4931412012-02-22 09:46:27.493141X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.3931512012-02-22 09:46:27.393151X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.2390562012-02-22 09:46:27.239056X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.1790942012-02-22 09:46:27.179094X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.1080072012-02-22 09:46:27.108007X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:27.0483702012-02-22 09:46:27.048370X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:26.9420702012-02-22 09:46:26.942070X5AAfg@fractalgarden.comJohnsmith2012-02-22 09:46:26.8946932012-02-22 09:46:26.894693;AA2012-02-22 09:46:26.0421872012-02-22 09:46:26.042187 TT!Io?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class")@ i?eindexindex_active_metadata_histories_on_document_idactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_id" ON "active_metadata_histories" ("document_id"). ]?Mindexindex_active_metadata_histories_on_labelactive_metadata_histories"CREATE INDEX "index_active_metadata_histories_on_label" ON "active_metadata_histories" ("label")e 77itableactive_metadata_notesactive_metadata_notes CREATE TABLE "active_metadata_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) ll8?HmCmindexindex_active_metadata_attachments_on_document_idactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_id" ON "active_metadata_attachments" ("document_id")6aCUindexindex_active_metadata_attachments_on_labelactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_label" ON "active_metadata_attachments" ("label")I??!tableactive_metadata_historiesactive_metadata_historiesCREATE TABLE "active_metadata_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)=g?aindexindex_active_metadata_histories_on_created_atactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_created_at" ON "active_metadata_histories" ("created_at") UIMw:UR)AAemail@email.itJohnsmith2012-03-23 10:28:17.7876332012-03-23 10:28:17.787633R)AAemail@email.itJohnsmith2012-03-23 10:28:17.7236672012-03-23 10:28:17.723667;AA2012-03-23 10:27:51.9519332012-03-23 10:27:51.951933;AA2012-03-23 09:31:06.6382232012-03-23 09:31:06.638223;AA2012-03-23 09:30:04.4619602012-03-23 09:30:04.461960;AA2012-03-23 09:28:56.2388002012-03-23 09:28:56.238800Z+!AAemail2@email.itGeorgeWashington2012-03-23 09:23:44.6242462012-03-23 09:23:44.624246R)AAemail@email.itJohnsmith2012-03-23 09:23:44.6179932012-03-23 09:23:44.617993R)AAemail@email.itJohnsmith2012-03-23 09:23:44.5586072012-03-23 09:23:44.558607R)AAemail@email.itJohnsmith2012-03-23 09:23:44.4942402012-03-23 09:23:44.494240;AA2012-03-23 09:23:19.7736892012-03-23 09:23:19.773689;AA2012-03-23 09:22:57.7062042012-03-23 09:22:57.706204; AA2012-03-23 09:21:33.4019532012-03-23 09:21:33.401953 p[ydOIqo?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class")@ri?eindexindex_active_metadata_histories_on_document_idactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_id" ON "active_metadata_histories" ("document_id").s]?Mindexindex_active_metadata_histories_on_labelactive_metadata_histories CREATE INDEX "index_active_metadata_histories_on_label" ON "active_metadata_histories" ("label")et77itableactive_metadata_notesactive_metadata_notes CREATE TABLE "active_metadata_notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note" text, "label" varchar(255), "do surnamename surnamename surname name surname name - surname name surnamenamename  #document_id" -title! name: <<O<|CIo?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class")@ i?eindexindex_activ9 g7aindexindex_active_metadata_notes_on_document_classactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_class" ON "active_metadata_notes" ("document_class")0 a7Uindexindex_active_metadata_notes_on_document_idactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_id" ON "active_metadata_notes" ("document_id")U7=indexindex_active_metadata_notes_on_labelactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_label" ON "active_metadata_notes" ("label")-_7Qindexindex_active_metadata_notes_on_updated_atactive_metadata_notesCREATE INDEX "index_active_metadata_notes_on_updated_at" ON "active_metadata_notes" ("updated_at") R|CIo?qindexindex_active_metadata_histories_on_document_classactive6==tableactive_metadata_watchersactive_metadata_watchersCREATE TABLE "active_metadata_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)9e=]indexindex_active_metadata_watchers_on_created_atactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_created_at" ON "active_metadata_watchers" ("created_at")<g=aindexindex_active_metadata_watchers_on_document_idactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_document_id" ON "active_metadata_watchers" ("document_id")*[=Iindexindex_active_metadata_watchers_on_labelactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_label" ON "active_metadata_watchers" ("label") O?QsIo?qindexindex_active_metadata_histories_U7=indexinde3a=Uindexindex_active_metadata_watchers_on_owner_idactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_owner_id" ON "active_metadata_watchers" ("owner_id")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)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)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) + surname name surnamenamename  #document_id +title name <<O<|CIo?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class")@ i?eindexindex_activ9 g7aindexindex_active_metadata_notes_on_document_classactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_class" ON "active_metadata_notes" ("document_class")0 a7Uindexindex_active_metadata_notes_on_document_idactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_id" ON "active_metadata_notes" ("document_id")U7=indexindex_active_metadata_notes_on_labelactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_label" ON "active_metadata_notes" ("label")-_7Qindexindex_active_metadata_notes_on_updated_atactive_metadata_notesCREATE INDEX "index_active_metadata_notes_on_updated_at" ON "active_metadata_notes" ("updated_at") R|CIo?qindexindex_active_metadata_histories_on_document_classactive6==tableactive_metadata_watchersactive_metadata_watchersCREATE TABLE "active_metadata_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)9e=]indexindex_active_metadata_watchers_on_created_atactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_created_at" ON "active_metadata_watchers" ("created_at")<g=aindexindex_active_metadata_watchers_on_document_idactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_document_id" ON "active_metadata_watchers" ("document_id")*[=Iindexindex_active_metadata_watchers_on_labelactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_label" ON "active_metadata_watchers" ("label") O?QsIo?qindexindex_active_metadata_histories_U7=indexinde3a=Uindexindex_active_metadata_watchers_on_owner_idactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_owner_id" ON "active_metadata_watchers" ("owner_id")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)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)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) (I Ua$|(R7)AAemail@email.itJohnsmith2012-04-17 14:45:29.9497012012-04-17 14:45:29.949701R6)AAemail@email.itJohnsmith2012-04-17 14:45:29.8284462012-04-17 14:45:29.828446R5)AAemail@email.itJohnsmith2012-04-17 14:45:29.7610552012-04-17 14:45:29.761055;4AA2012-04-17 14:45:02.4107692012-04-17 14:45:02.410769;3AA2012-04-17 14:44:39.1166362012-04-17 14:44:39.116636;2AA2012-04-17 14:35:17.4193942012-04-17 14:35:17.419394;1AA2012-04-17 14:32:27.3536562012-04-17 14:32:27.353656;0AA2012-04-17 14:29:46.0254472012-04-17 14:29:46.025447;/AA2012-04-17 14:26:57.3112142012-04-17 14:26:57.311214;.AA2012-04-17 14:26:43.0250872012-04-17 14:26:43.025087;-AA2012-04-17 14:26:07.5579942012-04-17 14:26:07.557994;,AA2012-04-17 14:25:27.4850162012-04-17 14:25:27.485016;+AA2012-04-17 14:16:24.9285372012-04-17 14:16:24.928537;*AA2012-04-17 14:10:13.9732082012-04-17 14:10:13.973208;)AA2012-04-17 14:09:42.2189242012-04-17 14:09:42.218924 Z8+!AAemail2@email.itGeorgeWashington2012-04-17 14:45:29.9561002012-04-17 14:45:29.956100 \ No newline at end of file