test/dummy/db/test.sqlite3 in guts-1.0.8 vs test/dummy/db/test.sqlite3 in guts-1.1.0

- old
+ new

@@ -1,34 +1,42 @@ -SQLite format 3@ !!- - F [ +SQLite format 3@ ,5- ++ F [ gb+9p)!!tableguts_mediaguts_mediaCREATE TABLE "guts_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "tags" text, "position" integer DEFAULT 0, "filable_id" integer, "filable_type" varchar, "caption" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)w55tableguts_categorizationsguts_categorizationsCREATE TABLE "guts_categorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "content_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)C''indexindex_guts_contents_on_slugguts_contentsCREATE UNIQUE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug")9''1tableguts_contentsguts_contentsCREATE TABLE "guts_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "tags" text, "content" text, "visible" integer(1) DEFAULT 1, "type_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) G+/indexindex_guts_categories_on_slugguts_categoriesCREATE UNIQUE INDEX "index_guts_categories_on_slug" ON "guts_categories" ("slug")o++tableguts_categoriesguts_categoriesCREATE TABLE "guts_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "metafields" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)e--}tableguts_user_groupsguts_user_groupsCREATE TABLE "guts_user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "group_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)z ?#indexindex_guts_groups_on_slugguts_groupsCREATE UNIQUE INDEX "index_guts_groups_on_slug" ON "guts_groups" ("slug")P ##gtableguts_groupsguts_groups CREATE TABLE "guts_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) !!Otableguts_usersguts_users CREATE TABLE "guts_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "password_digest" varchar, "password_token" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v =!indexindex_guts_types_on_slugguts_types CREATE UNIQUE INDEX "index_guts_types_on_slug" ON "guts_types" ("slug")M !!etableguts_typesguts_types -CREATE TABLE "guts_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugs CREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)//1tablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT  13 12 11 10 -9 876543210 -1312 11 10 9 -8 7654321 0  vX?* !guts_users-T -guts_user_groups} !guts_types K -'guts_trackers:l %guts_options V-guts_navigations2 s7guts_navigation_itemsU*+guts_metafields7z!guts_media #guts_groups&'guts_contentsr#5guts_categorizations1,%+guts_categories/ +CREATE TABLE "guts_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugs CREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)//1tablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar p^L:()20160410203608)20160410200459)20160410200029)20160309030244 )20160309030243 )20160309030242 )20160309030241 +)20160309030240 )20160309030239)20160309030238)20160309030237)20160309030236)20160309030235)20160309030234)20160309030233)20160309030232)20160309030231 +|iVC0 +)20160410203608)20160410200459)20160410200029)20160309030244)20160309030243 )20160309030242 )20160309030241 )20160309030240 +)20160309030239 )20160309030238)20160309030237)20160309030236)20160309030235)20160309030234)20160309030233)20160309030232) 20160309030231  vX?*!guts_users-T -guts_user_groups} !guts_types K 'guts_trackers:l +!guts_sites,2 %guts_options V-guts_navigations2 s7guts_navigation_itemsU*+guts_metafields9ׄ!guts_media #guts_groups&'guts_contentsr#5guts_categorizations1,%+guts_categories/    - 4s33Pagepage2016-03-09 04:38:002016-03-09 04:38:00 - page K oo -쩩+ !+33Test Admintest@domain.com$2a$10$ufkl6AZOOMycq45JaxsuCeRI9kW58hJHHn42e84FGjBvL1kyjrL3e1234562016-03-09 04:38:002016-03-09 04:38:00 8O33Adminsadmins2016-03-09 04:38:002016-03-09 04:38:00 - admins& 4A33-T&2016-03-09 04:38:002016-03-09 04:38:00 J+)33Super Category!super-category2016-03-09 04:38:002016-03-09 04:38:00 -)super-category/ --^] ##3 33Test Page 2test-page-2Test page content 2 K2016-03-09 04:38:002016-03-09 04:38:00iιo '/ 33Test Pagetest-pageone,two,threeTest page content K-T2016-03-09 04:38:002016-03-09 04:38:00 -#test-page-2r#test-pages 4i33/s2016-03-09 04:38:002016-03-09 04:38:00 gϘa'33!PeppersGuts::ContentMy dog2016-03-09 04:38:002016-03-09 04:38:00Pepper.jpgimage/jpg" -'Guts::Contents  p F [ - gb+9p)!!tableguts_mediaguts_mediaCREATE TABLE "g)!!tableguts_mediaguts_mediaCREATE TABLE "guts_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "tags" text, "position" integer DEFAULT 0, "filable_id" integer, "filable_type" varchar, "caption" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)w55tableguts_categorizationsguts_categorizationsCREATE TABLE "guts_categorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "content_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)C''indexindex_guts_contents_on_slugguts_contentsCREATE UNIQUE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug")9''1tableguts_contentsguts_contentsCREATE TABLE "guts_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "tags" text, "content" text, "visible" integer(1) DEFAULT 1, "type_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) -G+/indexindex_guts_categories_on_slugguts_categoriesCREATE UNIQUE INDEX "index_guts_categories_on_slug" ON "guts_categories" ("slug")o++tableguts_categoriesguts_categoriesCREATE TABLE "guts_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "metafields" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)e--}tableguts_user_groupsguts_user_groupsCREATE TABLE "guts_user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "group_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)z ?#indexindex_guts_groups_on_slugguts_groupsCREATE UNIQUE INDEX "index_guts_groups_on_slug" ON "guts_groups" ("slug")P ##gtableguts_groupsguts_groups CREATE TABLE "guts_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) !!Otableguts_usersguts_users CREATE TABLE "guts_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "password_digest" varchar, "password_token" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v -=!indexindex_guts_types_on_slugguts_types CREATE UNIQUE INDEX "index_guts_types_on_slug" ON "guts_types" ("slug")M !!etableguts_typesguts_types -CREATE TABLE "guts_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugs CREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)//1tablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 6 \ -b V2%OM. |9m'kindexindex_guts_trackers_on_object_type_and_object_idguts_trackers CREATE INDEX "index_guts_trackers_on_object_type_and_object_id" ON "guts_trackers" ("object_type", "object_id")''=tableguts_trackersguts_trackersCREATE TABLE "guts_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "object_id" integer, "object_type" varchar, "params" text, "action" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S}+ indexindex_guts_metafields_on_fieldable_type_and_fieldable_idguts_metafieldsCREATE INDEX "index_guts_metafields_on_fieldable_type_and_fieldable_id" ON "guts_metafields" ("fieldable_type", "fieldable_id") -++Ktableguts_metafieldsguts_metafieldsCREATE TABLE "guts_metafields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar, "value" text, "fieldable_id" integer, "fieldable_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)A[7}indexindex_nav_items_on_nav_with_type_and_idguts_navigation_itemsCREATE INDEX "index_nav_items_on_nav_with_type_and_id" ON "guts_navigation_items" ("navigatable_type", "navigatable_id")]77Ytableguts_navigation_itemsguts_navigation_itemsCREATE TABLE "guts_navigation_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "custom" varchar, "position" integer DEFAULT 0, "navigatable_id" integer, "navigatable_type" varchar, "navigation_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)I-3indexindex_guts_navigations_on_slugguts_navigationsCREATE UNIQUE INDEX "index_guts_navigations_on_slug" ON "guts_navigations" ("slug")!!wtableguts_mediaguts_mediaCREATE TABLE "guts_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "tags" text, "position" integer DEFAULT 0, "filable_id" integer, "filable_type" varchar, "caption" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "file_file_name" varchar, "file_content_type" varchar, "file_file_size" integer, "file_updated_at" datetime)3k!gindexindex_guts_media_on_filable_type_and_filable_idguts_mediaCREATE INDEX "index_guts_media_on_filable_type_and_filable_id" ON "guts_media" ("filable_type", "filable_id") J!!tableguts_mediaguts_mediaCREATE TABLE "guts_media" ("id" IN_--qtableguts_navigationsguts_navigationsCREATE TABLE "guts_navigations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)w55tableguts_categorizationsguts_categorizationsCREATE TABLE "guts_categorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "content_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)C''indexindex_guts_contents_on_slugguts_contentsCREATE UNIQUE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug")M''1tableguts_contentsguts_contentsCREATE TABLE "guts_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "tags" text, "content" text, "visible" integer(1) DEFAULT 1, "type_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) -G+/indexindex_guts_categories_on_slugguts_categoriesCREATE UNIQUE INDEX "index_guts_categories_on_slug" ON "guts_categories" ("slug")o++tableguts_categoriesguts_categoriesCREATE TABLE "guts_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "metafields" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)e--}tableguts_user_groupsguts_user_groupsCREATE TABLE "guts_user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integeO%%atableguts_optionsguts_options!CREATE TABLE "guts_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar, "value" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) <33Test Navtest-nav2016-03-09 04:38:002016-03-09 04:38:00 -test-nav2 s PPR9 -'/33Test Nav Itemhttp://google.ca/2 s2016-03-09 04:38:002016-03-09 04:38:00R׀* -''33Test Nav ItemsGuts::Content2 s2016-03-09 04:38:002016-03-09 04:38:00 -'Guts::ContentsU*  \ \ E&b-%533Test Metafield 7Test Value 7U*Guts::NavigationItem2016-03-09 04:38:002016-03-09 04:38:00^p-%-33Test Metafield 6Test Value 62 sGuts::Navigation2016-03-09 04:38:002016-03-09 04:38:00\z-%)33Test Metafield 5Test Value 5/Guts::Category2016-03-09 04:38:002016-03-09 04:38:00Yնv-%#33Test Metafield 4Test Value 4&Guts::Group2016-03-09 04:38:002016-03-09 04:38:00X蝶8-%!33Test Metafield 3Test Value 3-TGuts::User2016-03-09 04:38:002016-03-09 04:38:00X⫴X-%!33Test Metafield 2Test Value 2 KGuts::Type2016-03-09 04:38:002016-03-09 04:38:00Wϗ{)!'33Test MetafieldTest ValuesGuts::Content2016-03-09 04:38:002016-03-09 04:38:00 -GhG 5Guts::NavigationItemU*Pn-Guts::Navigation2 sϞp)Guts::Category/7z#Guts::Group&v!Guts::User-T[8!Guts::Type KJX'Guts::Contents{ TTEf'33sGuts::Contentcreate2016-03-09 04:38:002016-03-09 04:38:00[Ӳr'933sGuts::Content{"title": ["X", "Y"]} -update2016-03-09 04:38:002016-03-09 04:38:00 -'Guts::Contentsʊf'Guts::Contents:l 7ɭ933test_key1232016-03-09 04:38:002016-03-09 04:38:00 + 5s33Pagepage2016-04-18 23:12:122016-04-18 23:12:12 + page K oP %;33Test Regulartest_regular@domain.com$2a$10$XNbTRIWJpw2NX2AGOtFEauJYkKwK2c5so5TuEy3D33tRwvq13S4iS2016-04-18 23:12:122016-04-18 23:12:12 +쩩+ !+33Test Admintest@domain.com$2a$10$0F0r73YV5zaawBWYClUdyuClMHnXDwCBMhRrYEV8ERmc4pNAsY3uW1234562016-04-18 23:12:122016-04-18 23:12:12 8O33Adminsadmins2016-04-18 23:12:122016-04-18 23:12:12 + admins& 4A33-T&2016-04-18 23:12:122016-04-18 23:12:12 K+)33Super Category!super-category2016-04-18 23:12:122016-04-18 23:12:12 +)super-category/ ++_] ##3 33Test Page 2test-page-2Test page content 2 K2016-04-18 23:12:122016-04-18 23:12:12jιo '/ 33Test Pagetest-pageone,two,threeTest page content K-T2016-04-18 23:12:122016-04-18 23:12:12 +#test-page-2r#test-pages 4i33/s2016-04-18 23:12:122016-04-18 23:12:12 hϘa'33!PeppersGuts::ContentMy dog2016-04-18 23:12:122016-04-18 23:12:12Pepper.jpgimage/jpg" +'Guts::Contents   F [ + TO|7L''Wtableguts_contentsguts_contentsCREATE TABLE "guts_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "tags" text, "content" text, "visible" integer(1) DEFAULT 1, "type_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)++;tableguts_categoriesguts_categoriesCRw55tableguts_categorizationsguts_categorizationsCREATE TABLE "guts_categorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "content_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)C''indexindex_guts_contents_on_slugguts_contentsCREATE UNIQUE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug")L''Wtableguts_contentsguts_contentsCREATE TABLE "guts_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "tags" text, "content" text, "visible" integer(1) DEFAULT 1, "type_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer) +G+/indexindex_guts_categories_on_slugguts_categoriesCREATE UNIQUE INDEX "index_guts_categories_on_slug" ON "guts_categories" ("slug")++;tableguts_categoriesguts_categoriesCREATE TABLE "guts_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "metafields" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)e--}tableguts_user_groupsguts_user_groupsCREATE TABLE "guts_user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "group_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)z ?#indexindex_guts_groups_on_slugguts_groupsCREATE UNIQUE INDEX "index_guts_groups_on_slug" ON "guts_groups" ("slug")P ##gtableguts_groupsguts_groups CREATE TABLE "guts_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) !!Otableguts_usersguts_users CREATE TABLE "guts_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "password_digest" varchar, "password_token" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v +=!indexindex_guts_types_on_slugguts_types CREATE UNIQUE INDEX "index_guts_types_on_slug" ON "guts_types" ("slug")` !! tableguts_typesguts_types +CREATE TABLE "guts_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugs CREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)//1tablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL) g *0 + + \S9|b%%tableguts_optionsguts_options!CREATE TABLE "guts_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar, "value" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)&I'%indexindex_guts_trackers_on_site_idguts_trackers)CREATE INDEX "index_guts_trackers_on_site_id" ON "guts_trackers" ("site_id") %M+-indexindex_guts_metafields_on_site_idguts_metafields(CREATE INDEX "index_guts_metafields_on_site_id" ON "guts_metafields" ("site_id")$$Y7Eindexindex_guts_navigation_items_on_site_idguts_navigation_items'CREATE INDEX "index_guts_navigation_items_on_site_id" ON "guts_navigation_items" ("site_id")#O-1indexindex_guts_navigations_on_site_idguts_navigations&CREATE IND)!!tableguts_mediaguts_mediaCREATE TABLE "guts_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "tags" text, "position" integer DEFAULT 0, "filable_id" integer, "filable_type" varchar, "caption" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "file_file_name" varchar, "file_content_type" varchar, "file_file_size" integer, "file_updated_at" datetime, "site_id" integer)w55tableguts_categorizationsguts_categorizationsCREATE TABLE "guts_categorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "content_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)C''indexindex_guts_contents_on_slugguts_contentsCREATE UNIQUE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug")L''Wtableguts_contentsguts_contentsCREATE TABLE "guts_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "tags" text, "content" text, "visible" integer(1) DEFAULT 1, "type_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)S}+ indexindex_guts_metafields_on_fieldable_type_and_fieldable_idguts_metafieldsCREATE INDEX "index_guts_metafields_on_fieldable_type_and_fieldable_id" ON "guts_metafields" ("fieldable_type", "fieldable_id")++qtableguts_metafieldsguts_metafieldsCREATE TABLE "guts_metafields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar, "value" text, "fieldable_id" integer, "fieldable_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)A[7}indexindex_nav_items_on_nav_with_type_and_idguts_navigation_itemsCREATE INDEX "index_nav_items_on_nav_with_type_and_id" ON "guts_navigation_items" ("navigatable_type", "navigatable_id")p77tableguts_navigation_itemsguts_navigation_itemsCREATE TABLE "guts_navigation_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "custom" varchar, "position" integer DEFAULT 0, "navigatable_id" integer, "navigatable_type" varchar, "navigation_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)I-3indexindex_guts_navigations_on_slugguts_navigationsCREATE UNIQUE INDEX "index_guts_navigations_on_slug" ON "guts_navigations" ("slug")r--tableguts_navigationsguts_navigationsCREATE TABLE "guts_navigations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)3k!gindexindex_guts_media_on_filable_type_and_filable_idguts_mediaCREATE INDEX "index_guts_media_on_filable_type_and_filable_id" ON "guts_media" ("filable_type", "filable_id")!!wtableguts_mediaguts_mediaCREATE TABLE "guts_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "tags" text, "position" integer DEFAULT 0, "filable_id" integer, "filable_type" varchar, "caption" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "file_file_name" varchar, "file_content_type" varchar, "file_file_size" integer, "file_updated_at" datetime) =33Test Navtest-nav2016-04-18 23:12:122016-04-18 23:12:12 +test-nav2 s NNS9 '/33Test Nav Itemhttp://google.ca/2 s2016-04-18 23:12:122016-04-18 23:12:12S׀* ''33Test Nav ItemsGuts::Content2 s2016-04-18 23:12:122016-04-18 23:12:12 +'Guts::ContentsU*  U C! Yމ -%!33Test Metafield 8Test Value 8,2Guts::Site2016-04-18 23:12:122016-04-18 23:12:12c -%533Test Metafield 7Test Value 7U*Guts::NavigationItem2016-04-18 23:12:122016-04-18 23:12:12_p -%-33Test Metafield 6Test Value 62 sGuts::Navigation2016-04-18 23:12:122016-04-18 23:12:12]z -%)33Test Metafield 5Test Value 5/Guts::Category2016-04-18 23:12:122016-04-18 23:12:12Zնv -%#33Test Metafield 4Test Value 4&Guts::Group2016-04-18 23:12:122016-04-18 23:12:12Y蝶8 -%!33Test Metafield 3Test Value 3-TGuts::User2016-04-18 23:12:122016-04-18 23:12:12Y⫴X -%!33Test Metafield 2Test Value 2 KGuts::Type2016-04-18 23:12:122016-04-18 23:12:12Xϗ{ )!'33Test MetafieldTest ValuesGuts::Content2016-04-18 23:12:122016-04-18 23:12:12 +0hG0!Guts::Site,29ׄ 5Guts::NavigationItemU*Pn-Guts::Navigation2 sϞp)Guts::Category/7z#Guts::Group&v!Guts::User-T[8!Guts::Type KJX'Guts::Contents{ RRFf '33sGuts::Contentcreate2016-04-18 23:12:122016-04-18 23:12:12\Ӳr '933sGuts::Content{"title": ["X", "Y"]} +update2016-04-18 23:12:122016-04-18 23:12:12 +'Guts::Contentsʊf'Guts::Contents:l 8ɭ933test_key1232016-04-18 23:12:122016-04-18 23:12:12 jjHM%+33Fr Test Sitefr.testsite.com2016-04-18 23:12:122016-04-18 23:12:12Cb%33Test Sitetestsite.com2016-04-18 23:12:122016-04-18 23:12:12t + K +/ +r#s +2 s +U* +9ׄPnϞp7zv[8JX{ +ʊf:l + V y / J p + +V k!!!tableguts_sitesguts_sites"CREATE TABLE "guts_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "domain" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "default" boolean DEFAULT 0)x(C!indexindex_guts_media_on_site_idguts_media,CREATE INDEX "index_guts_media_on_site_id" ON "guts_media" ("site_id")'G%!indexindex_guts_options_on_site_idguts_options*CREATE INDEX "index_guts_options_on_site_id" ON "guts_options" ("site_id")&I'%indexindex_guts_trackers_on_site_idguts_trackers)CREATE INDEX "index_guts_trackers_on_site_id" ON "guts_trackers" ("site_id") %M+-indexindex_guts_metafields_on_site_idguts_metafields(CREATE INDEX "index_guts_metafields_on_site_id" ON "guts_metafields" ("site_id")$$Y7Eindexindex_guts_navigation_items_on_site_idguts_navigation_items'CREATE INDEX "index_guts_navigation_items_on_site_id" ON "guts_navigation_items" ("site_id")#O-1indexindex_guts_navigations_on_site_idguts_navigations&CREATE INDEX "index_guts_navigations_on_site_id" ON "guts_navigations" ("site_id")"I'%indexindex_guts_contents_on_site_idguts_contents%CREATE INDEX "index_guts_contents_on_site_id" ON "guts_contents" ("site_id") !M+-indexindex_guts_categories_on_site_idguts_categories$CREATE INDEX "index_guts_categories_on_site_id" ON "guts_categories" ("site_id")x C!indexindex_guts_types_on_site_idguts_types#CREATE INDEX "index_guts_types_on_site_id" ON "guts_types" ("site_id")!!gtableguts_sitesguts_sites"CREATE TABLE "guts_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "domain" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)b%%tableguts_optionsguts_options!CREATE TABLE "guts_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar, "value" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer)9m'kindexindex_guts_trackers_on_object_type_and_object_idguts_trackers CREATE INDEX "index_guts_trackers_on_object_type_and_object_id" ON "guts_trackers" ("object_type", "object_id")''ctableguts_trackersguts_trackersCREATE TABLE "guts_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "object_id" integer, "object_type" varchar, "params" text, "action" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "site_id" integer) +  \ No newline at end of file