| 123456789 |
- insert into t_permission (name,pid,value,weight) values ('平台配置',0,'platform.list',1);
- SELECT @parentId := LAST_INSERT_ID();
- insert into t_permission (name,pid,value,weight) values ('查看',@parentId,'platform.list',1),('编辑',@parentId,'platform.modify',1),('删除',@parentId,'platform.remove',1),('新增',@parentId,'platform.add',1)
- ALTER TABLE `charge_admin`.`t_platform`
- MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT FIRST,
- ADD PRIMARY KEY (`id` DESC);
|