SQLite format 3@ "   4 --Entry12009-01-01 05:002009-01-01 05:00f  seedings@ entries teamsTregions;bM users roles pools   QQP #333Test Pool 1f2009-02-24 18:29:262009-03-10 23:33:562009-03-10 23:33:56f[ #I33Test Pool 2fSun Mar 15 16:33:55 -0700 20092009-03-10 23:33:562009-03-10 23:33:56f kka3=tableentriesentriesCREATE TABLE "entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(64) NOT NULL, "data" blob, "created_at" datetime, "updated_at" datetime, "tie_break" integer, "user_id" integer DEFAULT 1 NOT NULL, "pool_id" integer, "completed" boolean DEFAULT 'f' NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)l= indexindex_entries_on_pool_identriesCREATE INDEX "index_entries_on_pool_id" ON "entries" ("pool_id")l= indexindex_entries_on_user_identriesCREATE INDEX "index_entries_on_user_id" ON "entries" ("user_id").;tablepoolspoolsCREATE TABLE "pools" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "data" blob, "started" boolean DEFAULT 'f' NOT NULL, "starts_at" datetime, "created_at" datetime, "updated_at" datetime, "user_id" integer, "active" boolean DEFAULT 'f' NOT NULL) 6ƾ 33Region12009-03-10 23:33:562009-03-10 23:33:566ۋM33Region22009-03-10 23:33:562009-03-10 23:33:56 MqtableregionsregionsCREATE TABLE "regions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pool_id" integer, "name" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime)Fktablerolesroles CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(32), "created_at" datetime, "updated_at" datetime, "position" integer DEFAULT 0 NOT NULL)d##tableroles_usersroles_users CREATE TABLE "roles_users" ("role_id" integer, "user_id" integer)a tableseedingsseedings CREATE TABLE "seedings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pool_id" integer, "team_id" integer, "region" varchar(255), "seed" integer, "created_at" datetime, "updated_at" datetime) 233admin2009-03-10 23:33:562009-03-10 23:33:56 1/,04.-o#{ouI' )~ 0$3+I(!%b:,Q`H*Tn!|=*&@"%n M?A  /]]33]aaronaaron@example.comd5600e3281af22fb000a384ef128652ca3ff96efc1dfd96eea8cc2b62785275bca38ac261256e2782009-03-09 23:33:562009-03-10 23:33:56fe5dbbcea5ce7e2988b8c69bcfdfde8904aabc1f  ]]333admin00742970dc9e6319f8019fd54864d3ea740f04b17e3041ebc2fc05a40c60028e2c4901a81035d3cd2009-03-09 23:33:562009-03-10 23:33:562009-03-05 23:33:56o  3]]33];3quentinquentin@example.comdccb78fe6c6ce433d5211def938929abb8852c9bac3478d69a3c81fa62e60f5c3696165a4e5e6ac42009-03-05 23:33:552009-03-10 23:33:56902ba3cda1883801594b6e1b452790cc53948fda2009-03-11 23:33:56 UTC2009-03-05 23:33:56> 3 7]]333old_password_holdersalty_dog@example.com00742970dc9e6319f8019fd54864d3ea740f04b17e3041ebc2fc05a40c60028e2c4901a81035d3cd2009-03-09 23:33:562009-03-10 23:33:562009-03-05 23:33:56 UwRU=//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)e 5 indexindex_users_on_loginusersCREATE UNIQUE INDEX "index_users_on_login" ON "users" ("login"); Utableteamsteams CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "short_name" varchar(255), "created_at" datetime, "updated_at" datetime) ktableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(40), "name" varchar(100) DEFAULT '', "email" varchar(100), "crypted_password" varchar(40), "salt" varchar(40), "created_at" datetime, "updated_at" datetime, "remember_token" varchar(40), "remember_token_expires_at" datetime, "activation_code" varchar(40), "activated_at" datetime)  aaron admin quentin3old_password_holder p^L:()20090218025240)20090225072849)20090301014710)20090301041526)20090218024350)20090225074149 )20090225022928 )20090225072358 )20090226142240 )20090217004039 )20090217001611)20090301025902)20090216015836)20090218024657)20090217014940)20090226021913)20090225030346)20090225084414)20090301090511 {UB /h)20090218025240)20090225072849)20090301014710)20090301041526)20090218024350)20090225074149)20090225022928 )20090225072358 )20090226142240 )20090217004039 )20090217001611 )20090301025902)20090216015836)20090218024657)20090217014940)20090226021913)20090225030346)20090225084414)20090301090511 ?x-fQ=)33North CarolinaUNC2009-03-01 01:58:182009-03-01 01:58:18=)33Mt. St. Mary'sMSM2009-03-01 01:58:182009-03-01 01:58:18633IndianaInd2009-03-01 01:58:182009-03-01 01:58:18733ArkansasArk2009-03-01 01:58:182009-03-01 01:58:188!33Notre DameND2009-03-01 01:58:182009-03-01 01:58:18:%33George MasonGM2009-03-01 01:58:182009-03-01 01:58:18=)33Washington St.WSt2009-03-01 01:58:182009-03-01 01:58:18733WinthropWin2009-03-01 01:58:182009-03-01 01:58:187 33OklahomaOkl2009-03-01 01:58:182009-03-01 01:58:18; %33St. Joseph'sStJ2009-03-01 01:58:182009-03-01 01:58:189 !33LouisvilleLou2009-03-01 01:58:182009-03-01 01:58:188 33Boise St.BSt2009-03-01 01:58:182009-03-01 01:58:185 33ButlerBut2009-03-01 01:58:182009-03-01 01:58:18<'33South AlabamaSAl2009-03-01 01:58:182009-03-01 01:58:18833TennesseeTen2009-03-01 01:58:182009-03-01 01:58:18 W7rQ633AmericanAm2009-03-01 01:58:182009-03-01 01:58:18533KansasKan2009-03-01 01:58:182009-03-01 01:58:18;%33Portland St.PSt2009-03-01 01:58:182009-03-01 01:58:18333UNLVULV2009-03-01 01:58:182009-03-01 01:58:18733Kent St.KSt2009-03-01 01:58:182009-03-01 01:58:18633ClemsonClm2009-03-01 01:58:182009-03-01 01:58:18833VillanovaVil2009-03-01 01:58:182009-03-01 01:58:189!33VanderbiltVan2009-03-01 01:58:182009-03-01 01:58:18433SienaSie2009-03-01 01:58:182009-03-01 01:58:18233USCUSC2009-03-01 01:58:182009-03-01 01:58:189!33Kansas St.KSU2009-03-01 01:58:192009-03-01 01:58:19833WisconsinWis2009-03-01 01:58:192009-03-01 01:58:19<'33CSU FullertonCSF2009-03-01 01:58:192009-03-01 01:58:19633GonzagaGon2009-03-01 01:58:192009-03-01 01:58:19733DavidsonDav2009-03-01 01:58:192009-03-01 01:58:19 FF*jP8!33GeorgetownGT2009-03-01 01:58:192009-03-01 01:58:193 33UMBCUBC2009-03-01 01:58:192009-03-01 01:58:196!33MemphisMem2009-03-01 01:58:192009-03-01 01:58:19;"%33TX ArlingtonTxA2009-03-01 01:58:192009-03-01 01:58:19>#+33Mississippi St.MiS2009-03-01 01:58:192009-03-01 01:58:195$33OregonOre2009-03-01 01:58:192009-03-01 01:58:19;%%33Michigan St.MSU2009-03-01 01:58:192009-03-01 01:58:195&33TempleTem2009-03-01 01:58:192009-03-01 01:58:199'!33PittsburghPit2009-03-01 01:58:192009-03-01 01:58:19;(%33Oral RobertsORo2009-03-01 01:58:192009-03-01 01:58:198)33MarquetteMar2009-03-01 01:58:192009-03-01 01:58:197*33KentuckyKen2009-03-01 01:58:192009-03-01 01:58:19 ppW=qY7+33StanfordSta2009-03-01 01:58:192009-03-01 01:58:196,33CornellCor2009-03-01 01:58:192009-03-01 01:58:199-!33Miami (FL)Mia2009-03-01 01:58:192009-03-01 01:58:199.!33St. Mary'sStM2009-03-01 01:58:192009-03-01 01:58:194/33TexasTex2009-03-01 01:58:192009-03-01 01:58:19:0#33Austin PeayAPe2009-03-01 01:58:192009-03-01 01:58:193133UCLAULA2009-03-01 01:58:192009-03-01 01:58:19=2)33Mis. Valley StMVS2009-03-01 01:58:192009-03-01 01:58:192333BYUBYU2009-03-01 01:58:192009-03-01 01:58:198433Texas A&MA&M2009-03-01 01:58:192009-03-01 01:58:194533DrakeDra2009-03-01 01:58:192009-03-01 01:58:19:6#33W. KentuckyWKy2009-03-01 01:58:192009-03-01 01:58:19:7#33ConnecticutCon2009-03-01 01:58:192009-03-01 01:58:197833San DiegoSD2009-03-01 01:58:192009-03-01 01:58:195933PurduePur2009-03-01 01:58:192009-03-01 01:58:195:33BaylorBay2009-03-01 01:58:192009-03-01 01:58:19 E'` C5;33XavierXav2009-03-01 01:58:192009-03-01 01:58:195<33GeorgiaUG2009-03-01 01:58:192009-03-01 01:58:19<='33West VirginiaWVa2009-03-01 01:58:192009-03-01 01:58:195>33ArizonaUA2009-03-01 01:58:192009-03-01 01:58:193?33DukeDuk2009-03-01 01:58:192009-03-01 01:58:196@33BelmontBel2009-03-01 01:58:192009-03-01 01:58:197A33Air ForceAF2009-03-01 04:12:292009-03-01 04:12:294B33AkronAkr2009-03-01 04:12:292009-03-01 04:12:296C33AlabamaAla2009-03-01 04:12:292009-03-01 04:12:29j+33Cleveland StateClS2009-03-01 04:12:292009-03-01 04:12:29?k-33Coastal CarolinaCCa2009-03-01 04:12:292009-03-01 04:12:296l33ColgateCgt2009-03-01 04:12:292009-03-01 04:12:297m33ColoradoCol2009-03-01 04:12:292009-03-01 04:12:29=n)33Colorado StateCoS2009-03-01 04:12:292009-03-01 04:12:29 D{,cDJ=~5v33DePaulDPl2009-03-01 04:12:302009-03-01 04:12:30;o%33Coppin StateCpn2009-03-01 04:12:292009-03-01 04:12:298p33CreightonCgh2009-03-01 04:12:292009-03-01 04:12:298q33DartmouthDrt2009-03-01 04:12:292009-03-01 04:12:295r33DaytonDay2009-03-01 04:12:292009-03-01 04:12:297s33DelawareDel2009-03-01 04:12:292009-03-01 04:12:29=t)33Delaware StateDSt2009-03-01 04:12:292009-03-01 04:12:295u33DenverDen2009-03-01 04:12:292009-03-01 04:12:296w33DetroitDet2009-03-01 04:12:302009-03-01 04:12:305x33DrexelDrx2009-03-01 04:12:302009-03-01 04:12:307y33DuquesneDuq2009-03-01 04:12:302009-03-01 04:12:3033ManhattanMan2009-03-01 04:12:302009-03-01 04:12:305?33MaristMst2009-03-01 04:12:302009-03-01 04:12:307@33MarshallMsh2009-03-01 04:12:302009-03-01 04:12:307A33MarylandMry2009-03-01 04:12:302009-03-01 04:12:30EB933Maryland-Eastern ShoreMES2009-03-01 04:12:302009-03-01 04:12:30+33St. BonaventureStB2009-03-01 04:12:322009-03-01 04:12:32?-33St. Francis (NY)SFN2009-03-01 04:12:322009-03-01 04:12:32? -33St. Francis (PA)SFP2009-03-01 04:12:322009-03-01 04:12:329!!33St. John'sSJn2009-03-01 04:12:322009-03-01 04:12:32:"#33St. Peter'sStP2009-03-01 04:12:322009-03-01 04:12:32@#/33Stephen F. AustinSFA2009-03-01 04:12:322009-03-01 04:12:326$33StetsonSts2009-03-01 04:12:322009-03-01 04:12:327%33SyracuseSyr2009-03-01 04:12:322009-03-01 04:12:32 UUPP?K-33Western IllinoisWIl2009-03-01 04:12:322009-03-01 04:12:326P33WoffordWof2009-03-01 04:12:322009-03-01 04:12:32;Q%33Wright StateWrS2009-03-01 04:12:322009-03-01 04:12:32?J-33Western CarolinaWCa2009-03-01 04:12:322009-03-01 04:12:32?L-33Western MichiganWMi2009-03-01 04:12:322009-03-01 04:12:32'+33Tennessee StateTSt2009-03-01 04:12:322009-03-01 04:12:32=()33Tennessee TechTTc2009-03-01 04:12:322009-03-01 04:12:32?)-33Tennessee-MartinTnM2009-03-01 04:12:322009-03-01 04:12:32;*%33Texas A&M-CCTAC2009-03-01 04:12:322009-03-01 04:12:32=+)33Texas SouthernTxS2009-03-01 04:12:322009-03-01 04:12:32A,133Texas-Pan AmericanTPA2009-03-01 04:12:322009-03-01 04:12:32@-/33Texas-San AntonioTSA2009-03-01 04:12:322009-03-01 04:12:325.33ToledoTol2009-03-01 04:12:322009-03-01 04:12:325/33TowsonTow2009-03-01 04:12:322009-03-01 04:12:323033TroyTry2009-03-01 04:12:322009-03-01 04:12:325133TulaneTln2009-03-01 04:12:322009-03-01 04:12:324233TulsaTul2009-03-01 04:12:322009-03-01 04:12:322333UABUAB2009-03-01 04:12:322009-03-01 04:12:32 ^M4uDZ733Cal State BakersfieldCSB2009-03-01 04:12:292009-03-01 04:12:294U33BrownBwn2009-03-01 04:12:292009-03-01 04:12:29@V/33Bryant UniversityBry2009-03-01 04:12:292009-03-01 04:12:297W33BucknellBuk2009-03-01 04:12:292009-03-01 04:12:296X33BuffaloBuf2009-03-01 04:12:292009-03-01 04:12:297Y33Cal PolyCPy2009-03-01 04:12:292009-03-01 04:12:29C[533Cal State NorthridgeCSN2009-03-01 04:12:292009-03-01 04:12:299\!33CaliforniaCal2009-03-01 04:12:292009-03-01 04:12:297]33CampbellCmb2009-03-01 04:12:292009-03-01 04:12:297^33CanisiusCan2009-03-01 04:12:292009-03-01 04:12:298_33CentenaryCen2009-03-01 04:12:292009-03-01 04:12:29?`-33Central ArkansasCAr2009-03-01 04:12:292009-03-01 04:12:29Ha?33Central Connecticut StateCCS2009-03-01 04:12:292009-03-01 04:12:29?b-33Central MichiganCMU2009-03-01 04:12:292009-03-01 04:12:29 =x,bQ7433UC DavisUCD2009-03-01 04:12:322009-03-01 04:12:328533UC IrvineUCI2009-03-01 04:12:322009-03-01 04:12:32;6%33UC RiversideUCR2009-03-01 04:12:322009-03-01 04:12:32>7-33UC Santa BarbaraSB2009-03-01 04:12:322009-03-01 04:12:322833UCFUCF2009-03-01 04:12:322009-03-01 04:12:323933UMKCUMK2009-03-01 04:12:322009-03-01 04:12:32=:)33UNC GreensboroUNG2009-03-01 04:12:322009-03-01 04:12:32:;#33USC UpstateUsU2009-03-01 04:12:322009-03-01 04:12:323<33UtahUta2009-03-01 04:12:322009-03-01 04:12:329=!33Utah StateUSt2009-03-01 04:12:322009-03-01 04:12:32:>#33Utah ValleyUVa2009-03-01 04:12:322009-03-01 04:12:323?33UTEPUTP2009-03-01 04:12:322009-03-01 04:12:329@!33ValparaisoVal2009-03-01 04:12:322009-03-01 04:12:32 {!]I?|{6 33SamfordSam2009-03-01 04:12:312009-03-01 04:12:31433RiderRid2009-03-01 04:12:312009-03-01 04:12:31333RiceRic2009-03-01 04:12:312009-03-01 04:12:319}!33ProvidencePro2009-03-01 04:12:312009-03-01 04:12:319~!33QuinnipiacQui2009-03-01 04:12:312009-03-01 04:12:31633RadfordRad2009-03-01 04:12:312009-03-01 04:12:31:%33Rhode IslandRI2009-03-01 04:12:312009-03-01 04:12:31733RichmondRch2009-03-01 04:12:312009-03-01 04:12:31<'33Robert MorrisRbM2009-03-01 04:12:312009-03-01 04:12:31433RutgersR2009-03-01 04:12:312009-03-01 04:12:31?-33Sacramento StateSSt2009-03-01 04:12:312009-03-01 04:12:31;%33Sacred HeartScH2009-03-01 04:12:312009-03-01 04:12:31:#33Saint LouisStL2009-03-01 04:12:312009-03-01 04:12:31@ /33Sam Houston StateSHS2009-03-01 04:12:312009-03-01 04:12:31> +33San Diego StateSDS2009-03-01 04:12:312009-03-01 04:12:31 )bP:#33Idaho StateISt2009-03-01 04:12:302009-03-01 04:12:30633HofstraHof2009-03-01 04:12:302009-03-01 04:12:309!33Holy CrossHCr2009-03-01 04:12:302009-03-01 04:12:30633HoustonHou2009-03-01 04:12:302009-03-01 04:12:30>+33Houston BaptistHBa2009-03-01 04:12:302009-03-01 04:12:30533HowardHow2009-03-01 04:12:302009-03-01 04:12:30433IdahoIda2009-03-01 04:12:302009-03-01 04:12:306 33IllinoisIl2009-03-01 04:12:302009-03-01 04:12:30=!)33Illinois StateIlS2009-03-01 04:12:302009-03-01 04:12:30 -e(gS>+33Grambling StateGrS2009-03-01 04:12:302009-03-01 04:12:305 33FurmanFur2009-03-01 04:12:302009-03-01 04:12:30; %33Gardner-WebbG-W2009-03-01 04:12:302009-03-01 04:12:30@/33George WashingtonGWa2009-03-01 04:12:302009-03-01 04:12:30?-33Georgia SouthernGSo2009-03-01 04:12:302009-03-01 04:12:30<'33Georgia StateGSt2009-03-01 04:12:302009-03-01 04:12:30;%33Georgia TechGTc2009-03-01 04:12:302009-03-01 04:12:30833Green BayGBy2009-03-01 04:12:302009-03-01 04:12:30633HamptonHam2009-03-01 04:12:302009-03-01 04:12:30733HartfordHrt2009-03-01 04:12:302009-03-01 04:12:30633HarvardHvd2009-03-01 04:12:302009-03-01 04:12:30533HawaiiHaw2009-03-01 04:12:302009-03-01 04:12:309!33High PointHiP2009-03-01 04:12:302009-03-01 04:12:30 ""aV J=I)33Arkansas StateAkS2009-03-01 04:12:292009-03-01 04:12:29CJ533Arkansas-Little RockALR2009-03-01 04:12:292009-03-01 04:12:29BK333Arkansas-Pine BluffAPB2009-03-01 04:12:292009-03-01 04:12:293L33ArmyArm2009-03-01 04:12:292009-03-01 04:12:295M33AuburnAub2009-03-01 04:12:292009-03-01 04:12:299N!33Ball StateBaS2009-03-01 04:12:292009-03-01 04:12:29>O+33Bethune-CookmanBCk2009-03-01 04:12:292009-03-01 04:12:299P!33BinghamtonBin2009-03-01 04:12:292009-03-01 04:12:2933>Region32009-03-10 23:33:562009-03-10 23:33:568?33?Region32009-03-10 23:33:562009-03-10 23:33:568@33@Region32009-03-10 23:33:562009-03-10 23:33:56