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 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                     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)                   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)