--用户表

create table "SysUser"(

    "UserId" serial,                  --用户Id，自增

    "UserName" character varying(50), --用户名

    "Pwd" character varying(50),      --密码

    "Status" smallint,                --状态

    primary key("UserId")             --设置UserId主键

)

--角色表

create table "SysRole"(

    "RoleId" serial,                  --角色Id

    "RoleName" character varying(50), --角色名称

    primary key("RoleId")

)

--用户角色关系表

create table "SysUserRole"(

      "UserId" integer,--用户Id

        "RoleId" integer,--角色Id

    primary key("UserId","RoleId")

)

--测试数据

insert into "SysUser" ("UserName","Pwd") values ('username1','');

insert into "SysUser" ("UserName","Pwd") values ('username2','');

insert into "SysUser" ("UserName","Pwd") values ('username3','');

insert into "SysUser" ("UserName","Pwd") values ('username4','');

insert into "SysRole" ("RoleName") values ('Role1');

insert into "SysRole" ("RoleName") values ('Role2');

insert into "SysUserRole" ("UserId","RoleId") values (1,1);

insert into "SysUserRole" ("UserId","RoleId") values (2,2);

insert into "SysUserRole" ("UserId","RoleId") values (3,1);

insert into "SysUserRole" ("UserId","RoleId") values (3,2);