test/dummy/db/test.sqlite3 in saphira-0.1.0 vs test/dummy/db/test.sqlite3 in saphira-0.1.1.beta1

- old
+ new

@@ -1,13 +1,13 @@ -SQLite format 3@  "V8 mtabletaggingstaggings CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(255), "created_at" datetime)o +SQLite format 3@  "V8 mtabletaggingstaggings CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(255), "created_at" datetime)o Atabletagstags CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) K1)indexindex_saphira_file_items_on_rgtsaphira_file_items -CREATE INDEX "index_saphira_file_items_on_rgt" ON "saphira_file_items" ("rgt") K1)indexindex_saphira_file_items_on_lftsaphira_file_items CREATE INDEX "index_saphira_file_items_on_lft" ON "saphira_file_items" ("lft")W1Aindexindex_saphira_file_items_on_parent_idsaphira_file_itemsCREATE INDEX "index_saphira_file_items_on_parent_id" ON "saphira_file_items" ("parent_id")M1;indexindex_saphira_file_items_on_pathsaphira_file_itemsCREATE UNIQUE INDEX "index_saphira_file_items_on_path" ON "saphira_file_items" ("path")M1-indexindex_saphira_file_items_on_slugsaphira_file_itemsCREATE INDEX "index_saphira_file_items_on_slug" ON "saphira_file_items" ("slug")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) 11Ctablesaphira_file_itemssaphira_file_itemsCREATE TABLE "saphira_file_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "item_type" varchar(255), "file_uid" varchar(255), "file_name" varchar(255), "slug" varchar(255), "path" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "dynamic_attributes" text, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT  )20110904172952)20110904172951 -)20110904172952)20110904172951   +CREATE INDEX "index_saphira_file_items_on_rgt" ON "saphira_file_items" ("rgt") K1)indexindex_saphira_file_items_on_lftsaphira_file_items CREATE INDEX "index_saphira_file_items_on_lft" ON "saphira_file_items" ("lft")W1Aindexindex_saphira_file_items_on_parent_idsaphira_file_itemsCREATE INDEX "index_saphira_file_items_on_parent_id" ON "saphira_file_items" ("parent_id")M1;indexindex_saphira_file_items_on_pathsaphira_file_itemsCREATE UNIQUE INDEX "index_saphira_file_items_on_path" ON "saphira_file_items" ("path")M1-indexindex_saphira_file_items_on_slugsaphira_file_itemsCREATE INDEX "index_saphira_file_items_on_slug" ON "saphira_file_items" ("slug")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) 11Ctablesaphira_file_itemssaphira_file_itemsCREATE TABLE "saphira_file_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "item_type" varchar(255), "file_uid" varchar(255), "file_name" varchar(255), "slug" varchar(255), "path" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "dynamic_attributes" text, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT  )20110909143951)20110904172952)20110904172951 +)20110909143951)20110904172952)20110904172951           VVS4_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") 11Ctablesaphira_file_itemssaphira_file_itemsCREATE TABLE "saphira_file_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "item_type" varchar(255), "file_uid" varchar(255), "file_name" varchar(255), "slug" varchar(255), "path" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "dynamic_attributes" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)M1-indexindex_saphira_file_items_on_slugsq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") 11Ctablesaphira_file_itemssaphira_file_itemsCREATE TABLE "saphira_file_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "item_type" varchar(255), "file_uid" varchar(255), "file_name" varchar(255), "slug" varchar(255), "path" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "dynamic_attributes" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)M1-indexindex_saphira_file_items_on_slugsaphira_file_itemsCREATE INDEX "index_saphira_file_items_on_slug" ON "saphira_file_items" ("slug")M1;indexindex_saphira_file_items_on_pathsaphira_file_itemsCREATE UNIQUE INDEX "index_saphira_file_items_on_path" ON "saphira_file_items" ("path")W1Aindexindex_saphira_file_items_on_parent_idsaphira_file_itemsCREATE INDEX "index_saphira_file_items_on_parent_id" ON "saphira_file_items" ("parent_id") - 8( K1)indexindex_saphira_file_items_on_lftsaphira_file_items CREATE INDEX "index_saphira_file_items_on_lft" ON "saphira_file_items" ("lft") K1)indexindex_saphira_file_items_on_rgtsaphira_file_items +  8( 993tablesaphira_image_variantssaphira_image_variantsCREATE TABLE "saphira_image_variants" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "manipulation" varchar(255), "created_at" datetime, "updated_at" datetime) K1)indexindex_saphira_file_items_on_lftsaphira_file_items CREATE INDEX "index_saphira_file_items_on_lft" ON "saphira_file_items" ("lft") K1)indexindex_saphira_file_items_on_rgtsaphira_file_items CREATE INDEX "index_saphira_file_items_on_rgt" ON "saphira_file_items" ("rgt")o -Atabletagstags CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) mtabletaggingstaggings CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(255), "created_at" datetime)m = indexindex_taggings_on_tag_idtaggings CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")U indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context") +Atabletagstags CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) mtabletaggingstaggings CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(255), "created_at" datetime)m = indexindex_taggings_on_tag_idtaggings CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")U indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  \ No newline at end of file