sql.txt

软件下载平台 软件下载平台

GO

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

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

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

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFFilm_Admin] ON [dbo].[CFFilm_Admin]([Admin]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFFilm_Class] ON [dbo].[CFFilm_Class]([ClassName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_CFFilm_Film] ON [dbo].[CFFilm_Film]([ClassID]) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_CFFilm_Link] ON [dbo].[CFFilm_Link]([FilmID], [Assort], [PartNum]) ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFFilm_User] ON [dbo].[CFFilm_User]([UserName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_CFFilm_UserLog] ON [dbo].[CFFilm_UserLog]([UserName], [FilmID], [PartNum], [DoType]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFFilm_Admin] ADD 
	CONSTRAINT [DF_CFFilm_Admin_Title] DEFAULT ('乘风电影程序') FOR [Title],
	CONSTRAINT [DF_CFFilm_Admin_RegState] DEFAULT ((-1)) FOR [RegState],
	CONSTRAINT [DF_CFFilm_Admin_RegAdminCheck] DEFAULT (0) FOR [RegAdminCheck],
	CONSTRAINT [DF_CFFilm_Admin_DotChangeNum] DEFAULT (10) FOR [DotChangeNum],
	CONSTRAINT [DF_CFFilm_Admin_HtmOpen] DEFAULT (0) FOR [HtmOpen],
	CONSTRAINT [DF_CFFilm_Admin_EmailSendType] DEFAULT (1) FOR [EmailSendType],
	CONSTRAINT [DF_CFFilm_Admin_JmailAddress] DEFAULT ('-') FOR [JmailAddress],
	CONSTRAINT [DF_CFFilm_Admin_JmailUser] DEFAULT ('-') FOR [JmailUser],
	CONSTRAINT [DF_CFFilm_Admin_JmailPassword] DEFAULT ('-') FOR [JmailPassword],
	CONSTRAINT [DF_CFFilm_Admin_QQ_State] DEFAULT ((-1)) FOR [QQShow],
	CONSTRAINT [DF_CFFilm_Admin_QQ_Code] DEFAULT ('10000') FOR [QQ_Code],
	CONSTRAINT [DF_CFFilm_Admin_Templet_Play] DEFAULT ('{player}') FOR [Templet_Play],
	CONSTRAINT [DF_CFFilm_Admin_AdCode] DEFAULT ('-') FOR [AdCode],
	CONSTRAINT [DF_CFFilm_Admin_RegType] DEFAULT (1) FOR [RegType],
	CONSTRAINT [DF_CFFilm_Admin_AccessPath] DEFAULT ('-') FOR [AccessPath],
	CONSTRAINT [DF_CFFilm_Admin_SqlServerIP] DEFAULT ('-') FOR [SqlServerIP],
	CONSTRAINT [DF_CFFilm_Admin_SqlServerDbName] DEFAULT ('-') FOR [SqlServerDbName],
	CONSTRAINT [DF_CFFilm_Admin_SqlServerLinkName] DEFAULT ('-') FOR [SqlServerLinkName],
	CONSTRAINT [DF_CFFilm_Admin_SqlServerLinkPassword] DEFAULT ('-') FOR [SqlServerLinkPassword],
	CONSTRAINT [DF_CFFilm_Admin_SaveRegTable] DEFAULT ('-') FOR [SaveRegTable],
	CONSTRAINT [DF_CFFilm_Admin_SaveRegUserName] DEFAULT ('-') FOR [SaveRegUserName],
	CONSTRAINT [DF_CFFilm_Admin_SaveRegPassword] DEFAULT ('-') FOR [SaveRegPassword],
	CONSTRAINT [DF_CFFilm_Admin_PassWordType] DEFAULT (1) FOR [PassWordType],
	CONSTRAINT [DF_CFFilm_Admin_RegUrl] DEFAULT ('http://www.qqcf.com') FOR [RegUrl],
	CONSTRAINT [DF_CFFilm_Admin_LoginUrl] DEFAULT ('http://www.qqcf.com') FOR [LoginUrl],
	CONSTRAINT [DF_CFFilm_Admin_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_CFFilm_Admin_LicensedCode] DEFAULT ('-') FOR [LicensedCode],
	CONSTRAINT [DF_CFFilm_Admin_Ip] DEFAULT ('-') FOR [Ip],
	CONSTRAINT [DF_CFFilm_Admin_LoginTotal] DEFAULT (0) FOR [LoginTotal],
	CONSTRAINT [DF_CFFilm_Admin_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_CFFilm_Admin_Cookies] DEFAULT ('-') FOR [Cookies],
	CONSTRAINT [PK_CFFilm_Admin] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFFilm_Admin_1] ON [dbo].[CFFilm_Admin]([Cookies]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFFilm_Class] ADD 
	CONSTRAINT [DF_CFFilm_Class_ClassTaxis] DEFAULT (1) FOR [ClassTaxis],
	CONSTRAINT [DF_CFFilm_Class_MenuTaxis] DEFAULT (1) FOR [MenuTaxis],
	CONSTRAINT [DF_CFFilm_Class_IndexTaxis] DEFAULT (1) FOR [IndexTaxis],
	CONSTRAINT [PK_CFFilm_Class] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFFilm_Film] ADD 
	CONSTRAINT [DF_CFFilm_Film_FilmOtherName] DEFAULT ('-') FOR [FilmOtherName],
	CONSTRAINT [DF_CFFilm_Film_CommendLevel] DEFAULT (0) FOR [CommendLevel],
	CONSTRAINT [DF_CFFilm_Film_PorduceArea] DEFAULT (1) FOR [PorduceArea],
	CONSTRAINT [DF_CFFilm_Film_PorduceYear] DEFAULT (0) FOR [PorduceYear],
	CONSTRAINT [DF_CFFilm_Film_PorduceMonth] DEFAULT (0) FOR [PorduceMonth],
	CONSTRAINT [DF_CFFilm_Film_Direct] DEFAULT ('-') FOR [Direct],
	CONSTRAINT [DF_CFFilm_Film_Player] DEFAULT ('-') FOR [Player],
	CONSTRAINT [DF_CFFilm_Film_TimeLength] DEFAULT (90) FOR [TimeLength],
	CONSTRAINT [DF_CFFilm_Film_ClickTotal] DEFAULT (0) FOR [ClickTotal],
	CONSTRAINT [DF_CFFilm_Film_ListID] DEFAULT (0) FOR [ListID],
	CONSTRAINT [DF_CFFilm_Film_FilmPic] DEFAULT ('-') FOR [FilmPic],
	CONSTRAINT [DF_CFFilm_Film_FilmIntro] DEFAULT ('-') FOR [FilmIntro],
	CONSTRAINT [DF_CFFilm_Film_OnlineState] DEFAULT (0) FOR [OnlineState],
	CONSTRAINT [DF_CFFilm_Film_OnlineLevel] DEFAULT (1) FOR [OnlineLevel],
	CONSTRAINT [DF_CFFilm_Film_OnlineSpendCount] DEFAULT (0) FOR [OnlineSpendCount],
	CONSTRAINT [DF_CFFilm_Film_OnlineSite] DEFAULT (1) FOR [OnlineSite],
	CONSTRAINT [DF_CFFilm_Film_OnlineProtocol] DEFAULT (1) FOR [OnlineProtocol],
	CONSTRAINT [DF_CFFilm_Film_OnlineServer] DEFAULT (0) FOR [OnlineServer],
	CONSTRAINT [DF_CFFilm_Film_OnlineNum] DEFAULT (0) FOR [OnlineNum],
	CONSTRAINT [DF_CFFilm_Film_DownState] DEFAULT (0) FOR [DownState],
	CONSTRAINT [DF_CFFilm_Film_DownLevel] DEFAULT (1) FOR [DownLevel],
	CONSTRAINT [DF_CFFilm_Film_DownSpendCount] DEFAULT (0) FOR [DownSpendCount],
	CONSTRAINT [DF_CFFilm_Film_DownSite] DEFAULT (0) FOR [DownSite],
	CONSTRAINT [DF_CFFilm_Film_DownProtocol] DEFAULT (1) FOR [DownProtocol],
	CONSTRAINT [DF_CFFilm_Film_DownServer] DEFAULT (0) FOR [DownServer],
	CONSTRAINT [DF_CFFilm_Film_DownNum] DEFAULT (0) FOR [DownNum],
	CONSTRAINT [DF_CFFilm_Film_HtmName] DEFAULT ('-') FOR [HtmName],
	CONSTRAINT [DF_CFFilm_Film_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFFilm_Film_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_CFFilm_Film] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFFilm_Gbook] ADD 
	CONSTRAINT [DF_CFFilm_Gbook_Title] DEFAULT ('-') FOR [Title],
	CONSTRAINT [DF_CFFilm_Gbook_Content] DEFAULT ('-') FOR [Content],
	CONSTRAINT [DF_CFFilm_Gbook_AddTime] DEFAULT (getdate()) FOR [AddTime]
GO

ALTER TABLE [dbo].[CFFilm_Link] ADD 
	CONSTRAINT [PK_CFFilm_Link] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFFilm_User] ADD 
	CONSTRAINT [DF_CFFilm_User_Pwd] DEFAULT ('254a978baaa071ad') FOR [Pwd],
	CONSTRAINT [DF_CFFilm_User_Email] DEFAULT ('-') FOR [Email],
	CONSTRAINT [DF_CFFilm_User_QQ] DEFAULT ('-') FOR [QQ],
	CONSTRAINT [DF_CFFilm_User_PageUrl] DEFAULT ('-') FOR [PageUrl],
	CONSTRAINT [DF_CFFilm_User_Total_Dot] DEFAULT (0) FOR [Total_Dot],
	CONSTRAINT [DF_CFFilm_User_Spend_Dot] DEFAULT (0) FOR [Spend_Dot],
	CONSTRAINT [DF_CFFilm_User_Spare_Dot] DEFAULT (0) FOR [Spare_Dot],
	CONSTRAINT [DF_CFFilm_User_State] DEFAULT ((-1)) FOR [State],
	CONSTRAINT [DF_CFFilm_User_VipState] DEFAULT (0) FOR [VipState],
	CONSTRAINT [DF_CFFilm_User_VipEndTime] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [VipEndDate],
	CONSTRAINT [DF_CFFilm_User_AdminDesc] DEFAULT ('-') FOR [AdminDesc],
	CONSTRAINT [DF_CFFilm_User_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFFilm_User_Cookies] DEFAULT (convert(varchar,datediff(second,'2000-1-1',getdate()))) FOR [Cookies],
	CONSTRAINT [PK_CFFilm_User] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFFilm_User_1] ON [dbo].[CFFilm_User]([Cookies]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFFilm_Server] ADD 
	CONSTRAINT [DF_CFFilm_Server_ServerUser] DEFAULT ('-') FOR [ServerUser],
	CONSTRAINT [DF_CFFilm_Server_ServerPassword] DEFAULT ('-') FOR [ServerPassword]
GO

ALTER TABLE [dbo].[CFFilm_SysInfo] ADD 
	CONSTRAINT [DF_CFFilm_SysInfo_AddTime] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate]
GO

ALTER TABLE [dbo].[CFFilm_UserLog] ADD 
	CONSTRAINT [DF_CFFilm_UserLog_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_CFFilm_UserLog] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO