[파워빌더] MYSQL이나 마리아DB 사용시 카탈로그 문제 : Catalog tables could not be created and are not available for use.


   파워빌더는 처음 실행시 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

;



저작자 표시 비영리 변경 금지
신고
크리에이티브 커먼즈 라이선스
Creative Commons License