SQLite format 3@ MU.K 4eUM779tablealchemy_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) 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_elements CREATE INDEX "index_elements_on_page_id_and_position" ON "alchemy_elements" ("page_id", "position")Q {-indexindex_alchemy_elements_on_page_id_and_parent_element_idalchemy_elements CREATE INDEX "index_alchemy_elements_on_page_id_and_parent_element_id" ON "alchemy_elements" ("page_id", "parent_element_id") O-1indexindex_alchemy_elements_on_cell_idalchemy_elements CREATE INDEX "index_alchemy_elements_on_cell_id" ON "alchemy_elements" ("cell_id")L --Ktablealchemy_elementsalchemy_elements CREATE TABLE "alchemy_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "position" integer, "page_id" integer NOT NULL, "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)Rw- indexindex_alchemy_contents_on_essence_id_and_essence_typealchemy_contents CREATE UNIQUE INDEX "index_alchemy_contents_on_essence_id_and_essence_type" ON "alchemy_contents" ("essence_id", "essence_type")/_-_indexindex_contents_on_element_id_and_positionalchemy_contentsCREATE INDEX "index_contents_on_element_id_and_position" ON "alchemy_contents" ("element_id", "position")m-- tablealchemy_contentsalchemy_contentsCREATE TABLE "alchemy_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "essence_type" varchar NOT NULL, "essence_id" integer NOT NULL, "element_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer)I'%indexindex_alchemy_cells_on_page_idalchemy_cellsCREATE INDEX "index_alchemy_cells_on_page_id" ON "alchemy_cells" ("page_id")a''tablealchemy_cellsalchemy_cellsCREATE TABLE "alchemy_cells" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)W3Aindexindex_alchemy_attachments_on_file_uidalchemy_attachmentsCREATE INDEX "index_alchemy_attachments_on_file_uid" ON "alchemy_attachments" ("file_uid")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)s33 tablealchemy_attachmentsalchemy_attachmentsCREATE 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_li5x!i \P  -alchemy_pictures'alchemy_pages' alchemy_users/ alchemy_languages' alchemy_sites  q4 "=qqqqqqqqqqqFFFM779tablealchemy_essence_filesalchemy_essence_filesCREATE TABLE "alcO3--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)A'indexindex_alchemmP-- tablealchemy_contentsalchemy_contentsCREATE TABLE "alchemy_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "essence_type" varchar NOT NULL, "essence_id" integer NOT NULL, "element_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "creator_id" integer, "updater_id" integer) <G!indexindex_taggings_on_taggable_idtaggingsCCREATE INDEX "index_taggings_on_taggable_id" ON "taggings" ("taggable_id")T%Qindextaggings_idytaggingsBCREATE INDEX "taggings_idy" ON "taggings" ("taggable_id", "taggable_type", "tagger_id", "context")indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsACREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")= indexindex_taggings_on_tag_idtaggings@CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")%indextaggings_idxtaggings?CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")?indexindex_taggings_on_contexttaggings>CREATE INDEX "index_taggings_on_context" ON "taggings" ("context")Otabletaggingstaggings=CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,OI'%indexindex_alchemy_cells_on_page_idalchemy_cellsCREATE INDEX "index_alchemy_cells_on_page_id" ON "alchemy_cells" ("page_id")aN''tablealchemy_cellsalchemy_cellsCREATE TABLE "alchemy_cells" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)MW3Aindexindex_alchemy_attachments_on_file_uidalchemy_attachments)CREATE INDEX "index_alchemy_attachments_on_file_uid" ON "alchemy_attachments" ("file_uid")sL33 tablealchemy_attachmentsalchemy_attachmentsCREATE 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)1indexindex_tags_on_nametagsHCREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name"):tabletagstagsGCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)Cindexindex_taggings_on_tagger_idtaggingsFCREATE INDEX "index_taggings_on_tagger_id" ON "taggings" ("tagger_id")/cWindexindex_taggings_on_tagger_id_and_tagger_typetaggingsECREATE INDEX "index_taggings_on_tagger_id_and_tagger_type" ON "taggings" ("tagger_id", "tagger_type")K)indexindex_taggings_on_taggable_typetaggingsDCREATE INDEX "index_taggings_on_taggable_type" ON "taggings" ("taggable_type")GG[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataMNF55?tablear_internal_metadataar_internal_metadataLCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)AEU/indexsqlite_autoindex_schema_migrations_1schema_migrationsJxD//tableschema_migrationsschema_migrationsICREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)      W+  ]/Mindex$y_&']/Mindexindex_alchemy_languages_on_language_codealchemy_languages#CREATE INDEX "index_alchemy_languages_on_la|FG!indexindex_taggings_on_taggable_idtaggingsCCREATE INDEX "index_taggings_on_taggable_id" ON "taggings" ("taggable_id")E%Qindextaggings_idytaggingsBCREATE INDEX "taggings_idy" ON "taggings" ("taggable_id", "taggable_type", "tagger_id", "context")UDindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsACREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")mC= indexindex_taggings_on_tag_idtaggings@CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")#B%indextaggings_idxtaggings?CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")pA?indexindex_taggings_on_contexttaggings>CREATE INDEX "index_taggings_on_context" ON "taggings" ("context")~@OtablTO-1indexindex_alchemy_elements_on_cell_idalchemy_elements CREATE INDEX "index_alchemy_elements_on_cell_id" ON "alchemy_elements" ("cell_id")LS--Ktablealchemy_elementsalchemy_elements CREATE TABLE "alchemy_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "position" integer, "page_id" integer NOT NULL, "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)RRw- indexindex_alchemy_contents_on_essence_id_and_essence_typealchemy_contents4CREATE UNIQUE INDEX "index_alchemy_contents_on_essence_id_and_essence_type" ON "alchemy_contents" ("essence_id", "essence_type")/Q_-_indexindex_contents_on_element_id_and_positionalchemy_contentsCREATE INDEX "index_contents_on_element_id_and_position" ON "alchemy_contents" ("element_id", "position")-- tablealchemy_contentsalchemy_contentsCREATE TABLE "alchemy_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "essence_type" varchar NOT NULL, "essence_id" integer NOT NULL, "element_id" integer NOT NULL, "po6\e7]indexindex_alchemy_essence_files_on_attachment_idalchemy_essence_filesCREATE INDEX "index_alchemy_essence_files_on_attachment_id" ON "alchemy_essence_files" ("attachment_id")M[779tablealchemy_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) Z773tablealchemy_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)*Y[=Iindexindex_alchemy_essence_booleans_on_valuealchemy_essence_booleansCREATE INDEX "index_alchemy_essence_booleans_on_value" ON "alchemy_essence_booleans" ("value")X==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) WII;tablealchemy_elements_alchemy_pagesalchemy_elements_alchemy_pagesCREATE TABLE "alchemy_elements_alchemy_pages" ("element_id" integer, "page_id" integer)&VY-Sindexindex_elements_on_page_id_and_positionalchemy_elements CREATE INDEX "index_elements_on_page_id_and_position" ON "alchemy_elements" ("page_id", "position")QU{-indexindex_alchemy_elements_on_page_id_and_parent_element_idalchemy_elements CREATE INDEX "index_alchemy_elements_on_page_id_and_parent_element_id" ON "alchemy_elements" ("page_id", "parent_element_id")           $#! n  |( OI|FG!indexindex_taggings_on_taggable_idtaggingsCCREATE INDEX "index_taggings_on_taggable_id" ON "taggings" ("taggable_id")E%Qindextaggings_idytaggingsBCREATE INDEX "taggings_idy" ON "taggings" ("taggable_id", "taggable_type", "tagger_id", "context")UDindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsACREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")#B%indextaggings_idxtaggings?CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type");K')indexindex_alchemy_users_on_lastnamealchemy_users8CREATE INDEX "index_alchemy_users_on_lastname" ON "alchemy_users" ("lastname") :M'-indexindex_alchemy_users_on_firstnamealchemy_users7CREATE INDEX "index_alchemy_users_on_firstname" ON "alchemy_users" ("firstname")9E'+indexindex_alchemy_users_on_emailalchemy_users6CREATE UNIQUE INDEX "index_alchemy_users_on_email" ON "alchemy_users" ("email")8U'=indexindex_alchemy_users_on_alchemy_rolesalchemy_users3CREATE INDEX "index_alchemy_users_on_alchemy_roles" ON "alchemy_users" ("alchemy_roles")*7''tablealchemy_usersalchemy_users"CREATE 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'){6C'indexindex_alchemy_sites_on_hostalchemy_sites2CREATE INDEX "index_alchemy_sites_on_host" ON "alchemy_sites" ("host") 5I'3indexalchemy_sites_public_hosts_idxalchemy_sites1CREATE INDEX "alchemy_sites_public_hosts_idx" ON "alchemy_sites" ("host", "public")'4'' tablealchemy_sitesalchemy_sites0CREATE 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) G]/Mindexindex_alchemy_languages_on_language_codealchemy_languag2=c'gindexindex_alchemy_users_on_reset_password_tokenalchemy_users:CREATE UNIQUE INDEX "index_alchemy_users_on_reset_password_token" ON "alchemy_users" ("reset_password_token")<E'+indexindex_alchemy_users_on_loginalchemy_users9CREATE UNIQUE INDEX "index_alchemy_users_on_login" ON "alchemy_users" ("login")--QtablealchemC= indexindex_taggings_on_tag_idtaggings@CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")pA?indexindex_taggings_on_contexttaggings>CREATE INDEX "index_taggings_on_context" ON "taggings" ("context")~@Otabletaggingstaggings=CREATE 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?Atablelocationslocationswtableeventsevents;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 N ,,   AA r AA IntrointroIntrodetintrofftttf2017-10-24 14:40:13.6140832017-10-24 14:40:13.627206^ AA Rootfftttf2017-10-24 14:40:04.0824992017-10-24 14:40:13.627206           ZAA DeutschdeIntrointrot2017-10-24 14:39:24.7176672017-10-24 14:39:24.717667tde   qG9:B9X==9tablealchemy_essence_booleansalchemy_essence_booleansCREATE TAB]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)e7]indexindex_alchemy_essence_files_on_attachment_idalchemy_essence_filesCREATE INDEX "index_alchemy_essence_files_on_attachment_id" ON "alchemy_essence_files" ("attachment_&i]/Mindexindex_alchemy_languages_on_language_codealchemy_languages$CREATE INDEX "index_alchemy_languages_on_language_code" ON "alchemy_languages" ("language_code")Xh/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")ng// tablealchemy_languagesalchemy_languages CREATE 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 NOT NULL, "locale" varchar)Jfo5}indexindex_alchemy_folded_pages_on_page_id_and_user_idalchemy_folded_pagesCREATE UNIQUE INDEX "index_alchemy_folded_pages_on_page_id_and_user_id" ON "alchemy_folded_pages" ("page_id", "user_id")`e55ctablealchemy_folded_pagesalchemy_folded_pagesCREATE TABLE "alchemy_folded_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer NOT NULL, "user_id" integer NOT NULL, "folded" boolean DEFAULT 'f')|d77tablealchemy_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)&cY;Eindexindex_alchemy_essence_selects_on_valuealchemy_essence_selectsCREATE INDEX "index_alchemy_essence_selects_on_value" ON "alchemy_essence_selects" ("value")b;;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):a??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)9`e=]indexindex_alchemy_essence_pictures_on_picture_idalchemy_essence_picturesCREATE INDEX "index_alchemy_essence_pictures_on_picture_id" ON "alchemy_essence_pictures" ("picture_id")}_== 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)Q^77Atablealchemy_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)   3 AAAAAThomasvon Deyenthomas@vondeyen.commalede$2a$10$N7UcGKdn3XA1unHu2Xpttev1OZUuRiKPwcgJ.3ugvC/.UUPvtxTqG2017-10-24 14:43:12.7100472017-10-24 14:40:02.3547052017-10-24 14:40:02.354705::1::12017-10-24 14:40:02.3267752017-10-24 14:40:02.355691admin  de  de   &%    V%##%indextaggings_Q77Atablealchemy_essence_linksalchemy_essence_linksCREATE ;;7tablealchemy_essence_selectsalchemy_essence_selectsCREATE TABL&!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_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)9e=]indexindex_alchemy_essence_pictures_on_picture_idalchemy_essence_picturesCREATE INDEX "index_alchemy_essence_pictures_on_picture_id" ON "alchemy_essence_pictures" ("picture_id")}== 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)We7]indexindex_alchemy_essence_files_on_attachment_idalchemy_essence_filesCREAT&']/Mindexindex_alchemy_languages_on_language_codealchemy_languages#CREATE INDEX "index_alchemy_languages_on_language_code" ON "alchemy_languages" ("language_code")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")n%// tablealchemy_languagesalchemy_languages CREATE 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 NOT NULL, "locale" varchar)J$o5}indexindex_alchemy_folded_pages_on_page_id_and_user_idalchemy_folded_pagesCREATE UNIQUE INDEX "index_alchemy_folded_pages_on_page_id_and_user_id" ON "alchemy_folded_pages" ("page_id", "user_id")`#55ctablealchemy_folded_pagesalchemy_folded_pagesCREATE TABLE "alchemy_folded_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer NOT NULL, "user_id" integer NOT NULL, "folded" boolean DEFAULT 'f')|"77tablealchemy_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) A 2017-10-24 14:42:52.4      ,+*( intro  lD !AA 3MHenry6Henry6.jpg2017-10-24 14:43:12.6239932017-10-24 14:43:12.62399332131629665566221092017/10/24/6ws5yr1vy0_Henry6.jpg Rjpeg!AA 3MHenry4Henry4.jpg2017-10-24 14:43:12.5862062017-10-24 14:43:12.58620632131629665566221092017/10/24/6jj3l9ljzm_Henry4.jpgjpeg!AA 3MHenry5Henry5.jpg2017-10-24 14:43:12.5383612017-10-24 14:43:12.53836132131629665566221092017/10/24/457zolur6h_Henry5.jpg%jpeg!AA 3MHenry3Henry3.jpg2017-10-24 14:43:12.4892912017-10-24 14:43:12.48929132131629665566221092017/10/24/1k0wfg8k65_Henry3.jpgjpeg K %AA*Default Site2017-10-24 14:39:24.6525572017-10-24 14:39:24.652557f  *f 10 *  admin p i )  e nc// tablealchemy_languagesalchemy_languages CREATE 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 DEF6Xe7]indexindex_alchemy_essence_files_on_attachment_idalchemy_essence_filesCREATE INDEX "index_alchemy_essence_files_on_attachment_id" ON "alchemy_essence_files" ("attachment_id")nc// tablealchemy_languagesalchemy_languages CREATE 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 NOT NULL, "locale" varchar)Jbo5}indexindex_alchemy_folded_pages_on_page_id_and_user_idalchemy_folded_pagesCREATE UNIQUE INDEX "index_alchemy_folded_pages_on_page_id_and_user_id" ON "alchemy_folded_pages" ("page_id", "user_id")`a55ctablealchemy_folded_pagesalchemy_folded_pagesCREATE TABLE "alchemy_folded_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer NOT NULL, "user_id" integer NOT NULL, "folded" boolean DEFAULT 'f')|`77tablealchemy_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):]??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)9\e=]indexindex_alchemy_essence_pictures_on_picture_idalchemy_essence_picturesCREATE INDEX "index_alchemy_essence_pictures_on_picture_id" ON "alchemy_essence_pictures" ("picture_id")== tablealchemy_ess0i_=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")0h_=Qindexindex_alchemy_legacy_page_urls_on_page_idalchemy_legacy_page_urls&CREATE INDEX "index_alchemy_legacy_page_urls_on_page_id" ON "alchemy_legacy_page_urls" ("page_id")g==/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)fQ/5indexindex_alchemy_languages_on_site_idalchemy_languages$CREATE INDEX "index_alchemy_languages_on_site_id" ON "alchemy_languages" ("site_id")&e]/Mindexindex_alchemy_languages_on_language_codealchemy_languages#CREATE INDEX "index_alchemy_languages_on_language_code" ON "alchemy_languages" ("language_code")Xd/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")&_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) NZ|A = &cY;Eindexindex_alchemy_essence_selects_on_valuealchemy_essence_selectsCREATE INDEX "index_alchemy_essence_selects_on_value" ON "alchemy_essence_selects" ("value")b;;7tablealchqM';indexindex_pages_on_parent_id_and_lftalchemy_pages+CREATE INDEX "index_pages_on_parent_id_and_lft" ON "alchemy_pages" ("parent_id", "lft")3pi'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")=  G bp^L:(tb)20141119205158)20131015124700)20161106124022)20160518190421)20141119205156)20161106124024)20160614164603)20141119205157)20131018201541)20160518190427 )20160627081901 )20160518190425 )20131225232042 )20160322214808 )20141119205155)20131018201539)20141209144532)20131018201540)20160322214809)20160518190426)20160614164602)20161106124023)20161106124026 L_i0VL|C r)20141119205158)20131015124700)20161106124022)20160518190421)20141119205156)20161106124024)20160614164603)20141119205157)20131018201541)20160518190427)20160627081901 )20160518190425 )20131225232042 )20160322214808 )20141119205155 )20131018201539)20141209144532)20131018201540)20160322214809)20160518190426)20160614164602)20161106124023) 20161106124026 @"r^ J u b ] R@^ 1indexindex_tags_on_nametagsHCREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")% cWindexindex_taggings_on_tagger_id_and_tagger_typetaggingsECREATE INDEX "index_taggings_on_tagger_id_and_tagger_type" ON "taggings" ("tagger_id", "tagger_type")Nwtableeventsevents;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)Uindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsACREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")m= indexindex_taggings_on_tag_idtaggings@CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")#%indextaggings_idxtaggings?CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")p?indexindex_taggings_on_contexttaggings>CREATE INDEX "index_taggings_on_context" ON "taggings" ("context"){E'+indexindex_alchemy_users_on_emailalchemy_users6CREATE UNIQUE INDEX "index_alchemy_users_on_email" ON "alchemy_users" ("email")zU'=indexindex_alchemy_users_on_alchemy_rolesalchemy_users3CREATE INDEX "index_alchemy_users_on_alchemy_roles" ON "alchemy_users" ("alchemy_roles")*y''tablealchemy_usersalchemy_users"CREATE 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') tabletagstagsGCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)v Cindexindex_taggings_on_tagger_idtaggingsFCREATE INDEX "index_taggings_on_tagger_id" ON "taggings" ("tagger_id") K)indexindex_taggings_on_taggable_typetaggingsDCREATE INDEX "index_taggings_on_taggable_type" ON "taggings" ("taggable_type")|G!indexindex_taggings_on_taggable_idtaggingsCCREATE INDEX "index_taggings_on_taggable_id" ON "taggings" ("taggable_id")%Qindextaggings_idytaggingsBCREATE INDEX "taggings_idy" ON "taggings" ("taggable_id", "taggable_type", "tagger_id", "context")~Otabletaggingstaggings=CREATE 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)9Atablelocationslocations