· 8 years ago · Feb 03, 2018, 05:22 PM
1DROP TABLE IF EXISTS `roles`;
2
3CREATE TABLE `roles` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `permissions` json DEFAULT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9LOCK TABLES `roles` WRITE;
10
11INSERT INTO `roles` (`id`, `permissions`)
12VALUES
13 (1,X'7B2263616E437265617465506F737473223A20747275657D'),
14 (2,X'7B2263616E436F6D6D656E74506F737473223A20747275657D'),
15 (3,X'7B2263616E45646974506F737473223A20747275657D'),
16 (4,X'7B2263616E437265617465546F70696373223A20747275657D'),
17 (5,X'7B2263616E436F6D6D656E74546F70696373223A20747275657D'),
18 (6,X'7B2263616E45646974546F70696373223A20747275657D'),
19 (7,X'7B2263616E45646974466F72756D223A20747275652C202263616E45646974506F737473223A20747275652C202263616E45646974546F70696373223A20747275652C202263616E437265617465466F72756D223A20747275652C202263616E437265617465506F737473223A20747275652C202263616E437265617465546F706963223A20747275652C202263616E44656C657465466F72756D223A20747275652C202263616E436F6D6D656E74506F737473223A20747275652C202263616E436F6D6D656E74546F706963223A20747275657D'),
20 (8,X'7B2263616E437265617465466F72756D223A20747275657D'),
21 (9,X'7B2263616E45646974466F72756D223A20747275657D');
22
23UNLOCK TABLES;