GSR引擎20240113更新SQL更新汇总(2023.1.1-2024.1.12)

夜游神 · 发表于 2024-1-14 00:17:38

--2023.1.1扩展nameprefix,增加vip
ALTER TABLE [TBL_ITEM] ALTER COLUMN [FLD_NAMEPREFIX] varchar(127)
ALTER TABLE [TBL_SAVEDITEM] ALTER COLUMN [FLD_NAMEPREFIX] varchar(127)
ALTER TABLE [TBL_DHLBOX] ALTER COLUMN [FLD_NAMEPREFIX] varchar(127)
ALTER TABLE [TBL_ITEMMARKET] ALTER COLUMN [FLD_NAMEPREFIX] varchar(127)
go
ALTER TABLE [TBL_CHARACTER] ADD [FLD_VIPLEVEL] tinyint
ALTER TABLE [TBL_CHARACTER] ADD [FLD_VIPENDDATE] datetime
go
--2023.1.5增加3个自定义段
ALTER TABLE [TBL_CHARACTER] ADD [FLD_BINDJF] int
ALTER TABLE [TBL_CHARACTER] ADD [FLD_CUSINT3] int
ALTER TABLE [TBL_CHARACTER] ADD [FLD_CUSINT4] int
ALTER TABLE [TBL_CHARACTER] ADD [FLD_CUSINT5] int
go
--2023.5.13PET相关
--PET表
CREATE TABLE [dbo].[TBL_PET] (
[FLD_CHARACTER] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_TIMEHASH] [int] NULL ,
[FLD_PETIDX] [tinyint] NULL ,
[FLD_LEVEL] [tinyint] NULL ,
[FLD_EXP] [int] NULL ,
[FLD_FOOD] [int] NULL ,
[FLD_FULLY] [int] NULL ,
[FLD_STATUS] [tinyint] NULL ,
[FLD_PETNAME] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_BAGINDEX] [int] NULL ,
[FLD_HEADWEARINDEX] [int] NULL ,
[FLD_WINGINDEX] [int] NULL ,
[FLD_HEADWEAREXPITIME] [int] NULL ,
[FLD_WINGEXPITIME] [int] NULL ,
[FLD_SKILL1] [int] NULL ,
[FLD_SKILL2] [int] NULL ,
[FLD_SKILL3] [int] NULL ,
[FLD_SKILL4] [int] NULL ,
[FLD_PICKUP] [bigint] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX IX_TBL_PET ON dbo.TBL_PET (FLD_CHARACTER) ON [PRIMARY]
GO
--物品表TBL_PETITEM
CREATE TABLE [dbo].[TBL_PETITEM] (
[FLD_TIMEHASH] [int] NULL ,
[FLD_TYPE] [tinyint] NULL ,
[FLD_MAKEINDEX] [int] NOT NULL ,
[FLD_INDEX] [int] NULL ,
[FLD_DURA] [int] NULL ,
[FLD_DESC0] [int] NULL ,
[FLD_DESC1] [int] NULL ,
[FLD_DESC2] [int] NULL ,
[FLD_DESC3] [int] NULL ,
[FLD_DESC4] [int] NULL ,
[FLD_DESC5] [int] NULL ,
[FLD_DESC6] [int] NULL ,
[FLD_DESC7] [int] NULL ,
[FLD_DESC8] [int] NULL ,
[FLD_DESC9] [int] NULL ,
[FLD_DESC10] [int] NULL ,
[FLD_DESC11] [int] NULL ,
[FLD_DESC12] [int] NULL ,
[FLD_DESC13] [int] NULL ,
[FLD_NAMEPREFIX] [varchar] (127) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_HP] [int] NULL ,
[FLD_MP] [int] NULL ,
[FLD_TMINDEX] [int] NULL ,
[FLD_COLOR] [int] NULL ,
[FLD_EXPIRTIME] [int] NULL ,
[FLD_SOCKET] [bigint] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX IX_TBL_PETITEM ON dbo.TBL_PETITEM (FLD_TIMEHASH) ON [PRIMARY]
GO
--2023.10.14buff保存 (10.15日更改FLD_ID和FLD_ICON为int类型)
CREATE TABLE [dbo].[TBL_BUFF] (
[FLD_CHARACTER] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_BUFFNAME] [char] (24) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_BUFFTYPE] [tinyint] NULL ,
[FLD_TIMERTYPE] [tinyint] NULL ,
[FLD_ID] [int] NULL ,
[FLD_ICON] [int] NULL ,
[FLD_BEGINTIME] [int] NULL ,
[FLD_ENDTIME] [int] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX IX_TBL_BUFF ON dbo.TBL_BUFF (FLD_CHARACTER, FLD_BEGINTIME) ON [PRIMARY]
GO
--2024.1.8任务表
--增加任务DB表
CREATE TABLE [dbo].[SYS_Quest] (
[FLD_QUESTID] [int] NOT NULL primary key,
[FLD_KIND] [tinyint] NULL ,
[FLD_CRLV] [int] NULL ,
[FLD_SERIESNAME] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_OPENNPC] [int] NULL ,
[FLD_COMPNPC] [int] NULL ,
[FLD_TIMELIMIT] [int] NULL ,
[FLD_PREVQUESTID] [int] NULL ,
[FLD_PASSBYCASH] [int] NULL ,
[FLD_REQLV] [int] NULL ,
[FLD_REQZS] [int] NULL ,
[FLD_REQJOB] [tinyint] NULL ,
[FLD_DISABLE] [tinyint] NULL ,
[FLD_CALLBACK] [tinyint] NULL ,
[FLD_REACTION] [varchar] (127) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_QUESTTAR] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_REWARD] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_QUESTTITLE] [varchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_OPENSENTENCE] [varchar] (900) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_COMPSENTENCE] [varchar] (356) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_CLEARSENTENCE] [varchar] (356) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
--增加任务用户表
CREATE TABLE [dbo].[TBL_QUESTDATA] (
[FLD_CHARACTER] [nchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[FLD_QUESTID] [int] NULL ,
[FLD_AMOUNT1] [int] NULL ,
[FLD_AMOUNT2] [int] NULL ,
[FLD_AMOUNT3] [int] NULL ,
[FLD_AMOUNT4] [int] NULL ,
[FLD_EXPIRETIME] [int] NULL ,
[FLD_COMPLETED] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX IX_TBL_QUESTDATA ON dbo.TBL_QUESTDATA (FLD_CHARACTER, FLD_QUESTID) ON [PRIMARY]
GO
--扩充任务记录表
ALTER TABLE [TBL_QUEST] ADD [FLD_QUEST] binary(512)
--2024.1.8增加item的最大持久
ALTER TABLE [TBL_PETITEM] ADD [FLD_DURAMAX] int
GO
ALTER TABLE [TBL_ITEM] ADD [FLD_DURAMAX] int
GO
ALTER TABLE [TBL_SAVEDITEM] ADD [FLD_DURAMAX] int
GO
ALTER TABLE [TBL_DHLBOX] ADD [FLD_DURAMAX] int
GO
ALTER TABLE [TBL_ITEMMARKET] ADD [FLD_DURAMAX] int
GO
UPDATE TBL_PETITEM
SET FLD_DURAMAX = DuraMax
FROM TBL_PETITEM, SYS_Stditems
WHERE FLD_INDEX = idx + 1
UPDATE TBL_ITEM
SET FLD_DURAMAX = DuraMax
FROM TBL_ITEM, SYS_Stditems
WHERE FLD_INDEX = idx + 1
UPDATE TBL_SAVEDITEM
SET FLD_DURAMAX = DuraMax
FROM TBL_SAVEDITEM, SYS_Stditems
WHERE FLD_INDEX = idx + 1
UPDATE TBL_DHLBOX
SET FLD_DURAMAX = DuraMax
FROM TBL_DHLBOX, SYS_Stditems
WHERE FLD_INDEX = idx + 1
UPDATE TBL_ITEMMARKET
SET FLD_DURAMAX = DuraMax
FROM TBL_ITEMMARKET, SYS_Stditems
WHERE FLD_INDEX = idx + 1
--2024.1.12物品库扩展
ALTER TABLE [SYS_Stditems] ADD [addHideFunc_Type] tinyint
ALTER TABLE [SYS_Stditems] ADD [addHideFunc] int

复制代码