ddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
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 = 3)
INSERT INTO Sp_About(,) VALUES (3 ,'')
if not exists (select 1 from Sp_About where = 4)
INSERT INTO Sp_About(,) VALUES (4 ,'')
if not exists (select 1 from Sp_About where = 5)
INSERT INTO Sp_About(,) VALUES (5 ,'')
go
楼主太棒了 ，，，谢谢啊。。。。。。真是太好了！