SQLite format 3 @ 4 / h 4 - - F[ gb+9% 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)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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "type_id" integer, "user_id" integer)C''indexindex_guts_contents_on_slugguts_contentsCREATE UNIQUE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug") )I'%indexindex_guts_contents_on_user_idguts_contentsCREATE INDEX "index_guts_contents_on_user_id" ON "guts_contents" ("user_id")I'%indexindex_guts_contents_on_type_idguts_contentsCREATE INDEX "index_guts_contents_on_type_id" ON "guts_contents" ("type_id") 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_usersCREATE 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_typesCREATE 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 8 + 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 W +fw> + guts_metafields 'guts_contents5 guts_categorizations guts_media ! guts_sites !guts_media- guts_user_groups ! guts_users# guts_groups guts_cat +guts_categories!guts_types'guts_trackers x x B AAPostpost2016-03-09 03:02:56.0431142016-03-09 03:02:56.043114B AAPagepage2016-03-09 03:02:56.0199172016-03-09 03:02:56.019917 post page b b != AATyler Kingtyler.n.king@outlook.com$2a$10$cVtVy96nHCUuwK/2sXP6J.7rcdqr9/m9RzRpE6JawmcTgrXqebrWC2016-03-09 04:05:06.4388342016-03-09 04:05:06.438834 F AAAdminsadmins2016-03-09 03:02:56.0727482016-03-09 03:02:56.072748 admins : AA2016-03-09 04:05:06.4408682016-03-09 04:05:06.440868 [ [ q g AA Demo Catdemo-cat-af5c7f96-af2e-4a73-ada0-449760fb02932016-08-14 22:34:02.2661092016-08-14 22:34:02.266109L AA Demo Catdemo-cat2016-06-27 04:21:50.4511672016-06-27 04:21:50.451167U '' AAUncategorizeduncategorized2016-03-09 03:02:56.0576782016-03-09 03:02:56.057678 1gdemo-cat-af5c7f96-af2e-4a73-ada0-449760fb0293demo-cat' uncategorized @ @ b - AA Next Homenext-home
Demo Home
2016-08-14 22:42:18.0902242016-08-14 22:42:18.090224Z 1 AA Homehomecontentrr!!
2016-03-09 04:37:30.1698012016-04-18 22:32:12.765889 next-home home : AA2016-06-27 04:24:22.4035692016-06-27 04:24:22.403569 b ' AA#!A CoolioGuts::Content2016-08-14 22:53:47.2526912016-08-14 22:53:47.2526910r0slLL.jpgimage/jpegd2016-08-14 22:53:45.611076 ! AA]A Paris 23002016-04-18 22:26:42.9736032016-04-18 22:26:42.973603Screen_Shot_2016-04-06_at_4.28.49_PM.pngimage/png) 2016-04-18 22:26:39.487963 F[ O| *b f L''Wtableguts_contentsguts_contentsCRE9/m'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_)+!!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) !!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)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) T G+/O-%%atableguts_optionsguts_options$CREATE TABLE "guts_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar, "value" text, "createk"!!!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)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_usersCREATE 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) [=!indexindex_guts_types_on_slugguts_typesCREATE UNIQUE INDEX ".''ctableguts_trackersguts_trackers"CREATE 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))_/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) *C * :E e]kU l DM+-indexindex_guts_metafields_on_site_idguts_metafields+CREATE INDEX "index_guts_metafields_on_site_id" ON "guts_metafields" ("site_id")0++qtableguts_metafieldsguts_metafields CREATE 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)XY7Eindexindex_guts_navigation_items_on_site_idguts_navigation_items*CREATE INDEX "index_guts_navigation_items_on_site_id" ON "guts_navigation_items" ("site_id")BO-1indexindex_guts_navigations_on_site_idguts_navigations)CREATE INDEX "index_guts_navigations_on_site_id" ON "guts_navigations" ("site_id")AI'%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&CREb-%%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)9/m'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_trackers"CREATE 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) %%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)3,k!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")8C''indexindex_guts_contents_on_slugguts_contentsCREATE UNIQUE INDEX "index_guts_contents_on_slug" ON "guts_contents" ("slug")L7''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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "type_id" integer, "user_id" integer, "site_id" integer)6I-3indexindex_guts_navigations_on_slugguts_navigationsCREATE UNIQUE INDEX "index_guts_navigations_on_slug" ON "guts_navigations" ("slug")r5--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)64e7]indexindex_guts_navigation_items_on_navigation_idguts_navigation_itemsCREATE INDEX "index_guts_navigation_items_on_navigation_id" ON "guts_navigation_items" ("navigation_id")A3[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")p277tableguts_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "navigation_id" integer, "site_id" integer)S1}+indexindex_guts_metafields_on_fieldable_type_and_fieldable_idguts_metafields!CREATE INDEX "index_guts_metafields_on_fieldable_type_and_fieldable_id" ON "guts_metafields" ("fieldable_type", "fieldable_id") ' Guts::Content ] # 'AA Cool KeyTest
Guts::Content2016-08-14 22:59:19.0662382016-08-14 22:59:19.066238 ' Guts::Content _j o S` ; =<: R %AA Guts::Medium{}create2016-08-14 22:53:47.2670712016-08-14 22:53:47.267071S 'AA Guts::Content{}create2016-08-14 22:42:18.1012422016-08-14 22:42:18.101242U )AA Guts::Category{}destroy2016-08-14 22:34:31.7164902016-08-14 22:34:31.716490T )AA Guts::Category{}create2016-08-14 22:34:02.2695252016-08-14 22:34:02.269525U )AA Guts::Category{}destroy2016-08-14 22:33:01.3106882016-08-14 22:33:01.310688T )AA Guts::Category{}create2016-08-14 22:32:34.3135742016-08-14 22:32:34.313574R 'AA Guts::Content{}update2016-06-27 04:24:22.4069292016-06-27 04:24:22.406929T )AA Guts::Category{}create2016-06-27 04:21:50.4690442016-06-27 04:21:50.469044R 'AA Guts::Content{}update2016-04-18 22:33:35.0943252016-04-18 22:33:35.094325R 'AA Guts::Content{}update2016-04-18 22:32:12.7818502016-04-18 22:32:12.781850Q %AA Guts::Medium{}create2016-04-18 22:26:42.9782802016-04-18 22:26:42.978280R 'AA Guts::Content{}update2016-04-18 22:25:45.8971862016-04-18 22:25:45.897186| !kAA Guts::Site{"name":["French Domaina","Guts: French Site"]}update2016-04-13 13:17:26.8126372016-04-13 13:17:26.812637O !AA Guts::Site{}update2016-04-10 21:06:33.1706322016-04-10 21:06:33.170632O !AA Guts::Site{}update2016-04-10 21:06:32.2003272016-04-10 21:06:32.200327O !AA Guts::Site{}update2016-04-10 21:06:28.8967392016-04-10 21:06:28.896739O !AA Guts::Site{}update2016-04-10 21:06:25.4539852016-04-10 21:06:25.453985x !cAA Guts::Site{"name":["French Domain","French Domaina"]}update2016-04-10 20:42:43.8005122016-04-10 20:42:43.800512O !AA Guts::Site{}create2016-04-10 20:41:43.9965242016-04-10 20:41:43.996524S )AA Guts::Category{}update2016-04-10 20:24:43.3767662016-04-10 20:24:43.376766Q 'AAGuts::Content{}update2016-03-09 04:37:38.1115822016-03-09 04:37:38.111582Q 'AAGuts::Content{}create2016-03-09 04:37:30.1820882016-03-09 04:37:30.182088N !AAGuts::User{}create2016-03-09 04:05:06.4513632016-03-09 04:05:06.451363O #AAGuts::Group{}create2016-03-09 03:02:56.0745842016-03-09 03:02:56.074584R )AAGuts::Category{}create2016-03-09 03:02:56.0594912016-03-09 03:02:56.059491O !AAGuts::Type{}create2016-03-09 03:02:56.0448842016-03-09 03:02:56.044884N !AAGuts::Type{}create2016-03-09 03:02:56.0402172016-03-09 03:02:56.040217 qydO:&aQA1! %Guts::Medium'Guts::Content)Guts::Category)Guts::Category)Guts::Category)Guts::Category' Guts::Content)Guts::Category' Guts::Content' Guts::Content% Guts::Medium' Guts::Content! Guts::Site! Guts::Site! Guts::Site ! Guts::Site! Guts::Site! Guts::Site ! Guts::Site ) Guts::Category' Guts::Content' Guts::Content! Guts::User# Guts::Group) Guts::Category!Guts::Type! Guts::Type Z /'AAGuts: French Sitefr.guts.local2016-04-10 20:41:43.9809872016-04-13 13:17:26.796313f z z ( y `} u ;%( xGC!indexindex_guts_media_on_site_idguts_media/CREATE INDEX "index_guts_media_on_site_id" ON "guts_media" ("site_id") FG%!indexindex_guts_options_on_site_idguts_options.CREATE INDEX "index_guts_options_on_site_id" ON "guts_options" ("site_id")EI'%indexindex_guts_trackers_on_site_idguts_trackers,CREATE INDEX "index_guts_trackers_on_site_id" ON "guts_trackers" ("site_id")DM+-indexindex_guts_metafields_on_site_idguts_metafields+CREATE INDEX "index_guts_metafields_on_site_id" ON "guts_metafields" ("site_id")$CY7Eindexindex_guts_navigation_items_on_site_idguts_navigation_items*CREATE INDEX "index_guts_navigation_items_on_site_id" ON "guts_navigation_items" ("site_id")BO-1indexindex_guts_navigations_on_site_idguts_navigations)CREATE INDEX "index_guts_navigations_on_site_id" ON "guts_navigations" ("site_id")AI'%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")v>=!indexindex_guts_types_on_slugguts_typesCREATE 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) <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):I'%indexindex_guts_contents_on_user_idguts_contentsCREATE INDEX "index_guts_contents_on_user_id" ON "guts_contents" ("user_id")9I'%indexindex_guts_contents_on_type_idguts_contentsCREATE INDEX "index_guts_contents_on_type_id" ON "guts_contents" ("type_id") - - - * ) ( ' &