Tippgemeinschaft:Datenbank: Unterschied zwischen den Versionen

Aus SibiWiki
Zur Navigation springen Zur Suche springen
Zeile 11: Zeile 11:
--
--
-- Host: localhost
-- Host: localhost
-- Erstellungszeit: 16. März 2012 um 21:17
-- Erstellungszeit: 18. März 2012 um 14:46
-- Server Version: 5.0.45
-- Server Version: 5.0.45
-- PHP-Version: 5.2.4
-- PHP-Version: 5.2.4
Zeile 18: Zeile 18:


--
--
-- Datenbank: `tippgemeinschaft`
-- Datenbank: `tipp`
--
--


Zeile 27: Zeile 27:
--
--


DROP TABLE IF EXISTS `ti_admin`;
CREATE TABLE `ti_admin` (
CREATE TABLE `ti_admin` (
   `id` int(10) NOT NULL auto_increment,
   `id` int(10) NOT NULL auto_increment,
Zeile 48: Zeile 47:
--
--


DROP TABLE IF EXISTS `ti_gruppe`;
CREATE TABLE `ti_gruppe` (
CREATE TABLE `ti_gruppe` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `id` int(10) unsigned NOT NULL auto_increment,
Zeile 72: Zeile 70:
--
--


DROP TABLE IF EXISTS `ti_klasse`;
CREATE TABLE `ti_klasse` (
CREATE TABLE `ti_klasse` (
   `id` int(10) NOT NULL auto_increment,
   `id` int(10) NOT NULL auto_increment,
Zeile 115: Zeile 112:
(30, 'Freunde'),
(30, 'Freunde'),
(31, 'Eltern');
(31, 'Eltern');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ti_kommentar`
--
CREATE TABLE `ti_kommentar` (
  `id` int(10) NOT NULL auto_increment,
  `kommentar` varchar(280) NOT NULL,
  `datum` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `nutzer_id` int(10) NOT NULL,
  `spiel_id` int(10) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `spiel_id` (`spiel_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
--
-- Daten für Tabelle `ti_kommentar`
--
INSERT INTO `ti_kommentar` (`id`, `kommentar`, `datum`, `nutzer_id`, `spiel_id`) VALUES
(8, 'Ganz klar: Germany spielt zu 0, weil Neuer einfach alles hält!', '2012-03-17 13:15:25', 10, 27),
(10, 'Das Spiel war sehr spannend. Deutschland hat schon wieder gewonnen.', '2012-03-17 13:59:54', 4, 27),
(27, 'Fußball ist halt immer anders...', '2012-03-17 17:47:31', 4, 27);


-- --------------------------------------------------------
-- --------------------------------------------------------
Zeile 122: Zeile 144:
--
--


DROP TABLE IF EXISTS `ti_nutzer`;
CREATE TABLE `ti_nutzer` (
CREATE TABLE `ti_nutzer` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `id` int(10) unsigned NOT NULL auto_increment,
Zeile 130: Zeile 151:
   `name` varchar(45) collate utf8_unicode_ci NOT NULL,
   `name` varchar(45) collate utf8_unicode_ci NOT NULL,
   `vorname` varchar(45) collate utf8_unicode_ci NOT NULL,
   `vorname` varchar(45) collate utf8_unicode_ci NOT NULL,
  `rolle` varchar(10) collate utf8_unicode_ci default NULL,
   `punkte` int(10) unsigned default NULL,
   `punkte` int(10) unsigned default NULL,
   `mail` varchar(80) collate utf8_unicode_ci default NULL,
   `mail` varchar(80) collate utf8_unicode_ci default NULL,
Zeile 135: Zeile 157:
   KEY `nutzer_index_punkte` (`punkte`),
   KEY `nutzer_index_punkte` (`punkte`),
   KEY `klasse_id` (`klasse_id`)
   KEY `klasse_id` (`klasse_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;


--
--
Zeile 141: Zeile 163:
--
--


INSERT INTO `ti_nutzer` (`id`, `klasse_id`, `nick`, `passwort`, `name`, `vorname`, `punkte`, `mail`) VALUES
INSERT INTO `ti_nutzer` (`id`, `klasse_id`, `nick`, `passwort`, `name`, `vorname`, `rolle`, `punkte`, `mail`) VALUES
(6, 1, 'max', '0706025b2bbcec1ed8d64822f4eccd96314938d0', '', '', 0, NULL),
(4, 2, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', '', '', NULL, 0, NULL),
(4, 2, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', '', '', 0, NULL),
(25, 5, 'b2', '32f28ea03b1b20126629d2ca63fc6665b0bbb604', '', '', NULL, NULL, 'b2b2@sibi.honnef.de'),
(7, 4, 'test2', '109f4b3c50d7b0df729d299bc6f8e9ef9066971f', '', '', 0, NULL),
(24, 5, 'a2', 'b9f85daa6f83cf02ce5c31913d1f64d3f5c8fade', '', '', NULL, NULL, 'a2a2@sibi.honnef.de'),
(8, 3, 'bla', 'ffa6706ff2127a749973072756f83c532e43ed02', '', '', 0, NULL),
(19, 5, 'a', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', '', '', NULL, 5, 'aaa@sibi.honnef.de'),
(10, 0, 'm', '6b0d31c0d563223024da45691584643ac78c96e8', '', '', 0, NULL),
(20, 5, 'b', 'e9d71f5ee7c92d6dc9e92ffdad17b8bd49418f98', '', '', NULL, 0, 'bbb@sibi.honnef.de'),
(18, 9, 'y', '186154712b2d5f6791d85b9a0987b98fa231779c', '', '', 0, 'yyy@yyy.de'),
(21, 5, 'c', '84a516841ba77a5b4648de2cd0dfcb30ea46dbb4', '', '', NULL, 8, 'ccc@sibi.honnef.de'),
(17, 0, 'z', '395df8f7c51f007019cb30201c49e884b46b92fa', '', '', 0, 'zzz@zzz.de');
(22, 5, 'd', '3c363836cf4e16666669a25da280a1865c2d2874', '', '', NULL, 14, 'ddd@sibi.honnef.de'),
(23, 0, 'autor', '51182033f975abba510f037480ec2571967ae2e9', '', '', 'autor', 0, 'autor@sibi.honnef.de');


-- --------------------------------------------------------
-- --------------------------------------------------------
Zeile 156: Zeile 179:
--
--


DROP TABLE IF EXISTS `ti_sibinet`;
CREATE TABLE `ti_sibinet` (
CREATE TABLE `ti_sibinet` (
   `id` int(10) NOT NULL auto_increment,
   `id` int(10) NOT NULL auto_increment,
Zeile 183: Zeile 205:
--
--


DROP TABLE IF EXISTS `ti_spiel`;
CREATE TABLE `ti_spiel` (
CREATE TABLE `ti_spiel` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `id` int(10) unsigned NOT NULL auto_increment,
Zeile 205: Zeile 226:


INSERT INTO `ti_spiel` (`id`, `verein1_id`, `verein2_id`, `gruppe_id`, `datum`, `zeit`, `tore1`, `tore2`, `faktor`) VALUES
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),
(33, 20, 21, 3, '2012-06-10', '20:45:00', 2, 0, 1),
(32, 15, 4, 3, '2012-06-10', '18:00:00', NULL, NULL, 1),
(32, 15, 4, 3, '2012-06-10', '18:00:00', 3, 1, 1),
(31, 16, 1, 2, '2012-06-17', '20:45: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),
(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),
(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),
(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),
(27, 1, 22, 2, '2012-06-09', '20:45:00', 2, 4, 1),
(26, 14, 16, 2, '2012-06-09', '18:00:00', NULL, NULL, 1),
(26, 14, 16, 2, '2012-06-09', '18:00:00', 0, 0, 1),
(25, 23, 12, 1, '2012-06-16', '20:45: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),
(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),
(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),
(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),
(21, 18, 23, 1, '2012-06-08', '20:45:00', 1, 2, 1),
(20, 12, 17, 1, '2012-06-08', '18:00:00', NULL, NULL, 1),
(20, 12, 17, 1, '2012-06-08', '18:00:00', 2, 3, 1),
(34, 4, 21, 3, '2012-06-14', '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),
(35, 15, 20, 3, '2012-06-14', '20:45:00', NULL, NULL, 1),
Zeile 236: Zeile 257:
--
--


DROP TABLE IF EXISTS `ti_tipp`;
CREATE TABLE `ti_tipp` (
CREATE TABLE `ti_tipp` (
   `nutzer_id` int(10) unsigned NOT NULL,
   `nutzer_id` int(10) unsigned NOT NULL,
Zeile 252: Zeile 272:


INSERT INTO `ti_tipp` (`nutzer_id`, `spiel_id`, `tore1`, `tore2`) VALUES
INSERT INTO `ti_tipp` (`nutzer_id`, `spiel_id`, `tore1`, `tore2`) VALUES
(4, 39, 3, 4),
(19, 31, NULL, NULL),
(4, 38, 1, 2),
(19, 30, NULL, NULL),
(4, 35, 5, 6),
(19, 29, NULL, NULL),
(4, 34, 7, 8),
(19, 28, NULL, NULL),
(4, 33, 7, 8),
(19, 27, 1, 1),
(4, 32, 5, 6),
(19, 26, 2, 0),
(4, 29, 3, 4),
(19, 25, NULL, NULL),
(4, 28, 1, 2),
(19, 24, NULL, NULL),
(4, 27, 3, 4),
(19, 23, NULL, NULL),
(4, 26, 1, 2),
(19, 22, NULL, NULL),
(4, 23, 7, 8),
(19, 21, 1, 2),
(4, 22, 5, 6);
(19, 20, 4, 4),
(19, 32, NULL, NULL),
(19, 33, NULL, NULL),
(19, 34, NULL, NULL),
(19, 35, NULL, NULL),
(19, 36, NULL, NULL),
(19, 37, NULL, NULL),
(19, 38, NULL, NULL),
(19, 39, NULL, NULL),
(19, 40, NULL, NULL),
(19, 41, NULL, NULL),
(19, 42, NULL, NULL),
(19, 43, NULL, NULL),
(20, 20, 2, 1),
(20, 21, 3, 3),
(20, 22, NULL, NULL),
(20, 23, NULL, NULL),
(20, 24, NULL, NULL),
(20, 25, NULL, NULL),
(20, 26, 0, 2),
(20, 27, 4, 2),
(20, 28, NULL, NULL),
(20, 29, NULL, NULL),
(20, 30, NULL, NULL),
(20, 31, NULL, NULL),
(20, 32, 0, 0),
(20, 33, 2, 2),
(20, 34, NULL, NULL),
(20, 35, NULL, NULL),
(20, 36, NULL, NULL),
(20, 37, NULL, NULL),
(20, 38, NULL, NULL),
(20, 39, NULL, NULL),
(20, 40, NULL, NULL),
(20, 41, NULL, NULL),
(20, 42, NULL, NULL),
(20, 43, NULL, NULL),
(21, 20, 1, 2),
(21, 21, 2, 2),
(21, 22, NULL, NULL),
(21, 23, NULL, NULL),
(21, 24, NULL, NULL),
(21, 25, NULL, NULL),
(21, 26, 4, 4),
(21, 27, 3, 3),
(21, 28, NULL, NULL),
(21, 29, NULL, NULL),
(21, 30, NULL, NULL),
(21, 31, NULL, NULL),
(21, 32, NULL, NULL),
(21, 33, 2, 4),
(21, 34, NULL, NULL),
(21, 35, NULL, NULL),
(21, 36, NULL, NULL),
(21, 37, NULL, NULL),
(21, 38, NULL, NULL),
(21, 39, NULL, NULL),
(21, 40, NULL, NULL),
(21, 41, NULL, NULL),
(21, 42, NULL, NULL),
(21, 43, NULL, NULL),
(22, 20, 3, 1),
(22, 21, 2, 3),
(22, 22, NULL, NULL),
(22, 23, NULL, NULL),
(22, 24, NULL, NULL),
(22, 25, NULL, NULL),
(22, 26, 3, 3),
(22, 27, 2, 2),
(22, 28, NULL, NULL),
(22, 29, NULL, NULL),
(22, 30, NULL, NULL),
(22, 31, NULL, NULL),
(22, 32, 5, 4),
(22, 33, 1, 0),
(22, 34, NULL, NULL),
(22, 35, NULL, NULL),
(22, 36, NULL, NULL),
(22, 37, NULL, NULL),
(22, 38, NULL, NULL),
(22, 39, NULL, NULL),
(22, 40, NULL, NULL),
(22, 41, NULL, NULL),
(22, 42, 2, 3),
(22, 43, NULL, NULL),
(4, 20, 5, 4),
(4, 21, 2, 2),
(4, 22, 0, 2),
(4, 23, NULL, NULL),
(4, 24, NULL, NULL),
(4, 25, NULL, NULL),
(4, 26, 3, 2),
(4, 27, 1, 1),
(4, 28, NULL, NULL),
(4, 29, NULL, NULL),
(4, 30, NULL, NULL),
(4, 31, NULL, NULL),
(4, 32, 0, 2),
(4, 33, 0, 3),
(4, 34, NULL, NULL),
(4, 35, NULL, NULL),
(4, 36, NULL, NULL),
(4, 37, NULL, NULL),
(4, 38, 4, 2),
(4, 39, 1, 3),
(4, 40, NULL, NULL),
(4, 41, NULL, NULL),
(4, 42, NULL, NULL),
(4, 43, NULL, NULL);


-- --------------------------------------------------------
-- --------------------------------------------------------
Zeile 271: Zeile 399:
--
--


DROP TABLE IF EXISTS `ti_verein`;
CREATE TABLE `ti_verein` (
CREATE TABLE `ti_verein` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `id` int(10) unsigned NOT NULL auto_increment,
   `name` varchar(45) collate utf8_unicode_ci NOT NULL,
   `name` varchar(45) collate utf8_unicode_ci NOT NULL,
   `flagge` varchar(45) collate utf8_unicode_ci default NULL,
   `flagge` varchar(45) collate utf8_unicode_ci default NULL,
  `beschreibung` varchar(500) collate utf8_unicode_ci default NULL,
   PRIMARY KEY  (`id`)
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;
Zeile 283: Zeile 411:
--
--


INSERT INTO `ti_verein` (`id`, `name`, `flagge`) VALUES
INSERT INTO `ti_verein` (`id`, `name`, `flagge`, `beschreibung`) VALUES
(1, 'Deutschland', 'germany.gif'),
(1, 'Deutschland', 'germany.gif', ''),
(2, 'Frankreich', 'france.gif'),
(2, 'Frankreich', 'france.gif', ''),
(16, 'Dänemark', 'denmark.gif'),
(16, 'Dänemark', 'denmark.gif', ''),
(4, 'Italien', 'italy.gif'),
(4, 'Italien', 'italy.gif', ''),
(15, 'Spanien', 'spain.gif'),
(15, 'Spanien', 'spain.gif', ''),
(8, 'England', 'england.gif'),
(8, 'England', 'england.gif', ''),
(14, 'Niederlande', 'netherlands.gif'),
(14, 'Niederlande', 'netherlands.gif', ''),
(13, 'Ukraine', 'ukraine.gif'),
(13, 'Ukraine', 'ukraine.gif', ''),
(12, 'Polen', 'poland.gif'),
(12, 'Polen', 'poland.gif', ''),
(17, 'Griechenland', 'greece.gif'),
(17, 'Griechenland', 'greece.gif', ''),
(18, 'Russland', 'russia.gif'),
(18, 'Russland', 'russia.gif', ''),
(19, 'Schweden', 'sweden.gif'),
(19, 'Schweden', 'sweden.gif', ''),
(20, 'Irland', 'ireland.gif'),
(20, 'Irland', 'ireland.gif', ''),
(21, 'Kroatien', 'croatia.gif'),
(21, 'Kroatien', 'croatia.gif', ''),
(22, 'Portugal', 'portugal.gif'),
(22, 'Portugal', 'portugal.gif', ''),
(23, 'Tschechien', 'czechrepublic.gif');
(23, 'Tschechien', 'czechrepublic.gif', '');
 
 
 
--
-- Tabellenstruktur für Tabelle `ti_kommentar`
--
 
DROP TABLE IF EXISTS `ti_kommentar`;
CREATE TABLE IF NOT EXISTS `ti_kommentar` (
  `id` int(10) NOT NULL auto_increment,
  `kommentar` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `datum` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `nutzer_id` int(10) NOT NULL,
  `spiel_id` int(10) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `spiel_id` (`spiel_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
 
--
-- Daten für Tabelle `ti_kommentar`
--
 
INSERT INTO `ti_kommentar` (`id`, `kommentar`, `datum`, `nutzer_id`, `spiel_id`) VALUES
(8, 'Ganz klar: Germany spielt zu 0, weil Neuer einfach alles hält!', '2012-03-17 13:15:25', 10, 27),
(10, 'Das Spiel war sehr spannend. Deutschland hat schon wieder gewonnen.', '2012-03-17 13:59:54', 4, 27);

Version vom 18. März 2012, 13:48 Uhr

Datenbank: Infos

  1. Keine "echten" Passwörter für User hier reinlegen!!!!
  2. Die Tabelle ti-sibinet ist (aus Datenschutzgründen...) nicht vollständig. Sie sollte auch nie vollständig hier erscheinen!
  3. 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: 18. März 2012 um 14:46 -- 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` --

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

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

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=32 ;

-- -- Daten für Tabelle `ti_klasse` --

INSERT INTO `ti_klasse` (`id`, `name`) VALUES (17, '09A'), (18, '09B'), (19, '09C'), (27, 'Lehrer'), (28, 'Hausmeister'), (29, 'Sekretariat'), (13, '08A'), (14, '08B'), (15, '08C'), (16, '08D'), (1, '05A'), (2, '05B'), (3, '05C'), (4, '05D'), (5, '06A'), (6, '06B'), (7, '06C'), (8, '06D'), (9, '07A'), (10, '07B'), (11, '07C'), (12, '07D'), (20, '09D'), (21, '09E'), (22, 'EF-10'), (23, 'Q1-11'), (24, 'Q1-12'), (25, '13'), (26, 'Ehemalige'), (30, 'Freunde'), (31, 'Eltern');

-- --------------------------------------------------------

-- -- Tabellenstruktur für Tabelle `ti_kommentar` --

CREATE TABLE `ti_kommentar` ( 

 `id` int(10) NOT NULL auto_increment,
 `kommentar` varchar(280) NOT NULL,
 `datum` timestamp NOT NULL default CURRENT_TIMESTAMP,
 `nutzer_id` int(10) NOT NULL,
 `spiel_id` int(10) NOT NULL,
 PRIMARY KEY  (`id`),
 KEY `spiel_id` (`spiel_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;

-- -- Daten für Tabelle `ti_kommentar` --

INSERT INTO `ti_kommentar` (`id`, `kommentar`, `datum`, `nutzer_id`, `spiel_id`) VALUES (8, 'Ganz klar: Germany spielt zu 0, weil Neuer einfach alles hält!', '2012-03-17 13:15:25', 10, 27), (10, 'Das Spiel war sehr spannend. Deutschland hat schon wieder gewonnen.', '2012-03-17 13:59:54', 4, 27), (27, 'Fußball ist halt immer anders...', '2012-03-17 17:47:31', 4, 27);

-- --------------------------------------------------------

-- -- Tabellenstruktur für Tabelle `ti_nutzer` --

CREATE TABLE `ti_nutzer` ( 

 `id` int(10) unsigned NOT NULL auto_increment,
 `klasse_id` int(10) 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,
 `rolle` varchar(10) collate utf8_unicode_ci default NULL,
 `punkte` int(10) unsigned default NULL,
 `mail` varchar(80) collate utf8_unicode_ci default NULL,
 PRIMARY KEY  (`id`),
 KEY `nutzer_index_punkte` (`punkte`),
 KEY `klasse_id` (`klasse_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

-- -- Daten für Tabelle `ti_nutzer` --

INSERT INTO `ti_nutzer` (`id`, `klasse_id`, `nick`, `passwort`, `name`, `vorname`, `rolle`, `punkte`, `mail`) VALUES (4, 2, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', , , NULL, 0, NULL), (25, 5, 'b2', '32f28ea03b1b20126629d2ca63fc6665b0bbb604', , , NULL, NULL, 'b2b2@sibi.honnef.de'), (24, 5, 'a2', 'b9f85daa6f83cf02ce5c31913d1f64d3f5c8fade', , , NULL, NULL, 'a2a2@sibi.honnef.de'), (19, 5, 'a', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', , , NULL, 5, 'aaa@sibi.honnef.de'), (20, 5, 'b', 'e9d71f5ee7c92d6dc9e92ffdad17b8bd49418f98', , , NULL, 0, 'bbb@sibi.honnef.de'), (21, 5, 'c', '84a516841ba77a5b4648de2cd0dfcb30ea46dbb4', , , NULL, 8, 'ccc@sibi.honnef.de'), (22, 5, 'd', '3c363836cf4e16666669a25da280a1865c2d2874', , , NULL, 14, 'ddd@sibi.honnef.de'), (23, 0, 'autor', '51182033f975abba510f037480ec2571967ae2e9', , , 'autor', 0, 'autor@sibi.honnef.de');

-- --------------------------------------------------------

-- -- Tabellenstruktur für Tabelle `ti_sibinet` --

CREATE TABLE `ti_sibinet` ( 

 `id` int(10) NOT NULL auto_increment,
 `login` varchar(45) collate utf8_unicode_ci NOT NULL,
 `vorname` varchar(45) collate utf8_unicode_ci NOT NULL,
 `name` varchar(45) collate utf8_unicode_ci NOT NULL,
 `klasse` varchar(10) collate utf8_unicode_ci default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1462 ;

-- -- Daten für Tabelle `ti_sibinet` --

INSERT INTO `ti_sibinet` (`id`, `login`, `vorname`, `name`, `klasse`) VALUES (42, 'akaibel', 'Andreas', 'Kaibel', NULL), (468, 'hlewin', 'Heike', 'Lewin', 'Q1-11'), (1013, 'mtchalabi', 'Mohammad Fadel', 'Tchalabi', 'Q1-12'), (1195, 'rroschlau', 'Robin', 'Roschlau', 'Q1-12'), (1374, 'tnolden', 'Thorsten', 'Nolden', 'Q1-11');

-- --------------------------------------------------------

-- -- Tabellenstruktur für Tabelle `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 `verein1_id` (`verein1_id`),
 KEY `verein2_id` (`verein2_id`),
 KEY `gruppe_id` (`gruppe_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', 2, 0, 1), (32, 15, 4, 3, '2012-06-10', '18:00:00', 3, 1, 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', 2, 4, 1), (26, 14, 16, 2, '2012-06-09', '18:00:00', 0, 0, 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', 1, 2, 1), (20, 12, 17, 1, '2012-06-08', '18:00:00', 2, 3, 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` --

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 `nutzer_id` (`nutzer_id`),
 KEY `spiel_id` (`spiel_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 (19, 31, NULL, NULL), (19, 30, NULL, NULL), (19, 29, NULL, NULL), (19, 28, NULL, NULL), (19, 27, 1, 1), (19, 26, 2, 0), (19, 25, NULL, NULL), (19, 24, NULL, NULL), (19, 23, NULL, NULL), (19, 22, NULL, NULL), (19, 21, 1, 2), (19, 20, 4, 4), (19, 32, NULL, NULL), (19, 33, NULL, NULL), (19, 34, NULL, NULL), (19, 35, NULL, NULL), (19, 36, NULL, NULL), (19, 37, NULL, NULL), (19, 38, NULL, NULL), (19, 39, NULL, NULL), (19, 40, NULL, NULL), (19, 41, NULL, NULL), (19, 42, NULL, NULL), (19, 43, NULL, NULL), (20, 20, 2, 1), (20, 21, 3, 3), (20, 22, NULL, NULL), (20, 23, NULL, NULL), (20, 24, NULL, NULL), (20, 25, NULL, NULL), (20, 26, 0, 2), (20, 27, 4, 2), (20, 28, NULL, NULL), (20, 29, NULL, NULL), (20, 30, NULL, NULL), (20, 31, NULL, NULL), (20, 32, 0, 0), (20, 33, 2, 2), (20, 34, NULL, NULL), (20, 35, NULL, NULL), (20, 36, NULL, NULL), (20, 37, NULL, NULL), (20, 38, NULL, NULL), (20, 39, NULL, NULL), (20, 40, NULL, NULL), (20, 41, NULL, NULL), (20, 42, NULL, NULL), (20, 43, NULL, NULL), (21, 20, 1, 2), (21, 21, 2, 2), (21, 22, NULL, NULL), (21, 23, NULL, NULL), (21, 24, NULL, NULL), (21, 25, NULL, NULL), (21, 26, 4, 4), (21, 27, 3, 3), (21, 28, NULL, NULL), (21, 29, NULL, NULL), (21, 30, NULL, NULL), (21, 31, NULL, NULL), (21, 32, NULL, NULL), (21, 33, 2, 4), (21, 34, NULL, NULL), (21, 35, NULL, NULL), (21, 36, NULL, NULL), (21, 37, NULL, NULL), (21, 38, NULL, NULL), (21, 39, NULL, NULL), (21, 40, NULL, NULL), (21, 41, NULL, NULL), (21, 42, NULL, NULL), (21, 43, NULL, NULL), (22, 20, 3, 1), (22, 21, 2, 3), (22, 22, NULL, NULL), (22, 23, NULL, NULL), (22, 24, NULL, NULL), (22, 25, NULL, NULL), (22, 26, 3, 3), (22, 27, 2, 2), (22, 28, NULL, NULL), (22, 29, NULL, NULL), (22, 30, NULL, NULL), (22, 31, NULL, NULL), (22, 32, 5, 4), (22, 33, 1, 0), (22, 34, NULL, NULL), (22, 35, NULL, NULL), (22, 36, NULL, NULL), (22, 37, NULL, NULL), (22, 38, NULL, NULL), (22, 39, NULL, NULL), (22, 40, NULL, NULL), (22, 41, NULL, NULL), (22, 42, 2, 3), (22, 43, NULL, NULL), (4, 20, 5, 4), (4, 21, 2, 2), (4, 22, 0, 2), (4, 23, NULL, NULL), (4, 24, NULL, NULL), (4, 25, NULL, NULL), (4, 26, 3, 2), (4, 27, 1, 1), (4, 28, NULL, NULL), (4, 29, NULL, NULL), (4, 30, NULL, NULL), (4, 31, NULL, NULL), (4, 32, 0, 2), (4, 33, 0, 3), (4, 34, NULL, NULL), (4, 35, NULL, NULL), (4, 36, NULL, NULL), (4, 37, NULL, NULL), (4, 38, 4, 2), (4, 39, 1, 3), (4, 40, NULL, NULL), (4, 41, NULL, NULL), (4, 42, NULL, NULL), (4, 43, NULL, NULL);

-- --------------------------------------------------------

-- -- Tabellenstruktur für Tabelle `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,
 `beschreibung` varchar(500) 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`, `beschreibung`) 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, 'Tschechien', 'czechrepublic.gif', );

Abgerufen von „https://sibiwiki.de/wiki/index.php?title=Tippgemeinschaft:Datenbank&oldid=540“