spec/dummy/db/development.sqlite3 in manageable-0.1.0 vs spec/dummy/db/development.sqlite3 in manageable-0.1.1
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @
- -
-
-
0MMStablemanageable_content_page_contentsmanageable_content_page_contentsCREATE TABLE "manageable_content_page_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "key" varchar(255), "short" boolean DEFAULT 'f', "content" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)nMindexindex_manageable_content_page_contents_on_page_id_and_keymanageable_content_page_contentsCREATE UNIQUE INDEX "index_manageable_content_page_contents_on_page_id_and_key" ON "manageable_content_page_contents" ("page_id", "key")
C @2C =//indexunique_schema_migrationsschema_migrations
-CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)o==qtablemanageable_content_pagesmanageable_content_pagesCREATE TABLE "manageable_content_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar(255), "locale" varchar(255), "created_at" datetime, "updated_at" datetime)Km=yindexindex_manageable_content_pages_on_key_and_localemanageable_content_pagesCREATE UNIQUE INDEX "index_manageable_content_pages_on_key_and_locale" ON "manageable_content_pages" ("key", "locale")
)20110814002730)20110814003912
- )20110814002730)20110814003912
+SQLite format 3 @ -
)20120311172544)20120302131617
+ )20120311172544)20120302131617
/ 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")D_tablesamplessamplesCREATE TABLE "samples" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text_field" varchar(255), "password_field" varchar(255), "telephone_field" varchar(255), "date_field" varchar(255), "url_field" varchar(255), "email_field" varchar(255), "number_field" varchar(255), "range_field" varchar(255), "file_field" varchar(255), "radio_button" varchar(255), "select_field" varchar(255), "multiple_select_field" varchar(255), "text_area" text, "checkbox_one" boolean, "checkbox_two" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
j @5 j H{indexindex_articles_on_highlight_and_published_at_and_localearticlesCREATE INDEX "index_articles_on_highlight_and_published_at_and_locale" ON "articles" ("highlight", "published_at", "locale")_Oindexindex_articles_on_published_at_and_localearticles
+CREATE INDEX "index_articles_on_published_at_and_locale" ON "articles" ("published_at", "locale")g9indexindex_articles_on_slugarticles CREATE INDEX "index_articles_on_slug" ON "articles" ("slug")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)k)tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "title" varchar(255), "description" varchar(255), "keywords" varchar(255), "locale" varchar(255), "excerpt" text, "content" text, "published_at" datetime, "highlight" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
+
+
+
\ No newline at end of file