yilv_new/AA/sql/addColumn.sql

use wtu
go
insert into transtime(entitytype) values('供应商')
insert into transtime(entitytype) values('仓库')
insert into transtime(entitytype) values('存货')
insert into transtime(entitytype) values('其他入库')
insert into transtime(entitytype) values('其他出库')
insert into transtime(entitytype) values('采购订单')
insert into transtime(entitytype) values('采购入库')
insert into transtime(entitytype) values('采购退货')
insert into transtime(entitytype) values('销售退货')
insert into transtime(entitytype) values('销售订单')
insert into transtime(entitytype) values('材料出库')
insert into transtime(entitytype) values('组装入库')
insert into transtime(entitytype) values('组装出库')
insert into transtime(entitytype) values('委外加工')

alter table transtime
add lasttime2 datetime

alter table rdrecords08
add text_flag bigint

alter table rdrecords09
add text_flag bigint


alter table