SAY --- Installing system tables for EASY ...
/
/* @(#)EASY.ins 10.01.00  1998-01-30
/ *****************************************************
/ Systemtables of the Conversational Component EASY
/ *****************************************************
/
/
INIT SERVERDB
/
IF $RC (SHOW VIEW SYSEASYMASKS) = 0
THEN
/
     DROP VIEW SYSEASYMASKS
/
IF $RC (EXISTS TABLE SYSEASYMASKS) <> 0
THEN
     BEGIN
/
     CREATE TABLE SYSEASYMASKS
       (
        TOWNER         CHAR(18) ASCII KEY DEFAULT USERGROUP,
        TNAME          CHAR(18) ASCII KEY DEFAULT ' ',
        MOWNER         CHAR(18) ASCII KEY DEFAULT USERGROUP,
        MNAME          CHAR(18) ASCII KEY DEFAULT ' ',
        OBJTYPE        CHAR(18) ASCII KEY DEFAULT 'EASYMASK',
        SUBTYPE        CHAR(12) ASCII KEY DEFAULT ' ',
        KEY7_NOT_USED  CHAR(4)  ASCII KEY DEFAULT ' ',
        CREATEDATE     DATE DEFAULT DATE,
        CREATETIME     TIME DEFAULT TIME,
        UPDATEDATE     DATE DEFAULT DATE,
        UPDATETIME     TIME DEFAULT TIME,
        MCODE          CHAR(6)  ASCII,
        MVERSION       FIXED(3),
        MLENGTH        FIXED(18),
        WARNINGLEVEL   FIXED(3),
        WARNINGCOMMENT CHAR(18) ASCII,
        CODE           LONG     BYTE
       )
/
     GRANT SELECT, UPDATE, INSERT, DELETE ON SYSEASYMASKS TO DOMAIN
/
     GRANT SELECT ON SYSEASYMASKS TO PUBLIC
/
     IF $RC (SHOW VIEW SYSEASYDEFMASKS) = 0
     THEN
/
          DROP VIEW SYSEASYDEFMASKS
/
     CREATE VIEW SYSEASYDEFMASKS
     AS SELECT *
        FROM SYSEASYMASKS
        WHERE towner = USERGROUP
     WITH CHECK OPTION
/
     GRANT SELECT, UPDATE, INSERT, DELETE ON SYSEASYDEFMASKS TO PUBLIC
/
     COMMIT WORK
/
     END
/
IF $RC (SHOW VIEW SYSEASYSTOCOMS) = 0
THEN
/
     DROP VIEW SYSEASYSTOCOMS
/
IF $RC (EXISTS TABLE SYSEASYSTOCOMS) <> 0
THEN
     BEGIN
/
     CREATE TABLE SYSEASYSTOCOMS
       (
        AUTHOR         CHAR(18) ASCII KEY DEFAULT USERGROUP,
        COMMAND_NAME   CHAR(18) ASCII KEY DEFAULT ' ',
        TOWNER         CHAR(18) ASCII KEY DEFAULT USERGROUP,
        TNAME          CHAR(18) ASCII KEY DEFAULT ' ',
        OBJTYPE        CHAR(18) ASCII KEY DEFAULT 'EASYCOMMAND',
        SUBTYPE        CHAR(12) ASCII KEY DEFAULT ' ',
        KEY7_NOT_USED  CHAR(4)  ASCII KEY DEFAULT ' ',
        CREATEDATE     DATE DEFAULT DATE,
        CREATETIME     TIME DEFAULT TIME,
        UPDATEDATE     DATE DEFAULT DATE,
        UPDATETIME     TIME DEFAULT TIME,
        CCODE          CHAR(1) ASCII,
        COMMAND        LONG    BYTE
       )
/
     GRANT SELECT, UPDATE, INSERT, DELETE ON SYSEASYSTOCOMS TO DOMAIN
/
     GRANT SELECT ON SYSEASYSTOCOMS TO PUBLIC
/
     IF $RC (SHOW VIEW SYSEASYDEFSTOCOMS) = 0
     THEN
/
          DROP VIEW SYSEASYDEFSTOCOMS
/
     CREATE VIEW SYSEASYDEFSTOCOMS
     AS SELECT *
        FROM SYSEASYSTOCOMS
        WHERE author = USERGROUP
     WITH CHECK OPTION
/
     GRANT SELECT, UPDATE, INSERT, DELETE ON SYSEASYDEFSTOCOMS TO PUBLIC
/
     COMMIT WORK
/
     END
/
END INIT SERVERDB
/
