From 48a649c8e6fca04a0a7de20110e6a8427e9da659 Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Thu, 06 Apr 2017 15:26:35 +0000
Subject: [PATCH] Profil hinzugefuegt
---
web/WEB-INF/create_database.sql | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
index 596df1f..5258a34 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,12 @@
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', 'nutzerProfil');
+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