SQLite format 3@ 1)D-p+ 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 tp^L:(t)20161201022201)20161201021539)20160927044443)20160927035600)20160726010421)20160410203608)20160410200459)20160410200029)20160309030244 )20160309030243 )20160309030242 )20160309030241 )20160309030240 )20160309030239)20160309030238)20160309030237)20160309030236)20160309030235)20160309030234)20160309030233)20160309030232)20160309030231 _|iVC0 r_)20161201022201)20161201021539)20160927044443)20160927035600)20160726010421)20160410203608)20160410200459)20160410200029)20160309030244)20160309030243 )20160309030242 )20160309030241 )20160309030240 )20160309030239 )20160309030238)20160309030237)20160309030236)20160309030235)20160309030234)20160309030233)20160309030232) 20160309030231  pR9$ !guts_users-T-guts_user_groups}!guts_types K'guts_contentsr#!guts_users-T !guts_sites,2 -guts_permissions; %guts_options V -guts_navigations2 s7guts_navigation_itemsU*+guts_metafields9ׄ!guts_media #guts_groups&5guts_categorizations1,%+guts_categories/3guts_authorizations7^h     CsAAPagepage2017-03-08 13:56:52.2005562017-03-08 13:56:52.200556  page K aP %;AATest Regulartest_regular@domain.com$2a$10$X34SFdaXprjKrKlX4ZsQsOYn9R1.LCwbGcMIgm4m1mgiu/JczXQxq2017-03-08 13:56:52.2044852017-03-08 13:56:52.204485쩩+ !+AATest Admintest@domain.com$2a$10$A5kulPy5P2GKPkUGCfLabuyycswpw684gQPFGzwp0JEy.5zK61zn21234562017-03-08 13:56:52.2044852017-03-08 13:56:52.204485 PO##AASuper Groupsuper-group2017-03-08 13:56:52.1561952017-03-08 13:56:52.156195 #super-group& BAAA-T&2017-03-08 13:56:52.2027512017-03-08 13:56:52.202751 Y+)AASuper Category!super-category2017-03-08 13:56:52.1495182017-03-08 13:56:52.149518 )super-category/ m] ##3 AATest Page 2test-page-2Test page content 2 K2017-03-08 13:56:52.1526022017-03-08 13:56:52.152602xιo '/ AATest Pagetest-pageone,two,threeTest page content K-T2017-03-08 13:56:52.1526022017-03-08 13:56:52.152602 #test-page-2r#test-pages BiAA/s2017-03-08 13:56:52.1512022017-03-08 13:56:52.151202 vϘa'AA!PeppersGuts::ContentMy dog2017-03-08 13:56:52.1590562017-03-08 13:56:52.159056Pepper.jpgimage/jpg" 'Guts::Contents  T F [ O|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)x=!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) * 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)gI-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) KAATest Navtest-nav2017-03-08 13:56:52.1845362017-03-08 13:56:52.184536 test-nav2 s 22a9 '/ AATest Nav Itemhttp://google.ca/2 s2017-03-08 13:56:52.1808572017-03-08 13:56:52.180857a׀* ''AATest Nav ItemsGuts::Content2 s2017-03-08 13:56:52.1808572017-03-08 13:56:52.180857 'Guts::ContentsU*  iL' gމ -%!AATest Metafield 8Test Value 8,2Guts::Site2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322q -%5AATest Metafield 7Test Value 7U*Guts::NavigationItem2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322mp -%-AATest Metafield 6Test Value 62 sGuts::Navigation2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322kz -%)AATest Metafield 5Test Value 5/Guts::Category2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322hնv -%#AATest Metafield 4Test Value 4&Guts::Group2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322g蝶8 -%!AATest Metafield 3Test Value 3-TGuts::User2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322g⫴X -%!AATest Metafield 2Test Value 2 KGuts::Type2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322fϗ{ )!'AATest MetafieldTest ValuesGuts::Content2017-03-08 13:56:52.1763222017-03-08 13:56:52.176322 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{   Fɭ9AAtest_key1232017-03-08 13:56:52.1894062017-03-08 13:56:52.189406 NNVM%+AAFr Test Sitefr.testsite.com2017-03-08 13:56:52.1960022017-03-08 13:56:52.196002Qb%AATest Sitetestsite.com2017-03-08 13:56:52.1960022017-03-08 13:56:52.196002t  K / r#s 2 s U* 9ׄPnϞp7zv[8JX{ ʊf:l  V  J p V  16`N055?tablear_internal_metadataar_internal_metadata0CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G1[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata1W/u-indexindex_perm_on_permissionable_type_and_permissionableguts_permissions/CREATE INDEX "index_perm_on_permissionable_type_and_permissionable" ON "guts_permissions" ("permissionable_type", "permissionable_id").--_tableguts_permissionsguts_permissions.CREATE TABLE "guts_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissionable_id" integer, "permissionable_type" varchar, "authorization_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)--33tableguts_authorizationsguts_authorizations-CREATE TABLE "guts_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "subject_class" varchar, "subject_id" integer, "action" varchar, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o,=! indexindex_guts_types_on_slugguts_types CREATE INDEX "index_guts_types_on_slug" ON "guts_types" ("slug")+I-%indexindex_guts_navigations_on_slugguts_navigationsCREATE INDEX "index_guts_navigations_on_slug" ON "guts_navigations" ("slug"){*C'indexindex_guts_contents_on_slugguts_contentsCREATE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug")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") yI'%indexindex_guts_trackers_on_site_idguts_trackers)CREATE INDEX "index_guts_trackers_on_site_id" ON "guts_trackers" ("s2 %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")/K!!gtableguts_sitesguts_sites"CREATE TABLE "guts_sites" ("id"0)G+!indexindex_guts_categories_on_slugguts_categoriesCREATE INDEX "index_guts_categories_on_slug" ON "guts_categories" ("slug")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)1m'kindexindex_guts_trackers_on_object_type3[Gindexindex_versions_on_item_type_and_item_idversions CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")2UtableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "event" varchar NOT NULL, "whodunnit" varchar, "object" text(1073741823), "created_at" datetime)   ;;\ԀZ !)AAGuts::TypemanageAll operations2017-03-08 13:56:52.1437452017-03-08 13:56:52.143745^h !)AAEverythingallmanageAll operations2017-03-08 13:56:52.1437452017-03-08 13:56:52.143745 ZN#AA&Guts::Group7^h2017-03-08 13:56:52.1925362017-03-08 13:56:52.192536M"!AA-TGuts::User7^h2017-03-08 13:56:52.1925362017-03-08 13:56:52.192536Mݼ|!AA!uGuts::User7^h2017-03-08 13:56:52.1925362017-03-08 13:56:52.192536 #Guts::Group&7!Guts::User-T;!Guts::User!u| H#AAenvironmenttest2016-12-01 02:16:35.3109812016-12-01 02:16:35.310981 # environment