파워빌더는 처음 실행시 DB에 5개의 테이블을 만드는데 MYSQL이나 마리아DB 사용시 잘 생성이 되지 않는 경우가 있다. 그냥 직접 만들어주자.
CREATE TABLE `pbcatcol` (
`pbc_tnam` CHAR(65) NOT NULL,
`pbc_tid` INT(11) NULL DEFAULT NULL,
`pbc_ownr` CHAR(65) NOT NULL,
`pbc_cnam` CHAR(65) NOT NULL,
`pbc_cid` SMALLINT(6) NULL DEFAULT NULL,
`pbc_labl` VARCHAR(254) NULL DEFAULT NULL,
`pbc_lpos` SMALLINT(6) NULL DEFAULT NULL,
`pbc_hdr` VARCHAR(254) NULL DEFAULT NULL,
`pbc_hpos` SMALLINT(6) NULL DEFAULT NULL,
`pbc_jtfy` SMALLINT(6) NULL DEFAULT NULL,
`pbc_mask` VARCHAR(31) NULL DEFAULT NULL,
`pbc_case` SMALLINT(6) NULL DEFAULT NULL,
`pbc_hght` SMALLINT(6) NULL DEFAULT NULL,
`pbc_wdth` SMALLINT(6) NULL DEFAULT NULL,
`pbc_ptrn` VARCHAR(31) NULL DEFAULT NULL,
`pbc_bmap` CHAR(1) NULL DEFAULT NULL,
`pbc_init` VARCHAR(254) NULL DEFAULT NULL,
`pbc_cmnt` VARCHAR(254) NULL DEFAULT NULL,
`pbc_edit` VARCHAR(31) NULL DEFAULT NULL,
`pbc_tag` VARCHAR(254) NULL DEFAULT NULL,
UNIQUE INDEX `pbcatc_x` (`pbc_tnam`, `pbc_ownr`, `pbc_cnam`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `pbcatedt` (
`pbe_name` VARCHAR(30) NOT NULL,
`pbe_edit` VARCHAR(254) NULL DEFAULT NULL,
`pbe_type` SMALLINT(6) NULL DEFAULT NULL,
`pbe_cntr` INT(11) NULL DEFAULT NULL,
`pbe_seqn` SMALLINT(6) NOT NULL,
`pbe_flag` INT(11) NULL DEFAULT NULL,
`pbe_work` CHAR(32) NULL DEFAULT NULL,
UNIQUE INDEX `pbcate_x` (`pbe_name`, `pbe_seqn`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `pbcatfmt` (
`pbf_name` VARCHAR(30) NOT NULL,
`pbf_frmt` VARCHAR(254) NULL DEFAULT NULL,
`pbf_type` SMALLINT(6) NULL DEFAULT NULL,
`pbf_cntr` INT(11) NULL DEFAULT NULL,
UNIQUE INDEX `pbcatf_x` (`pbf_name`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `pbcattbl` (
`pbt_tnam` CHAR(65) NOT NULL,
`pbt_tid` INT(11) NULL DEFAULT NULL,
`pbt_ownr` CHAR(65) NOT NULL,
`pbd_fhgt` SMALLINT(6) NULL DEFAULT NULL,
`pbd_fwgt` SMALLINT(6) NULL DEFAULT NULL,
`pbd_fitl` CHAR(1) NULL DEFAULT NULL,
`pbd_funl` CHAR(1) NULL DEFAULT NULL,
`pbd_fchr` SMALLINT(6) NULL DEFAULT NULL,
`pbd_fptc` SMALLINT(6) NULL DEFAULT NULL,
`pbd_ffce` CHAR(18) NULL DEFAULT NULL,
`pbh_fhgt` SMALLINT(6) NULL DEFAULT NULL,
`pbh_fwgt` SMALLINT(6) NULL DEFAULT NULL,
`pbh_fitl` CHAR(1) NULL DEFAULT NULL,
`pbh_funl` CHAR(1) NULL DEFAULT NULL,
`pbh_fchr` SMALLINT(6) NULL DEFAULT NULL,
`pbh_fptc` SMALLINT(6) NULL DEFAULT NULL,
`pbh_ffce` CHAR(18) NULL DEFAULT NULL,
`pbl_fhgt` SMALLINT(6) NULL DEFAULT NULL,
`pbl_fwgt` SMALLINT(6) NULL DEFAULT NULL,
`pbl_fitl` CHAR(1) NULL DEFAULT NULL,
`pbl_funl` CHAR(1) NULL DEFAULT NULL,
`pbl_fchr` SMALLINT(6) NULL DEFAULT NULL,
`pbl_fptc` SMALLINT(6) NULL DEFAULT NULL,
`pbl_ffce` CHAR(18) NULL DEFAULT NULL,
`pbt_cmnt` VARCHAR(254) NULL DEFAULT NULL,
UNIQUE INDEX `pbcatt_x` (`pbt_tnam`, `pbt_ownr`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `pbcatvld` (
`pbv_name` VARCHAR(30) NOT NULL,
`pbv_vald` VARCHAR(254) NULL DEFAULT NULL,
`pbv_type` SMALLINT(6) NULL DEFAULT NULL,
`pbv_cntr` INT(11) NULL DEFAULT NULL,
`pbv_msg` VARCHAR(254) NULL DEFAULT NULL,
UNIQUE INDEX `pbcatv_x` (`pbv_name`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
