Subversion-Projekte lars-tiefland.em_wm

-- MySQL dump 10.10

--

-- Host: localhost    Database: wm2006

-- ------------------------------------------------------

-- Server version	5.0.22-standard-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

SET FOREIGN_KEY_CHECKS=0;

--

-- Table structure for table `auth_user`

--

DROP TABLE IF EXISTS `auth_user`;

CREATE TABLE `auth_user` (

  `u_id` int(11) NOT NULL auto_increment,

  `u_name` varchar(255) collate latin1_general_ci NOT NULL,

  `u_email` varchar(255) collate latin1_general_ci NOT NULL,

  `u_password` varchar(50) collate latin1_general_ci NOT NULL,

  `u_key` varchar(32) collate latin1_general_ci default NULL,

  `u_active` tinyint(1) unsigned default NULL,

  `u_type` tinyint(1) unsigned NOT NULL default '0',

  `u_lang` char(2) collate latin1_general_ci NOT NULL,

  PRIMARY KEY  (`u_id`),

  UNIQUE KEY `u_name` (`u_name`),

  UNIQUE KEY `u_email` (`u_email`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `auth_user`

--

/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;

LOCK TABLES `auth_user` WRITE;

INSERT INTO `auth_user` VALUES (1,'LTiefland','ltiefland@gmail.com','77eeef4a06967c4bfcb83391a690aa13','',1,1,'de'),(2,'test','ltiefland@lycos.de','68eacb97d86f0c4621fa2b0e17cabd8c','',1,1,'en');

UNLOCK TABLES;

/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;

--

-- Table structure for table `challenge`

--

DROP TABLE IF EXISTS `challenge`;

CREATE TABLE `challenge` (

  `id` int(10) unsigned NOT NULL auto_increment,

  `challenge_id` varchar(255) collate latin1_general_ci NOT NULL,

  `u_id` int(11) NOT NULL,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `challenge_id` (`challenge_id`,`u_id`),

  KEY `u_id` (`u_id`),

  CONSTRAINT `challenge_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `auth_user` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `challenge`

--

/*!40000 ALTER TABLE `challenge` DISABLE KEYS */;

LOCK TABLES `challenge` WRITE;

UNLOCK TABLES;

/*!40000 ALTER TABLE `challenge` ENABLE KEYS */;

--

-- Table structure for table `config`

--

DROP TABLE IF EXISTS `config`;

CREATE TABLE `config` (

  `config_name` varchar(255) collate latin1_general_ci NOT NULL,

  `config_value` varchar(255) collate latin1_general_ci NOT NULL,

  PRIMARY KEY  (`config_name`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `config`

--

/*!40000 ALTER TABLE `config` DISABLE KEYS */;

LOCK TABLES `config` WRITE;

INSERT INTO `config` VALUES ('cookie_name','cookie_wm'),('groups','8'),('host','Germany'),('logo','WC06_Logo.png'),('max_anz','16'),('session_length','7200'),('teams_per_group','4'),('type','WC'),('version','0.6.0'),('year','2006');

UNLOCK TABLES;

/*!40000 ALTER TABLE `config` ENABLE KEYS */;

--

-- Table structure for table `games`

--

DROP TABLE IF EXISTS `games`;

CREATE TABLE `games` (

  `g_id` int(10) unsigned NOT NULL auto_increment,

  `g_name` varchar(255) collate latin1_general_ci default NULL,

  `g_m1` int(10) unsigned NOT NULL,

  `g_m2` int(10) unsigned NOT NULL,

  `g_g1` int(10) unsigned NOT NULL,

  `g_g2` int(10) unsigned NOT NULL,

  `g_location` int(10) unsigned NOT NULL,

  `g_date` int(11) NOT NULL default '0',

  `g_type` int(10) unsigned NOT NULL,

  PRIMARY KEY  (`g_id`),

  KEY `g_location` (`g_location`),

  KEY `g_m1` (`g_m1`,`g_m2`),

  KEY `g_m2` (`g_m2`),

  KEY `g_type` (`g_type`),

  CONSTRAINT `games_ibfk_16` FOREIGN KEY (`g_m1`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,

  CONSTRAINT `games_ibfk_17` FOREIGN KEY (`g_m2`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,

  CONSTRAINT `games_ibfk_18` FOREIGN KEY (`g_location`) REFERENCES `locations` (`l_id`) ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `games`

--

/*!40000 ALTER TABLE `games` DISABLE KEYS */;

LOCK TABLES `games` WRITE;

INSERT INTO `games` VALUES (1,'Spiel 1',1,2,4,2,10,1149868800,1),(2,'Spiel 2',3,4,0,2,2,1149879600,1),(3,'Spiel 3',5,6,1,0,4,1149944400,1),(4,'Spiel 4',7,8,0,0,1,1149955200,1),(5,'Spiel 5',9,10,2,1,5,1149966000,1),(6,'Spiel 6',11,12,0,1,9,1150030800,1),(7,'Spiel 7',13,14,3,1,11,1150041600,1),(8,'Spiel 8',15,16,0,1,8,1150052400,1),(9,'Spiel 12',23,24,3,1,7,1150117200,1),(10,'Spie 10',19,20,0,3,2,1150128000,1),(11,'Spiel 9',17,18,2,0,6,1150138800,1),(12,'Spiel 14',27,28,2,1,4,1150203600,1),(13,'Spiel 13',25,26,0,0,12,1150214400,1),(14,'Spiel 11',21,22,1,0,3,1150225200,1),(15,'Spiel 15',29,30,4,0,9,1150290000,1),(16,'Spiel 16',31,32,2,2,10,1150300800,1),(17,'Spiel 17',1,3,1,0,1,1150311600,1),(18,'Spiel 18',4,2,3,0,5,1150376400,1),(19,'Spiel 19',5,7,2,0,11,1150387200,1),(20,'Spiel 20',8,6,1,0,3,1150398000,1),(21,'Spiel 21',9,11,6,0,2,1150462800,1),(22,'Spiel 22',12,10,2,1,12,1150473600,1),(23,'Spiel 23',13,15,0,0,6,1150484400,1),(24,'Spiel 24',16,14,2,0,4,1150549200,1),(25,'Spiel 26',20,18,0,2,8,1150560000,1),(26,'Spiel 25',17,19,1,1,7,1150570800,1),(27,'Spiel 28',24,22,0,0,11,1150635600,1),(28,'Spiel 27',21,23,2,0,10,1150646400,1),(29,'Spiel 29',25,27,1,1,9,1150657200,1),(30,'Spiel 30',28,26,0,2,1,1150722000,1),(31,'Spiel 32',32,30,0,4,5,1150732800,1),(32,'Spiel 31',29,31,3,1,12,1150743600,1),(33,'Spiel 33',4,1,0,3,3,1150812000,1),(34,'Spiel 34',2,3,1,2,6,1150812000,1),(35,'Spiel 35',8,5,2,2,8,1150830000,1),(36,'Spiel 36',6,7,2,0,7,1150830000,1),(37,'Spiel 39',16,13,2,1,2,1150898400,1),(38,'Spiel 40',14,15,1,1,9,1150898400,1),(39,'Spiel 37',12,9,0,0,4,1150916400,1),(40,'Spiel 38',10,11,3,2,10,1150916400,1),(41,'Spiel 41',20,17,0,2,5,1150984800,1),(42,'Spiel 42',18,19,2,1,11,1150984800,1),(43,'Spiel 43',24,21,1,4,1,1151002800,1),(44,'Spiel 44',22,23,2,2,12,1151002800,1),(45,'Spiel 47',32,29,0,1,7,1151071200,1),(46,'Spiel 48',30,31,1,0,3,1151071200,1),(47,'Spiel 45',28,25,0,2,8,1151089200,1),(48,'Spiel 46',26,27,2,0,6,1151089200,1),(49,'Achtelfinalspiel 1',1,8,2,0,10,1151161200,2),(50,'Achtelfinalspiel 2',9,13,2,1,9,1151175600,2),(51,'Achtelfinalspiel 3',5,4,1,0,12,1151247600,2),(52,'Achtelfinalspiel 4',16,12,1,0,11,1151262000,2),(53,'Achtelfinaspiel 5',17,23,1,0,7,1151334000,2),(54,'Achtelfinalspiel 6',26,30,0,3,8,1151348400,2),(55,'Achtelfinalspiel 7',21,18,3,0,1,1151420400,2),(56,'Achtelfinalspiel 8',29,25,1,3,6,1151434800,2),(57,'Viertelfinalspiel 1',1,9,5,3,3,1151679600,3),(58,'Viertelfinalspiel 2',17,30,3,0,5,1151694000,3),(59,'Viertelfinalspiel 3',5,16,1,3,2,1151766000,3),(60,'Viertelfinalspiel 4',21,25,0,1,4,1151780400,3),(61,'Halbfinalspiel 1',1,17,0,2,1,1152039600,4),(62,'Halbfinalspiel 2',16,25,0,1,10,1152126000,4),(63,'Spiel um Platz 3',1,16,3,1,12,1152385200,5),(64,'Finale',17,25,6,4,3,1152471600,6);

UNLOCK TABLES;

/*!40000 ALTER TABLE `games` ENABLE KEYS */;

--

-- Table structure for table `groups`

--

DROP TABLE IF EXISTS `groups`;

CREATE TABLE `groups` (

  `g_id` int(10) unsigned NOT NULL auto_increment,

  `g_name` char(1) collate latin1_general_ci default NULL,

  PRIMARY KEY  (`g_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `groups`

--

/*!40000 ALTER TABLE `groups` DISABLE KEYS */;

LOCK TABLES `groups` WRITE;

INSERT INTO `groups` VALUES (1,'A'),(2,'B'),(3,'C'),(4,'D'),(5,'E'),(6,'F'),(7,'G'),(8,'H');

UNLOCK TABLES;

/*!40000 ALTER TABLE `groups` ENABLE KEYS */;

--

-- Table structure for table `i18n_de`

--

DROP TABLE IF EXISTS `i18n_de`;

CREATE TABLE `i18n_de` (

  `id` varchar(255) collate latin1_general_ci NOT NULL default '',

  `page_id` varchar(255) collate latin1_general_ci NOT NULL default '',

  `string` text collate latin1_general_ci,

  PRIMARY KEY  (`id`,`page_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `i18n_de`

--

/*!40000 ALTER TABLE `i18n_de` DISABLE KEYS */;

LOCK TABLES `i18n_de` WRITE;

INSERT INTO `i18n_de` VALUES ('actions','common','Aktionen'),('activate','common','Aktivieren'),('alert','common','Alarm'),('an_error_occured','common','Ein Fehler ist aufgetreten!'),('at','common','um'),('can_login_now','common','Er kann sich jetzt einloggen!'),('changed_subject','common','Pa&szlig;wort ge&auml;ndert'),('change_subject','common','Pa&szlig;wort&auml;nderung beantragt'),('critical','common','kritisch'),('date','common','Datum'),('debug','common','Debug'),('delete','common','l&ouml;schen'),('EC1','common','Europameister'),('EC2','common','Vize-Europameister'),('edit','common','&auml;ndern'),('email','common','E-Mail Adresse'),('email_empty','common','Bitte eine E-Mail Adresse eingeben!'),('email_exists','common','Ein User mit der E-Mail Adresse \"<b>%s</b>\" existiert bereits!'),('email_invalid','common','Die E-Mail Adresse ist (syntaktisch) nicht korrekt!'),('emergency','common','Notfall'),('error','common','Fehler'),('flag','common','Flagge'),('fourth','common','Vierter'),('game','common','Spiel'),('games','common','Spiele'),('game_name','common','Spielname'),('go','common','los'),('goal_diff','common','Tordifferenz'),('goal_relation','common','Torverhl&auml;tnis'),('group','common','Gruppe'),('groups','common','Gruppen'),('g_type','common','Spieltyp'),('host','common','Deutschland'),('info','common','Information'),('key','common','Aktivierungsschl&uuml;ssel'),('language','common','Sprache'),('language_empty','common','Bitte eine Sprache ausw&auml;hlen!'),('list_of_games','common','Liste der Spiele'),('list_of_groups','common','Liste der Gruppen'),('list_of_teams','common','Liste der Mannschaften'),('list_of_types','common','Liste der Spieltypen'),('list_of_venues','common','Liste der Austragungsorte'),('logged_in_as','common','angemeldet als'),('login','common','Einloggen'),('logout','common','Ausloggen'),('lost_password','common','Passwort vergessen'),('max_games','common','Maximalanzahl von Spielen'),('message','common','Meldung'),('notice','common','Hinweis'),('not_logged_in','common','nicht angemeldet'),('of','common','von'),('o_clock','common','Uhr'),('page','common','Seite'),('password','common','Pa&szlig;wort'),('password_confirm','common','Pa&szlig;wort best&auml;tigen'),('password_confirm_empty','common','Bitte das Pa&szlig;wort ein zweites mal eingeben!'),('password_diff','common','Die Pa&szlig;w&ouml;rter stimmen nicht &uuml;berein!'),('password_empty','common','Bitte ein Pa&szlig;wort eingeben!'),('please_select','common','Bitte w&auml;hlen!'),('points','common','Punkte'),('prel_table','common','Vorrundentablle'),('priority','common','Priori&auml;t'),('profile','common','Profil'),('property','common','Eigenschaft'),('rank','common','Rang'),('register','common','Registrieren'),('reg_failed','common','Registrierung fehlgeschlagen!'),('reg_info','common','Du erhlst in Krze eine E-Mail mit weiteren Instruktionen / informationen!'),('reg_subject','common','erfolgreiche Registrierung'),('reg_success','common','User <b>\"%s\"</b> wurde erfolgreich registriert.'),('result','common','Ergebnis'),('separated_in','common','ausgeschieden in'),('stadium_name','common','Stadionname'),('table_pos','common','Tabllenplatz'),('tasks','common','Aufgaben'),('team','common','Mannschaft'),('teams','common','Mannschaften'),('third','common','Dritter'),('time','common','Uhrzeit'),('userinfo_incorrect','common','Username und / oder Paßwort stimmen nicht!'),('username','common','Benutzername'),('username_empty','common','Bitte einen Benutzernamen eigeben!'),('user_activated','common','Der User \"<b>%s</b>\" wurde erfolgreich aktiviert!'),('user_activation','common','Benutzeraktivierung'),('user_exists','common','Ein User mit dem Namen \"<b>%s</b>\" existiert bereits!'),('value','common','Wert'),('venue','common','Austragungsort'),('venues','common','Austragungsorte'),('view_log','common','Log ansehen'),('warning','common','Warnung'),('WC','common','WM'),('WC1','common','Weltmeister'),('WC2','common','Vize-Weltmeister');

UNLOCK TABLES;

/*!40000 ALTER TABLE `i18n_de` ENABLE KEYS */;

--

-- Table structure for table `i18n_en`

--

DROP TABLE IF EXISTS `i18n_en`;

CREATE TABLE `i18n_en` (

  `id` varchar(255) collate latin1_general_ci NOT NULL,

  `page_id` varchar(255) collate latin1_general_ci NOT NULL,

  `string` text collate latin1_general_ci,

  PRIMARY KEY  (`id`,`page_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `i18n_en`

--

/*!40000 ALTER TABLE `i18n_en` DISABLE KEYS */;

LOCK TABLES `i18n_en` WRITE;

INSERT INTO `i18n_en` VALUES ('actions','common','Actions'),('activate','common','Activate'),('alert','common','Alert'),('an_error_occured','common','An error occured!'),('at','common','at'),('can_login_now','common','He can now login!'),('changed_subject','common','Password changed'),('change_subject','common','Password change requested'),('critical','common','Critical'),('date','common','Date'),('debug','common','Debug'),('delete','common','delete'),('EC1','common','World Europe Champion'),('EC2','common','Vize-Europe Champion'),('edit','common','edit'),('email','common','email address'),('email_empty','common','Please enter an email address!'),('email_exists','common','A user with the email Address \"<b>%s</b>\" already exists!'),('email_invalid','common','The email address is (syntactically) incorrect!'),('emergency','common','Emergency'),('error','common','Fehler'),('flag','common','Flag'),('fourth','common','Fourth'),('game','common','Game'),('games','common','Games'),('game_name','common','Name of game'),('go','common','go'),('goal_diff','common','Goal difference'),('goal_relation','common','Goal relation'),('group','common','Group'),('groups','common','Groups'),('g_type','common','Game Type'),('host','common','Germany'),('info','common','Information'),('key','common','Activation key'),('language','common','Language'),('language_empty','common','Please select a language!'),('list_of_games','common','List of games'),('list_of_groups','common','Group List'),('list_of_teams','common','Team List'),('list_of_types','common','Type List'),('list_of_venues','common','List of venues'),('logged_in_as','common','logged in as'),('login','common','Login'),('logout','common','Logout'),('lost_password','common','lost password'),('max_games','common','maximum count of games'),('message','common','Message'),('notice','common','Notice'),('not_logged_in','common','not logged in'),('of','common','of'),('o_clock','common','o\' clock'),('page','common','Page'),('password','common','Password'),('password_confirm','common','Confirm password'),('password_confirm_empty','common','Please enter the password a second time!'),('password_diff','common','The passwords do not match!'),('password_empty','common','Please enter a password!'),('please_select','common','Please select!'),('points','common','Points'),('prel_table','common','Preliminary round table'),('priority','common','Priority'),('profile','common','Profile'),('property','common','Property'),('rank','common','Rank'),('register','common','Register'),('reg_failed','common','Registration failed!'),('reg_info','common','You will recieve an email with further instructions / information shortly!'),('reg_subject','common','successfull registration'),('reg_success','common','User <b>\"%s\"</b> was successfully registered.'),('result','common','Result'),('separated_in','common','separated in'),('stadium_name','common','Stadium name'),('table_pos','common','Table position'),('tasks','common','Tasks'),('team','common','Team'),('teams','common','Teams'),('third','common','Third'),('time','common','Time'),('userinfo_incorrect','common','Username and / or Password are incorrect!'),('username','common','Username'),('username_empty','common','Please enter a username!'),('user_activated','common','The User \"<b>%s</b>\" was activated successfully!'),('user_activation','common','User Activation'),('user_exists','common','A user with the name \"<b>%s</b>\" already exists!'),('value','common','Value'),('venue','common','Venue'),('venues','common','Venues'),('view_log','common','View Log'),('warning','common','Warning'),('WC','common','WC'),('WC1','common','World Champion'),('WC2','common','Vize-World Champion');

UNLOCK TABLES;

/*!40000 ALTER TABLE `i18n_en` ENABLE KEYS */;

--

-- Table structure for table `langs`

--

DROP TABLE IF EXISTS `langs`;

CREATE TABLE `langs` (

  `id` char(2) collate latin1_general_ci NOT NULL,

  `name` varchar(255) collate latin1_general_ci default NULL,

  `meta` varchar(255) collate latin1_general_ci default NULL,

  `error_text` varchar(255) collate latin1_general_ci default NULL,

  `encoding` varchar(255) collate latin1_general_ci default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `langs`

--

/*!40000 ALTER TABLE `langs` DISABLE KEYS */;

LOCK TABLES `langs` WRITE;

INSERT INTO `langs` VALUES ('de','Deutsch','','',NULL),('en','Englisch',NULL,NULL,NULL);

UNLOCK TABLES;

/*!40000 ALTER TABLE `langs` ENABLE KEYS */;

--

-- Table structure for table `locations`

--

DROP TABLE IF EXISTS `locations`;

CREATE TABLE `locations` (

  `l_id` int(10) unsigned NOT NULL auto_increment,

  `l_name` varchar(255) collate latin1_general_ci default NULL,

  `l_name2` varchar(255) collate latin1_general_ci NOT NULL,

  PRIMARY KEY  (`l_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `locations`

--

/*!40000 ALTER TABLE `locations` DISABLE KEYS */;

LOCK TABLES `locations` WRITE;

INSERT INTO `locations` VALUES (1,'Dortmund','FIFA WM-Stadion'),(2,'Gelsenkirchen','FIFA WM-Stadion'),(3,'Berlin','Olympiastadion'),(4,'Frankfurt','FIFA WM-Stadion'),(5,'Hamburg','FIFA WM-Stadion'),(6,'Hannover','FIFA WM-Stadion'),(7,'Kaiserslautern','Fritz-Walter-Stadion'),(8,'Köln','FIFA WM-Stadion'),(9,'Leipzig','Zentralstadion'),(10,'München','FIFA WM-Stadion'),(11,'Nürnberg','Frankenstadion'),(12,'Stuttgart','Gottlieb-Daimler-Stadion');

UNLOCK TABLES;

/*!40000 ALTER TABLE `locations` ENABLE KEYS */;

--

-- Table structure for table `log`

--

DROP TABLE IF EXISTS `log`;

CREATE TABLE `log` (

  `id` int(11) unsigned NOT NULL auto_increment,

  `u_id` int(11) default '0',

  `priority` int(11) NOT NULL,

  `ident` varchar(16) collate latin1_general_ci NOT NULL,

  `logtime` int(11) unsigned NOT NULL default '0',

  `message` varchar(255) collate latin1_general_ci NOT NULL,

  PRIMARY KEY  (`id`),

  KEY `user_id` (`u_id`),

  CONSTRAINT `log_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `auth_user` (`u_id`) ON DELETE SET NULL ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `log`

--

/*!40000 ALTER TABLE `log` DISABLE KEYS */;

LOCK TABLES `log` WRITE;

INSERT INTO `log` VALUES (1,1,6,'fifa',1152397446,'Spiel Spiel um Platz 3 erfolgreich geändert!'),(2,1,6,'fifa',1152515198,'Spiel Finale erfolgreich geändert!'),(3,1,6,'fifa',1152531759,'Spieltyp Vorrunde erfolgreich geändert');

UNLOCK TABLES;

/*!40000 ALTER TABLE `log` ENABLE KEYS */;

--

-- Table structure for table `teams`

--

DROP TABLE IF EXISTS `teams`;

CREATE TABLE `teams` (

  `t_id` int(10) unsigned NOT NULL auto_increment,

  `t_name` varchar(255) collate latin1_general_ci default NULL,

  `t_group` int(10) unsigned NOT NULL,

  `t_pos` tinyint(1) unsigned NOT NULL,

  `t_diff` tinyint(3) NOT NULL,

  `t_points` tinyint(2) unsigned NOT NULL,

  `t_goals` varchar(10) collate latin1_general_ci NOT NULL,

  `t_flag` varchar(255) collate latin1_general_ci NOT NULL,

  `t_aus` set('-1','1','2','3','4','5','6') collate latin1_general_ci default NULL,

  PRIMARY KEY  (`t_id`),

  KEY `t_name` (`t_name`),

  KEY `t_group` (`t_group`),

  CONSTRAINT `teams_ibfk_1` FOREIGN KEY (`t_group`) REFERENCES `groups` (`g_id`) ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `teams`

--

/*!40000 ALTER TABLE `teams` DISABLE KEYS */;

LOCK TABLES `teams` WRITE;

INSERT INTO `teams` VALUES (1,'Deutschland',1,1,6,9,'8 : 2','Germany.png','5'),(2,'Costa Rica',1,4,-6,0,'3 : 9','Costa_Rica.png','1'),(3,'Polen',1,3,-2,3,'2 : 4','Poland.png','1'),(4,'Ecuador',1,2,2,6,'5 : 3','Ecuador.png','2'),(5,'England',2,1,3,7,'5 : 2','England.png','3'),(6,'Paraguay',2,3,0,3,'2 : 2','Paraguay.png','1'),(7,'Trinidad/Tobago',2,4,-4,1,'0 : 4','Trinidad_Tobago.png','1'),(8,'Schweden',2,2,1,5,'3 : 2','Sweden.png','2'),(9,'Argentinien',3,1,7,7,'8 : 1','Argentina.png','3'),(10,'Elfenbeinküste',3,3,-1,3,'5 : 6','Cote_dIvoire.png','1'),(11,'Serbien/Montenegro',3,4,-8,0,'2 : 10','Serbia_Montenegro.png','1'),(12,'Niederlande',3,2,2,7,'3 : 1','Netherlands.png','2'),(13,'Mexiko',4,2,1,4,'4 : 3','Mexico.png','2'),(14,'Iran',4,4,-4,1,'2 : 6','Iran.png','1'),(15,'Angola',4,3,-1,2,'1 : 2','Angola.png','1'),(16,'Portugal',4,1,4,9,'5 : 1','Portugal.png','5'),(17,'Italien',5,1,4,7,'5 : 1','Italy.png','6'),(18,'Ghana',5,2,1,6,'4 : 3','Ghana.png','2'),(19,'USA',5,4,-4,1,'2 : 6','USA.png','1'),(20,'Tschechien',5,3,-1,3,'3 : 4','Czech_Republic.png','1'),(21,'Brasilien',6,1,6,9,'7 : 1','Brazil.png','3'),(22,'Kroatien',6,3,-1,2,'2 : 3','Croatia.png','1'),(23,'Australien',6,2,0,4,'5 : 5','Australia.png','2'),(24,'Japan',6,4,-5,1,'2 : 7','Japan.png','1'),(25,'Frankreich',7,2,2,5,'3 : 1','France.png','6'),(26,'Schweiz',7,1,4,7,'4 : 0','Switzerland.png','2'),(27,'Südkorea',7,3,-1,4,'3 : 4','Korea_Republic.png','1'),(28,'Togo',7,4,-5,0,'1 : 6','Togo.png','1'),(29,'Spanien',8,1,7,9,'8 : 1','Spain.png','2'),(30,'Ukraine',8,2,1,6,'5 : 4','Ukraine.png','3'),(31,'Tunesien',8,3,-3,1,'3 : 6','Tunisia.png','1'),(32,'Saudi-Arabien',8,4,-5,1,'2 : 7','Saudi_Arabia.png','1');

UNLOCK TABLES;

/*!40000 ALTER TABLE `teams` ENABLE KEYS */;

--

-- Table structure for table `types`

--

DROP TABLE IF EXISTS `types`;

CREATE TABLE `types` (

  `t_id` int(10) unsigned NOT NULL auto_increment,

  `t_name` varchar(255) collate latin1_general_ci NOT NULL,

  `t_max` int(11) NOT NULL,

  PRIMARY KEY  (`t_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `types`

--

/*!40000 ALTER TABLE `types` DISABLE KEYS */;

LOCK TABLES `types` WRITE;

INSERT INTO `types` VALUES (1,'Vorrunde',48),(2,'Achtelfinale',8),(3,'Viertelfinale',4),(4,'Halbfinale',2),(5,'Spiel um Platz 3',1),(6,'Finale',1);

UNLOCK TABLES;

/*!40000 ALTER TABLE `types` ENABLE KEYS */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

SET FOREIGN_KEY_CHECKS=1;