db/development.sqlite3 in active_metadata-0.1.9 vs db/development.sqlite3 in active_metadata-0.2.0

- old
+ new

@@ -1,25 +1,14 @@ -SQLite format 3@  - & O - Ily"8H2vA#indexindex_attachments_on_labelattachmentsCREATE INDEX "index_attachments_on_label" ON "attachments" ("label")M#-indexindex_attachments_on_document_idattachmentsCREATE INDEX "index_attachments_on_document_id" ON "attachments" ("document_id")##WtableattachmentsattachmentsCREATE TABLE "attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "document_id" integer, "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, "created_at" datetime, "updated_at" datetime)yEindexindex_watchers_on_created_atwatchersCREATE INDEX "index_watchers_on_created_at" ON "watchers" ("created_at")sAindexindex_watchers_on_owner_idwatchersCREATE INDEX "index_watchers_on_owner_id" ON "watchers" ("owner_id")j; indexindex_watchers_on_labelwatchersCREATE INDEX "index_watchers_on_label" ON "watchers" ("label")|G!indexindex_watchers_on_document_idwatchersCREATE INDEX "index_watchers_on_document_id" ON "watchers" ("document_id")U}tablewatcherswatchersCREATE TABLE "watchers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)}G!indexindex_histories_on_created_athistoriesCREATE INDEX "index_histories_on_created_at" ON "histories" ("created_at")n= indexindex_histories_on_labelhistoriesCREATE INDEX "index_histories_on_label" ON "histories" ("label")I%indexindex_histories_on_document_idhistoriesCREATE INDEX "index_histories_on_document_id" ON "histories" ("document_id")Z tablehistorieshistoriesCREATE TABLE "histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar(255), "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)m ?indexindex_notes_on_updated_atnotes CREATE INDEX "index_notes_on_updated_at" ON "notes" ("updated_at")] 5}indexindex_notes_on_labelnotes CREATE INDEX "index_notes_on_label" ON "notes" ("label")p -Aindexindex_notes_on_document_idnotes CREATE INDEX "index_notes_on_document_id" ON "notes" ("document_id")y Qtablenotesnotes -CREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note" varchar(255), "label" varchar(255), "document_id" integer, "created_by" integer, "updated_by" integer, "created_at" datetime, "updated_at" datetime)O))Ytablealert_messagesalert_messages CREATE TABLE "alert_messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "model_class" varchar(255), "model_id" integer, "alert_type" varchar(255), "old_value" text, "new_value" text, "inbox_id" integer, "read" boolean, "created_at" datetime, "updated_at" datetime)vCtableinboxesinboxesCREATE TABLE "inboxes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer)TtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "firstname" varchar(255), "lastname" varchar(255), "created_at" datetime, "updated_at" datetime)AUtablesectionssectionsCREATE TABLE "sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)DWtabledocumentsdocumentsCREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "surname" varchar(255))=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT   11 -10 987654321 - 11 10 -9 87654321        - - -  - - -  - - - -  - - - # yli 0 -F  Uyy"8H2vA#indexindex_attachments_on_labelattachmentsCREATE INDEX "indevA#indexindex_attachments_on_labelattachmentsCREATE INDEX "index_attachments_on_label" ON "attachments" ("label")M#-indexindex_attachments_on_document_idattachmentsCREATE INDEX "index_attachments_on_document_id" ON "attachments" ("document_id")##WtableattachmentsattachmentsCREATE TABLE "attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "document_id" integer, "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, "created_at" datetime, "updated_at" datetime)yEindexindex_watchers_on_created_atwatchersCREATE INDEX "index_watchers_on_created_at" ON "watchers" ("created_at")sAindexindex_watchers_on_owner_idwatchersCREATE INDEX "index_watchers_on_owner_id" ON "watchers" ("owner_id")j; indexindex_watchers_on_labelwatchersCREATE INDEX "index_watchers_on_label" ON "watchers" ("label")|G!indexindex_watchers_on_document_idwatchersCREATE INDEX "index_watchers_on_document_id" ON "watchers" ("document_id")U}tablewatcherswatchersCREATE TABLE "watchers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)}G!indexindex_histories_on_created_athistoriesCREATE INDEX "index_histories_on_created_at" ON "histories" ("created_at")p /tablehistorieshistoriesCREATE TABLE "histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar(255), "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime, "created_by" integer)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")DWtabledocumentsdocumentsCREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "surname" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)AUtablesectionssectionsCREATE TABLE "sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)TtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "firstname" varchar(255), "lastname" varchar(255), "created_at" datetime, "updated_at" datetime)vCtableinboxesinboxesCREATE TABLE "inboxes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer)O))Ytablealert_messagesalert_messages CREATE TABLE "alert_messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "model_class" varchar(255), "model_id" integer, "alert_type" varchar(255), "old_value" text, "new_value" text, "inbox_id" integer, "read" boolean, "created_at" datetime, "updated_at" datetime)y Qtablenotesnotes -CREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note" varchar(255), "label" varchar(255), "document_id" integer, "created_by" integer, "updated_by" integer, "created_at" datetime, "updated_at" datetime)p -Aindexindex_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")tablehistorieshistoriesCREATE TABLE "histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar(255), "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)  4 -# - y Z `cI%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")U}tablewatcherswatchersCREATE TABLE "watchers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)|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")yEindexindex_watchers_on_created_atwatchersCREATE INDEX "index_watchers_on_created_at" ON "watchers" ("created_at")##WtableattachmentsattachmentsCREATE TABLE "attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "document_id" integer, "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, "created_at" datetime, "updated_at" datetime)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") +SQLite format 3@  -"AUtablesectionssectionsCREATE TABLE "sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)DWtabledocumentsdocumentsCREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "surname" varchar(255))=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar   987645321 + 9 87645321     OOLe)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")DWtabledocumentsdocumentsCREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "surname" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)AUtablesectionssectionsCREATE TABLE "sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)Ttableusersusers +CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "firstname" varchar(255), "lastname" varchar(255), "created_at" datetime, "updated_at" datetime) 0vCtableinboxesinboxesCREATE TABLE "inboxes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOTvCtableinboxesinboxesCREATE TABLE "inboxes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer)_ ))ytablealert_messagesalert_messages CREATE TABLE "alert_messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "model_class" varchar(255), "model_id" integer, "alert_type" varchar(255), "old_value" varchar(255), "new_value" varchar(255), "content" text, "inbox_id" integer, "created_at" datetime, "updated_at" datetime)y +Qtablenotesnotes CREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note" varchar(255), "label" varchar(255), "document_id" integer, "created_by" integer, "updated_by" integer, "created_at" datetime, "updated_at" datetime)p Aindexindex_notes_on_document_idnotes CREATE INDEX "index_notes_on_document_id" ON "notes" ("document_id")    + + + bb0 (qmm ?indexindex_notes_on_updated_atnotesCREATE INDEX "index_notes_on_updated_at" ON "notes" ("updated_at")ZtablehistorieshistoriesCREATE TABLE "histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar(255), "label] 5}indexindex_notes_on_labelnotesCREATE INDEX "index_notes_on_label" ON "notes" ("label")m ?indexindex_notes_on_updated_atnotesCREATE INDEX "index_notes_on_updated_at" ON "notes" ("updated_at")ZtablehistorieshistoriesCREATE TABLE "histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar(255), "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)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")  + + +  + +JyEindexindex_watchers_on_created_atwatchersCREATE INDEX "index_watchers_on_created_at" ON "watchers" ("created_at")sAindexindex_watchers_on_owner_idwatchersCREATE INDEX "index_watchers_on_owner_id" ON "watchers" ("owner_id")j; indexindex_watchers_on_labelwatchersCREATE INDEX "index_watchers_on_label" ON "watchers" ("label")}G!indexindex_histories_on_created_athistoriesCREATE INDEX "index_histories_on_created_at" ON "histories" ("created_at")U}tablewatcherswatchersCREATE TABLE "watchers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "label" varchar(255), "document_id" integer, "created_at" datetime, "updated_at" datetime)|G!indexindex_watchers_on_document_idwatchersCREATE INDEX "index_watchers_on_document_id" ON "watchers" ("document_id") + + + \ No newline at end of file