📄 creatdata.sql

📁 最好用的站点内容管理系统全部源代码都有
💻 SQL
📖 第 1 页 / 共 5 页
字号:
) ON [PRIMARY]
;

CREATE TABLE [nt_Define_Data] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Type] [int] NULL default 0 ,
	[defineInfoId] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[defineCname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[defineColumns] [nvarchar] (50) ,
	[defineType] [int] NULL ,
	[IsNull] [tinyint] NULL ,
	[defineValue] [ntext] ,
	[defineExpr] [nvarchar] (200) ,
	[definedvalue] [nvarchar] (200) ,
	[SiteID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Define_Save] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[DsNewsID] [nvarchar] (12) ,
	[DsEname] [nvarchar] (50) ,
	[DsNewsTable] [nvarchar] (50) ,
	[DsType] [tinyint] NULL ,
	[DsContent] [ntext] ,
	[DsApiID] [nvarchar] (30) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Form_Newsform] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[usernum] [nvarchar] (50) ,
	[username] [nvarchar] (50) ,
	[submit_ip] [nvarchar] (15) ,
	[submit_time] [datetime] NULL ,
	[xb] [nvarchar] (100) ,
	[age] [nvarchar] (100) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Friend_Class] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [nvarchar] (12) ,
	[ClassCName] [nvarchar] (50) ,
	[ClassEName] [nvarchar] (50) ,
	[Content] [ntext] ,
	[ParentID] [nvarchar] (12) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Friend_Link] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (50) ,
	[Type] [tinyint] NULL ,
	[Url] [nvarchar] (250) ,
	[Content] [ntext] ,
	[PicUrl] [nvarchar] (250) ,
	[Lock] [tinyint] NULL ,
	[IsUser] [tinyint] NULL ,
	[Author] [nvarchar] (50) ,
	[Mail] [nvarchar] (150) ,
	[ContentFor] [ntext] ,
	[LinkContent] [ntext] ,
	[Addtime] [datetime] NULL ,
	[isAdmin] [tinyint] NULL ,
	[ClassID] [nvarchar] (12) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Friend_Pram] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[IsOpen] [tinyint] NULL ,
	[IsRegister] [tinyint] NULL ,
	[ArrSize] [nvarchar] (10) ,
	[Content] [ntext] ,
	[isLock] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_News] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[NewsID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NewsType] [tinyint] NOT NULL ,
	[OrderID] [tinyint] NOT NULL ,
	[NewsTitle] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sNewsTitle] [nvarchar] (100) ,
	[TitleColor] [nvarchar] (10) ,
	[TitleITF] [tinyint] NOT NULL ,
	[TitleBTF] [tinyint] NULL ,
	[CommLinkTF] [tinyint] NULL ,
	[SubNewsTF] [tinyint] NULL ,
	[URLaddress] [nvarchar] (200) ,
	[PicURL] [nvarchar] (200) ,
	[SPicURL] [nvarchar] (200) ,
	[ClassID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SpecialID] [nvarchar] (12) ,
	[Author] [nvarchar] (100) ,
	[Souce] [nvarchar] (100) ,
	[Tags] [nvarchar] (100) ,
	[NewsProperty] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NewsPicTopline] [tinyint] NOT NULL ,
	[Templet] [nvarchar] (200) ,
	[Content] [ntext] ,
	[Metakeywords] [nvarchar] (200) ,
	[Metadesc] [nvarchar] (200) ,
	[naviContent] [nvarchar] (255) ,
	[Click] [int] NOT NULL ,
	[CreatTime] [datetime] NOT NULL ,
	[EditTime] [datetime] NULL ,
	[SavePath] [nvarchar] (200) ,
	[FileName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FileEXName] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[isDelPoint] [tinyint] NOT NULL ,
	[Gpoint] [int] NOT NULL ,
	[iPoint] [int] NOT NULL ,
	[GroupNumber] [ntext] ,
	[ContentPicTF] [tinyint] NOT NULL ,
	[ContentPicURL] [nvarchar] (200) ,
	[ContentPicSize] [nvarchar] (10) ,
	[CommTF] [tinyint] NOT NULL ,
	[DiscussTF] [tinyint] NOT NULL ,
	[TopNum] [int] NOT NULL ,
	[VoteTF] [tinyint] NOT NULL ,
	[CheckStat] [nvarchar] (10) ,
	[isLock] [tinyint] NOT NULL ,
	[isRecyle] [tinyint] NOT NULL ,
	[SiteID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DataLib] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DefineID] [tinyint] NULL ,
	[isVoteTF] [tinyint] NOT NULL ,
	[Editor] [nvarchar] (18) ,
	[isHtml] [tinyint] NOT NULL ,
	[isConstr] [tinyint] NOT NULL ,
	[isFiles] [tinyint] NULL ,
	[vURL] [nvarchar] (200) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_News_Class] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassCName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassEName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ParentID] [nvarchar] (12) ,
	[IsURL] [tinyint] NULL ,
	[OrderID] [tinyint] NULL ,
	[URLaddress] [nvarchar] (200) ,
	[Domain] [nvarchar] (150) ,
	[ClassTemplet] [nvarchar] (200) ,
	[ReadNewsTemplet] [nvarchar] (200) ,
	[SavePath] [nvarchar] (50) ,
	[SaveClassframe] [nvarchar] (200) ,
	[Checkint] [tinyint] NULL ,
	[ClassSaveRule] [nvarchar] (200) ,
	[ClassIndexRule] [nvarchar] (50) ,
	[NewsSavePath] [nvarchar] (50) ,
	[NewsFileRule] [nvarchar] (200) ,
	[PicDirPath] [nvarchar] (150) ,
	[ContentPicTF] [tinyint] NULL ,
	[ContentPICurl] [nvarchar] (200) ,
	[ContentPicSize] [nvarchar] (15) ,
	[InHitoryDay] [int] NULL ,
	[DataLib] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteID] [nvarchar] (12) ,
	[NaviShowtf] [tinyint] NULL ,
	[NaviPIC] [nvarchar] (200) ,
	[NaviContent] [nvarchar] (250) ,
	[MetaKeywords] [nvarchar] (200) ,
	[MetaDescript] [nvarchar] (200) ,
	[isDelPoint] [tinyint] NULL ,
	[Gpoint] [int] NULL ,
	[iPoint] [int] NULL ,
	[GroupNumber] [nvarchar] (250) ,
	[FileName] [nvarchar] (6) ,
	[isLock] [tinyint] NULL ,
	[isRecyle] [tinyint] NULL ,
	[NaviPosition] [ntext] ,
	[NewsPosition] [ntext] ,
	[isComm] [tinyint] NULL ,
	[Defineworkey] [nvarchar] (220) ,
	[CreatTime] [datetime] NULL ,
	[isPage] [tinyint] NULL ,
	[PageContent] [ntext] ,
	[ModelID] [nvarchar] (12) ,
	[isunHTML] [tinyint] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_News_Gen] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Cname] [nvarchar] (100) ,
	[gType] [tinyint] NULL ,
	[URL] [nvarchar] (200) ,
	[EmailURL] [nvarchar] (200) ,
	[isLock] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_News_Js] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[JsID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[jsType] [tinyint] NOT NULL ,
	[JSName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JsTempletID] [nvarchar] (12) ,
	[jsNum] [int] NULL ,
	[jsLenTitle] [int] NULL ,
	[jsLenNavi] [int] NULL ,
	[jsLenContent] [int] NULL ,
	[jsContent] [ntext] ,
	[SiteID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[jsColsNum] [int] NULL ,
	[CreatTime] [datetime] NULL ,
	[jsfilename] [nvarchar] (50) ,
	[jssavepath] [nvarchar] (200) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_News_Jsfile] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[JsID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Njf_title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NewsId] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NewsTable] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PicPath] [nvarchar] (200) ,
	[ClassId] [nvarchar] (12) ,
	[SiteID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CreatTime] [datetime] NULL ,
	[TojsTime] [datetime] NULL ,
	[ReclyeTF] [tinyint] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_News_Jst_Class] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ParentID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Description] [nvarchar] (500) ,
	[CreatTime] [datetime] NOT NULL ,
	[SiteID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_News_Jstemplet] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[TempletID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JSClassid] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JSTType] [tinyint] NOT NULL ,
	[JSTContent] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CreatTime] [datetime] NOT NULL ,
	[SiteID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_News_Page] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nvarchar] (100) ,
	[Content] [ntext] ,
	[CreatTime] [datetime] NULL ,
	[ClassID] [nvarchar] (12) ,
	[SavePath] [nvarchar] (100) ,
	[fileName] [nvarchar] (50) ,
	[isDelPoint] [tinyint] NULL ,
	[Gpoint] [int] NULL ,
	[iPoint] [int] NULL ,
	[GroupNumber] [ntext] ,
	[KeyMeta] [nvarchar] (150) ,
	[DescMeta] [nvarchar] (150) ,
	[Editor] [nvarchar] (20) ,
	[Templet] [nvarchar] (200) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_News_URL] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[URLName] [nvarchar] (50) ,
	[NewsID] [nvarchar] (15) ,
	[DataLib] [nvarchar] (30) ,
	[FileURL] [nvarchar] (220) ,
	[CreatTime] [datetime] NULL ,
	[OrderID] [tinyint] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Sys_Help] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[HelpID] [nvarchar] (30) ,
	[TitleCN] [nvarchar] (80) ,
	[ContentCN] [ntext] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_User_URL] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [int] NULL ,
	[URLName] [nvarchar] (100) ,
	[URL] [nvarchar] (200) ,
	[URLColor] [nvarchar] (10) ,
	[CreatTime] [datetime] NULL ,
	[Content] [nvarchar] (200) ,
	[UserNum] [nvarchar] (15) 
) ON [PRIMARY]
;

CREATE TABLE [nt_User_URLClass] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassName] [nvarchar] (50) ,
	[ParentID] [int] NULL ,
	[UserNum] [nvarchar] (15) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Vote_Class] (
	[VID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassName] [nvarchar] (20) ,
	[Description] [nvarchar] (50) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Vote_Item] (
	[IID] [int] IDENTITY (1, 1) NOT NULL ,
	[TID] [int] NOT NULL ,
	[ItemName] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ItemMode] [tinyint] NULL ,
	[PicSrc] [nvarchar] (200) ,
	[DisColor] [nvarchar] (7) ,
	[VoteCount] [int] NULL ,
	[ItemDetail] [nvarchar] (255) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Vote_Manage] (
	[RID] [int] IDENTITY (1, 1) NOT NULL ,
	[TID] [int] NOT NULL ,
	[IID] [int] NULL ,
	[OtherContent] [nvarchar] (50) ,
	[VoteIp] [nvarchar] (15) ,
	[VoteTime] [datetime] NULL ,
	[UserNumber] [nvarchar] (15) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Vote_Param] (
	[SysID] [int] IDENTITY (1, 1) NOT NULL ,
	[IPtime] [nvarchar] (20) ,
	[IsReg] [tinyint] NULL ,
	[IpLimit] [nvarchar] (200) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Vote_Steps] (
	[SID] [int] IDENTITY (1, 1) NOT NULL ,
	[TIDS] [int] NOT NULL ,
	[Steps] [int] NOT NULL ,
	[TIDU] [int] NOT NULL ,
	[SiteID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Vote_Topic] (
	[TID] [int] IDENTITY (1, 1) NOT NULL ,
	[VID] [int] NULL ,
	[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Type] [tinyint] NOT NULL ,
	[AllowFillIn] [bit] NOT NULL ,
	[SeriesMode] [tinyint] NOT NULL ,
	[DisMode] [tinyint] NULL ,
	[StartDate] [datetime] NULL ,
	[EndDate] [datetime] NULL ,
	[ItemMode] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_news_site] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ParentID] [nvarchar] (12) ,
	[CName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ChannCName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IsURL] [tinyint] NOT NULL ,
	[Urladdress] [nvarchar] (200) ,
	[DataLib] [nvarchar] (20) ,
	[IndexTemplet] [nvarchar] (200) ,
	[ClassTemplet] [nvarchar] (200) ,
	[ReadNewsTemplet] [nvarchar] (200) ,
	[SpecialTemplet] [nvarchar] (200) ,
	[isLock] [tinyint] NULL ,
	[Domain] [nvarchar] (100) ,
	[isDelPoint] [tinyint] NULL ,
	[Gpoint] [int] NULL ,
	[iPoint] [int] NULL ,
	[GroupNumber] [ntext] ,
	[isCheck] [tinyint] NULL ,
	[Keywords] [nvarchar] (100) ,
	[Descript] [nvarchar] (200) ,
⌨️ 快捷键说明

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