if not exists (select 1 from syscolumns where name = 'member' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add member int DEFAULT (0)
if not exists (select 1 from syscolumns where name = 'LGONGZHISJ' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add LGONGZHISJ datetime DEFAULT ('')
if not exists (select 1 from syscolumns where name = 'StopTime' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add StopTime datetime DEFAULT ('')
if not exists (select 1 from syscolumns where name = 'OnlineHours' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add OnlineHours int DEFAULT (0)
if not exists (select 1 from syscolumns where name = 'LeaderShip' and id = object_id('Character'))
alter table Character
add LeaderShip smallint DEFAULT (0)
if not exists (select 1 from syscolumns where name = 'ChatLimitTime' and id = object_id('Character'))
alter table Character
add ChatLimitTime smallint DEFAULT (0)
if not exists (select 1 from syscolumns where name = 'FruitPoint' and id = object_id('Character'))
alter table Character
add FruitPoint int DEFAULT (0)
use MuWeb
go
if not exists (select 1 from Sp_About where [type] = 3)
INSERT INTO Sp_About([type],[contact]) VALUES (3 ,'')
if not exists (select 1 from Sp_About where [type] = 4)
INSERT INTO Sp_About([type],[contact]) VALUES (4 ,'')
if not exists (select 1 from Sp_About where [type] = 5)
INSERT INTO Sp_About([type],[contact]) VALUES (5 ,'')
go |