SQLite format 3@ *5*- @zV3x s5tablerel_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 NOT NULL, "updated_at" datetime NOT NULL)`!! tablefans_teamsfans_teamsCREATE TABLE "fans_teams" ("fan_id" integer, "team_id" integer)8StablefansfansCREATE TABLE "fans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(100) NOT NULL) O/indexindex_histories_on_item_and_tablehistoriesCREATE INDEX "index_histories_on_item_and_table" ON "histories" ("item", "table") Otablehistorieshistories CREATE TABLE "histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "message" varchar(255), "username" varchar(255), "item" integer, "table" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime 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"): Stableusersusers 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 NOT NULL, "updated_at" datetime NOT NULL, "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "roles" varchar(255))Cetableteamsteams CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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)) tableplayersplayersCREATE TABLE "players" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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')@WtableleaguesleaguesCREATE TABLE "leagues" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(50) NOT NULL)/9tabledraftsdraftsCREATE TABLE "drafts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "player_id" integer, "team_id" integer, "date" date, "round" integer, "pick" integer, "overall" integer, "college" varchar(100), "notes" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)[tabledivisionsdivisionsCREATE TABLE "divisions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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  $)m[I7%q_M;)$)20120319041705#)20120118122004")20120117151733!)20111215083258 )20111130075338)20111123092549)20111115041025)20111108143642)20111103174459)20110901154834)20110901150912)20110901142530)20110901131551)20110831090841)20110714095433)20110607152842)20110329183136)20110328193014)20110224184303)20110123042530)20110103205808)2010122322223314 13 12 11 10 987654321 $n[H5"wdQ>+)20120319041705$)20120118122004#)20120117151733")20111215083258!)20111130075338 )20111123092549)20111115041025)20111108143642)20111103174459)20110901154834)20110901150912)20110901142530)20110901131551)20110831090841)20110714095433)20110607152842)20110329183136)20110328193014)20110224184303)20110123042530)20110103205808)201012232222331413 12 11 10 9 87654321   balls users     i7AAAAadmin@getupstream.com$2a$10$DHSfOVXBLIf1XbosjYhyceAEcM18ZpDeIwsBbpK61ouWORplaRZGy2012-04-29 16:18:22.3187732012-04-29 16:18:22.318773127.0.0.1127.0.0.12012-04-29 16:18:13.0959592012-04-29 16:18:22.320209--- [] 7admin@getupstream.com       0  C C C o n   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")[tabledivisionsdivisionsCREATE TABLE "divisions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "league_id" integer, "name" varchar(50) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/9tabledraftsdraftsCREATE TABLE "drafts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "player_id" integer, "team_id" integer, "date" date, "round" integer, "pick" integer, "overall" integer, "college" varchar(100), "notes" text)@WtableleaguesleaguesCREATE TABLE "leagues" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(50) NOT NULL) tableplayersplayersCREATE TABLE "players" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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,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") }tabledivisionsdivisionsCREATE TABLE "divisions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "league_id" integer, "name" varchar(50) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/9tabledraftsdraftsCREATE TABLE "drafts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "player_id" integer, "team_id" integer, "date" date, "round" integer, "pick" integer, "overall" integer, "college" varchar(100), "notes" text)@WtableleaguesleaguesCREATE TABLE "leagues" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(50) NOT NULL) tableplayersplayersCREATE TABLE "players" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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')etableteamsteams CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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)): Stableusersusers 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 NOT NULL, "updated_at" datetime NOT NULL, "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "roles" varchar(255)) .I q>H.. !!_tablecategoriescategoriesCREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_category_id" integer)Kutableteamsteams CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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))<Ktablefoo_barsfoo_barsCREATE TABLE "foo_bars" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)s11tablenested_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 NOT NULL, "updated_at" datetime NOT NULL)N))Wtableunscoped_pagesunscoped_pagesCREATE TABLE "unscoped_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) O7Gindexindex_histories_on_item_and_tablerails_admin_historiesCREATE INDEX "index_histories_on_item_and_table" ON "rails_admin_histories" ("item", "table")!77atablerails_admin_historiesrails_admin_histories CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)i!tabledivisionsdivisionsCREATE TABLE "divisions" ("created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "custom_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "custom_league_id" integer, "name" varchar(50) NOT NULL)HotableballsballsCREATE TABLE "balls" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "color" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "type" varchar(255))a++ytablecms_basic_pagescms_basic_pagesCREATE TABLE "cms_basic_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ##Ytablefield_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 NOT NULL, "updated_at" datetime NOT NULL, "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))q5tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commentable_id" integer, "commentable_type" varchar(255), "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)5tablerel_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 NOT NULL, "updated_at" datetime NOT NULL)`!! tablefans_teamsfans_teamsCREATE TABLE "fans_teams" ("fan_id" integer, "team_id" integer)8StablefansfansCREATE TABLE "fans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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")   ~~?AAGreen2012-04-29 16:21:17.4958102012-04-29 16:21:17.495810?AAGreen2012-04-29 16:20:54.0876102012-04-29 16:20:54.087610