1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| CREATE TABLE APP.SENDER
| (
| SENDER_ID INT NOT NULL,
| SENDER_NAME VARCHAR(1024) NOT NULL,
| SENDER_URL VARCHAR(1024),
| SENDER_LOGO VARCHAR(1024),
| PRIMARY KEY (SENDER_ID)
| );
| create index sname ON APP.sender (sender_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 ('sender_id',1);
|
|
