File: create_PBCatalog.sql
Size: 1837
Date: Sat, 08 Dec 2007 15:36:53 +0100
Type: sql

-- CREATE PB Catalog Tables
CREATE TABLE pbcattbl (pbt_tnam varchar(129) NOT NULL , pbt_tid int , pbt_ownr varchar(129) NOT NULL , pbd_fhgt smallint , pbd_fwgt smallint , pbd_fitl varchar(1) , pbd_funl varchar(1) , pbd_fchr smallint , pbd_fptc smallint , pbd_ffce varchar(18) , pbh_fhgt smallint , pbh_fwgt smallint , pbh_fitl varchar(1) , pbh_funl varchar(1) , pbh_fchr smallint , pbh_fptc smallint , pbh_ffce varchar(18) , pbl_fhgt smallint , pbl_fwgt smallint , pbl_fitl varchar(1) , pbl_funl varchar(1) , pbl_fchr smallint , pbl_fptc smallint , pbl_ffce varchar(18) , pbt_cmnt varchar(254) , CONSTRAINT pbcattbl_x PRIMARY KEY NONCLUSTERED (pbt_tnam, pbt_ownr)) ;
CREATE TABLE pbcatcol (pbc_tnam varchar(129) NOT NULL , pbc_tid int , pbc_ownr varchar(129) NOT NULL , pbc_cnam varchar(129) NOT NULL , pbc_cid smallint , pbc_labl varchar(254) , pbc_lpos smallint , pbc_hdr varchar(254) , pbc_hpos smallint , pbc_jtfy smallint , pbc_mask varchar(31) , pbc_case smallint , pbc_hght smallint , pbc_wdth smallint , pbc_ptrn varchar(31) , pbc_bmap varchar(1) , pbc_init varchar(254) , pbc_cmnt varchar(254) , pbc_edit varchar(31) , pbc_tag varchar(254) ) ;
CREATE INDEX pbcatcol_idx ON pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam) ;
CREATE TABLE pbcatfmt (pbf_name varchar(30) NOT NULL , pbf_frmt varchar(254) , pbf_type smallint , pbf_cntr int ) ;
CREATE INDEX pbcatfmt_idx ON pbcatfmt (pbf_name) ;
CREATE TABLE pbcatedt (pbe_name varchar(30) NOT NULL , pbe_edit varchar(254) , pbe_type smallint , pbe_cntr int , pbe_seqn smallint NOT NULL , pbe_flag int , pbe_work varchar(32) ) ;
CREATE INDEX pbcatedt_idx ON pbcatedt (pbe_name, pbe_seqn) ;
CREATE TABLE pbcatvld (pbv_name varchar(30) NOT NULL , pbv_vald varchar(254) , pbv_type smallint , pbv_cntr int , pbv_msg varchar(254) ) ;
CREATE INDEX pbcatvld_idx ON pbcatvld (pbv_name) ;