ljez.sql

庐江二中

GO

CREATE TABLE [dbo].[UserGrade] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserLevel] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[LevelPoint] [int] NULL ,
	[LimitPoint] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[gstbook] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[datetime] [datetime] NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[NewsID] [int] NULL ,
	[BigClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BigClassType] [int] NULL ,
	[SmallClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SmallClassType] [int] NULL ,
	[SpecialName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Replay] [int] NULL ,
	[ip] [char] (15) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[research] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[select1] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer1] [int] NULL ,
	[select2] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer2] [int] NULL ,
	[select3] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer3] [int] NULL ,
	[select4] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer4] [int] NULL ,
	[select5] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer5] [int] NULL ,
	[select6] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer6] [int] NULL ,
	[select7] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer7] [int] NULL ,
	[select8] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer8] [int] NULL ,
	[DateAndTime] [datetime] NOT NULL ,
	[IsChecked] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[users] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Email] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Password] [varchar] (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Sign] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[addDate] [datetime] NOT NULL ,
	[LoginIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[logins] [int] NOT NULL ,
	[UserPoint] [int] NOT NULL ,
	[UserLevel] [int] NOT NULL ,
	[LimitPoint] [int] NOT NULL ,
	[ReadNews] [int] NOT NULL ,
	[SendNews] [int] NOT NULL ,
	[Replay] [int] NOT NULL ,
	[WGBooks] [int] NOT NULL ,
	[UserWebName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserWebUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Oicq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lastlogin] [datetime] NULL ,
	[lockuser] [bit] NOT NULL ,
	[ischecked] [bit] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Ad] WITH NOCHECK ADD 
	CONSTRAINT [PK_Ad] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Admin] WITH NOCHECK ADD 
	CONSTRAINT [PK_Admin] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AllySite] WITH NOCHECK ADD 
	CONSTRAINT [PK_AllySite] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Announce] WITH NOCHECK ADD 
	CONSTRAINT [PK_Announce] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[BigClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_BigClass] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Const] WITH NOCHECK ADD 
	CONSTRAINT [PK_Const] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Counters] WITH NOCHECK ADD 
	CONSTRAINT [PK_Counters] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[FriendSite] WITH NOCHECK ADD 
	CONSTRAINT [PK_FriendSite] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Menu] WITH NOCHECK ADD 
	CONSTRAINT [PK_Menu] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[News] WITH NOCHECK ADD 
	CONSTRAINT [PK_News] PRIMARY KEY  CLUSTERED 
	(
		[NewsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SiteColor] WITH NOCHECK ADD 
	CONSTRAINT [PK_SiteColor] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SmallClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_SmallClass] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Special] WITH NOCHECK ADD 
	CONSTRAINT [PK_Special] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[UserGrade] WITH NOCHECK ADD 
	CONSTRAINT [PK_UserGrade] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[gstbook] WITH NOCHECK ADD 
	CONSTRAINT [PK_gstbook] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[research] WITH NOCHECK ADD 
	CONSTRAINT [PK_research] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[users] WITH NOCHECK ADD 
	CONSTRAINT [PK_users] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Ad] WITH NOCHECK ADD 
	CONSTRAINT [DF_Ad_Adwidth] DEFAULT (0) FOR [Adwidth],
	CONSTRAINT [DF_Ad_Adheight] DEFAULT (0) FOR [Adheight],
	CONSTRAINT [DF_Ad_IsFlash] DEFAULT (0) FOR [IsFlash],
	CONSTRAINT [DF_Ad_beginday] DEFAULT (getdate()) FOR [beginday],
	CONSTRAINT [DF_Ad_yesterday] DEFAULT (0) FOR [yesterday],
	CONSTRAINT [DF_Ad_today] DEFAULT (0) FOR [today],
	CONSTRAINT [DF_Ad_totalclick] DEFAULT (0) FOR [totalclick],
	CONSTRAINT [DF_Ad_checked] DEFAULT (0) FOR [checked]
GO

ALTER TABLE [dbo].[Announce] WITH NOCHECK ADD 
	CONSTRAINT [DF_Announce_Popup] DEFAULT (0) FOR [Popup],
	CONSTRAINT [DF_Announce_board] DEFAULT (0) FOR [board],
	CONSTRAINT [DF_Announce_DateAndTime] DEFAULT (getdate()) FOR [DateAndTime],
	CONSTRAINT [DF_Announce_IsChecked] DEFAULT (0) FOR [IsChecked]
GO

ALTER TABLE [dbo].[BigClass] WITH NOCHECK ADD 
	CONSTRAINT [DF_BigClass_BigClassView] DEFAULT (0) FOR [BigClassView],
	CONSTRAINT [DF_BigClass_BigClassType] DEFAULT (0) FOR [BigClassType]
GO

ALTER TABLE [dbo].[Const] WITH NOCHECK ADD 
	CONSTRAINT [DF_Const_MaxList] DEFAULT (20) FOR [MaxList],
	CONSTRAINT [DF_Const_MaxNewsList] DEFAULT (10) FOR [MaxNewsList],
	CONSTRAINT [DF_Const_MaxFocusNewsList] DEFAULT (10) FOR [MaxFocusNewsList],
	CONSTRAINT [DF_Const_MaxGoodNewsList] DEFAULT (10) FOR [MaxGoodNewsList],
	CONSTRAINT [DF_Const_MaxTxtList] DEFAULT (10) FOR [MaxTxtList],
	CONSTRAINT [DF_Const_FenTitle] DEFAULT (3) FOR [FenTitle],
	CONSTRAINT [DF_Const_MaxTxtListDate] DEFAULT (30) FOR [MaxTxtListDate],
	CONSTRAINT [DF_Const_InDate] DEFAULT (6) FOR [InDate],
	CONSTRAINT [DF_Const_MaxImgList] DEFAULT (3) FOR [MaxImgList],
	CONSTRAINT [DF_Const_MaxSpecialList] DEFAULT (5) FOR [MaxSpecialList],
	CONSTRAINT [DF_Const_ShowNewImg] DEFAULT (1) FOR [ShowNewImg],
	CONSTRAINT [DF_Const_WebTitle] DEFAULT (N'安徽省庐江第二中学') FOR [WebTitle],
	CONSTRAINT [DF_Const_WebUrl] DEFAULT (N'default.asp') FOR [WebUrl],
	CONSTRAINT [DF_Const_Logo] DEFAULT (N'images/link/logo.gif') FOR [Logo],
	CONSTRAINT [DF_Const_ShowBoard] DEFAULT (1) FOR [ShowBoard],
	CONSTRAINT [DF_Const_ImgPath] DEFAULT (N'newsimg/') FOR [ImgPath],
	CONSTRAINT [DF_Const_Copyright] DEFAULT (N'<font face=Verdana, Arial, Helvetica, sans-serif>Copyright &copy; 2003-2004 <font color=#CC0000>安徽省庐江第二中学</font>, All Rights Reserved .</font>') FOR [Copyright],
	CONSTRAINT [DF_Const_Ver] DEFAULT (N'LJez System Ver2.5 For SQL') FOR [Ver],
	CONSTRAINT [DF_Const_UploadFlag] DEFAULT (1) FOR [UploadFlag],
	CONSTRAINT [DF_Const_SMTPServer] DEFAULT (N'smtp.163.com') FOR [SMTPServer],
	CONSTRAINT [DF_Const_SetTimeOut] DEFAULT (500) FOR [Time_Out],
	CONSTRAINT [DF_Const_StartDate] DEFAULT (getdate()) FOR [StartDate],
	CONSTRAINT [DF_Const_THeight] DEFAULT (6) FOR [THeight],
	CONSTRAINT [DF_Const_FlashWidth] DEFAULT (500) FOR [FlashWidth],
	CONSTRAINT [DF_Const_OpenCheck] DEFAULT (0) FOR [OpenCheck],
	CONSTRAINT [DF_Const_ShowAnnounce] DEFAULT (1) FOR [ShowAnnounce],
	CONSTRAINT [DF_Const_ShowSearch] DEFAULT (1) FOR [ShowSearch],
	CONSTRAINT [DF_Const_ShowTxtTop] DEFAULT (N'txt') FOR [ShowTxtTop],
	CONSTRAINT [DF_Const_ShowImgTop] DEFAULT (2) FOR [ShowImgTop],
	CONSTRAINT [DF_Const_ShowFocusNews] DEFAULT (1) FOR [ShowFocusNews],
	CONSTRAINT [DF_Const_ShowGoodNews] DEFAULT (1) FOR [ShowGoodNews],
	CONSTRAINT [DF_Const_ShowAllySite] DEFAULT (1) FOR [ShowAllySite],
	CONSTRAINT [DF_Const_ShowFriendSite] DEFAULT (1) FOR [ShowFriendSite],
	CONSTRAINT [DF_Const_ShowGoodSite] DEFAULT (1) FOR [ShowGoodSite],
	CONSTRAINT [DF_Const_ShowLogo] DEFAULT (1) FOR [ShowLogo],
	CONSTRAINT [DF_Const_ShowUserLogin] DEFAULT (1) FOR [ShowUserLogin],
	CONSTRAINT [DF_Const_ShowGBook] DEFAULT (1) FOR [ShowGBook],
	CONSTRAINT [DF_Const_ShowOnline] DEFAULT (1) FOR [ShowOnline],
	CONSTRAINT [DF_Const_ShowTotalUser] DEFAULT (0) FOR [ShowTotalUser],
	CONSTRAINT [DF_Const_ShowTotalNews] DEFAULT (1) FOR [ShowTotalNews],
	CONSTRAINT [DF_Const_ShowTotalSpecial] DEFAULT (0) FOR [ShowTotalSpecial],
	CONSTRAINT [DF_Const_ShowTotalView] DEFAULT (1) FOR [ShowTotalView],
	CONSTRAINT [DF_Const_ShowTodayView] DEFAULT (1) FOR [ShowTodayView],
	CONSTRAINT [DF_Const_ShowYesterdayView] DEFAULT (1) FOR [ShowYesterdayView],
	CONSTRAINT [DF_Const_ShowMonthView] DEFAULT (0) FOR [ShowMonthView],
	CONSTRAINT [DF_Const_ShowBMonthView] DEFAULT (0) FOR [ShowBMonthView],
	CONSTRAINT [DF_Const_ShowTotalDate] DEFAULT (1) FOR [ShowTotalDate],
	CONSTRAINT [DF_Const_ShowAverageView] DEFAULT (1) FOR [ShowAverageView],
	CONSTRAINT [DF_Const_ShowResearch] DEFAULT (1) FOR [ShowResearch],
	CONSTRAINT [DF_Const_ShowStatistic] DEFAULT (1) FOR [ShowStatistic],
	CONSTRAINT [DF_Const_ShowNewUser] DEFAULT (0) FOR [ShowNewUser],
	CONSTRAINT [DF_Const_ReadFree] DEFAULT (1) FOR [ReadFree],
	CONSTRAINT [DF_Const_RegFree] DEFAULT (1) FOR [RegFree],
	CONSTRAINT [DF_Const_ShowClassImg] DEFAULT (1) FOR [ShowClassImg],
	CONSTRAINT [DF_Const_ShowNavigate] DEFAULT (0) FOR [ShowNavigate],
	CONSTRAINT [DF_Const_BigModel] DEFAULT (0) FOR [BigModel],
	CONSTRAINT [DF_Const_ShowBigModelRight] DEFAULT (1) FOR [ShowBigModelRight],
	CONSTRAINT [DF_Const_ShowSmallModelRight] DEFAULT (1) FOR [ShowSmallModelRight],
	CONSTRAINT [DF_Const_ShowSpecialModelRight] DEFAULT (1) FOR [ShowSpecialModelRight],
	CONSTRAINT [DF_Const_ShowNewsModelRight] DEFAULT (1) FOR [ShowNewsModelRight],
	CONSTRAINT [DF_Const_BBS_login] DEFAULT (1) FOR [BBS_login]
GO

ALTER TABLE [dbo].[Counters] WITH NOCHECK ADD 
	CONSTRAINT [DF_Counters_total] DEFAULT (0) FOR [total],
	CONSTRAINT [DF_Counters_today] DEFAULT (0) FOR [today],
	CONSTRAINT [DF_Counters_yesterday] DEFAULT (0) FOR [yesterday],
	CONSTRAINT [DF_Counters_month] DEFAULT (0) FOR [month],
	CONSTRAINT [DF_Counters_bmonth] DEFAULT (0) FOR [bmonth],
	CONSTRAINT [DF_Counters_date] DEFAULT (getdate()) FOR [date],
	CONSTRAINT [DF_Counters_inputdate] DEFAULT (getdate()) FOR [inputdate]
GO

ALTER TABLE [dbo].[FriendSite] WITH NOCHECK ADD 
	CONSTRAINT [DF_FriendSite_IsGood] DEFAULT (0) FOR [IsGood],
	CONSTRAINT [DF_FriendSite_IsOK] DEFAULT (0) FOR [IsOK]
GO

ALTER TABLE [dbo].[News] WITH NOCHECK ADD 
	CONSTRAINT [DF_News_model] DEFAULT (0) FOR [model],
	CONSTRAINT [DF_News_image] DEFAULT (0) FOR [image],
	CONSTRAINT [DF_News_UpdateTime] DEFAULT (getdate()) FOR [UpdateTime],
	CONSTRAINT [DF_News_click] DEFAULT (0) FOR [click],
	CONSTRAINT [DF_News_Hot] DEFAULT (0) FOR [Hot],
	CONSTRAINT [DF_News_goodnews] DEFAULT (0) FOR [goodnews],
	CONSTRAINT [DF_News_FocusNews] DEFAULT (0) FOR [FocusNews],
	CONSTRAINT [DF_News_Checked] DEFAULT (1) FOR [Checked],
	CONSTRAINT [DF_News_OnTop] DEFAULT (0) FOR [OnTop]
GO

ALTER TABLE [dbo].[SiteColor] WITH NOCHECK ADD 
	CONSTRAINT [DF_SiteColor_Ischecked] DEFAULT (0) FOR [Ischecked]
GO

ALTER TABLE [dbo].[SmallClass] WITH NOCHECK ADD 
	CONSTRAINT [DF_SmallClass_ReaderLevel] DEFAULT (0) FOR [ReaderLevel]
GO

ALTER TABLE [dbo].[gstbook] WITH NOCHECK ADD 
	CONSTRAINT [DF_gstbook_datetime] DEFAULT (getdate()) FOR [datetime]
GO

ALTER TABLE [dbo].[research] WITH NOCHECK ADD 
	CONSTRAINT [DF_research_DateAndTime] DEFAULT (getdate()) FOR [DateAndTime],
	CONSTRAINT [DF_research_IsChecked] DEFAULT (0) FOR [IsChecked]
GO

ALTER TABLE [dbo].[users] WITH NOCHECK ADD 
	CONSTRAINT [DF_users_Sex] DEFAULT (0) FOR [Sex],
	CONSTRAINT [DF_users_addDate] DEFAULT (getdate()) FOR [addDate],
	CONSTRAINT [DF_users_logins] DEFAULT (0) FOR [logins],
	CONSTRAINT [DF_users_UserPoint] DEFAULT (0) FOR [UserPoint],
	CONSTRAINT [DF_users_UserLevel] DEFAULT (0) FOR [UserLevel],
	CONSTRAINT [DF_users_LimitPoint] DEFAULT (0) FOR [LimitPoint],
	CONSTRAINT [DF_users_ReadNews] DEFAULT (0) FOR [ReadNews],
	CONSTRAINT [DF_users_SendNews] DEFAULT (0) FOR [SendNews],
	CONSTRAINT [DF_users_Replay] DEFAULT (0) FOR [Replay],
	CONSTRAINT [DF_users_WGBooks] DEFAULT (0) FOR [WGBooks],
	CONSTRAINT [DF_users_lastlogin] DEFAULT (getdate()) FOR [lastlogin],
	CONSTRAINT [DF_users_lockuser] DEFAULT (0) FOR [lockuser],
	CONSTRAINT [DF_users_ischecked] DEFAULT (0) FOR [ischecked]
GO