| commit | author | age | ||
| 314fea | 1 | |
| U | 2 | |
| 3 | CREATE TABLE APP.USERS | |
| 4 | ( | |
| 5 | USER_NAME VARCHAR(250) NOT NULL, | |
| e0ec31 | 6 | USER_PASS VARCHAR(1024) NOT NULL, |
| 314fea | 7 | USER_FIRST VARCHAR(250), |
| U | 8 | USER_LAST VARCHAR(250), |
| 9 | USER_EMAIL VARCHAR(250), | |
| 10 | USER_CREATED VARCHAR(14), | |
| 11 | PRIMARY KEY (USER_NAME) | |
| 12 | ); | |
| 13 | ||
| 14 | CREATE TABLE APP.USER_ROLES | |
| 15 | ( | |
| 16 | USER_NAME VARCHAR(250) NOT NULL, | |
| 17 | ROLE_NAME VARCHAR(250) NOT NULL, | |
| 18 | PRIMARY KEY (USER_NAME, ROLE_NAME) | |
| 19 | ); | |
| d313b3 | 20 | insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'manager-script'); |
| 57c58d | 21 | insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'nutzerAdmin'); |
| U | 22 | insert into APP.USER_ROLES (user_name, role_name) values ('admin', 'sqlKonsole'); |
| 314fea | 23 | |
| U | 24 | create table APP.keytable ( |
| 25 | key_name varchar(80) not null primary key, | |
| 26 | key_next int | |
| 27 | ); | |
| 28 | create index key_name_next ON APP.keytable (key_name,key_next); | |
| 29 | insert into APP.keytable (key_name, key_next) values ('gr_id',1); | |
| 30 | insert into APP.keytable (key_name, key_next) values ('mt_id',1); | |
| 31 | ||
| 32 | create table APP.methoden ( | |
| 33 | mt_id int, | |
| 34 | mt_klasse varchar(32000), | |
| 35 | mt_name varchar(32000), | |
| 36 | primary key (mt_id) | |
| 37 | ); | |
| 38 | create index mtkm on APP.methoden (mt_klasse,mt_name); | |
| 39 | ||
| 40 | create table APP.methoden_rechte ( | |
| 41 | role_name varchar(250), | |
| 42 | mt_id int, | |
| 43 | primary key (role_name,mt_id) | |
| 44 | ); | |
