forward/src/main/resources/db/migration/V1.0.2__modle_update.sql

update device set data = null;

ALTER TABLE `forward`.`model` 
ADD COLUMN `createtime` DATETIME NULL COMMENT '创建时间' AFTER `tenant_id`,
ADD COLUMN `modifytime` DATETIME NULL COMMENT '修改时间' AFTER `createtime`;

update model set createtime='2024-04-09 13:47:58';

ALTER TABLE `forward`.`permission` 
ADD COLUMN `name` VARCHAR(45) NULL COMMENT '别名' AFTER `icon`;

UPDATE `forward`.`role` SET `id` = 'developer', `name` = '开发人员', `description` = '开发人员' WHERE (`id` = 'worker');

LOCK TABLES `permission` WRITE;
/*!40000 ALTER TABLE `permission` DISABLE KEYS */;
INSERT INTO `permission` VALUES (4,0,'home','01',NULL,'管理员首页',0,NULL,'系统首页'),(5,0,'product','01','/product','产品管理',10,NULL,'产品管理'),(6,5,'product::add','03','/product/add','添加产品',20,NULL,'添加产品'),(15,0,'device','01','/device','设备管理相关功能',1,NULL,'设备管理');
/*!40000 ALTER TABLE `permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `role_permission`
--

LOCK TABLES `role_permission` WRITE;
/*!40000 ALTER TABLE `role_permission` DISABLE KEYS */;
INSERT INTO `role_permission` VALUES ('developer',4),('developer',5),('developer',15),('manager',4),('manager',5),('manager',6),('manager',15),('user',4),('user',5),('user',15);
/*!40000 ALTER TABLE `role_permission` ENABLE KEYS */;
UNLOCK TABLES;