18 lines
536 B
SQL
18 lines
536 B
SQL
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)
|
|
); |