PB连接MySQL需要的数据库

create table PBCATCOL
(
PBC_TNAM VARCHAR(30) not null,
PBC_TID INTEGER,
PBC_OWNR VARCHAR(30) not null,
PBC_CNAM VARCHAR(30) not null,
PBC_CID INTEGER,
PBC_LABL VARCHAR(254),
PBC_LPOS INTEGER,
PBC_HDR VARCHAR(254),
PBC_HPOS INTEGER,
PBC_JTFY INTEGER,
PBC_MASK VARCHAR(31),
PBC_CASE INTEGER,
PBC_HGHT INTEGER,
PBC_WDTH INTEGER,
PBC_PTRN VARCHAR(31),
PBC_BMAP CHAR(1),
PBC_INIT VARCHAR(254),
PBC_CMNT VARCHAR(254),
PBC_EDIT VARCHAR(31),
PBC_TAG VARCHAR(254)
);


create unique index PBSYSCATCOLDICT_IDX on PBCATCOL (PBC_TNAM, PBC_OWNR, PBC_CNAM);

create table PBCATEDT
(
PBE_NAME VARCHAR(30),
PBE_EDIT VARCHAR(254),
PBE_TYPE INTEGER,
PBE_CNTR INTEGER,
PBE_SEQN INTEGER,
PBE_FLAG INTEGER,
PBE_WORK VARCHAR(32)
);

create unique index PBSYSPBE_IDX on PBCATEDT (PBE_NAME, PBE_SEQN);


create table PBCATFMT
(
PBF_NAME VARCHAR(30),
PBF_FRMT VARCHAR(254),
PBF_TYPE INTEGER not null,
PBF_CNTR INTEGER
);

create unique index PBSYSCATFRMTS_IDX on PBCATFMT (PBF_NAME);

create table PBCATTBL
(
PBT_TNAM VARCHAR(30) not null,
PBT_TID INTEGER,
PBT_OWNR VARCHAR(30) not null,
PBD_FHGT INTEGER,
PBD_FWGT INTEGER,
PBD_FITL CHAR(1),
PBD_FUNL CHAR(1),
PBD_FCHR INTEGER,
PBD_FPTC INTEGER,
PBD_FFCE VARCHAR(18),
PBH_FHGT INTEGER,
PBH_FWGT INTEGER,
PBH_FITL CHAR(1),
PBH_FUNL CHAR(1),
PBH_FCHR INTEGER,
PBH_FPTC INTEGER,
PBH_FFCE VARCHAR(18),
PBL_FHGT INTEGER,
PBL_FWGT INTEGER,
PBL_FITL CHAR(1),
PBL_FUNL CHAR(1),
PBL_FCHR INTEGER,
PBL_FPTC INTEGER,
PBL_FFCE VARCHAR(18),
PBT_CMNT VARCHAR(254)
);

create unique index PBSYSCATPBT_IDX on PBCATTBL (PBT_TNAM, PBT_OWNR);

create table PBCATVLD
(
PBV_NAME VARCHAR(30),
PBV_VALD VARCHAR(254),
PBV_TYPE INTEGER,
PBV_CNTR INTEGER,
PBV_MSG VARCHAR(254)
);

create unique index PBSYSCATVLDS_IDX on PBCATVLD (PBV_NAME);