Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 3 | Revision 42 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 3 Revision 18
Zeile 1... Zeile 1...
1 
-- phpMyAdmin SQL Dump
 1 
-- phpMyAdmin SQL Dump
2 
-- version 2.8.0.4
 2 
-- version 2.8.0.4
3 
-- http://www.phpmyadmin.net
 3 
-- http://www.phpmyadmin.net
4 
--
4 
--
5 
-- Host: localhost
 5 
-- Host: localhost
6 
-- Erstellungszeit: 15. Juni 2006 um 01:52
 6 
-- Erstellungszeit: 18. Juni 2006 um 02:00
7 
-- Server Version: 5.0.22
 7 
-- Server Version: 5.0.22
8 
-- PHP-Version: 5.1.4-pl1-gentoo
 8 
-- PHP-Version: 5.1.4-pl1-gentoo
Zeile 9... Zeile 9...
9 
 
 9 
 
Zeile 17... Zeile 17...
17 
--
17 
--
Zeile 18... Zeile 18...
18 
 
 18 
 
Zeile 19... Zeile 19...
19 
-- --------------------------------------------------------
 19 
-- --------------------------------------------------------
- 
 
 20 
 
- 
 
 21 
--
- 
 
 22 
-- Tabellenstruktur für Tabelle `auth_user`
- 
 
 23 
--
- 
 
 24 
 
- 
 
 25 
DROP TABLE IF EXISTS `auth_user`;
- 
 
 26 
CREATE TABLE IF NOT EXISTS `auth_user` (
- 
 
 27 
  `u_id` int(11) NOT NULL auto_increment,
- 
 
 28 
  `u_name` varchar(255) collate latin1_german1_ci NOT NULL default '',
- 
 
 29 
  `u_email` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
- 
 
 30 
  `u_password` varchar(50) collate latin1_german1_ci NOT NULL default '',
- 
 
 31 
  `u_type` int(11) unsigned NOT NULL default '0',
- 
 
 32 
  PRIMARY KEY  (`u_id`),
- 
 
 33 
  UNIQUE KEY `u_name` (`u_name`),
- 
 
 34 
  UNIQUE KEY `u_email` (`u_email`)
- 
 
 35 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=3 ;
- 
 
 36 
 
- 
 
 37 
-- --------------------------------------------------------
- 
 
 38 
 
- 
 
 39 
--
- 
 
 40 
-- Tabellenstruktur für Tabelle `challenge`
- 
 
 41 
--
- 
 
 42 
 
- 
 
 43 
DROP TABLE IF EXISTS `challenge`;
- 
 
 44 
CREATE TABLE IF NOT EXISTS `challenge` (
- 
 
 45 
  `id` int(10) unsigned NOT NULL auto_increment,
- 
 
 46 
  `challenge_id` varchar(255) collate latin1_general_ci NOT NULL,
- 
 
 47 
  `u_id` int(11) NOT NULL,
- 
 
 48 
  PRIMARY KEY  (`id`),
- 
 
 49 
  UNIQUE KEY `challenge_id` (`challenge_id`,`u_id`),
- 
 
 50 
  KEY `u_id` (`u_id`)
- 
 
 51 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
- 
 
 52 
 
- 
 
 53 
-- --------------------------------------------------------
- 
 
 54 
 
- 
 
 55 
--
- 
 
 56 
-- Tabellenstruktur für Tabelle `config`
- 
 
 57 
--
- 
 
 58 
 
- 
 
 59 
DROP TABLE IF EXISTS `config`;
- 
 
 60 
CREATE TABLE IF NOT EXISTS `config` (
- 
 
 61 
  `config_name` varchar(255) collate latin1_general_ci NOT NULL,
- 
 
 62 
  `config_value` varchar(255) collate latin1_general_ci NOT NULL,
- 
 
 63 
  PRIMARY KEY  (`config_name`)
- 
 
 64 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
- 
 
 65 
 
- 
 
 66 
-- --------------------------------------------------------
20 
 
 67 
 
21 
--
68 
--
Zeile 22... Zeile 69...
22 
-- Tabellenstruktur für Tabelle `games`
 69 
-- Tabellenstruktur für Tabelle `games`
23 
--
70 
--
Zeile 30... Zeile 77...
30 
  `g_m2` int(10) unsigned NOT NULL,
 77 
  `g_m2` int(10) unsigned NOT NULL,
31 
  `g_g1` int(10) unsigned NOT NULL,
 78 
  `g_g1` int(10) unsigned NOT NULL,
32 
  `g_g2` int(10) unsigned NOT NULL,
 79 
  `g_g2` int(10) unsigned NOT NULL,
33 
  `g_location` int(10) unsigned NOT NULL,
 80 
  `g_location` int(10) unsigned NOT NULL,
34 
  `g_date` int(11) NOT NULL default '0',
 81 
  `g_date` int(11) NOT NULL default '0',
- 
 
 82 
  `g_type` int(10) unsigned NOT NULL,
35 
  PRIMARY KEY  (`g_id`),
 83 
  PRIMARY KEY  (`g_id`),
36 
  KEY `g_location` (`g_location`),
 84 
  KEY `g_location` (`g_location`),
37 
  KEY `g_m1` (`g_m1`,`g_m2`),
 85 
  KEY `g_m1` (`g_m1`,`g_m2`),
38 
  KEY `g_m2` (`g_m2`)
 86 
  KEY `g_m2` (`g_m2`),
- 
 
 87 
  KEY `g_type` (`g_type`)
39 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=49 ;
 88 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=49 ;
Zeile 40... Zeile 89...
40 
 
 89 
 
Zeile 41... Zeile 90...
41 
-- --------------------------------------------------------
 90 
-- --------------------------------------------------------
Zeile 65... Zeile 114...
65 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
 114 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
Zeile 66... Zeile 115...
66 
 
 115 
 
Zeile 67... Zeile 116...
67 
-- --------------------------------------------------------
 116 
-- --------------------------------------------------------
- 
 
 117 
 
- 
 
 118 
--
- 
 
 119 
-- Tabellenstruktur für Tabelle `log`
- 
 
 120 
--
- 
 
 121 
 
- 
 
 122 
DROP TABLE IF EXISTS `log`;
- 
 
 123 
CREATE TABLE IF NOT EXISTS `log` (
- 
 
 124 
  `id` int(11) unsigned NOT NULL auto_increment,
- 
 
 125 
  `user_id` int(11) default '0',
- 
 
 126 
  `datum` int(11) unsigned NOT NULL default '0',
- 
 
 127 
  `message` varchar(255) collate latin1_german1_ci NOT NULL default '',
- 
 
 128 
  PRIMARY KEY  (`id`),
- 
 
 129 
  KEY `user_id` (`user_id`)
- 
 
 130 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=1 ;
- 
 
 131 
 
- 
 
 132 
-- --------------------------------------------------------
68 
 
 133 
 
69 
--
134 
--
Zeile 70... Zeile 135...
70 
-- Tabellenstruktur für Tabelle `teams`
 135 
-- Tabellenstruktur für Tabelle `teams`
71 
--
136 
--
72 
 
 137 
 
73 
DROP TABLE IF EXISTS `teams`;
 138 
DROP TABLE IF EXISTS `teams`;
74 
CREATE TABLE IF NOT EXISTS `teams` (
 139 
CREATE TABLE IF NOT EXISTS `teams` (
- 
 
 140 
  `t_id` int(10) unsigned NOT NULL auto_increment,
- 
 
 141 
  `t_name` varchar(255) collate latin1_general_ci default NULL,
- 
 
 142 
  `t_group` int(10) unsigned NOT NULL,
- 
 
 143 
  `t_pos` tinyint(1) unsigned NOT NULL,
75 
  `t_id` int(10) unsigned NOT NULL auto_increment,
 144 
  `t_diff` tinyint(3) NOT NULL,
76 
  `t_name` varchar(255) collate latin1_general_ci default NULL,
 145 
  `t_points` tinyint(2) unsigned NOT NULL,
77 
  `t_group` int(10) unsigned NOT NULL,
 146 
  `t_goals` varchar(10) collate latin1_general_ci NOT NULL,
78 
  PRIMARY KEY  (`t_id`),
 147 
  PRIMARY KEY  (`t_id`),
Zeile -... Zeile 148...
- 
 
 148 
  KEY `t_name` (`t_name`),
- 
 
 149 
  KEY `t_group` (`t_group`)
- 
 
 150 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=33 ;
- 
 
 151 
 
- 
 
 152 
-- --------------------------------------------------------
- 
 
 153 
 
- 
 
 154 
--
- 
 
 155 
-- Tabellenstruktur für Tabelle `types`
- 
 
 156 
--
- 
 
 157 
 
- 
 
 158 
DROP TABLE IF EXISTS `types`;
- 
 
 159 
CREATE TABLE IF NOT EXISTS `types` (
- 
 
 160 
  `t_id` int(10) unsigned NOT NULL auto_increment,
79 
  KEY `t_name` (`t_name`),
 161 
  `t_name` varchar(255) collate latin1_general_ci NOT NULL,
80 
  KEY `t_group` (`t_group`)
 162 
  PRIMARY KEY  (`t_id`)
81 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=33 ;
 163 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
Zeile 82... Zeile 164...
82 
 
 164 
 
- 
 
 165 
--
- 
 
 166 
-- Constraints der exportierten Tabellen
- 
 
 167 
--
- 
 
 168 
 
- 
 
 169 
--
- 
 
 170 
-- Constraints der Tabelle `challenge`
83 
--
171 
--
84 
-- Constraints der exportierten Tabellen
 172 
ALTER TABLE `challenge`
85 
--
173 
  ADD CONSTRAINT `challenge_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `auth_user` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE;
86 
 
 174 
 
87 
--
175 
--
88 
-- Constraints der Tabelle `games`
 176 
-- Constraints der Tabelle `games`
- 
 
 177 
--
- 
 
 178 
ALTER TABLE `games`
- 
 
 179 
  ADD CONSTRAINT `games_ibfk_16` FOREIGN KEY (`g_m1`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
- 
 
 180 
  ADD CONSTRAINT `games_ibfk_17` FOREIGN KEY (`g_m2`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
- 
 
 181 
  ADD CONSTRAINT `games_ibfk_18` FOREIGN KEY (`g_location`) REFERENCES `locations` (`l_id`) ON UPDATE CASCADE;
- 
 
 182 
 
Zeile 89... Zeile 183...
89 
--
183 
--
90 
ALTER TABLE `games`
 184 
-- Constraints der Tabelle `log`
91 
  ADD CONSTRAINT `games_ibfk_7` FOREIGN KEY (`g_m1`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
 185 
--
92 
  ADD CONSTRAINT `games_ibfk_8` FOREIGN KEY (`g_m2`) REFERENCES `teams` (`t_id`) ON UPDATE CASCADE,
 186 
ALTER TABLE `log`