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>
18 lines
476 B
Transact-SQL
18 lines
476 B
Transact-SQL
-- Execute All
|
|
|
|
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TblRYLUserStat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
|
drop table [dbo].[TblRYLUserStat]
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[TblRYLUserStat] (
|
|
[nNation] [tinyint] NULL ,
|
|
[nServerID] [int] NULL ,
|
|
[nUserNum] [int] NULL ,
|
|
[tDateTime] [smalldatetime] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
CREATE CLUSTERED INDEX [TblRYLUserStat1] ON [dbo].[TblRYLUserStat]([tDateTime] DESC , [nServerID]) ON [PRIMARY]
|
|
GO
|
|
|