Tippgemeinschaft:Datenbank: Unterschied zwischen den Versionen
| Zeile 76: | Zeile 76: | ||
`name` varchar(45) collate utf8_unicode_ci NOT NULL, | `name` varchar(45) collate utf8_unicode_ci NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT= | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=29 ; | ||
-- | -- | ||
| Zeile 83: | Zeile 83: | ||
INSERT INTO `ti_klasse` (`id`, `name`) VALUES | INSERT INTO `ti_klasse` (`id`, `name`) VALUES | ||
(1, ' | (1, '09A'), | ||
(2, ' | (2, '09B'), | ||
(3, ' | (3, '09C'), | ||
(4, 'Lehrer'), | (4, 'Lehrer'), | ||
(5, ' | (5, '08A'), | ||
(6, ' | (6, '08B'), | ||
(7, ' | (7, '08C'), | ||
(8, '05A'), | |||
(9, '05B'), | |||
(10, '05C'), | |||
(11, '05D'), | |||
(12, '06A'), | |||
(13, '06B'), | |||
(14, '06C'), | |||
(15, '06D'), | |||
(16, '07A'), | |||
(17, '07B'), | |||
(18, '07C'), | |||
(19, '07D'), | |||
(20, '09D'), | |||
(21, '09E'), | |||
(22, 'EF-10'), | |||
(23, 'Q1-11'), | |||
(24, 'Q1-12'), | |||
(25, '13'), | |||
(26, 'Ehemalige'), | |||
(27, 'Freunde'), | |||
(28, 'Eltern'); | |||
-- -------------------------------------------------------- | -- -------------------------------------------------------- | ||
Version vom 8. März 2012, 20:11 Uhr
Datenbank: Infos
- Keine "echten" Passwörter für User hier reinlegen!!!!
- Am besten den Quelltext für die Erzeugung der Datenbank nutzen.
SQL-Insert-Skript
-- phpMyAdmin SQL Dump -- version 2.11.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 06. März 2012 um 09:32 -- Server Version: 5.0.45 -- PHP-Version: 5.2.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- -- Datenbank: `tipp` --
-- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `ti_admin` --
DROP TABLE IF EXISTS `ti_admin`; CREATE TABLE `ti_admin` (
`id` int(10) NOT NULL auto_increment, `nick` varchar(20) collate utf8_unicode_ci NOT NULL, `passwort` varchar(255) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- -- Daten für Tabelle `ti_admin` --
INSERT INTO `ti_admin` (`id`, `nick`, `passwort`) VALUES (1, 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997');
-- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `ti_gruppe` --
DROP TABLE IF EXISTS `ti_gruppe`; CREATE TABLE `ti_gruppe` (
`id` int(10) unsigned NOT NULL auto_increment, `name` varchar(45) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
-- -- Daten für Tabelle `ti_gruppe` --
INSERT INTO `ti_gruppe` (`id`, `name`) VALUES (1, 'Gruppe A'), (2, 'Gruppe B'), (3, 'Gruppe C'), (4, 'Gruppe D'), (9, 'Finalrunde');
-- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `ti_klasse` --
DROP TABLE IF EXISTS `ti_klasse`; CREATE TABLE `ti_klasse` (
`id` int(10) NOT NULL auto_increment, `name` varchar(45) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=29 ;
-- -- Daten für Tabelle `ti_klasse` --
INSERT INTO `ti_klasse` (`id`, `name`) VALUES (1, '09A'), (2, '09B'), (3, '09C'), (4, 'Lehrer'), (5, '08A'), (6, '08B'), (7, '08C'), (8, '05A'), (9, '05B'), (10, '05C'), (11, '05D'), (12, '06A'), (13, '06B'), (14, '06C'), (15, '06D'), (16, '07A'), (17, '07B'), (18, '07C'), (19, '07D'), (20, '09D'), (21, '09E'), (22, 'EF-10'), (23, 'Q1-11'), (24, 'Q1-12'), (25, '13'), (26, 'Ehemalige'), (27, 'Freunde'), (28, 'Eltern'); -- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `ti_nutzer` --
DROP TABLE IF EXISTS `ti_nutzer`; CREATE TABLE `ti_nutzer` (
`id` int(10) unsigned NOT NULL auto_increment, `klasse_id` int(10) unsigned NOT NULL, `nick` varchar(20) collate utf8_unicode_ci NOT NULL, `passwort` varchar(255) collate utf8_unicode_ci NOT NULL, `name` varchar(45) collate utf8_unicode_ci NOT NULL, `vorname` varchar(45) collate utf8_unicode_ci NOT NULL, `punkte` int(10) unsigned default NULL, `mail` varchar(80) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`), KEY `nutzer_index_punkte` (`punkte`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;
-- -- Daten für Tabelle `ti_nutzer` --
INSERT INTO `ti_nutzer` (`id`, `klasse_id`, `nick`, `passwort`, `name`, `vorname`, `punkte`, `mail`) VALUES (6, 1, 'max', '0706025b2bbcec1ed8d64822f4eccd96314938d0', , , 9, NULL), (4, 2, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', , , 10, NULL), (7, 4, 'test2', '109f4b3c50d7b0df729d299bc6f8e9ef9066971f', , , 0, NULL), (8, 3, 'bla', 'ffa6706ff2127a749973072756f83c532e43ed02', , , 0, NULL), (10, 0, 'm', '6b0d31c0d563223024da45691584643ac78c96e8', , , 4, NULL), (18, 9, 'y', '186154712b2d5f6791d85b9a0987b98fa231779c', , , NULL, 'yyy@yyy.de'), (17, 0, 'z', '395df8f7c51f007019cb30201c49e884b46b92fa', , , NULL, 'zzz@zzz.de');
-- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `ti_spiel` --
DROP TABLE IF EXISTS `ti_spiel`; CREATE TABLE `ti_spiel` (
`id` int(10) unsigned NOT NULL auto_increment, `verein1_id` int(10) unsigned NOT NULL, `verein2_id` int(10) unsigned NOT NULL, `gruppe_id` int(10) unsigned NOT NULL, `datum` date NOT NULL, `zeit` time NOT NULL default '12:00:00', `tore1` int(10) unsigned default NULL, `tore2` int(10) unsigned default NULL, `faktor` int(10) NOT NULL default '1', PRIMARY KEY (`id`), KEY `spiel_FKIndex1` (`gruppe_id`), KEY `spiel_verein1_id` (`verein1_id`), KEY `spiel_verein2_id` (`verein2_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=44 ;
-- -- Daten für Tabelle `ti_spiel` --
INSERT INTO `ti_spiel` (`id`, `verein1_id`, `verein2_id`, `gruppe_id`, `datum`, `zeit`, `tore1`, `tore2`, `faktor`) VALUES (33, 20, 21, 3, '2012-06-10', '20:45:00', NULL, NULL, 1), (32, 15, 4, 3, '2012-06-10', '18:00:00', NULL, NULL, 1), (31, 16, 1, 2, '2012-06-17', '20:45:00', NULL, NULL, 1), (30, 22, 14, 2, '2012-06-17', '20:45:00', NULL, NULL, 1), (29, 14, 1, 2, '2012-06-13', '20:45:00', NULL, NULL, 1), (28, 16, 22, 2, '2012-06-13', '18:00:00', NULL, NULL, 1), (27, 1, 22, 2, '2012-06-09', '20:45:00', NULL, NULL, 1), (26, 14, 16, 2, '2012-06-09', '18:00:00', NULL, NULL, 1), (25, 23, 12, 1, '2012-06-16', '20:45:00', NULL, NULL, 1), (24, 17, 18, 1, '2012-06-16', '20:45:00', NULL, NULL, 1), (23, 12, 18, 1, '2012-06-12', '20:45:00', NULL, NULL, 1), (22, 17, 23, 1, '2012-06-12', '18:00:00', NULL, NULL, 1), (21, 18, 23, 1, '2012-06-08', '20:45:00', NULL, NULL, 1), (20, 12, 17, 1, '2012-06-08', '18:00:00', NULL, NULL, 1), (34, 4, 21, 3, '2012-06-14', '18:00:00', NULL, NULL, 1), (35, 15, 20, 3, '2012-06-14', '20:45:00', NULL, NULL, 1), (36, 21, 15, 3, '2012-06-18', '20:45:00', NULL, NULL, 1), (37, 4, 20, 3, '2012-06-18', '20:45:00', NULL, NULL, 1), (38, 2, 8, 4, '2012-06-11', '18:00:00', NULL, NULL, 1), (39, 13, 19, 4, '2012-06-11', '20:45:00', NULL, NULL, 1), (40, 13, 2, 4, '2012-06-15', '18:00:00', NULL, NULL, 1), (41, 19, 8, 4, '2012-06-15', '20:45:00', NULL, NULL, 1), (42, 19, 2, 4, '2012-06-19', '20:45:00', NULL, NULL, 1), (43, 8, 13, 4, '2012-06-19', '20:45:00', NULL, NULL, 1);
-- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `ti_tipp` --
DROP TABLE IF EXISTS `ti_tipp`; CREATE TABLE `ti_tipp` (
`nutzer_id` int(10) unsigned NOT NULL, `spiel_id` int(10) unsigned NOT NULL, `tore1` int(10) default NULL, `tore2` int(10) default NULL, PRIMARY KEY (`nutzer_id`,`spiel_id`), KEY `tipp_FKIndex1` (`spiel_id`), KEY `tipp_FKIndex2` (`nutzer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -- Daten für Tabelle `ti_tipp` --
INSERT INTO `ti_tipp` (`nutzer_id`, `spiel_id`, `tore1`, `tore2`) VALUES (4, 43, NULL, NULL), (4, 42, NULL, NULL), (4, 41, NULL, NULL), (4, 40, NULL, NULL), (4, 39, 3, 4), (4, 38, 1, 2), (4, 37, NULL, NULL), (4, 36, NULL, NULL), (4, 35, 5, 6), (4, 34, 7, 8), (4, 33, 7, 8), (4, 32, 5, 6), (4, 31, NULL, NULL), (4, 30, NULL, NULL), (4, 29, 3, 4), (4, 28, 1, 2), (4, 27, 3, 4), (4, 26, 1, 2), (4, 25, NULL, NULL), (4, 24, NULL, NULL), (4, 23, 7, 8), (4, 22, 5, 6), (4, 21, NULL, NULL), (4, 20, NULL, NULL), (1, 7, NULL, NULL), (1, 8, NULL, NULL), (1, 9, NULL, NULL), (1, 10, NULL, NULL), (1, 11, NULL, NULL), (1, 12, NULL, NULL), (1, 13, NULL, NULL), (1, 14, NULL, NULL), (1, 15, NULL, NULL), (1, 16, NULL, NULL), (1, 17, NULL, NULL), (7, 6, NULL, NULL), (7, 7, NULL, NULL), (7, 8, NULL, NULL), (7, 9, NULL, NULL), (7, 10, NULL, NULL), (7, 11, NULL, NULL), (7, 12, NULL, NULL), (7, 13, NULL, NULL), (7, 14, NULL, NULL), (7, 15, NULL, NULL), (7, 16, NULL, NULL), (7, 17, NULL, NULL);
-- --------------------------------------------------------
-- -- Tabellenstruktur für Tabelle `ti_verein` --
DROP TABLE IF EXISTS `ti_verein`; CREATE TABLE `ti_verein` (
`id` int(10) unsigned NOT NULL auto_increment, `name` varchar(45) collate utf8_unicode_ci NOT NULL, `flagge` varchar(45) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;
-- -- Daten für Tabelle `ti_verein` --
INSERT INTO `ti_verein` (`id`, `name`, `flagge`) VALUES (1, 'Deutschland', 'germany.gif'), (2, 'Frankreich', 'france.gif'), (16, 'Dänemark', 'denmark.gif'), (4, 'Italien', 'italy.gif'), (15, 'Spanien', 'spain.gif'), (8, 'England', 'england.gif'), (14, 'Niederlande', 'netherlands.gif'), (13, 'Ukraine', 'ukraine.gif'), (12, 'Polen', 'poland.gif'), (17, 'Griechenland', 'greece.gif'), (18, 'Russland', 'russia.gif'), (19, 'Schweden', 'sweden.gif'), (20, 'Irland', 'ireland.gif'), (21, 'Kroatien', 'croatia.gif'), (22, 'Portugal', 'portugal.gif'), (23, 'Tchechien', 'czechrepublic.gif');