⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 ljez.sql

📁 庐江二中
💻 SQL
📖 第 1 页 / 共 2 页
字号:
🔍
12 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Ad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Ad]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Admin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AllySite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AllySite]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Announce]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Announce]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BigClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BigClass]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Const]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Const]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Counters]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Counters]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FriendSite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FriendSite]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Menu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Menu]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[News]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[News]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SiteColor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SiteColor]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SmallClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SmallClass]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Special]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Special]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserGrade]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserGrade]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gstbook]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[gstbook]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[research]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[research]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[users]
GO

CREATE TABLE [dbo].[Ad] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdPic] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdIntro] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Adwidth] [int] NOT NULL ,
	[Adheight] [int] NOT NULL ,
	[AdAdd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsFlash] [bit] NOT NULL ,
	[beginday] [datetime] NOT NULL ,
	[yesterday] [int] NOT NULL ,
	[today] [int] NOT NULL ,
	[totalclick] [int] NOT NULL ,
	[checked] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Admin] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[oskey] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoginIP] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[LoginTime] [datetime] NULL ,
	[LogoutTime] [datetime] NULL ,
	[LoginTimes] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[AllySite] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AllySitePic] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AllySiteUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AllySiteName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Announce] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Popup] [bit] NOT NULL ,
	[board] [bit] NOT NULL ,
	[win_width] [int] NULL ,
	[win_height] [int] NULL ,
	[DateAndTime] [datetime] NOT NULL ,
	[IsChecked] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[BigClass] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BigClassID] [int] NOT NULL ,
	[BigClassMaster] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[BigClassView] [smallint] NOT NULL ,
	[BigClassType] [smallint] NOT NULL ,
	[BigClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Const] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MaxList] [int] NOT NULL ,
	[MaxNewsList] [int] NOT NULL ,
	[MaxFocusNewsList] [int] NOT NULL ,
	[MaxGoodNewsList] [int] NOT NULL ,
	[MaxTxtList] [int] NOT NULL ,
	[FenTitle] [int] NOT NULL ,
	[MaxTxtListDate] [int] NOT NULL ,
	[InDate] [int] NOT NULL ,
	[MaxImgList] [int] NOT NULL ,
	[MaxSpecialList] [int] NOT NULL ,
	[ShowNewImg] [int] NOT NULL ,
	[WebTitle] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[WebUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Logo] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowBoard] [int] NOT NULL ,
	[ImgPath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Copyright] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ver] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdminEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UploadFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SMTPServer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Time_Out] [int] NOT NULL ,
	[StartDate] [datetime] NOT NULL ,
	[THeight] [int] NOT NULL ,
	[FlashWidth] [int] NOT NULL ,
	[OpenCheck] [int] NOT NULL ,
	[ShowAnnounce] [int] NOT NULL ,
	[ShowSearch] [int] NOT NULL ,
	[ShowTxtTop] [varchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ShowImgTop] [int] NOT NULL ,
	[ShowFocusNews] [int] NOT NULL ,
	[ShowGoodNews] [int] NOT NULL ,
	[ShowAllySite] [int] NOT NULL ,
	[ShowFriendSite] [int] NOT NULL ,
	[ShowGoodSite] [int] NOT NULL ,
	[ShowLogo] [int] NOT NULL ,
	[ShowUserLogin] [int] NOT NULL ,
	[ShowGBook] [int] NOT NULL ,
	[ShowOnline] [int] NOT NULL ,
	[ShowTotalUser] [int] NOT NULL ,
	[ShowTotalNews] [int] NOT NULL ,
	[ShowTotalSpecial] [int] NOT NULL ,
	[ShowTotalView] [int] NOT NULL ,
	[ShowTodayView] [int] NOT NULL ,
	[ShowYesterdayView] [int] NOT NULL ,
	[ShowMonthView] [int] NOT NULL ,
	[ShowBMonthView] [int] NOT NULL ,
	[ShowTotalDate] [int] NOT NULL ,
	[ShowAverageView] [int] NOT NULL ,
	[ShowResearch] [int] NOT NULL ,
	[ShowStatistic] [int] NOT NULL ,
	[ShowNewUser] [int] NOT NULL ,
	[ReadFree] [int] NOT NULL ,
	[RegFree] [int] NOT NULL ,
	[ShowClassImg] [int] NOT NULL ,
	[ShowNavigate] [int] NOT NULL ,
	[BadWords] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[BigModel] [int] NOT NULL ,
	[ShowBigModelRight] [int] NOT NULL ,
	[ShowSmallModelRight] [int] NOT NULL ,
	[ShowSpecialModelRight] [int] NOT NULL ,
	[ShowNewsModelRight] [int] NOT NULL ,
	[BBS_login] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Counters] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[total] [int] NOT NULL ,
	[today] [int] NOT NULL ,
	[yesterday] [int] NOT NULL ,
	[month] [int] NOT NULL ,
	[bmonth] [int] NOT NULL ,
	[date] [datetime] NOT NULL ,
	[lastip] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[inputdate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[FriendSite] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SiteName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteIntro] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LogoUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteAdmin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsGood] [bit] NOT NULL ,
	[IsOK] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Menu] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Url] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Intro] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[News] (
	[NewsID] [int] IDENTITY (1, 1) NOT NULL ,
	[BigClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SmallClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SpecialName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Title] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TitleUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LoginIP] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Original] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[model] [int] NULL ,
	[image] [int] NOT NULL ,
	[UpdateTime] [datetime] NOT NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[about] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[click] [int] NOT NULL ,
	[Hot] [bit] NOT NULL ,
	[goodnews] [bit] NOT NULL ,
	[FocusNews] [bit] NOT NULL ,
	[Checked] [bit] NOT NULL ,
	[OnTop] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[SiteColor] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ColorName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TdFColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ALinkFColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[AHoverFColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[AVisitedFColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[AlertFColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[InputBGColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[InputBorderColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SelectBgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BGcolor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BgImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[MainBColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[MainBgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[MainTColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[MainCColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[TopBColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Top1BgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Top2BgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Top3BgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Out1Color] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Out2Color] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Out2Width] [int] NOT NULL ,
	[Out3Color] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftLColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftBColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftBImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftBgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftTColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftTImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftCColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftCImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftRColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LeftRImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[CenterBgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CenterTColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CenterTImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[CenterBColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CenterBImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[CenterCColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CenterCImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightLColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightLImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightBColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightBImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightBgColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightTColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightTImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightCColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightCImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightRColor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BottomBgcolor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BottomBgImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ColorCss] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[TableWidth] [varchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DaoDu_color] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[DaoDu_img] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[HHB1_img] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[HHB3_img] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[GongGao_color] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GongGao_img] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[BBS_color] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BBS_img] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ischecked] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[SmallClass] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SmallClassID] [int] NULL ,
	[SmallClassType] [int] NULL ,
	[BigClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SmallClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SmallClassMaster] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReaderLevel] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Special] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SpecialID] [smallint] NULL ,
	[SpecialName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -