sql

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;