歡迎來到捷俊通幫助中心
數據庫修改說明
3.0.1.2
SQL- 本文本內容皆須在服務端3.0.1.2以上版本執(zhí)行SQL界面執(zhí)行。
- 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);