SQLite format 3@ &d&-%  )-o )G O7Gindexindex_histories_on_item_and_tablerails_admin_historiesCREATE INDEX "index_histories_on_item_and_table" ON "rails_admin_histories" ("item", "table")_tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commentable_id" integer, "commentable_type" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)atablerel_testsrel_testsCREATE TABLE "rel_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "league_id" integer, "division_id" integer NOT NULL, "player_id" integer, "created_at" datetime, "updated_at" datetime)`!! tablefans_teamsfans_teamsCREATE TABLE "fans_teams" ("fan_id" integer, "team_id" integer)&/tablefansfansCREATE TABLE "fans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "name" varchar(100) NOT NULL)77Ctablerails_admin_historiesrails_admin_historiesCREATE TABLE "rails_admin_histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "message" varchar(255), "username" varchar(255), "item" integer, "table" varchar(255), "created_at" datetime, "updated_at" datetime)SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")( /tableusersusers CREATE 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), "password_salt" varchar(255), "created_at" datetime, "updated_at" datetime, "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "roles" varchar(255))1 Atableteamsteams CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "league_id" integer, "division_id" integer, "name" varchar(50), "logo_url" varchar(255), "manager" varchar(100) NOT NULL, "ballpark" varchar(100), "mascot" varchar(100), "founded" integer, "wins" integer, "losses" integer, "win_percentage" float, "revenue" decimal(18,2), "color" varchar(255)) itableplayersplayers CREATE TABLE "players" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "team_id" integer, "name" varchar(100) NOT NULL, "position" varchar(50), "number" integer NOT NULL, "retired" boolean DEFAULT 'f', "injured" boolean DEFAULT 'f', "born_on" date, "notes" text, "suspended" boolean DEFAULT 'f'). 3tableleaguesleaguesCREATE TABLE "leagues" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "name" varchar(50) NOT NULL)tabledraftsdraftsCREATE TABLE "drafts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "player_id" integer, "team_id" integer, "date" date, "round" integer, "pick" integer, "overall" integer, "college" varchar(100), "notes" text)IatabledivisionsdivisionsCREATE TABLE "divisions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "league_id" integer, "name" varchar(50) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name &m[I7%q_M;)&)20140412075608%)20120928075608$)20120720075608#)20120319041705")20120118122004!)20120117151733 )20111215083258)20111130075338)20111123092549)20111115041025)20111108143642)20110901154834)20110901150912)20110901142530)20110901131551)20110831090841)20110714095433)20110607152842)20110329183136)20110328193014)20110224184303)20110123042530)20110103205808)2010122322223314 13 12 11 10 987654321 & o\I6#xeR?, )20140412075608&)20120928075608%)20120720075608$)20120319041705#)20120118122004")20120117151733!)20111215083258 )20111130075338)20111123092549)20111115041025)20111108143642)20110901154834)20110901150912)20110901142530)20110901131551)20110831090841)20110714095433)20110607152842)20110329183136)20110328193014)20110224184303)20110123042530)20110103205808)201012232222331413 12 11 10 9 8765432 1 )20140412075608&)20120928075608%)20120720075608$)20120319041705#)20120118122004")20120117151733!)20111215083258 )20111130075338)20111123092549)20111115041025)20111108143642)20110901154834)20110901150912)20110901142530)20110901131551)20110831090841)20110714095433)20110607152842)20110329183136)20110328193014)20110224184303)20110123042530)20110103205808)201012232222331413 12 11 10 9 8765432 1 ' rails_admin_histories comments1nested_field_tests# field_tests          IAA2014-08-19 12:09:12.3570342014-08-19 12:09:12.357034      FF f  B o )G O7Gindexindex_histories_on_item_and_tablerails_admin_historiesCREATE I O7Gindexindex_histories_on_item_and_tablerails_admin_historiesCREATE INDEX "index_histories_on_item_and_table" ON "rails_admin_histories" ("item", "table")_tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commentable_id" integer, "commentable_type" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)atablerel_testsrel_testsCREATE TABLE "rel_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "league_id" integer, "division_id" integer NOT NULL, "player_id" integer, "created_at" datetime, "updated_at" datetime)`!! tablefans_teamsfans_teamsCREATE TABLE "fans_teaP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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")tabledraftsdraftsCREATE TABLE "drafts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "player_id" integer, "team_id" integer, "date" date, "round" integer, "pick" integer, "overall" integer, "college" varchar(100), "notes" text). 3tableleaguesleaguesCREATE TABLE "leagues" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "name" varchar(50) NOT NULL) itableplayersplayers CREATE TABLE "players" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "team_id" integer, "name" varchar(100) NOT NULL, "position" varchar(50), "number" integer NOT NULL, "retired" boolean DEFAULT 'f', "injured" boolean DEFAULT 'f', "born_on" date, "notes" text, "suspended" boolean DEFAULT 'f')( /tableusersusers CREATE 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), "password_salt" varchar(255), "created_at" datetime, "updated_at" datetime, "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "roles" varchar(255))e 5 indexindex_users_on_emailusers CREATE 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")&/tablefansfansCREATE TABLE "fans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "name" varchar(100) NOT NULL)`!! tablefans_teamsfans_teamsCREATE TABLE "fans_teams" ("fan_id" integer, "team_id" integer)_tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commentable_id" integer, "commentable_type" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)w##5tablefield_testsfield_testsCREATE TABLE "field_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "string_field" varchar(255), "text_field" text, "integer_field" integer, "float_field" float, "decimal_field" decimal, "datetime_field" datetime, "timestamp_field" datetime, "time_field" time, "date_field" date, "boolean_field" boolean, "created_at" datetime, "updated_at" datetime, "format" varchar(255), "restricted_field" varchar(255), "protected_field" varchar(255), "paperclip_asset_file_name" varchar(255), "dragonfly_asset_uid" varchar(255), "carrierwave_asset" varchar(255), "dragonfly_asset_name" varchar(255)) Z 4 F   @ u!etableimagesimagesCREATE TABLE "images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_file_name" varchar(255), "file_content_type" varchar(255), "file_file_size" integer, "file_updated_at" datetime, "created_at" datetime, "updated_at" datetime)11/tablenested_field_testsnested_field_testsCREATE TABLE "nested_field_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "field_test_id" integer, "created_at" datetime, "updated_at" datetime, "another_field_test_id" integer)5 33tableanother_field_testsanother_field_testsCREATE TABLE "another_field_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime) !!_tablecategoriescategoriesCREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_category_id" integer)*'tablefoo_barsfoo_barsCREATE TABLE "foo_bars" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime, "updated_at" datetime)8g7_indexindex_rails_admin_histories_on_item_and_tablerails_admin_historiesCREATE INDEX "indeO++Utablecms_basic_pagescms_basic_pagesCREATE TABLE "cms_basic_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)9Qtableteamsteams CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "division_id" integer, "name" varchar(50), "logo_url" varchar(255), "manager" varchar(100) NOT NULL, "ballpark" varchar(100), "mascot" varchar(100), "founded" integer, "wins" integer, "losses" integer, "win_percentage" float, "revenue" decimal(18,2), "color" varchar(255), "custom_field" varchar(255))6KtableballsballsCREATE TABLE "balls" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "color" varchar(255), "created_at" datetime, "updated_at" datetime, "type" varchar(255))W}tabledivisionsdivisionsCREATE TABLE "divisions" ("created_at" datetime, "updated_at" datetime, "custom_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "custom_league_id" integer, "name" varchar(50) NOT NULL)77=tablerails_admin_historiesrails_admin_historiesCREATE TABLE "rails_admin_histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "message" text(255), "username" varchar(255), "item" integer, "table" varchar(255), "created_at" datetime, "updated_at" datetime)8g7_indexindex_rails_admin_histories_on_item_and_tablerails_admin_historiesCREATE INDEX "index_rails_admin_histories_on_item_and_table" ON "rails_admin_histories" ("item", "table")11/tablenested_field_testsnested_field_testsCREATE TABLE "nested_field_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "field_test_id" integer, "created_at" datetime, "updated_at" datetime, "another_field_test_id" integer)*'tablefoo_barsfoo_barsCREATE TABLE "foo_bars" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime, "updated_at" datetime) !!_tablecategoriescategoriesCREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_category_id" integer)5 33tableanother_field_testsanother_field_testsCREATE TABLE "another_field_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)!etableimagesimagesCREATE TABLE "images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_file_name" varchar(255), "file_content_type" varchar(255), "file_file_size" integer, "file_updated_at" datetime, "created_at" datetime, "updated_at" datetime)}"?? tabledeeply_nested_field_testsdeeply_nested_field_testsCREATE TABLE "deeply_nested_field_tests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "nested_field_test_id" integer, "title" varchar(255), "created_at" datetime, "updated_at" datetime)   xB AAtitle 22014-08-19 12:09:12.3648272014-08-19 12:09:12.370362B AAtitle 12014-08-19 12:09:12.3613192014-08-19 12:09:12.368658