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