USE [SRO_VT_SHARD1] <------------ BURAYA BAKINIZ BURAYA SRO_VT_SHARD YAZILACAK!
GO
/****** Object: Table [dbo].[_Char] Script Date: 20.11.2021 12:38:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_Char](
[CharID] [int] IDENTITY(1,1) NOT NULL,
[Deleted] [tinyint] NOT NULL CONSTRAINT [DF__Char_Deleted] DEFAULT ((0)),
[RefObjID] [int] NOT NULL CONSTRAINT [DF__Char_RefObjID] DEFAULT ((0)),
[CharName16] [varchar](64) NOT NULL,
[NickName16] [varchar](17) NOT NULL CONSTRAINT [DF__Char_NickName16] DEFAULT (''),
[Scale] [tinyint] NOT NULL,
[CurLevel] [tinyint] NOT NULL CONSTRAINT [DF__Char_CurLevel] DEFAULT ((1)),
[MaxLevel] [tinyint] NOT NULL CONSTRAINT [DF__Char_MaxLevel] DEFAULT ((1)),
[ExpOffset] [bigint] NOT NULL CONSTRAINT [DF__Char_ExpOffset] DEFAULT ((0)),
[SExpOffset] [int] NOT NULL CONSTRAINT [DF__Char_SExpOffset] DEFAULT ((0)),
[Strength] [smallint] NOT NULL CONSTRAINT [DF__Char_Strength] DEFAULT ((0)),
[Intellect] [smallint] NOT NULL CONSTRAINT [DF__Char_Intellect] DEFAULT ((0)),
[RemainGold] [bigint] NOT NULL CONSTRAINT [DF__Char_RemainGold] DEFAULT ((0)),
[RemainSkillPoint] [int] NOT NULL CONSTRAINT [DF__Char_RemainSkillPoint] DEFAULT ((0)),
[RemainStatPoint] [smallint] NOT NULL CONSTRAINT [DF__Char_RemainStatPoint] DEFAULT ((0)),
[RemainHwanCount] [tinyint] NOT NULL CONSTRAINT [DF__Char_RemainHwanCount] DEFAULT ((0)),
[GatheredExpPoint] [int] NOT NULL CONSTRAINT [DF__Char_GatheredExpPoint] DEFAULT ((0)),
[HP] [int] NOT NULL CONSTRAINT [DF__Char_HP] DEFAULT ((200)),
[MP] [int] NOT NULL CONSTRAINT [DF__Char_MP] DEFAULT ((200)),
[LatestRegion] [smallint] NOT NULL CONSTRAINT [DF__Char_LatestRegion] DEFAULT ((0)),
[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,
[AppointedTeleport] [int] NOT NULL CONSTRAINT [DF__Char_AppointedTeleport] DEFAULT ((0)),
[AutoInvestExp] [tinyint] NOT NULL CONSTRAINT [DF__Char_AutoInvestExp] DEFAULT ((1)),
[InventorySize] [int] NOT NULL CONSTRAINT [DF__Char_EngagedCOS] DEFAULT ((0)),
[DailyPK] [tinyint] NOT NULL CONSTRAINT [DF__Char_DailyPK] DEFAULT ((0)),
[TotalPK] [smallint] NOT NULL CONSTRAINT [DF__Char_TotalPK] DEFAULT ((0)),
[PKPenaltyPoint] [int] NOT NULL CONSTRAINT [DF__Char_PKPenaltyPoint] DEFAULT ((0)),
[TPP] [int] NOT NULL CONSTRAINT [DF__Char_TPP] DEFAULT ((0)),
[PenaltyForfeit] [int] NOT NULL CONSTRAINT [DF__Char_PenaltyForfeit] DEFAULT ((0)),
[JobPenaltyTime] [int] NOT NULL CONSTRAINT [DF__Char_PenaltyTime] DEFAULT ((0)),
[JobLvl_Trader] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Trader] DEFAULT ((1)),
[Trader_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Trader_Exp] DEFAULT ((0)),
[JobLvl_Hunter] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Hunter] DEFAULT ((1)),
[Hunter_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Hunter_Exp] DEFAULT ((0)),
[JobLvl_Robber] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Robber] DEFAULT ((1)),
[Robber_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Robber_Exp] DEFAULT ((0)),
[GuildID] [int] NULL CONSTRAINT [DF__Char_GuildID] DEFAULT ((0)),
[LastLogout] [smalldatetime] NOT NULL,
[TelRegion] [smallint] NOT NULL CONSTRAINT [DF___char__TelRegion__4C2C2D6D] DEFAULT ((0)),
[TelPosX] [real] NOT NULL CONSTRAINT [DF___char__TelPosX__4D2051A6] DEFAULT ((0)),
[TelPosY] [real] NOT NULL CONSTRAINT [DF___char__TelPosY__4E1475DF] DEFAULT ((0)),
[TelPosZ] [real] NOT NULL CONSTRAINT [DF___char__TelPosZ__4F089A18] DEFAULT ((0)),
[DiedRegion] [smallint] NOT NULL CONSTRAINT [DF___char__DiedRegio__4FFCBE51] DEFAULT ((0)),
[DiedPosX] [real] NOT NULL CONSTRAINT [DF___char__DiedPosX__50F0E28A] DEFAULT ((0)),
[DiedPosY] [real] NOT NULL CONSTRAINT [DF___char__DiedPosY__51E506C3] DEFAULT ((0)),
[DiedPosZ] [real] NOT NULL CONSTRAINT [DF___char__DiedPosZ__52D92AFC] DEFAULT ((0)),
[WorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__WorldID] DEFAULT ((1)),
[TelWorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__TelWorldID] DEFAULT ((1)),
[DiedWorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__DiedWorldID] DEFAULT ((1)),
[HwanLevel] [tinyint] NOT NULL DEFAULT ((0)),
CONSTRAINT [PK__Char_1] PRIMARY KEY CLUSTERED
(
[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX__Char] UNIQUE NONCLUSTERED
(
[CharName16] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
