CREATE TABLE [dbo].[DZEN] (
[accountid] [char] (10) COLLATE Korean_Wansung_CI_AS NULL ,
[mathe] [nvarchar] (14) COLLATE Korean_Wansung_CI_AS NULL ,
[soserial] [nvarchar] (14) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[ngaydangky] [datetime] NULL ,
[sodzen] [int] NULL ,
[nickchat] [nvarchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[ghichu] [nvarchar] (1000) COLLATE Korean_Wansung_CI_AS NULL ,
[loaithe] [nchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[menhgia] [nchar] (50) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_CREDITS] (
[memb___id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[credits] [int] NOT NULL ,
[ngaybatdau] [datetime] NULL ,
[ngayketthuc] [datetime] NULL ,
[thoigianvip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Priserver] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[db_nv] (
[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tennv] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[dbcharacter] (
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[reset] [int] NULL ,
[vip] [int] NULL ,
[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[relife] [int] NULL ,
[class] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[dbrs] (
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[reset] [int] NULL ,
[vip] [int] NULL ,
[thoigian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[dbthe] (
[id] [int] NULL ,
[mathe] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[serial] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[menhgia] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[loaithe] [int] NULL ,
[ngaynap] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[kt] [int] NULL ,
[login] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lydo] [int] NULL ,
[hoicham] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[xoso] (
[stt] [int] IDENTITY (1, 1) NOT NULL ,
[accountid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[dzen] [int] NULL ,
[so3] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[so2] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[so1] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[ngaydat] [datetime] NULL ,
[ketqua] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ngayxo] [datetime] NULL
) ON [PRIMARY]
GO
alter table dbo.character add SCFPCPoints money NULL default 0;
alter table dbo.character add reset int NULL default 0;
alter table dbo.character add relife int NULL default 0;
alter table dbo.character add nn varchar(50) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.character add tmrs int NULL default 0;
alter table dbo.character add rsthang int NULL default 0;
alter table dbo.character add timeendvip int NULL default 0;
alter table dbo.character add timevip int NULL default 0;
alter table dbo.character add vip int NULL default 0;
alter table dbo.character add avatar varchar(1000) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.character add duatop int NULL default 0;
alter table dbo.character add lifepoint int NULL default 0;
alter table dbo.character add dt int NULL default 0;
alter table dbo.character add auto1 varchar(50) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.character add auto2 varchar(50) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.character add auto varchar(50) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.character add autolv int NULL default 0;
alter table dbo.character add songaydangkyvip int NULL default 0;
alter table dbo.character add ngaydangkyvip datetime NULL default 0;
alter table dbo.character add ngayketthucvip datetime NULL default 0;
alter table dbo.character add ngayuythac datetime NULL default 0;
alter table dbo.character add uythac int NOT NULL default 0;
alter table dbo.character add dzen int NULL default 0;
alter table dbo.MEMB_INFO add bank bigint NOT NULL default 0;
alter table dbo.MEMB_INFO add money_vnd bigint NOT NULL default 0;
alter table dbo.MEMB_INFO add total_amount bigint NOT NULL default 0;
alter table dbo.MEMB_INFO add block_time varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL default 0;
alter table dbo.MEMB_INFO add last_visit varchar(100) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.MEMB_INFO add skin varchar(50) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.MEMB_INFO add lang varchar(50) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.MEMB_INFO add admin int NULL default 0;
alter table dbo.MEMB_INFO add id_nv int NULL default 0;
alter table dbo.MEMB_INFO add hoanthanh int NULL default 0;
alter table dbo.MEMB_INFO add dahoanthanh int NULL default 0;
alter table dbo.MEMB_INFO add tuochieu int NULL default 0;
alter table dbo.MEMB_INFO add lydo int NULL default 0;
alter table dbo.MEMB_INFO add tien int NULL default 0;
alter table dbo.MEMB_INFO add usdbank int NULL default 0;
alter table dbo.MEMB_INFO add zenbank int NULL default 0;
alter table dbo.MEMB_INFO add lydobl varchar(50) COLLATE Chinese_PRC_CI_AS NULL default 0;
alter table dbo.MEMB_INFO add SCFMasterLevel int NULL default 0;
alter table dbo.MEMB_INFO add SCFMasterPoints int NULL default 0;
alter table dbo.MEMB_INFO add SCFMasterSkills varbinary(50) NULL
