CREATE DATABASE COMPANY;
-- データベーススペースの作成場所は、実行環境に合わせて修正してください。
CREATE DBSPACE MYDBSP_1 ALLOCATE FILE C:\jdbc\COMPANY.dbs ATTRIBUTE SPACE (20M);
CREATE SCHEMA GENERAL;

CREATE TABLE GENERAL.EMPLOYEE (ID INT NOT NULL,
                               NAME CHARACTER(20),
                               PRIMARY KEY(ID));

CREATE TABLE GENERAL.ADDRESSTABLE (
                       ID INT NOT NULL,
                       NAME CHARACTER VARYING(20),
                       ADDRESS CHARACTER VARYING(100),
                       PHONE CHARACTER VARYING(13),
                       PRIMARY KEY(ID));

CREATE DSO DSO01
    FROM GENERAL.EMPLOYEE
    TYPE RANDOM (PAGESIZE1(4),PAGESIZE2(4));
CREATE DSI DSI01
    DSO DSO01
    ALLOCATE PRIME ON MYDBSP_1 SIZE 200K,OVERFLOW ON MYDBSP_1 SIZE 80K;
CREATE DSO DSO02
    FROM GENERAL.ADDRESSTABLE
    TYPE RANDOM (PAGESIZE1(4),PAGESIZE2(4));
CREATE DSI DSI02
    DSO DSO02
    ALLOCATE PRIME ON MYDBSP_1 SIZE 200K,OVERFLOW ON MYDBSP_1 SIZE 80K;

CREATE INDEX GENERAL.EMPLOYEE.TB1IDX KEY(ID) ON MYDBSP_1;
CREATE INDEX GENERAL.ADDRESSTABLE.TB2IDX KEY(ID) ON MYDBSP_1;

GRANT ALL PRIVILEGES ON GENERAL.EMPLOYEE TO PUBLIC;
GRANT ALL PRIVILEGES ON GENERAL.ADDRESSTABLE TO PUBLIC;
GRANT ALL PRIVILEGES ON SCHEMA GENERAL TO PUBLIC;
GRANT ALL PRIVILEGES ON DBSPACE MYDBSP_1 TO PUBLIC;