JETSQL

ALTER TABLE [Bigclass] ADD
NewsTC int NULL,
HotNews int NULL,
HotNewsTC int NULL,
HotNewsTP nvarchar(50) NULL,
RecommendNews int NULL,
RecommendNewsTC int NULL,
RecommendNewsTP nvarchar(200) NULL,
LastNews int NULL,
LastNewsTC int NULL,
LastNewsTP nvarchar(200) NULL,
ShowClickCount bit NULL,
ShowDate bit NULL

update [Bigclass] set [HotNews] = 10 , [HotNewsTC] = 10 , [RecommendNews] = 10 , [RecommendNewsTC] = 10 , [LastNews] = 10 , [LastNewsTC] = 10

ALTER TABLE [SmallClass] ADD
TitleNumber int NULL,
DateType nvarchar(255) NULL

ALTER TABLE [news] ADD
auditing bit NULL
DelDate datetime NULL

ALTER TABLE [Config] ADD
ShowPic nvarchar(50) NULL,
WordNumber int NULL,
LastNews int NULL,
LNTitle nvarchar(255) NULL,
RegisterNumber nvarchar(255) NULL,
UpdateNO nvarchar(50) NULL

update [config] set wordNumber = 10000 , LastNews = 10 where 1

CREATE TABLE SourceManage(
SourceID int NOT NULL IDENTITY ,
SourceName nvarchar(250) NULL,
SourceUrl ntext NULL
)

CREATE TABLE notice(
idSourceID int NOT NULL IDENTITY ,
active bit Ture,
startdate datetime NULL,
enddate datetime NULL,
url nvarchar(255) NULL,
content ntext NULL,
loc nvarchar(255) NULL
)