Subversion-Projekte lars-tiefland.em_wm

-- phpMyAdmin SQL Dump
-- version 2.8.0.4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 15. Juni 2006 um 01:52
-- 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 `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',
  PRIMARY KEY  (`g_id`),
  KEY `g_location` (`g_location`),
  KEY `g_m1` (`g_m1`,`g_m2`),
  KEY `g_m2` (`g_m2`)
) 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 `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,
  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 ;

-- 
-- Constraints der exportierten Tabellen
-- 

-- 
-- Constraints der Tabelle `games`
-- 
ALTER TABLE `games`
  ADD CONSTRAINT `games_ibfk_7` FOREIGN KEY (`g_m1`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `games_ibfk_8` FOREIGN KEY (`g_m2`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `games_ibfk_9` FOREIGN KEY (`g_location`) REFERENCES `locations` (`l_id`) 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;