SQLite format 3@  8- - D rF)CC+tableactive_metadata_attachmentsactive_metadata_attachmentsCREATE 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, "group" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)I(o?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class")='g?aindexindex_active_metadata_histories_on_created_atactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_created_at" ON "active_metadata_histories" ("created_at").&]?Mindexindex_active_metadata_histories_on_labelactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_label" ON "active_metadata_histories" ("label")@%i?eindexindex_active_metadata_histories_on_document_idactive_metadata_histories CREATE INDEX "index_active_metadata_histories_on_document_id" ON "active_metadata_histories" ("document_id")I$??!tableactive_metadata_historiesactive_metadata_histories CREATE 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)9#g7aindexindex_active_metadata_notes_on_document_classactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_class" ON "active_metadata_notes" ("document_class")-"_7Qindexindex_active_metadata_notes_on_updated_atactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_updated_at" ON "active_metadata_notes" ("updated_at")!U7=indexindex_active_metadata_notes_on_labelactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_label" ON "active_metadata_notes" ("label")0 a7Uindexindex_active_metadata_notes_on_document_idactive_metadata_notesCREATE INDEX "index_active_metadata_notes_on_document_id" ON "active_metadata_notes" ("document_id"){77tableactive_metadata_notesactive_metadata_notesCREATE 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, "group" varchar(255), "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)<KtablechapterschaptersCREATE TABLE "chapters" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "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)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" varchar(255) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name" zA3AAAndrea2012-05-03 15:35:05.8223982012-05-03 15:35:05.822398?WAAJohn2012-05-03 15:35:20.6522362012-05-03 15:35:20.652236 ;;[}active_metadata_watchers?active_metadata_histories Cactive_metadata_attachmentsN chapters usersdocumentsW=active_metadata_watchers usersi7active_metadata_notesh sections  o&K p ' L  q ( G#AAnew section;2012-05-03 15:35:07.2618032012-05-03 15:35:07.261803G#AAnew section*2012-05-03 15:35:05.1612932012-05-03 15:35:05.161293G#AAnew section2012-05-03 15:34:59.5038802012-05-03 15:34:59.503880G#AAnew section2012-05-03 10:29:48.8953802012-05-03 10:29:48.895380G#AAnew section2012-05-03 10:29:46.8662882012-05-03 10:29:46.866288G #AAnew section2012-05-03 10:29:41.0207222012-05-03 10:29:41.020722G #AAnew section2012-05-03 08:49:51.2162142012-05-03 08:49:51.216214G #AAnew section2012-05-03 08:49:49.2273382012-05-03 08:49:49.227338G #AAnew section2012-05-03 08:49:43.8897792012-05-03 08:49:43.889779G #AAnew section2012-04-27 17:18:25.6077912012-04-27 17:18:25.607791G#AAnew sectiont2012-04-27 17:18:22.2288962012-04-27 17:18:22.228896G#AAnew sectionJ2012-04-27 17:18:15.0414702012-04-27 17:18:15.041470G#AAnew section!2012-04-27 17:16:25.6650322012-04-27 17:16:25.665032G#AAnew section2012-04-27 17:16:23.4475302012-04-27 17:16:23.447530G#AAnew section2012-04-27 17:16:15.7349652012-04-27 17:16:15.734965G#AAnew section2012-04-27 17:12:11.5155822012-04-27 17:12:11.515582G#AAnew section2012-04-27 17:12:08.9390652012-04-27 17:12:08.939065F#AAnew section2012-04-27 17:12:01.8165882012-04-27 17:12:01.816588 @@@ @ @ @ @ @ @>AACool!2012-05-03 15:34:59.2724312012-05-03 15:34:59.272431>AACool!2012-05-03 15:34:57.8801182012-05-03 15:34:57.880118>AACool!2012-05-03 10:29:40.8353892012-05-03 10:29:40.835389>AACool!2012-05-03 10:29:40.6658672012-05-03 10:29:40.665867>AACool!2012-05-03 09:14:41.7501512012-05-03 09:14:41.750151>AACool!2012-05-03 09:14:41.6273152012-05-03 09:14:41.627315>AACool!2012-05-03 09:14:21.1210892012-05-03 09:14:21.121089>AACool!2012-05-03 09:14:21.0146632012-05-03 09:14:21.014663>AACool!2012-05-03 09:13:38.6130942012-05-03 09:13:38.613094>AACool!2012-05-03 09:13:38.4861812012-05-03 09:13:38.486181>AACool!2012-05-03 09:13:20.2359732012-05-03 09:13:20.235973>AACool!2012-05-03 09:13:20.1165472012-05-03 09:13:20.116547>AACool!2012-05-03 09:12:38.9195912012-05-03 09:12:38.919591>AACool!2012-05-03 09:12:38.8052542012-05-03 09:12:38.805254>AACool!2012-05-03 09:11:16.3754132012-05-03 09:11:16.375413>AACool!2012-05-03 09:11:16.2628492012-05-03 09:11:16.262849>AACool!2012-05-03 09:10:58.1820952012-05-03 09:10:58.182095>AACool!2012-05-03 09:10:58.0691732012-05-03 09:10:58.069173> AACool!2012-05-03 09:08:10.8660812012-05-03 09:08:10.866081> AACool!2012-05-03 09:08:10.7337502012-05-03 09:08:10.733750> AACool!2012-05-03 09:06:43.5985502012-05-03 09:06:43.598550> AACool!2012-05-03 09:06:23.2171752012-05-03 09:06:23.217175> AACool!2012-05-03 09:05:46.2747722012-05-03 09:05:46.274772>AACool!2012-05-03 09:02:00.6363912012-05-03 09:02:00.636391>AACool!2012-05-03 09:01:49.9011502012-05-03 09:01:49.901150>AACool!2012-05-03 08:59:26.6429732012-05-03 08:59:26.642973>AACool!2012-05-03 08:49:43.6302922012-05-03 08:49:43.630292>AACool!2012-04-27 17:18:14.7951462012-04-27 17:18:14.795146>AACool!2012-04-27 17:16:15.4673232012-04-27 17:16:15.467323>AACool!2012-04-27 17:12:01.5388742012-04-27 17:12:01.538874>AACool!2012-04-27 16:12:10.6375912012-04-27 16:12:10.637591  U a $ m 0 y < H T 2E:6Qdh U;:AA2012-05-03 09:06:42.5782982012-05-03 09:06:42.578298;9AA2012-05-03 09:06:22.2134222012-05-03 09:06:22.213422;8AA2012-05-03 09:05:45.1453992012-05-03 09:05:45.145399;7AA2012-05-03 09:01:59.6015322012-05-03 09:01:59.601532;6AA2012-05-03 09:01:49.2116732012-05-03 09:01:49.211673;5AA2012-05-03 08:59:25.7798522012-05-03 08:59:25.779852Z4+!AAemail2@email.itGeorgeWashington2012-05-03 08:50:04.3590102012-05-03 08:50:04.359010R3)AAemail@email.itJohnsmith2012-05-03 08:50:04.3547272012-05-03 08:50:04.354727R2)AAemail@email.itJohnsmith2012-05-03 08:50:04.3168502012-05-03 08:50:04.316850R1)AAemail@email.itJohnsmith2012-05-03 08:50:04.2723312012-05-03 08:50:04.272331;0AA2012-05-03 08:49:40.8932002012-05-03 08:49:40.893200Z/+!AAemail2@email.itGeorgeWashington2012-04-27 17:18:39.6592082012-04-27 17:18:39.659208R.)AAemail@email.itJohnsmith2012-04-27 17:18:39.6550802012-04-27 17:18:39.655080R-)AAemail@email.itJohnsmith2012-04-27 17:18:39.6125252012-04-27 17:18:39.612525R,)AAemail@email.itJohnsmith2012-04-27 17:18:39.4838682012-04-27 17:18:39.483868;+AA2012-04-27 17:18:12.8275062012-04-27 17:18:12.827506Z*+!AAemail2@email.itGeorgeWashington2012-04-27 17:16:39.9371252012-04-27 17:16:39.937125R))AAemail@email.itJohnsmith2012-04-27 17:16:39.9330282012-04-27 17:16:39.933028R()AAemail@email.itJohnsmith2012-04-27 17:16:39.8848772012-04-27 17:16:39.884877R')AAemail@email.itJohnsmith2012-04-27 17:16:39.8356082012-04-27 17:16:39.835608;&AA2012-04-27 17:16:13.3152452012-04-27 17:16:13.315245;%AA2012-04-27 17:16:02.9892812012-04-27 17:16:02.989281;$AA2012-04-27 17:14:59.7416332012-04-27 17:14:59.741633;#AA2012-04-27 17:13:58.1036512012-04-27 17:13:58.103651Z"+!AAemail2@email.itGeorgeWashington2012-04-27 17:12:25.2851672012-04-27 17:12:25.285167R!)AAemail@email.itJohnsmith2012-04-27 17:12:25.2816392012-04-27 17:12:25.281639R )AAemail@email.itJohnsmith2012-04-27 17:12:25.2172462012-04-27 17:12:25.217246R)AAemail@email.itJohnsmith2012-04-27 17:12:25.1559152012-04-27 17:12:25.155915;AA2012-04-27 17:11:59.5233492012-04-27 17:11:59.523349;AA2012-04-27 17:11:35.2876582012-04-27 17:11:35.287658;AA2012-04-27 17:10:40.4177322012-04-27 17:10:40.417732;AA2012-04-27 17:09:08.0835542012-04-27 17:09:08.083554;AA2012-04-27 17:07:58.0650132012-04-27 17:07:58.065013;AA2012-04-27 17:07:22.8165082012-04-27 17:07:22.816508;AA2012-04-27 17:06:57.4026132012-04-27 17:06:57.402613;AA2012-04-27 17:06:37.4529772012-04-27 17:06:37.452977;AA2012-04-27 17:04:18.6178462012-04-27 17:04:18.617846;AA2012-04-27 17:03:12.2965462012-04-27 17:03:12.296546;AA2012-04-27 17:02:11.3965322012-04-27 17:02:11.396532;AA2012-04-27 17:01:34.5084082012-04-27 17:01:34.508408;AA2012-04-27 16:59:50.2859972012-04-27 16:59:50.285997;AA2012-04-27 16:58:01.3662512012-04-27 16:58:01.366251;AA2012-04-27 16:54:00.6785842012-04-27 16:54:00.678584;AA2012-04-27 16:53:10.7622182012-04-27 16:53:10.762218;AA2012-04-27 16:52:56.9657612012-04-27 16:52:56.965761; AA2012-04-27 16:51:54.5754912012-04-27 16:51:54.575491; AA2012-04-27 16:44:02.7997182012-04-27 16:44:02.799718; AA2012-04-27 16:43:50.8178982012-04-27 16:43:50.817898; AA2012-04-27 16:42:19.3944812012-04-27 16:42:19.394481; AA2012-04-27 16:38:25.3994612012-04-27 16:38:25.399461;AA2012-04-27 16:31:08.1598852012-04-27 16:31:08.159885;AA2012-04-27 16:30:45.2567192012-04-27 16:30:45.256719;AA2012-04-27 16:30:11.5209242012-04-27 16:30:11.520924;AA2012-04-27 16:29:49.9968212012-04-27 16:29:49.996821;AA2012-04-27 16:26:43.1755332012-04-27 16:26:43.175533;AA2012-04-27 16:18:34.1940372012-04-27 16:18:34.194037;AA2012-04-27 16:18:27.5620802012-04-27 16:18:27.562080;AA2012-04-27 16:12:09.9057812012-04-27 16:12:09.9: >K oO 7!AAstarred note for namenameDocumentGetyour_group2012-05-03 15:35:10.8901022012-05-03 15:35:10.890102oN 7!AAstarred note for namenameDocumentGefyour_group2012-05-03 15:35:10.8781122012-05-03 15:35:10.878112fM )AAto be returnednameDocumentGetmy_` %AAsurname notesurnameDocumentNef2012-05-03 15:35:15.7950562012-05-03^h AAnote_2nameDocumentRefmy_group2012-05-03 15:35:20.4758852012-05-03 15:35:20.475885^g AAnote_1nameDocumentRetmy_group2012-05-03 15:35:20.4444482012-05-03 15:35:20.444448 GOGNN`RhRg  nameO name surname` nameh nameg `A2012-05-03 15:35:10.890102OA2012-05-03 15:35:10.878112NA2012-05-03 15:35:15.795056`A2012-05-03 15:35:20.475885hA2012-05-03 15:35:20.444448g  DocumentO DocumentN Document` Documenth Documentg RR. AAname 2nameDocument+e2012-05-03 15:35:05.5373502012-05-03 15:35V@ #AA827document_idDocument;e2012-05-03 15:35:07.2665822012-05-03 15:35:07.266582X? #AAnew sectiontitleDocument;e2012-05-03 15:35:07.2643932012-05-03 15:35:07.264393P\ AAJohnnameDocumentWe2012-05-03 15:35:20.6539092012-05-03 15:35:20.653909 +;;W  #document_id title name A2012-05-03 15:35:05.537350A2012-05-03 15:35:07.266582A2012-05-03 15:35:07.264393A2012-05-03 15:35:20.653909  Document Document Document Document h gJ 3%+A!AAnameDocumentepdf_test.pdfapplication/pdf/2012-05-03 15:35:02.111358tyour_group2012-05-03 15:35:02.1126082012-05-03 15:35:02.1126082%+A!AAnF)+AAAsurnameNDocumentepdf_test_1.pdfapplication/pdf/2012-05-03 15:35:19.830273f2012-05-03 15:35:19.8318862012-05-03 15:35:19.831886E)+AAAsurnameNDocumentepdf_test_2.pdfapplication/pdf/2012-05-03 15:35:17.810122f2012-05-03 15:35:17.8118222012-05-03N)+AAAnameRDocumentepdf_test_2.pdfapplication/pdf/2012-05-03 15:35:20.463398fmy_group2012-05-03 15:35:20.4646482012-05-03 15:35:20.464648M)+AAAnameRDocumentepdf_test_1.pdfapplication/pdf/2012-05-03 15:35:20.430953tmy_group2012-05-03 15:35:20.4323992012-05-03 15:35:20.432399 3NFNERNRM   ~ PF)CC+tableactive_metadata_attachmentsactive_metadata_attachmentsCREATE TA)CC+tableactive_metadata_attachmentsactive_metadata_attachmentsCREATE 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, "group" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)I(o?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class")='g?aindexindex_active_metadata_histories_on_created_atactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_created_at" ON "active_metadata_histories" ("created_at").&]?Mindexindex_active_metadata_histories_on_labelactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_label" ON "active_metadata_histories" ("label")@%i?eindexindex_active_metadata_histories_on_document_idactive_metadata_histories CREATE INDEX "index_active_metadata_histories_on_document_id" ON "active_metadata_histories" ("document_id")I$??!tableactive_metadata_historiesactive_metadata_histories CREATE 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)9#g7aindexindex_active_metadata_notes_on_document_classactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_class" ON "active_metadata_notes" ("document_class")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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)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)<KtablechapterschaptersCREATE TABLE "chapters" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "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){77tableactive_metadata_notesactive_metadata_notesCREATE 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, "group" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)0 a7Uindexindex_active_metadata_notes_on_document_idactive_metadata_notesCREATE 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_notes CREATE INDEX "index_active_metadata_notes_on_updated_at" ON "active_metadata_notes" ("updated_at")  T 5_u S92e=]indexindex_active_metadata_watchers_on_created_atactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_created_at" ON "active_metadata_watchers" ("created_at")31a=Uindexindex_active_metadata_watchers_on_owner_idactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_owner_id" ON "active_metadata_watchers" ("owner_id")*0[=Iindexindex_active_metadata_watchers_on_labelactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_label" ON "active_metadata_watchers" ("label")AA2012-05-03 09:12:37.8119942012-05-03 09:12:37.811994;=AA2012-05-03 09:11:15.2417072012-05-03 09:11:15.241707;<AA2012-05-03 09:10:56.9284882012-05-03 09:10:56.928488;;AA2012-05-03 09:08:09.7001512012-05-03 09:08:09.700151