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;