/*----
עֻ
°װʱʹãᵼǰ˷վƹϵͳıݶʧ
ǳ˷վƹϵͳıκӰ
------*/
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_RegUserDudect]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[WWW_QQCF_COM_CfWztg_RegUserDudect]
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_Temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[WWW_QQCF_COM_CfWztg_Temp]
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 ,
	[IncomeTop] [smallint] NOT NULL ,
	[SpendTop] [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 Chinese_PRC_CI_AS NOT NULL ,
	[OtherSet] [varchar] (255) 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]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_Gbook] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Assort] [int] NOT NULL ,
	[User_Name] [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].[WWW_QQCF_COM_CfWztg_LowUser] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LowUser_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_RegUser] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_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 ,
	[Bank_Address] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Bank_UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Bank_UserCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Post_Address] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Post_UserNmae] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Post_Zip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Total_Cent] [int] NOT NULL ,
	[Spend_Cent] [int] NOT NULL ,
	[Spare_Cent] [int] NOT NULL ,
	[AdShowNum] [int] NOT NULL ,
	[ComVisit] [int] NOT NULL ,
	[ComReg] [int] NOT NULL ,
	[DeDuct_Rate] [int] NOT NULL ,
	[UserAllSite] [text] COLLATE Chinese_PRC_CI_AS 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 ,
	[AdminDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_RegUserDudect] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Dudect_Cent] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_Spend] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Spend_Cent] [int] NOT NULL ,
	[SpendDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SpendTime] [datetime] NOT NULL ,
	[SpendState] [int] NOT NULL ,
	[SpendAbortFeedBack] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdminCheck] [smallint] NOT NULL ,
	[AdminDesc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdminSpendTime] [datetime] NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_Temp] (
	[MyID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_UserSite] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteState] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_Visit_Ip] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AD_ID] [int] NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ly] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfWztg_Visit_Ly] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AD_ID] [int] NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ly] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Counter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Enough] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdUser_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Enough_Cent] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[AdminDesc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Expend] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[AdUser_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Expend_Cent] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[ExpendDesc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ChaseState] [smallint] NOT NULL ,
	[ChaseClickNum] [int] NOT NULL ,
	[ExpendState] [int] NOT NULL ,
	[ExPendAbortFeedBack] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdminCheck] [smallint] NOT NULL ,
	[AdminDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdminSpendTime] [datetime] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_AD] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdState] DEFAULT (1) FOR [AdState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdWidth] DEFAULT (0) FOR [AdWidth],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdHeight] DEFAULT (0) FOR [AdHeight],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_ClickState] DEFAULT ((-1)) FOR [ClickState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_OverClick] DEFAULT (0) FOR [OverClick],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdRegUserState] DEFAULT (0) FOR [AdRegUserState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdRegUserDouble] DEFAULT (0) FOR [AdRegUserDouble],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdDesc] DEFAULT ('-') FOR [AdDesc],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdListShowState] DEFAULT ((-1)) FOR [AdListShowState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdSpareShowState] DEFAULT ((-1)) FOR [AdSpareShowState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AdDeDuct_Rate] DEFAULT (0) FOR [AdDeDuct_Rate],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_AD] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Day] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Day_Display_Counter] DEFAULT (0) FOR [Display_Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Day_Click_Counter] DEFAULT (0) FOR [Click_Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Day_Reg_Counter] DEFAULT (0) FOR [Reg_Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_AD_Counter_Day] PRIMARY KEY  CLUSTERED 
	(
		[User_Name],
		[Ad_ID],
		[AddDate]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_AD_Counter_Hour] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Hour_Display_Counter] DEFAULT (0) FOR [Display_Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Hour_Click_Counter] DEFAULT (0) FOR [Click_Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Hour_Reg_Counter] DEFAULT (0) FOR [Reg_Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Hour_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AD_Counter_Hour_AddHour] DEFAULT (convert(numeric(2),convert(varchar(2),getdate(),114))) FOR [AddHour],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_AD_Counter_Hour] PRIMARY KEY  CLUSTERED 
	(
		[User_Name],
		[Ad_ID],
		[AddDate],
		[AddHour]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_AdUser] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_EMail] DEFAULT ('-') FOR [EMail],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_QQ] DEFAULT ('-') FOR [QQ],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_PageName] DEFAULT ('-') FOR [PageName],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_PageUrl] DEFAULT ('-') FOR [PageUrl],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_AdShowNum] DEFAULT (0) FOR [AdShowNum],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_ComVisit] DEFAULT (0) FOR [ComVisit],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_ComReg] DEFAULT (0) FOR [ComReg],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_Total_Cent] DEFAULT (0) FOR [Total_Cent],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_Spend_Cent] DEFAULT (0) FOR [Spend_Cent],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_Spare_Cent] DEFAULT (0) FOR [Spare_Cent],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_Logintotal] DEFAULT (0) FOR [Logintotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_LastLoginIp] DEFAULT ('-') FOR [LastLoginIp],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_State] DEFAULT ((-1)) FOR [State],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_AdUser_Cookies] DEFAULT ('-') FOR [Cookies],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_AdUser] PRIMARY KEY  CLUSTERED 
	(
		[AdUser_Name]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_Admin] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_Title] DEFAULT ('˷վƹϵͳhttp://www.qqcf.com') FOR [Title],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_EffectTime] DEFAULT (24) FOR [EffectTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_LyMaxTotal] DEFAULT (1000) FOR [LyMaxTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_IpMaxTotal] DEFAULT (1000) FOR [IpMaxTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_LastDelTime] DEFAULT (getdate()) FOR [LastDelTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_LowSpendCent] DEFAULT (100) FOR [LowSpendCent],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_PutObj] DEFAULT (1) FOR [PutObj],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_PutRange] DEFAULT (1) FOR [PutRange],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_PutSite] DEFAULT ('-') FOR [PutSite],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_PutRange_2] DEFAULT (1) FOR [PutRange_2],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_AdClickRate] DEFAULT (3) FOR [AdClickRate],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_ShowClickInfo] DEFAULT (0) FOR [ShowClickInfo],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_UserDeDuctState] DEFAULT ((-1)) FOR [UserDeDuctState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_UserValid] DEFAULT (0) FOR [UserValid],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_AdUserValid] DEFAULT (0) FOR [AdUserValid],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_IncomeTop] DEFAULT ((-1)) FOR [IncomeTop],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SpendTop] DEFAULT ((-1)) FOR [SpendTop],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_QQ_State] DEFAULT (-1) FOR [QQ_State],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_QQ_Code] DEFAULT ('10000') FOR [QQ_Code],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_RegType] DEFAULT (1) FOR [RegType],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_AccessPath] DEFAULT ('-') FOR [AccessPath],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SqlServerIP] DEFAULT ('-') FOR [SqlServerIP],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SqlServerDbName] DEFAULT ('-') FOR [SqlServerDbName],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SqlServerLinkName] DEFAULT ('-') FOR [SqlServerLinkName],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SqlServerLinkPassword] DEFAULT ('-') FOR [SqlServerLinkPassword],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SaveRegTable] DEFAULT ('-') FOR [SaveRegTable],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SaveRegUserName] DEFAULT ('-') FOR [SaveRegUserName],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_SaveRegPassword] DEFAULT ('-') FOR [SaveRegPassword],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_PassWordType] DEFAULT (1) FOR [PassWordType],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_RegUrl] DEFAULT ('http://www.qqcf.com') FOR [RegUrl],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_LoginUrl] DEFAULT ('http://www.qqcf.com') FOR [LoginUrl],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_EamilSendType] DEFAULT (1) FOR [EamilSendType],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_JmailAddress] DEFAULT ('-') FOR [JmailAddress],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_JmailUser] DEFAULT ('-') FOR [JmailUser],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_JmailPassword] DEFAULT ('-') FOR [JmailPassword],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_LicensedCode] DEFAULT ('-') FOR [LicensedCode],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_Ip] DEFAULT ('-') FOR [Ip],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_LoginTotal] DEFAULT (0) FOR [LoginTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Admin_Cookies] DEFAULT ('-') FOR [Cookies],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_Admin] PRIMARY KEY  CLUSTERED 
	(
		[Admin]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_Gbook] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Gbook_Assort] DEFAULT (1) FOR [Assort],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Gbook_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_Gbook] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_LowUser] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_LowUser_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_LowUser_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_LowUser] PRIMARY KEY  CLUSTERED 
	(
		[LowUser_Name]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_RegUser] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Password] DEFAULT ('254a978baaa071ad') FOR [Password],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_EMail] DEFAULT ('-') FOR [EMail],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_QQ] DEFAULT ('-') FOR [QQ],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_PageName] DEFAULT ('-') FOR [PageName],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_PageUrl] DEFAULT ('-') FOR [PageUrl],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Bank_Address] DEFAULT ('-') FOR [Bank_Address],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Bank_UserName] DEFAULT ('-') FOR [Bank_UserName],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Bank_UserCode] DEFAULT ('-') FOR [Bank_UserCode],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Post_Address] DEFAULT ('-') FOR [Post_Address],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Post_UserNmae] DEFAULT ('-') FOR [Post_UserNmae],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Post_Zip] DEFAULT ('-') FOR [Post_Zip],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Total_Cent] DEFAULT (0) FOR [Total_Cent],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Spend_Cent] DEFAULT (0) FOR [Spend_Cent],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Spare_Cent] DEFAULT (0) FOR [Spare_Cent],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_AdShowNum] DEFAULT (0) FOR [AdShowNum],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_ComVisit] DEFAULT (0) FOR [ComVisit],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_ComReg] DEFAULT (0) FOR [ComReg],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_DeDuct_Rate] DEFAULT (0) FOR [DeDuct_Rate],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_UserAllSite] DEFAULT ('-') FOR [UserAllSite],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Logintotal] DEFAULT (0) FOR [Logintotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_LastLoginIp] DEFAULT ('-') FOR [LastLoginIp],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_State] DEFAULT ((-1)) FOR [State],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_AdminDesc] DEFAULT ('-') FOR [AdminDesc],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUser_Cookies] DEFAULT ('-') FOR [Cookies],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_RegUser] PRIMARY KEY  CLUSTERED 
	(
		[User_Name]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_RegUserDudect] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_RegUserDudect_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_RegUserDudect] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_Spend] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Spend_Spend_Desc] DEFAULT ('-') FOR [SpendDesc],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Spend_SpendTime] DEFAULT (getdate()) FOR [SpendTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Spend_SpendState] DEFAULT (1) FOR [SpendState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Spend_SpendAbortFeedBack] DEFAULT ('-') FOR [SpendAbortFeedBack],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Spend_AdminCheck] DEFAULT (0) FOR [AdminCheck],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Spend_AdminDesc] DEFAULT ('-') FOR [AdminDesc],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Spend_AdminSpendTime] DEFAULT (getdate()) FOR [AdminSpendTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_Spend] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_SysInfo] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_SysInfo_Assort] DEFAULT (1) FOR [Assort],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_SysInfo_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_SysInfo] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_UserSite] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_UserSite_SiteState] DEFAULT (1) FOR [SiteState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_UserSite_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_UserSite] PRIMARY KEY  CLUSTERED 
	(
		[User_Name],
		[SiteUrl]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_Visit_Ip] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Visit_Ip_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Visit_Ip_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_Visit_Ip] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfWztg_Visit_Ly] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Visit_Ly_Counter] DEFAULT (1) FOR [Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Visit_Ly_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Visit_Ly_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfWztg_Visit_Ly_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfWztg_Visit_Ly] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Enough] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Enough_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Enough_AdminDesc] DEFAULT ('-') FOR [AdminDesc],
	CONSTRAINT [PK_WWW_QQCF_COM_Cfwztg_AdUser_Enough] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_Cfwztg_AdUser_Expend] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Expend_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Expend_ChaseState] DEFAULT (0) FOR [ChaseState],
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Expend_ChaseClickNum] DEFAULT (0) FOR [ChaseClickNum],
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Expend_ExpendState] DEFAULT (1) FOR [ExpendState],
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Expend_ExPendAbortFeedBack] DEFAULT ('-') FOR [ExPendAbortFeedBack],
	CONSTRAINT [DF_WWW_QQCF_COM_Cfwztg_AdUser_Expend_AdminCheck] DEFAULT (0) FOR [AdminCheck],
	CONSTRAINT [PK_WWW_QQCF_COM_Cfwztg_AdUser_Expend] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO



CREATE Proc WWW_QQCF_COM_Cfwztg_GetAd_Proc
@User_Name Varchar(50),
@Ad_ID Int
As
/*
====================================================
 *  @Author     ˷
 *  @Web        http://www.qqcf.com
 *  @Date       2005-10-12
 *  @Update     2006-03-24
 *  @Describe   ʾ
====================================================
 */
Declare 	 
@ReturnFlag int,
@RowState int,
@AddDate datetime,
@AddHour int
Set @AddDate=convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))
Set @AddHour=convert(numeric(2),convert(varchar(2),getdate(),114))
Set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction GetAd
Set @ReturnFlag=0
Update WWW_QQCF_COM_CfWztg_RegUser Set AdShowNum=AdShowNum+1 Where User_Name = @User_Name
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Update WWW_QQCF_COM_CfWztg_AD_Counter_Day Set Display_Counter=Display_Counter+1 Where User_Name = @User_Name And Ad_ID = @Ad_ID And AddDate = @AddDate
Select @RowState = @@rowcount
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
If @RowState=0
Begin
Insert Into WWW_QQCF_COM_CfWztg_AD_Counter_Day (User_Name,Ad_ID,Display_Counter) values(@User_Name, @Ad_ID, 1)
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
Update WWW_QQCF_COM_CfWztg_AD_Counter_Hour Set Display_Counter=Display_Counter+1 Where User_Name = @User_Name And Ad_ID = @Ad_ID And AddDate = @AddDate And AddHour = @AddHour
Select @RowState = @@rowcount
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
If @RowState=0
Begin
Insert Into WWW_QQCF_COM_CfWztg_AD_Counter_Hour (User_Name,Ad_ID,Display_Counter) values(@User_Name, @Ad_ID, 1)
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
Commit Transaction GetAd
Return
Error_handler: 
BEGIN
RollBack Transaction GetAd
Return 
END


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO



CREATE Proc WWW_QQCF_COM_Cfwztg_GotoAd_Proc
@User_Name Varchar(50),
@Ad_ID Int,
@Ip Varchar(50),
@Ly Varchar(255),
@LastDelTime Varchar(50),
@LyMaxTotal Int,
@IpMaxTotal Int,
@ClickState Int,
@Unit_Cent Int,
@OverClick Int,
@TotalClick Int
As
/*
====================================================
 *  @Author     ˷
 *  @Web      http://www.qqcf.com
 *  @Date       2005-10-12
 *  @Update     2006-3-21
 *  @Describe   
====================================================
 */
Declare 	 
@sql varchar(1000),
@ReturnFlag int,
@Mycounter int,
@Mycounter_2 int,
@RowState int,
@AddDate varchar(50),
@AddHour int
Set @AddDate=convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))
Set @AddHour=convert(numeric(2),convert(varchar(2),getdate(),114))
Set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction GetAd
Set @ReturnFlag=0
Insert Into WWW_QQCF_COM_CfWztg_Visit_Ip (User_Name,Ad_ID,Ip,Ly) Values (@User_Name, @Ad_ID, @Ip, @Ly)
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Update WWW_QQCF_COM_CfWztg_Visit_Ly Set Counter=Counter+1,Ip = @Ip, LastTime = getdate() Where User_Name = @User_Name And Ad_ID = @Ad_ID And Ly = @Ly And DateDiff(d,AddDate,GetDate())=0
Select @RowState = @@rowcount
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
If @RowState=0
Begin
Insert Into WWW_QQCF_COM_CfWztg_Visit_Ly (User_Name,Ad_ID,Ip,Ly) Values (@User_Name, @Ad_ID, @Ip , @Ly)
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
Update WWW_QQCF_COM_CfWztg_AD_Counter_Day Set Click_Counter=Click_Counter+1 Where User_Name = @User_Name And Ad_ID = @Ad_ID And AddDate = @AddDate
Select @RowState = @@rowcount
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
If @RowState=0
Begin
Insert Into WWW_QQCF_COM_CfWztg_AD_Counter_Day (User_Name,Ad_ID,Click_Counter) Values (@User_Name, @Ad_ID, 1)
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
Update WWW_QQCF_COM_CfWztg_AD_Counter_Hour Set Click_Counter=Click_Counter+1 Where User_Name = @User_Name And Ad_ID = @Ad_ID And AddDate = @AddDate And AddHour = @AddHour
Select @RowState = @@rowcount
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
If @RowState=0
Begin
Insert Into WWW_QQCF_COM_CfWztg_AD_Counter_Hour (User_Name,Ad_ID,Click_Counter) Values (@User_Name , @Ad_ID ,1)
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
If DateDiff(n, @LastDelTime,GetDate())>60 Or DateDiff(n,GetDate(), @LastDelTime)>60
Begin
Select @Mycounter = Count(ID) From WWW_QQCF_COM_CfWztg_Visit_Ly
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
If @Mycounter > @LyMaxTotal
Begin
If object_id('WWW_QQCF_COM_CfWztg_Temp') is not null
Begin
drop table WWW_QQCF_COM_CfWztg_Temp
End
Set @Sql='Select Min(id) as myid Into WWW_QQCF_COM_CfWztg_Temp From WWW_QQCF_COM_CfWztg_Visit_Ly Where ID In (Select Top ' +  convert(varchar, @LyMaxTotal ) +  ' Id From WWW_QQCF_COM_CfWztg_Visit_Ly Order By Id Desc) '
Exec(@sql)
Select @Mycounter_2 = MyID From WWW_QQCF_COM_CfWztg_Temp
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End 
End
Delete From WWW_QQCF_COM_CfWztg_Visit_Ly Where ID<@Mycounter_2
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Select @Mycounter = Count(ID) From WWW_QQCF_COM_CfWztg_Visit_Ip
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End 
If @Mycounter>@IpMaxTotal
Begin
If object_id('WWW_QQCF_COM_CfWztg_Temp') is not null
Begin
drop table WWW_QQCF_COM_CfWztg_Temp
End
Set @Sql='Select Min(id) As MyID Into WWW_QQCF_COM_CfWztg_Temp From WWW_QQCF_COM_CfWztg_Visit_Ip Where ID In (Select Top ' + convert(varchar, @IpMaxTotal ) + ' Id From WWW_QQCF_COM_CfWztg_Visit_Ip Order By Id Desc)'
Exec(@sql)
Select @Mycounter_2 = MyID From WWW_QQCF_COM_CfWztg_Temp
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Delete From WWW_QQCF_COM_CfWztg_Visit_Ip Where ID<@Mycounter_2
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End    
Update WWW_QQCF_COM_CfWztg_Admin Set LastDelTime=GetDate()
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
If @ClickState = -1
Begin
Set @Sql='Update WWW_QQCF_COM_CfWztg_RegUser Set ComVisit=ComVisit+1,Total_Cent=Total_Cent + ' + convert(varchar, @Unit_Cent) + ',Spare_Cent=Spare_Cent + ' +  convert(varchar, @Unit_Cent) + ' Where User_Name = ' + '''' + @User_Name + ''''
Exec(@Sql)
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Update WWW_QQCF_COM_CfWztg_AD Set OverClick=OverClick+1 Where ID = @Ad_ID
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
If @OverClick >= @TotalClick
Begin
Update WWW_QQCF_COM_CfWztg_AD Set AdState=4 Where ID = @Ad_ID
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
End
Commit Transaction GetAd
return
Error_handler: 
BEGIN
RollBack Transaction GetAd
Return
END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


insert into WWW_QQCF_COM_CfWztg_Admin (admin,Password) values('www.qqcf.com','254a978baaa071ad')
Go

insert into WWW_QQCF_COM_CfWztg_RegUser (User_Name,Password) values('qqcf','92b8e739d0ac37c8')
Go


insert into WWW_QQCF_COM_CfWztg_AD (AdUser_Name,AdState,Ad_Class,AD,AD_Url,Unit_Cent,TotalClick,AdSpareShowState) values('myad' , 2 , 1 ,'˷ԭ' ,'http://www.qqcf.com' , 1 , 1000, 0)
Go

insert into WWW_QQCF_COM_CfWztg_AD (AdUser_Name,AdState,Ad_Class,AD,AD_Url,Unit_Cent,TotalClick,AdSpareShowState) values('myad' , 2 , 2 ,'QQCF_AdPic/myad.gif' ,'http://www.qqcf.com' , 1 , 1100, 0)
Go

insert into WWW_QQCF_COM_CfWztg_AD (AdUser_Name,AdState,Ad_Class,AD,AD_Url,Unit_Cent,TotalClick,AdSpareShowState) values('myad' , 2 , 3 ,'˷ԭ' ,'http://www.qqcf.com' , 1 , 1200,0)
Go

insert into WWW_QQCF_COM_CfWztg_AD (AdUser_Name,AdState,Ad_Class,AD,AD_Url,Unit_Cent,TotalClick,AdSpareShowState) values('myad' , 2 , 4 ,'QQCF_AdPic/myad.gif' ,'http://www.qqcf.com' , 1 , 1300,0)
Go

insert into WWW_QQCF_COM_CfWztg_AD (AdUser_Name,AdState,Ad_Class,AD,AD_Url,AdWidth,AdHeight,Unit_Cent,TotalClick,AdSpareShowState,AdRegUserState,AdRegUserDouble) values('myad' , 2 , 5 ,'QQCF_AdPic/myad.gif' ,'http://www.qqcf.com' ,170,60,1 , 1400, -1,-1,10)
Go


insert into WWW_QQCF_COM_CfWztg_AdUser (AdUser_Name,Password,Total_Cent,Spend_Cent,Spare_Cent) values('myad','7e83c85f3fe8d97f',100000,6000,94000)
Go


insert into WWW_QQCF_COM_Cfwztg_AdUser_Enough (AdUser_Name,Enough_Cent,AdminDesc) values('myad',100000,'')
Go


insert into WWW_QQCF_COM_Cfwztg_AdUser_Expend (Ad_ID,AdUser_Name,Expend_Cent,ExpendDesc,ExpendState,AdminCheck,AdminDesc) values(1,'myad',1000,'',2,-1,'')
Go

insert into WWW_QQCF_COM_Cfwztg_AdUser_Expend (Ad_ID,AdUser_Name,Expend_Cent,ExpendDesc,ExpendState,AdminCheck,AdminDesc) values(2,'myad',1100,'',2,-1,'')
Go

insert into WWW_QQCF_COM_Cfwztg_AdUser_Expend (Ad_ID,AdUser_Name,Expend_Cent,ExpendDesc,ExpendState,AdminCheck,AdminDesc) values(3,'myad',1200,'',2,-1,'')
Go

insert into WWW_QQCF_COM_Cfwztg_AdUser_Expend (Ad_ID,AdUser_Name,Expend_Cent,ExpendDesc,ExpendState,AdminCheck,AdminDesc) values(4,'myad',1300,'',2,-1,'')
Go

insert into WWW_QQCF_COM_Cfwztg_AdUser_Expend (Ad_ID,AdUser_Name,Expend_Cent,ExpendDesc,ExpendState,AdminCheck,AdminDesc) values(5,'myad',1400,'',2,-1,'')
Go

/*----
עֻ
°װʱʹãᵼǰ˷վƹϵͳıݶʧ
ǳ˷վƹϵͳıκӰ
------*/
