· 8 years ago · Nov 27, 2017, 04:30 PM
1[bLogs] Successfully connected to remote database on 37.122.209.16:3306.
2[bLogs] MySQL error!: Unknown character set: 'utf8mb4'
3
4 CREATE TABLE IF NOT EXISTS `blogs` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `session` int(11) NOT NULL,
7 `module` varchar(255) NOT NULL,
8 `log` text CHARACTER SET utf8mb4 NOT NULL,
9 `time` int(11) NOT NULL,
10 PRIMARY KEY (`id`)
11 );
12
13 CREATE TABLE IF NOT EXISTS `blogs_archive` (
14 `id` int(11) NOT NULL AUTO_INCREMENT,
15 `module` varchar(255) NOT NULL,
16 `log` text CHARACTER SET utf8mb4 NOT NULL,
17 `time` int(11) NOT NULL,
18 PRIMARY KEY (`id`)
19 );
20
21 CREATE TABLE IF NOT EXISTS `blogs_vars` (
22 `var_name` varchar(255) NOT NULL,
23 `var_str` varchar(255) NOT NULL,
24 `var_int` int(11) NOT NULL,
25 PRIMARY KEY (`var_name`)
26 );
27
28 DROP PROCEDURE IF EXISTS SCHEMA_CHANGE;
29
30 CREATE PROCEDURE SCHEMA_CHANGE() BEGIN
31
32 IF EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_NAME='blogs' AND COLUMN_NAME='ROWID' AND TABLE_SCHEMA='drewbie_blogs') THEN
33 ALTER TABLE `blogs` CHANGE `ROWID` `id` INT(11) NOT NULL AUTO_I[17:26][ServerGuard] Fetched friends for Drewbie (success)