SQLite format 3@  - )20110814185929 )20110814185929 p  # AAtestDrafttesttttestfapplication2011-08-23 22:47:17.4146322011-08-23 22:47:17.414632 JJGq//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 yyP++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  tJpt{ C'indexindex_page_snippets_on_namepage_snippetsCREATE INDEX "index_page_snippets_on_name" ON "page_snippets" ("name")W 1uindexindex_pages_on_urlpagesCREATE INDEX "index_pages_on_url" ON "pages" ("url")7!!9tablepage_rolespage_roles CREATE 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_permalinkpages CREATE INDEX "index_pages_on_permalink" ON "pages" ("permalink") U;indexindex_pages_on_controller_and_actionpages CREATE INDEX "index_pages_on_controller_and_action" ON "pages" ("controller", "action")