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 zAjAAAndrea2012-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+PG #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 section2012-01-31 14:40:13.5591542012-01-31 14:40:13.559154G #AAnew section2012-01-31 14:40:13.2865432012-01-31 14:40:13.286543G #AAnew section2012-01-31 11:01:56.3890802012-01-31 11:01:56.389080G#AAnew section2012-01-31 11:01:43.6991472012-01-31 11:01:43.699147G#AAnew section2012-01-31 11:01:42.7140162012-01-31 11:01:42.714016G#AAnew section2012-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.2ER )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_idnotes CREATE INDEX "index_notes_on_document_id" ON "notes" ("document_id")] 5}indexindex_notes_on_labelnotes CREATE 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")y G!indexindex_notes_on_document_classnotesCREATE INDEX "index_notes_on_document_class" ON "notes" ("document_class") PP\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^ RR 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 `cL##_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")    surname surname 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") KAAnameDocument2012-01-31 14:49:43.0633872012-01-31 14:49:43.063387  name  A2012-01-31 14:49:43.063387 Eok.2ER )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 Pp(Ot+PG #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 section2012-01-31 14:40:13.5591542012-01-31 14:40:13.559154G #AAnew section2012-01-31 14:40:13.2865432012-01-31 14:40:13.286543G #AAnew section2012-01-31 11:01:56.3890802012-01-31 11:01:56.389080G#AAnew section2012-01-31 11:01:43.6991472012-01-31 11:01:43.699147G#AAnew section2012-01-31 11:01:42.7140162012-01-31 11:01:42.714016G#AAnew section2012-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