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 |&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.038099FAAplutoAuAAAndrea2012-03-23 09:23:29.4461322012-03-23 09:23:29.44613?3AAJohn2012-03-23 09:31:18.3156442012-03-23 09:31:18.315644 PPp"active_metadat,active_/active_met%?active_metadata_histories7active_metadata_notes Cactive_metadata_attachments=active_metadata_watchers usersdocuments sections users (p(F#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:26.0 :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) pM~)+AAAsurnameDocumentpdf_test_1.pdfapplication/pdf/2012-03-23 09:31:18.233918f2012-03-23 09:31:18.2735702012-03-23 09:31:18.273570})+AAAsurnameDocumentpdf_test_2.pdfapplication/pdf/2012-03-23 09:31:16.178141f2012-03-23 09:31:16.2163332012-03-23 09:31:16.216333 )+AAAnameDocumentpdf_test_2.pdfapplication/pdf/2012-03-23 09:31:18.358629f2012-03-23 09:31:18.3605802012-03-23 09:31:18.360580 )+AAAnameDocumentpdf_test_1.pdfapplication/pdf/2012-03-23 09:31:18.329265f2012-03-23 09:31:18.3311592012-03-23 09:31:18.331159 PP\ '^z %AAsurname notesurnameDocumentf2012-03-23 09:31:14.1433152012-03-23 09:31:14.143315U| AAnote_2nameDocumentf2012-03-23 09:31:18.3758622012-03-23 09:31:18.375862U{ AAnote_1nameDocumentf2012-03-23 09:31:18.3470352012-03-23 09:31:18.347035  Document Document Document   surname name name A2012-03-23 09:31:14.143315A2012-03-23 09:31:18.375862A2012-03-23 09:31:18.347035 A2012-03-23 09:31:18.233918A2012-03-23 09:31:16.178141A2012-03-23 09:31:18.358629A2012-03-23 09:31:18.329265 T\ 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.960906T Q AAname 2nameDocumentm2012-03-23 09:23:29.0491492012-03-23 09:23U #AA125document_idDocument}2012-03-23 09:23:31.3619582012-03-23 09:23:31.361958W #AAnew sectiontitleDocument}2012-03-23 09:23:31.3604062012-03-23 09:23:31.36040PM AAJohnnameDocument2012-03-23 09:31:18.3176092012-03-23 09:31:18.317609 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 09:23:29.049149A2012-03-23 09:23:31.361958A2012-03-23 09:23:31.360406A2012-03-23 09:31:18.317609 ~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.95063K AAnameDocument2012-03-23 09:23:44.6312912012-03-23 09:23:44.631291 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")      m}}  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-03-23 09:23:44.631291   namenamenamenamenamenamenamename   !!|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")  |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") :IMw:;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)