DROP TABLE if exists SRDEF;
CREATE TABLE SRDEF (
     RT     VARCHAR (3) BINARY NOT NULL,
     UI     VARCHAR (4) BINARY NOT NULL,
     STYRL     VARCHAR (41) BINARY NOT NULL,
     STNRTN     VARCHAR (14) BINARY NOT NULL,
     DEF     BLOB   NOT NULL,
     EX     VARCHAR (185) BINARY NOT NULL,
     UN     BLOB   NOT NULL,
     RH     VARCHAR (1) BINARY NOT NULL,
     ABR     VARCHAR (4) BINARY NOT NULL,
     RIN     VARCHAR (23) BINARY NOT NULL
)\p\g
LOAD DATA LOCAL INFILE "./NET/SRDEF" INTO TABLE SRDEF FIELDS TERMINATED BY "|"\p\g
ALTER TABLE SRDEF ADD INDEX SRDEF_STYRL_X (STYRL)\p\g

DROP TABLE IF EXISTS SRFIL\p\g
CREATE TABLE SRFIL (
     FIL     VARCHAR (7) BINARY NOT NULL,
     DES     VARCHAR (56) BINARY NOT NULL,
     FMT     VARCHAR (41) BINARY NOT NULL,
     CLS     VARCHAR (2) BINARY NOT NULL,
     RWS     VARCHAR (4) BINARY NOT NULL,
     BTS     VARCHAR (6) BINARY NOT NULL
)\p\g
LOAD DATA LOCAL INFILE "./NET/SRFIL" INTO TABLE SRFIL FIELDS TERMINATED BY "|"\p\g

DROP TABLE IF EXISTS SRFLD\p\g
CREATE TABLE SRFLD (
     COL     VARCHAR (3) BINARY NOT NULL,
     DES     VARCHAR (32) BINARY NOT NULL,
     REF     VARCHAR (3) BINARY NOT NULL,
     FIL     VARCHAR (19) BINARY NOT NULL
)\p\g
LOAD DATA LOCAL INFILE "./NET/SRFLD" INTO TABLE SRFLD FIELDS TERMINATED BY "|"\p\g

DROP TABLE IF EXISTS SRSTR\p\g
CREATE TABLE SRSTR (
     STYRL1     VARCHAR (41) BINARY NOT NULL,
     RL     VARCHAR (23) BINARY NOT NULL,
     STYRL2     VARCHAR (39) BINARY NOT NULL,
     LS     VARCHAR (3) BINARY NOT NULL
)\p\g
LOAD DATA LOCAL INFILE "./NET/SRSTR" INTO TABLE SRSTR FIELDS TERMINATED BY "|"\p\g

DROP TABLE IF EXISTS SRSTRE1\p\g
CREATE TABLE SRSTRE1 (
     UI1     VARCHAR (4) BINARY NOT NULL,
     UI2     VARCHAR (4) BINARY NOT NULL,
     UI3     VARCHAR (4) BINARY NOT NULL
)\p\g
LOAD DATA LOCAL INFILE "./NET/SRSTRE1" INTO TABLE SRSTRE1 FIELDS TERMINATED BY "|"\p\g

DROP TABLE IF EXISTS SRSTRE2\p\g
CREATE TABLE SRSTRE2 (
     STY1     VARCHAR (41) BINARY NOT NULL,
     RL     VARCHAR (23) BINARY NOT NULL,
     STY2     VARCHAR (41) BINARY NOT NULL
)\p\g
LOAD DATA LOCAL INFILE "./NET/SRSTRE2" INTO TABLE SRSTRE2 FIELDS TERMINATED BY "|"\p\g
ALTER TABLE SRSTRE2 ADD INDEX SRSTRE2_STY1_X (STY1), ADD INDEX SRSTRE2_STY2_X (STY2)\p\g