乘风网站推广系统 v3.7(Sql)

/*---- 注：只能在 新安装时使用，否则会导致以前乘风网站推广系统所建立的表内数据丢失，但不会对其它 非乘风网站推广系统的表有任何影响 ------*/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_Cfwztg_GetAd_Proc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[WWW_QQCF_COM_Cfwztg_GetAd_Proc] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_Cfwztg_GotoAd_Proc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[WWW_QQCF_COM_Cfwztg_GotoAd_Proc] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_AD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_AD] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Day] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Hour]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Hour] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_AdUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_AdUser] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_Admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_Admin] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_Gbook]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_Gbook] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_LowUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_LowUser] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_RegUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_RegUser] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_Spend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_Spend] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_SysInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_SysInfo] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_UserSite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_UserSite] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_Visit_Ip]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_Visit_Ip] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_CfWztg_Visit_Ly]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_CfWztg_Visit_Ly] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Enough]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Enough] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Expend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Expend] GO CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_AD] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [AdUser_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [AdState] [int] NOT NULL , [Ad_Class] [int] NOT NULL , [AD] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL , [AD_Url] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , [AdWidth] [int] NOT NULL , [AdHeight] [int] NOT NULL , [ClickState] [smallint] NOT NULL , [Unit_Cent] [int] NOT NULL , [TotalClick] [int] NOT NULL , [OverClick] [int] NOT NULL , [AdRegUserState] [smallint] NOT NULL , [AdRegUserDouble] [int] NOT NULL , [AdDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , [AdListShowState] [smallint] NOT NULL , [AdSpareShowState] [smallint] NOT NULL , [AdDeDuct_Rate] [int] NOT NULL , [AddDate] [datetime] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Day] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Ad_ID] [int] NOT NULL , [Display_Counter] [int] NOT NULL , [Click_Counter] [int] NOT NULL , [Reg_Counter] [int] NOT NULL , [AddDate] [datetime] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Hour] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Ad_ID] [int] NOT NULL , [Display_Counter] [int] NOT NULL , [Click_Counter] [int] NOT NULL , [Reg_Counter] [int] NOT NULL , [AddDate] [datetime] NOT NULL , [AddHour] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_AdUser] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [AdUser_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Password] [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 , [PageName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [PageUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [AdShowNum] [int] NOT NULL , [ComVisit] [int] NOT NULL , [ComReg] [int] NOT NULL , [Total_Cent] [int] NOT NULL , [Spend_Cent] [int] NOT NULL , [Spare_Cent] [int] NOT NULL , [Logintotal] [int] NOT NULL , [LastLoginTime] [datetime] NOT NULL , [LastLoginIp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [State] [smallint] NOT NULL , [AddTime] [datetime] NOT NULL , [Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_Admin] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Admin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [EffectTime] [int] NOT NULL , [LyMaxTotal] [int] NOT NULL , [IpMaxTotal] [int] NOT NULL , [LastDelTime] [datetime] NOT NULL , [LowSpendCent] [int] NOT NULL , [PutObj] [int] NOT NULL , [PutRange] [int] NOT NULL , [PutSite] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , [PutRange_2] [int] NOT NULL , [AdClickRate] [int] NOT NULL , [ShowClickInfo] [smallint] NOT NULL , [UserDeDuctState] [smallint] NOT NULL , [UserValid] [smallint] NOT NULL , [AdUserValid] [smallint] NOT NULL , [QQ_State] [smallint] NOT NULL , [QQ_Code] [varchar] (50) 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 , [EamilSendType] [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 Chi