[offl-cvs] offl/sql/load load_nflteams.sql,1.1.1.1,1.2

[Job R. <jo...@us...>]

Update of /cvsroot/offl/offl/sql/load
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv21400

Modified Files:
	load_nflteams.sql 
Log Message:
added field nflteam_schedulename data for 2008 schedule processing


Index: load_nflteams.sql
===================================================================
RCS file: /cvsroot/offl/offl/sql/load/load_nflteams.sql,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** load_nflteams.sql	16 Aug 2004 00:31:36 -0000	1.1.1.1
--- load_nflteams.sql	4 Sep 2008 11:40:00 -0000	1.2
***************
*** 5,38 ****
  -- these abbreviations match those on NFL.com and should allow for automatic roster detection later.
  
! insert into nflteams values (1,'Baltimore','Ravens','BAL');
! insert into nflteams values (2,'Buffalo','Bills','BUF');
! insert into nflteams values (3,'Cincinnati','Bengals','CIN');
! insert into nflteams values (4,'Cleveland','Browns','CLE');
! insert into nflteams values (5,'Denver','Broncos','DEN');
! insert into nflteams values (6,'Houston','Texans','HOU');
! insert into nflteams values (7,'Indianapolis','Colts','IND');
! insert into nflteams values (8,'Jacksonville','Jaguars','JAC');
! insert into nflteams values (9,'Kansas City','Chiefs','KC');
! insert into nflteams values (10,'Miami','Dolphins','MIA');
! insert into nflteams values (11,'New England','Patriots','NE');
! insert into nflteams values (12,'New York','Jets','NYJ');
! insert into nflteams values (13,'Oakland','Raiders','OAK');
! insert into nflteams values (14,'Pittsburgh','Steelers','PIT');
! insert into nflteams values (15,'San Diego','Chargers','SD');
! insert into nflteams values (16,'Tennessee','Titans','TEN');
! insert into nflteams values (17,'Arizona','Cardinals','ARI');
! insert into nflteams values (18,'Atlanta','Falcons','ATL');
! insert into nflteams values (19,'Carolina','Panthers','CAR');
! insert into nflteams values (20,'Chicago','Bears','CHI');
! insert into nflteams values (21,'Dallas','Cowboys','DAL');
! insert into nflteams values (22,'Detroit','Lions','DET');
! insert into nflteams values (23,'Green Bay','Packers','GB');
! insert into nflteams values (24,'Minnesota','Vikings','MIN');
! insert into nflteams values (25,'New Orleans','Saints','NO');
! insert into nflteams values (26,'New York','Giants','NYG');
! insert into nflteams values (27,'Philadelphia','Eagles','PHI');
! insert into nflteams values (28,'San Francisco','49ers','SF');
! insert into nflteams values (29,'St. Louis','Rams','STL');
! insert into nflteams values (30,'Seattle','Seahawks','SEA');
! insert into nflteams values (31,'Tampa Bay','Buccaneers','TB');
! insert into nflteams values (32,'Washington','Redskins','WAS');
--- 5,38 ----
  -- these abbreviations match those on NFL.com and should allow for automatic roster detection later.
  
! insert into nflteams values (1,'Baltimore','Ravens','Baltimore','BAL');
! insert into nflteams values (2,'Buffalo','Bills','Buffalo','BUF');
! insert into nflteams values (3,'Cincinnati','Bengals','Cincinnati','CIN');
! insert into nflteams values (4,'Cleveland','Browns','Cleveland','CLE');
! insert into nflteams values (5,'Denver','Broncos','Denver','DEN');
! insert into nflteams values (6,'Houston','Texans','Houston','HOU');
! insert into nflteams values (7,'Indianapolis','Colts','Indianapolis','IND');
! insert into nflteams values (8,'Jacksonville','Jaguars','Jacksonville','JAC');
! insert into nflteams values (9,'Kansas City','Chiefs','Kansas City','KC');
! insert into nflteams values (10,'Miami','Dolphins','Miami','MIA');
! insert into nflteams values (11,'New England','Patriots','New England','NE');
! insert into nflteams values (12,'New York','Jets','N.Y. Jets','NYJ');
! insert into nflteams values (13,'Oakland','Raiders','Oakland','OAK');
! insert into nflteams values (14,'Pittsburgh','Steelers','Pittsburgh','PIT');
! insert into nflteams values (15,'San Diego','Chargers','San Diego','SD');
! insert into nflteams values (16,'Tennessee','Titans','Tennessee','TEN');
! insert into nflteams values (17,'Arizona','Cardinals','Arizona','ARI');
! insert into nflteams values (18,'Atlanta','Falcons''Atlanta','ATL');
! insert into nflteams values (19,'Carolina','Panthers','Carolina','CAR');
! insert into nflteams values (20,'Chicago','Bears','Chicago','CHI');
! insert into nflteams values (21,'Dallas','Cowboys','Dallas','DAL');
! insert into nflteams values (22,'Detroit','Lions','Detroit','DET');
! insert into nflteams values (23,'Green Bay','Packers','Green Bay','GB');
! insert into nflteams values (24,'Minnesota','Vikings','Minnesota','MIN');
! insert into nflteams values (25,'New Orleans','Saints','New Orleans','NO');
! insert into nflteams values (26,'New York','Giants','N.Y. Giants','NYG');
! insert into nflteams values (27,'Philadelphia','Eagles','Philadelphia','PHI');
! insert into nflteams values (28,'San Francisco','49ers','San Francisco','SF');
! insert into nflteams values (29,'St. Louis','Rams','St. Louis','STL');
! insert into nflteams values (30,'Seattle','Seahawks','Seattle','SEA');
! insert into nflteams values (31,'Tampa Bay','Buccaneers','Tampa Bay','TB');
! insert into nflteams values (32,'Washington','Redskins','Washington','WAS');