From d2846a33833eb86c2f4ad098a20524d80506b2e7 Mon Sep 17 00:00:00 2001 From: Angelo Cuccato Date: Sat, 25 Dec 2010 20:19:33 +0100 Subject: add Freeloader logging --- DB/Himmel.sql | 16 +++++++++++++++- 1 file changed, 15 insertions(+), 1 deletion(-) (limited to 'DB') diff --git a/DB/Himmel.sql b/DB/Himmel.sql index b76021b3..e8edbc80 100755 --- a/DB/Himmel.sql +++ b/DB/Himmel.sql @@ -212,4 +212,18 @@ CREATE TABLE IF NOT EXISTS `Counter` ( `URL` varchar(255) NOT NULL default '', `Anz` bigint(20) NOT NULL default '0', PRIMARY KEY (`URL`) -) TYPE=MyISAM COMMENT='Counter alles der Seiten'; +) TYPE=MyISAM COMMENT='Counter der Seiten'; + +-- +-- Tabellenstruktur für Tabelle `ShiftFreeloader` +-- + +CREATE TABLE IF NOT EXISTS `ShiftFreeloader` ( + `ID` int(11) NOT NULL auto_increment, + `Remove_Time` timestamp NOT NULL default CURRENT_TIMESTAMP, + `UID` int(11) NOT NULL, + `Length` int(11) NOT NULL, + `Comment` text NOT NULL, + PRIMARY KEY (`ID`) +) TYPE=MyISAM AUTO_INCREMENT=1 ; + -- cgit v1.2.3-54-g00ecf