USE [RanGame1]
GO
/****** Object: Table [dbo].[ChaInfo] Script Date: 12/27/2020 01:07:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ChaInfo](
[ChaNum] [int] IDENTITY(1,1) NOT NULL,
[SGNum] [int] NULL,
[UserNum] [int] NOT NULL,
[GuNum] [int] NULL,
[GuPosition] [int] NOT NULL,
[ChaName] [varchar](33) NOT NULL,
[ChaGuName] [varchar](33) NOT NULL,
[ChaTribe] [int] NOT NULL,
[ChaClass] [int] NOT NULL,
[ChaSchool] [int] NOT NULL,
[ChaHair] [int] NOT NULL,
[ChaFace] [int] NOT NULL,
[ChaLiving] [int] NOT NULL,
[ChaLevel] [int] NOT NULL,
[ChaReborn] [int] NOT NULL,
[ChaMoney] [money] NOT NULL,
[ChaPower] [bigint] NOT NULL,
[ChaDex] [bigint] NOT NULL,
[ChaSpirit] [bigint] NOT NULL,
[ChaStrong] [bigint] NOT NULL,
[ChaStrength] [bigint] NOT NULL,
[ChaIntel] [bigint] NOT NULL,
[ChaStRemain] [bigint] NOT NULL,
[ChaExp] [money] NOT NULL,
[ChaViewRange] [int] NOT NULL,
[ChaHP] [bigint] NOT NULL,
[ChaMP] [bigint] NOT NULL,
[ChaSP] [bigint] NOT NULL,
[ChaCP] [bigint] NOT NULL,
[ChaStartMap] [int] NOT NULL,
[ChaStartGate] [int] NOT NULL,
[ChaPosX] [float] NOT NULL,
[ChaPosY] [float] NOT NULL,
[ChaPosZ] [float] NOT NULL,
[ChaSaveMap] [int] NOT NULL,
[ChaSavePosX] [float] NOT NULL,
[ChaSavePosY] [float] NOT NULL,
[ChaSavePosZ] [float] NOT NULL,
[ChaReturnMap] [int] NOT NULL,
[ChaReturnPosX] [float] NOT NULL,
[ChaReturnPosY] [float] NOT NULL,
[ChaReturnPosZ] [float] NOT NULL,
[ChaBright] [int] NOT NULL,
[ChaAttackP] [int] NOT NULL,
[ChaDefenseP] [int] NOT NULL,
[ChaFightA] [int] NOT NULL,
[ChaShootA] [int] NOT NULL,
[ChaPK] [int] NOT NULL,
[ChaSkillPoint] [int] NOT NULL,
[ChaInvenLine] [int] NOT NULL,
[ChaDeleted] [int] NOT NULL,
[ChaOnline] [int] NOT NULL,
[ChaCreateDate] [datetime] NOT NULL,
[ChaDeletedDate] [datetime] NOT NULL,
[ChaStorage2] [datetime] NOT NULL,
[ChaStorage3] [datetime] NOT NULL,
[ChaStorage4] [datetime] NOT NULL,
[ChaGuSecede] [datetime] NOT NULL,
[ChaQuest] [image] NULL,
[ChaSkills] [image] NULL,
[ChaSkillSlot] [image] NULL,
[ChaActionSlot] [image] NULL,
[ChaPutOnItems] [image] NULL,
[ChaInven] [image] NULL,
[ChaCoolTime] [image] NULL,
[ChaSex] [int] NULL,
[ChaHairStyle] [int] NULL,
[ChaHairColor] [int] NULL,
[ChaReExp] [float] NOT NULL,
[ChaSpSID] [int] NULL,
[ChaSpMID] [int] NULL,
[ChaPersonalMap] [image] NULL,
[ChaEquipmentLockEnable] [bigint] NOT NULL,
[ChaEquipmentLockStatus] [bigint] NOT NULL,
[ChaPKScore] [bigint] NOT NULL,
[ChaPKDeath] [bigint] NOT NULL,
[ChaBadge] [varchar](33) NOT NULL,
[ChaActivity] [image] NULL,
[ChaActivityPoint] [int] NOT NULL,
[ChaContributionPoint] [money] NOT NULL,
[ChaItemFood] [image] NULL,
[ChaScaleRange] [float] NOT NULL,
[ChaCWDeath] [bigint] NOT NULL,
[ChaCWKill] [bigint] NOT NULL,
CONSTRAINT [PK_ChaInfo] PRIMARY KEY CLUSTERED
(
[ChaNum] 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] TEXTIMAGE_ON [SECONDARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_SGNum] DEFAULT ((0)) FOR [SGNum]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCWDeath] DEFAULT ((0)) FOR [ChaCWDeath]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCWKill] DEFAULT ((0)) FOR [ChaCWKill]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaScaleRange] DEFAULT ((1.0)) FOR [ChaScaleRange]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaActivityPoint] DEFAULT ((0)) FOR [ChaActivityPoint]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaBadge] DEFAULT (('')) FOR [ChaBadge]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPKScore] DEFAULT ((0)) FOR [ChaPKScore]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPKDeath] DEFAULT ((0)) FOR [ChaPKDeath]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaContributionPoint] DEFAULT ((0)) FOR [ChaContributionPoint]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaEquipmentLockEnable] DEFAULT ((0)) FOR [ChaEquipmentLockEnable]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaEquipmentLockStatus] DEFAULT ((0)) FOR [ChaEquipmentLockStatus]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_GuNum] DEFAULT ((0)) FOR [GuNum]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_GuPosition] DEFAULT ((0)) FOR [GuPosition]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaGuName] DEFAULT ('') FOR [ChaGuName]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaTribe] DEFAULT ((0)) FOR [ChaTribe]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaClass] DEFAULT ((0)) FOR [ChaClass]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSchool] DEFAULT ((0)) FOR [ChaSchool]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaHair] DEFAULT ((0)) FOR [ChaHair]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaFace] DEFAULT ((0)) FOR [ChaFace]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaLiving] DEFAULT ((0)) FOR [ChaLiving]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaLevel] DEFAULT ((0)) FOR [ChaLevel]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF__ChaInfo__ChaRebo__2EDAF651] DEFAULT ((0)) FOR [ChaReborn]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaMoney] DEFAULT ((0)) FOR [ChaMoney]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPower] DEFAULT ((0)) FOR [ChaPower]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDex] DEFAULT ((0)) FOR [ChaDex]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSpirit] DEFAULT ((0)) FOR [ChaSpirit]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStrong] DEFAULT ((0)) FOR [ChaStrong]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStrength] DEFAULT ((0)) FOR [ChaStrength]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaIntel] DEFAULT ((0)) FOR [ChaIntel]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStRemain] DEFAULT ((0)) FOR [ChaStRemain]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaExp] DEFAULT ((0)) FOR [ChaExp]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaViewRange] DEFAULT ((0)) FOR [ChaViewRange]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaHP] DEFAULT ((0)) FOR [ChaHP]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaMP] DEFAULT ((0)) FOR [ChaMP]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSP] DEFAULT ((0)) FOR [ChaSP]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCP] DEFAULT ((0)) FOR [ChaCP]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStartMap] DEFAULT ((0)) FOR [ChaStartMap]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStartGate] DEFAULT ((0)) FOR [ChaStartGate]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPosX] DEFAULT ((0)) FOR [ChaPosX]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPosY] DEFAULT ((0)) FOR [ChaPosY]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPosZ] DEFAULT ((0)) FOR [ChaPosZ]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSaveMap] DEFAULT ((-1)) FOR [ChaSaveMap]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSavePosX] DEFAULT ((0)) FOR [ChaSavePosX]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSavePosY] DEFAULT ((0)) FOR [ChaSavePosY]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSavePosZ] DEFAULT ((0)) FOR [ChaSavePosZ]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnMap] DEFAULT ((-1)) FOR [ChaReturnMap]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnPosX] DEFAULT ((0)) FOR [ChaReturnPosX]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnPosY] DEFAULT ((0)) FOR [ChaReturnPosY]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnPosZ] DEFAULT ((0)) FOR [ChaReturnPosZ]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaBright] DEFAULT ((0)) FOR [ChaBright]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaAttackP] DEFAULT ((0)) FOR [ChaAttackP]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDefenseP] DEFAULT ((0)) FOR [ChaDefenseP]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaFightA] DEFAULT ((0)) FOR [ChaFightA]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaShootA] DEFAULT ((0)) FOR [ChaShootA]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPK] DEFAULT ((0)) FOR [ChaPK]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSkillPoint] DEFAULT ((0)) FOR [ChaSkillPoint]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaInvenLine] DEFAULT ((0)) FOR [ChaInvenLine]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDeleted] DEFAULT ((0)) FOR [ChaDeleted]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaOnline] DEFAULT ((0)) FOR [ChaOnline]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCreateDate] DEFAULT (getdate()) FOR [ChaCreateDate]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDeletedDate] DEFAULT (getdate()) FOR [ChaDeletedDate]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStorage2] DEFAULT ('1970-02-01') FOR [ChaStorage2]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStorage3] DEFAULT ('1970-02-01') FOR [ChaStorage3]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStorage4] DEFAULT ('1970-02-01') FOR [ChaStorage4]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaGuSecede] DEFAULT ('1970-02-01') FOR [ChaGuSecede]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReExp] DEFAULT ((0)) FOR [ChaReExp]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSpSID_1] DEFAULT ((0)) FOR [ChaSpSID]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSpMID_1] DEFAULT ((0)) FOR [ChaSpMID]
GO