Tippgemeinschaft:Datenbank: Unterschied zwischen den Versionen

Aus SibiWiki
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „= SQL-Insert-Skript für die Datenbank= # Keine "echten" Passwörter für User hier reinlegen!!!! # Am besten den Quelltext für die Erzeugung der Datenbank nu…“)
 
(Attribut Mail in ti_sibinet)
 
(15 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
= SQL-Insert-Skript für die Datenbank=
= Datenbank: Infos=
# Keine "echten" Passwörter für User hier reinlegen!!!!
# Keine "echten" Passwörter für User hier reinlegen!!!!
# Die Tabelle ti-sibinet ist (aus Datenschutzgründen...) nicht vollständig. '''Sie sollte auch nie vollständig hier erscheinen!'''
# Am besten den Quelltext für die Erzeugung der Datenbank nutzen.
# Am besten den Quelltext für die Erzeugung der Datenbank nutzen.


= SQL-Insert-Skript =


-- phpMyAdmin SQL Dump
-- phpMyAdmin SQL Dump
Zeile 9: Zeile 11:
--
--
-- Host: localhost
-- Host: localhost
-- Erstellungszeit: 01. März 2012 um 23:41
-- Erstellungszeit: 18. März 2012 um 21:01
-- Server Version: 5.0.45
-- Server Version: 5.0.45
-- PHP-Version: 5.2.4
-- PHP-Version: 5.2.4
Zeile 18: Zeile 20:
-- Datenbank: `tipp`
-- 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');


-- --------------------------------------------------------
-- --------------------------------------------------------
Zeile 25: Zeile 48:
--
--


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,
   `name` varchar(255) 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=9 ;
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;


--
--
Zeile 40: Zeile 64:
(3, 'Gruppe C'),
(3, 'Gruppe C'),
(4, 'Gruppe D'),
(4, 'Gruppe D'),
(5, 'Gruppe E'),
(9, 'Finalrunde');
(6, 'Gruppe F'),
(7, 'Gruppe G'),
(8, 'Gruppe H');


-- --------------------------------------------------------
-- --------------------------------------------------------
Zeile 51: Zeile 72:
--
--


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,
   `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=8 ;
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ;


--
--
Zeile 62: Zeile 84:


INSERT INTO `ti_klasse` (`id`, `name`) VALUES
INSERT INTO `ti_klasse` (`id`, `name`) VALUES
(1, '9a'),
(17, '09A'),
(2, '9b'),
(18, '09B'),
(3, '9c'),
(19, '09C'),
(4, 'Lehrer'),
(27, 'Lehrer'),
(5, '8a'),
(28, 'Hausmeister'),
(6, '8b'),
(29, 'Sekretariat'),
(7, '8c');
(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`
--
 
DROP TABLE IF EXISTS `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
(4, 'Ganz klar: Germany spielt zu 0, weil Neuer einfach alles hält!', '2012-03-17 13:15:25', 22, 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 76: Zeile 148:
--
--


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,
   `klasse_id` int(10) unsigned NOT NULL,
   `klasse_id` int(10) NOT NULL,
  `admin` tinyint(1) NOT NULL default '0',
   `nick` varchar(20) collate utf8_unicode_ci NOT NULL,
   `nick` varchar(20) collate utf8_unicode_ci NOT NULL,
   `passwort` varchar(255) collate utf8_unicode_ci NOT NULL,
   `passwort` varchar(255) collate utf8_unicode_ci NOT NULL,
   `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,
   `punktedatum` date default NULL,
   `token` varchar(10) collate utf8_unicode_ci NOT NULL,
  `mail` varchar(80) collate utf8_unicode_ci default NULL,
   PRIMARY KEY  (`id`),
   PRIMARY KEY  (`id`),
   KEY `nutzer_index_punkte` (`punkte`)
   KEY `nutzer_index_punkte` (`punkte`),
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
  KEY `klasse_id` (`klasse_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;


--
--
Zeile 94: Zeile 169:
--
--


INSERT INTO `ti_nutzer` (`id`, `klasse_id`, `admin`, `nick`, `passwort`, `name`, `vorname`, `punkte`, `punktedatum`) VALUES
INSERT INTO `ti_nutzer` (`id`, `klasse_id`, `nick`, `passwort`, `name`, `vorname`, `rolle`, `punkte`, `token`, `mail`) VALUES
(6, 1, 0, 'max', '0706025b2bbcec1ed8d64822f4eccd96314938d0', '', '', 9, '2010-06-30'),
(4, 2, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'Timmes', 'Theo', NULL, 0, '', NULL),
(4, 2, 0, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', '', '', 10, '2010-06-30'),
(25, 5, 'b2', '32f28ea03b1b20126629d2ca63fc6665b0bbb604', 'Bartho', 'Berta', NULL, NULL, '', 'b2b2@sibi.honnef.de'),
(5, 1, 1, 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', '', '', 0, '2010-06-30'),
(24, 5, 'a2', 'b9f85daa6f83cf02ce5c31913d1f64d3f5c8fade', 'Amann', 'Anna', NULL, NULL, '', 'a2a2@sibi.honnef.de'),
(7, 4, 0, 'test2', '109f4b3c50d7b0df729d299bc6f8e9ef9066971f', '', '', 0, NULL),
(19, 5, 'a', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', 'Alster', 'Albert', NULL, 5, '', 'aaa@sibi.honnef.de'),
(8, 3, 0, 'bla', 'ffa6706ff2127a749973072756f83c532e43ed02', '', '', 0, NULL),
(20, 5, 'b', 'e9d71f5ee7c92d6dc9e92ffdad17b8bd49418f98', 'Bohr', 'Bruno', NULL, 0, '', 'bbb@sibi.honnef.de'),
(10, 0, 0, 'm', '6b0d31c0d563223024da45691584643ac78c96e8', '', '', 4, NULL);
(21, 5, 'c', '84a516841ba77a5b4648de2cd0dfcb30ea46dbb4', 'Char', 'Christoph', NULL, 8, '', 'ccc@sibi.honnef.de'),
(22, 5, 'd', '3c363836cf4e16666669a25da280a1865c2d2874', 'Day', 'Doris', NULL, 14, '', 'ddd@sibi.honnef.de'),
(23, 0, 'autor', '51182033f975abba510f037480ec2571967ae2e9', 'Anton', 'Autor', '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,
  `token` varchar(10) collate utf8_unicode_ci default NULL,
  `mail` varchar(80) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1463 ;
 
--
-- Daten für Tabelle `ti_sibinet`
--


INSERT INTO `ti_sibinet` (`id`, `login`, `vorname`, `name`, `klasse`, `token`, `mail`) VALUES
(42, 'akaibel', 'Andreas', 'Kaibel', 'Lehrer', 'xc7F5', 'a.kaibel@googlemail.com'),
(468, 'hlewin', 'Heike', 'Lewin', 'Q1-11', NULL, NULL),
(1013, 'mtchalabi', 'Mohammad Fadel', 'Tchalabi', 'Q1-12', NULL, NULL),
(1195, 'rroschlau', 'Robin', 'Roschlau', 'Q1-12', NULL, NULL),
(1374, 'tnolden', 'Thorsten', 'Nolden', 'Q1-11', NULL, NULL),
(1462, 'fkaibel', 'Felix', 'Kaibel', 'EF-10', 'Y3d5C2', NULL);
-- --------------------------------------------------------
-- --------------------------------------------------------


Zeile 108: Zeile 213:
--
--


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 114: Zeile 220:
   `gruppe_id` int(10) unsigned NOT NULL,
   `gruppe_id` int(10) unsigned NOT NULL,
   `datum` date NOT NULL,
   `datum` date NOT NULL,
  `zeit` time NOT NULL default '12:00:00',
   `tore1` int(10) unsigned default NULL,
   `tore1` int(10) unsigned default NULL,
   `tore2` int(10) unsigned default NULL,
   `tore2` int(10) unsigned default NULL,
   `faktor` int(10) NOT NULL default '1',
   `faktor` int(10) NOT NULL default '1',
   PRIMARY KEY  (`id`),
   PRIMARY KEY  (`id`),
   KEY `spiel_FKIndex1` (`gruppe_id`),
   KEY `verein1_id` (`verein1_id`),
   KEY `spiel_verein1_id` (`verein1_id`),
   KEY `verein2_id` (`verein2_id`),
   KEY `spiel_verein2_id` (`verein2_id`)
   KEY `gruppe_id` (`gruppe_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=44 ;


--
--
Zeile 127: Zeile 234:
--
--


INSERT INTO `ti_spiel` (`id`, `verein1_id`, `verein2_id`, `gruppe_id`, `datum`, `tore1`, `tore2`, `faktor`) VALUES
INSERT INTO `ti_spiel` (`id`, `verein1_id`, `verein2_id`, `gruppe_id`, `datum`, `zeit`, `tore1`, `tore2`, `faktor`) VALUES
(10, 7, 1, 4, '2010-06-23', NULL, NULL, 1),
(33, 20, 21, 3, '2012-06-10', '20:45:00', 2, 0, 1),
(9, 7, 5, 4, '2010-06-19', 2, 3, 1),
(32, 15, 4, 3, '2012-06-10', '18:00:00', 3, 1, 1),
(8, 1, 6, 4, '2010-06-18', 3, 2, 1),
(31, 16, 1, 2, '2012-06-17', '20:45:00', NULL, NULL, 1),
(7, 6, 7, 4, '2010-06-13', 2, 2, 2),
(30, 22, 14, 2, '2012-06-17', '20:45:00', NULL, NULL, 1),
(6, 1, 5, 4, '2010-06-13', 0, 2, 1),
(29, 14, 1, 2, '2012-06-13', '20:45:00', NULL, NULL, 1),
(11, 5, 6, 4, '2010-06-23', NULL, NULL, 1),
(28, 16, 22, 2, '2012-06-13', '18:00:00', NULL, NULL, 1),
(12, 8, 9, 3, '2010-06-12', 1, 1, 1),
(27, 1, 22, 2, '2012-06-09', '20:45:00', 2, 4, 1),
(13, 10, 11, 3, '2010-06-13', 2, 2, 1),
(26, 14, 16, 2, '2012-06-09', '18:00:00', 0, 0, 1),
(14, 11, 9, 3, '2010-06-18', 3, 1, 1),
(25, 23, 12, 1, '2012-06-16', '20:45:00', NULL, NULL, 1),
(15, 8, 10, 3, '2010-06-18', 4, 2, 1),
(24, 17, 18, 1, '2012-06-16', '20:45:00', NULL, NULL, 1),
(16, 11, 8, 3, '2010-06-23', 2, 3, 1),
(23, 12, 18, 1, '2012-06-12', '20:45:00', NULL, NULL, 1),
(17, 9, 10, 3, '2010-06-23', 1, 0, 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);


-- --------------------------------------------------------
-- --------------------------------------------------------
Zeile 147: Zeile 266:
--
--


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 153: Zeile 273:
   `tore2` int(10) default NULL,
   `tore2` int(10) default NULL,
   PRIMARY KEY  (`nutzer_id`,`spiel_id`),
   PRIMARY KEY  (`nutzer_id`,`spiel_id`),
   KEY `tipp_FKIndex1` (`spiel_id`),
   KEY `nutzer_id` (`nutzer_id`),
   KEY `tipp_FKIndex2` (`nutzer_id`)
   KEY `spiel_id` (`spiel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


Zeile 162: Zeile 282:


INSERT INTO `ti_tipp` (`nutzer_id`, `spiel_id`, `tore1`, `tore2`) VALUES
INSERT INTO `ti_tipp` (`nutzer_id`, `spiel_id`, `tore1`, `tore2`) VALUES
(4, 17, 7, 4),
(19, 31, NULL, NULL),
(4, 16, 5, 4),
(19, 30, NULL, NULL),
(4, 15, NULL, NULL),
(19, 29, NULL, NULL),
(4, 11, 2, 4),
(19, 28, NULL, NULL),
(4, 14, 3, 3),
(19, 27, 1, 1),
(4, 13, 7, 2),
(19, 26, 2, 0),
(4, 12, 1, 1),
(19, 25, NULL, NULL),
(4, 10, 2, 3),
(19, 24, NULL, NULL),
(4, 8, 7, 1),
(19, 23, NULL, NULL),
(4, 7, 9, 9),
(19, 22, NULL, NULL),
(4, 6, 4, 3),
(19, 21, 1, 2),
(6, 12, 1, 2),
(19, 20, 4, 4),
(6, 13, 3, 4),
(19, 32, NULL, NULL),
(6, 14, 2, 2),
(19, 33, NULL, NULL),
(6, 15, 4, 1),
(19, 34, NULL, NULL),
(6, 16, 2, 3),
(19, 35, NULL, NULL),
(6, 17, 3, 4),
(19, 36, NULL, NULL),
(4, 9, 0, 3),
(19, 37, NULL, NULL),
(6, 7, 1, 1),
(19, 38, NULL, NULL),
(6, 8, 2, 5),
(19, 39, NULL, NULL),
(6, 9, 2, 4),
(19, 40, NULL, NULL),
(6, 10, 3, 2),
(19, 41, NULL, NULL),
(6, 11, 1, 2),
(19, 42, NULL, NULL),
(10, 6, NULL, NULL),
(19, 43, NULL, NULL),
(10, 7, NULL, NULL),
(20, 20, 2, 1),
(10, 8, NULL, NULL),
(20, 21, 3, 3),
(10, 9, 1, 2),
(20, 22, NULL, NULL),
(10, 10, 7, 8),
(20, 23, NULL, NULL),
(10, 11, 9, 10),
(20, 24, NULL, NULL),
(10, 12, NULL, NULL),
(20, 25, NULL, NULL),
(10, 13, NULL, NULL),
(20, 26, 0, 2),
(10, 14, NULL, NULL),
(20, 27, 4, 2),
(10, 15, NULL, NULL),
(20, 28, NULL, NULL),
(10, 16, 3, 4),
(20, 29, NULL, NULL),
(10, 17, 5, 6);
(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);


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


--
--
<code>
-- Tabellenstruktur für Tabelle `ti_verein`
-- Tabellenstruktur für Tabelle `ti_verein`
--
--


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(255) 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=12 ;
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;


--
--
Zeile 216: Zeile 422:
--
--


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', 'Ob Deutschland es diesmal wieder packt? Wir sind gespannt!'),
(2, 'Frankreich', 'france.gif'),
(2, 'Frankreich', 'france.gif', 'Frankreich sollte die Talsohle endg&uuml;ltig durchschritten haben.'),
(5, 'Australien', 'australia.gif'),
(16, 'D&auml;nemark', 'denmark.gif', ''),
(4, 'Italien', 'italy.gif'),
(4, 'Italien', 'italy.gif', ''),
(6, 'Serbien', 'serbia.gif'),
(15, 'Spanien', 'spain.gif', ''),
(7, 'Ghana', 'ghana.gif'),
(8, 'England', 'england.gif', ''),
(8, 'England', 'england.gif'),
(14, 'Niederlande', 'netherlands.gif', ''),
(9, 'USA', 'usa.gif'),
(13, 'Ukraine', 'ukraine.gif', ''),
(10, 'Algerien', 'algeria.gif'),
(12, 'Polen', 'poland.gif', ''),
(11, 'Slowenien', 'slovenia.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', '');

Aktuelle Version vom 23. März 2012, 22:54 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 21:01 -- 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=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` --

DROP TABLE IF EXISTS `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 (4, 'Ganz klar: Germany spielt zu 0, weil Neuer einfach alles hält!', '2012-03-17 13:15:25', 22, 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` --

DROP TABLE IF EXISTS `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,
 `token` varchar(10) collate utf8_unicode_ci NOT 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`, `token`, `mail`) VALUES (4, 2, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'Timmes', 'Theo', NULL, 0, , NULL), (25, 5, 'b2', '32f28ea03b1b20126629d2ca63fc6665b0bbb604', 'Bartho', 'Berta', NULL, NULL, , 'b2b2@sibi.honnef.de'), (24, 5, 'a2', 'b9f85daa6f83cf02ce5c31913d1f64d3f5c8fade', 'Amann', 'Anna', NULL, NULL, , 'a2a2@sibi.honnef.de'), (19, 5, 'a', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', 'Alster', 'Albert', NULL, 5, , 'aaa@sibi.honnef.de'), (20, 5, 'b', 'e9d71f5ee7c92d6dc9e92ffdad17b8bd49418f98', 'Bohr', 'Bruno', NULL, 0, , 'bbb@sibi.honnef.de'), (21, 5, 'c', '84a516841ba77a5b4648de2cd0dfcb30ea46dbb4', 'Char', 'Christoph', NULL, 8, , 'ccc@sibi.honnef.de'), (22, 5, 'd', '3c363836cf4e16666669a25da280a1865c2d2874', 'Day', 'Doris', NULL, 14, , 'ddd@sibi.honnef.de'), (23, 0, 'autor', '51182033f975abba510f037480ec2571967ae2e9', 'Anton', 'Autor', '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,
 `token` varchar(10) collate utf8_unicode_ci default NULL,
 `mail` varchar(80) collate utf8_unicode_ci default NULL,
 PRIMARY KEY  (`id`)

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

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

INSERT INTO `ti_sibinet` (`id`, `login`, `vorname`, `name`, `klasse`, `token`, `mail`) VALUES (42, 'akaibel', 'Andreas', 'Kaibel', 'Lehrer', 'xc7F5', 'a.kaibel@googlemail.com'), (468, 'hlewin', 'Heike', 'Lewin', 'Q1-11', NULL, NULL), (1013, 'mtchalabi', 'Mohammad Fadel', 'Tchalabi', 'Q1-12', NULL, NULL), (1195, 'rroschlau', 'Robin', 'Roschlau', 'Q1-12', NULL, NULL), (1374, 'tnolden', 'Thorsten', 'Nolden', 'Q1-11', NULL, NULL), (1462, 'fkaibel', 'Felix', 'Kaibel', 'EF-10', 'Y3d5C2', NULL); -- --------------------------------------------------------

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

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

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,
 `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', 'Ob Deutschland es diesmal wieder packt? Wir sind gespannt!'), (2, 'Frankreich', 'france.gif', 'Frankreich sollte die Talsohle endgültig durchschritten haben.'), (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=548“