forked from Elfocrash/L2dotNET
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCharacters.sql
More file actions
52 lines (50 loc) · 1.52 KB
/
Copy pathCharacters.sql
File metadata and controls
52 lines (50 loc) · 1.52 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
CREATE TABLE [dbo].[Characters]
(
[CharacterId] INT NOT NULL PRIMARY KEY,
[AccountId] INT NOT NULL,
[Name] VARCHAR(30) NOT NULL,
[Level] INT NOT NULL,
[MaxHp] INT NOT NULL,
[CurHp] INT NOT NULL,
[MaxCp] INT NOT NULL,
[CurCp] INT NOT NULL,
[MaxMp] INT NOT NULL,
[CurMp] INT NOT NULL,
[Face] TINYINT NOT NULL,
[HairStyle] TINYINT NOT NULL,
[HairColor] TINYINT NOT NULL,
[Sex] BIT NOT NULL,
[Heading] INT NOT NULL,
[X] INT NOT NULL,
[Y] INT NOT NULL,
[Z] INT NOT NULL,
[Exp] BIGINT NOT NULL,
[ExpBeforeDeath] BIGINT NOT NULL,
[Sp] INT NOT NULL,
[Karma] INT NOT NULL,
[PvpKills] INT NOT NULL,
[PkKills] INT NOT NULL,
[Race] TINYINT NOT NULL,
[ClassId] INT NOT NULL,
[BaseClass] INT NOT NULL,
[DeleteTime] DATETIME2 NULL,
[CanCraft] INT NOT NULL,
[Title] VARCHAR(50) NULL,
[RecHave] INT NOT NULL,
[RecLeft] INT NOT NULL,
[AccessLevel] INT NOT NULL,
[Online] INT NOT NULL,
[OnlineTime] INT NOT NULL,
[CharSlot] INT NOT NULL,
[LastAccess] DATETIME2 NULL,
[PunishLevel] INT NULL,
[PunishTime] DATETIME2 NULL,
[PowerGrade] INT NOT NULL,
[Nobless] BIT NOT NULL,
[Hero] BIT NOT NULL,
[LastRecomDate] DATETIME2 NULL,
CONSTRAINT [FK_Characters_Accounts] FOREIGN KEY ([AccountId]) REFERENCES [Accounts]([AccountId]),
CONSTRAINT [AK_Characters_Name] UNIQUE ([Name])
)
GO
CREATE INDEX [IX_Characters_AccountId] ON [dbo].[Characters] ([AccountId])