SQLite format 3@ IOHI- J  m/hS]Qindexcore_custom_field_def_translations_indexcore_custom_field_def_translationsCREATE INDEX "core_custom_field_def_translations_index" ON "core_custom_field_def_translations" ("core_custom_field_def_id")=QQetablecore_custom_field_def_translationscore_custom_field_def_translationsCREATE TABLE "core_custom_field_def_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_custom_field_def_id" integer, "locale" varchar, "label" varchar, "description" text, "created_at" datetime, "updated_at" datetime)I'%indexindex_core_comments_on_user_idcore_commentsCREATE INDEX "index_core_comments_on_user_id" ON "core_comments" ("user_id") ['Iindexindex_core_comments_on_commentable_typecore_commentsCREATE INDEX "index_core_comments_on_commentable_type" ON "core_comments" ("commentable_type") W'Aindexindex_core_comments_on_commentable_idcore_comments CREATE INDEX "index_core_comments_on_commentable_id" ON "core_comments" ("commentable_id") ''stablecore_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, "user_id" integer, "role" varchar DEFAULT 'comments', "account_id" integer, "created_at" datetime, "updated_at" datetime, "type" varchar, "ancestry" varchar, "ancestry_depth" integer DEFAULT 0) AAIindexindex_category_translationcore_category_translations CREATE INDEX "index_category_translation" ON "core_category_translations" ("core_category_id") AAItablecore_category_translationscore_category_translations CREATE TABLE "core_category_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_category_id" integer, "locale" varchar, "name" varchar, "description" varchar, "created_at" datetime, "updated_at" datetime)d++tablecore_categoriescore_categories CREATE TABLE "core_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "row_order" integer, "account_id" integer, "created_on" datetime, "updated_on" datetime)c)%indexindex_core_addresses_on_addressable_type_and_addressable_idcore_addressesCREATE UNIQUE INDEX "index_core_addresses_on_addressable_type_and_addressable_id" ON "core_addresses" ("addressable_type", "addressable_id")I))Mtablecore_addressescore_addressesCREATE TABLE "core_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "line1" varchar, "line2" varchar, "city" varchar, "state" varchar, "zip" varchar, "country_code" varchar(2), "addressable_id" integer, "addressable_type" varchar, "created_at" datetime, "updated_at" datetime) M+-indexindex_core_activities_on_user_idcore_activitiesCREATE INDEX "index_core_activities_on_user_id" ON "core_activities" ("user_id")S+9indexindex_core_activities_on_account_idcore_activitiesCREATE INDEX "index_core_activities_on_account_id" ON "core_activities" ("account_id")V++ctablecore_activitiescore_activitiesCREATE TABLE "core_activities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "user_id" integer, "browser" varchar, "session_id" varchar, "ip_address" varchar, "controller" varchar, "action" varchar, "params" varchar, "slug" varchar, "lesson" varchar, "created_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)D''Gtablecore_accountscore_accountsCREATE TABLE "core_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "company_name" varchar, "contact_email" varchar, "domain" varchar, "account_prefix" varchar, "default_site_id" integer, "created_at" datetime, "updated_at" datetime, "next_invoice_num" i:8&/                  g  v  m/hS]Qindexcore_custom_field_def_translations_indexcore_custom_field_def_translationsCREATE INDEX "core_custom_field_def_translations_index" ON "core_custom_field_def_translations" ("core_custom_field_def_id")=QQetablecore_custom_field_def_translationscore_custom_field_def_translationsCREATE TABLE "core_custom_field_def_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_custom_field_def_id" integer, "locale" varchar, "label" varchar, "description" text, "created_at" datetime, "updated_at" datetime)I'%indexindex_core_comments_on_user_idcore_commentsCREATE INDEX "index_core_comments_on_user_id" ON "core_comments" ("user_id") ['Iindexindex_core_comments_on_commentable_typecore_commentsCREATE INDEX "index_core_comments_on_commentable_type" ON "core_comments" ("commentable_type") W'Aindexindex_core_comments_on_commentable_idcore_comments CREATE INDEX "index_core_comments_on_commentable_id" ON "core_comments" ("commentable_id") ''stablecore_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, "user_id" integer, "role" varchar DEFAULT 'comments', "account_id" integer, "created_at" datetime, "updated_at" datetime, "type" varchar, "ancestry" varchar, "ancestry_depth" integer DEFAULT 0) AAIindexindex_category_translationcore_category_translations CREATE INDEX "index_category_translation" ON "core_category_translations" ("core_category_id") AAItablecore_category_translationscore_category_translations CREATE TABLE "core_category_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_category_id" integer, "locale" varchar, "name" varchar, "description" varchar, "created_at" datetime, "updated_at" datetime)d++tablecore_categoriescore_categories CREATE TABLE "core_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "row_order" integer, "account_id" integer, "created_on" datetime, "updated_on" datetime)c)%indexindex_core_addresses_on_addressable_type_and_addressable_idcore_addressesCREATE UNIQUE INDEX "index_core_addresses_on_addressable_type_and_addressable_id" ON "core_addresses" ("addressable_type", "addressable_id")I))Mtablecore_addressescore_addressesCREATE TABLE "core_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "line1" varchar, "line2" varchar, "city" varchar, "state" varchar, "zip" varchar, "country_code" varchar(2), "addressable_id" integer, "addressable_type" varchar, "created_at" datetime, "updated_at" datetime) M+-indexindex_core_activities_on_user_idcore_activitiesCREATE INDEX "index_core_activities_on_user_id" ON "core_activities" ("user_id")S+9indexindex_core_activities_on_account_idcore_activitiesCREATE INDEX "index_core_activities_on_account_id" ON "core_activities" ("account_id")V++ctablecore_activitiescore_activitiesCREATE TABLE "core_activities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "user_id" integer, "browser" varchar, "session_id" varchar, "ip_address" varchar, "controller" varchar, "action" varchar, "params" varchar, "slug" varchar, "lesson" varchar, "created_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)D''Gtablecore_accountscore_accountsCREATE TABLE "core_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "company_name" varchar, "contact_email" varchar, "domain" varchar, "account_prefix" varchar, "default_site_id" integer, "created_at" datetime, "updated_at" datetime, "next_invoice_num" integer DEFAULT 1000)  & \3Do\>:"e!!indexfk_followsfollows$CREATE INDEX "fk_follows" ON "follows" ("follower_id", "follower_type")q )+indexfk_followablesfollows#CREATE INDEX "fk_followables" ON "follows" ("followable_id", "followable_type")AYtablefollowsfollows"CREATE TABLE "follows" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "followable_id" integer NOT NULL, "followable_type" varchar NOT NULL, "follower_id" integer NOT NULL, "follower_type" varchar NOT NULL, "blocked" boolean DEFAULT 'f' NOT NULL, "created_at" datetime, "updated_at" datetime)11Ktablecore_system_emailscore_system_emails!CREATE TABLE "core_system_emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email_type" varchar, "emailable_id" integer, "emailable_type" varchar, "created_at" datetime, "updated_at" datetime, "account_id" integer)(IIKtablecore_system_email_translationscore_system_email_translations CREATE TABLE "core_system_email_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_system_email_id" integer, "locale" varchar, "subject" varchar, "body" text, "created_at" datetime, "updated_at" datetime)'W9Kindexindex_payment_histories_on_owner_typecore_payment_historiesCREATE INDEX "index_payment_histories_on_owner_type" ON "core_payment_histories" ("owner_type")!S9Cindexindex_payment_histories_on_owner_idcore_payment_historiesCREATE INDEX "index_payment_histories_on_owner_id" ON "core_payment_histories" ("owner_id")$U9Gindexindex_payment_histories_on_order_refcore_payment_historiesCREATE INDEX "index_payment_histories_on_order_ref" ON "core_payment_histories" ("order_ref")!S9Cindexindex_payment_histories_on_item_refcore_payment_historiesCREATE INDEX "index_payment_histories_on_item_ref" ON "core_payment_histories" ("item_ref")$U9Gindexindex_payment_histories_on_anchor_idcore_payment_historiesCREATE INDEX "index_payment_histories_on_anchor_id" ON "core_payment_histories" ("anchor_id")99tablecore_payment_historiescore_payment_historiesCREATE 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, "item_ref" varchar, "item_name" varchar, "quantity" integer, "cost" varchar, "discount" varchar, "total_cents" integer, "total_currency" varchar(3), "payment_method" varchar, "payment_date" datetime, "bill_to_name" varchar, "item_details" text, "order_details" text, "status" varchar, "user_profile_id" integer, "created_on" datetime, "account_id" integer, "notify_data" text, "transaction_id" varchar)Gs1windexindex_core_custom_fields_on_owner_id_and_owner_typecore_custom_fieldsCREATE INDEX "index_core_custom_fields_on_owner_id_and_owner_type" ON "core_custom_fields" ("owner_id", "owner_type")!Y1Eindexindex_core_custom_fields_on_account_idcore_custom_fieldsCREATE INDEX "index_core_custom_fields_on_account_id" ON "core_custom_fields" ("account_id")-11tablecore_custom_fieldscore_custom_fieldsCREATE TABLE "core_custom_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar, "custom_field_def_id" integer, "field_data" varchar(4096), "created_at" datetime, "updated_at" datetime, "account_id" integer)W{9indexindex_core_custom_field_defs_on_owner_id_and_owner_typecore_custom_field_defsCREATE INDEX "index_core_custom_field_defs_on_owner_id_and_owner_type" ON "core_custom_field_defs" ("owner_id", "owner_type")1a9Uindexindex_core_custom_field_defs_on_account_idcore_custom_field_defsCREATE INDEX "index_core_custom_field_defs_on_account_id" ON "core_custom_field_defs" ("account_id")u99tablecore_custom_field_defscore_custom_field_defsCREATE TABLE "core_custom_field_defs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar, "name" varchar, "field_type" varchar, "row_order" integer, "required" boolean DEFAULT 'f', "properties" varchar(2048), "created_at" datetime, "updated_at" datetime, "account_id" integer)                  KK[ ) : KyC%IE5^41indexindex_tags_on_nametags8CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")3^41indexindex_tags_on_nametags8CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")3tabletagstags7CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)U2indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings6CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")#1%indextaggings_idxtaggings5CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")0Ytabletaggingstaggings4CREATE TABLEe!!indexfk_followsfollows$CREATE INDEX "fk_follows" ON "follows" ("follower_id", "follower_type")q )+indexfk_followablesfollows#CREATE INDEX "fk_followables" ON "follows" ("followable_id", "followable_type")Z/3yindexindex_roles_on_nameroles3CREATE INDEX "index_roles_on_name" ON "roles" ("name")?.w}indexindex_roles_on_name_and_resource_type_and_resource_idroles2CREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")m-?indexindex_roles_on_account_idroles1CREATE INDEX "index_roles_on_account_id" ON "roles" ("account_id")a,!tablerolesroles0CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_id" integer, "resource_type" varchar, "created_at" datetime, "updated_at" datetime, "account_id" integer)`+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")-*##!tablepreferencespreferences.CREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "owner_id" integer NOT NULL, "owner_type" varchar NOT NULL, "group_id" integer, "group_type" varchar, "value" varchar, "created_at" datetime, "updated_at" datetime))W3Aindexindex_globalize_languages_on_rfc_3066globalize_languages-CREATE INDEX "index_globalize_languages_on_rfc_3066" ON "globalize_languages" ("rfc_3066")"(Y3Eindexindex_globalize_languages_on_iso_639_3globalize_languages,CREATE INDEX "index_globalize_languages_on_iso_639_3" ON "globalize_languages" ("iso_639_3")"'Y3Eindexindex_globalize_languages_on_iso_639_2globalize_languages+CREATE INDEX "index_globalize_languages_on_iso_639_2" ON "globalize_languages" ("iso_639_2")"&Y3Eindexindex_globalize_languages_on_iso_639_1globalize_languages*CREATE INDEX "index_globalize_languages_on_iso_639_1" ON "globalize_languages" ("iso_639_1")l%33tableglobalize_languagesglobalize_languages)CREATE 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, "english_name" varchar, "english_name_locale" varchar, "english_name_modifier" varchar, "native_name" varchar, "native_name_locale" varchar, "native_name_modifier" varchar, "macro_language" boolean, "direction" varchar, "pluralization" varchar, "scope" varchar(1))$S39indexindex_globalize_countries_on_localeglobalize_countries(CREATE INDEX "index_globalize_countries_on_locale" ON "globalize_countries" ("locale")#O31indexindex_globalize_countries_on_codeglobalize_countries'CREATE INDEX "index_globalize_countries_on_code" ON "globalize_countries" ("code")""33ktableglobalize_countriesglobalize_countries%CREATE TABLE "globalize_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(2), "english_name" varchar, "date_format" varchar, "currency_format" varchar, "currency_code" varchar(3), "thousands_sep" varchar(2), "decimal_sep" varchar(2), "currency_decimal_sep" varchar(2), "number_grouping_scheme" varchar, "continent" varchar, "locale" varchar)                    T | 3^|  d=##tableusers_rolesusers_rolesBCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)<SGindexindex_users_on_reset_password_tokenusersACREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e;5 indexindex_users_on_emailusers@CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") :O?indexindex_users_on_confirmation_tokenusers?CREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")m9?indexindex_users_on_account_idusers>CREATE INDEX "index_users_on_account_id" ON "users" ("account_id")g8-tableusersusers=CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "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, "last_sign_in_ip" varchar, "confirmation_token" varchar, "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar, "created_at" datetime, "updated_at" datetime, "account_id" integer)7M1-indexindex_user_site_profiles_on_uuiduser_site_profiles]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")d=##tableusers_rolesusers_rolesBCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)<SGindexindex_users_on_reset_password_tokenusersACREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e;5 indexindex_users_on_emailusers@CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") :O?indexindex_users_on_confirmation_tokenusers?CREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")m9?indexindex_users_on_account_idusers>CREATE INDEX "index_users_on_account_id" ON "users" ("account_id")    )20160128094739 ) 20160128094739