cCpi2vsW

1CREATE DATABASE IF NOT EXISTS `backserver` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
2
3DROP TABLE IF EXISTS `backserver`.`backclients`;
4CREATE TABLE `backserver`.`backclients` (
5  `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
6  `botid` varchar(36) NOT NULL,
7  `botip` varchar(16) NOT NULL,
8  `type` varchar(10) NOT NULL,
9  `botport` int(11) NOT NULL,
10  `onlinefrom` datetime NOT NULL,
11  PRIMARY KEY (`id`),
12  UNIQUE KEY `backid` (`botid`, `type`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;
14
15DROP TABLE IF EXISTS `backserver`.`backhistory`;
16CREATE TABLE `backserver`.`backhistory` (
17  `botid` varchar(36) NOT NULL,
18  `type` int(11) NOT NULL,
19  `port` int(11) NOT NULL,
20  PRIMARY KEY (`botid`, `type`)
21) ENGINE=MyISAM DEFAULT CHARSET=utf8;
22
23CREATE USER IF NOT EXISTS 'backserver'@'localhost' IDENTIFIED BY 'vj6JY1oP7LA9F4276to6y73r88M4h76Er35091K425A3M7U9U69B8H2JE13y';
24GRANT USAGE ON *.* TO 'backserver'@'localhost';
25GRANT ALL PRIVILEGES ON `backserver`.* TO 'backserver'@'localhost';
26
27CREATE USER IF NOT EXISTS 'backviewer'@'%' IDENTIFIED BY 'VrggeNj1ydwD3Pgt62HrgHXzja8SlJMTSSEBtg2hDxwX6osiMFu43PyjxQvN';
28GRANT USAGE ON *.* TO 'backviewer'@'%';
29GRANT SELECT ON `backserver`.* TO 'backviewer'@'%';