SQLite format 3@ 8t8-ix33Ytableglobalize_languagesglobalize_languagesCREATE TABLE "globalize_languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_639_1" varchar(2), "iso_639_2" varchar(3), "iso_639_3" varchar(3), "rfc_3066" varchar(255), "english_name" varchar(255), "english_name_locale" varchar(255), "english_name_modifier" varchar(255), "native_name" varchar(255), "native_name_locale" varchar(255), "native_name_modifier" varchar(255), "macro_language" boolean, "direction" varchar(255), "pluralization" varchar(255), "scope" varchar(1))S39indexindex_globalize_countries_on_localeglobalize_countriesCREATE INDEX "index_globalize_countries_on_locale" ON "globalize_countries" ("locale")O31indexindex_globalize_countries_on_codeglobalize_countriesCREATE INDEX "index_globalize_countries_on_code" ON "globalize_countries" ("code")@33'tableglobalize_countriesglobalize_countriesCREATE TABLE "globalize_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(2), "english_name" varchar(255), "date_format" varchar(255), "currency_format" varchar(255), "currency_code" varchar(3), "thousands_sep" varchar(2), "decimal_sep" varchar(2), "currency_decimal_sep" varchar(2), "number_grouping_scheme" varchar(255), "continent" varchar(255), "locale" varchar(255))[!Gindexindex_fms_forums_on_account_id_and_slugfms_forumsCREATE INDEX "index_fms_forums_on_account_id_and_slug" ON "fms_forums" ("account_id", "slug")> !!Gtablefms_forumsfms_forumsCREATE TABLE "fms_forums" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "forum_site_id" integer, "name" varchar(255), "description" text, "forum_topics_count" integer DEFAULT 0, "comments_count" integer DEFAULT 0, "row_order" integer DEFAULT 0, "description_html" text, "published" boolean DEFAULT 'f', "slug" varchar(255), "is_public" boolean DEFAULT 'f', "requires_login" boolean DEFAULT 'f', "forum_category_id" integer, "requires_subscription" boolean DEFAULT 'f', "owner_id" integer, "owner_type" varchar(255))^ q-+indexindex_forum_topics_sticky_last_updated_at_forum_idfms_forum_topics CREATE INDEX "index_forum_topics_sticky_last_updated_at_forum_id" ON "fms_forum_topics" ("account_id", "sticky", "last_updated_at", "forum_id")F c- indexindex_forum_topics_last_updated_at_forum_idfms_forum_topics CREATE INDEX "index_forum_topics_last_updated_at_forum_id" ON "fms_forum_topics" ("account_id", "last_updated_at", "forum_id")Z -indexindex_fms_forum_topics_on_account_id_and_forum_id_and_slugfms_forum_topics CREATE INDEX "index_fms_forum_topics_on_account_id_and_forum_id_and_slug" ON "fms_forum_topics" ("account_id", "forum_id", "slug")| --+tablefms_forum_topicsfms_forum_topics CREATE TABLE "fms_forum_topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "forum_id" integer, "user_id" integer, "title" varchar(255), "created_at" datetime, "updated_at" datetime, "hits" integer DEFAULT 0, "sticky" boolean DEFAULT 'f', "comments_count" integer DEFAULT 0, "locked" boolean DEFAULT 'f', "last_forum_comment_id" integer, "last_updated_at" datetime, "last_user_id" integer, "forum_site_id" integer, "slug" varchar(255))o++tablefms_forum_sitesfms_forum_sites CREATE TABLE "fms_forum_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "enabled" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "forum_topics_count" integer DEFAULT 0, "comments_count" integer DEFAULT 0, "users_count" integer DEFAULT 0, "description" text, "tagline" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("V6f&S D2 6 4p^L:(tbP>, x f T B 0  | j X F 46)201411191120435)201411191120424)201411191120413)201411191120402)201411191120391)201411191120380)20141119112037/)20141119112036.)20141119112035-)20141119112034,)20141119112033+)20141119112032*)20141119112031))20141119112030()20141114170960')20141114170959&)20141114170958%)20141114170957$)20141114170956#)20141114170955")20141114170954!)20141114170953 )20141114170952)20141114170951)20141114170950)20141114170949)20141114170948)20141114170947)20141114170946)20141114170945)20141114170944)20141114170943)20141114170942)20141114170941)20141114170940)20141114170939)20141114170938)20141114170937)20141114170936)20141114170935)20141114170934 )20141114170933 )20141114170932 )20141114170931 )20141114170930 )20141114170929)20141114170928)20141114170927)20140423113420)20140303121325)20140201112134)20130430084925)20130424125513)20130103151149 6 |iVC0 r_L9& { h U B /  q ^ K 8 %  )201411191120436)201411191120425)201411191120414)201411191120403)201411191120392)201411191120381)201411191120370)20141119112036/)20141119112035.)20141119112034-)20141119112033,)20141119112032+)20141119112031*)20141119112030))20141114170960()20141114170959')20141114170958&)20141114170957%)20141114170956$)20141114170955#)20141114170954")20141114170953!)20141114170952 )20141114170951)20141114170950)20141114170949)20141114170948)20141114170947)20141114170946)20141114170945)20141114170944)20141114170943)20141114170942)20141114170941)20141114170940)20141114170939)20141114170938)20141114170937)20141114170936)20141114170935)20141114170934)20141114170933 )20141114170932 )20141114170931 )20141114170930 )20141114170929 )20141114170928)20141114170927)20140423113420)20140303121325)20140201112134)20130430084925)20130424125513) 20130103151149              <f/ Q H 33Ytableglobalize_languagesgq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)o++tablefms_forum_sitesfms_forum_sites CREATE TABLE "fms_forum_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "enabled" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "forum_topics_count" integer DEFAULT 0, "comments_count" integer DEFAULT 0, "users_count" integer DEFAULT 0, "description" text, "tagline" text)| --+tablefms_forum_topicsfms_forum_topics CREATE TABLE "fms_forum_topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "forum_id" integer, "user_id" integer, "title" varchar(255), "created_at" datetime, "updated_at" datetime, "hits" integer DEFAULT 0, "sticky" boolean DEFAULT 'f', "comments_count" integer DEFAULT 0, "locked" boolean DEFAULT 'f', "last_forum_comment_id" integer, "last_updated_at" datetime, "last_user_id" integer, "forum_site_id" integer, "slug" varchar(255))Z -indexindex_fms_forum_topics_on_account_id_and_forum_id_and_slugfms_forum_topics CREATE INDEX "index_fms_forum_topics_on_account_id_and_forum_id_and_slug" ON "fms_forum_topics" ("account_id", "forum_id", "slug")F c- indexindex_forum_topics_last_updated_at_forum_idfms_forum_topics CREATE INDEX "index_forum_topics_last_updated_at_forum_id" ON "fms_forum_topics" ("account_id", "last_updated_at", "forum_id")^ q-+indexindex_forum_topics_sticky_last_updated_at_forum_idfms_forum_topics CREATE INDEX "index_forum_topics_sticky_last_updated_at_forum_id" ON "fms_forum_topics" ("account_id", "sticky", "last_updated_at", "forum_id")> !!Gtablefms_forumsfms_forumsCREATE TABLE "fms_forums" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "forum_site_id" integer, "name" varchar(255), "description" text, "forum_topics_count" integer DEFAULT 0, "comments_count" integer DEFAULT 0, "row_order" integer DEFAULT 0, "description_html" text, "published" boolean DEFAULT 'f', "slug" varchar(255), "is_public" boolean DEFAULT 'f', "requires_login" boolean DEFAULT 'f', "forum_category_id" integer, "requires_subscription" boolean DEFAULT 'f', "owner_id" integer, "owner_type" varchar(255))[!Gindexindex_fms_forums_on_account_id_and_slugfms_forumsCREATE INDEX "index_fms_forums_on_account_id_and_slug" ON "fms_forums" ("account_id", "slug")@33'tableglobalize_countriesglobalize_countriesCREATE TABLE "globalize_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(2), "english_name" varchar(255), "date_format" varchar(255), "currency_format" varchar(255), "currency_code" varchar(3), "thousands_sep" varchar(2), "decimal_sep" varchar(2), "currency_decimal_sep" varchar(2), "number_grouping_scheme" varchar(255), "continent" varchar(255), "locale" varchar(255))O31indexindex_globalize_countries_on_codeglobalize_countriesCREATE INDEX "index_globalize_countries_on_code" ON "globalize_countries" ("code")S39indexindex_globalize_countries_on_localeglobalize_countriesCREATE INDEX "index_globalize_countries_on_locale" ON "globalize_countries" ("locale")33Ytableglobalize_languagesglobalize_languagesCREATE TABLE "globalize_languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_639_1" varchar(2), "iso_639_2" varchar(3), "iso_639_3" varchar(3), "rfc_3066" varchar(255), "english_name" varchar(255), "english_name_locale" varchar(255), "english_name_modifier" varchar(255), "native_name" varchar(255), "native_name_locale" varchar(255), "native_name_modifier" varchar(255), "macro_language" boolean, "direction" varchar(255), "pluralization" varchar(255), "scope" varchar(1)) vve[y 2 Y HP''Ytablecor"Y3Eindexindex_glob"Y3Eindexindex_globalize_languages_on_iso_639_1globalize_languagesCREATE INDEX "index_globalize_languages_on_iso_639_1" ON "globalize_languages" ("iso_639_1")"Y3Eindexindex_globalize_languages_on_iso_639_2globalize_languagesCREATE INDEX "index_globalize_languages_on_iso_639_2" ON "globalize_languages" ("iso_639_2")"Y3Eindexindex_globalize_languages_on_iso_639_3globalize_languagesCREATE INDEX "index_globalize_languages_on_iso_639_3" ON "globalize_languages" ("iso_639_3")W3Aindexindex_globalize_languages_on_rfc_3066globalize_languagesCREATE INDEX "index_globalize_languages_on_rfc_3066" ON "globalize_languages" ("rfc_3066")k5tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "resource_id" integer, "resource_type" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer)d##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)Z3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")?w}indexindex_roles_on_name_and_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")m$?indexindex_roles_on_account_idroles#CREATE INDEX "index_roles_on_account_id" ON "roles" ("account_id")A%##Itablepreferencespreferences$CREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "owner_id" integer NOT NULL, "owner_type" varchar(255) NOT NULL, "group_id" integer, "group_type" varchar(255), "value" varchar(255), "created_at" datetime, "updated_at" datetime)`&q#9indexindex_preferences_on_owner_and_name_and_preferencepreferences%CREATE UNIQUE INDEX "index_preferences_on_owner_and_name_and_preference" ON "preferences" ("owner_id", "owner_type", "name", "group_id", "group_type")~+++3tablecore_activitiescore_activities+CREATE TABLE "core_activities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "user_id" integer, "browser" varchar(255), "session_id" varchar(255), "ip_address" varchar(255), "controller" varchar(255), "action" varchar(255), "params" varchar(255), "slug" varchar(255), "lesson" varchar(255), "created_at" datetime),S+9indexindex_core_activities_on_account_idcore_activities,CREATE INDEX "index_core_activities_on_account_id" ON "core_activities" ("account_id") -M+-indexindex_core_activities_on_user_idcore_activities-CREATE INDEX "index_core_activities_on_user_id" ON "core_activities" ("user_id")..''tablecore_commentscore_comments'CREATE TABLE "core_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(50) DEFAULT '', "body" text, "commentable_id" integer, "commentable_type" varchar(255), "user_id" integer, "role" varchar(255) DEFAULT 'comments', "account_id" integer, "created_at" datetime, "updated_at" datetime, "type" varchar(255), "ancestry" varchar(255), "ancestry_depth" integer DEFAULT 0)/['Iindexindex_core_comments_on_commentable_typecore_comments(CREATE INDEX "index_core_comments_on_commentable_type" ON "core_comments" ("commentable_type")0W'Aindexindex_core_comments_on_commentable_idcore_comments)CREATE INDEX "index_core_comments_on_commentable_id" ON "core_comments" ("commentable_id")1I'%indexindex_core_comments_on_user_idcore_comments*CREATE INDEX "index_core_comments_on_user_id" ON "core_comments" ("user_id").2AAgtablecore_category_translationscore_category_translations.CREATE TABLE "core_category_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_category_id" integer, "locale" varchar(255), "name" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)              aa$A 5 Y 3AAIindexindex_category_translationcore_category_translations/CREATE INDEX "index_category_translation" ON "core_category_translations" ("core_category_id")i4++ tablecore_categoriescore_categories0CREATE TABLE "core_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "row_order" integer, "account_id" integer, "created_on" datetime, "updated_on" datetime)25II_tablecore_system_email_translationscore_system_email_translations1CREATE TABLE "core_system_email_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_system_email_id" integer, "locale" varchar(255), "subject" varchar(255), "body" text, "created_at" datetime, "updated_at" datetime)611_tablecore_system_emailscore_system_emails2CREATE TABLE "core_system_emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email_type" varchar(255), "emailable_id" integer, "emailable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer) 8stableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "confirmation_token" varchar(255), "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer)e95 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email"):SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") ;O?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")m<?indexindex_users_on_account_idusers"CREATE INDEX "index_users_on_account_id" ON "users" ("account_id") C11?tableuser_site_profilesuser_site_profiles;CREATE TABLE "user_site_profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "last_access_at" datetime, "created_at" datetime, "updated_at" datetime, "account_id" integer, "uuid" varchar(40))(D''tableuser_profilesuser_profiles3CREATE TABLE "user_profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "public_name" varchar(50) DEFAULT '', "first_name" varchar(50) DEFAULT '', "last_name" varchar(50) DEFAULT '', "address" varchar(70) DEFAULT '', "address2" varchar(70) DEFAULT '', "city" varchar(30) DEFAULT '', "state" varchar(30) DEFAULT '', "zipcode" varchar(10) DEFAULT '', "country_id" integer DEFAULT 0, "phone" varchar(20) DEFAULT '', "cell" varchar(20) DEFAULT '', "fax" varchar(20) DEFAULT '', "workphone" varchar(20) DEFAULT '', "website" varchar(50) DEFAULT '', "gender" varchar(1) DEFAULT '', "status" integer DEFAULT 0, "lock_version" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "account_id" integer, "email" varchar(255), "public_avatar" varchar(255), "public_avatar_file_size" integer, "public_avatar_content_type" varchar(255), "private_avatar" varchar(255), "private_avatar_file_size" integer, "private_avatar_content_type" varchar(255), "use_private_avatar_for_public" boolean DEFAULT 'f')      z!l  a ;GC3AAIindexindex_category_translationcore_category_translations/CREATE INDEX "index_category_t1I'%indexindex_core_comments_on_user_idcore_comments*C,E99stablecore_payment_historiescore_payment_histories4CREATE TABLE "core_payment_histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(30), "anchor_id" varchar(20), "order_ref",E99stablecore_payment_historiescore_payment_histories4CREATE TABLE "core_payment_histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(30), "anchor_id" varchar(20), "order_ref" varchar(255), "item_ref" varchar(255), "item_name" varchar(255), "quantity" integer, "cost" varchar(255), "discount" varchar(255), "total_cents" integer, "total_currency" varchar(3), "payment_method" varchar(255), "payment_date" datetime, "bill_to_name" varchar(255), "item_details" text, "order_details" text, "status" varchar(255), "user_profile_id" integer, "created_on" datetime, "account_id" integer, "notify_data" text, "transaction_id" varchar(255))$FU9Gindexindex_payment_histories_on_anchor_idcore_payment_histories5CREATE INDEX "index_payment_histories_on_anchor_id" ON "core_payment_histories" ("anchor_id")!GS9Cindexindex_payment_histories_on_item_refcore_payment_histories7CREATE INDEX "index_payment_histories_on_item_ref" ON "core_payment_histories" ("item_ref")$HU9Gindexindex_payment_histories_on_order_refcore_payment_histories8CREATE INDEX "index_payment_histories_on_order_ref" ON "core_payment_histories" ("order_ref")!IS9Cindexindex_payment_histories_on_owner_idcore_payment_histories9CREATE INDEX "index_payment_histories_on_owner_id" ON "core_payment_histories" ("owner_id")'JW9Kindexindex_payment_histories_on_owner_typecore_payment_histories:CREATE INDEX "index_payment_histories_on_owner_type" ON "core_payment_histories" ("owner_type")4KGtablevotesvotesCREATE INDEX "index_votes_on_votable_id_and_votable_type_and_vote_scope" ON "votes" ("votable_id", "votable_type", "vote_scope")NM1-indexindex_user_site_profiles_on_uuiduser_site_profiles?CREATE INDEX "index_user_site_profiles_on_uuid" ON "user_site_profiles" ("uuid")KOmtablefollowsfollows@CREATE TABLE "follows" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "followable_id" integer NOT NULL, "followable_type" varchar(255) NOT NULL, "follower_id" integer NOT NULL, "follower_type" varchar(255) NOT NULL, "blocked" boolean DEFAULT 'f' NOT NULL, "created_at" datetime, "updated_at" datetime)eP!indexfk_followsfollowsACREATE INDEX "fk_follows" ON "follows" ("follower_id", "follower_type")qQ)+indexfk_followablesfollowsBCREATE INDEX "fk_followables" ON "follows" ("followable_id", "followable_type")XR''otablecore_accountscore_accounts!CREATE TABLE "core_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "company_name" varchar(255), "contact_email" varchar(255), "domain" varchar(255), "account_prefix" varchar(255), "default_site_id" integer, "created_at" datetime, "updated_at" datetime, "next_invoice_num" integer DEFAULT 1000)gS)) tablecore_addressescore_addressesCCREATE TABLE "core_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "line1" varchar(255), "line2" varchar(255), "city" varchar(255), "state" varchar(255), "zip" varchar(255), "country_code" varchar(2), "addressable_id" integer, "addressable_type" varchar(255), "created_at" datetime, "updated_at" datetime)    )('           :98764'BW9Kindexindex_payment_histories_on_owner_typecore_payment_histories:CREATE INDEX "index_payment_histories_on_owner_type" ON "core_payment_histories" ("owner_type") S9Cindexindex_payment_histories_on_owner_idcore_payment_histories9CREATE INDEX "index_payment_histories_on_owner_id" ON "core_payment_histories" ("owner_id") U9Gindexindex_payment_histories_on_order_refcore_payment_histories8CREATE INDEX "index_payment_histories_on_order_ref" ON "core_payment_histories" ("order_ref") KS9Cindexindex_payment_histories_on_item_refcore_payment_histories7CREATE INDEX "index_payment_histories_on_item_ref" ON "core_payment_histories" ("item_ref") U9Gindexindex_payment_histories_on_anchor_idcore_payment_histories6CREATE INDEX "index_payment_histories_on_anchor_id" ON "core_payment_histories" ("anchor_id") 8stableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "confirmation_token" varchar(255), "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer)e95 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email"):SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") ;O?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")m<?indexindex_users_on_account_idusers"CREATE INDEX "index_users_on_account_id" ON "users" ("account_id")99tablecore_payment_historiescore_payment_histories4CREATE TABLE "core_payment_histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(30), "anchor_id" integer, "order_ref" varchar(255), "item_ref" varchar(255), "item_name" varchar(255), "quantity" integer, "cost" varchar(255), "discount" varchar(255), "total_cents" integer, "total_currency" varchar(3), "payment_method" varchar(255), "payment_date" datetime, "bill_to_name" varchar(255), "item_details" text, "order_details" text, "current_stage" varchar(255), "user_profile_id" integer, "created_on" datetime, "account_id" integer) "28s M m FG`QQytablecore_custom_field_def_translationscore_customUeindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingcT)%indexindex_core_addresses_on_addressable_type_and_addressable_idcore_addressesDCREATE UNIQUE INDEX "index_core_addresses_on_addressable_type_and_addressable_id" ON "core_addresses" ("addressable_type", "addressable_id")8UCtableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime, "object_changes" mediumtext, "locale" varchar(255))V[Gindexindex_versions_on_item_type_and_item_idversionsECREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")W tabletagstagsFCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "taggings_count" integer DEFAULT 0) XmtabletaggingstaggingsGCREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(128), "created_at" datetime)^[1indexindex_tags_on_nametagsJCREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")#\%indextaggings_idxtaggingsICREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")]99#tablecore_custom_field_defscore_custom_field_defsHCREATE TABLE "core_custom_field_defs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(255), "name" varchar(255), "field_type" varchar(255), "row_order" integer, "required" boolean DEFAULT 'f', "properties" varchar(2048), "created_at" datetime, "updated_at" datetime, "account_id" integer)1^a9Uindexindex_core_custom_field_defs_on_account_idcore_custom_field_defsKCREATE INDEX "index_core_custom_field_defs_on_account_id" ON "core_custom_field_defs" ("account_id")W_{9indexindex_core_custom_field_defs_on_owner_id_and_owner_typecore_custom_field_defsLCREATE INDEX "index_core_custom_field_defs_on_owner_id_and_owner_type" ON "core_custom_field_defs" ("owner_id", "owner_type")G`QQytablecore_custom_field_def_translationscore_custom_field_def_translationsMCREATE TABLE "core_custom_field_def_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_custom_field_def_id" integer, "locale" varchar(255), "label" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime)Sa]Qindexcore_custom_field_def_translations_indexcore_custom_field_def_translationsNCREATE INDEX "core_custom_field_def_translations_index" ON "core_custom_field_def_translations" ("core_custom_field_def_id")2b11tablecore_custom_fieldscore_custom_fieldsOCREATE TABLE "core_custom_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(255), "custom_field_def_id" integer, "field_data" varchar(4096), "created_at" datetime, "updated_at" datetime, "account_id" integer)!cY1Eindexindex_core_custom_fields_on_account_idcore_custom_fieldsPCREATE INDEX "index_core_custom_fields_on_account_id" ON "core_custom_fields" ("account_id")Gds1windexindex_core_custom_fields_on_owner_id_and_owner_typecore_custom_fieldsQCREATE INDEX "index_core_custom_fields_on_owner_id_and_owner_type" ON "core_custom_fields" ("owner_id", "owner_type")Ueindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsRCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")fEE-tablecms_contentitem_translationscms_contentitem_translationsSCREATE TABLE "cms_contentitem_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_contentitem_id" integer, "locale" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)    98754              I              @@<t I e mtablecms_blogscms_blogshCREATE TMgiEyindexindex_072c3a76f87c96e2f91149eccd2a283dca2b613fcms_contentitem_translationsTCREATE INDEX "index_072c3a76f87c96e2f91149eccd2a283dca2b613f" ON "cms_contentitem_translations" ("cms_contentitem_id"))j77qtablecms_page_translationscms_page_translationsXCREATE TABLE "cms_page_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_page_id" integer, "locale" varchar(255), "title" varchar(255), "menutitle" varchar(255), "created_at" datetime, "updated_at" datetime, "summary" text)0ka7Uindexindex_cms_page_translations_on_cms_page_idcms_page_translationsYCREATE INDEX "index_cms_page_translations_on_cms_page_id" ON "cms_page_translations" ("cms_page_id")q==tablecms_snippet_translationscms_snippet_translations_CREATE TABLE "cms_snippet_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_snippet_id" integer, "locale" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)Erm=mindexindex_cms_snippet_translations_on_cms_snippet_idcms_snippet_translations`CREATE INDEX "index_cms_snippet_translations_on_cms_snippet_id" ON "cms_snippet_translations" ("cms_snippet_id")x77tablecms_blog_translationscms_blog_translationsfCREATE TABLE "cms_blog_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_blog_id" integer, "locale" varchar(255), "title" varchar(255), "created_at" datetime, "updated_at" datetime)0ya7Uindexindex_cms_blog_translations_on_cms_blog_idcms_blog_translationsgCREATE INDEX "index_cms_blog_translations_on_cms_blog_id" ON "cms_blog_translations" ("cms_blog_id")}77]tablecms_post_translationscms_post_translationslCREATE TABLE "cms_post_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_post_id" integer, "locale" varchar(255), "title" varchar(255), "content" text, "summary" text, "created_at" datetime, "updated_at" datetime)0~a7Uindexindex_cms_post_translations_on_cms_post_idcms_post_translationsmCREATE INDEX "index_cms_post_translations_on_cms_post_id" ON "cms_post_translations" ("cms_post_id") %%Ytablecms_snippetscms_snippetsaCREATE TABLE "cms_snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "itemtype" varchar(30) DEFAULT 'markdown', "slug" varchar(255), "description" varchar(255), "enable_cache" boolean DEFAULT 't' NOT NULL, "published" boolean DEFAULT 't' NOT NULL, "created_on" datetime, "updated_on" datetime, "lock_version" integer DEFAULT 0, "account_id" integer) M%-indexindex_cms_snippets_on_account_idcms_snippetseCREATE INDEX "index_cms_snippets_on_account_id" ON "cms_snippets" ("account_id")wA%indexindex_cms_snippets_on_slugcms_snippetsqCREATE INDEX "index_cms_snippets_on_slug" ON "cms_snippets" ("slug") --Gtablecms_contentitemscms_contentitemsUCREATE TABLE "cms_contentitems" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_page_id" integer, "itemtype" varchar(30) DEFAULT 'textile', "container" varchar(30), "row_order" integer DEFAULT 0, "enable_cache" boolean DEFAULT 't' NOT NULL, "created_on" datetime, "updated_on" datetime, "lock_version" integer DEFAULT 0, "account_id" integer)Q-;indexcms_contentitems_cms_page_id_indexcms_contentitemsWCREATE INDEX "cms_contentitems_cms_page_id_index" ON "cms_contentitems" ("cms_page_id")U-=indexindex_cms_contentitems_on_account_idcms_contentitemsdCREATE INDEX "index_cms_contentitems_on_account_id" ON "cms_contentitems" ("account_id")X++gtablecms_media_filescms_media_filesbCREATE TABLE "cms_media_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "media" varchar(255), "media_file_size" integer, "media_content_type" varchar(255), "folder" varchar(255), "generate_retina" boolean, "user_id" integer, "created_at" datetime, "updated_at" datetime, "account_id" integer)            c^]\[Z ^]\[Z  ba    ^sE    /T%sindexblogname_keycms_blogsjCRT%sindexpostname_keycms_postsoCREATE INDEX "postname_key" ON "cms_posts" ("slug") tablecms_postscms_postsnCREATE TABLE "cms_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "cms_blog_id" integer, "featured_image" varchar(255), "published_on" datetime, "updated_on" datetime, "created_on" datetime, "account_id" integer, "lock_version" integer DEFAULT 0 NOT NULL, "notification_sent_on" datetime, "comments_count" integer DEFAULT 0, "comments_allowed" boolean)Q-;indexcms_contentitems_#G+aindexindex_media_folder_account_idcms_media_filesrCREATE UNIQUE INDEX "index_media_folder_account_id" ON "cms_media_files" ("media", "folder", "account_id")3CCmtablecms_media_file_translationscms_media_file_translationssCREATE TABLE "cms_media_file_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_media_file_id" integer, "locale" varchar(255), "title" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)ZyCindexindex_cms_media_file_translations_on_cms_media_file_idcms_media_file_translationstCREATE INDEX "index_cms_media_file_translations_on_cms_media_file_id" ON "cms_media_file_translations" ("cms_media_file_id")Nktablecms_pagescms_pagesZCREATE TABLE "cms_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(50) DEFAULT '' NOT NULL, "pagetype" varchar(20) DEFAULT 'content' NOT NULL, "published" boolean DEFAULT 'f' NOT NULL, "template" varchar(50) DEFAULT '' NOT NULL, "link" varchar(255) DEFAULT '' NOT NULL, "menuimage" varchar(255), "requires_login" boolean DEFAULT 'f', "ancestry" varchar(255), "ancestry_depth" integer DEFAULT 0, "updated_on" datetime, "created_on" datetime, "lock_version" integer DEFAULT 0 NOT NULL, "account_id" integer, "requires_subscription" boolean DEFAULT 'f', "is_public" boolean DEFAULT 't', "row_order" integer, "featured_image" varchar(255), "header_image" varchar(255))T%sindexpagename_keycms_pages[CREATE INDEX "pagename_key" ON "cms_pages" ("slug")wCindexindex_cms_pages_on_ancestrycms_pages\CREATE INDEX "index_cms_pages_on_ancestry" ON "cms_pages" ("ancestry") O1indexindex_cms_pages_on_ancestry_depthcms_pages]CREATE INDEX "index_cms_pages_on_ancestry_depth" ON "cms_pages" ("ancestry_depth")t?indexcms_pages_published_indexcms_pages^CREATE INDEX "cms_pages_published_index" ON "cms_pages" ("published")}G!indexindex_cms_pages_on_account_idcms_pagescCREATE INDEX "index_cms_pages_on_account_id" ON "cms_pages" ("account_id")"tablecms_blogscms_blogshCREATE TABLE "cms_blogs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "published" boolean DEFAULT 'f', "is_public" boolean DEFAULT 'f', "requires_login" boolean DEFAULT 'f', "row_order" integer, "updated_on" datetime, "created_on" datetime, "account_id" integer, "lock_version" integer DEFAULT 0 NOT NULL, "comments_allowed" boolean, "header_image" varchar(255), "requires_subscription" boolean DEFAULT 'f', "owner_id" integer, "owner_type" varchar(255), "image_email_header" varchar(255))T%sindexblogname_keycms_blogsjCREATE INDEX "blogname_key" ON "cms_blogs" ("slug")t?indexcms_blogs_published_indexcms_blogskCREATE INDEX "cms_blogs_published_index" ON "cms_blogs" ("published") tablecms_postscms_postsnCREATE TABLE "cms_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "cms_blog_id" integer, "featured_image" varchar(255), "published_on" datetime, "updated_on" datetime, "created_on" datetime, "account_id" integer, "lock_version" integer DEFAULT 0 NOT NULL, "notification_sent_on" datetime, "comments_count" integer DEFAULT 0, "comments_allowed" boolean)T%sindexpostname_keycms_postsoCREATE INDEX "postname_key" ON "cms_posts" ("slug")w?indexcms_posts_published_indexcms_postspCREATE INDEX "cms_posts_published_index" ON "cms_posts" ("published_on")  jh     on