| commit | author | age | ||
| a5d72f | 1 | CREATE TABLE APP.SENDER |
| U | 2 | ( |
| 3 | SENDER_ID INT NOT NULL, | |
| 4 | SENDER_NAME VARCHAR(1024) NOT NULL, | |
| 5 | SENDER_URL VARCHAR(1024), | |
| 6 | SENDER_LOGO VARCHAR(1024), | |
| 7 | PRIMARY KEY (SENDER_ID) | |
| 8 | ); | |
| 9 | create index sname ON APP.sender (sender_name); | |
| 5d0e42 | 10 | |
| U | 11 | create table APP.keytable ( |
| 12 | key_name varchar(80) not null primary key, | |
| 13 | key_next int | |
| 14 | ); | |
| 15 | create index key_name_next ON APP.keytable (key_name,key_next); | |
| 16 | insert into APP.keytable (key_name, key_next) values ('sender_id',1); | |
