SQLite format 3@  -   )20110801161138)20110801125309)20110801125209)20110801125109)20110801125009)20110801124909)20110801124809 {{)20110801161138)20110801125309)20110801125209)20110801125109)20110801125009)20110801124909)20110801124809  @@=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")@_tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(150), "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) 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, "failed_attempts" integer DEFAULT 0, "locked_at" datetime, "password_salt" varchar(255), "created_at" datetime, "updated_at" datetime)  roles users b^P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") O?indexindex_users_on_confirmation_tokenusers CREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")Iqtablerolesroles CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_type" integer(1) DEFAULT 0, "user_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)E gindexfk_userroles CREATE INDEX "fk_user" ON "roles" ("user_id")       nz5 !!5tablestructuresstructures CREATE TABLE "structures" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255) NOT NULL, "slug" varchar(25) NOT NULL, "kind" integer(1) DEFAULT 0, "position" integer(2) DEFAULT 0, "is_visible" boolean DEFAULT 't', "redirect_url" varchar(255), "parent_id" integer, "lft" integer DEFAULT 0, "rgt" integer DEFAULT 0, "depth" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime) O!/indexindex_structures_on_kind_and_slugstructuresCREATE INDEX "index_structures_on_kind_and_slug" ON "structures" ("kind", "slug")~ G!!indexindex_structures_on_parent_idstructuresCREATE INDEX "index_structures_on_parent_id" ON "structures" ("parent_id") K!'indexindex_structures_on_lft_and_rgtstructuresCREATE INDEX "index_structures_on_lft_and_rgt" ON "structures" ("lft", "rgt")     QQ/}4[tablepagespagesCREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255) NOT NULL, "content" text, "structure_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)Lsindexfk_pagespagesCREATE INDEX "fk_pages" ON "pages" ("structure_id")4CtableassetsassetsCREATE TABLE "assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "data_file_name" varchar(255) NOT NULL, "data_content_type" varchar(255), "data_file_size" integer, "assetable_id" integer NOT NULL, "assetable_type" varchar(25) NOT NULL, "type" varchar(25), "guid" varchar(10), "locale" integer(1) DEFAULT 0, "user_id" integer, "sort_order" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime)I} indexindex_assets_on_assetable_type_and_type_and_assetable_idassetsCREATE INDEX "index_assets_on_assetable_type_and_type_and_assetable_id" ON "assets" ("assetable_type", "type", "assetable_id")     u/kgindexindex_assets_on_assetable_type_and_assetable_idassetsCREATE INDEX "index_assets_on_assetable_type_and_assetable_id" ON "assets" ("assetable_type", "assetable_id")h; indexindex_assets_on_user_idassetsCREATE INDEX "index_assets_on_user_id" ON "assets" ("user_id")tableheadersheadersCREATE TABLE "headers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "keywords" varchar(255), "description" text, "headerable_type" varchar(30) NOT NULL, "headerable_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)      K)indexindex_widgets_on_widget_type_idwidgets CREATE INDEX "index_widgets_on_widget_type_id" ON "widgets" ("widget_type_id") S9indexindex_widgets_on_widget_position_idwidgetsCREATE INDEX "index_widgets_on_widget_position_id" ON "widgets" ("widget_position_id"){G!indexindex_widgets_on_structure_idwidgetsCREATE INDEX "index_widgets_on_structure_id" ON "widgets" ("structure_id")o')indexfk_headerableheadersCREATE INDEX "fk_headerable" ON "headers" ("headerable_type", "headerable_id")l/tablewidgetswidgetsCREATE TABLE "widgets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "structure_id" integer, "title" varchar(255) NOT NULL, "content" text, "is_visible" boolean DEFAULT 't', "sort_order" integer DEFAULT 0, "widget_type_id" integer(1) DEFAULT 0, "widget_position_id" integer(1) DEFAULT 0, "created_at" datetime, "updated_at" datetime)