?? 4.變動管理.sql
字號:
CREATE TABLE "dba"."sbdbd"
("id" char(22) NOT NULL ,
"bh" char(22) NOT NULL ,
"dbrq" date ,
"sbbh" char(12) ,
"sbmc" char(40) ,
"ggxh" char(20) ,
"sccj" char(40) ,
"ccrq" date ,
"yz" numeric(12,2) ,
"jz" numeric(12,2) ,
"dcdw" char(40) ,
"drdw" char(40) ,
"dbyy" varchar(200) ,
"gsld" char(8) ,
"zgbm" char(8) ,
"dcbm" char(8) ,
"drbm" char(8) ) ;
CREATE UNIQUE INDEX "sbdbd"
ON "dba"."sbdbd"
("id" ) ;
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
('sbdbd',
'dba',
-9,
400,
'N',
'N',
134,
2,
'宋體',
-9,
400,
'N',
'N',
134,
2,
'宋體',
-9,
400 ,
'N',
'N',
134,
2,
'宋體',
'設(shè)備調(diào)撥單') ;
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
('sbdbd',
'dba',
'id',
'序列號',
0 ,
'序列號',
0,
23 ,
0 ,
77 ,
567 ,
'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
('sbdbd',
'dba',
'bh',
'設(shè)備序列號',
0 ,
'設(shè)備序列號',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'設(shè)備序列號' ) ;
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
('sbdbd',
'dba',
'dbrq',
'調(diào)撥日期',
0 ,
'調(diào)撥日期',
0,
23 ,
0 ,
77 ,
247 ,
'N',
'調(diào)撥日期' ) ;
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
('sbdbd',
'dba',
'sbbh',
'設(shè)備編號',
0 ,
'設(shè)備編號',
0,
23 ,
0 ,
77 ,
343 ,
'N',
'設(shè)備編號' ) ;
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
('sbdbd',
'dba',
'sbmc',
'設(shè)備名稱',
0 ,
'設(shè)備名稱',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'設(shè)備名稱' ) ;
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
('sbdbd',
'dba',
'ggxh',
'規(guī)格型號',
0 ,
'規(guī)格型號',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'規(guī)格型號' ) ;
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
('sbdbd',
'dba',
'sccj',
'生產(chǎn)廠家',
0 ,
'生產(chǎn)廠家',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'生產(chǎ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
('sbdbd',
'dba',
'ccrq',
'出廠日期',
0 ,
'出廠日期',
0,
23 ,
0 ,
77 ,
247 ,
'N',
'出廠日期' ) ;
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,
pbc_cmnt )
values
('sbdbd',
'dba',
'yz',
'原值',
0 ,
'原值',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'N',
'原值' ) ;
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,
pbc_cmnt )
values
('sbdbd',
'dba',
'jz',
'凈值',
0 ,
'凈值',
0,
24 ,
'[General]',
0 ,
77 ,
389 ,
'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
('sbdbd',
'dba',
'dcdw',
'調(diào)出單位',
0 ,
'調(diào)出單位',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'調(diào)出單位' ) ;
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
('sbdbd',
'dba',
'drdw',
'調(diào)入單位',
0 ,
'調(diào)入單位',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'調(diào)入單位' ) ;
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
('sbdbd',
'dba',
'dbyy',
'調(diào)撥原因',
0 ,
'調(diào)撥原因',
0,
23 ,
0 ,
77 ,
4641 ,
'N',
'調(diào)撥原因' ) ;
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
('sbdbd',
'dba',
'gsld',
'公司領(lǐng)導',
0 ,
'公司領(lǐng)導',
0,
23 ,
0 ,
57 ,
247 ,
'N',
'公司領(lǐng)導' ) ;
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
('sbdbd',
'dba',
'zgbm',
'主管部門',
0 ,
'主管部門',
0,
23 ,
0 ,
57 ,
247 ,
'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
('sbdbd',
'dba',
'dcbm',
'調(diào)出部門',
0 ,
'調(diào)出部門',
0,
23 ,
0 ,
57 ,
247 ,
'N',
'調(diào)出部門' ) ;
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
('sbdbd',
'dba',
'drbm',
'調(diào)入部門',
0 ,
'調(diào)入部門',
0,
23 ,
0 ,
57 ,
247 ,
'N',
'調(diào)入部門' ) ;
CREATE TABLE "dba"."sbzjd"
("id" char(22) NOT NULL ,
"bh" char(22) NOT NULL ,
"zjrq" date ,
"ghrq" date ,
"sbbh" char(12) ,
"sbmc" char(40) ,
"ggxh" char(20) ,
"sccj" char(40) ,
"synx" integer ,
"qysj" date ,
"yz" numeric(12,2) ,
"jz" numeric(12,2) ,
"sybm" char(40) ,
"zjdw" char(40) ,
"zjxy" char(200) ) ;
CREATE UNIQUE INDEX "sbzjd"
ON "dba"."sbzjd"
("id" ) ;
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
('sbzjd',
'dba',
-9,
400,
'N',
'N',
0,
34,
'Arial',
-9,
400,
'N',
'N',
134,
2,
'宋體',
-9,
400 ,
'N',
'N',
134,
2,
'宋體',
'設(shè)備租借單') ;
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
('sbzjd',
'dba',
'id',
'序列號',
0 ,
'序列號',
0,
23 ,
0 ,
77 ,
567 ,
'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
('sbzjd',
'dba',
'bh',
'設(shè)備序列號',
0 ,
'設(shè)備序列號',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'設(shè)備序列號' ) ;
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -