12 lines
1.9 KiB
SQL
12 lines
1.9 KiB
SQL
delete from upbs_arg;
|
|
delete from usps_exch_arg;
|
|
insert into upbs_arg (BRANCH_NO, CHECK_ID, COUNTER_TYPE, INIT_DATE, SYS_STATUS, SYS_NAME, TRANSACTION_NO) values (0, ' ', ' ', {init_date}, '1', '初始化', 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', '2', {init_date}, '0', '0', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', '1', {init_date}, '0', '1', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', 'G', {init_date}, '0', '0', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', 'S', {init_date}, '0', '0', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', '3', {init_date}, '0', '0', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', '9', {init_date}, '0', '1', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', 'D', {init_date}, '0', '0', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', 'A', {init_date}, '0', '0', '1', 0, 0);
|
|
insert into usps_exch_arg (EXCHANGE_STATUS, EXCHANGE_TYPE, INIT_DATE, MONEY_TYPE, SEAT_SOURCE, WITHDRAW, TRANSACTION_NO, SEAT_PREFIX_LEN) values ('1', 'R', {init_date}, '0', '0', '1', 0, 0); |