SQL更新记录
2026-09-07
20260907更新日志-增加账号记录,必须在A库执行否则将会产生错误, FLD_RAWID为uid对应的账号
SQL语句
ALTER TABLE [TBL_ACCOUNT] ADD [FLD_RAWID] [nchar] (25)
2026-09-01
20260901更新日志
SQL语句
--增加额外伤害 ALTER TABLE [SYS_Stditems] ADD [ExtraDamage] int go --更新恢复石的用户装备数据,如无此功能可以忽略 UPDATE TBL_ITEM SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201)) UPDATE TBL_SAVEDITEM SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201)) UPDATE TBL_ITEMMARKET SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201)) UPDATE TBL_DHLBOX SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201)) UPDATE TBL_PETITEM SET FLD_COLOR = FLD_DESC1 * 65536 + FLD_DESC0, FLD_DESC0 = 0, FLD_DESC1 = 0 WHERE ((FLD_INDEX - 1) IN (SELECT idx FROM sys_stditems WHERE stdmode = 201)) go