SQLite format 3@ ;T-p4 xK==9tablealchemy_essence_booleansalchemy_essence_booleansCREATE TABLE "alchemy_essence_booleans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer) II;tablealchemy_elements_alchemy_pagesalchemy_elements_alchemy_pagesCREATE TABLE "alchemy_elements_alchemy_pages" ("element_id" integer, "page_id" integer)&Y-Sindexindex_elements_on_page_id_and_positionalchemy_elementsCREATE INDEX "index_elements_on_page_id_and_position" ON "alchemy_elements" ("page_id", "position")& --tablealchemy_elementsalchemy_elementsCREATE TABLE "alchemy_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "position" integer, "page_id" integer, "public" boolean DEFAULT 't', "folded" boolean DEFAULT 'f', "unique" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer, "cell_id" integer, "cached_tag_list" text)/ _-_indexindex_contents_on_element_id_and_positionalchemy_contents CREATE INDEX "index_contents_on_element_id_and_position" ON "alchemy_contents" ("element_id", "position")R --Wtablealchemy_contentsalchemy_contents CREATE TABLE "alchemy_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "essence_type" varchar, "essence_id" integer, "element_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer)X ''otablealchemy_cellsalchemy_cells CREATE TABLE "alchemy_cells" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) W3Aindexindex_alchemy_attachments_on_file_uidalchemy_attachments CREATE INDEX "index_alchemy_attachments_on_file_uid" ON "alchemy_attachments" ("file_uid")s33 tablealchemy_attachmentsalchemy_attachments CREATE TABLE "alchemy_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "file_name" varchar, "file_mime_type" varchar, "file_size" integer, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "cached_tag_list" text, "file_uid" varchar)2c'gindexindex_alchemy_users_on_reset_password_tokenalchemy_usersCREATE UNIQUE INDEX "index_alchemy_users_on_reset_password_token" ON "alchemy_users" ("reset_password_token")E'+indexindex_alchemy_users_on_loginalchemy_usersCREATE UNIQUE INDEX "index_alchemy_users_on_login" ON "alchemy_users" ("login")E'+indexindex_alchemy_users_on_emailalchemy_usersCREATE UNIQUE INDEX "index_alchemy_users_on_email" ON "alchemy_users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)''?tablealchemy_usersalchemy_usersCREATE TABLE "alchemy_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "firstname" varchar, "lastname" varchar, "login" varchar, "email" varchar, "gender" varchar, "language" varchar, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "password_salt" varchar(128) DEFAULT '' NOT NULL, "sign_in_count" integer DEFAULT 0 NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer, "cached_tag_list" text, "reset_password_token" varchar, "reset_password_sent_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" va#0 p^L:()20161020101037)20160627081901)20160614164603)20160614164602)20160518190427)20160518190426)20160518190425 )20160518190421 )20160322214809 )20160322214808 )20141209144532 )20141119205158)20141119205157)20141119205156)20141119205155)20131225232042)20131018201541)20131018201540)20131018201539)20131015124700 |iVC0 )20161020101037)20160627081901)20160614164603)20160614164602)20160518190427)20160518190426)20160518190425)20160518190421 )20160322214809 )20160322214808 )20141209144532 )20141119205158 )20141119205157)20141119205156)20141119205155)20131225232042)20131018201541)20131018201540)20131018201539) 20131015124700                . { 1S''etablealchemy_usersalchemy_usersCREATE TABLE "alchemy_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "firstname" varchar, "lastname" varchar, "login" varchar, "email" varchar, "gender" varchar, "language" varchar, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "password_salt" varchar(128) DEFAULT '' NOT NULL, "sign_in_count" integer DEFAULT 0 NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer, "cached_tag_list" text, "reset_password_token" varchar, "reset_password_sent_at" datetime, "alchemy_roles" varchar DEFAULT 'member', "password_change_requested_at" datetime) II;tablealchemy_elements_alchemy_pagesalchemy_elements_alchemy_pagesCREATE TABLE "alchemy_elements_alchemy_pages" ("element_id" integer, "page_id" integer)&Y-Sindexindex_elements_on_page_id_and_positionalchemy_elementsCREATE INDEX "index_elements_on_page_id_and_position" ON "alchemy_elements" ("page_id", "position")C --9tablealchemy_elementsalchemy_elementsCREATE TABLE "alchemy_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "position" integer, "page_id" integer, "public" boolean DEFAULT 't', "folded" boolean DEFAULT 'f', "unique" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer, "cell_id" integer, "cached_tag_list" text, "parent_element_id" integer)/ _-_indexindex_contents_on_element_id_and_positionalchemy_contents CREATE INDEX "index_contents_on_element_id_and_position" ON "alchemy_contents" ("element_id", "position")R --Wtablealchemy_contentsalchemy_contents CREATE TABLE "alchemy_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "essence_type" varchar, "essence_id" integer, "element_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer)X ''otablealchemy_cellsalchemy_cells CREATE TABLE "alchemy_cells" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) W3Aindexindex_alchemy_attachments_on_file_uidalchemy_attachments CREATE INDEX "index_alchemy_attachments_on_file_uid" ON "alchemy_attachments" ("file_uid")s33 tablealchemy_attachmentsalchemy_attachments CREATE TABLE "alchemy_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "file_name" varchar, "file_mime_type" varchar, "file_size" integer, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "cached_tag_list" text, "file_uid" varchar)2c'gindexindex_alchemy_users_on_reset_password_tokenalchemy_usersCREATE UNIQUE INDEX "index_alchemy_users_on_reset_password_token" ON "alchemy_users" ("reset_password_token")E'+indexindex_alchemy_users_on_loginalchemy_usersCREATE UNIQUE INDEX "index_alchemy_users_on_login" ON "alchemy_users" ("login")E'+indexindex_alchemy_users_on_emailalchemy_usersCREATE UNIQUE INDEX "index_alchemy_users_on_email" ON "alchemy_users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)   1= 0 n1e//ytablealchemy_languagesalchemy_languagesCREATE TABLE "alchemy_languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "language_code" varchar, "frontpage_name" varchar, "page_layout" varchar DEFAULT 'intro', "public" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer, "default" boolean DEFAULT 'f', "country_code" varchar DEFAULT '' NOT NULL, "site_id" integer, "locale" varchar)/indexindex_alchemy_languages_on_language_code_and_country_codealchemy_languages CREATE INDEX "index_alchemy_languages_on_language_code_and_country_code" ON "alchemy_languages" ("language_code", "country_code")N55?tablealchemy_folded_pagesalchemy_folded_pagesCREATE TABLE "alchemy_folded_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "user_id" integer, "folded" boolean DEFAULT 'f')&Y;Eindexindex_alchemy_essence_selects_on_valuealchemy_essence_selectsCREATE INDEX "index_alchemy_essence_selects_on_value" ON "alchemy_essence_selects" ("value");;7tablealchemy_essence_selectsalchemy_essence_selectsCREATE TABLE "alchemy_essence_selects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer)}== tablealchemy_essence_picturesalchemy_essence_picturesCREATE TABLE "alchemy_essence_pictures" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "picture_id" integer, "caption" varchar, "title" varchar, "alt_tag" varchar, "link" varchar, "link_class_name" varchar, "link_title" varchar, "css_class" varchar, "link_target" varchar, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "crop_from" varchar, "crop_size" varchar, "render_size" varchar)Q77Atablealchemy_essence_linksalchemy_essence_linksCREATE TABLE "alchemy_essence_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "link" varchar, "link_title" varchar, "link_target" varchar, "link_class_name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer)77/tablealchemy_essence_htmlsalchemy_essence_htmlsCREATE TABLE "alchemy_essence_htmls" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source" text, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)M779tablealchemy_essence_filesalchemy_essence_filesCREATE TABLE "alchemy_essence_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachment_id" integer, "title" varchar, "css_class" varchar, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "link_text" varchar) 773tablealchemy_essence_datesalchemy_essence_datesCREATE TABLE "alchemy_essence_dates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "date" datetime, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*[=Iindexindex_alchemy_essence_booleans_on_valuealchemy_essence_booleansCREATE INDEX "index_alchemy_essence_booleans_on_value" ON "alchemy_essence_booleans" ("value")==9tablealchemy_essence_booleansalchemy_essence_booleansCREATE TABLE "alchemy_essence_booleans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer)              Fm W} m M @ ?mPyH0j/7tabletagstags3CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)U.indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings2CREATE Ib"''tablealchemy_pagesalchemy_pages&CREATE TABLE "alchemy_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "urlname" varchar, "title" varchar, "language_code" varchar, "language_root" boolean, "page_layout" varchar, "meta_keywords" text, "meta_description" text, "lft" integer, "rgt" integer, "parent_id" intege|077tablealchemy_essence_textsalchemy_essence_textsCREATE TABLE "alchemy_essence_texts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text, "link" varchar, "link_title" varchar, "link_class_name" varchar, "public" boolean DEFAULT 'f', "link_target" varchar, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/tabletagstags3CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0) ==/tablealchemy_legacy_page_urlsalchemy_legacy_page_urls$CREATE TABLE "alchemy_legacy_page_urls" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "urlname" varchar NOT NULL, "page_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) (I'3indexalchemy_sites_public_hosts_idxalchemy_sites,CREATE INDEX "alchemy_sites_public_hosts_idx" ON "alchemy_sites" ("host", "public")'''' tablealchemy_sitesalchemy_sites+CREATE TABLE "alchemy_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "host" varchar, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "public" boolean DEFAULT 'f', "aliases" text, "redirect_to_primary_host" boolean)X'--tablealchemy_picturesalchemy_O&--Qtablealchemy_picturesalchemy_pictures*CREATE TABLE "alchemy_pictures" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "image_file_name" varchar, "image_file_width" integer, "image_file_height" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer, "upload_hash" varchar, "cached_tag_list" text, "image_file_uid" varchar, "image_file_size" integer, "image_file_format" varchar)~,Otabletaggingstaggings0CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar, "tagger_id" integer, "tagger_type" varchar, "context" varchar, "created_at" datetime)9+Atablelocationslocations/CREATE TABLE "locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)N*wtableeventsevents.CREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "hidden_name" varchar, "starts_at" datetime, "ends_at" datetime, "description" text, "entrance_fee" decimal(6,2), "published" boolean, "location_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL){)C'indexindex_alchemy_sites_on_hostalchemy_sites-CREATE INDEX "index_alchemy_sites_on_host" ON "alchemy_sites" ("host")X/indexindex_alchemy_languages_on_language_code_and_country_codealchemy_languages CREATE INDEX "index_alchemy_languages_on_language_code_and_country_code" ON "alchemy_languages" ("language_code", "country_code")0!_=Qindexindex_alchemy_legacy_page_urls_on_urlnamealchemy_legacy_page_urls%CREATE INDEX "index_alchemy_legacy_page_urls_on_urlname" ON "alchemy_legacy_page_urls" ("urlname")h==/tablealchemy_legacy_pag1|077tablealchemy_essence_textsalchemy_essence_textsCREATQ/5indexindex_alchemy_languages_on_site_idalchemy_languages"CREATE INDEX "index_alchemy_languages_on_site_id" ON "alchemy_languages" ("site_id")&]/Mindexindex_alchemy_languages_on_language_codealchemy_languages!CREATE INDEX "index_alchemy_languages_on_language_code" ON "alchemy_languages" ("language_code")              2   e (/$ > 4 u;M';indexindex_pages_on_parent_id_and_lftalchemy_pages(CREATE INDEX "index_pages_on_parent_id_and_lft" ON "alchemy_pages" ("parent_id", "lft") eA'%indexindex_pages_on_language_idalchemy_pages'CREATE INDEX "index_pages_on_language_id" ON "alchemy_pages" ("language_id") eG''Gtablealchemy_pagesalchemy_pages&CREATE TABLE "alchemy_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "urlname" varchar, "title" varchar, "language_code" varchar, "language_root" boolean, "page_layout" varchar, "meta_keywords" text, "meta_description" text, "lft" integer, "rgt" integer, "parent_id" integer, "depth" integer, "visible" boolean DEFAULT 'f', "locked" boolean DEFAULT 'f', "locked_by" integer, "restricted" boolean DEFAULT 'f', "robot_index" boolean DEFAULT 't', "robot_follow" boolean DEFAULT 't', "sitemap" boolean DEFAULT 't', "layoutpage" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at"3>i'cindexindex_alchemy_pages_on_locked_at_and_locked_byalchemy_pages;CREATE INDEX "index_alchemy_pages_on_locked_at_and_locked_by" ON "alchemy_pages" ("locked_at", "locked_by")Q8{-indexindex_alchemy_elements_on_page_id_and_parent_element_idalchemy_elements9CREATE INDEX "index_alchemy_elements_on_page_id_and_parent_element_id" ON "alchemy_elements" ("page_id", "parent_element_id")7K')indexindex_alchemy_users_on_lastnamealchemy_users8CREATE INDEX "index_alchemy_users_on_lastname" ON "alchemy_users" ("lastname") 6M'-indexindex_alchemy_users_on_firstnamealchemy_users7CREATE INDEX "index_alchemy_users_on_firstname" ON "alchemy_users" ("firstname")U5indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings1CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")#4%indextaggings_idxtaggings2CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")^31indexindex_tags_on_nametags6CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")2U'=indexindex_alchemy_users_on_alchemy_rolesalchemy_users5CREATE INDEX "index_alchemy_users_on_alchemy_roles" ON "alchemy_users" ("alchemy_roles"):1??tablealchemy_essence_richtextsalchemy_essence_richtextsCREATE TABLE "alchemy_essence_richtexts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text, "stripped_body" text, "public" boolean, "creator_id" integer, "updater_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)77tablea<=o'oindexindex_alchemy_pages_on_public_on_and_public_untilalchemy_pages:CREATE INDEX "index_alchemy_pages_on_public_on_and_public_until" ON "alchemy_pages" ("public_on", "public_until")t<9'indexindex_pages_on_urlnamealchemy_pages)CREATE INDEX "index_pages_on_urlname" ON "alchemy_pages" ("urlname");M';indexindex_pages_on_parent_id_and_lftalchemy_pages(CREATE INDEX "index_pages_on_parent_id_and_lft" ON "alchemy_pages" ("parent_id", "lft"):A'%indexindex_pages_on_language_idalchemy_pages'CREATE INDEX "index_pages_on_language_id" ON "alchemy_pages" ("language_id")<9''7tablealchemy_pagesalchemy_pages&CREATE TABLE "alchemy_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "urlname" varchar, "title" varchar, "language_code" varchar, "language_root" boolean, "page_layout" varchar, "meta_keywords" text, "meta_description" text, "lft" integer, "rgt" integer, "parent_id" integer, "depth" integer, "visible" boolean DEFAULT 'f', "locked_by" integer, "restricted" boolean DEFAULT 'f', "robot_index" boolean DEFAULT 't', "robot_follow" boolean DEFAULT 't', "sitemap" boolean DEFAULT 't', "layoutpage" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer, "language_id" integer, "cached_tag_list" text, "published_at" datetime, "public_on" datetime, "public_until" datetime, "locked_at" datetime)      )('&