51 lines
4.2 KiB
SQL
51 lines
4.2 KiB
SQL
--添加银联行号字段
|
|
alter table capcompty add BNK_TYP VARCHAR2(10);
|
|
--修改主键
|
|
alter table capcompty drop constraint CAPCOMPTY_PK;
|
|
alter table capcompty add constraint CAPCOMPTY_PK primary key(PTY_KND,PTY_ID);
|
|
--更新现有银行信息
|
|
update CAPCOMPTY set bnk_typ='0102' where pty_id='102584000002' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0103' where pty_id='103584099993' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0104' where pty_id='104584000003' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0105' where pty_id='105584000005' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0301' where pty_id='301584000016' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0302' where pty_id='302584043105' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0303' where pty_id='303584000004' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0304' where pty_id='304584040898' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0305' where pty_id='305584000002' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0306' where pty_id='306584001261' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0308' where pty_id='308584001016' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0309' where pty_id='309584000000' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0310' where pty_id='310584000006' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='6403' where pty_id='313584001005' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0408' where pty_id='313584003003' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0423' where pty_id='313584004006' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0401' where pty_id='313584005009' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0479' where pty_id='313584007004' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0508' where pty_id='313584008007' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0425' where pty_id='313584009000' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0489' where pty_id='313584010016' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0413' where pty_id='313584011011' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0578' where pty_id='313584012014' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0437' where pty_id='313584018019' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0316' where pty_id='316584000013' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0318' where pty_id='318584000010' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0100' where pty_id='403584099005' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='2502' where pty_id='502584000001' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0623' where pty_id='509584000011' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0531' where pty_id='531584000009' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0563' where pty_id='563584000012' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0564' where pty_id='564584000007' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0327' where pty_id='593584000000' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0596' where pty_id='596584000014' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0322' where pty_id='671584000002' and PTY_KND='SZFS';
|
|
update CAPCOMPTY set bnk_typ='0787' where pty_id='787584000005' and PTY_KND='SZFS';
|
|
|
|
--新增
|
|
insert into CAPCOMPTY(PTY_KND,PTY_ID,PTY_NM,BNK_TYP) VALUES('SZFS','320584000015','深圳龙岗鼎业村镇银行股份有限公司','1514');
|
|
insert into CAPCOMPTY(PTY_KND,PTY_ID,PTY_NM,BNK_TYP) VALUES('SZFS','320584001000','深圳宝安融兴村镇银行有限责任公司','1521');
|
|
insert into CAPCOMPTY(PTY_KND,PTY_ID,PTY_NM,BNK_TYP) VALUES('SZFS','320584002002','深圳福田银座村镇银行股份有限公司','1520');
|
|
insert into CAPCOMPTY(PTY_KND,PTY_ID,PTY_NM,BNK_TYP) VALUES('SZFS','402584009991','深圳农村商业银行','1404');
|
|
insert into CAPCOMPTY(PTY_KND,PTY_ID,PTY_NM,BNK_TYP) VALUES('SZFS','307584007998','平安银行','0307');
|
|
insert into CAPCOMPTY(PTY_KND,PTY_ID,PTY_NM,BNK_TYP) VALUES('SZFS','785584000009','华商银行','0102');
|
|
|