Anonymous

    DROP DATABASE IF EXISTS usersecurity;    CREATE DATABASE usersecurity;    create table usersecurity.GroupPermissions (        GroupId varchar(255) not null,        PermissionId int not null,        primary key (GroupId, PermissionId)    );    create table usersecurity.groups (        distinguishedName varchar(255) not null,        primary key (distinguishedName)    );    create table usersecurity.permissions (        permissionId int not null,        applicaitonName varchar(255) null,        moduleName varchar(255) null,        objectName varchar(255) null,        actionName varchar(255) null,        primary key (permissionId)    );    alter table usersecurity.GroupPermissions        add constraint FK88EB34A591F848B1         foreign key (GroupId)         references usersecurity.groups;    alter table usersecurity.GroupPermissions        add constraint FK88EB34A5D7E925A1        foreign key (PermissionId)        references usersecurity.permissions;