Subversion-Projekte lars-tiefland.em_wm

-- phpMyAdmin SQL Dump

-- version 2.8.0.4

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Erstellungszeit: 18. Juni 2006 um 02:00

-- Server Version: 5.0.22

-- PHP-Version: 5.1.4-pl1-gentoo

SET FOREIGN_KEY_CHECKS=0;

SET AUTOCOMMIT=0;

START TRANSACTION;

--

-- Datenbank: `wm2006`

--

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

--

-- Tabellenstruktur für Tabelle `auth_user`

--

DROP TABLE IF EXISTS `auth_user`;

CREATE TABLE IF NOT EXISTS `auth_user` (

  `u_id` int(11) NOT NULL auto_increment,

  `u_name` varchar(255) collate latin1_german1_ci NOT NULL default '',

  `u_email` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,

  `u_password` varchar(50) collate latin1_german1_ci NOT NULL default '',

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

  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 ;

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

--

-- Tabellenstruktur für Tabelle `challenge`

--

DROP TABLE IF EXISTS `challenge`;

CREATE TABLE IF NOT EXISTS `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`)

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

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

--

-- Tabellenstruktur für Tabelle `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;

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

--

-- Tabellenstruktur für Tabelle `games`

--

DROP TABLE IF EXISTS `games`;

CREATE TABLE IF NOT EXISTS `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`)

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

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

--

-- Tabellenstruktur für Tabelle `groups`

--

DROP TABLE IF EXISTS `groups`;

CREATE TABLE IF NOT EXISTS `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 ;

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

--

-- Tabellenstruktur für Tabelle `locations`

--

DROP TABLE IF EXISTS `locations`;

CREATE TABLE IF NOT EXISTS `locations` (

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

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

  PRIMARY KEY  (`l_id`)

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

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

--

-- Tabellenstruktur für Tabelle `log`

--

DROP TABLE IF EXISTS `log`;

CREATE TABLE IF NOT EXISTS `log` (

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

  `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`),

  KEY `user_id` (`user_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=1 ;

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

--

-- Tabellenstruktur für Tabelle `teams`

--

DROP TABLE IF EXISTS `teams`;

CREATE TABLE IF NOT EXISTS `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,

  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 ;

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

--

-- Tabellenstruktur für Tabelle `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,

  PRIMARY KEY  (`t_id`)

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

--

-- Constraints der exportierten Tabellen

--

--

-- 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`

--

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,

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

--

-- Constraints der Tabelle `log`

--

ALTER TABLE `log`

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

--

-- Constraints der Tabelle `teams`

--

ALTER TABLE `teams`

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

SET FOREIGN_KEY_CHECKS=1;

COMMIT;