S9ZXEcLf

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : root
5 Source Server Type    : MySQL
6 Source Server Version : 50545
7 Source Host           : localhost:3306
8 Source Schema         : pilvi
9
10 Target Server Type    : MySQL
11 Target Server Version : 50545
12 File Encoding         : 65001
13
14 Date: 01/10/2019 13:01:01
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for color_names
22-- ----------------------------
23DROP TABLE IF EXISTS `color_names`;
24CREATE TABLE `color_names`  (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
27  `color_code` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#000000',
28  `min_rank` int(11) NULL DEFAULT 1,
29  PRIMARY KEY (`id`) USING BTREE
30) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
31
32-- ----------------------------
33-- Records of color_names
34-- ----------------------------
35INSERT INTO `color_names` VALUES (1, 'red', '#ff0000', 1);
36INSERT INTO `color_names` VALUES (2, 'rainbow', '#ff4c4c,#ffa34c,#fff74c,#4cff82,#4cc3ff,#8a4cff', 1);
37INSERT INTO `color_names` VALUES (3, 'purple', '#8f00ff', 1);
38INSERT INTO `color_names` VALUES (4, 'gradient', '#ff2d00,#cf2500,#871901', 1);
39
40-- ----------------------------
41-- Table structure for emojis
42-- ----------------------------
43DROP TABLE IF EXISTS `emojis`;
44CREATE TABLE `emojis`  (
45  `id` int(11) NOT NULL AUTO_INCREMENT,
46  `min_rank` int(11) NULL DEFAULT 1,
47  `keys` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
48  PRIMARY KEY (`id`) USING BTREE
49) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
50
51-- ----------------------------
52-- Records of emojis
53-- ----------------------------
54INSERT INTO `emojis` VALUES (1, 1, ':p');
55INSERT INTO `emojis` VALUES (2, 1, ':P');
56INSERT INTO `emojis` VALUES (3, 1, ':|&:!');
57
58SET FOREIGN_KEY_CHECKS = 1;
59
60
61ALTER TABLE  `permissions` ADD  `cmd_namecolour` ENUM('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1';
62ALTER TABLE  `users` ADD  `name_colour` VARCHAR(255) NOT NULL DEFAULT 'default';