SQLite format 3@ DvD-^  K/)indexindex_ems_registr K/)indexindex_ems_registrations_on_uuidems_registrations CREATE INDEX "index_ems_registrations_on_uuid" ON "ems_registrations" ("uuid")#//utableems_registrationsems_registrationsCREATE TABLE "ems_registrations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workshop_id" integer, "receipt_code" varchar(20), "receipt_requested" boolean, "workshop_price_id" integer, "amount_paid_cents" integer DEFAULT 0, "discount_value" integer, "discount_use_percent" boolean, "checkin_at" datetime, "aasm_state" varchar(20), "process_changed_on" datetime, "user_updated_at" datetime, "archived_on" datetime, "confirmed_on" datetime, "created_at" datetime, "updated_at" datetime, "account_id" integer, "lock_version" integer DEFAULT 0, "registered_locale" varchar(5), "user_profile_id" integer, "amount_paid_currency" varchar(255), "payment_reminder_sent_on" datetime, "uuid" varchar(36), "comments_count" integer, "payment_comment_id" integer)e-'indexworkshopname_keyems_workshopsCREATE INDEX "workshopname_key" ON "ems_workshops" ("slug")Y''qtableems_workshopsems_workshopsCREATE TABLE "ems_workshops" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "starting_on" datetime, "ending_on" datetime, "deadline_on" date, "registrations_count" integer DEFAULT 0, "country_id" integer, "contact_email" varchar(60) DEFAULT '', "contact_phone" varchar(20) DEFAULT '', "info_url" varchar(255) DEFAULT '', "require_review" boolean DEFAULT 'f', "waitlisting" boolean DEFAULT 'f', "closed_text" text, "published" boolean, "archived_on" datetime, "created_at" datetime, "updated_at" datetime, "account_id" integer, "require_account" boolean, "require_address" boolean, "require_photo" boolean, "base_currency" varchar(3), "event_style" varchar(255) DEFAULT 'workshop', "funding_goal_cents" integer DEFAULT 0, "payments_enabled" boolean, "show_address" boolean, "image" varchar(255))u-/indexreceipt_code_keyems_registrations CREATE INDEX "receipt_code_key" ON "ems_registrations" ("receipt_code")p 33tableems_workshop_pricesems_workshop_prices CREATE TABLE "ems_workshop_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workshop_id" integer, "price_cents" integer, "price_currency" varchar(10), "alt1_price_cents" integer, "alt1_price_currency" varchar(10), "alt2_price_cents" integer, "alt2_price_currency" varchar(10), "disabled" boolean DEFAULT 'f' NOT NULL, "valid_until" date, "valid_starting_on" date, "total_available" integer, "recurring_amount" integer, "recurring_period" integer, "recurring_number" integer, "row_order" integer, "account_id" integer, "created_at" datetime, "updated_at" datetime)c KK=tableems_workshop_price_translationsems_workshop_price_translations CREATE TABLE "ems_workshop_price_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "ems_workshop_price_id" integer, "locale" varchar(255), "price_description" varchar(255), "sub_description" text, "payment_details" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)C??tableems_workshop_translationsems_workshop_translationsCREATE TABLE "ems_workshop_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "ems_workshop_id" integer, "locale" varchar(255), "title" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime, "sidebar" text, "summary" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migration]Mx>_3O!=) B \p^L:(tbP>, x f T B 0  | j X F 4 "  n \B)20141119103753A)20141119103752@)20141119103751?)20141119103750>)20141119103749=)20141119103748<)20141119103747;)20141119103746:)201411191037459)201411191037448)201411191037437)201411191037426)201411191037415)201411191037404)201411141709603)201411141709592)201411141709581)201411141709570)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)20140708142312)20140707152124)20140605052208)20140523165342)20140122204702 )20131127165445 )20131116180719 )20130917161700 )20130916160033 )20130914105736)20130913083529)20130703131515)20130624134506)20130609145812)20130518092324)20130516204454)20130516124327)20130510155617 B |iVC0 r_L9& { h U B /  q ^ K 8 %  z g T A . )20141119103753B)20141119103752A)20141119103751@)20141119103750?)20141119103749>)20141119103748=)20141119103747<)20141119103746;)20141119103745:)201411191037449)201411191037438)201411191037427)201411191037416)201411191037405)201411141709604)201411141709593)201411141709582)201411141709571)201411141709560)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)20140708142312)20140707152124)20140605052208)20140523165342)20140122204702)20131127165445 )20131116180719 )20130917161700 )20130916160033 )20130914105736 )20130913083529)20130703131515)20130624134506)20130609145812)20130518092324)20130516204454)20130516124327) 20130510155617            >  s rq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")C??q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")C??tableems_workshop_translationsems_workshop_translationsCREATE TABLE "ems_workshop_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "ems_workshop_id" integer, "locale" varchar(255), "title" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime, "sidebar" text, "summary" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)c KK=tableems_workshop_price_translationsems_workshop_price_translations CREATE TABLE "ems_workshop_price_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "ems_workshop_price_id" integer, "locale" varchar(255), "price_description" varchar(255), "sub_description" text, "payment_details" text, "created_at" datetime, "updated_at" datetime)p 33tableems_workshop_pricesems_workshop_prices CREATE TABLE "ems_workshop_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workshop_id" integer, "price_cents" integer, "price_currency" varchar(10), "alt1_price_cents" integer, "alt1_price_currency" varchar(10), "alt2_price_cents" integer, "alt2_price_currency" varchar(10), "disabled" boolean DEFAULT 'f' NOT NULL, "valid_until" date, "valid_starting_on" date, "total_available" integer, "recurring_amount" integer, "recurring_period" integer, "recurring_number" integer, "row_order" integer, "account_id" integer, "created_at" datetime, "updated_at" datetime)Y''qtableems_workshopsems_workshopsCREATE TABLE "ems_workshops" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "starting_on" datetime, "ending_on" datetime, "deadline_on" date, "registrations_count" integer DEFAULT 0, "country_id" integer, "contact_email" varchar(60) DEFAULT '', "contact_phone" varchar(20) DEFAULT '', "info_url" varchar(255) DEFAULT '', "require_review" boolean DEFAULT 'f', "waitlisting" boolean DEFAULT 'f', "closed_text" text, "published" boolean, "archived_on" datetime, "created_at" datetime, "updated_at" datetime, "account_id" integer, "require_account" boolean, "require_address" boolean, "require_photo" boolean, "base_currency" varchar(3), "event_style" varchar(255) DEFAULT 'workshop', "funding_goal_cents" integer DEFAULT 0, "payments_enabled" boolean, "show_address" boolean, "image" varchar(255))e-'indexworkshopname_keyems_workshopsCREATE INDEX "workshopname_key" ON "ems_workshops" ("slug")#//utableems_registrationsems_registrationsCREATE TABLE "ems_registrations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workshop_id" integer, "receipt_code" varchar(20), "receipt_requested" boolean, "workshop_price_id" integer, "amount_paid_cents" integer DEFAULT 0, "discount_value" integer, "discount_use_percent" boolean, "checkin_at" datetime, "aasm_state" varchar(20), "process_changed_on" datetime, "user_updated_at" datetime, "archived_on" datetime, "confirmed_on" datetime, "created_at" datetime, "updated_at" datetime, "account_id" integer, "lock_version" integer DEFAULT 0, "registered_locale" varchar(5), "user_profile_id" integer, "amount_paid_currency" varchar(255), "payment_reminder_sent_on" datetime, "uuid" varchar(36), "comments_count" integer, "payment_comment_id" integer) E 8  EYkEtt$P''Ytablecore_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, "invoice_id_counter" integer)[Gindexindex_versions_on_item_type_and_item_idversions"CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")57tableversionsversions CREATE 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" text, "locale" varchar(255))&]#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")?%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")Z$3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")d###tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)k"5tablerolesrolesCREATE 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)W3Aindexindex_globalize_languages_on_rfc_3066globalize_languagesCREATE INDEX "index_globalize_languages_on_rfc_3066" ON "globalize_languages" ("rfc_3066")"Y3Eindexindex_globalize_languages_on_iso_639_3globalize_languagesCREATE INDEX "index_globalize_languages_on_iso_639_3" ON "globalize_languages" ("iso_639_3")"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_1globalize_languagesCREATE INDEX "index_globalize_languages_on_iso_639_1" ON "globalize_languages" ("iso_639_1")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))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_countries CREATE 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)) K/)indexindex_ems_registrations_on_uuidems_registrations CREATE INDEX "index_ems_registrations_on_uuid" ON "ems_registrations" ("uuid")u-/indexreceipt_code_keyems_registrations CREATE INDEX "receipt_code_key" ON "ems_registrations" ("receipt_code")                  ;;Ry * h rGC:AAIindexindex_category_translationcore_category_translations0CREATE INDEX "index_category_translation" ON "core_category_translations" ("core_category_id").9AAgtablecore_category_translationscore_2'7tableversionsversions CREATE 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" text, "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")~2++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)3S+9indexindex_core_activities_on_account_idcore_activities-CREATE INDEX "index_core_activities_on_account_id" ON "core_activities" ("account_id") 4M+-indexindex_core_activities_on_user_idcore_activities.CREATE INDEX "index_core_activities_on_user_id" ON "core_activities" ("user_id").5''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)6['Iindexindex_core_comments_on_commentable_typecore_comments)CREATE INDEX "index_core_comments_on_commentable_type" ON "core_comments" ("commentable_type")7W'Aindexindex_core_comments_on_commentable_idcore_comments*CREATE INDEX "index_core_comments_on_commentable_id" ON "core_comments" ("commentable_id")8I'%indexindex_core_comments_on_user_idcore_comments+CREATE INDEX "index_core_comments_on_user_id" ON "core_comments" ("user_id").9AAgtablecore_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):AAIindexindex_category_translationcore_category_translations0CREATE INDEX "index_category_translation" ON "core_category_translations" ("core_category_id")i;++ tablecore_categoriescore_categories1CREATE 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)2<II_tablecore_system_email_translationscore_system_email_translations2CREATE 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)=11_tablecore_system_emailscore_system_emails4CREATE 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)          *)(        -)'4 _YVb ?stableusersusersCREATE 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, " ?stableusersusersCREATE 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)e@5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")ASGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") BO?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")mC?indexindex_users_on_account_idusers$CREATE INDEX "index_users_on_account_id" ON "users" ("account_id") J11?tableuser_site_profilesuser_site_profiles