数据库修改说明

作者：小编更新时间：2022-06-07 点击数：

3.0.1.2

SQL

本文本内容皆须在服务端3.0.1.2以上版本执行SQL界面执行。
1.客户单价表单价小数点问题： ALTER TABLE CustomerPrice_Info MODIFY COLUMN Price DECIMAL(10,4);
2.称重记录表添加上传时间字段： ALTER TABLE Weighdata_Info ADD ToERPTime datetime;
3.客户单价维护金额小数点问题：
ALTER TABLE basicdata_info MODIFY COLUMN balance DECIMAL(19,4);
ALTER TABLE basicdata_info MODIFY COLUMN creditquota DECIMAL(19,4);
4.收货确认修改说明：
ALTER TABLE weighdata_info ADD UploadDateTime DATETIME
ALTER TABLE weighdata_info ADD ReceiptConfirmDateTime DATETIME
ALTER TABLE weighimage_info ADD UploadDateTime DATETIME
5.增加四代数据查询权限：
（1加四代权限）insert into `menu_info` (`ID`, `Node`, `ParentNode`, `Formname`, `ButtonName`, `MenuName`, `MenuSort`, `LinkAddress`, `MenuIcon`, `Shortcutkey`, `AddOperator`, `AddDateTime`, `ModDateTime`, `ModOperator`, `ISEnable`, `Remarks`) values('123123','60','53','','FrmDataRecordQueryFour','四代数据记录查询','60',NULL,NULL,'0','60128048567546f586ac48f44fe44b7e','2020-10-28 08:47:35','2020-10-28 08:47:39','60128048567546f586ac48f44fe44b7e','1','仅做权限设置');
（2管理员分配四代权限）insert into `menupermissions_info` (`ID`, `RoleID`, `MenuID`, `AddOperator`, `AddDateTime`, `ModDateTime`, `ModOperator`, `ISEnable`, `Remarks`) values('dfaerfgawfgvsdfhnjkluiolftjhdfgjh','superadmin','123123','4BDAF4F6-B2B3-48D3-82B8-300BC83D0CAB','2020-10-28 08:49:55','2020-10-28 08:49:58',NULL,'1',NULL);