From 0e1f47619cc063c5af3a3caf0959bf725ceb29a2 Mon Sep 17 00:00:00 2001 From: ulrich <undisclosed> Date: Wed, 05 Apr 2017 13:06:50 +0000 Subject: [PATCH] Rolle sqlKonsole in DB-Skript aufgenommen --- web/WEB-INF/create_database.sql | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql index 596df1f..4f1be1b 100644 --- a/web/WEB-INF/create_database.sql +++ b/web/WEB-INF/create_database.sql @@ -3,7 +3,7 @@ CREATE TABLE APP.USERS ( USER_NAME VARCHAR(250) NOT NULL, - USER_PASS VARCHAR(250) NOT NULL, + USER_PASS VARCHAR(1024) NOT NULL, USER_FIRST VARCHAR(250), USER_LAST VARCHAR(250), USER_EMAIL VARCHAR(250), @@ -17,6 +17,11 @@ ROLE_NAME VARCHAR(250) NOT NULL, PRIMARY KEY (USER_NAME, ROLE_NAME) ); +insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'manager-script'); +insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'nutzerAdmin'); +insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'wbxAdmin'); +insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'ownFileAdmin'); +insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'sqlKonsole'); create table APP.keytable ( key_name varchar(80) not null primary key, -- Gitblit v1.9.3