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