X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.sql;fp=database.sql;h=718b05877b0e6523a3a91a518c816949682315cd;hp=14102125e458b9748da6726a3975f22e24aee235;hb=abb1f08cf0b36ffd7ad54252a6893236dc274aff;hpb=382e8e7b3ee6d65c87ed795825cc3889fd915f3c diff --git a/database.sql b/database.sql index 1410212..718b058 100644 --- a/database.sql +++ b/database.sql @@ -359,4 +359,39 @@ CREATE TABLE `donotregister` ( UNIQUE ( `dnr_target` ) -) ENGINE = MYISAM ; \ No newline at end of file +) ENGINE = MYISAM ; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `helpserv_requests` +-- + +CREATE TABLE IF NOT EXISTS `helpserv_requests` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `host` varchar(200) NOT NULL, + `hand` varchar(50) NOT NULL, + `nick` varchar(50) NOT NULL, + `status` int(1) NOT NULL, + `supporter` int(11) NOT NULL, + `time` int(20) NOT NULL, + `delay` int(20) NOT NULL, + `text` text NOT NULL, + `log` text NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `helpserv_settings` +-- + +CREATE TABLE IF NOT EXISTS `helpserv_settings` ( + `helpserv_botid` int(11) NOT NULL, + `helpserv_support` varchar(256) NOT NULL, + `helpserv_public` varchar(256) DEFAULT NULL, + `helpserv_intern` varchar(256) DEFAULT NULL, + PRIMARY KEY (`helpserv_botid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +