【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-brands_manage.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
CREATE TABLE "dba"."agent" ("agent_no" smallint NOT NULL DEFAULT NULL, "fullname" char(100) DEFAULT NULL, "shortname" char(20) DEFAULT NULL, "spell_code" char(6) DEFAULT NULL , PRIMARY KEY ("agent_no")) ;
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 ('agent', 'dba', -12, 400, 'N', 'N', 134, 33, '宋体', -12, 700, 'N', 'N', 134, 33, '宋体', -12, 700 , 'N', 'N', 134, 33, '宋体', '代理人编号表') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_mask, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('agent', 'dba', 'agent_no', '代理人编号:', 23 , '代理人编号', 25, 23 , '[General]', 0 , 77 , 229 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('agent', 'dba', 'fullname', '代理人全称:', 23 , '代理人全称', 25, 23 , 0 , 77 , 605 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('agent', 'dba', 'shortname', '代理人简称:', 23 , '代理人简称', 25, 23 , 0 , 77 , 605 , 'N', '用于统计报表的显示部分' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('agent', 'dba', 'spell_code', '拼音编码:', 23 , '拼音编码', 25, 23 , 0 , 77 , 229 , 'N', '代理人全称中前6个汉语拼音字母,每个字取一个字母,自左向右取' ) ;
CREATE TABLE "dba"."areacode" ("area_code" integer NOT NULL DEFAULT NULL, "prov_abbr" char(6) DEFAULT NULL, "prov_name" char(30) DEFAULT NULL, "district" char(50) DEFAULT NULL, "county" char(50) DEFAULT NULL, "spell_code" char(6) DEFAULT NULL , PRIMARY KEY ("area_code")) ;
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 ('areacode', '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_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_mask, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('areacode', 'dba', 'area_code', '地区编号:', 23 , '地区编号', 25, 23 , '[General]', 0 , 77 , 325 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('areacode', 'dba', 'prov_abbr', '省缩写:', 23 , '省缩写', 25, 23 , 0 , 77 , 325 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('areacode', 'dba', 'prov_name', '省:', 23 , '省', 25, 23 , 0 , 77 , 517 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('areacode', 'dba', 'district', '市:', 23 , '市', 25, 23 , 0 , 77 , 517 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('areacode', 'dba', 'county', '县:', 23 , '县', 25, 23 , 0 , 77 , 517 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('areacode', 'dba', 'spell_code', '拼音:', 23 , '拼音', 25, 23 , 0 , 77 , 325 , 'N') ;
CREATE TABLE "dba"."country" ("country_no" integer NOT NULL DEFAULT NULL, "shortname" char(30) DEFAULT NULL, "fullname" char(80) DEFAULT NULL, "spell_code" char(6) DEFAULT NULL , PRIMARY KEY ("country_no")) ;
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, pb