forked from Elfocrash/L2dotNET
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathArmors.sql
More file actions
25 lines (24 loc) · 673 Bytes
/
Copy pathArmors.sql
File metadata and controls
25 lines (24 loc) · 673 Bytes
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
CREATE TABLE [dbo].[Armors]
(
[ArmorId] INT NOT NULL PRIMARY KEY,
[Name] VARCHAR(70) NOT NULL,
[BodyPart] INT NOT NULL,
[Crystallizable] BIT NOT NULL,
[ArmorType] TINYINT NOT NULL,
[Weight] INT NOT NULL,
[AvoidModify] BIT NOT NULL,
[Duration] INT NOT NULL,
[Pdef] INT NOT NULL,
[Mdef] INT NOT NULL,
[MpBonus] INT NOT NULL,
[Price] INT NOT NULL,
[CrystalType] TINYINT NOT NULL,
[CrystalCount] INT NOT NULL,
[Sellable] BIT NOT NULL,
[Dropable] BIT NOT NULL,
[Destroyable] BIT NOT NULL,
[Tradeable] BIT NOT NULL,
[ItemSkillId] INT NOT NULL,
[ItemSkillLvl] TINYINT NOT NULL
)
GO