| 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 | ); | |
| 20 | ||
| 21 | create table APP.keytable ( | |
| 22 | key_name varchar(80) not null primary key, | |
| 23 | key_next int | |
| 24 | ); | |
| 25 | create index key_name_next ON APP.keytable (key_name,key_next); | |
| 26 | insert into APP.keytable (key_name, key_next) values ('gr_id',1); | |
| 27 | insert into APP.keytable (key_name, key_next) values ('mt_id',1); | |
| 28 | ||
| 29 | create table APP.methoden ( | |
| 30 | mt_id int, | |
| 31 | mt_klasse varchar(32000), | |
| 32 | mt_name varchar(32000), | |
| 33 | primary key (mt_id) | |
| 34 | ); | |
| 35 | create index mtkm on APP.methoden (mt_klasse,mt_name); | |
| 36 | ||
| 37 | create table APP.methoden_rechte ( | |
| 38 | role_name varchar(250), | |
| 39 | mt_id int, | |
| 40 | primary key (role_name,mt_id) | |
| 41 | ); | |
