欢迎来到捷俊通帮助中心


数据库修改说明

作者:小编 更新时间: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);



产品推荐