#
# Football Officials' Associations
#
INSERT INTO officials_associations (slug,name,other_name,sport,website,oregon_region,updated_at,created_at) VALUES 
("BMF","Blue Mountain Football",NULL,"Football",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("COF","Central Oregon Football",NULL,"Football",NULL,"CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("DCF","Douglas County Football",NULL,"Football",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("KFFA","Klamath Falls Football Association",NULL,"Football","http://www.reftown.com/Default.asp?Assoc=KFF","SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LCFOA","Lane County Football Officials Association",NULL,"Football","http://www.lcfoa.com","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LCF","Lower Columbia Football",NULL,"Football",NULL,"METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TDOA","Third District Officials Association","Malheur County Football","Football","http://www.idahoofficials.com","EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MCF","Mid-Columbia Football",NULL,"Football",NULL,"GORGE","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MWFOA","Midwestern Football Officials Association",NULL,"Football","http://www.midwesternfootballofficials.com","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NCF","North Coast Football",NULL,"Football",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NEOF","Northeast Oregon Football",NULL,"Football",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("PFOA","Portland Football Officials Association",NULL,"Football","http://www.pfoa.us","METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("RVF","Rogue Valley Football",NULL,"Football",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SFOA","Salem Football Officials Association",NULL,"Football","http://www.salemfbrefs.org","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWOFOA","Southwestern Oregon Football Officials Association",NULL,"Football","https://sites.google.com/site/swofoa","COAST","2014-10-13 00:00:00","2014-10-13 00:00:00")

#
# Volleyball Officials' Associations
#
INSERT INTO officials_associations (slug,name,other_name,sport,website,oregon_region,updated_at,created_at) VALUES 
("BMV","Blue Mountain Volleyball",NULL,"Volleyball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("COVA","Central Oregon Volleyball Association",NULL,"Volleyball","http://www.reftown.com/Default.asp?Assoc=COVOA","CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("DCV","Douglas County Volleyball",NULL,"Volleyball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("EEVO","Emerale Empire Volleyball Officials",NULL,"Volleyball","http://www.eevo.org","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("GPVOA","Greater Portland Volleyball Officials Association",NULL,"Volleyball","http://www.gpvoa.org","METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("KCV","Klamath County Volleyball",NULL,"Volleyball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TDOA","Third District Officials Association","Malheur County Volleyball","Volleyball","http://www.idahoofficials.com","EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MCV","Mid-Columbia Volleyball",NULL,"Volleyball",NULL,"GORGE","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MVOA","Mid-Valley Volleyball Officials Association",NULL,"Volleyball","http://www.reftown.com/Default.asp?Assoc=MVOA","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NCV","North Coast Volleyball",NULL,"Volleyball",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NEOV","Northeast Oregon Volleyball",NULL,"Volleyball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SVOA","Salem Volleyball Officials Association",NULL,"Volleyball","http://www.reftown.com/Default.asp?Assoc=SVOA","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SOV","South Oregon Volleyball",NULL,"Volleyball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWLV","Southwest Longview Volleyball",NULL,"Volleyball",NULL,"METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWOV","Southwest Oregon Volleyball",NULL,"Volleyball",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TRV","Three Rivers Volleyball",NULL,"Volleyball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TCV","Tri-Co Volleyball",NULL,"Volleyball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00")

#
# Soccer Officials' Associations 
#
INSERT INTO officials_associations (slug,name,other_name,sport,website,oregon_region,updated_at,created_at) VALUES
("BMS","Blue Mountain Soccer",NULL,"Soccer",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("COSOA","Central Oregon Soccer Officials Association",NULL,"Soccer","http://www.cosoa.org","CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("CBS","Coos/Brookings Soccer",NULL,"Soccer",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("DCS","Douglas County Soccer",NULL,"Soccer",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("HSOA","Hermiston Soccer Officials Association",NULL,"Soccer","http://www.hermistonsoccerofficials.org","EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("KSR","Klamath Soccer Referees",NULL,"Soccer",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LCSRA","Lane County Soccer Referees Association",NULL,"Soccer","http://www.lcsra.org","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MCS","Mid-Columbia Soccer",NULL,"Soccer",NULL,"GORGE","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MVSRA","Mid-Valley Soccer Referees Association",NULL,"Soccer","http://www.mvsra.net","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NCS","North Coast Soccer",NULL,"Soccer",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MISOA","Metropolitan Interscholastic Soccer Officials Association",NULL,"Soccer","http://www.misoarefs.org/","METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SSRA","Salem Soccer Referees Association",NULL,"Soccer","http://ssraref.com","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SOS","Southern Oregon Soccer",NULL,"Soccer",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00")

#
# Basketball Officials' Associations
#
INSERT INTO officials_associations (slug,name,other_name,sport,website,oregon_region,updated_at,created_at) VALUES
("BMBOA","Blue Mountain Basketball Officials Association",NULL,"Basketball","http://www.reftown.com/Default.asp?Assoc=BMBOA","EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("COB","Central Oregon Basketball",NULL,"Basketball",NULL,"CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("DCB","Douglas County Basketball",NULL,"Basketball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("GPB","Grants Pass Basketball",NULL,"Basketball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("KFB","Klamath Falls Basketball",NULL,"Basketball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LCBOA","Lane County Basketball Officials Association",NULL,"Basketball",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LB","Longview Basketball",NULL,"Basketball",NULL,"METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TDOA","Third District Officials Association","Malheur County Basketball","Basketball","http://www.idahoofficials.com","EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MCB","Mid-Columbia Basketball",NULL,"Basketball",NULL,"GORGE","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MVBOA","Mid-Valley Basketball Officials Association",NULL,"Basketball","http://www.mvbofficials.com","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NCBOA","North Coast Basketball Officials Association",NULL,"Basketball","http://www.reftown.com/Default.asp?Assoc=NCBOA","COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NEOB","Northeast Oregon Basketball",NULL,"Basketball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("PBOA","Portland Basketball Officials Association",NULL,"Basketball","http://www.reftown.com/?Assoc=PBOA","METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("RVBOA","Rogue Valley Basketball Officials Association",NULL,"Basketball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SBOA","Salem Basketball Officials Association",NULL,"Basketball",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SB","Strawberry Basketball",NULL,"Basketball",NULL,"CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWOB","Southwest Oregon Basketball",NULL,"Basketball",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00")

#
# Wrestling Officials' Associations
#
INSERT INTO officials_associations (slug,name,other_name,sport,website,oregon_region,updated_at,created_at) VALUES
("AWOA","Albany Wrestling Officials Association",NULL,"Wrestling",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("BMW","Blue Mountain Wrestling",NULL,"Wrestling",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("COW","Central Oregon Wrestling",NULL,"Wrestling",NULL,"CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("DW","Douglas Wrestling",NULL,"Wrestling",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("KFW","Klamath Falls Wrestling",NULL,"Wrestling",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LCW","Lane County Wrestling",NULL,"Wrestling",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TDOA","Third District Officials Association","Malheur Wrestling","Wrestling",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MWWOA","Metro West Wrestling Officials Association",NULL,"Wrestling","http://www.reftown.com/Default.asp?Assoc=MWWOA","METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NCW","North Coast Wrestling",NULL,"Wrestling",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NEOW","Northeast Oregon Wrestling",NULL,"Wrestling",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("PWOA","Portland Wrestling Officials Association",NULL,"Wrestling",NULL,"METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("RVW","Rogue Valley Wrestling",NULL,"Wrestling",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWOA","Salem Wrestling Officials Association",NULL,"Wrestling","http://www.reftown.com/Default.asp?Assoc=SWOA","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWOW","Southwest Oregon Wrestling",NULL,"Wrestling",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00")

#
# Baseball Officials' Associations
#
INSERT INTO officials_associations (slug,name,other_name,sport,website,oregon_region,updated_at,created_at) VALUES
("BMB","Blue Mountain Baseball",NULL,"Baseball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("COB","Central Oregon Baseball",NULL,"Baseball",NULL,"CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("DCB","Douglas County Baseball",NULL,"Baseball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("KFUA","Klamath Falls Umpires Association",NULL,"Baseball","http://www.reftown.com/Default.asp?Assoc=KFUA","SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LCB","Lane County Baseball",NULL,"Baseball",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LB","Longview Baseball",NULL,"Baseball",NULL,"METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TDOA","Third District Officials Association","Malheur Baseball","Baseball","http://www.idahoofficials.com","EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MCB","Mid-Columbia Baseball",NULL,"Baseball",NULL,"GORGE","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MVB","Mid-Valley Baseball",NULL,"Baseball",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NEOB","Northeast Oregon Baseball",NULL,"Baseball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NEOBS","Northeast Oregon Baseball Satellite",NULL,"Baseball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NCB","North Coast Baseball",NULL,"Baseball",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("PBUA","Portland Baseball Umpires Association",NULL,"Baseball","http://www.reftown.com/Default.asp?Assoc=PBUA","METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("RVB","Rogue Valley Baseball",NULL,"Baseball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SBUA","Salem Baseball Umpires Association",NULL,"Baseball","http://www.salembaseballumpires.org","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWUA","Southwest Oregon Umpires Association",NULL,"Baseball",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00")

#
# Softball Officials' Associations
#
INSERT INTO officials_associations (slug,name,other_name,sport,website,oregon_region,updated_at,created_at) VALUES
("BMS","Blue Mountain Softball",NULL,"Softball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("COS","Central Oregon Softball",NULL,"Softball",NULL,"CENTRAL","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("DCS","Douglas County Softball",NULL,"Softball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("KFS","Klamath Falls Softball",NULL,"Softball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LCSUA","Lane County Softball Umpires Association",NULL,"Softball","http://www.reftown.com/Default.asp?Assoc=LCSUA","VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("LS","Longview Softball",NULL,"Softball",NULL,"METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TDOA","Third District Officials Association","Malheur Softball","Softball","http://www.idahoofficials.com","EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MCS","Mid-Columbia Softball",NULL,"Softball",NULL,"GORGE","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("MVS","Mid-Valley Softball",NULL,"Softball",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NEOS","Northeast Oregon Softball",NULL,"Softball",NULL,"EASTERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("NCS","North Coast Softball",NULL,"Softball",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("PSUA","Portland Softball Umpires Association",NULL,"Softball","http://www.reftown.com/Default.asp?Assoc=PSUA","METRO","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("RVS","Rogue Valley Softball",NULL,"Softball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SFPUA","Salem Fast Pitch Umpires Association",NULL,"Softball",NULL,"VALLEY","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("SWUA","Southwest Oregon Umpires Association",NULL,"Softball",NULL,"COAST","2014-10-13 00:00:00","2014-10-13 00:00:00"),
("TRS","Three Rivers Softball",NULL,"Softball",NULL,"SOUTHERN","2014-10-13 00:00:00","2014-10-13 00:00:00")