Ðề: Dừng phát triển và Share ForestWeb bản thương mại Full No Bug tốt nhất
CREATE TABLE [dbo].[ZYZZ](
[ServerID] [int] NULL,
[ZYWin] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ZenEvent](
[Guid] [int] IDENTITY(1,1) NOT NULL,
[AccountID] [varchar](10) NOT NULL,
[Zen] [int] NULL,
CONSTRAINT [PK_ZenEvent] PRIMARY KEY CLUSTERED
(
[Guid] ASC,
[AccountID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[WZ_CW_INFO](
[MAP_SVR_GROUP] [int] NULL,
[CRYWOLF_OCCUFY] [int] NULL,
[CRYWOLF_STATE] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[WZ_CreateCharacter_Version](
[Version] [varchar](50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[warehouse](
[AccountID] [varchar](10) NOT NULL,
[Items] [varbinary](3840) NULL,
[Money] [int] NULL,
[EndUseDate] [smalldatetime] NULL,
[DbVersion] [tinyint] NULL,
[pw] [smallint] NULL,
[ExtCKNum] [int] NULL,
[NeedExtCK] [int] NULL,
[Itens2] [varbinary](1200) NULL,
[pwd] [smallint] NOT NULL,
[mu_wid] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_warehouse] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VI_CURR_INFO](
[ends_days] [nvarchar](8) NULL,
[chek_code] [nvarchar](1) NOT NULL,
[used_time] [int] NULL,
[memb___id] [nvarchar](10) NOT NULL,
[memb_name] [nvarchar](10) NOT NULL,
[memb_guid] [int] NOT NULL,
[sno__numb] [nvarchar](18) NOT NULL,
[Bill_Section] [int] NULL,
[Bill_Value] [int] NULL,
[Bill_Hour] [int] NULL,
[Surplus_Point] [int] NULL,
[Surplus_Minute] [datetime] NULL,
[Increase_Days] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TopResetMiniInTime](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Resets] [int] NOT NULL,
[WeekYear] [varchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TopResetInWeek](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Resets] [int] NOT NULL,
[WeekYear] [varchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TopResetInTime](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Resets] [int] NOT NULL,
[Code] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TopResetInMonth](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Resets] [int] NOT NULL,
[MonthYear] [varchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TopPointInTime](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Points] [int] NOT NULL,
[Code] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TopManhTuongInTime](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Points] [int] NOT NULL,
[Week] [varchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TopDanhVongInTime](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[DanhVong] [int] NOT NULL,
[Code] [varchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Titan_Rewards](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NOT NULL,
[Zen] [int] NOT NULL,
[VIPMoney] [int] NOT NULL,
[Num] [int] NOT NULL,
[Lvl] [tinyint] NOT NULL,
[Opt] [tinyint] NOT NULL,
[Luck] [tinyint] NOT NULL,
[Skill] [tinyint] NOT NULL,
[Dur] [tinyint] NOT NULL,
[Excellent] [tinyint] NOT NULL,
[Ancient] [tinyint] NOT NULL,
[JOH] [tinyint] NOT NULL,
[Sock1] [tinyint] NOT NULL,
[Sock2] [tinyint] NOT NULL,
[Sock3] [tinyint] NOT NULL,
[Sock4] [tinyint] NOT NULL,
[Sock5] [tinyint] NOT NULL,
[Days] [smallint] NOT NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_WaitFriend](
[GUID] [int] NOT NULL,
[FriendGuid] [int] NOT NULL,
[FriendName] [varchar](10) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_Serial_Bank](
[F_Serial_Guid] [int] IDENTITY(1,1) NOT NULL,
[P_Serial_1] [char](4) NOT NULL,
[P_Serial_2] [char](4) NOT NULL,
[P_Serial_3] [char](4) NOT NULL,
[F_Serial_Section] [smallint] NOT NULL,
[F_Member_Guid] [int] NULL,
[F_Member_Id] [char](10) NULL,
[F_Register_Section] [smallint] NULL,
[F_Register_Date] [smalldatetime] NULL,
[F_Create_Date] [smalldatetime] NOT NULL,
[F_RegisterCheck] [bit] NOT NULL,
CONSTRAINT [PK_T_Serial_Bank] PRIMARY KEY CLUSTERED
(
[P_Serial_1] ASC,
[P_Serial_2] ASC,
[P_Serial_3] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_RingEvent_OfflineGift](
[GUID] [smallint] IDENTITY(1,1) NOT NULL,
[AccountID] [varchar](10) NULL,
[GiftSection] [tinyint] NOT NULL,
[GiftKind] [tinyint] NOT NULL,
[RegisterDate] [datetime] NULL,
CONSTRAINT [PK_T_RingEvent_OfflineGift] PRIMARY KEY CLUSTERED
(
[GUID] ASC,
[GiftSection] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_RingEvent_GiftName](
[GiftKind] [tinyint] NOT NULL,
[GiftName] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_RingAttackEvent_Gift](
[GUID] [int] IDENTITY(1,1) NOT NULL,
[AccountID] [varchar](50) NOT NULL,
[GiftKind] [tinyint] NOT NULL,
[RegisterDate] [datetime] NOT NULL,
CONSTRAINT [PK_T_RingAttackEvent_Gift] PRIMARY KEY CLUSTERED
(
[GUID] ASC,
[GiftKind] ASC,
[RegisterDate] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_Register_Info](
[F_Register_Section] [smallint] NOT NULL,
[F_Register_Name] [varchar](50) NOT NULL,
[F_Register_TotalCount] [int] NOT NULL,
CONSTRAINT [PK_T_Register_Info] PRIMARY KEY CLUSTERED
(
[F_Register_Section] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_RegCount_Check](
[AccountID] [varchar](10) NOT NULL,
[RegCount] [int] NOT NULL,
[RegAlready] [bit] NOT NULL,
CONSTRAINT [PK_T_RegCount_Check] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_PetItem_Info](
[ItemSerial] [int] NOT NULL,
[Pet_Level] [smallint] NULL,
[Pet_Exp] [int] NULL,
CONSTRAINT [PK_T_Pet_Info] PRIMARY KEY CLUSTERED
(
[ItemSerial] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_MU2003_EVENT](
[AccountID] [varchar](50) NOT NULL,
[EventChips] [smallint] NOT NULL,
[MuttoIndex] [int] NOT NULL,
[MuttoNumber] [int] NOT NULL,
[Check_Code] [char](1) NOT NULL,
CONSTRAINT [PK_T_MU2003_EVENT_1] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_FRIENDSHIP_STONE](
[AccountID] [varchar](10) NOT NULL,
[ServerCode] [smallint] NOT NULL,
[CharName] [varchar](10) NOT NULL,
[FriendShipStoneCount] [int] NOT NULL,
[Check_Code] [tinyint] NOT NULL,
CONSTRAINT [PK_T_T] PRIMARY KEY CLUSTERED
(
[AccountID] ASC,
[ServerCode] ASC,
[CharName] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_FRIENDSHIP_SERVERRANK](
[ServerCode] [smallint] NOT NULL,
[FriendShipStoneCount] [int] NOT NULL,
CONSTRAINT [PK_T_FRIENDSHIP_SERVERRANK] PRIMARY KEY CLUSTERED
(
[ServerCode] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_FriendMain](
[GUID] [int] NOT NULL,
[Name] [varchar](10) NOT NULL,
[FriendCount] [tinyint] NULL,
[MemoCount] [int] NULL,
[MemoTotal] [int] NULL,
CONSTRAINT [PK_T_FriendMain] PRIMARY KEY CLUSTERED
(
[GUID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_FriendMail](
[MemoIndex] [int] NOT NULL,
[GUID] [int] NOT NULL,
[FriendName] [varchar](10) NULL,
[wDate] [smalldatetime] NOT NULL,
[Subject] [varchar](50) NULL,
[bRead] [bit] NOT NULL,
[Memo] [varbinary](1000) NULL,
[Photo] [binary](18) NULL,
[Dir] [tinyint] NULL,
[Act] [tinyint] NULL,
CONSTRAINT [PK_T_FriendMemo] PRIMARY KEY CLUSTERED
(
[GUID] ASC,
[MemoIndex] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_FriendList](
[GUID] [int] NOT NULL,
[FriendGuid] [int] NULL,
[FriendName] [varchar](10) NULL,
[Del] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_ENTER_CHECK_BC](
[AccountID] [varchar](10) NOT NULL,
[CharName] [varchar](10) NOT NULL,
[ServerCode] [smallint] NOT NULL,
[ToDayEnterCount] [tinyint] NOT NULL,
[LastEnterDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_T_ENTER_CHECK_DS] PRIMARY KEY CLUSTERED
(
[AccountID] ASC,
[CharName] ASC,
[ServerCode] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_DL_OFFLINE_GIFTNAME](
[GiftKind] [int] NOT NULL,
[GiftName] [varchar](50) NOT NULL,
CONSTRAINT [PK_T_DL_OFFLINE_GIFTNAME] PRIMARY KEY CLUSTERED
(
[GiftKind] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_DL_OFFLINE_GIFT](
[Guid] [int] IDENTITY(1,1) NOT NULL,
[Server] [int] NULL,
[AccountID] [varchar](10) NULL,
[CharName] [varchar](10) NULL,
[GiftKind] [int] NOT NULL,
[Date_Give] [smalldatetime] NOT NULL,
[Date_Reg] [smalldatetime] NULL,
[RegCheck] [tinyint] NOT NULL,
CONSTRAINT [PK_T_DL_OFFLINE_GIFT] PRIMARY KEY NONCLUSTERED
(
[Guid] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_CurCharName](
[Name] [char](10) NOT NULL,
[cDate] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_CGuid](
[GUID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NOT NULL,
CONSTRAINT [PK_T_CGuid] PRIMARY KEY CLUSTERED
(
[GUID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_CC_OFFLINE_GIFTNAME](
[GiftKind] [int] NOT NULL,
[GiftName] [varchar](50) NOT NULL,
CONSTRAINT [PK_T_CC_OFFLINE_GIFTNAME] PRIMARY KEY CLUSTERED
(
[GiftKind] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_CC_OFFLINE_GIFT](
[Guid] [int] IDENTITY(1,1) NOT NULL,
[Server] [int] NULL,
[AccountID] [varchar](10) NULL,
[CharName] [varchar](10) NULL,
[GiftKind] [int] NOT NULL,
[Date_Give] [smalldatetime] NOT NULL,
[Date_Reg] [smalldatetime] NULL,
[RegCheck] [tinyint] NOT NULL,
CONSTRAINT [PK_T_CC_OFFLINE_GIFT] PRIMARY KEY NONCLUSTERED
(
[Guid] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_BLOOD_PLAYCOUNT](
[AccountId] [varchar](50) NOT NULL,
[PlayCount] [int] NOT NULL,
[RecoverCheck] [bit] NOT NULL,
CONSTRAINT [PK_T_BLOOD_PLAYCOUNT] PRIMARY KEY CLUSTERED
(
[AccountId] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_BLOOD_CASTLE](
[AccountID] [varchar](10) NOT NULL,
[StoneCount] [int] NOT NULL,
[Check_Code] [int] NOT NULL,
CONSTRAINT [PK_T_BLOOD_CASTLE] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ShopManhTuongBuyLog](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Week] [varchar](10) NULL,
[TimeBuy] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[SCFS5Quest](
[AccountID] [varchar](10) NOT NULL,
[Name] [nvarchar](10) NOT NULL,
[SCFS5Quest] [varbinary](8000) NOT NULL,
[Type] [smallint] NOT NULL,
PRIMARY KEY NONCLUSTERED
(
[Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Race_LastWinners](
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NOT NULL,
[Seconds] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Race_Data](
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NOT NULL,
[Seconds] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[QUESTIONS](
[ID] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[DIFF] [int] NOT NULL,
[QUESTION] [varchar](300) NOT NULL,
[OK] [varchar](50) NULL,
[NOK] [int] NOT NULL,
[nAnsws] [int] NOT NULL,
[Answer1] [varchar](100) NULL,
[Answer2] [varchar](100) NULL,
[Answer3] [varchar](100) NULL,
[Answer4] [varchar](100) NULL,
[Answer5] [varchar](100) NULL,
[Answer6] [varchar](100) NULL,
[Answers] [int] NOT NULL,
[kind] [varchar](20) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[OfficialHelper](
[Name] [varchar](10) NOT NULL,
[Data] [varbinary](257) NULL,
PRIMARY KEY NONCLUSTERED
(
[Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MuExtraData](
[HUNT_ZONE_OPEN] [int] NOT NULL,
[MAP_SRV] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MuCrywolf_DATA](
[MAP_SVR_GROUP] [int] NOT NULL,
[CRYWOLF_OCCUFY] [int] NOT NULL,
[CRYWOLF_STATE] [int] NOT NULL,
[CHAOSMIX_PLUS_RATE] [int] NOT NULL,
[CHAOSMIX_MINUS_RATE] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MuCastle_SIEGE_GUILDLIST](
[MAP_SVR_GROUP] [int] NOT NULL,
[GUILD_NAME] [varchar](10) NOT NULL,
[GUILD_ID] [int] NOT NULL,
[GUILD_INVOLVED] [bit] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MuCastle_REG_SIEGE](
[MAP_SVR_GROUP] [int] NOT NULL,
[REG_SIEGE_GUILD] [varchar](8) NOT NULL,
[REG_MARKS] [int] NOT NULL,
[IS_GIVEUP] [tinyint] NOT NULL,
[SEQ_NUM] [int] NOT NULL,
CONSTRAINT [IX_ATTACK_GUILD_SUBKEY] UNIQUE NONCLUSTERED
(
[MAP_SVR_GROUP] ASC,
[REG_SIEGE_GUILD] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MuCastle_NPC](
[MAP_SVR_GROUP] [int] NOT NULL,
[NPC_NUMBER] [int] NOT NULL,
[NPC_INDEX] [int] NOT NULL,
[NPC_DF_LEVEL] [int] NOT NULL,
[NPC_RG_LEVEL] [int] NOT NULL,
[NPC_MAXHP] [int] NOT NULL,
[NPC_HP] [int] NOT NULL,
[NPC_X] [tinyint] NOT NULL,
[NPC_Y] [tinyint] NOT NULL,
[NPC_DIR] [tinyint] NOT NULL,
[NPC_CREATEDATE] [datetime] NOT NULL,
CONSTRAINT [IX_NPC_SUBKEY] UNIQUE NONCLUSTERED
(
[MAP_SVR_GROUP] ASC,
[NPC_NUMBER] ASC,
[NPC_INDEX] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MuCastle_MONEY_STATISTICS](
[MAP_SVR_GROUP] [int] NOT NULL,
[LOG_DATE] [datetime] NOT NULL,
[MONEY_CHANGE] [money] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MuCastle_DATA](
[MAP_SVR_GROUP] [int] NOT NULL,
[SIEGE_START_DATE] [datetime] NOT NULL,
[SIEGE_END_DATE] [datetime] NOT NULL,
[SIEGE_GUILDLIST_SETTED] [bit] NOT NULL,
[SIEGE_ENDED] [bit] NOT NULL,
[CASTLE_OCCUPY] [bit] NOT NULL,
[OWNER_GUILD] [varchar](8) NOT NULL,
[MONEY] [money] NOT NULL,
[TAX_RATE_CHAOS] [int] NOT NULL,
[TAX_RATE_STORE] [int] NOT NULL,
[TAX_HUNT_ZONE] [int] NOT NULL,
CONSTRAINT [PK_MuCastle_DATA] PRIMARY KEY CLUSTERED
(
[MAP_SVR_GROUP] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MgItemLog](
[Seq] [int] IDENTITY(1,1) NOT NULL,
[Acc] [nvarchar](10) NULL,
[ItemCode] [char](20) NULL,
[Sn] [int] NULL,
[SentDate] [smalldatetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_STAT_GJ](
[memb___id] [char](10) NOT NULL,
[name] [char](10) NOT NULL,
[ServerName] [varchar](20) NULL,
[ServerCode] [int] NULL,
[IP] [varchar](20) NULL,
[TM] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_STAT](
[memb___id] [varchar](10) NOT NULL,
[ConnectStat] [tinyint] NOT NULL,
[ServerName] [varchar](50) NULL,
[IP] [varchar](15) NULL,
[ConnectTM] [smalldatetime] NULL,
[DisConnectTM] [smalldatetime] NULL,
[OnlineHours] [int] NULL,
CONSTRAINT [PK_MEMB_STAT] PRIMARY KEY CLUSTERED
(
[memb___id] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_INFO](
[memb_guid] [int] IDENTITY(1,1) NOT NULL,
[memb___id] [varchar](10) NOT NULL,
[memb__pwd] [varbinary](17) NULL,
[memb_name] [varchar](10) NOT NULL,
[sno__numb] [char](18) NOT NULL,
[post_code] [char](6) NULL,
[addr_info] [varchar](50) NULL,
[addr_deta] [varchar](50) NULL,
[tel__numb] [varchar](20) NULL,
[phon_numb] [varchar](15) NULL,
[mail_addr] [varchar](50) NULL,
[fpas_ques] [varchar](50) NULL,
[fpas_answ] [varchar](50) NULL,
[job__code] [char](2) NULL,
[appl_days] [char](10) NULL,
[modi_days] [char](10) NULL,
[out__days] [varchar](20) NULL,
[true_days] [char](10) NULL,
[mail_chek] [char](1) NULL,
[bloc_code] [char](1) NOT NULL,
[ctl1_code] [char](1) NOT NULL,
[vip_free] [tinyint] NULL,
[country] [nvarchar](100) NULL,
[gender] [nvarchar](100) NULL,
[SecretQuestion] [int] NULL,
[SecretAnswer] [varchar](100) NULL,
[SCFIsVip] [smallint] NOT NULL,
[SCFVipMoney] [int] NOT NULL,
[SCFVipDays] [int] NOT NULL,
[SCFWareVipCount] [int] NOT NULL,
[SCFLuckyCoins] [int] NOT NULL,
[SMSPoints] [char](10) NULL,
[confirmed] [int] NULL,
[activation_id] [varchar](50) NULL,
[SCFExtWarehouse] [tinyint] NOT NULL,
[WCoin] [int] NOT NULL,
[WCoinP] [int] NOT NULL,
[GoblinCoin] [int] NOT NULL,
[MuItemShopList] [varbinary](720) NULL,
[MuItemShopGiftList] [varbinary](720) NULL,
[MuItemShopGiftMsg] [varbinary](4995) NULL,
[GoldChannelTime] [int] NOT NULL,
[sid] [varchar](32) NULL,
[PassCap1] [varchar](32) NULL,
[PassCap2] [varchar](32) NULL,
[Bank_Zen] [bigint] NOT NULL,
[Bank_MoneyC1] [int] NOT NULL,
[Bank_MoneyC2] [int] NOT NULL,
[Bank_Chaos] [int] NOT NULL,
[Bank_Cre] [int] NOT NULL,
[Bank_Blue] [int] NOT NULL,
[Block_End_Time] [int] NULL,
[IP_Secure] [varchar](20) NULL,
[SecureQuestion] [int] NULL,
[SecureAnswer] [varchar](100) NULL,
[Phone_No] [varchar](15) NULL,
[Email_Address] [varchar](50) NULL,
[Active_GCode] [tinyint] NOT NULL,
[Time_GiveCode] [int] NOT NULL,
[IPLoginCheck] [varchar](20) NULL,
[LanQuayItem] [int] NOT NULL,
[BlockInfo] [varchar](100) NULL,
CONSTRAINT [PK_MEMB_INFO_1] PRIMARY KEY NONCLUSTERED
(
[memb_guid] DESC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_DETA](
[memb_guid] [int] NOT NULL,
[desc_text] [varchar](5000) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_CREDITS](
[memb___id] [varchar](10) NOT NULL,
[credits] [int] NOT NULL,
CONSTRAINT [PK_MEMB_CREDITS] PRIMARY KEY CLUSTERED
(
[memb___id] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MANG_INFO](
[mang_guid] [int] IDENTITY(1,1) NOT NULL,
[mang___id] [varchar](15) NOT NULL,
[mang__pwd] [varchar](34) NOT NULL,
[mang_name] [varchar](20) NOT NULL,
[auth_code] [int] NOT NULL,
[appl_day] [smalldatetime] NULL,
[bloc_code] [int] NOT NULL,
[perm] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LuckyCoinsRank](
[id] [int] IDENTITY(1,1) NOT NULL,
[Account] [nvarchar](10) NULL,
[LuckyCoins] [int] NULL,
[Date] [smalldatetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[GuildWarehouse](
[G_Name] [varchar](10) NOT NULL,
[Items] [varbinary](3840) NULL,
[Money] [int] NULL,
[EndUseDate] [smalldatetime] NULL,
[DbVersion] [tinyint] NULL,
[pw] [smallint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[GuildMember](
[Name] [varchar](10) NOT NULL,
[G_Name] [varchar](8) NOT NULL,
[G_Level] [tinyint] NULL,
[G_Status] [tinyint] NOT NULL,
CONSTRAINT [PK_GuildMember] PRIMARY KEY CLUSTERED
(
[Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Guild](
[G_Name] [varchar](8) NOT NULL,
[G_Mark] [varbinary](32) NULL,
[G_Score] [int] NULL,
[G_Master] [varchar](10) NULL,
[G_Count] [int] NULL,
[G_Notice] [varchar](60) NULL,
[Number] [int] IDENTITY(1,1) NOT NULL,
[G_Type] [int] NOT NULL,
[G_Rival] [int] NOT NULL,
[G_Union] [int] NOT NULL,
[MemberCount] [int] NULL,
[Resets] [int] NOT NULL,
[SCFG_Gens] [smallint] NOT NULL,
CONSTRAINT [PK_Guild] PRIMARY KEY CLUSTERED
(
[G_Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[GameServerInfo](
[Number] [int] NOT NULL,
[ItemCount] [int] NOT NULL,
[ZenCount] [int] NULL,
[AceItemCount] [int] NULL,
[MuShopItemCount] [int] NOT NULL,
CONSTRAINT [PK_GameServerInfo] PRIMARY KEY NONCLUSTERED
(
[Number] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_WareOnline](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Item_Code] [varchar](32) NULL,
[Item_Serial] [varchar](8) NULL,
[TimeAct] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_OTP_SMS](
[AccountID] [varchar](16) NULL,
[OTP] [varchar](10) NULL,
[Time] [int] NULL,
[Status] [tinyint] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_Log_QuayItem](
[AccountID] [varchar](16) NULL,
[Character] [varchar](16) NULL,
[Comment] [nvarchar](200) NULL,
[Time] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_Log_Action](
[AccountID] [varchar](16) NULL,
[IP] [varchar](20) NULL,
[Action] [tinyint] NULL,
[Time] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_GiftCode](
[STT] [int] IDENTITY(1,1) NOT NULL,
[GiftCode] [varchar](10) NULL,
[Date_Create] [varchar](20) NULL,
[Date_Exp] [varchar](20) NULL,
[Date_Use] [varchar](20) NULL,
[Date_Give] [varchar](20) NULL,
[Acc_Use] [varchar](10) NULL,
[type] [tinyint] NOT NULL,
[Status] [tinyint] NOT NULL,
[Comment] [varchar](30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_GiaiTri_LoDe](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Account] [varchar](10) NULL,
[Num_Bet1] [varchar](2) NULL,
[Num_Bet2] [varchar](2) NULL,
[Num_Bet3] [varchar](2) NULL,
[Num_Bet4] [varchar](2) NULL,
[Num_Point] [int] NOT NULL,
[Type_play] [varchar](7) NULL,
[Type_MoneyBet] [varchar](6) NULL,
[Date_Bet] [varchar](10) NULL,
[Bet_Status] [tinyint] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_FBAppLog](
[STT] [int] IDENTITY(1,1) NOT NULL,
[Fbuserid] [varchar](20) NULL,
[AccountID] [varchar](20) NULL,
[Time] [varchar](20) NULL,
[Count] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_Event_Goblin](
[id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](10) NULL,
[Item_Code] [varchar](32) NULL,
[Item_Serial] [varchar](8) NULL,
[Item_Level] [tinyint] NULL,
[UpTime] [int] NULL,
[Code] [tinyint] NULL,
[NotFair] [tinyint] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_DaiLy_Order](
[id] [int] IDENTITY(1,1) NOT NULL,
[AccountID] [varchar](10) NULL,
[Number] [int] NOT NULL,
[BankName] [varchar](100) NULL,
[Time] [int] NOT NULL,
[Status] [tinyint] NOT NULL,
[TimeDuyet] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_DaiLy_Log](
[id] [int] IDENTITY(1,1) NOT NULL,
[AccountID] [varchar](10) NULL,
[Number] [int] NOT NULL,
[TimeTrans] [varchar](20) NULL,
[Type] [varchar](1) NULL,
[Content] [nvarchar](200) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[FW_DaiLy](
[id] [int] IDENTITY(1,1) NOT NULL,
[AccountID] [varchar](10) NULL,
[DateCreate] [varchar](20) NULL,
[BuLicense_Img] [varchar](200) NULL,
[PhoneNum] [varchar](15) NULL,
[Yahoo] [varchar](30) NULL,
[Password] [varchar](10) NULL,
[Status] [tinyint] NOT NULL,
[Money] [int] NOT NULL,
[DisCount] [tinyint] NOT NULL,
[DaiLyName] [varchar](30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CopyLog](
[copy_id] [int] IDENTITY(1,1) NOT NULL,
[copy_acid] [varchar](10) NOT NULL,
[copy_name] [varchar](15) NOT NULL,
[copy_type] [binary](1) NULL,
[copy_serial] [binary](4) NULL,
[copy_item] [binary](16) NULL,
[copy_date] [datetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CharPreview](
[Name] [varchar](10) NOT NULL,
[cLevel] [int] NULL,
[Class] [tinyint] NOT NULL,
[Inventory] [varbinary](84) NULL,
CONSTRAINT [PK_CharPreview] PRIMARY KEY CLUSTERED
(
[Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Character](
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NOT NULL,
[cLevel] [int] NULL,
[LevelUpPoint] [int] NULL,
[Class] [tinyint] NULL,
[Experience] [int] NULL,
[Strength] [int] NULL,
[Dexterity] [int] NULL,
[Vitality] [int] NULL,
[Energy] [int] NULL,
[Inventory] [varbinary](3776) NULL,
[MagicList] [varbinary](180) NULL,
[Money] [int] NULL,
[Life] [real] NULL,
[MaxLife] [real] NULL,
[Mana] [real] NULL,
[MaxMana] [real] NULL,
[MapNumber] [smallint] NULL,
[MapPosX] [smallint] NULL,
[MapPosY] [smallint] NULL,
[MapDir] [tinyint] NULL,
[PkCount] [int] NULL,
[PkLevel] [int] NULL,
[PkTime] [int] NULL,
[MDate] [smalldatetime] NULL,
[LDate] [smalldatetime] NULL,
[CtlCode] [tinyint] NULL,
[DbVersion] [tinyint] NULL,
[Quest] [varbinary](50) NULL,
[Leadership] [int] NULL,
[ChatLimitTime] [smallint] NULL,
[FruitPoint] [int] NULL,
[zs_count] [int] NULL,
[ZY] [int] NULL,
[FQBZ] [int] NULL,
[FQCount] [int] NULL,
[FQName] [varchar](10) NULL,
[Resets] [int] NOT NULL,
[mu_id] [int] IDENTITY(1,1) NOT NULL,
[SCFPCPoints] [int] NULL,
[SCFMarried] [int] NOT NULL,
[SCFMarryHusbandWife] [varchar](10) NOT NULL,
[SCFMasterLevel] [int] NOT NULL,
[SCFMasterPoints] [int] NOT NULL,
[SCFMasterSkills] [varbinary](300) NULL,
[SCFCustomQuest] [varbinary](512) NULL,
[SCFGensFamily] [smallint] NOT NULL,
[SCFGensContribution] [int] NOT NULL,
[SCFGensRank] [int] NOT NULL,
[SCFGensDateLeave] [smalldatetime] NULL,
[SCFGensRecvReward] [tinyint] NOT NULL,
[Grand_Resets] [int] NOT NULL,
[SCFMasterSkill] [varbinary](240) NULL,
[SCFExtInventory] [tinyint] NOT NULL,
[SCFUpdatedPShop] [tinyint] NOT NULL,
[SCFSealItem] [int] NOT NULL,
[SCFSealTime] [int] NOT NULL,
[SCFScrollItem] [int] NOT NULL,
[SCFScrollTime] [int] NOT NULL,
[TanThu_CheckCapDo1] [tinyint] NOT NULL,
[TanThu_CheckCapDo2] [tinyint] NOT NULL,
[TanThu_CheckCapDo3] [tinyint] NOT NULL,
[TanThu_CheckCapDo4] [tinyint] NOT NULL,
[TanThu_CheckCapDo5] [tinyint] NOT NULL,
[Day_Reset] [int] NOT NULL,
[Last_Reset] [int] NULL,
[Relifes] [int] NOT NULL,
[Point_UyThac] [int] NOT NULL,
[Status_UyThac] [tinyint] NOT NULL,
[Time_UyThac] [int] NULL,
[PointDuTru] [int] NOT NULL,
[Point_Event_Add] [int] NOT NULL,
[Event_ItemPoint_Type1] [int] NOT NULL,
[Event_ItemPoint_Type2] [int] NOT NULL,
[Event_ItemPoint_Type3] [int] NOT NULL,
[Event_MoneyvsUT_UTType] [int] NOT NULL,
[Event_MoneyvsUT_MoneyType] [int] NOT NULL,
[Event_MoneyvsUT_ItemType] [int] NOT NULL,
[Event_MoneyvsUT_UTType_Day] [int] NOT NULL,
[Event_MoneyvsUT_MoneyType_Day] [int] NOT NULL,
[Event_MoneyvsUT_ItemType_Day] [int] NOT NULL,
[DanhVong_Day] [tinyint] NOT NULL,
[DiemDanhVong] [int] NOT NULL,
[DiemManhTuong] [int] NOT NULL,
[GHRSExtended] [int] NOT NULL,
[QuestUpBack] [tinyint] NOT NULL,
CONSTRAINT [PK_Character] PRIMARY KEY NONCLUSTERED
(
[Name] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ChangeCharacter](
[Col001] [int] NULL,
[Col002] [varchar](10) NULL,
[Col003] [varchar](10) NULL,
[Col004] [varchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BotPet](
[AccountID] [varchar](10) NOT NULL,
[Name] [nvarchar](10) NOT NULL,
[cLevel] [int] NOT NULL,
[Class] [tinyint] NULL,
[Experience] [bigint] NULL,
[Power] [smallint] NULL,
[Defense] [smallint] NULL,
[Inventory] [varbinary](1728) NULL,
[MagicList] [varbinary](180) NULL,
[Life] [real] NOT NULL,
[MaxLife] [real] NOT NULL,
[Mana] [real] NOT NULL,
[MaxMana] [real] NOT NULL,
[MapNumber] [smallint] NULL,
[MapPosX] [smallint] NULL,
[MapPosY] [smallint] NULL,
[CDate] [smalldatetime] NULL,
[BotLife] [int] NOT NULL,
[BotMaxLife] [int] NOT NULL,
[BotLvlUpDefense] [int] NOT NULL,
[BotLvlUpPower] [int] NOT NULL,
[BotLvlUpLife] [int] NOT NULL,
[BotLvlUpMana] [int] NOT NULL,
[BotLvlUpExp] [int] NOT NULL,
[BotLvlUpMaxLevel] [int] NOT NULL,
[BotVersion] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BLOCKING_LOG](
[appl_days] [datetime] NOT NULL,
[admin_guid] [int] NOT NULL,
[block_guid] [int] NOT NULL,
[dist_code] [char](2) NOT NULL,
[admin_name] [varchar](50) NOT NULL,
CONSTRAINT [PK_BLOCKING_LOG] PRIMARY KEY CLUSTERED
(
[appl_days] DESC,
[admin_guid] DESC,
[dist_code] DESC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BLOCKING](
[block_guid] [int] IDENTITY(1,1) NOT NULL,
[memb_guid] [int] NOT NULL,
[serv_guid] [int] NOT NULL,
[char_name] [varchar](20) NULL,
[take_code] [char](1) NOT NULL,
[take_cont] [varchar](1000) NOT NULL,
[memb_cont] [varchar](2000) NULL,
[appl_days] [char](8) NOT NULL,
[rels_days] [char](8) NOT NULL,
[ctl1_code] [char](1) NOT NULL,
CONSTRAINT [PK_BLOCKING] PRIMARY KEY CLUSTERED
(
[block_guid] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BK_warehouse](
[AccountID] [varchar](10) NOT NULL,
[Items] [varbinary](1200) NULL,
[Money] [int] NULL,
[EndUseDate] [smalldatetime] NULL,
[DbVersion] [tinyint] NULL,
[pw] [smallint] NULL,
CONSTRAINT [PK_BK_warehouse] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BK_AccountCharacter](
[Number] [int] NOT NULL,
[Id] [varchar](10) NOT NULL,
[GameID1] [varchar](10) NULL,
[GameID2] [varchar](10) NULL,
[GameID3] [varchar](10) NULL,
[GameID4] [varchar](10) NULL,
[GameID5] [varchar](10) NULL,
[GameIDC] [varchar](10) NULL,
CONSTRAINT [PK_BK_AccountCharacter] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BFB_SBK](
[ServerID] [int] NOT NULL,
[IDX] [int] NOT NULL,
[GuildName] [varchar](50) NULL,
[GuildTT] [varchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BFB_INFO](
[ServerID] [int] NOT NULL,
[Money] [float] NOT NULL,
[Cents] [int] NOT NULL,
[LastPayDay] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Back_T_CGuid](
[GUID] [int] NOT NULL,
[Name] [varchar](10) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Back_OptionData](
[Name] [varchar](10) NOT NULL,
[SkillKey] [binary](10) NULL,
[GameOption] [tinyint] NULL,
[Qkey] [tinyint] NULL,
[Wkey] [tinyint] NULL,
[Ekey] [tinyint] NULL,
[ChatWindow] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Back_AccountCharacter](
[Number] [int] NOT NULL,
[Id] [varchar](10) NOT NULL,
[GameID1] [varchar](10) NULL,
[GameID2] [varchar](10) NULL,
[GameID3] [varchar](10) NULL,
[GameID4] [varchar](10) NULL,
[GameID5] [varchar](10) NULL,
[GameIDC] [varchar](10) NULL,
[MoveCnt] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[AutoGMGG](
[ID] [int] NOT NULL,
[Valid] [int] NOT NULL,
[SvrID] [int] NOT NULL,
[Type] [int] NOT NULL,
[BeginTM] [smalldatetime] NOT NULL,
[EndTM] [smalldatetime] NOT NULL,
[DispJG] [int] NOT NULL,
[WorkMINU] [int] NOT NULL,
[LoopMINU] [int] NOT NULL,
[Notice] [varchar](200) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[AllItemsLog](
[items_id] [int] IDENTITY(1,1) NOT NULL,
[items_type] [binary](1) NOT NULL,
[items_serial] [binary](4) NOT NULL,
[items_acid] [varchar](10) NOT NULL
) ON [PRIMARY]
GO