--MRP功能模块中建立的对应表约束：

alter table spa

add constraint uqe unique(idx, spadate)

;

alter table spad

add Constraint fk_spad_invoice foreign key(listpid) references invoice(id)

;

alter table spad

add Constraint fk_spad_invoiceitem foreign key(listid) references invoiceitem(id)

;

alter table invoiceitem

add qtyli float

;

alter table billitem

add qtyli float

;

alter table invoiceitem

add qtylo float

;

alter table billitem

add qtylo float

;

--采购建议明细单所对应的【入库\领料】单据前缀代码存入MySetting表中对应的键：

insert into mysetting(vname,userid,shortsetting) values('MRP.spa.btype','','')