MySQL 角色表创建和数据插入示例

DROP TABLE IF EXISTS role_tbl;\nCREATE TABLE role_tbl (\n id int(11) NOT NULL AUTO_INCREMENT,\n name varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\n code varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,\n type tinyint(4) NOT NULL,\n description varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,\n enabled tinyint(4) NULL DEFAULT 1,\n updated_at timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n created_by varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,\n updated_by varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,\n PRIMARY KEY (id) USING BTREE,\n UNIQUE INDEX uniq_role_tbl(name) USING BTREE\n) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = COMPACT;\n\n-- ----------------------------\n-- Records of role_tbl\n-- ----------------------------\nINSERT INTO role_tbl VALUES (NULL, '运维超级管理员', 'ROLE-DW-SUPER', 0, '默认运维角色, 请勿操作', 1, NULL, NULL, NULL, NULL);\nINSERT INTO role_tbl VALUES (NULL, '运维管理员', 'ROLE-YW-001', 0, '默认运维角色, 请勿操作', 1, NULL, NULL, NULL, NULL);\nINSERT INTO role_tbl VALUES (NULL, '运维操作员', 'ROLE-YW-002', 0, '默认运维角色, 请勿操作', 1, NULL, NULL, NULL, NULL);\n\nSET FOREIGN_KEY_CHECKS = 1;