github.com/SupenBysz/gf-admin-community@v0.7.4/database/migrations/000008_v01.1217.up.sql (about) 1 ALTER TABLE "public"."sys_role" 2 ADD COLUMN "union_main_id" int8, 3 ADD COLUMN "is_sys" varchar(255); 4 5 COMMENT ON COLUMN "public"."sys_role"."union_main_id" IS '主体id'; 6 7 COMMENT ON COLUMN "public"."sys_role"."is_sys" IS '是否允许删除和修改: 0允许 1禁止,并拥有默认权限 '; 8 9 ALTER TABLE "public"."sys_role" 10 ALTER COLUMN "is_sys" TYPE int2 USING "is_sys"::int2;