3ruEmPwZ

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