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;