最新SQL数据脚本
/************* 最后更新*期: 2002.11.29. 20:48 Writing by Chinasf *************/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_ABILITY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_ABILITY]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_BONUSABILITY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_BONUSABILITY]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_CHANGECHR]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_CHANGECHR]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_CHAR_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_CHAR_INFO]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_CURRENTABILITY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_CURRENTABILITY]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_ITEM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_ITEM]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_MAGIC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_MAGIC]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_QUEST]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_QUEST]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_SAVEDITEM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_SAVEDITEM]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_CHARACTER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_CHARACTER]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_SKILL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[TBL_SKILL]GO
CREATE TABLE [dbo].[TBL_ABILITY] ( [FLD_CHARACTER] [varchar] (50) NULL , [FLD_LEVEL] [int] NULL , [FLD_AC] [int] NULL , [FLD_MAC] [int] NULL , [FLD_DC] [int] NULL , [FLD_MC] [int] NULL , [FLD_SC] [int] NULL , [FLD_HP] [int] NULL , [FLD_MP] [int] NULL , [FLD_MAXHP] [int] NULL , [FLD_MAXMP] [int] NULL , [FLD_EXP] [int] NULL , [FLD_MAXEXP] [int] NULL , [FLD_WEIGHT] [int] NULL , [FLD_MAXWEIGHT] [int] NULL , [FLD_WEARWEIGHT] [int] NULL , [FLD_MAXWEARWEIGHT] [int] NULL , [FLD_HANDWEIGHT] [int] NULL , [FLD_MAXHANDWEIGHT] [int] NULL , [FLD_ATOMFIRE_MC] [int] NULL , [FLD_ATOMICE_MC] [int] NULL , [FLD_ATOMLIGHT_MC] [int] NULL , [FLD_ATOMWIND_MC] [int] NULL , [FLD_ATOMHOLY_MC] [int] NULL , [FLD_ATOMDARK_MC] [int] NULL , [FLD_ATOMPHANTOM_MC] [int] NULL , [FLD_ATOMFIRE_MAC] [int] NULL , [FLD_ATOMICE_MAC] [int] NULL , [FLD_ATOMLIGHT_MAC] [int] NULL , [FLD_ATOMWIND_MAC] [int] NULL , [FLD_ATOMHOLY_MAC] [int] NULL , [FLD_ATOMDARK_MAC] [int] NULL , [FLD_ATOMPHANTOM_MAC] [int] NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_BONUSABILITY] ( [FLD_CHARACTER] [varchar] (50) NOT NULL , [FLD_DC] [int] NULL , [FLD_SC] [int] NULL , [FLD_MC] [int] NULL , [FLD_AC] [int] NULL , [FLD_MAC] [int] NULL , [FLD_HP] [int] NULL , [FLD_MP] [int] NULL , [FLD_HIT] [int] NULL , [FLD_SPEED] [int] NULL , [FLD_RESERVED] [int] NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_CHANGECHR] ( [FLD_LOGINID] [varchar] (50) NULL , [New_Chr] [varchar] (50) NULL , [FLD_HORSERACE] [int] NULL , [FLD_ATOMFIRE_MC] [float] NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_CHAR_INFO] ( [FLD_LOGINID] [varchar] (50) NOT NULL , [FLD_CHARACTER] [varchar] (50) NULL , [FLD_SERVERNAME] [varchar] (50) NULL , [FLD_JOB] [int] NULL , [FLD_SEX] [int] NULL , [FLD_DELETED] [bit] NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_CURRENTABILITY] ( [FLD_CHARACTER] [varchar] (50) NULL , [FLD_DC] [int] NULL , [FLD_SC] [int] NULL , [FLD_MC] [int] NULL , [FLD_AC] [int] NULL , [FLD_MAC] [int] NULL , [FLD_HP] [int] NULL , [FLD_MP] [int] NULL , [FLD_HIT] [int] NULL , [FLD_SPEED] [int] NULL , [FLD_RESERVED] [int] NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_ITEM] ( [FLD_CHARACTER] [varchar] (50) NOT NULL , [FLD_MAKEINDEX] [int] NULL , [FLD_INDEX] [int] NULL , [FLD_DURA] [int] NULL , [FLD_DURAMAX] [int] NULL , [FLD_DESC0] [varchar] (50) NULL , [FLD_DESC1] [varchar] (50) NULL , [FLD_DESC2] [varchar] (50) NULL , [FLD_DESC3] [varchar] (50) NULL , [FLD_DESC4] [varchar] (50) NULL , [FLD_DESC5] [varchar] (50) NULL , [FLD_DESC6] [varchar] (50) NULL , [FLD_DESC7] [varchar] (50) NULL , [FLD_DESC8] [varchar] (50) NULL , [FLD_DESC9] [varchar] (50) NULL , [FLD_DESC10] [varchar] (50) NULL , [FLD_DESC11] [varchar] (50) NULL , [FLD_DESC12] [varchar] (50) NULL , [FLD_DESC13] [varchar] (50) NULL , [FLD_TYPE] [varchar] (50) NULL , [FLD_COLORR] [int] NULL , [FLD_COLORG] [int] NULL , [FLD_COLORB] [int] NULL , [FLD_NAMEPREFIX] [varchar] (50) NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_MAGIC] ( [FLD_CHARACTER] [varchar] (50) NULL , [FLD_MAGICID] [varchar] (50) NULL , [FLD_LEVEL] [int] NULL , [FLD_KEY] [varchar] (50) NULL , [FLD_CURTRAIN] [varchar] (50) NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_QUEST] ( [FLD_CHARACTER] [varchar] (50) NULL , [FLD_QUESTOPENINDEX] [varchar] (1024) NULL , [FLD_QUESTFININDEX] [varchar] (1024) NULL , [FLD_QUEST] [varchar] (1024) NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_SAVEDITEM] ( [FLD_CHARACTER] [varchar] (50) NULL , [FLD_MAKEINDEX] [int] NULL , [FLD_INDEX] [int] NULL , [FLD_DURA] [int] NULL , [FLD_DURAMAX] [int] NULL , [FLD_DESC0] [varchar] (50) NULL , [FLD_DESC1] [varchar] (50) NULL , [FLD_DESC2] [varchar] (50) NULL , [FLD_DESC3] [varchar] (50) NULL , [FLD_DESC4] [varchar] (50) NULL , [FLD_DESC5] [varchar] (50) NULL , [FLD_DESC6] [varchar] (50) NULL , [FLD_DESC7] [varchar] (50) NULL , [FLD_DESC8] [varchar] (50) NULL , [FLD_DESC9] [varchar] (50) NULL , [FLD_DESC10] [varchar] (50) NULL , [FLD_DESC11] [varchar] (50) NULL , [FLD_DESC12] [varchar] (50) NULL , [FLD_DESC13] [varchar] (50) NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_CHARACTER] ( [FLD_CHARACTER] [varchar] (50) NOT NULL , [FLD_USERID] [varchar] (50) NULL , [FLD_DELETED] [bit] NULL , [FLD_UPDATEDATETIME] [datetime] NULL , [FLD_DBVERSION] [int] NULL , [FLD_MAPNAME] [varchar] (50) NULL , [FLD_CX] [int] NULL , [FLD_CY] [int] NULL , [FLD_DIR] [int] NULL , [FLD_HAIR] [int] NULL , [FLD_HAIRCOLORR] [int] NULL , [FLD_HAIRCOLORG] [int] NULL , [FLD_HAIRCOLORB] [int] NULL , [FLD_SEX] [int] NULL , [FLD_JOB] [int] NULL , [FLD_LEVEL] [int] NULL , [FLD_GOLD] [int] NULL , [FLD_HOMEMAP] [varchar] (50) NULL , [FLD_HOMEX] [int] NULL , [FLD_HOMEY] [int] NULL , [FLD_PKPOINT] [int] NULL , [FLD_ALLOWPARTY] [int] NULL , [FLD_FREEGULITYCOUNT] [int] NULL , [FLD_ATTACKMODE] [int] NULL , [FLD_FIGHTZONEDIE] [int] NULL , [FLD_BODYLUCK] [int] NULL , [FLD_INCHEALTH] [int] NULL , [FLD_INCSPELL] [int] NULL , [FLD_INCHEALING] [int] NULL , [FLD_BONUSAPPLY] [int] NULL , [FLD_BONUSPOINT] [int] NULL , [FLD_HUNGRYSTATE] [int] NULL , [FLD_TESTSERVERRESETCOUNT] [int] NULL , [FLD_CGHUSETIME] [int] NULL , [FLD_ENABLEGRECALL] [int] NULL , [FLD_BYTES_1] [int] NULL , [FLD_HORSERACE] [int] NULL , [FLD_MAKEDATE] [datetime] NULL ) ON [PRIMARY]GO
CREATE TABLE [dbo].[TBL_SKILL] ( [FLD_CHARACTER] [varchar] (50) NULL , [FLD_SKILLINDEX] [int] NULL , [FLD_RESERVERD] [varchar] (50) NULL , [FLD_CURTRAIN] [varchar] (50) NULL ) ON [PRIMARY]GO
ALTER TABLE [dbo].[TBL_CHARACTER] WITH NOCHECK ADD CONSTRAINT [PK_TBL_CHARACTER] PRIMARY KEY CLUSTERED ( [FLD_CHARACTER] ) ON [PRIMARY] GO
