Subversion-Projekte lars-tiefland.em_wm

Revision

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

Revision 18 Revision 42
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: 18. Juni 2006 um 02:00
6
-- Erstellungszeit: 24. Juni 2006 um 00:59
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-pl3-gentoo
Zeile 9... Zeile 9...
9
 
9
 
Zeile 10... Zeile 10...
10
SET FOREIGN_KEY_CHECKS=0;
10
SET FOREIGN_KEY_CHECKS=0;
11
 
11
 
Zeile 30... Zeile 30...
30
  `u_password` varchar(50) collate latin1_german1_ci NOT NULL default '',
30
  `u_password` varchar(50) collate latin1_german1_ci NOT NULL default '',
31
  `u_type` int(11) unsigned NOT NULL default '0',
31
  `u_type` int(11) unsigned NOT NULL default '0',
32
  PRIMARY KEY  (`u_id`),
32
  PRIMARY KEY  (`u_id`),
33
  UNIQUE KEY `u_name` (`u_name`),
33
  UNIQUE KEY `u_name` (`u_name`),
34
  UNIQUE KEY `u_email` (`u_email`)
34
  UNIQUE KEY `u_email` (`u_email`)
35
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=3 ;
35
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
Zeile 36... Zeile 36...
36
 
36
 
Zeile 37... Zeile 37...
37
-- --------------------------------------------------------
37
-- --------------------------------------------------------
38
 
38
 
Zeile 46... Zeile 46...
46
  `challenge_id` varchar(255) collate latin1_general_ci NOT NULL,
46
  `challenge_id` varchar(255) collate latin1_general_ci NOT NULL,
47
  `u_id` int(11) NOT NULL,
47
  `u_id` int(11) NOT NULL,
48
  PRIMARY KEY  (`id`),
48
  PRIMARY KEY  (`id`),
49
  UNIQUE KEY `challenge_id` (`challenge_id`,`u_id`),
49
  UNIQUE KEY `challenge_id` (`challenge_id`,`u_id`),
50
  KEY `u_id` (`u_id`)
50
  KEY `u_id` (`u_id`)
51
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
51
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Zeile 52... Zeile 52...
52
 
52
 
Zeile 53... Zeile 53...
53
-- --------------------------------------------------------
53
-- --------------------------------------------------------
54
 
54
 
Zeile 83... Zeile 83...
83
  PRIMARY KEY  (`g_id`),
83
  PRIMARY KEY  (`g_id`),
84
  KEY `g_location` (`g_location`),
84
  KEY `g_location` (`g_location`),
85
  KEY `g_m1` (`g_m1`,`g_m2`),
85
  KEY `g_m1` (`g_m1`,`g_m2`),
86
  KEY `g_m2` (`g_m2`),
86
  KEY `g_m2` (`g_m2`),
87
  KEY `g_type` (`g_type`)
87
  KEY `g_type` (`g_type`)
88
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=49 ;
88
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Zeile 89... Zeile 89...
89
 
89
 
Zeile 90... Zeile 90...
90
-- --------------------------------------------------------
90
-- --------------------------------------------------------
91
 
91
 
Zeile 96... Zeile 96...
96
DROP TABLE IF EXISTS `groups`;
96
DROP TABLE IF EXISTS `groups`;
97
CREATE TABLE IF NOT EXISTS `groups` (
97
CREATE TABLE IF NOT EXISTS `groups` (
98
  `g_id` int(10) unsigned NOT NULL auto_increment,
98
  `g_id` int(10) unsigned NOT NULL auto_increment,
99
  `g_name` char(1) collate latin1_general_ci default NULL,
99
  `g_name` char(1) collate latin1_general_ci default NULL,
100
  PRIMARY KEY  (`g_id`)
100
  PRIMARY KEY  (`g_id`)
101
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
101
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Zeile 102... Zeile 102...
102
 
102
 
Zeile 103... Zeile 103...
103
-- --------------------------------------------------------
103
-- --------------------------------------------------------
104
 
104
 
Zeile 108... Zeile 108...
108
 
108
 
109
DROP TABLE IF EXISTS `locations`;
109
DROP TABLE IF EXISTS `locations`;
110
CREATE TABLE IF NOT EXISTS `locations` (
110
CREATE TABLE IF NOT EXISTS `locations` (
111
  `l_id` int(10) unsigned NOT NULL auto_increment,
111
  `l_id` int(10) unsigned NOT NULL auto_increment,
-
 
112
  `l_name` varchar(255) collate latin1_general_ci default NULL,
112
  `l_name` varchar(255) collate latin1_general_ci default NULL,
113
  `l_name2` varchar(255) collate latin1_general_ci NOT NULL,
113
  PRIMARY KEY  (`l_id`)
114
  PRIMARY KEY  (`l_id`)
Zeile 114... Zeile 115...
114
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
115
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Zeile 115... Zeile 116...
115
 
116
 
116
-- --------------------------------------------------------
117
-- --------------------------------------------------------
Zeile 125... Zeile 126...
125
  `user_id` int(11) default '0',
126
  `user_id` int(11) default '0',
126
  `datum` int(11) unsigned NOT NULL default '0',
127
  `datum` int(11) unsigned NOT NULL default '0',
127
  `message` varchar(255) collate latin1_german1_ci NOT NULL default '',
128
  `message` varchar(255) collate latin1_german1_ci NOT NULL default '',
128
  PRIMARY KEY  (`id`),
129
  PRIMARY KEY  (`id`),
129
  KEY `user_id` (`user_id`)
130
  KEY `user_id` (`user_id`)
130
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=1 ;
131
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
Zeile 131... Zeile 132...
131
 
132
 
Zeile 132... Zeile 133...
132
-- --------------------------------------------------------
133
-- --------------------------------------------------------
133
 
134
 
Zeile 142... Zeile 143...
142
  `t_group` int(10) unsigned NOT NULL,
143
  `t_group` int(10) unsigned NOT NULL,
143
  `t_pos` tinyint(1) unsigned NOT NULL,
144
  `t_pos` tinyint(1) unsigned NOT NULL,
144
  `t_diff` tinyint(3) NOT NULL,
145
  `t_diff` tinyint(3) NOT NULL,
145
  `t_points` tinyint(2) unsigned NOT NULL,
146
  `t_points` tinyint(2) unsigned NOT NULL,
146
  `t_goals` varchar(10) collate latin1_general_ci NOT NULL,
147
  `t_goals` varchar(10) collate latin1_general_ci NOT NULL,
-
 
148
  `t_flag` varchar(255) collate latin1_general_ci NOT NULL,
147
  PRIMARY KEY  (`t_id`),
149
  PRIMARY KEY  (`t_id`),
148
  KEY `t_name` (`t_name`),
150
  KEY `t_name` (`t_name`),
149
  KEY `t_group` (`t_group`)
151
  KEY `t_group` (`t_group`)
150
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=33 ;
152
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Zeile 151... Zeile 153...
151
 
153
 
Zeile 152... Zeile 154...
152
-- --------------------------------------------------------
154
-- --------------------------------------------------------
153
 
155
 
Zeile 157... Zeile 159...
157
 
159
 
158
DROP TABLE IF EXISTS `types`;
160
DROP TABLE IF EXISTS `types`;
159
CREATE TABLE IF NOT EXISTS `types` (
161
CREATE TABLE IF NOT EXISTS `types` (
160
  `t_id` int(10) unsigned NOT NULL auto_increment,
162
  `t_id` int(10) unsigned NOT NULL auto_increment,
-
 
163
  `t_name` varchar(255) collate latin1_general_ci NOT NULL,
161
  `t_name` varchar(255) collate latin1_general_ci NOT NULL,
164
  `t_max` int(11) NOT NULL,
162
  PRIMARY KEY  (`t_id`)
165
  PRIMARY KEY  (`t_id`)
Zeile 163... Zeile 166...
163
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
166
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
164
 
167
 
165
-- 
168
--