X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=database.sql;h=01abde3eba806b9cc613daf5bfe3afe0a6386ec5;hb=141636b58bbe071ac218f214aa26613ab6f2aff0;hp=4b1bb19685bb1d82b11b8899b7a226ca72360290;hpb=de4e38ad80dc9365a31e0226635e3cdf26b21577;p=NeonServV5.git diff --git a/database.sql b/database.sql index 4b1bb19..01abde3 100644 --- a/database.sql +++ b/database.sql @@ -52,13 +52,15 @@ CREATE TABLE IF NOT EXISTS `bots` ( CREATE TABLE IF NOT EXISTS `bot_binds` ( `id` int(11) NOT NULL AUTO_INCREMENT, `botclass` int(11) NOT NULL, + `botid` int(11) NOT NULL, `command` varchar(60) NOT NULL, `function` varchar(60) NOT NULL, `parameters` varchar(100) NOT NULL, `chan_access` varchar(256) DEFAULT NULL, `global_access` int(3) DEFAULT NULL, `flags` tinyint(4) NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `botid` (`botid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- --------------------------------------------------------