commit | author | age
|
5d0e42
|
1 |
|
734b13
|
2 |
create table app.sender |
U |
3 |
( |
|
4 |
sender_id int not null, |
|
5 |
sender_name varchar(1024) not null, |
|
6 |
sender_url varchar(1024), |
|
7 |
sender_logo varchar(1024), |
|
8 |
primary key (sender_id) |
|
9 |
); |
|
10 |
create index sname on app.sender (sender_name); |
|
11 |
|
|
12 |
create table app.keytable ( |
5d0e42
|
13 |
key_name varchar(80) not null primary key, |
U |
14 |
key_next int |
|
15 |
); |
734b13
|
16 |
create index key_name_next ON app.keytable (key_name,key_next); |
U |
17 |
insert into app.keytable (key_name, key_next) values ('sender_id',1); |