You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
29 lines
1.4 KiB
Plaintext
29 lines
1.4 KiB
Plaintext
--合计数添加移动支付字段
|
|
alter table STATIONSQUADSUM add MPAYRECCOUNT int not null default 0
|
|
,MPAYCASH int not null default 0,MPAYINCASH int not null default 0
|
|
|
|
alter table STATIONSQUADSUM_center add MPAYRECCOUNT int not null default 0
|
|
,MPAYCASH int not null default 0,MPAYINCASH int not null default 0
|
|
|
|
|
|
alter table STATIONSQUADSUM add ISFORCE int not null default 0
|
|
alter table STATIONSQUADSUM add SPCOUNT int default 0
|
|
alter table STATIONSQUADSUM add SPCASH int default 0
|
|
alter table STATIONSQUADSUM add SPINCASH int default 0
|
|
alter table STATIONSQUADSUM add BAK1 int default 0
|
|
alter table STATIONSQUADSUM add BAK2 int default 0
|
|
alter table STATIONSQUADSUM add BAK3 int default 0
|
|
alter table STATIONSQUADSUM add BAK4 int default 0
|
|
alter table STATIONSQUADSUM add BAK5 int default 0
|
|
alter table STATIONSQUADSUM add BAK6 int default 0
|
|
|
|
alter table STATIONSQUADSUM_center add ISFORCE int not null default 0
|
|
alter table STATIONSQUADSUM_center add SPCOUNT int default 0
|
|
alter table STATIONSQUADSUM_center add SPCASH int default 0
|
|
alter table STATIONSQUADSUM_center add SPINCASH int default 0
|
|
alter table STATIONSQUADSUM_center add BAK1 int default 0
|
|
alter table STATIONSQUADSUM_center add BAK2 int default 0
|
|
alter table STATIONSQUADSUM_center add BAK3 int default 0
|
|
alter table STATIONSQUADSUM_center add BAK4 int default 0
|
|
alter table STATIONSQUADSUM_center add BAK5 int default 0
|
|
alter table STATIONSQUADSUM_center add BAK6 int default 0 |