spec/dummy/db/development.sqlite3 in page_engine-0.0.3 vs spec/dummy/db/development.sqlite3 in page_engine-0.0.4
- old
+ new
@@ -1,8 +1,21 @@
-SQLite format 3 @ -
)20110814185929
- )20110814185929
p
#
AAtestDrafttesttttestfapplication2011-08-23 22:47:17.4146322011-08-23 22:47:17.414632
J J G 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")6KtablepagespagesCREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "meta_description" text, "meta_keywords" text, "status" varchar(255), "publish_from" datetime, "publish_to" datetime, "created_by" integer, "permalink" varchar(255), "url" varchar(255), "display_in_menu" boolean DEFAULT 't', "display_in_sitemap" boolean DEFAULT 't', "menu_css_class" varchar(255), "no_link" boolean DEFAULT 'f', "controller" varchar(255), "action" varchar(255), "layout" varchar(255), "js" text, "css" text, "parent_id" integer, "lft" integer, "rgt" integer, "authorable_type" varchar(255), "authorable_id" integer, "created_at" datetime, "updated_at" datetime)
!page_parts pages
y y P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)j!!tablepage_partspage_partsCREATE TABLE "page_parts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "page_id" integer, "filter" varchar(255), "created_at" datetime, "updated_at" datetime)d##tablepages_rolespages_roles CREATE TABLE "pages_roles" ("page_id" integer, "role_id" integer)_''}tablepage_snippetspage_snippets
-CREATE TABLE "page_snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "filter" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)
r* G
AAfooternone2011-08-23 22:47:17.4751642011-08-23 22:47:17.475164G
AAheadernone2011-08-23 22:47:17.4732212011-08-23 22:47:17.473221F
AArightnone2011-08-23 22:47:17.4709842011-08-23 22:47:17.470984E
AAleftnone2011-08-23 22:47:17.4676772011-08-23 22:47:17.467677E
AAbodynone2011-08-23 22:47:17.4636892011-08-23 22:47:17.463689
- test
-
t Jpt {C'indexindex_page_snippets_on_namepage_snippetsCREATE INDEX "index_page_snippets_on_name" ON "page_snippets" ("name")W1uindexindex_pages_on_urlpagesCREATE INDEX "index_pages_on_url" ON "pages" ("url")7!!9tablepage_rolespage_rolesCREATE TABLE "page_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "required_role_id" integer, "excluded_role_id" integer)j =
indexindex_pages_on_permalinkpagesCREATE INDEX "index_pages_on_permalink" ON "pages" ("permalink")
+SQLite format 3 @ . . -
)20110814185929
+ )20110814185929
J J G 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")6KtablepagespagesCREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "meta_description" text, "meta_keywords" text, "status" varchar(255), "publish_from" datetime, "publish_to" datetime, "created_by" integer, "permalink" varchar(255), "url" varchar(255), "display_in_menu" boolean DEFAULT 't', "display_in_sitemap" boolean DEFAULT 't', "menu_css_class" varchar(255), "no_link" boolean DEFAULT 'f', "controller" varchar(255), "action" varchar(255), "layout" varchar(255), "js" text, "css" text, "parent_id" integer, "lft" integer, "rgt" integer, "authorable_type" varchar(255), "authorable_id" integer, "created_at" datetime, "updated_at" datetime)
!page_parts( pages
y y P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)j!!tablepage_partspage_partsCREATE TABLE "page_parts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "page_id" integer, "filter" varchar(255), "created_at" datetime, "updated_at" datetime)d##tablepages_rolespages_roles CREATE TABLE "pages_roles" ("page_id" integer, "role_id" integer)_''}tablepage_snippetspage_snippets
+CREATE TABLE "page_snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "filter" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime) '