sql.txt

PB(PowerBuilder)源代码学习

CREATE TABLE "dba"."zckm" ("kmbm" char(10) NOT NULL DEFAULT NULL, "kmmc" char(30) DEFAULT NULL , PRIMARY KEY ("kmbm")) ;
insert into "dba".pbcattbl (pbt_tnam, pbt_ownr, pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce, pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce, pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce, pbt_cmnt) values ('zckm', 'dba', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400 , 'N', 'N', 134, 33, 'System', '') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('zckm', 'dba', 'kmbm', 0 , 0, 23 , 0 , 65 , 471 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('zckm', 'dba', 'kmmc', 0 , 0, 23 , 0 , 65 , 1207 , 'N') ;
CREATE TABLE "dba"."wh_czy" ("uid" varchar(10) NOT NULL DEFAULT NULL, "pass" varchar(10) DEFAULT NULL, "nname" varchar(10) DEFAULT NULL, "tel" varchar(10) DEFAULT NULL , PRIMARY KEY ("uid")) ;
insert into "dba".pbcattbl (pbt_tnam, pbt_ownr, pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce, pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce, pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce, pbt_cmnt) values ('wh_czy', 'dba', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400 , 'N', 'N', 134, 33, 'System', '') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('wh_czy', 'dba', 'uid', 0 , 0, 23 , 0 , 65 , 471 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('wh_czy', 'dba', 'pass', 0 , 0, 23 , 0 , 65 , 471 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('wh_czy', 'dba', 'nname', 0 , 0, 23 , 0 , 65 , 471 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('wh_czy', 'dba', 'tel', 0 , 0, 23 , 0 , 65 , 471 , 'N') ;
CREATE TABLE "dba"."picture" ("mc" varchar(100) NOT NULL DEFAULT NULL, "tp" long binary DEFAULT NULL , PRIMARY KEY ("mc")) ;
insert into "dba".pbcattbl (pbt_tnam, pbt_ownr, pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce, pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce, pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce, pbt_cmnt) values ('picture', 'dba', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400 , 'N', 'N', 134, 33, 'System', '') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('picture', 'dba', 'mc', 0 , 0, 0 , 0 , 0 , 0 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('picture', 'dba', 'tp', 0 , 0, 0 , 0 , 0 , 0 , 'N') ;
INSERT INTO zckm VALUES (
	'10',
	't1');
INSERT INTO zckm VALUES (
	'1001',
	't11');
INSERT INTO zckm VALUES (
	'100101',
	't111');
INSERT INTO zckm VALUES (
	'100102',
	't112');
INSERT INTO zckm VALUES (
	'100103',
	't113');
INSERT INTO zckm VALUES (
	'1002',
	't12');
INSERT INTO zckm VALUES (
	'100201',
	't121');
INSERT INTO zckm VALUES (
	'100202',
	't122');
INSERT INTO zckm VALUES (
	'100203',
	't123');
INSERT INTO zckm VALUES (
	'100204',
	't124');
INSERT INTO zckm VALUES (
	'1003',
	't13');
INSERT INTO zckm VALUES (
	'11',
	't2');
INSERT INTO zckm VALUES (
	'1101',
	't21');
INSERT INTO wh_czy VALUES (
	'01',
	'1',
	'111',
	'111');