6.sql 483 B

123456789
  1. insert into t_permission (name,pid,value,weight) values ('平台配置',0,'platform.list',1);
  2. SELECT @parentId := LAST_INSERT_ID();
  3. 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)
  4. ALTER TABLE `charge_admin`.`t_platform`
  5. MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT FIRST,
  6. ADD PRIMARY KEY (`id` DESC);