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);