DROP TABLE MPSTSFTP;

CREATE TABLE MPSTSFTP
(
   ARE_CD      CHAR(03)    NOT NULL,
   PRV_CD      CHAR(02)    NOT NULL,
   PRV_NM      CHAR(30)    DEFAULT ' ',
   PRD_STS     CHAR(01)    NOT NULL,
   IP_ADR      CHAR(15)    NOT NULL,
   USR_NAM     CHAR(30)    NOT NULL ,
   USR_PWD     CHAR(30)    DEFAULT ' ',
   FIL_PTH     CHAR(100)   DEFAULT ' ',
   FTP_PRT     CHAR(10)    DEFAULT '22',
   FIL1        CHAR(30)    DEFAULT ' ',
   FIL2        CHAR(30)    DEFAULT ' ',
   FIL3        CHAR(30)    DEFAULT ' ',
primary key (ARE_CD)
);