WebSVN – lars-tiefland.em_wm – Diff – /trunk/wm2006.sql

--- phpMyAdmin SQL Dump
--- version 2.8.0.4
+-- MySQL dump 10.10
--- http://www.phpmyadmin.net
 --
--- Host: localhost
+-- Host: localhost    Database: wm2006
--- Erstellungszeit: 24. Juni 2006 um 12:49
+-- ------------------------------------------------------
--- Server Version: 5.0.22
+-- 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 */;
--- PHP-Version: 5.1.4-pl3-gentoo
+/*!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;
-SET AUTOCOMMIT=0;
-START TRANSACTION;
+SET FOREIGN_KEY_CHECKS=0;
---
--- Datenbank: `wm2006`
---
--- --------------------------------------------------------
 --
--- Tabellenstruktur für Tabelle `auth_user`
+-- Table structure for table `auth_user`
 --
 DROP TABLE IF EXISTS `auth_user`;
-CREATE TABLE IF NOT 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_name` varchar(255) collate latin1_german1_ci NOT NULL default '',
+  `u_password` varchar(50) collate latin1_general_ci NOT NULL,
+  `u_key` varchar(32) collate latin1_general_ci default NULL,
-  `u_email` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
+  `u_active` tinyint(1) unsigned default NULL,
-  `u_password` varchar(50) collate latin1_german1_ci NOT NULL default '',
+  `u_type` tinyint(1) unsigned NOT NULL default '0',
-  `u_type` int(11) 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_german1_ci AUTO_INCREMENT=3 ;
---
+  UNIQUE KEY `u_name` (`u_name`),
--- Daten für Tabelle `auth_user`
+  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 */;
-INSERT INTO `auth_user` (`u_id`, `u_name`, `u_email`, `u_password`, `u_type`) VALUES (1, 'LTiefland', 'ltiefland@gmail.com', '77eeef4a06967c4bfcb83391a690aa13', 1),
+LOCK TABLES `auth_user` WRITE;
-(2, 'test', 'ltiefland@lycos.de', '68eacb97d86f0c4621fa2b0e17cabd8c', 0);
+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 */;
 --
--- Tabellenstruktur für Tabelle `challenge`
+-- Table structure for table `challenge`
 --
 DROP TABLE IF EXISTS `challenge`;
+CREATE TABLE `challenge` (
-CREATE TABLE IF NOT EXISTS `challenge` (
+  `id` int(10) unsigned NOT NULL auto_increment,
-  `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`),
+  `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`),
+  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;
-  KEY `u_id` (`u_id`)
+--
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
+-- Dumping data for table `challenge`
+--
 --
--- Daten für Tabelle `challenge`
---
+/*!40000 ALTER TABLE `challenge` DISABLE KEYS */;
 LOCK TABLES `challenge` WRITE;
 UNLOCK TABLES;
--- --------------------------------------------------------
+/*!40000 ALTER TABLE `challenge` ENABLE KEYS */;
 --
--- Tabellenstruktur für Tabelle `config`
+-- Table structure for table `config`
+--
---
+DROP TABLE IF EXISTS `config`;
-DROP TABLE IF EXISTS `config`;
-CREATE TABLE IF NOT EXISTS `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;
+CREATE TABLE `config` (
---
+  `config_name` varchar(255) collate latin1_general_ci NOT NULL,
--- Daten für Tabelle `config`
+  `config_value` varchar(255) collate latin1_general_ci NOT NULL,
---
+  PRIMARY KEY  (`config_name`)
-INSERT INTO `config` (`config_name`, `config_value`) VALUES ('cookie_name', 'cookie_wm'),
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-('groups', '8'),
-('host', 'Germany'),
+--
-('logo', 'WC06_Logo.png'),
+-- Dumping data for table `config`
-('max_anz', '16'),
+--
-('session_length', '1200'),
 ('teams_per_group', '4'),
-('type', 'WM'),
+/*!40000 ALTER TABLE `config` DISABLE KEYS */;
-('version', '0.1.0'),
+LOCK TABLES `config` WRITE;
-('year', '2006');
+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;
   `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`)
+  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 AUTO_INCREMENT=57 ;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+--
+-- Dumping data for table `games`
+--
---
--- Daten für Tabelle `games`
---
-INSERT INTO `games` (`g_id`, `g_name`, `g_m1`, `g_m2`, `g_g1`, `g_g2`, `g_location`, `g_date`, `g_type`) VALUES (1, 'Spiel 1', 1, 2, 4, 2, 10, 1149868800, 1),
-(2, 'Spiel 2', 3, 4, 0, 2, 2, 1149879600, 1),
+/*!40000 ALTER TABLE `games` DISABLE KEYS */;
-(3, 'Spiel 3', 5, 6, 1, 0, 4, 1149944400, 1),
+LOCK TABLES `games` WRITE;
-(4, 'Spiel 4', 7, 8, 0, 0, 1, 1149955200, 1),
+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);
-(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),
+UNLOCK TABLES;
-(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, 0, 0, 10, 1151161200, 2),
-(50, 'Achtelfinalspiel 2', 9, 13, 0, 0, 9, 1151175600, 2),
-(51, 'Achtelfinalspiel 3', 5, 4, 0, 0, 12, 1151247600, 2),
-(52, 'Achtelfinalspiel 4', 16, 12, 0, 0, 11, 1151262000, 2),
-(53, 'Achtelfinaspiel 5', 17, 23, 0, 0, 7, 1151334000, 2),
-(54, 'Achtelfinalspiel 6', 26, 30, 0, 0, 8, 1151348400, 2),
-(55, 'Achtelfinalspiel 7', 21, 18, 0, 0, 1, 1151420400, 2),
-(56, 'Achtelfinalspiel 8', 29, 25, 0, 0, 6, 1151434800, 2);
--- --------------------------------------------------------
+/*!40000 ALTER TABLE `games` ENABLE KEYS */;
 --
--- Tabellenstruktur für Tabelle `groups`
+-- Table structure for table `groups`
 --
 DROP TABLE IF EXISTS `groups`;
-CREATE TABLE IF NOT 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 AUTO_INCREMENT=9 ;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+--
---
+-- Dumping data for table `groups`
+--
--- Daten für Tabelle `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`
+--
-INSERT INTO `groups` (`g_id`, `g_name`) VALUES (1, 'A'),
+/*!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`
-(2, 'B'),
+--
+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;
-(3, 'C'),
+--
+-- Dumping data for table `i18n_en`
+--
-(4, 'D'),
-(5, 'E'),
+/*!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 */;
-(6, 'F'),
+--
+-- Table structure for table `langs`
+--
+DROP TABLE IF EXISTS `langs`;
-(7, 'G'),
+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,
-(8, 'H');
+  `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 */;
 --
--- Tabellenstruktur für Tabelle `locations`
+-- Table structure for table `locations`
 --
 DROP TABLE IF EXISTS `locations`;
-CREATE TABLE IF NOT 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;
-  `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 AUTO_INCREMENT=13 ;
---
--- Daten für Tabelle `locations`
+-- Dumping data for table `locations`
---
-INSERT INTO `locations` (`l_id`, `l_name`, `l_name2`) 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'),
+/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
-(11, 'Nürnberg', 'Frankenstadion'),
+LOCK TABLES `locations` WRITE;
-(12, 'Stuttgart', 'Gottlieb-Daimler-Stadion');
+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 */;
 --
--- Tabellenstruktur für Tabelle `log`
+-- Table structure for table `log`
+--
---
+DROP TABLE IF EXISTS `log`;
+CREATE TABLE `log` (
-DROP TABLE IF EXISTS `log`;
+  `id` int(11) unsigned NOT NULL auto_increment,
-CREATE TABLE IF NOT EXISTS `log` (
+  `u_id` int(11) default '0',
+  `priority` int(11) NOT NULL,
-  `id` int(11) unsigned NOT NULL auto_increment,
+  `ident` varchar(16) collate latin1_general_ci NOT NULL,
-  `user_id` int(11) default '0',
-  `datum` int(11) unsigned NOT NULL default '0',
-  `message` varchar(255) collate latin1_german1_ci NOT NULL default '',
-  PRIMARY KEY  (`id`),
+  `logtime` int(11) unsigned NOT NULL default '0',
+  `message` varchar(255) collate latin1_general_ci NOT NULL,
+  PRIMARY KEY  (`id`),
-  KEY `user_id` (`user_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`
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=1 ;
+--
---
--- Daten für Tabelle `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 */;
 --
--- Tabellenstruktur für Tabelle `teams`
+-- Table structure for table `teams`
 --
+DROP TABLE IF EXISTS `teams`;
-DROP TABLE IF EXISTS `teams`;
+CREATE TABLE `teams` (
-CREATE TABLE IF NOT EXISTS `teams` (
+  `t_id` int(10) unsigned NOT NULL auto_increment,
-  `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_name` varchar(255) collate latin1_general_ci default 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,
-  `t_group` int(10) unsigned NOT NULL,
-  `t_pos` tinyint(1) unsigned NOT NULL,
+  PRIMARY KEY  (`t_id`),
-  `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,
-  PRIMARY KEY  (`t_id`),
-  KEY `t_name` (`t_name`),
-  KEY `t_group` (`t_group`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=33 ;
---
--- Daten für Tabelle `teams`
---
-INSERT INTO `teams` (`t_id`, `t_name`, `t_group`, `t_pos`, `t_diff`, `t_points`, `t_goals`, `t_flag`) VALUES (1, 'Deutschland', 1, 0, 6, 9, '8 : 2', 'Germany.png'),
-(2, 'Costa Rica', 1, 0, -6, 0, '3 : 9', 'Costa_Rica.png'),
-(3, 'Polen', 1, 0, -2, 3, '2 : 4', 'Poland.png'),
+  KEY `t_name` (`t_name`),
-(4, 'Equador', 1, 0, 2, 6, '5 : 3', 'Ecuador.png'),
-(5, 'England', 2, 0, 3, 7, '5 : 2', 'England.png'),
+  KEY `t_group` (`t_group`),
-(6, 'Paraguay', 2, 0, 0, 3, '2 : 2', 'Paraguay.png'),
-(7, 'Trinidad/Tobago', 2, 0, -4, 1, '0 : 4', 'Trinidad_Tobago.png'),
-(8, 'Schweden', 2, 0, 1, 5, '3 : 2', 'Sweden.png'),
+  CONSTRAINT `teams_ibfk_1` FOREIGN KEY (`t_group`) REFERENCES `groups` (`g_id`) ON UPDATE CASCADE
-(9, 'Argentinien', 3, 0, 7, 7, '8 : 1', 'Argentina.png'),
-(10, 'Elfenbeinküste', 3, 0, -1, 3, '5 : 6', 'Cote_dIvoire.png'),
-(11, 'Serbien/Montenegro', 3, 0, -8, 0, '2 : 10', 'Serbia_Montenegro.png'),
-(12, 'Niederlande', 3, 0, 2, 7, '3 : 1', 'Netherlands.png'),
-(13, 'Mexiko', 4, 0, 1, 4, '4 : 3', 'Mexico.png'),
-(14, 'Iran', 4, 0, -4, 1, '2 : 6', 'Iran.png'),
-(15, 'Angola', 4, 0, -1, 2, '1 : 2', 'Angola.png'),
-(16, 'Portugal', 4, 0, 4, 9, '5 : 1', 'Portugal.png'),
-(17, 'Italien', 5, 0, 4, 7, '5 : 1', 'Italy.png'),
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-(18, 'Ghana', 5, 0, 1, 6, '4 : 3', 'Ghana.png'),
-(19, 'USA', 5, 0, -4, 1, '2 : 6', 'USA.png'),
-(20, 'Tschechien', 5, 0, -1, 3, '3 : 4', 'Czech_Republic.png'),
-(21, 'Brasilien', 6, 0, 6, 9, '7 : 1', 'Brazil.png'),
-(22, 'Kroatien', 6, 0, -1, 2, '2 : 3', 'Croatia.png'),
-(23, 'Australien', 6, 0, 0, 4, '5 : 5', 'Australia.png'),
-(24, 'Japan', 6, 0, -5, 1, '2 : 7', 'Japan.png'),
-(25, 'Frankreich', 7, 0, 2, 5, '3 : 1', 'France.png'),
+--
-(26, 'Schweiz', 7, 0, 4, 7, '4 : 0', 'Switzerland.png'),
+-- Dumping data for table `teams`
-(27, 'Südkorea', 7, 0, -1, 4, '3 : 4', 'Korea_Republic.png'),
+--
 (28, 'Togo', 7, 0, -5, 0, '1 : 6', 'Togo.png'),
-(29, 'Spanien', 8, 0, 7, 9, '8 : 1', 'Spain.png'),
-(30, 'Ukraine', 8, 0, 1, 6, '5 : 4', 'Ukraine.png'),
+/*!40000 ALTER TABLE `teams` DISABLE KEYS */;
-(31, 'Tunesien', 8, 0, -3, 1, '3 : 6', 'Tunisia.png'),
+LOCK TABLES `teams` WRITE;
-(32, 'Saudi-Arabien', 8, 0, -5, 1, '2 : 7', 'Saudi_Arabia.png');
+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 */;
 --
--- Tabellenstruktur für Tabelle `types`
+-- Table structure for table `types`
 --
-DROP TABLE IF EXISTS `types`;
-CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=7 ;
+DROP TABLE IF EXISTS `types`;
---
--- Daten für Tabelle `types`
---
-INSERT INTO `types` (`t_id`, `t_name`, `t_max`) VALUES (1, 'Vorrunde', 48),
-(2, 'Achtelfinale', 8),
+CREATE TABLE `types` (
-(3, 'Viertelfinale', 4),
+  `t_id` int(10) unsigned NOT NULL auto_increment,
-(4, 'Halbfinale', 2),
-(5, 'Spiel um Platz 3', 1),
-(6, 'Finale', 1);
---
+  `t_name` varchar(255) collate latin1_general_ci NOT NULL,
--- Constraints der exportierten Tabellen
+  `t_max` int(11) NOT NULL,
---
+  PRIMARY KEY  (`t_id`)
---
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--- Constraints der Tabelle `challenge`
---
-ALTER TABLE `challenge`
-  ADD CONSTRAINT `challenge_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `auth_user` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE;
+--
---
--- Constraints der Tabelle `games`
---
+-- Dumping data for table `types`
-ALTER TABLE `games`
-  ADD CONSTRAINT `games_ibfk_16` FOREIGN KEY (`g_m1`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
+--
-  ADD CONSTRAINT `games_ibfk_17` FOREIGN KEY (`g_m2`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
+/*!40000 ALTER TABLE `types` DISABLE KEYS */;
-  ADD CONSTRAINT `games_ibfk_18` FOREIGN KEY (`g_location`) REFERENCES `locations` (`l_id`) ON UPDATE CASCADE;
+LOCK TABLES `types` WRITE;
---

Subversion-Projekte lars-tiefland.em_wm

(root)/trunk/wm2006.sql – Revision 46 → 74