/* CREATE OR REPLACE PROCEDURE D2OraApplication Version: 1.3 Date : 12.12.2007 (c) IPESOFT 1993, 2009. All rights reserved. Purpose: creation of tablespaces, users and tables needed for D2000 application Usage: SET SERVEROUTPUT ON <- turn on writing lines SET LINE 260 <- set line width SPOOL c:\D2ORAAPP_out.sql <- set output file EXEC D2OraApplication; <- execute this procedure SPOOL OFF <- close output file and continue according to instructions in D2000 help */ AS AppName VARCHAR(20) := 'MyApp'; /*@@@ Name of application */ TempTablespace VARCHAR(20) := 'TEMP'; /*@@@ Always 'TEMP' unless you have modified Oracle database */ DatafilePath VARCHAR(80) := '???'; /*@@@*/ SyscfgStartDatafileSize VARCHAR(10) := '50M'; /*@@@ Initial size of datafile: 50M should be enough */ SyscfgDatafileSizeStep VARCHAR(10) := ''; /*@@@ Increment of datafile (or '' if db default) */ LogFileInSyscfg BOOLEAN := False; /*@@@ Are Logfile tables located in Syscfg tablespace? */ LogfileStartDatafileSize VARCHAR(10) := '100M'; /*@@@ Initial size of datafile: 100M should be enough */ LogfileDatafileSizeStep VARCHAR(10) := '20M'; /*@@@ Increment of datafile (or '' if db default) */ LogfileMaxDatafileSize VARCHAR(10) := '2000M'; /*@@@ Maximum size of datafile (or 'UNLIMITED') */ AppNameU VARCHAR(20) := Upper(AppName); SyscfgTS VARCHAR(30) := AppNameU || '_TS_SYSCFG'; LogfileTS VARCHAR(30) := AppNameU || '_TS_LOGFILE'; PROCEDURE WriteInfoHeader IS FUNCTION B2Txt( B in BOOLEAN) return VARCHAR2 IS begin IF B THEN RETURN 'TRUE'; ELSE RETURN 'FALSE'; END IF; end; BEGIN DBMS_OUTPUT.PUT_LINE('/* ----------------------------------------------- */'); DBMS_OUTPUT.PUT_LINE('/* D2OraApplication v1.2 was run with these parameters '); DBMS_OUTPUT.PUT_LINE(' AppName : ' || AppName ); DBMS_OUTPUT.PUT_LINE(' TempTablespace : ' || TempTablespace); DBMS_OUTPUT.PUT_LINE(' DatafilePath : ' || DatafilePath); DBMS_OUTPUT.PUT_LINE(' SyscfgStartDatafileSize : ' || SyscfgStartDatafileSize); DBMS_OUTPUT.PUT_LINE(' SyscfgDatafileSizeStep : ' || SyscfgDatafileSizeStep); DBMS_OUTPUT.PUT_LINE(' LogFileInSyscfg : ' || B2Txt(LogFileInSyscfg)); DBMS_OUTPUT.PUT_LINE(' LogfileStartDatafileSize : ' || LogfileStartDatafileSize); DBMS_OUTPUT.PUT_LINE(' LogfileDatafileSizeStep : ' || LogfileDatafileSizeStep); DBMS_OUTPUT.PUT_LINE(' LogfileMaxDatafileSize : ' || LogfileMaxDatafileSize); DBMS_OUTPUT.PUT_LINE('*/'); DBMS_OUTPUT.PUT_LINE('/* ----------------------------------------------- */'); END WriteInfoHeader; procedure CreateNewSyscfg is SyscfgUser VARCHAR(30) := AppNameU || '_SYSCFG'; begin DBMS_OUTPUT.PUT_LINE('/* Start of creating syscfg */'); DBMS_OUTPUT.PUT_LINE('CREATE TABLESPACE "' || SyscfgTS || '" LOGGING DATAFILE'); DBMS_OUTPUT.PUT_LINE(' ''' || DatafilePath || SyscfgTS || '.ORA'' SIZE ' || SyscfgStartDatafileSize || ' AUTOEXTEND ON '); if SyscfgDatafileSizeStep <> '' then DBMS_OUTPUT.PUT_LINE(' NEXT ' || SyscfgDatafileSizeStep); end if; DBMS_OUTPUT.PUT_LINE(' EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('CREATE USER "' || SyscfgUser || '" PROFILE "DEFAULT"'); DBMS_OUTPUT.PUT_LINE('IDENTIFIED BY "swx" DEFAULT TABLESPACE "' || SyscfgTS || '"'); DBMS_OUTPUT.PUT_LINE('TEMPORARY TABLESPACE "' || TempTablespace ||'" ACCOUNT UNLOCK;'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('GRANT UNLIMITED TABLESPACE TO "' || SyscfgUser || '";'); DBMS_OUTPUT.PUT_LINE('GRANT "CONNECT" TO "' || SyscfgUser || '";'); DBMS_OUTPUT.PUT_LINE('GRANT "DBA" TO "' || SyscfgUser || '";'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('/* End of creating syscfg */'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('/* Start of creating objects in syscfg */'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LOGDEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LOGDEF ('); DBMS_OUTPUT.PUT_LINE(' EVENT_TYPE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' ACTIVE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HIST_TIME INTEGER,'); DBMS_OUTPUT.PUT_LINE(' USE_DEVICE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEVICE CHAR(201)'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: NAME_RULES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.NAME_RULES ('); DBMS_OUTPUT.PUT_LINE(' TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' PREFIX CHAR(13),'); DBMS_OUTPUT.PUT_LINE(' SUFFIX CHAR(13)'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: OBJLIST */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.OBJLIST ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' NAME CHAR(65) not null,'); DBMS_OUTPUT.PUT_LINE(' DESCRIPT CHAR(129),'); DBMS_OUTPUT.PUT_LINE(' TYP SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PARENT INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' VALUE_TYPE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' REFNR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' MODIFY_TIME TIMESTAMP,'); DBMS_OUTPUT.PUT_LINE(' TEXT_PALETTE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TECH_UNIT CHAR(13),'); DBMS_OUTPUT.PUT_LINE(' VHL FLOAT,'); DBMS_OUTPUT.PUT_LINE(' HL FLOAT,'); DBMS_OUTPUT.PUT_LINE(' LL FLOAT,'); DBMS_OUTPUT.PUT_LINE(' VLL FLOAT,'); DBMS_OUTPUT.PUT_LINE(' VHL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' HL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' LL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' VLL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PASREFNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' READ_ONLY SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HYSTEREZIA FLOAT,'); DBMS_OUTPUT.PUT_LINE(' VHL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VHL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VLL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VLL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TRANS_PAL_IDX INTEGER,'); DBMS_OUTPUT.PUT_LINE(' HIDDEN_OBJECT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint PK_OBJLIST primary key (ID)'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: PAL_STYLE */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.PAL_STYLE ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PALETTE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' STATE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' PEN_COLOR1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PEN_COLOR2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BRUSH_COLOR1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BRUSH_COLOR2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TEXT_COLOR1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TEXT_COLOR2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PODKLAD_COLOR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DISPL3D SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VALUE_STATE CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_PAL_STYLE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: PICTURES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.PICTURES ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DX SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' DY SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' BACKCOLOR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAPFILE CHAR(21),'); DBMS_OUTPUT.PUT_LINE(' BINDATA BLOB,'); DBMS_OUTPUT.PUT_LINE(' STYLENR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PALETTENR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DYNAMICNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DISPLAYNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CONTROLNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BITMAPSNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BITMAP_STYLE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' BMPPATTERN INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMPLOGO INTEGER,'); DBMS_OUTPUT.PUT_LINE(' POSLOGO SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' POSTYPE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' POSAT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SKUPINA SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TRANSFORM SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ODKAZ1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' ODKAZ2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' ODKAZ3 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMPPALNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' EXTPALNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMPIDNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DIALOG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MODAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' APPL_MODAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HOME_INST_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' NEXT_INST_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PREV_INST_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' UNVISIBLE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LOG_CLOSE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_PICTURES unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_PICTURES foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: POINTS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.POINTS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' TECHCONVTYPE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' TECHCONVPAR1 FLOAT,'); DBMS_OUTPUT.PUT_LINE(' TECHCONVPAR2 FLOAT,'); DBMS_OUTPUT.PUT_LINE(' TECHCONVPAR3 FLOAT,'); DBMS_OUTPUT.PUT_LINE(' TECHCONVPAR4 FLOAT,'); DBMS_OUTPUT.PUT_LINE(' FILTERTYPE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' CTRLOBJECT INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MANUALVALUE CHAR(20),'); DBMS_OUTPUT.PUT_LINE(' DEFAULT_CTRLOBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DEFAULT_VALUE CHAR(20),'); DBMS_OUTPUT.PUT_LINE(' DEAD_BAND FLOAT,'); DBMS_OUTPUT.PUT_LINE(' POINT_ADDRESS1 CHAR(50),'); DBMS_OUTPUT.PUT_LINE(' POINT_ADDRESS2 CHAR(50),'); DBMS_OUTPUT.PUT_LINE(' K FLOAT,'); DBMS_OUTPUT.PUT_LINE(' MIN FLOAT,'); DBMS_OUTPUT.PUT_LINE(' MAX FLOAT,'); DBMS_OUTPUT.PUT_LINE(' MANUAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LOG_POLARITY SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEF_USE_DEF SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEFAULT_MANUAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CHANGE_MODE_ENABLE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEF_CHANGE_MODE_ENABLE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEF_ON_ERR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEF_FROM_HI SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' UPD_ON_TIME_CHANGE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' KMIT_TIME INTEGER,'); DBMS_OUTPUT.PUT_LINE(' KMIT_MAXNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' ZERO_DEADBAND FLOAT,'); DBMS_OUTPUT.PUT_LINE(' ZERO_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' COMMAND_OUTPUT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VALUE_DELAY INTEGER,'); DBMS_OUTPUT.PUT_LINE(' IS_VALUE_DELAY INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SCH_USE_DEF SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SCH_DEFVAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SCH_USE_MAN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SCH_MANVAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' WRITE_REQUEST_TIMEOUT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' USE_LIM_FROM_DEV SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_POINTS unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_POINTS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: PROCES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.PROCES ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PATH CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' INPUT CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' TITLE CHAR(81),'); DBMS_OUTPUT.PUT_LINE(' SLEEP SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PRIORITY SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' WRKDIR CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' AUTOSTART SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' PM SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_PROCES unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_PROCES foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: PROC_ALARM */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.PROC_ALARM ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ALARM INTEGER,'); DBMS_OUTPUT.PUT_LINE(' MONITOR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' KVIT_REQ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CRITICAL INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SILENT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TIMEOUT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SIGNAL_MONITOR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SIGNAL_ALARM SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SIGNAL_CRITICAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' "ROW" SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_PROC_ALARM foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: REF_TABLE */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.REF_TABLE ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' REFID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ACTIVE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_REF_TABLE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Index: UNIK */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create unique index ' || SyscfgUser || '.UNIK on ' || SyscfgUser || '.REF_TABLE ('); DBMS_OUTPUT.PUT_LINE(' ID ASC,'); DBMS_OUTPUT.PUT_LINE(' REFID ASC'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Index: REFIDX */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create index ' || SyscfgUser || '.REFIDX on ' || SyscfgUser || '.REF_TABLE ('); DBMS_OUTPUT.PUT_LINE(' REFID ASC'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: REM_OBJ */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.REM_OBJ ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' CTRLOBJECT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' MANUALVALUE CHAR(20),'); DBMS_OUTPUT.PUT_LINE(' REMOTE_NAME CHAR(65) not null,'); DBMS_OUTPUT.PUT_LINE(' MANUAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MANUAL_ENABLE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_REM_OBJ unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_REM_OBJ foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: RESOURCE_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.RESOURCE_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ID_RESOURCE INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' Single_Member SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_RESOURCE_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SCRIPT_BODY */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.SCRIPT_BODY ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' REF_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' LOC_VAR_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SCRIPT BLOB,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_SCRIPT_BODY foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SCRIPT_LOCVAR */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.SCRIPT_LOCVAR ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' NAME CHAR(65),'); DBMS_OUTPUT.PUT_LINE(' LOCVARID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' VAL_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LOC_VAR_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' REF_VAL INTEGER,'); DBMS_OUTPUT.PUT_LINE(' STRUCT_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DESCRIPT CHAR(129),'); DBMS_OUTPUT.PUT_LINE(' FOR_OBJECT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' FILTER SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' STTEXT_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TXTPAL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_SCRIPT_LOCVAR foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SCRIPT_REF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.SCRIPT_REF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' REFID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_SCRIPT_REF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: STATIONS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.STATIONS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' LINK_PARAM SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PROTOKOL SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' SOFT_ERR_TIME SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' ERR_DELAY SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' CTRL_OBJECT INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PERIODE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OFFSET INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SYNC_PER INTEGER,'); DBMS_OUTPUT.PUT_LINE(' POOL_PRIORITY SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' STA_ADDRESS CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' PROT_INIT CHAR(200),'); DBMS_OUTPUT.PUT_LINE(' MANUAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DISABLED SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SIMULATION SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' POOLING_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_LOCAL_TIME SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MonotonicStTime SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' UTC_Offset INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_STATIONS unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_STATIONS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: STRUCT_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.STRUCT_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ITEM_NR INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' NAME CHAR(33),'); DBMS_OUTPUT.PUT_LINE(' DESCRIPT CHAR(51),'); DBMS_OUTPUT.PUT_LINE(' TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_START_VALUE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_LIMITS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_PROC_ALARM SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' STATUS_TEXT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TRANS_PAL_IDX INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_STRUCT_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: STYLEDEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.STYLEDEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PHYS_NAME CHAR(41) not null,'); DBMS_OUTPUT.PUT_LINE(' X_SIZE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' Y_SIZE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' BOLD SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ITALIC SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' UNDERLINE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' STRIKEOUT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CHARSET SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_STYLEDEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SWITCH */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.SWITCH ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' SW_NOTIFY_OBJ INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ABLOCK_OBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BBLOCK_OBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TIME_OUT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CMD_ON_OBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CMD_OFF_OBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CMD_BACKOFF_OBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CMD_ON SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CMD_OFF SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CMD_BACKOFF SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' FLAGS INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DEFAULT_ENABLE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEFAULT_ACTIVE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEFAULT_VALUE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ABLOCK_INVERT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' BBLOCK_INVERT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_SWITCH unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_SWITCH foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SYSTEM_TEXT */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.SYSTEM_TEXT ('); DBMS_OUTPUT.PUT_LINE(' CISLO INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' SYS_TEXT CHAR(21)'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SYS_COLORS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.SYS_COLORS ('); DBMS_OUTPUT.PUT_LINE(' BINDATA BLOB'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SYS_VAR */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.SYS_VAR ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PERIOD INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' OFFSET INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_SYS_VAR unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_SYS_VAR foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TABVER */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TABVER ('); DBMS_OUTPUT.PUT_LINE(' NAME CHAR(20) not null,'); DBMS_OUTPUT.PUT_LINE(' VERSION SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PREV_VER SMALLINT'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Index: QST456756 */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create unique index ' || SyscfgUser || '.QST456756 on ' || SyscfgUser || '.TABVER ('); DBMS_OUTPUT.PUT_LINE(' NAME ASC'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TC_JOBS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TC_JOBS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DAY_ID SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' CAS INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' HODNOTA FLOAT not null,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_TC_JOBS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TEXTS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TEXTS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' STATUS SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' TEXT CHAR(21),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_TEXTS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TEXTS_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TEXTS_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' BASE_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' STEP_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_TEXTS_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TIME_CHAN */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TIME_CHAN ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' KALENDAR_ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_TIME_CHA unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_TIME_CHAN foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TOPOL_LINE */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TOPOL_LINE ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' SOURCE_ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DEST_ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_TOPOL_LINE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TOPOL_NODE */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TOPOL_NODE ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' NODE_TYPE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' OUT_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CONTROL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' IN_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_TOPOL_NODE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TRANS_MASKA */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.TRANS_MASKA ('); DBMS_OUTPUT.PUT_LINE(' VALTYP SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' "ROW" INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MASKA CHAR(33)'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: USERS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.USERS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' HESLO RAW(21),'); DBMS_OUTPUT.PUT_LINE(' COMPOSITION CHAR(32),'); DBMS_OUTPUT.PUT_LINE(' TIMEOUT SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' EXPIR_TIME TIMESTAMP,'); DBMS_OUTPUT.PUT_LINE(' PASS_EXPIR_TIME TIMESTAMP,'); DBMS_OUTPUT.PUT_LINE(' SPECIAL INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PASS_VALID_TIME SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' GRACE_LOG_NR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CPS_1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_3 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_4 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_5 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_6 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_7 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_8 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_9 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' CPS_10 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' COMPID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' ADMIN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USER_ENABLED SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MENU_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_USERS unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_USERS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: USER_GROUPS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.USER_GROUPS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ID_RESOURCE INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' RES_ACCESS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_USER_GROUPS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Index: IDRES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create index ' || SyscfgUser || '.IDRES on ' || SyscfgUser || '.USER_GROUPS ('); DBMS_OUTPUT.PUT_LINE(' ID_RESOURCE ASC'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: USER_VAR */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.USER_VAR ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MANUAL_VAL CHAR(20),'); DBMS_OUTPUT.PUT_LINE(' TEXT_VAR BLOB,'); DBMS_OUTPUT.PUT_LINE(' MANUAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MONITOR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SAVE_VALUE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' FLAGS INTEGER,'); DBMS_OUTPUT.PUT_LINE(' VALUE_TIME TIMESTAMP,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_USER_VAR unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_USER_VAR foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LINE_MODE */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LINE_MODE ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' LMODE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' BAUDRATE INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' NRBIT SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' NRSTOPBIT SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' WRITE_TIMEOUT SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' READ_TIMEOUT SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' SEND_BALAST SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' CHECK_ERROR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CONST_OPEN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HAND_SHAKING SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' WAIT_TX_EMPTY SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HW_HANDSHAKING SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' RTS_ON SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DTR_ON SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HAND_INVERT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' PARITY SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_LINE_MODE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: ALARMS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.ALARMS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ALARM_COND INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' NORMAL_COND INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ALARM_DELAY INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MASKA SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PRIORITY SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PICTURE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SCREEN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SEGMENT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ALARM_TRIG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' NORMAL_TRIG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' INVERT_A_TRIG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' INVERT_N_TRIG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' BLOCK SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' KVIT_REQ SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SHOW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SIGNAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ALARM_COND_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ALARM_COND_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' NORMAL_COND_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' NORMAL_COND_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_ALARMS unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_ALARMS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LOG_GROUP */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LOG_GROUP ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MEMBER_ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_LOG_GROUP foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LOG_GROUP_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LOG_GROUP_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PARENT_AL_GR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' AL_GROUP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_LOG_GROUP_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LPALETTES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LPALETTES ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PALETTEID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_LPALETTES foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LSTYLES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LSTYLES ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' STYLEID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_LSTYLE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: ARCHIV_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.ARCHIV_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' SOURCE_OBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' FUNCTION SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEEP_TIME INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PERIOD INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OFFSET INTEGER,'); DBMS_OUTPUT.PUT_LINE(' FILTER_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' HIGH_LIMIT FLOAT,'); DBMS_OUTPUT.PUT_LINE(' HIGH_FILTER FLOAT,'); DBMS_OUTPUT.PUT_LINE(' LOW_LIMIT FLOAT,'); DBMS_OUTPUT.PUT_LINE(' LOW_FILTER FLOAT,'); DBMS_OUTPUT.PUT_LINE(' START_TRIG INTEGER,'); DBMS_OUTPUT.PUT_LINE(' STOP_TRIG INTEGER,'); DBMS_OUTPUT.PUT_LINE(' K_INT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VALID_PERC SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' START_TRIG_COND SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' STOP_TRIG_COND SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' INVERT_START_TRIG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' INVERT_STOP_TRIG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ARCHIV SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' WRITE_METHOD SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' WRITE_DATA SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ACTIVE_OBJ SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SAVE_DATA SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' START_INT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SOURCE_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SOURCE_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' REF_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' STATISTIC_INTERVAL INTEGER,'); DBMS_OUTPUT.PUT_LINE(' MonotonicTime SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' UTC_Offset INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_ARCHIV_D unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_ARCHIV_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: ARRAYS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.ARRAYS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ARC_OBJ INTEGER,'); DBMS_OUTPUT.PUT_LINE(' NR_VAL INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' TM_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' STEP_VALUE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' STEP_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TM_BEGIN_POS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_ARRAYS unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_ARRAYS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: AXIS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.AXIS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DIGITLEVELS SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' MINVAL FLOAT not null,'); DBMS_OUTPUT.PUT_LINE(' MAXVAL FLOAT not null,'); DBMS_OUTPUT.PUT_LINE(' COLOR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' NR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LINEMINVAL FLOAT,'); DBMS_OUTPUT.PUT_LINE(' LINEMAXVAL FLOAT,'); DBMS_OUTPUT.PUT_LINE(' TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DYNAMIC SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_AXIS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: BITMAPS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.BITMAPS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' STATUS SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAP1 INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAP2 INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAP3 INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAP4 INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAP5 INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAP6 INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BITMAP7 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BITMAP8 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BITMAP9 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BITMAP10 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_BITMAPS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: BMPPALPICT */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.BMPPALPICT ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BMPPALID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_BMPPALPICT foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: BMPPAL_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.BMPPAL_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PALETTE INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' VALUE_STATE CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' STATE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' BMP_COLOR1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP_COLOR2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PODKLAD_COLOR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP_STATE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' BMP1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP3 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP4 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP5 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP6 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP7 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP8 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP9 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BMP10 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_BMPPAL_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: BMPPICT */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.BMPPICT ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BMPID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_BMPPICT foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: CALC */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.CALC ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PERIOD INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OFFSET INTEGER,'); DBMS_OUTPUT.PUT_LINE(' START_VAL CHAR(20),'); DBMS_OUTPUT.PUT_LINE(' STATMENT BLOB not null,'); DBMS_OUTPUT.PUT_LINE(' RECAL_REQ SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TRIGGER_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' TRIGGER_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TRIGGER_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TRIGGER_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TRIGGER_INV SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MonotonicTime SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' UTC_Offset INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_CALC unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_CALC foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: COMPOSITIONS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.COMPOSITIONS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MAX_X SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MAX_Y SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CLOSETYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MINIM SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SCREEN_DX INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SCREEN_DY INTEGER,'); DBMS_OUTPUT.PUT_LINE(' HOME INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PREV INTEGER,'); DBMS_OUTPUT.PUT_LINE(' NEXT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' HOME_INST_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' NEXT_INST_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PREV_INST_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_COMPOSIT unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_COMPOSITIONS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: CONTROL */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.CONTROL ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' OBJECTID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' TYPE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' STRING CHAR(20),'); DBMS_OUTPUT.PUT_LINE(' FNCT_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' REAKCIANA SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CTRL_DLG INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJECT_INDEX INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJECT_ITEM INTEGER,'); DBMS_OUTPUT.PUT_LINE(' INSTANCE_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJ_IS_LOCVAR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' OBJIDX_IS_LOCVAR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' INST_IS_LOCVAR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_CONTROL foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: CPS_ITEM */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.CPS_ITEM ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ITEM_ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' X SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' Y SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' DX SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' DY SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' NR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' SX INTEGER,'); DBMS_OUTPUT.PUT_LINE(' SY INTEGER,'); DBMS_OUTPUT.PUT_LINE(' WIN_STATE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DIALOG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ITEM_INST_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_CPS_ITEM foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: D2RECORD */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.D2RECORD ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MANUAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MONITOR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SAVE_VALUE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DIMENSION INTEGER,'); DBMS_OUTPUT.PUT_LINE(' STRUCT_TYP_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_D2RECORD foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: D2RECORD_ITEM */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.D2RECORD_ITEM ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' "ROW" SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_START_VALUE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_LIMITS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_PROC_ALARM SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MANUAL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MONITOR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SAVE_VALUE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' USE_STATUS_TEXT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' STATUS_TEXT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_D2RECORD_ITEM foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: D2RECORD_VALUE */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.D2RECORD_VALUE ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' D2REC_ROW INTEGER,'); DBMS_OUTPUT.PUT_LINE(' D2REC_COL INTEGER,'); DBMS_OUTPUT.PUT_LINE(' START_VALUE CHAR(201),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_D2RECORD_VALUE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Index: IdRowCol */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create unique index ' || SyscfgUser || '.IdRowCol on ' || SyscfgUser || '.D2RECORD_VALUE ('); DBMS_OUTPUT.PUT_LINE(' ID ASC,'); DBMS_OUTPUT.PUT_LINE(' D2REC_ROW ASC,'); DBMS_OUTPUT.PUT_LINE(' D2REC_COL ASC'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DAY_TYPES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DAY_TYPES ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DAY_ID SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_DAY_TYPE unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DAY_TYPES foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DB_CONNECT_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DB_CONNECT_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DB_USERID CHAR(33),'); DBMS_OUTPUT.PUT_LINE(' DB_PASSWORD CHAR(33),'); DBMS_OUTPUT.PUT_LINE(' DB_DSN CHAR(33),'); DBMS_OUTPUT.PUT_LINE(' MonotonicTime SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' UTC_Offset INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DB_CONNECT_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DB_TABLE_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DB_TABLE_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DB_ACCESS SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' DB_KEY INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DB_TABLE CHAR(33) not null,'); DBMS_OUTPUT.PUT_LINE(' STRUCT_TYP_ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DB_DEEP_COL INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DB_DEEP_TIME INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DB_TABLE_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DIATREND */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DIATREND ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MAXTIME INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' SHIFTTIME INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' LEFT_AXIS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' RIGHT_AXIS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' C_BACK SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' C_GRAPHBACK SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' C_XAXIS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' C_XDATE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' GRID SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' POINT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DESCR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' COMP_YAXIS SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ACTIVE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_DIATREND unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DIATREND foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DISPLAY */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DISPLAY ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' OBJECTID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' OBJECT_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJECT_FNCT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJECT_INDEX INTEGER,'); DBMS_OUTPUT.PUT_LINE(' REDRAW_MODE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' COLOR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJECT_ITEM INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJ_IS_LOCVAR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' OBJIDX_IS_LOCVAR SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DISPLAY foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DISPSPEC */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DISPSPEC ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' BINDATA BLOB,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DISPSPEC foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DTLINE */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DTLINE ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' NR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' MINLIMIT FLOAT not null,'); DBMS_OUTPUT.PUT_LINE(' MAXLIMIT FLOAT not null,'); DBMS_OUTPUT.PUT_LINE(' COLOR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' DIGITLEVEL SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' OBJECTID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' AXISNO SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' GRAPH_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' FUNCTION SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' COLOR_LOW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' COLOR_HIGH SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LIMIT_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' PERIODE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' LINE_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' THICK SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' OBJECTROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' OBJECTCOL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VLOW_LIMIT FLOAT,'); DBMS_OUTPUT.PUT_LINE(' VHIGH_LIMIT FLOAT,'); DBMS_OUTPUT.PUT_LINE(' COLOR_VLOW INTEGER,'); DBMS_OUTPUT.PUT_LINE(' COLOR_VHIGH INTEGER,'); DBMS_OUTPUT.PUT_LINE(' STRIP_DATA RAW(20),'); DBMS_OUTPUT.PUT_LINE(' PATTERN INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BASELINE_REF SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DTLINE foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: DYNAMICDISP */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.DYNAMICDISP ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' MINVAL FLOAT not null,'); DBMS_OUTPUT.PUT_LINE(' MAXVAL FLOAT not null,'); DBMS_OUTPUT.PUT_LINE(' DIRECTION SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PAINTONLYDYN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_DYNAMICDISP foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: EVENTS */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.EVENTS ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' START_TRIGGER INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PRIORITY SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ERROR_ID SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' TRIG_COND SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' INVERT_TRIG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' EVENT_BODY BLOB,'); DBMS_OUTPUT.PUT_LINE(' START_TRIGGER_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' START_TRIGGER_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' QUEUE_START_RQ SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' EVENT_HAVE_VALUE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CRUMBLE_CHANGE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' SERVER_EVENT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_EVENTS unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_EVENTS foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: EXTPALPICT */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.EXTPALPICT ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' GROBJECTNR INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' EXTPALID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_EXTPALPICT foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: EXTPAL_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.EXTPAL_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' PALETTE INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' VALUE_STATE CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' OBJ_STATE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' PEN_COLOR1 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' PEN_COLOR2 INTEGER,'); DBMS_OUTPUT.PUT_LINE(' LINE_WIDTH INTEGER,'); DBMS_OUTPUT.PUT_LINE(' OBJECT SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_EXTPAL_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: EXT_FNCT */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.EXT_FNCT ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' FULL_PATH CHAR(81),'); DBMS_OUTPUT.PUT_LINE(' FUNC_NAME CHAR(65),'); DBMS_OUTPUT.PUT_LINE(' TYPE_SPEC CHAR(32),'); DBMS_OUTPUT.PUT_LINE(' FUNC_DISABLE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_EXT_FNCT foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: GR_REPORT */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.GR_REPORT ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' REPORT_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' BINDATA BLOB,'); DBMS_OUTPUT.PUT_LINE(' PARAMS_OPEN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DEFAULT_DLG SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' ACTIVE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' CR_PASSWD CHAR(32),'); DBMS_OUTPUT.PUT_LINE(' CR_LOGIN_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_GR_REPORT foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: HI_MENU */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.HI_MENU ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' MENU_TEXT CHAR(33),'); DBMS_OUTPUT.PUT_LINE(' MENU_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' MENU_IDX INTEGER,'); DBMS_OUTPUT.PUT_LINE(' MENU_PARENT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' MENU_OBJECT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' INSTANCE_NR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' constraint IDX_HI_MENU foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: KALENDAR */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.KALENDAR ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' ROK SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' JAN_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' FEB_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' MAR_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' APR_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' MAJ_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JUN_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JUL_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' AUG_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' SEP_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' OKT_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' NOV_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' DEC_C CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JAN_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' FEB_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' MAR_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' APR_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' MAJ_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JUN_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JUL_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' AUG_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' SEP_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' OKT_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' NOV_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' DEC_N CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JAN_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' FEB_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' MAR_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' APR_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' MAJ_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JUN_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' JUL_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' AUG_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' SEP_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' OKT_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' NOV_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' DEC_P CHAR(31) not null,'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_KALENDAR unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_KALENDAR foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LIMITS_DEF */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LIMITS_DEF ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' "ROW" INTEGER,'); DBMS_OUTPUT.PUT_LINE(' COL INTEGER,'); DBMS_OUTPUT.PUT_LINE(' VLL_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VLL_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' VLL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' VLL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VLL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VLL_COLUMN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LL_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LL_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' LL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' LL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' LL_COLUMN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HL_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HL_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' HL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' HL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HL_COLUMN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VHL_TYP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VHL_VALUE FLOAT,'); DBMS_OUTPUT.PUT_LINE(' VHL_ID INTEGER,'); DBMS_OUTPUT.PUT_LINE(' VHL_ROW SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VHL_COL SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' VHL_COLUMN SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' HYSTEREZIA FLOAT,'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_LIMITS_DEF foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: LINES */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || SyscfgUser || '.LINES ('); DBMS_OUTPUT.PUT_LINE(' ID INTEGER not null,'); DBMS_OUTPUT.PUT_LINE(' DEVICE CHAR(13),'); DBMS_OUTPUT.PUT_LINE(' TYPE SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' TRACE_LEVEL SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' RQ_DELAY SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PRIORITY SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' RUN_PATH CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' WORK_PATH CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' PARAMS CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' PRIMARY_HOST CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' PRIMARY_PORT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' BACKUP_HOST CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' BACKUP_PORT INTEGER,'); DBMS_OUTPUT.PUT_LINE(' USE_BACKUP SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DDE_SERVICE CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' INPUT_FILE CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' ARCHIVE_DIR CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' OPC_SERVER CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' OPC_SRV_TYPE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' DH485_NODE_ADR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DH485_MAXNODE_ADR INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DH485_BAUDRATE INTEGER,'); DBMS_OUTPUT.PUT_LINE(' DH485_MAXPACKETS INTEGER,'); DBMS_OUTPUT.PUT_LINE(' IMPERSONATE SMALLINT,'); DBMS_OUTPUT.PUT_LINE(' IMP_NAME CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' IMP_PSWD CHAR(80),'); DBMS_OUTPUT.PUT_LINE(' constraint AK_KEY_1_LINES unique (ID),'); DBMS_OUTPUT.PUT_LINE(' constraint IDF_LINES foreign key (ID)'); DBMS_OUTPUT.PUT_LINE(' references ' || SyscfgUser || '.OBJLIST (ID)'); DBMS_OUTPUT.PUT_LINE(' on delete cascade'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: SHOW_MASK */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('CREATE TABLE ' || SyscfgUser || '.SHOW_MASK (ID INTEGER NOT NULL, MASKA CHAR(201),'); DBMS_OUTPUT.PUT_LINE('CONSTRAINT IDX_SHOW_MASK FOREIGN KEY (ID) REFERENCES ' || SyscfgUser || '.OBJLIST(ID) ON DELETE CASCADE)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''ALARMS'',4,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''AXIS'',4,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''BITMAPS'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''CALC'',5,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''CONTROL'',8,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DISPLAY'',6,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DTLINE'',8,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DYNAMICDISP'',3,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LINES'',9,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LINE_MODE'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''OBJLIST'',17,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''PALETTES'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''PICTURES'',8,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''POINTS'',9,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''PROCES'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''REF_TABLE'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''STATIONS'',5,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''STYLEDEF'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''STYLES'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TEXTS'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DIATREND'',4,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''USERS'',5,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SYS_VAR'',4,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''USER_VAR'',4,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LOGDEF'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TABVER'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''COMPOSITIONS'',4,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''KALENDAR'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DAY_TYPES'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TC_JOBS'',3,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''CPS_ITEM'',5,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LOGFILE'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''ARCH_TABS'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''CMD_FILE'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''REM_OBJ'',3,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''ARCHIV_DEF'',8,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LPALETTES'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LSTYLES'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''REORG_CFG'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''USER_GROUPS'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DISPSPEC'',3,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''RESOURCE_DEF'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''PAL_STYLE'',3,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''EVENTS'',8,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''ACTIONS'',1,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DATABASE'',9,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''ARRAYS'',2,1)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TIME_CHAN'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SYSTEM_TEXT'',1,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''PROC_ALARM'',4,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SWITCH'',4,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''BMPPAL_DEF'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''EXTPAL_DEF'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''NAME_RULES'',3,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''BMPPICT'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''BMPPALPICT'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''EXTPALPICT'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TOPOL_NODE'',3,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TOPOL_LINE'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LIMITS_DEF'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TEXTS_DEF'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''STRUCT_DEF'',5,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DB_STRUCT_DEF'',3,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''D2RECORD'',3,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''D2RECORD_ITEM'',3,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''D2RECORD_VALUE'',5,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''GR_REPORT'',5,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''TRANS_MASKA'',1,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SCRIPT_BODY'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SCRIPT_REF'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SCRIPT_LOCVAR'',9,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LOG_GROUP'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''LOG_GROUP_DEF'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''EXT_FNCT'',4,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SYS_COLORS'',1,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DB_CONNECT_DEF'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''DB_TABLE_DEF'',1,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''HI_MENU'',2,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.TABVER ("NAME" ,"VERSION" ,"PREV_VER") VALUES (''SHOW_MASK'',1,0)'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (1,''SYSTEM'',''JADRO SYSTEMU'',0,0,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (2,''SUPERSYSTEM'',''SUPER JADRO'',0,0,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (3,''PICTURES'',''Zoznam obrazkov'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (4,''TRENDS'',''Zoznam trendov'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (5,''DIAGRAMS'',''Zoznam diagramov'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (6,''USERS'',''Zoznam uzivatelov'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (7,''REPORTS'',''Zoznam reportov'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (8,''SYSTEM_VAR'',''Systemove premenne'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (9,''USER_VAR'',''Uzivatelske premenne'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (10,''BITMAPS'',''Zoznam bitovych map'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (11,''STYLES'',''Zoznam typov pisma'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (12,''ORPHANAGE'',''Sirotinec'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (13,''ActAlarm'',''Indikacia aktivity alarmov'',0,8,1,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (14,''DiskSpace'',''Volne miesto na pracovnom disku'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,''kB'',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (15,''Year'',''Aktualny rok'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (16,''Month'',''Aktualny mesiac'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (17,''Day'',''Aktualny den'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (18,''Hour'',''Aktualna hodina'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (19,''Min'',''Aktualna minuta'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (20,''Sec'',''Aktualna sekunda'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (21,''SysTime'',''Aktualny cas'',22,8,17,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (22,''COMPOSITIONS'',''Zoznam kompozicii'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (23,''WeekDay'',''Den v tyzdni'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (24,''TIME_CHANNELS'',''Zoznam objektov pre casove kanaly'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (25,''Pracovny'',''Pracovny den'',27,24,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (26,''Sobota'',''Sobota'',27,24,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (27,''Nedela'',''Nedela'',27,24,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (28,''SELF.CLC'',''Proces vypoctov'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (29,''SELF.ARC'',''Proces archivacie'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (30,''SELF.ALA'',''Proces spracovania alarmov'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (31,''SELF.KOM'',''Komunikacny proces'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (32,''SELF.HIP'',''Operatorska konzola'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (33,''ARCH_TAB'',''Zoznam archivnych tabuliek'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (34,''SystemD2000'',''SystemD2000'',12,6,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (35,''SELF.Size'',''Velkost archivu [kB]'',20,29,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (36,''CMD_FILES'',''List of CMD_FILES'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (37,''LogFileSize'',''Velkost zapisnika'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,''kB'',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (38,''RES_GROUP'',''List of resource groups'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (39,''PALETTES'',''List of palettes'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (40,''TXTPALETTES'',''List of text''''s palettes'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (41,''CPU_Load'',''Vytazenost procesora'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,''%'',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (42,''STATUS_TEXT'',''List of status texts'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (55,''SELF.EVH'',''Event handler'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (56,''ArchivChange'',''Zmena hodnot v archive'',22,8,1,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (57,''IN_QUEUE'',''Pocet poziadaviek na Kernel'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (58,''Act_Client'',''Pocet pripojenych klientov'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (59,''ARRAYS'',''List of arrays'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (61,''SysAlarmsNr'',''Pocet aktivnych systemovych alarmov'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (62,''ProcAlarmsNr'',''Pocet aktivnych procesnych alarmov'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (63,''SELF.UPM'',''New Proces'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (67,''SELF.CNF'',''New Proces'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (69,''Signal_Trigger'',''Startovaci triger pre signal'',22,8,1,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (73,''SELF.GRE'',''New Proces'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (74,''STRUCTSDEF'',''Definicie Struktur'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (75,''STRUCTS'',''Strukturovene premenne'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (129,''ActTagNr'',''Aktualny pocet tagov'',22,8,2,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (130,''TimeFromStart'',''Cas od startu D2000'',22,8,18,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (131,''LOGGROUPS'',''Logicke skupiny objektov'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (132,''EXT_FNCT'',''Externe funkcie'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (134,''SELF.SMC'',''New Proces'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (136,''WS_VM.CNF'',''New Proces'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (143,''SELF.DBM'',''Database Manager'',1,1,16,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,'''',1.E38,1.E38,-1.E38,-1.E38,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (144,''HI_MENU'',''Uzivatelske menu'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (145,''SHOW_MASK'',''Zobrazovacie masky'',0,1,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (147,''SM._Start_Systemu'',''Start systemu'',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (148,''SM._Stop_Systemu'',''Stop systemu'',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (149,''SM._LogonSucc'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (150,''SM._LogonFailed'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (151,''SM._Logoff'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (152,''SM._ProcesStart'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (153,''SM._ProcesStop'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (154,''SM._ProcesLog'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (155,''SM._SysAlarm_Alarm'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (156,''SM._SysAlarm_Normal'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (157,''SM._SysAlarm_Kvit'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (158,''SM._SysAlarm_Block'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (159,''SM._SysAlarm_UnBlock'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (160,''SM._ProcAlarm_Kvit'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (161,''SM._ProcAlarm_Block'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (162,''SM._ProcAlarm_UnBlock'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (163,''SM._Operator_SetVal'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (164,''SM._MonitorVal_Limit'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (165,''SM._MonitorVal_Value'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (166,''SM._EventLog'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (167,''SM._ConfigChange'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (168,''SM._PMD'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.OBJLIST(ID,NAME,DESCRIPT,TYP,PARENT,VALUE_TYPE,REFNR,MODIFY_TIME,TEXT_PALETTE,TECH_UNIT,VHL,HL,LL,VLL,VHL_ID,HL_ID,LL_ID,VLL_ID,PASREFNR,READ_ONLY,HYSTEREZIA,'); DBMS_OUTPUT.PUT_LINE('VHL_ROW,VHL_COL,HL_ROW,HL_COL,LL_ROW,LL_COL,VLL_ROW,VLL_COL,TRANS_PAL_IDX,HIDDEN_OBJECT) VALUES (169,''SM._StationChange'','''',52,145,0,0,TO_DATE(''1995-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),0,'''',100,100,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.DAY_TYPES(ID,DAY_ID) VALUES (25,1);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.DAY_TYPES(ID,DAY_ID) VALUES (26,2);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.DAY_TYPES(ID,DAY_ID) VALUES (27,3);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (0,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (1,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (2,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (3,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (4,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (5,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (6,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (7,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (8,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.LOGDEF(EVENT_TYPE,ACTIVE,HIST_TIME,USE_DEVICE,DEVICE) VALUES (9,1,604800,0,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (0,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (1,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (2,''L.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (3,''B.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (4,''M.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (5,''S.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (6,''D.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (7,''P.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (8,''E.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (9,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (10,''T.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (11,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (12,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (13,'''',''.BMP'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (14,'''',''.PAL'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (15,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (16,''Z.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (17,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (18,'''',''.STL'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (19,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (20,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (21,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (22,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (23,''U.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (24,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (25,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (26,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (27,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (28,''X.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (29,'''',''.CMD'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (30,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (31,''H.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (32,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (33,'''','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (34,'''',''_Trigger'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (35,'''',''_AlarmCond'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (36,'''',''_NormCond'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (37,'''',''_StartCond'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (38,'''',''_StopCond'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (39,''SW.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (40,'''',''.BPL'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (41,'''',''.EPL'');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (42,''T.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (43,''TN.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (44,''TL.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (45,''SD.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (46,''SV.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (47,''DB.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (52,''SM.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.NAME_RULES(TYPE,PREFIX,SUFFIX) VALUES (47,''DB.'','''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (28,''CALC.EXE'',''/F60 /X2'',''D/2000 - Kalkulacka'',5,1,'''',1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (31,''KOM.EXE'',''/F60 /X2'',''D/2000 - Komunikacia'',5,2,'''',1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (73,'''','''','''',1,1,'''',0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (32,''HI.EXE'',''/F60'',''D/2000 - HI'',10,1,'''',0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (30,''ALARM.EXE'',''/F60 /X2'',''D/2000 - Alarm'',5,1,'''',1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (55,''EVENT.EXE'',''/F60 /X2'',''D/2000 - Event'',5,1,'''',1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (63,'''','''','''',1,1,'''',0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (67,'''','''','''',1,1,'''',0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (29,''ARCHIV.EXE'',''/F60 /X2'',''D/2000 - Archiv'',5,1,'''',1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (134,'''','''','''',1,1,'''',0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (136,'''','''','''',1,1,'''',0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.PROCES(ID,PATH,INPUT,TITLE,SLEEP, PRIORITY,WRKDIR,AUTOSTART,PM) VALUES (143,''dbmanager.exe'',''/X2 /F60'',''D2000 - DBManager'',10,0,'''',0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (147,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (148,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (149,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (150,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (151,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (152,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (153,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (154,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (155,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (156,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (157,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (158,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (159,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (160,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (161,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (162,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (163,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (164,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (165,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (166,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (167,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (168,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SHOW_MASK(ID,MASKA) VALUES (169,'''');'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (14,30,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (15,86400,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (16,86400,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (17,86400,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (18,3600,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (19,60,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (20,1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (21,1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (23,86400,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (37,900,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (41,1,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (56,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (57,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (58,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (61,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (62,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (69,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (129,0,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.SYS_VAR(ID,PERIOD,OFFSET) VALUES (130,10,0);'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || SyscfgUser || '.USERS(ID,HESLO,COMPOSITION,TIMEOUT,EXPIR_TIME,PASS_EXPIR_TIME,SPECIAL,PASS_VALID_TIME,GRACE_LOG_NR,'); DBMS_OUTPUT.PUT_LINE('CPS_1,CPS_2,CPS_3,CPS_4,CPS_5,CPS_6,CPS_7,CPS_8,CPS_9,CPS_10,'); DBMS_OUTPUT.PUT_LINE('COMPID,ADMIN,USER_ENABLED,MENU_ID) VALUES ('); DBMS_OUTPUT.PUT_LINE('34,''01ad593110e3c58ede3e00627496b8dafc1e406284'',NULL,0,TO_DATE(''1972-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),'); DBMS_OUTPUT.PUT_LINE('TO_DATE(''1972-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),47,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0);'); DBMS_OUTPUT.PUT_LINE('COMMIT;'); DBMS_OUTPUT.PUT_LINE('/* End of creating objects in syscfg */'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE(chr(0)); end CreateNewSyscfg; procedure CreateNewLogfile is LogfileUser VARCHAR(30) := AppNameU || '_LOGFILE'; begin if not LogFileInSyscfg then DBMS_OUTPUT.PUT_LINE('/* Start of creating logfile */'); DBMS_OUTPUT.PUT_LINE('CREATE TABLESPACE "' || LogfileTS || '" LOGGING DATAFILE'); DBMS_OUTPUT.PUT_LINE(' ''' || DatafilePath || LogfileTS || '.ORA'' SIZE ' || LogfileStartDatafileSize || ' AUTOEXTEND ON '); if LogfileDatafileSizeStep <> '' then DBMS_OUTPUT.PUT_LINE(' NEXT ' || LogfileDatafileSizeStep); end if; DBMS_OUTPUT.PUT(' MAXSIZE ' || LogfileMaxDatafileSize); DBMS_OUTPUT.PUT_LINE(' EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;'); DBMS_OUTPUT.PUT_LINE(chr(0)); end if; DBMS_OUTPUT.PUT_LINE('CREATE USER "' || LogfileUser || '" PROFILE "DEFAULT" IDENTIFIED BY "swx" DEFAULT TABLESPACE '); if LogFileInSyscfg then DBMS_OUTPUT.PUT_LINE(' "' || SyscfgTS || '"'); else DBMS_OUTPUT.PUT_LINE(' "' || LogfileTS || '"'); end if; DBMS_OUTPUT.PUT_LINE('TEMPORARY TABLESPACE "' || TempTablespace ||'" ACCOUNT UNLOCK;'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('GRANT UNLIMITED TABLESPACE TO "' || LogfileUser || '";'); DBMS_OUTPUT.PUT_LINE('GRANT "CONNECT" TO "' || LogfileUser || '";'); DBMS_OUTPUT.PUT_LINE('GRANT "DBA" TO "' || LogfileUser || '";'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('/* End of creating Logfile */'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('/* Start of creating objects in logfile */'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: TABVER */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || LogfileUser || '.TABVER ('); DBMS_OUTPUT.PUT_LINE(' NAME CHAR(20) not null,'); DBMS_OUTPUT.PUT_LINE(' VERSION SMALLINT not null,'); DBMS_OUTPUT.PUT_LINE(' PREV_VER SMALLINT'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('/* Table: UTC */'); DBMS_OUTPUT.PUT_LINE('/*==============================================================*/'); DBMS_OUTPUT.PUT_LINE('create table ' || LogfileUser || '.UTC ('); DBMS_OUTPUT.PUT_LINE(' TIME_MONO TIMESTAMP(6),'); DBMS_OUTPUT.PUT_LINE(' OFFSET NUMBER'); DBMS_OUTPUT.PUT_LINE(')'); DBMS_OUTPUT.PUT_LINE('/'); DBMS_OUTPUT.PUT_LINE('INSERT INTO ' || LogfileUser || '.UTC(TIME_MONO,OFFSET) VALUES(TO_DATE(''2005-01-01 00:00:00'',''YYYY-MM-DD HH24:MI:SS''),7200);'); DBMS_OUTPUT.PUT_LINE('commit;'); DBMS_OUTPUT.PUT_LINE('/* End of creating objects in logfile */'); DBMS_OUTPUT.PUT_LINE(chr(0)); DBMS_OUTPUT.PUT_LINE(chr(0)); end CreateNewLogfile; begin dbms_output.enable(buffer_size => null); WriteInfoHeader; CreateNewSyscfg; CreateNewLogfile; DBMS_OUTPUT.PUT_LINE('SPOOL OFF'); DBMS_OUTPUT.PUT_LINE('EXIT;'); end; /