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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[CFFilm_Admin] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Admin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Title] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RegState] [smallint] NOT NULL ,
	[RegAdminCheck] [smallint] NOT NULL ,
	[DotChangeNum] [int] NOT NULL ,
	[HtmOpen] [smallint] NOT NULL ,
	[EmailSendType] [int] NOT NULL ,
	[JmailAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JmailUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JmailPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QQShow] [smallint] NOT NULL ,
	[QQ_Code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Templet_Play] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdCode] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RegType] [int] NOT NULL ,
	[AccessPath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerDbName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerLinkName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerLinkPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaveRegTable] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaveRegUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaveRegPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PassWordType] [int] NOT NULL ,
	[RegUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoginUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OtherSet] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LicensedCode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoginTotal] [int] NOT NULL ,
	[LastLoginTime] [datetime] NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_Class] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassTaxis] [int] NOT NULL ,
	[MenuTaxis] [int] NOT NULL ,
	[IndexTaxis] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_Film] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FilmName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FilmOtherName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassID] [int] NOT NULL ,
	[CommendLevel] [int] NOT NULL ,
	[PorduceArea] [int] NOT NULL ,
	[PorduceYear] [int] NOT NULL ,
	[PorduceMonth] [int] NOT NULL ,
	[Direct] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Player] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TimeLength] [int] NOT NULL ,
	[ClickTotal] [int] NOT NULL ,
	[ListID] [int] NOT NULL ,
	[FilmPic] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FilmIntro] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OnlineState] [smallint] NOT NULL ,
	[OnlineLevel] [int] NOT NULL ,
	[OnlineSpendCount] [int] NOT NULL ,
	[OnlineSite] [int] NOT NULL ,
	[OnlineProtocol] [int] NOT NULL ,
	[OnlineServer] [int] NOT NULL ,
	[OnlineNum] [int] NOT NULL ,
	[DownState] [smallint] NOT NULL ,
	[DownLevel] [int] NOT NULL ,
	[DownSpendCount] [int] NOT NULL ,
	[DownSite] [int] NOT NULL ,
	[DownProtocol] [int] NOT NULL ,
	[DownServer] [int] NOT NULL ,
	[DownNum] [int] NOT NULL ,
	[HtmName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_Gbook] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Content] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[Reply] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyTime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_Link] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FilmID] [int] NOT NULL ,
	[Assort] [int] NOT NULL ,
	[PartNum] [int] NOT NULL ,
	[Link] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_User] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QQ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PageUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Total_Dot] [int] NOT NULL ,
	[Spend_Dot] [int] NOT NULL ,
	[Spare_Dot] [int] NOT NULL ,
	[State] [smallint] NOT NULL ,
	[VipState] [smallint] NOT NULL ,
	[VipEndDate] [datetime] NOT NULL ,
	[AdminDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_Server] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ServerIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ServerUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ServerPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_SysInfo] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Content] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFFilm_UserLog] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FilmID] [int] NOT NULL ,
	[PartNum] [int] NOT NULL ,
	[DoType] [int] NOT NULL ,
	[Spend_Dot] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY]
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

