📄 creatdata.sql

📁 最好用的站点内容管理系统全部源代码都有
💻 SQL
📖 第 1 页 / 共 5 页
字号:
上一页 1 2 3 45
	[ClassID] [ntext] ,
	[News] [ntext] ,
	[Special] [ntext] ,
	[TimeSet] [nvarchar] (100) ,
	[CreatTime] [datetime] NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_User] (
	[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[UserNum] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserName] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserPassword] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NickName] [nvarchar] (20) ,
	[RealName] [nvarchar] (20) ,
	[isAdmin] [tinyint] NOT NULL ,
	[UserGroupNumber] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PassQuestion] [nvarchar] (20) ,
	[PassKey] [nvarchar] (20) ,
	[CertType] [nvarchar] (15) ,
	[CertNumber] [nvarchar] (20) ,
	[Email] [nvarchar] (220) ,
	[mobile] [nvarchar] (15) ,
	[Sex] [tinyint] NULL ,
	[birthday] [datetime] NULL ,
	[Userinfo] [ntext] ,
	[UserFace] [nvarchar] (220) ,
	[userFacesize] [nvarchar] (8) ,
	[marriage] [tinyint] NULL ,
	[iPoint] [int] NOT NULL ,
	[gPoint] [int] NOT NULL ,
	[cPoint] [int] NOT NULL ,
	[ePoint] [int] NOT NULL ,
	[aPoint] [int] NOT NULL ,
	[isLock] [tinyint] NOT NULL ,
	[RegTime] [datetime] NOT NULL ,
	[LastLoginTime] [datetime] NULL ,
	[OnlineTime] [int] NOT NULL ,
	[OnlineTF] [int] NOT NULL ,
	[LoginNumber] [int] NOT NULL ,
	[FriendClass] [nvarchar] (50) ,
	[LoginLimtNumber] [int] NULL ,
	[LastIP] [nvarchar] (16) ,
	[SiteID] [nvarchar] (12) ,
	[Addfriend] [int] NULL ,
	[isOpen] [tinyint] NULL ,
	[ParmConstrNum] [int] NULL ,
	[isIDcard] [tinyint] NULL ,
	[IDcardFiles] [nvarchar] (220) ,
	[Addfriendbs] [tinyint] NULL ,
	[EmailATF] [tinyint] NULL ,
	[EmailCode] [nvarchar] (32) ,
	[isMobile] [tinyint] NULL ,
	[BindTF] [tinyint] NULL ,
	[MobileCode] [nvarchar] (32) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_UserLevel] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[LevelID] [nvarchar] (20) ,
	[LTitle] [nvarchar] (50) ,
	[Lpicurl] [nvarchar] (200) ,
	[iPoint] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_admin] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[UserNum] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[isSuper] [tinyint] NOT NULL ,
	[adminGroupNumber] [nvarchar] (12) ,
	[PopList] [ntext] ,
	[OnlyLogin] [tinyint] NOT NULL ,
	[isChannel] [tinyint] NOT NULL ,
	[isLock] [tinyint] NOT NULL ,
	[SiteID] [nvarchar] (12) ,
	[isChSupper] [tinyint] NULL ,
	[Iplimited] [ntext] ,
	[verCode] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_admingroup] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[adminGroupNumber] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GroupName] [nvarchar] (20) ,
	[ClassList] [ntext] ,
	[SpecialList] [ntext] ,
	[channelList] [ntext] ,
	[CreatTime] [datetime] NOT NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_channel] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ParentID] [int] NULL ,
	[channelName] [nvarchar] (50) ,
	[channelItem] [nvarchar] (50) ,
	[channelEItem] [nvarchar] (20) ,
	[channelDescript] [nvarchar] (200) ,
	[channelunit] [nvarchar] (50) ,
	[DataLib] [nvarchar] (30) ,
	[islock] [tinyint] NULL ,
	[isHTML] [tinyint] NULL ,
	[ClassSave] [nvarchar] (50) ,
	[ClassFileName] [nvarchar] (50) ,
	[SavePath] [nvarchar] (50) ,
	[FileName] [nvarchar] (60) ,
	[htmldir] [nvarchar] (100) ,
	[indexFileName] [nvarchar] (50) ,
	[issys] [tinyint] NULL ,
	[upfilessize] [int] NULL ,
	[upfiletype] [nvarchar] (100) ,
	[ischeck] [tinyint] NULL ,
	[TempletPath] [nvarchar] (100) ,
	[indextemplet] [nvarchar] (200) ,
	[classtemplet] [nvarchar] (200) ,
	[newstemplet] [nvarchar] (200) ,
	[specialtemplet] [nvarchar] (200) ,
	[isModelContent] [tinyint] NULL ,
	[channelType] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) ,
	[isConstr] [tinyint] NULL ,
	[binddomain] [nvarchar] (150) ,
	[keyCert] [nvarchar] (64) ,
	[isDelPoint] [tinyint] NULL ,
	[iPoint] [int] NULL ,
	[gPoint] [int] NULL ,
	[GroupNumber] [nvarchar] (200) 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_channelclass] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ParentID] [int] NULL ,
	[ChID] [int] NULL ,
	[classCName] [nvarchar] (50) ,
	[classEName] [nvarchar] (50) ,
	[OrderID] [tinyint] NULL ,
	[isPage] [tinyint] NULL ,
	[PageContent] [ntext] ,
	[Templet] [nvarchar] (200) ,
	[ContentTemplet] [nvarchar] (200) ,
	[SavePath] [nvarchar] (100) ,
	[FileName] [nvarchar] (100) ,
	[ContentSavePath] [nvarchar] (100) ,
	[ContentFileNameRule] [nvarchar] (150) ,
	[isShowNavi] [tinyint] NULL ,
	[PicURL] [nvarchar] (200) ,
	[NaviContent] [nvarchar] (200) ,
	[KeyMeta] [nvarchar] (100) ,
	[DescMeta] [nvarchar] (150) ,
	[isDelPoint] [tinyint] NULL ,
	[Gpoint] [int] NULL ,
	[iPoint] [int] NULL ,
	[GroupNumber] [nvarchar] (200) ,
	[isLock] [tinyint] NULL ,
	[ClassNavi] [ntext] ,
	[ContentNavi] [ntext] ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_channellabel] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [int] NULL ,
	[ChID] [int] NULL ,
	[LabelName] [nvarchar] (100) ,
	[LabelContent] [ntext] ,
	[LabelDescript] [nvarchar] (200) ,
	[isLock] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) ,
	[CreatTime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_channellabelclass] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ParentID] [int] NULL ,
	[ChID] [int] NULL ,
	[ClassName] [nvarchar] (80) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_channelspecial] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ChID] [int] NULL ,
	[ParentID] [int] NULL ,
	[specialCName] [nvarchar] (100) ,
	[specialEName] [nvarchar] (100) ,
	[binddomain] [nvarchar] (100) ,
	[navicontent] [nvarchar] (200) ,
	[savePath] [nvarchar] (100) ,
	[filename] [nvarchar] (100) ,
	[templet] [nvarchar] (200) ,
	[islock] [tinyint] NULL ,
	[isRec] [tinyint] NULL ,
	[PicURL] [nvarchar] (200) ,
	[OrderID] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_channelstyle] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ChID] [int] NULL ,
	[classID] [int] NULL ,
	[styleName] [nvarchar] (50) ,
	[styleContent] [ntext] ,
	[isLock] [tinyint] NULL ,
	[styleDescript] [nvarchar] (200) ,
	[SiteID] [nvarchar] (12) ,
	[creattime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_channelstyleclass] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ParentID] [int] NULL ,
	[cName] [nvarchar] (50) ,
	[ChID] [int] NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_channelvalue] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ChID] [int] NULL ,
	[OrderID] [tinyint] NULL ,
	[CName] [nvarchar] (50) ,
	[EName] [nvarchar] (50) ,
	[vValue] [nvarchar] (150) ,
	[vitem] [ntext] ,
	[isSearch] [tinyint] NULL ,
	[HTMLedit] [tinyint] NULL ,
	[vHeight] [nvarchar] (6) ,
	[vDescript] [nvarchar] (200) ,
	[vType] [tinyint] NULL ,
	[vLength] [nvarchar] (6) ,
	[isNulls] [tinyint] NULL ,
	[isUser] [tinyint] NULL ,
	[isLock] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) ,
	[fieldLength] [nvarchar] (5) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_logs] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nvarchar] (50) ,
	[content] [ntext] ,
	[creatTime] [datetime] NULL ,
	[IP] [nvarchar] (16) ,
	[usernum] [nvarchar] (15) ,
	[SiteID] [nvarchar] (12) ,
	[ismanage] [nvarchar] (50) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_newsIndex] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[TableName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CreatTime] [datetime] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_param] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[SiteName] [nvarchar] (50) ,
	[SiteDomain] [nvarchar] (100) ,
	[IndexTemplet] [nvarchar] (200) ,
	[IndexFileName] [nvarchar] (20) ,
	[ReadNewsTemplet] [nvarchar] (200) ,
	[ClassListTemplet] [nvarchar] (200) ,
	[SpecialTemplet] [nvarchar] (200) ,
	[FileEXName] [nvarchar] (30) ,
	[ReadType] [tinyint] NULL ,
	[LoginTimeOut] [int] NULL ,
	[Email] [nvarchar] (150) ,
	[LinkType] [tinyint] NULL ,
	[CopyRight] [ntext] ,
	[CheckInt] [tinyint] NULL ,
	[UnLinkTF] [tinyint] NULL ,
	[LenSearch] [nvarchar] (8) ,
	[CheckNewsTitle] [tinyint] NULL ,
	[CollectTF] [tinyint] NULL ,
	[SaveClassFilePath] [nvarchar] (200) ,
	[SaveIndexPage] [nvarchar] (100) ,
	[SaveNewsFilePath] [nvarchar] (200) ,
	[SaveNewsDirPath] [nvarchar] (100) ,
	[ConstrTF] [tinyint] NULL ,
	[PicServerTF] [tinyint] NULL ,
	[PicServerDomain] [ntext] ,
	[PicUpLoad] [nvarchar] (200) ,
	[UpfilesType] [nvarchar] (150) ,
	[UpFilesSize] [int] NULL ,
	[RemoteSavePath] [nvarchar] (200) ,
	[ReMoteDomainTF] [tinyint] NULL ,
	[RemoteDomain] [nvarchar] (100) ,
	[HotNewsJs] [nvarchar] (200) ,
	[LastNewsJs] [nvarchar] (200) ,
	[RecNewsJS] [nvarchar] (200) ,
	[HotCommJS] [nvarchar] (200) ,
	[TNewsJS] [nvarchar] (200) ,
	[ClassListNum] [int] NULL ,
	[NewsNum] [int] NULL ,
	[BatDelNum] [int] NULL ,
	[SpecialNum] [int] NULL ,
	[Pram_Index] [int] NULL ,
	[InsertPicPosition] [nvarchar] (20) ,
	[HistoryNum] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_parmConstr] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[PCId] [nvarchar] (18) ,
	[ConstrPayName] [nvarchar] (20) ,
	[gPoint] [int] NULL ,
	[iPoint] [int] NULL ,
	[money] [int] NULL ,
	[Gunit] [nvarchar] (10) ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_parmPrint] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[PrintTF] [tinyint] NULL ,
	[PrintPicTF] [tinyint] NULL ,
	[PrintWord] [nvarchar] (50) ,
	[Printfontsize] [int] NULL ,
	[Printfontfamily] [nvarchar] (30) ,
	[Printfontcolor] [nvarchar] (10) ,
	[PrintBTF] [tinyint] NULL ,
	[PintPicURL] [nvarchar] (150) ,
	[PrintPicsize] [nvarchar] (8) ,
	[PintPictrans] [nvarchar] (20) ,
	[PrintPosition] [tinyint] NULL ,
	[PrintSmallTF] [tinyint] NULL ,
	[PrintSmallSize] [nvarchar] (8) ,
	[PrintSmallinv] [nvarchar] (20) ,
	[PrintSmallSizeStyle] [tinyint] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_styleclass] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [nvarchar] (12) ,
	[Sname] [nvarchar] (50) ,
	[CreatTime] [datetime] NULL ,
	[SiteID] [nvarchar] (12) ,
	[isRecyle] [tinyint] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_sys_userfields] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[userNum] [nvarchar] (15) ,
	[province] [nvarchar] (20) ,
	[City] [nvarchar] (20) ,
	[Address] [nvarchar] (50) ,
	[Postcode] [nvarchar] (10) ,
	[FaTel] [nvarchar] (30) ,
	[WorkTel] [nvarchar] (30) ,
	[QQ] [nvarchar] (30) ,
	[MSN] [nvarchar] (150) ,
	[Fax] [nvarchar] (30) ,
	[character] [ntext] ,
	[UserFan] [ntext] ,
	[Nation] [nvarchar] (12) ,
	[nativeplace] [nvarchar] (20) ,
	[Job] [nvarchar] (30) ,
	[education] [nvarchar] (20) ,
	[Lastschool] [nvarchar] (80) ,
	[orgSch] [nvarchar] (10) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_sys_userother] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ConID] [nvarchar] (15) ,
	[address] [nvarchar] (100) ,
	[postcode] [nvarchar] (20) ,
	[RealName] [nvarchar] (20) ,
	[bankName] [nvarchar] (100) ,
	[bankaccount] [nvarchar] (30) ,
	[bankcard] [nvarchar] (50) ,
	[bankRealName] [nvarchar] (50) ,
	[UserNum] [nvarchar] (15) 
) ON [PRIMARY]
;

CREATE TABLE [nt_user_Card] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[CaID] [nvarchar] (12) ,
	[CardNumber] [nvarchar] (30) ,
	[CardPassWord] [nvarchar] (150) ,
	[creatTime]
上一页 1 2 3 45
⌨️ 快捷键说明

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