Xin query nwebmu 5.13 full

[loveoggy]

Ai còn giữ cho e xin với .Cảm ơn .
query_install.sql

[vodkacb]

Copy all querry này rồi paste vào và chạy đợi vài phút là xong

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character_back]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Character_back];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Card_Vpoint]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Card_Vpoint];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CardPhone]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CardPhone];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DoanhThu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DoanhThu];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Check_Action]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Check_Action];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_TOP_RS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_TOP_RS];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_TOP_Point]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_TOP_Point];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_TOP_Card]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_TOP_Card];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PassRan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PassRan];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Invite];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Log_TienTe]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Log_TienTe];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bongda_giaidau]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bongda_giaidau];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bongda_tran]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bongda_tran];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bongda_dudoankq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bongda_dudoankq];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[IPBonus]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IPBonus];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[IPBonus_acc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IPBonus_acc];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dupe_Scan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Dupe_Scan];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dupe_Scan_Online]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Dupe_Scan_Online];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dupe_Online]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Dupe_Online];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[item_vpoint_changed]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[item_vpoint_changed];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EventEpItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[EventEpItem];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ItemLock]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ItemLock];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopReset]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TopReset];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopResetScore]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TopResetScore];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGiaNguoc_Item]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGiaNguoc_Item];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGiaNguoc_Bid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGiaNguoc_Bid];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGiaNguoc_TheHe]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGiaNguoc_TheHe];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[daugia_dudoankq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[daugia_dudoankq];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[daugia_tran]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[daugia_tran];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[daugia_giaidau]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[daugia_giaidau];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_QWEBMU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_QWEBMU];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character_Top1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Character_Top1];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[quaysomienphi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[quaysomienphi];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GiftCode]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[GiftCode];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GiftLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[GiftLog];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Log_chuyensv]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Log_chuyensv];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OnePassDay]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[OnePassDay];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NBB_Award]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[NBB_Award];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SMS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[SMS];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGia_Item]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGia_Item];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGia_Bid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGia_Bid];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ChoTroi_Item]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ChoTroi_Item];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ChoTroi_Bid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ChoTroi_Bid];
CREATE TABLE [dbo].[Card_Vpoint] (
[stt] [int] NOT NULL ,
[accdl] [varchar] (20) NULL ,
[menhgia] [int] NULL ,
[card_num] [varchar] (20) NULL ,
[card_serial] [varchar] (20) NULL ,
[time_create] [int] NULL ,
[accused] [varchar] (20) NULL ,
[time_nap] [int] NULL ,
[status] [tinyint] NULL
) ON [PRIMARY];
CREATE TABLE [Character_back] (
[AccountID] [varchar] (10) NOT NULL ,
[Name] [varchar] (10) NOT NULL ,
[LevelUpPoint] [int] NULL DEFAULT (0),
[Class] [tinyint] NULL ,
[Leadership] [smallint] NULL DEFAULT (0),
[Resets] [int] NOT NULL DEFAULT (0),
[Relifes] [int] NOT NULL DEFAULT (0),
[NoResetInDay] [int] NOT NULL DEFAULT (0),
[NoResetInMonth] [int] NOT NULL DEFAULT (0),
[PointUyThac] [int] NOT NULL DEFAULT (0),
[point_event] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [CardPhone] (
[stt] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[Name] [varchar] (10) NULL ,
[menhgia] [int] NULL ,
[card_type] [varchar] (20) NULL ,
[card_num] [varchar] (20) NULL ,
[card_num_md5] [varchar] (32) NULL ,
[card_serial] [varchar] (20) NULL ,
[ngay] [smalldatetime] NULL ,
[status] [tinyint] NOT NULL DEFAULT (0) ,
[addvpoint] [varchar] (20) NULL ,
[timenap] [int] NULL ,
[timeduyet] [int] NULL ,
[teknet_check_wait] [tinyint] NOT NULL DEFAULT (0),
[teknet_check_last] [int] NULL
) ON [PRIMARY];
CREATE TABLE [DoanhThu] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[year] [int] NOT NULL DEFAULT (2008),
[month] [int] NOT NULL DEFAULT (1),
[money] [int] NOT NULL DEFAULT (0),
[card_type] [varchar] (20) NULL
) ON [PRIMARY];
CREATE TABLE [Check_Action] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[action] [varchar] (20) NULL ,
[time] [int] NOT NULL DEFAULT (0),
[status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [Event_TOP_RS] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[name] [varchar] (20) NULL ,
[resets] [int] NOT NULL DEFAULT (0),
[reset_score] [int] NOT NULL DEFAULT (0) ,
[time] [smalldatetime] NOT NULL DEFAULT (2013-01-01)
) ON [PRIMARY];
CREATE TABLE [Event_TOP_Point] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[name] [varchar] (20) NULL ,
[points] [int] NOT NULL DEFAULT (0),
[slg] [int] NOT NULL DEFAULT (0) ,
[type] [tinyint] NOT NULL DEFAULT (1) ,
[time] [smalldatetime] NOT NULL DEFAULT (2013-01-01)
) ON [PRIMARY];
CREATE TABLE [Event_TOP_Card] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[gcoin] [bigint] NOT NULL DEFAULT (0),
[time] [smalldatetime] NOT NULL DEFAULT (2013-01-01)
) ON [PRIMARY];
CREATE TABLE [PassRan] (
[acc] [varchar] (10) NULL ,
[pass] [varchar] (10) NULL,
[pass_md5] [varchar] (50) NULL
) ON [PRIMARY];
CREATE TABLE [Invite] (
[acc_invite] [varchar] (10) NOT NULL ,
[acc_accept] [varchar] (10) NOT NULL ,
[time_invite] [int] NOT NULL DEFAULT (0) ,
[vpoint_invite] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [Log_TienTe] (
[acc] [varchar] (10) NOT NULL,
[gcoin] [int] DEFAULT (0),
[gcoin_km] [int] DEFAULT (0),
[vpoint] [int] DEFAULT (0),
[price] [nvarchar] (250),
[Des] [ntext],
[time] [int] DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [bongda_giaidau] (
[giai_id] [int] identity Primary Key NOT NULL ,
[giai_name] [nvarchar] (200) NOT NULL ,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY];
CREATE TABLE [bongda_tran] (
[tran_id] [int] identity Primary Key NOT NULL ,
[tran_doi1] [nvarchar] (200) NOT NULL ,
[tran_doi2] [nvarchar] (200) NOT NULL ,
[giai_id] [int] DEFAULT(0) ,
[tran_kq1] [smallint] DEFAULT (0),
[tran_kq2] [smallint] DEFAULT (0),
[time] [int] NOT NULL,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY];
CREATE TABLE [bongda_dudoankq] (
[dudoan_id] [int] identity Primary Key NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[tran_id] [int] DEFAULT(0) ,
[dudoan_kq] [smallint] NOT NULL ,
[dudoan_slg] [int] NOT NULL DEFAULT (0),
[time] [int] NOT NULL,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY];
CREATE TABLE [IPBonus] (
[ipbonus_id] [int] identity Primary Key NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[ip] [varchar] (50) NOT NULL ,
[InternetName] [nvarchar] (200) NOT NULL ,
[Address] [nvarchar] (250) NOT NULL,
[QuanHuyen] [nvarchar] (100) NOT NULL,
[ThanhPho] [nvarchar] (100) NOT NULL,
[totalacc] [int] NOT NULL DEFAULT(0)
) ON [PRIMARY];
CREATE TABLE [IPBonus_acc] (
[ipbonus_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
CONSTRAINT pk_IPBonus_acc PRIMARY KEY (ipbonus_id,acc)
) ON [PRIMARY];
CREATE TABLE [Dupe_Scan] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[vitri] [tinyint] NOT NULL DEFAULT(0),
[isdupe] [tinyint] NOT NULL DEFAULT(0),
CONSTRAINT uc_DupeScan UNIQUE (acc,name,seri,vitri)
) ON [PRIMARY];
CREATE TABLE [Dupe_Scan_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[vitri] [tinyint] NOT NULL DEFAULT(0),
[isdupe] [tinyint] NOT NULL DEFAULT(0),
CONSTRAINT uc_DupeScanOnline UNIQUE (acc,name,seri,vitri)
) ON [PRIMARY];
CREATE TABLE [Dupe_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[vitri] [tinyint] NOT NULL DEFAULT(0),
[time] [int] NULL,
CONSTRAINT uc_DupeScanDupeOnline UNIQUE (acc,name,seri,vitri)
) ON [PRIMARY];
CREATE TABLE [item_vpoint_changed] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[itemtype] [varchar] (50) NULL ,
[seri] [varchar] (8) NOT NULL ,
[value] [int] NOT NULL DEFAULT(0),
[time] [int] NULL,
CONSTRAINT uc_item_vpoint_changed UNIQUE (acc,name,seri)
) ON [PRIMARY];
CREATE TABLE [EventEpItem] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[item] [varchar] (32) NOT NULL ,
[seri] [varchar] (8) NOT NULL ,
[lvl] [tinyint] NOT NULL ,
[image] [varchar] (255) NULL ,
[time_reg] [int] NOT NULL ,
[info] [text] NULL ,
[time_finish] [int] NULL ,
[infoend] [text] NULL ,
[status] [tinyint] NOT NULL DEFAULT 0
) ON [PRIMARY];
CREATE TABLE [ItemLock] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[item] [varchar] (32) NOT NULL ,
[seri] [varchar] (8) NOT NULL ,
[lvl] [tinyint] NOT NULL ,
[image] [varchar] (255) NULL ,
[info] [text] NULL ,
[time] [int] NOT NULL,
[status] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [OnePassDay] (
[acc] [varchar] (10) NOT NULL ,
[opd] [varchar] (32) NOT NULL ,
[time] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [SMS] (
[acc] [varchar] (20) NOT NULL ,
[KeyXuLy] [varchar] (20) NOT NULL ,
[time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (0),
[Code] [int] NOT NULL DEFAULT (0),
[dulieu1] [varchar] (50) NULL ,
[dulieu2] [varchar] (50) NULL ,
[dulieu3] [varchar] (50) NULL ,
[dulieu4] [varchar] (50) NULL ,
[dulieu5] [varchar] (50) NULL
) ON [PRIMARY];
CREATE TABLE [TopReset] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[reset] [int] NOT NULL DEFAULT(1) ,
[year] [int] NOT NULL DEFAULT(2012) ,
[month] [tinyint] NOT NULL DEFAULT(1) ,
[week] [tinyint] NOT NULL DEFAULT(1) ,
[day] [tinyint] NOT NULL DEFAULT(1) ,
[time] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [TopResetScore] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[reset_score] [bigint] NOT NULL DEFAULT(1) ,
[year] [int] NOT NULL DEFAULT(2012) ,
[month] [tinyint] NOT NULL DEFAULT(1) ,
[week] [tinyint] NOT NULL DEFAULT(1) ,
[day] [tinyint] NOT NULL DEFAULT(1) ,
[time] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [DauGiaNguoc_Item] (
[bid_id] [int] IDENTITY (1, 1) NOT NULL ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[price_min] [int] NOT NULL DEFAULT (0) ,
[bid_mod] [int] NOT NULL DEFAULT (0) ,
[time_begin] [int] NOT NULL DEFAULT (0) ,
[time_end] [int] NOT NULL DEFAULT (0) ,
[bid_status] [tinyint] NOT NULL DEFAULT (1),
[reward_status] [tinyint] NOT NULL DEFAULT (0),
[reward_time] [int] NULL
) ON [PRIMARY];
CREATE TABLE [DauGiaNguoc_Bid] (
[bid_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[bid_vpoint] [int] NOT NULL DEFAULT (0) ,
[bid_time] [int] NOT NULL DEFAULT (0) ,
[win] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [DauGiaNguoc_TheHe] (
[bid_id] [int] NOT NULL ,
[thehe] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [DauGia_Item] (
[bid_id] [int] IDENTITY (1, 1) NOT NULL ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[item_group] [tinyint] NOT NULL ,
[price_min] [int] NOT NULL DEFAULT (100) ,
[price_max] [int] NOT NULL DEFAULT (200) ,
[bid_end] [int] NOT NULL ,
[acc_own] [varchar] (10) NOT NULL ,
[char_own] [varchar] (10) NOT NULL ,
[bid_status] [tinyint] NOT NULL DEFAULT (1),
[reward_status] [tinyint] NOT NULL DEFAULT (0),
[reward_time] [int] NULL
) ON [PRIMARY];
CREATE TABLE [DauGia_Bid] (
[bid_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[bid_vpoint] [int] NOT NULL DEFAULT (0) ,
[bid_time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [ChoTroi_Item] (
[bid_id] [int] IDENTITY (1, 1) NOT NULL ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[item_group] [tinyint] NOT NULL ,
[price_max] [int] NOT NULL DEFAULT (200) ,
[bid_end] [int] NOT NULL ,
[acc_own] [varchar] (10) NOT NULL ,
[char_own] [varchar] (10) NOT NULL ,
[bid_status] [tinyint] NOT NULL DEFAULT (1),
[reward_status] [tinyint] NOT NULL DEFAULT (0),
[reward_time] [int] NULL
) ON [PRIMARY];
CREATE TABLE [ChoTroi_Bid] (
[bid_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[bid_vpoint] [int] NOT NULL DEFAULT (0) ,
[bid_time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [dbo].[daugia_dudoankq] (
[dudoan_id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[daugia_id] [int] NULL ,
[dudoan_kq] [smallint] NOT NULL ,
[dudoan_slg] [int] NOT NULL ,
[time] [int] NOT NULL ,
[status] [tinyint] NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[daugia_tran] (
[daugia_id] [int] IDENTITY (1, 1) NOT NULL ,
[daugia_doi1] [nvarchar] (200) NOT NULL ,
[daugia_doi2] [nvarchar] (200) NOT NULL ,
[giai_id] [int] NULL ,
[daugia_kq1] [smallint] NULL ,
[daugia_kq2] [smallint] NULL ,
[time] [int] NOT NULL ,
[status] [tinyint] NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[daugia_giaidau] (
[giai_id] [int] IDENTITY (1, 1) NOT NULL ,
[giai_name] [nvarchar] (200) NOT NULL ,
[status] [tinyint] NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[Event_QWEBMU] (
[event_id ] [int] NOT NULL ,
[event_name] [nvarchar] (100) NOT NULL ,
[event_image] [varchar] (20) NULL ,
[event_des] [nvarchar] (2000) NULL ,
[event_level] [varchar] (10) NOT NULL ,
[item_event] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[event_award] [tinyint] NOT NULL DEFAULT (0),
[event_point] [int] NOT NULL DEFAULT (0),
[event_status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[Character_Top1] (
[name] [varchar] (50) NOT NULL ,
[resets] [int] NOT NULL DEFAULT (0),
[NoResetInDay] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[quaysomienphi] (
[STT] [int] IDENTITY (1, 1) NOT NULL ,
[AccountID] [nvarchar] (50) NOT NULL ,
[Socap_Free] [int] NOT NULL DEFAULT (0),
[Trungcap_Free] [int] NOT NULL DEFAULT (0),
[Caocap_Free] [int] NOT NULL DEFAULT (0),
[Sieucap_Free] [int] NOT NULL DEFAULT (0),
[No_nv_rs_50] [int] NOT NULL DEFAULT (0),
[No_nv_rs_100] [int] NOT NULL DEFAULT (0),
[No_nv_rs_200] [int] NOT NULL DEFAULT (0),
) ON [PRIMARY];
CREATE TABLE [NBB_Award] (
[award_id] [int] IDENTITY (1, 1) NOT NULL ,
[award_info] [varchar] (250) NULL ,
[item_slg] [tinyint] NOT NULL DEFAULT (1) ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[seri_block] [tinyint] NOT NULL DEFAULT (0),
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[status] [tinyint] NOT NULL DEFAULT (0),
[create_time] [int] NULL,
[receive_time] [int] NULL,
[hsd_time] [int] NULL,
[thuhoi] [tinyint] NULL
) ON [PRIMARY];
CREATE TABLE [GiftCode] (
[gift_code] [varchar] (10) NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[reset] [int] NULL ,
[type] [tinyint] NOT NULL DEFAULT(0) ,
[gift_time] [int] NOT NULL ,
[gift_timeuse] [int] NULL ,
[ngay] [smalldatetime] NOT NULL ,
[status] [tinyint] NOT NULL DEFAULT(0)
) ON [PRIMARY]
CREATE TABLE [GiftLog] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[reset] [int] NULL ,
[type] [tinyint] NOT NULL DEFAULT(0) ,
[time] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [Log_chuyensv] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (10) NOT NULL,
[char] [varchar] (10) NOT NULL,
[accnew] [varchar] (10) NOT NULL,
[charnew] [varchar] (10) NOT NULL
) ON [PRIMARY];
INSERT INTO Check_Action (action) VALUES ('ResetInDay');
INSERT INTO Check_Action (action) VALUES ('ResetInMonth');
INSERT INTO Check_Action (action) VALUES ('Top50');
INSERT INTO Character_Top1 (name) VALUES ('QWEBMU');