creatdata.sql

最好用的站点内容管理系统 全部源代码都有

if exists (select * from sysobjects where id = object_id(N'[nt_user_Group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_Group]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_Guser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_Guser]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_MessFiles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_MessFiles]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_Message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_Message]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_Photo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_Photo]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_Photoalbum]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_Photoalbum]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_PhotoalbumClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_PhotoalbumClass]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_Requestinformation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_Requestinformation]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_constrPay]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_constrPay]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_news]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_news]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_note]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_note]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_userlogs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_userlogs]
;

if exists (select * from sysobjects where id = object_id(N'[nt_user_vote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [nt_user_vote]
;

CREATE TABLE [nt_Ads] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[AdID] [nvarchar] (15) ,
	[adName] [nvarchar] (50) ,
	[ClassID] [nvarchar] (12) ,
	[CusID] [nvarchar] (12) ,
	[adType] [tinyint] NULL ,
	[leftPic] [nvarchar] (200) ,
	[rightPic] [nvarchar] (200) ,
	[leftSize] [nvarchar] (12) ,
	[rightSize] [nvarchar] (12) ,
	[LinkURL] [nvarchar] (200) ,
	[CycTF] [tinyint] NULL ,
	[CycAdID] [nvarchar] (15) ,
	[CycSpeed] [int] NULL ,
	[CycDic] [tinyint] NULL ,
	[ClickNum] [int] NULL ,
	[ShowNum] [int] NULL ,
	[CondiTF] [tinyint] NULL ,
	[maxShowClick] [int] NULL ,
	[TimeOutDay] [datetime] NULL ,
	[maxClick] [int] NULL ,
	[creatTime] [datetime] NULL ,
	[AdTxtNum] [int] NULL ,
	[isLock] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Ads_Class] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[AcID] [nvarchar] (12) ,
	[Cname] [nvarchar] (50) ,
	[ParentID] [nvarchar] (12) ,
	[creatTime] [datetime] NULL ,
	[SiteID] [nvarchar] (12) ,
	[Adprice] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Ads_Stat] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[AdID] [nvarchar] (15) ,
	[IP] [nvarchar] (20) ,
	[Address] [nvarchar] (100) ,
	[creatTime] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Adstxt] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[AdID] [nvarchar] (15) ,
	[AdTxt] [nvarchar] (200) ,
	[AdCss] [nvarchar] (20) ,
	[AdLink] [nvarchar] (100) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Api_Commentary] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Commid] [nvarchar] (12) ,
	[InfoID] [nvarchar] (12) ,
	[APIID] [nvarchar] (20) ,
	[DataLib] [nvarchar] (20) ,
	[Title] [nvarchar] (200) ,
	[Content] [nvarchar] (200) ,
	[creatTime] [datetime] NULL ,
	[IP] [nvarchar] (20) ,
	[QID] [nvarchar] (12) ,
	[UserNum] [nvarchar] (20) ,
	[isRecyle] [tinyint] NULL ,
	[islock] [tinyint] NULL ,
	[OrderID] [int] NULL ,
	[GoodTitle] [tinyint] NULL ,
	[isCheck] [tinyint] NULL ,
	[SiteID] [nvarchar] (12) ,
	[commtype] [tinyint] NULL ,
	[ChID] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Api_Faviate] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[FID] [nvarchar] (12) ,
	[Infotitle] [nvarchar] (80) ,
	[UserNum] [nvarchar] (15) ,
	[CreatTime] [datetime] NULL ,
	[APIID] [nvarchar] (20) ,
	[DataLib] [nvarchar] (20) ,
	[ChID] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Api_Navi] (
	[am_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[api_IdentID] [nvarchar] (30) ,
	[am_ClassID] [nvarchar] (12) ,
	[Am_position] [nvarchar] (5) ,
	[am_Name] [nvarchar] (20) ,
	[Am_Ename] [nvarchar] (20) ,
	[am_FilePath] [nvarchar] (200) ,
	[am_target] [nvarchar] (20) ,
	[am_ParentID] [nvarchar] (12) ,
	[am_type] [tinyint] NULL ,
	[am_creatTime] [datetime] NULL ,
	[am_orderID] [int] NULL ,
	[isSys] [tinyint] NULL ,
	[siteID] [nvarchar] (12) ,
	[userNum] [nvarchar] (15) ,
	[popCode] [nvarchar] (50) ,
	[mainURL] [nvarchar] (100) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Api_Pop] (
	[pop_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[api_IdentID] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pop_classid] [int] NULL ,
	[pop_parentID] [int] NULL ,
	[pop_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pop_PopID] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pop_Content] [nvarchar] (200) ,
	[pop_Standby] [nvarchar] (200) ,
	[Pop_addTime] [datetime] NOT NULL ,
	[SiteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Api_Qmenu] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[QmID] [nvarchar] (12) ,
	[qName] [nvarchar] (50) ,
	[FilePath] [nvarchar] (200) ,
	[Ismanage] [tinyint] NULL ,
	[OrderID] [int] NULL ,
	[usernum] [nvarchar] (15) ,
	[siteID] [nvarchar] (12) 
) ON [PRIMARY]
;

CREATE TABLE [nt_Channel_House] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[ChID] [int] NOT NULL ,
	[title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassID] [int] NOT NULL ,
	[SpecialID] [nvarchar] (200) ,
	[TitleColor] [nvarchar] (10) ,
	[TitleITF] [tinyint] NULL ,
	[TitleBTF] [tinyint] NULL ,
	[PicURL] [nvarchar] (200) ,
	[Content] [ntext] ,
	[NaviContent] [nvarchar] (200) ,
	[ContentProperty] [nvarchar] (9) ,
	[Author] [nvarchar] (100) ,
	[Editor] [nvarchar] (50) ,
	[Souce] [nvarchar] (100) ,
	[OrderID] [tinyint] NOT NULL ,
	[Tags] [nvarchar] (100) ,
	[Templet] [nvarchar] (200) ,
	[SavePath] [nvarchar] (200) ,
	[FileName] [nvarchar] (100) ,
	[isDelPoint] [tinyint] NOT NULL ,
	[Gpoint] [int] NULL ,
	[iPoint] [int] NULL ,
	[GroupNumber] [ntext] ,
	[Metakeywords] [nvarchar] (200) ,
	[Metadesc] [nvarchar] (200) ,
	[Click] [int] NULL ,
	[CreatTime] [datetime] NULL ,
	[isHTML] [tinyint] NOT NULL ,
	[isConstr] [tinyint] NOT NULL ,
	[ConstrTF] [tinyint] NOT NULL ,
	[islock] [tinyint] NULL ,
	[ch_ddd] [nvarchar] (20) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Channel_Xiazzai] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[ChID] [int] NOT NULL ,
	[title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassID] [int] NOT NULL ,
	[SpecialID] [nvarchar] (200) ,
	[TitleColor] [nvarchar] (10) ,
	[TitleITF] [tinyint] NULL ,
	[TitleBTF] [tinyint] NULL ,
	[PicURL] [nvarchar] (200) ,
	[Content] [ntext] ,
	[NaviContent] [nvarchar] (200) ,
	[ContentProperty] [nvarchar] (9) ,
	[Author] [nvarchar] (100) ,
	[Editor] [nvarchar] (50) ,
	[Souce] [nvarchar] (100) ,
	[OrderID] [tinyint] NOT NULL ,
	[Tags] [nvarchar] (100) ,
	[Templet] [nvarchar] (200) ,
	[SavePath] [nvarchar] (200) ,
	[FileName] [nvarchar] (100) ,
	[isDelPoint] [tinyint] NOT NULL ,
	[Gpoint] [int] NULL ,
	[iPoint] [int] NULL ,
	[GroupNumber] [ntext] ,
	[Metakeywords] [nvarchar] (200) ,
	[Metadesc] [nvarchar] (200) ,
	[Click] [int] NULL ,
	[CreatTime] [datetime] NULL ,
	[isHTML] [tinyint] NOT NULL ,
	[isConstr] [tinyint] NOT NULL ,
	[ConstrTF] [tinyint] NOT NULL ,
	[islock] [tinyint] NULL ,
	[ch_name] [nvarchar] (20) ,
	[ch_neirong] [nvarchar] (20) ,
	[ch_addtime] [nvarchar] (20) 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Collect_News] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Links] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author] [nvarchar] (100) ,
	[Source] [nvarchar] (100) ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NULL ,
	[ImagesCount] [int] NULL ,
	[SiteID] [int] NOT NULL ,
	[Catched_Form] [nvarchar] (50) ,
	[History] [bit] NOT NULL ,
	[RecTF] [bit] NOT NULL ,
	[TodayNewsTF] [bit] NOT NULL ,
	[MarqueeNews] [bit] NOT NULL ,
	[SBSNews] [bit] NOT NULL ,
	[ReviewTF] [bit] NOT NULL ,
	[CollectTime] [datetime] NOT NULL ,
	[ChannelID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Collect_Rule] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[RuleName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OldContent] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ReContent] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[IgnoreCase] [bit] NOT NULL ,
	[ChannelID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Collect_RuleApply] (
	[SiteID] [int] NOT NULL ,
	[RuleID] [int] NOT NULL ,
	[RefreshTime] [datetime] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Collect_Site] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SiteName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[objURL] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Encode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OtherPara] [nvarchar] (50) ,
	[MaxNum] [int] NOT NULL ,
	[ListSetting] [nvarchar] (4000) ,
	[LinkSetting] [nvarchar] (4000) ,
	[OtherType] [int] NULL ,
	[OtherPageSetting] [nvarchar] (4000) ,
	[StartPageNum] [int] NULL ,
	[EndPageNum] [int] NULL ,
	[PagebodySetting] [nvarchar] (4000) ,
	[PageTitleSetting] [nvarchar] (4000) ,
	[OtherNewsType] [int] NULL ,
	[OtherNewsPageSetting] [nvarchar] (4000) ,
	[AuthorSetting] [nvarchar] (4000) ,
	[SourceSetting] [nvarchar] (4000) ,
	[AddDateSetting] [nvarchar] (4000) ,
	[IsAutoCollect] [bit] NOT NULL ,
	[CollectDate] [int] NULL ,
	[TextTF] [bit] NOT NULL ,
	[SaveRemotePic] [bit] NOT NULL ,
	[Audit] [int] NOT NULL ,
	[IsStyle] [bit] NOT NULL ,
	[IsDIV] [bit] NOT NULL ,
	[IsA] [bit] NOT NULL ,
	[IsClass] [bit] NOT NULL ,
	[IsFont] [bit] NOT NULL ,
	[IsSpan] [bit] NOT NULL ,
	[IsObject] [bit] NOT NULL ,
	[IsIFrame] [bit] NOT NULL ,
	[IsScript] [bit] NOT NULL ,
	[IsReverse] [bit] NOT NULL ,
	[IsAutoPicNews] [bit] NOT NULL ,
	[HandSetAuthor] [nvarchar] (50) ,
	[HandSetSource] [nvarchar] (50) ,
	[HandSetAddDate] [datetime] NULL ,
	[Folder] [int] NULL ,
	[ClassID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ChannelID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [nt_Collect_SiteFolder] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SiteFolder] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFolderDetail] [ntext] ,
	[ChannelID] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Customform] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[formname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[formtablename] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[accessorypath] [nvarchar] (100) ,
	[accessorysize] [int] NULL ,
	[memo] [nvarchar] (255) ,
	[islock] [bit] NOT NULL ,
	[timelimited] [bit] NOT NULL ,
	[starttime] [datetime] NULL ,
	[endtime] [datetime] NULL ,
	[showvalidatecode] [bit] NOT NULL ,
	[submitonce] [bit] NOT NULL ,
	[isdelpoint] [tinyint] NOT NULL ,
	[gpoint] [int] NOT NULL ,
	[ipoint] [int] NOT NULL ,
	[groupnumber] [ntext] ,
	[addtime] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Customform_item] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[seriesnumber] [int] NOT NULL ,
	[formid] [int] NOT NULL ,
	[fieldname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[itemname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[itemtype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[defaultvalue] [nvarchar] (50) ,
	[isnotnull] [bit] NOT NULL ,
	[itemsize] [int] NULL ,
	[islock] [bit] NOT NULL ,
	[prompt] [nvarchar] (255) ,
	[selectitem] [ntext] ,
	[addtime] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [nt_Define_Class] (
	[DefineId] [int] IDENTITY (1, 1) NOT NULL ,
	[DefineInfoId] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DefineName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ParentInfoId] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteID] [nvarchar] (12)