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