X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.sql;h=01abde3eba806b9cc613daf5bfe3afe0a6386ec5;hp=4b1bb19685bb1d82b11b8899b7a226ca72360290;hb=141636b58bbe071ac218f214aa26613ab6f2aff0;hpb=325de2e651ca95ad03ee333ed92a737affad3fce 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; -- --------------------------------------------------------