spec/dummy/db/development.sqlite3 in active_metadata-0.6.2 vs spec/dummy/db/development.sqlite3 in active_metadata-0.6.3

- old
+ new

@@ -1,20 +1,27 @@ -SQLite format 3@ "-â!â ûöñìçâS‚ytablesectionssectionsCREATE 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" ("v  öûö21 -ôúô21     ìì_éØ*è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)S‚ytablesectionssectionsCREATE 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) [[D¬_0a7Uindexindex_active_metadata_notes_on_documen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)‚e77„itableactive_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)0a7Uindexindex_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")  - - - ……5ñ=<- -_7Qindexindex_active_metadata_notes_on_updated_atactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_updated_at" ON "active_metadata_notes" ("updated_at")9 g7aindexindex_active_metadata_notes_on_document_classactive_metadata_notesCREATE INDEX "index_active_metadata_notes_on_document_class" ON "active_metadata_notes" ("document_class")‚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)@ i?eindexindex_active_metadata_histories_on_document_idactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_id" ON "active_metadata_histories" ("document_id") -  - - ÃÃt4üIo?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("documen.]?Mindexindex_active_metadata_histories_on_labelactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_label" ON "active_metadata_histories" ("label")=g?aindexindex_active_metadata_histories_on_created_atactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_created_at" ON "active_metadata_histories" ("created_at")Io?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class") - -  }}|Gƒ|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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)HmCmindexindex_active_metadata_attachments_on_document_idactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_id" ON "active_metadata_attachments" ("document_id")6aCUindexindex_active_metadata_attachments_on_labelactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_label" ON "active_metadata_attachments" ("label") - - - óÇAZyC‚indexindex_active_metadata_attachments_on_attach_updated_atactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_attach_updated_at" ON "active_metadata_attaZyC‚indexindex_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")QsCyindexindex_active_metadata_attachments_on_document_classactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_class" ON "active_metadata_attachments" ("document_class")‚6==ƒ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) -  - - "”SÞ"9e=]indexindex_active_metadata_watchers_on_created_atactive_metadata_watchers"CREATE INDEX "index_active_metadata_watchers_on_created_at" ON "active_metadata_watchers" ("created_at")3a=Uindexindex_active_metadata_watchers_on_owner_idactive_metadata_watchers!CREATE INDEX "index_active_metadata_watchers_on_owner_id" ON "active_metadata_watchers" ("owner_id")<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") - - +SQLite format 3@ -âûû  ì  +› è G—ۏÌ[ÅHmCmindexindex_active_metadata_attachments_on_document_idactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_id" ON "active_metadata_attachments" ("document_id")ƒ|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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Io?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_historiesCREATE 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 g7aindexindex_active_metadata_notes_on_document_classactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_class" ON "active_metadata_notes" ("document_class")- +_7Qindexindex_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")0a7Uindexindex_active_metadata_notes_on_document_idactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_id" ON "active_metadata_notes" ("document_id")‚e77„itableactive_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, "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)S‚ytablesectionssectionsCREATE 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" varchar(255) NOT  öûö21 +ôúô21      + + + +  + + + +  + + ÛÛNØ Ç + +ï Ø @ ó”DÌ[ÅHmCmindexindex_active_metadata_attachmentHmCmindexindex_active_metadata_attachments_on_document_idactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_id" ON "active_metadata_attachments" ("document_id")ƒ|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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Io?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_historiesCREATE 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)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)S‚ytablesectionssectionsCREATE 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)‚e77„itableactive_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)0a7Uindexindex_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")- +_7Qindexindex_active_metadata_notes_on_updated_atactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_updated_at" ON "active_metadata_notes" ("updated_at")9 g7aindexindex_active_metadata_notes_on_document_classactive_metadata_notes CREATE INDEX "index_active_metadata_notes_on_document_class" ON "active_metadata_notes" ("document_class") i1 } +@ +ñ ± }|GT€GˆÛ%i9e=]indexindex_active_metadata_watchers_on_created_atactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_created_at" ON "active_metadata_watchers" ("created_at")3a=Uindexindex_active_metadata_watchers_on_owner_idactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_owner_id" ON "active_metadata_watchers" ("owner_id")*[=Iindexindex_active_metadata_watchers_on_labelactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_label" ON "active_metadata_watchers" ("label")<g=aindexindex_active_metadata_watchers_on_document_idactive_metadata_watchersCREATE INDEX "index_active_metadata_watchers_on_document_id" ON "active_metadata_watchers" ("document_id")‚6==ƒ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)QsCyindexindex_active_metadata_attachments_on_document_classactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_class" ON "active_metadata_attachments" ("document_class")ZyC‚indexindex_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")‚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)@ 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_historiesCREATE INDEX "index_active_metadata_histories_on_label" ON "active_metadata_histories" ("label")=g?aindexindex_active_metadata_histories_on_created_atactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_created_at" ON "active_metadata_histories" ("created_at")Io?qindexindex_active_metadata_histories_on_document_classactive_metadata_historiesCREATE INDEX "index_active_metadata_histories_on_document_class" ON "active_metadata_histories" ("document_class")ƒ|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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)HmCmindexindex_active_metadata_attachments_on_document_idactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_document_id" ON "active_metadata_attachments" ("document_id")6aCUindexindex_active_metadata_attachments_on_labelactive_metadata_attachmentsCREATE INDEX "index_active_metadata_attachments_on_label" ON "active_metadata_attachments" ("label") + +  + + + + \ No newline at end of file