 -- Table structure for table `icpc2013_teams`
 --
 
+DROP TABLE IF EXISTS `icpc2013_teams`;
 CREATE TABLE IF NOT EXISTS `icpc2013_teams` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `reservation_id` int(11) NOT NULL,


-- 
-- Create views for the current contest
CREATE VIEW teams AS SELECT * FROM icpc2013_teams;
CREATE VIEW entries AS SELECT * FROM icpc2013_entries;
CREATE VIEW facts AS SELECT * FROM icpc2013_facts;
CREATE VIEW regions AS SELECT * FROM icpc2013_regions;
CREATE VIEW scoreboard AS SELECT * FROM icpc2013_scoreboard;
CREATE VIEW top_coder AS SELECT * FROM icpc2013_top_coder;

-- Table structure for table `icpc2013_top_coder`
--

DROP TABLE IF EXISTS `icpc2013_top_coder`;
CREATE TABLE IF NOT EXISTS `icpc2013_top_coder` (
  `university_name` varchar(150) NOT NULL,
  `coach_tcname` varchar(50) NOT NULL,
