select * from account ac where ac.account_id='1120070706162115001';
select * from account ac where ac.name like '%测试商户%';
delete from vnv.account_groups where id = 6305553;
update vnv.account set id_code='' where id = '1519334';
update vnv.account
set login_password = 'pass',
pay_password = '20160621@!#%@',
email = 'hxhz@unspay.com',
key = 'hxhz20160621#!!!',
account_type = 'C'
where account_id = '2120160608132303001';
alter table p2pgn.ORDER_INFO modify bank_code VARCHAR2(32);
ALTER TABLE mpos.COMMISSIONPOLICY ADD CARDTYPE NUMBER(2);
insert into vnv.ACCOUNT_FINANCE
(ID, MERCHANT_SEQ, FINANCE_TYPE, FINANCE_IP, RESERVE1, RESERVE2)
values
(25, 1544587, '1', 'https://www.unspay.com/p2pServer-hxhz/', null, null);
--9月份各用户余额流水sql
select b.name 用户名称,
a.amount 金额,
a.fee 手续费,
a.balance 账户余额,
a.lock_amount 冻结金额,
decode(a.flag, '1', '收', '-1', '付') 收付标志,
a.trans_id 交易编号,
a.update_time 更新时间
from vnv.acct_bal_his a, vnv.account b
where a.sub_acct_seq = b.default_sub_seq
--and b.account_type != 'A'
and to_char(a.update_time, 'yyyymmdd') >= '20160901'
and to_char(a.update_time, 'yyyymmdd') <= '20160930'
order by b.name, a.update_time desc
insert into vnv.account_authorize
(MERCHANT_SEQ,
ACCOUNT_SEQ,
AUTH_DATE,
AUTH_STATUS,
ID,
CREATE_DATE,
UPDATE_DATE)
values
(1602501,
3,
to_date('2016/12/1 16:23:00', 'yyyy/mm/dd hh24:mi:ss'),
'1',
vnv.ACCOUNTAUTHORIZE_SEQUENCE.nextval,
to_date('2016/12/1 16:23:00', 'yyyy/mm/dd hh24:mi:ss'),
to_date('2016/12/1 16:23:00', 'yyyy/mm/dd hh24:mi:ss'));
CREATE SEQUENCE vnv.cofee_deduct_order_SEQUENCE
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;
update vnv.account_company s
set s.boss_id = ''
where account_seq = (select id from vnv.account where account_id = '')
account_id 放表格里面的账户编号
boss_id 放加密后的表格里面法人身份证号
insert into vnv.bank_scene b
(b.action_type,
b.group_seq,
b.pay_type,
b.link_code,
b.card_type,
b.priority,
b.status,
b.id,
b.create_time)
values
('0',
'0',
'B',
'spdb',
'D',
'100',
'1',
3567,
to_date(to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-mm-dd hh24:mi:ss'));
insert into vnv.bank_scene_channel c
(c.scene_seq,
c.bank_seq,
c.channel_priority,
c.status,
c.id,
c.create_time)
values
(3567,
26,
'100',
'1',
2531,
to_date(to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-mm-dd hh24:mi:ss'));
comment on column ORDER_INFO.reserv2
is '保留字段二,退款原始订单号';
alter table vnv.companyfee_bal_his add constraint pk_companyfee_bal_his_id primary key (id);
update p2pgn.ORDER_INFO t
set t.status = 2
where t.order_num in
('T1764921', 'T1764985', 'T1764986', 'T1764991', 'T1764796');
commit;