use muonline
----------------------创建冰风堡申请表------------------------
CREATE TABLE [BFB_SQ] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[memb___id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ServerID] [int] NOT NULL CONSTRAINT [DF_BFB_SQ_SeverID] DEFAULT (0),
[Guildname] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GuildTT] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SQJF] [int] NULL CONSTRAINT [DF_BFB_SQ_SQJF] DEFAULT (0)
) ON [PRIMARY]
GO
----------------更新增加冰风攻城时间字段--------------------------------
ALTER TABLE BFB_SBK ADD StatDAY datetime not null default '2015-9-15'
go