/*ALIAS>l_data*/

/*SQLStart>706*/
CREATE TABLE SEARCHTUNE (
    SEARCHTUNE_REG INTEGER NOT NULL,
    SEARCHTUNE_USER INTEGER NOT NULL,
    SEARCHTUNE_NUM INTEGER NOT NULL,
    SEARCHTUNE_TITLE VARCHAR(100),
    SEARCHTUNE_BLOB BLOB SUB_TYPE 1 SEGMENT SIZE 80);
/*SQLStop*/

/*SQLStart>707*/
alter table SEARCHTUNE
add constraint PK_SEARCHTUNE
primary key (SEARCHTUNE_REG,SEARCHTUNE_USER,SEARCHTUNE_NUM);
/*SQLStop*/

/*SQLStart>708*/
CREATE INDEX SEARCHTUNE_REG_IDX
ON SEARCHTUNE (SEARCHTUNE_REG,SEARCHTUNE_USER);
/*SQLStop*/

/*SQLStart>709*/
GRANT ALL ON SEARCHTUNE TO PUBLIC;
/*SQLStop*/

/*SQLStart>710*/
delete from system_strings where SYS_ID = 0;
/*SQLStop*/

/*SQLStart>711*/
insert into system_strings (SYS_ID,SYS_STR) values (0,'0012');
/*SQLStop*/
