drop table SalesContractProcessMX;
CREATE TABLE SalesContractProcessMX (
id text,
chengben numeric(15,5),
sysIncident integer,
PRIMARY KEY (id)
)
Distributed by (id);

alter table SalesContractProcessMX add column hashResult text;
alter table SalesContractProcessMX add column rowNum serial;

alter table SalesContractProcessMX add column zongjia text;
alter table SalesContractProcessMX add column maolibz text;
alter table SalesContractProcessMX add column wuliaoh text;
