SQLite format 3@ G3.G-& = w % Qsv11tablespotlight_contactsspotlight_contactsCREATE TABLE "spotlight_contacts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar, "name" varchar, "email" varchar, "title" varchar, "location" varchar, "telephone" varchar, "show_in_sidebar" boolean, "weight" integer DEFAULT 50, "exhibit_id" integer, "created_at" datetime, "updated_at" datetime, "contact_info" text, "avatar" varchar, "avatar_crop_x" integer, "avatar_crop_y" integer, "avatar_crop_w" integer, "avatar_crop_h" integer)]y=indexindex_spotlight_contact_emails_on_email_and_exhibit_idspotlight_contact_emailsCREATE UNIQUE INDEX "index_spotlight_contact_emails_on_email_and_exhibit_id" ON "spotlight_contact_emails" ("email", "exhibit_id")Xu= indexindex_spotlight_contact_emails_on_confirmation_tokenspotlight_contact_emailsCREATE UNIQUE INDEX "index_spotlight_contact_emails_on_confirmation_token" ON "spotlight_contact_emails" ("confirmation_token")t =={tablespotlight_contact_emailsspotlight_contact_emailsCREATE TABLE "spotlight_contact_emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "email" varchar DEFAULT '' NOT NULL, "confirmation_token" varchar, "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar, "created_at" datetime, "updated_at" datetime)o SSEtablespotlight_blacklight_configurationsspotlight_blacklight_configurations CREATE TABLE "spotlight_blacklight_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "facet_fields" text, "index_fields" text, "search_fields" text, "sort_fields" text, "default_solr_params" text, "show" text, "index" text, "default_per_page" integer, "per_page" text, "document_index_view_types" text, "thumbnail_size" varchar, "created_at" datetime, "updated_at" datetime) 77tablespotlight_attachmentsspotlight_attachments CREATE TABLE "spotlight_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "file" varchar, "uid" varchar, "exhibit_id" integer, "created_at" datetime, "updated_at" datetime)p ?indexindex_searches_on_user_idsearches CREATE INDEX "index_searches_on_user_id" ON "searches" ("user_id")Q utablesearchessearches CREATE TABLE "searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_params" text, "user_id" integer, "user_type" varchar, "created_at" datetime, "updated_at" datetime))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugs CREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")//1tablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime)tAindexindex_bookmarks_on_user_idbookmarksCREATE INDEX "index_bookmarks_on_user_id" ON "bookmarks" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) atablebookmarksbookmarksCREATE TABLE "bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "user_type" varchar, "document_id" varchar, "title" varchar, "created_at" datetime, "updated_at" datetime, "document_type                  Hn L 'v11tablespotlight_contactsspotlight_contac atablebookmarksbookmarksCREATE TABLE "bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "user_type" varchar, "document_id" varchar, "title" varchar, "created_at" datetime, "updated_at" datetime, "document_type" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)tAindexindex_bookmarks_on_user_idbookmarksCREATE INDEX "index_bookmarks_on_user_id" ON "bookmarks" ("user_id")//1tablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime)h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id"))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugs CREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")Q utablesearchessearches CREATE TABLE "searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_params" text, "user_id" integer, "user_type" varchar, "created_at" datetime, "updated_at" datetime)p ?indexindex_searches_on_user_idsearches CREATE INDEX "index_searches_on_user_id" ON "searches" ("user_id") 77tablespotlight_attachmentsspotlight_attachments CREATE TABLE "spotlight_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "file" varchar, "uid" varchar, "exhibit_id" integer, "created_at" datetime, "updated_at" datetime)o SSEtablespotlight_blacklight_configurationsspotlight_blacklight_configurations CREATE TABLE "spotlight_blacklight_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "facet_fields" text, "index_fields" text, "search_fields" text, "sort_fields" text, "default_solr_params" text, "show" text, "index" text, "default_per_page" integer, "per_page" text, "document_index_view_types" text, "thumbnail_size" varchar, "created_at" datetime, "updated_at" datetime)t =={tablespotlight_contact_emailsspotlight_contact_emailsCREATE TABLE "spotlight_contact_emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "email" varchar DEFAULT '' NOT NULL, "confirmation_token" varchar, "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar, "created_at" datetime, "updated_at" datetime)Xu= indexindex_spotlight_contact_emails_on_confirmation_tokenspotlight_contact_emailsCREATE UNIQUE INDEX "index_spotlight_contact_emails_on_confirmation_token" ON "spotlight_contact_emails" ("confirmation_token")]y=indexindex_spotlight_contact_emails_on_email_and_exhibit_idspotlight_contact_emailsCREATE UNIQUE INDEX "index_spotlight_contact_emails_on_email_and_exhibit_id" ON "spotlight_contact_emails" ("email", "exhibit_id")v11tablespotlight_contactsspotlight_contactsCREATE TABLE "spotlight_contacts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar, "name" varchar, "email" varchar, "title" varchar, "location" varchar, "telephone" varchar, "show_in_sidebar" boolean, "weight" integer DEFAULT 50, "exhibit_id" integer, "created_at" datetime, "updated_at" datetime, "contact_info" text, "avatar" varchar, "avatar_crop_x" integer, "avatar_crop_y" integer, "avatar_crop_w" integer, "avatar_crop_h" integer) ^o_ R 8I>j !11Atablespotlight_searchesspotlight_searches$CREATE TABLE "spotlight_searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "scope" varchar, "short_description" text, "long_description" text, "query_params" text, "weight" integer, "on_landing_page" boolean, "exhibit_id" integer, "created_at" datetime, "updated_at" datetime, "featured_item_id" varchar)!Y1Eindexindex_spotlight_contacts_on_exhibit_idspotlight_contactsCREATE INDEX "index_spotlight_contacts_on_exhibit_id" ON "spotlight_contacts" ("exhibit_id");;3tablespotlight_custo!Y1Eindexindex_spotlight_contacts_on_exhibit_idspotlight_contactsCREATE INDEX "index_spotlight_contacts_on_exhibit_id" ON "spotlight_contacts" ("exhibit_id");;3tablespotlight_custom_fieldsspotlight_custom_fieldsCREATE TABLE "spotlight_custom_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "slug" varchar, "field" varchar, "configuration" text, "created_at" datetime, "updated_at" datetime)K11Atablespotlight_exhibitsspotlight_exhibitsCREATE TABLE "spotlight_exhibits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "default" boolean, "title" varchar NOT NULL, "subtitle" varchar, "slug" varchar, "description" text, "created_at" datetime, "updated_at" datetime, "searchable" boolean DEFAULT 't', "layout" varchar)S1Gindexindex_spotlight_exhibits_on_defaultspotlight_exhibitsCREATE UNIQUE INDEX "index_spotlight_exhibits_on_default" ON "spotlight_exhibits" ("default")M1;indexindex_spotlight_exhibits_on_slugspotlight_exhibitsCREATE UNIQUE INDEX "index_spotlight_exhibits_on_slug" ON "spotlight_exhibits" ("slug")q++tablespotlight_locksspotlight_locksCREATE TABLE "spotlight_locks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "on_id" integer, "on_type" varchar, "by_id" integer, "by_type" varchar, "created_at" datetime, "updated_at" datetime)0a+aindexindex_spotlight_locks_on_on_id_and_on_typespotlight_locksCREATE UNIQUE INDEX "index_spotlight_locks_on_on_id_and_on_type" ON "spotlight_locks" ("on_id", "on_type")"AAOtablespotlight_main_navigationsspotlight_main_navigationsCREATE TABLE "spotlight_main_navigations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar, "weight" integer DEFAULT 20, "nav_type" varchar, "exhibit_id" integer, "created_at" datetime, "updated_at" datetime)AiAeindexindex_spotlight_main_navigations_on_exhibit_idspotlight_main_navigationsCREATE INDEX "index_spotlight_main_navigations_on_exhibit_id" ON "spotlight_main_navigations" ("exhibit_id")G++Etablespotlight_pagesspotlight_pagesCREATE TABLE "spotlight_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "type" varchar, "slug" varchar, "scope" varchar, "content" text, "weight" integer DEFAULT 50, "published" boolean, "exhibit_id" integer, "created_by_id" integer, "last_edited_by_id" integer, "created_at" datetime, "updated_at" datetime, "parent_page_id" integer, "display_sidebar" boolean, "display_title" boolean)S+9indexindex_spotlight_pages_on_exhibit_idspotlight_pagesCREATE INDEX "index_spotlight_pages_on_exhibit_id" ON "spotlight_pages" ("exhibit_id")![+Iindexindex_spotlight_pages_on_parent_page_idspotlight_pagesCREATE INDEX "index_spotlight_pages_on_parent_page_id" ON "spotlight_pages" ("parent_page_id")'[+Uindexindex_spotlight_pages_on_slug_and_scopespotlight_pages CREATE UNIQUE INDEX "index_spotlight_pages_on_slug_and_scope" ON "spotlight_pages" ("slug", "scope")33Ctablespotlight_resourcesspotlight_resources!CREATE TABLE "spotlight_resources" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "type" varchar, "url" varchar, "data" text, "indexed_at" datetime, "created_at" datetime, "updated_at" datetime)4++tablespotlight_rolesspotlight_roles"CREATE TABLE "spotlight_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "user_id" integer, "role" varchar)                  & 3 kh$e,5 indexindex_users_on_emailusers0CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")+ctableusersusers/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 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar,/=//indexunique_schema_migrationsschema_migrations3CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l.//tableschema_migrationsschema_migrations2CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)? k+uindexindex_spotlight_roles_on_exhibit_id_and_user_idspotlight_roles#CREATE UNIQUE INDEX "index_spotlight_roles_on_exhibit_id_and_user_id" ON "spotlight_roles" ("exhibit_id", "user_id") !11Atablespotlight_searchesspotlight_searches$CREATE TABLE "spotlight_searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "slug" varchar, "scope" varchar, "short_description" text, "long_description" text, "query_params" text, "weight" integer, "on_landing_page" boolean, "exhibit_id" integer, "created_at" datetime, "updated_at" datetime, "featured_item_id" varchar)!"Y1Eindexindex_spotlight_searches_on_exhibit_idspotlight_searches%CREATE INDEX "index_spotlight_searches_on_exhibit_id" ON "spotlight_searches" ("exhibit_id")3#a1aindexindex_spotlight_searches_on_slug_and_scopespotlight_searches'CREATE UNIQUE INDEX "index_spotlight_searches_on_slug_and_scope" ON "spotlight_searches" ("slug", "scope")9$MMetablespotlight_solr_document_sidecarsspotlight_solr_document_sidecars(CREATE TABLE "spotlight_solr_document_sidecars" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "exhibit_id" integer, "solr_document_id" varchar, "public" boolean DEFAULT 't', "data" text, "created_at" datetime, "updated_at" datetime)Y%uM}indexindex_spotlight_solr_document_sidecars_on_exhibit_idspotlight_solr_document_sidecars)CREATE INDEX "index_spotlight_solr_document_sidecars_on_exhibit_id" ON "spotlight_solr_document_sidecars" ("exhibit_id")l&Mindexindex_spotlight_solr_document_sidecars_on_solr_document_idspotlight_solr_document_sidecars*CREATE INDEX "index_spotlight_solr_document_sidecars_on_solr_document_id" ON "spotlight_solr_document_sidecars" ("solr_document_id")'Ytabletaggingstaggings+CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" varchar, "taggable_type" varchar, "tagger_id" integer, "tagger_type" varchar, "context" varchar(128), "created_at" datetime)#(%indextaggings_idxtaggings,CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")j)7tabletagstags-CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)^*1indexindex_tags_on_nametags.CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")+ctableusersusers/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 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime, "updated_at" datetime, "guest" boolean DEFAULT 'f')e,5 indexindex_users_on_emailusers0CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")-SGindexindex_users_on_reset_password_tokenusers1CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")            >p^L:(tbP>)20150120185736)20150120185735)20150120185734)20150120185733)20150120185732)20150120185731)20150120185730)20150120185729)20150120185728)20150120185727)20150120185726)20150120185725 )20150120185724 )20150120185723 )20150120185722 )20150120185721 )20150120185720)20150120185719)20150120185718)20150120185717)20150120185716)20150120185715)20150120185713)20150120185710)20150120185737 &|iVC0 r_L9&)20150120185736)20150120185735)20150120185734)20150120185733)20150120185732)20150120185731)20150120185730)20150120185729)20150120185728)20150120185727)20150120185726)20150120185725)20150120185724 )20150120185723 )20150120185722 )20150120185721 )20150120185720 )20150120185719)20150120185718)20150120185717)20150120185716)20150120185715)20150120185713)20150120185710) 20150120185737