Files
mod-playerbots/data/sql/playerbots/base/playerbots_random_bots.sql

16 lines
476 B
SQL

DROP TABLE IF EXISTS `playerbots_random_bots`;
CREATE TABLE `playerbots_random_bots` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` INT(11) NOT NULL,
`bot` INT(11) NOT NULL,
`time` INT(11) NOT NULL,
`validIn` INT(11) DEFAULT NULL,
`event` varchar(45) DEFAULT NULL,
`value` INT(11) DEFAULT NULL,
`data` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `owner` (`owner`),
KEY `bot` (`bot`),
KEY `event` (`event`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;