BTYSZBGY

1ALTER TABLE `server_configuration` ADD COLUMN `emoji_image_path_url` varchar(256) DEFAULT 'http://localhost:8080/assets/img/emoji/';
2ALTER TABLE `players` 
3	MODIFY `name_colour` varchar(256) DEFAULT 'none',
4	ADD COLUMN `emoji_enabled` enum('0','1') DEFAULT '0';
5-- ----------------------------
6-- Table structure for emojis
7-- ----------------------------
8DROP TABLE IF EXISTS `emojis`;
9CREATE TABLE `emojis` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `min_rank` int(11) DEFAULT '1',
12  `strings` varchar(256) NOT NULL,
13  PRIMARY KEY (`id`)
14) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8;
15-- ----------------------------
16-- Records of emojis
17-- ----------------------------
18INSERT INTO `emojis` VALUES ('1', '1', ':p');
19INSERT INTO `emojis` VALUES ('2', '1', ':P');
20INSERT INTO `emojis` VALUES ('3', '1', ':|&:!');
21INSERT INTO `emojis` VALUES ('4', '1', ':D');
22INSERT INTO `emojis` VALUES ('5', '1', ':)');
23INSERT INTO `emojis` VALUES ('6', '1', ':(');
24INSERT INTO `emojis` VALUES ('7', '1', ':b');
25INSERT INTO `emojis` VALUES ('8', '1', ';)');
26INSERT INTO `emojis` VALUES ('9', '1', ':\'d');
27INSERT INTO `emojis` VALUES ('10', '1', '|_|');
28INSERT INTO `emojis` VALUES ('11', '1', ':@');
29INSERT INTO `emojis` VALUES ('12', '1', '>.>');
30INSERT INTO `emojis` VALUES ('13', '1', '>_>');
31INSERT INTO `emojis` VALUES ('14', '1', '<_<');
32INSERT INTO `emojis` VALUES ('15', '1', '<.<');
33INSERT INTO `emojis` VALUES ('16', '1', '._.');
34INSERT INTO `emojis` VALUES ('17', '1', ';\'(');
35INSERT INTO `emojis` VALUES ('18', '1', ':x');
36INSERT INTO `emojis` VALUES ('19', '1', ':cat');
37INSERT INTO `emojis` VALUES ('20', '1', ':s');
38INSERT INTO `emojis` VALUES ('21', '1', ':^)');
39INSERT INTO `emojis` VALUES ('22', '1', 'o.o');
40INSERT INTO `emojis` VALUES ('23', '1', ':<.>');
41INSERT INTO `emojis` VALUES ('24', '1', ':l');
42INSERT INTO `emojis` VALUES ('25', '1', ':facepalm');
43INSERT INTO `emojis` VALUES ('28', '1', 'x_x');
44INSERT INTO `emojis` VALUES ('29', '1', 'xd');
45INSERT INTO `emojis` VALUES ('31', '1', ':Peace');
46INSERT INTO `emojis` VALUES ('32', '1', ':peace');
47INSERT INTO `emojis` VALUES ('35', '1', ':o');
48INSERT INTO `emojis` VALUES ('36', '1', ':$');
49INSERT INTO `emojis` VALUES ('38', '1', ':gtfo');
50INSERT INTO `emojis` VALUES ('39', '1', ':think');
51INSERT INTO `emojis` VALUES ('40', '1', ':marshmallow');
52INSERT INTO `emojis` VALUES ('41', '1', ':ily');
53INSERT INTO `emojis` VALUES ('42', '1', ':sleep');
54INSERT INTO `emojis` VALUES ('43', '1', ':bff');
55INSERT INTO `emojis` VALUES ('44', '1', ':bad');
56INSERT INTO `emojis` VALUES ('46', '1', ':fire');
57INSERT INTO `emojis` VALUES ('99', '1', ':O');
58INSERT INTO `emojis` VALUES ('192', '1', ':xd');
59-- ----------------------------
60-- Table structure for name_colors
61-- ----------------------------
62DROP TABLE IF EXISTS `name_colors`;
63CREATE TABLE `name_colors` (
64  `id` int(11) NOT NULL AUTO_INCREMENT,
65	`name` varchar(256) NOT NULL,
66  `min_rank` int(11) DEFAULT '1',
67  `color_code` varchar(256) NOT NULL,
68  PRIMARY KEY (`id`)
69) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
70-- ----------------------------
71-- Records of name_colors
72-- ----------------------------
73INSERT INTO `name_colors` VALUES ('1', 'none', '1', '000000');
74INSERT INTO `name_colors` VALUES ('2', 'red', '1', 'FF0000');
75INSERT INTO `name_colors` VALUES ('3', 'blue', '1', '0000FF');
76INSERT INTO `name_colors` VALUES ('4', 'green', '1', '00FF00');
77INSERT INTO `name_colors` VALUES ('5', 'redblack', '2', '000000,FF0000');