SQLite format 3@ -  )-o )GGO7Gindexindex_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;)%)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   )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 % o\I6#xeR?, )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' rails_admin_histories comments(nested_field_tests field_tests          ] ; AAstring_field: nil -> "", text_field: nil -> "", boolean_field: nil -> false, format: nil -> "", restricted_field: nil -> "", protected_field: nil -> ""FieldTest2014-01-04 17:15:06.7890002014-01-04 17:15:06.789000    FieldTest    Z 9AAFieldTestnested comment content2014-01-04 17:15:06.7810002014-01-04 17:15:06.781000 x)){D d  U U U c _ t  cEO7Gindexindex_histories_on_item_and_tablerails_admin_historiesCRP++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")IatabledivisionsdivisionsCREATE TABLE "divisions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "league_id" integer, "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). 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')1 Atableteamsteams CREATE TABLP++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") atabledivisionsdivisionsCREATE TABLE "divisions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "league_id" integer, "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). 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')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))( /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)) J AA f2014-01-04 17:14:59.6420002014-01-04 17:15:06.762000 [  V|jp$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)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) 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)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")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)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)6KtableballsballsCREATE TABLE "balls" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "color" varchar(255), "created_at" datetime, "updated_at" datetime, "type" varchar(255))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))O++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)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))_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)`!! 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)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")   xD AAtitle 22014-01-04 17:14:59.6610002[M AAnested field test title 1 edited2014-01-04 17:14:59.6530002014-01-04 17:15:06.776000