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`)
+ `flags` int(10) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `botid` (`botid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
`id` int(11) NOT NULL AUTO_INCREMENT,
`botid` int(11) NOT NULL,
`chanid` int(11) NOT NULL,
- `trigger` varchar(50) NOT NULL DEFAULT '+',
+ `trigger` varchar(50) NULL DEFAULT '+',
`suspended` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;