Data + Query NBB 3.0
Bạn tải tại đây: DB_GameZoneNBB3.0 (<b><font color=red>[Chỉ có thành viên mới xem link được. <a href="register.php"> Nhấp đây để đăng ký thành viên......</a>]</font></b>)
Sau khi Add DB vào bạn chạy Query sau:
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_serial] [varchar] (20) NULL ,
[ngay] [smalldatetime] NULL ,
[status] [tinyint] NULL ,
[addvpoint] [varchar] (20) NULL ,
[timenap] [int] NULL,
[timeduyet] [int] NULL
) ON [PRIMARY]
GO
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]
GO
CREATE TABLE [TopMonth] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[stt] [int] NOT NULL DEFAULT (0) ,
[acc] [varchar] (20) NULL ,
[Name] [varchar] (10) NULL ,
[resets] [int] NOT NULL DEFAULT (0),
[Month] [int] NOT NULL DEFAULT (0) ,
[Year] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO
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]
GO
INSERT INTO Check_Action (action) VALUES ('ResetInDay')
INSERT INTO Check_Action (action) VALUES ('ResetInMonth')
INSERT INTO Check_Action (action) VALUES ('Top10RS')
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 ,
) ON [PRIMARY]
GO
CREATE TABLE [PassRan] (
[acc] [varchar] (10) NULL ,
[pass] [varchar] (10) NULL,
[pass_md5] [varchar] (50) NULL
) ON [PRIMARY]
GO
alter table MEMB_INFO add bank bigint NOT NULL default 0;
alter table MEMB_INFO add vpoint bigint NOT NULL default 0
alter table MEMB_INFO add gcoin bigint NOT NULL default 0
alter table MEMB_INFO add memb__pwd2 char(10)
alter table MEMB_INFO add memb__pwdmd5 char(50)
alter table MEMB_INFO add pass2 char(10)
alter table MEMB_INFO add jewel_chao int not null default 0
alter table MEMB_INFO add jewel_cre int not null default 0
alter table MEMB_INFO add jewel_blue int not null default 0
alter table MEMB_INFO add passran tinyint not null default 0
alter table MEMB_INFO add checklogin varchar(50) null
alter table MEMB_INFO add time_checksms int not null default 0
alter table MEMB_INFO add checksms_status tinyint not null default 0
alter table MEMB_INFO add admin_block tinyint not null default 0
alter table Character add Resets int not null default 0
alter table Character add ResetVIP int not null default 0
alter table Character add Resets_Time int not null default 0
alter table Character add NoResetInDay int not null default 0
alter table Character add NoResetInMonth int not null default 0
alter table Character add Relifes int not null default 0
alter table Character add khoado tinyint not null default 0
alter table Character add makhoado varchar(50)
alter table Character add pointdutru int not null default 0
Chúc bạn thành công!