sql.txt

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

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]