LGram16
dd97ddec92
Move git root from Client/ to src/ to track all source code: - Client: Game client source (moved to Client/Client/) - Server: Game server source - GameTools: Development tools - CryptoSource: Encryption utilities - database: Database scripts - Script: Game scripts - rylCoder_16.02.2008_src: Legacy coder tools - GMFont, Game: Additional resources 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
38 lines
1.1 KiB
Transact-SQL
38 lines
1.1 KiB
Transact-SQL
CREATE TABLE [dbo].[TblRestraintChar] (
|
|
[tinyServerID] [tinyint] NOT NULL ,
|
|
[UID] [int] NOT NULL ,
|
|
[strClientID] [varchar] (20) NOT NULL ,
|
|
[strCharName] [varchar] (20) NOT NULL ,
|
|
[tinyType] [tinyint] NOT NULL ,
|
|
[tinyKind] [tinyint] NOT NULL ,
|
|
[tinyBlocked] [tinyint] NOT NULL ,
|
|
[dateStartTime] [smalldatetime] NOT NULL ,
|
|
[dateEndTime] [smalldatetime] NOT NULL ,
|
|
[intEndTime] [int] NOT NULL ,
|
|
[strAdminID] [varchar] (20) NULL ,
|
|
[strDescription] [varchar] (30) NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[TblGMLogMsg] (
|
|
[LogID] [int] IDENTITY (1, 1) NOT NULL ,
|
|
[UID] [int] NULL ,
|
|
[CID] [int] NULL ,
|
|
[ServerGroupID] [tinyint] NOT NULL ,
|
|
[EditDate] [smalldatetime] NOT NULL ,
|
|
[LogMsg] [varchar] (200) NULL ,
|
|
[AdminID] [varchar] (20) NOT NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[TblGMLogMsg_Log] (
|
|
[LogID] [int] NOT NULL ,
|
|
[UID] [int] NULL ,
|
|
[CID] [int] NULL ,
|
|
[ServerGroupID] [tinyint] NOT NULL ,
|
|
[EditDate] [smalldatetime] NOT NULL ,
|
|
[LogMsg] [varchar] (200) NULL ,
|
|
[AdminID] [varchar] (20) NOT NULL ,
|
|
[InsertTime] [smalldatetime] NOT NULL
|
|
) ON [PRIMARY]
|
|
GO |