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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[CFCount_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] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TjTextName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LastCleanTime] [datetime] NOT NULL ,
	[LyKeep] [smallint] NOT NULL ,
	[OnlineKeep] [smallint] NOT NULL ,
	[WebKeep] [smallint] NOT NULL ,
	[StyleTotal] [int] NOT NULL ,
	[LogoUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpArea] [smallint] NOT NULL ,
	[TopList] [smallint] NOT NULL ,
	[SkinType] [int] NOT NULL ,
	[SkinColor] [varchar] (50) COLLATE Chinese_PRC_CI_AS 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 ,
	[AllSearch] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Store_Ly] [int] NOT NULL ,
	[Store_TotalLy] [int] NOT NULL ,
	[RegState] [smallint] NOT NULL ,
	[RegAdminCheck] [smallint] NOT NULL ,
	[UserAddSub] [smallint] NOT NULL ,
	[UserAddSubNum] [int] NOT NULL ,
	[UserUseDayState] [smallint] NOT NULL ,
	[UserUseDay] [int] NOT NULL ,
	[UserUpload] [int] NOT NULL ,
	[OtherSet] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoginTotal] [int] NOT NULL ,
	[LastLoginTime] [datetime] NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LicensedCode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Alexa_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Alexa_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Alexa_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Area] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Area] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Area_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Area] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Area_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Area] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Area_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Area] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Back] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BackNum_1] [int] NOT NULL ,
	[BackNum_2] [int] NOT NULL ,
	[BackNum_3] [int] NOT NULL ,
	[BackNum_4] [int] NOT NULL ,
	[BackNum_5] [int] NOT NULL ,
	[BackNum_6] [int] NOT NULL ,
	[BackNum_7] [int] NOT NULL ,
	[BackNum_8] [int] NOT NULL ,
	[BackNum_9] [int] NOT NULL ,
	[BackNum_10] [int] NOT NULL ,
	[BackNum_Higher] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Back_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BackNum_1] [int] NOT NULL ,
	[BackNum_2] [int] NOT NULL ,
	[BackNum_3] [int] NOT NULL ,
	[BackNum_4] [int] NOT NULL ,
	[BackNum_5] [int] NOT NULL ,
	[BackNum_6] [int] NOT NULL ,
	[BackNum_7] [int] NOT NULL ,
	[BackNum_8] [int] NOT NULL ,
	[BackNum_9] [int] NOT NULL ,
	[BackNum_10] [int] NOT NULL ,
	[BackNum_Higher] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Back_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BackNum_1] [int] NOT NULL ,
	[BackNum_2] [int] NOT NULL ,
	[BackNum_3] [int] NOT NULL ,
	[BackNum_4] [int] NOT NULL ,
	[BackNum_5] [int] NOT NULL ,
	[BackNum_6] [int] NOT NULL ,
	[BackNum_7] [int] NOT NULL ,
	[BackNum_8] [int] NOT NULL ,
	[BackNum_9] [int] NOT NULL ,
	[BackNum_10] [int] NOT NULL ,
	[BackNum_Higher] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Back_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BackNum_1] [int] NOT NULL ,
	[BackNum_2] [int] NOT NULL ,
	[BackNum_3] [int] NOT NULL ,
	[BackNum_4] [int] NOT NULL ,
	[BackNum_5] [int] NOT NULL ,
	[BackNum_6] [int] NOT NULL ,
	[BackNum_7] [int] NOT NULL ,
	[BackNum_8] [int] NOT NULL ,
	[BackNum_9] [int] NOT NULL ,
	[BackNum_10] [int] NOT NULL ,
	[BackNum_Higher] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Count_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Count_Hour] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddHour] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Count_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Count_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_IPHead_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_IpAddress] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Ip_1] [float] NOT NULL ,
	[Ip_2] [float] NOT NULL ,
	[Area] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_IpHead] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IPCounter] [int] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_IpHead_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_IpHead_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Ly] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LyHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[Ly] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Ly_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LyHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[Ly] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Ly_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LyHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[Ly] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Ly_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LyHead] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[Ly] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_OtherSet] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZValue] [text] COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Search] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_SearchKeyword] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KeyWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL ,
	[LastLy] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_SearchKeyword_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KeyWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL ,
	[LastLy] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_SearchKeyword_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KeyWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL ,
	[LastLy] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_SearchKeyword_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KeyWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL ,
	[LastLy] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Search_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Search_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Search_Set] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SiteDesc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KeyWordFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Search_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteFlag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Temp] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MyID] [int] NULL ,
	[MyStr] [varchar] (6000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Transfer] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Transfer_Type] [int] NOT NULL ,
	[Transfer_Value] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[CFCount_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 ,
	[Pwd_View] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ParentName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PassWordAsk] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PassWordAnswer] [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 ,
	[Style] [int] NOT NULL ,
	[PicNum] [int] NOT NULL ,
	[ShowTotal] [int] NOT NULL ,
	[RealShowTotal] [int] NOT NULL ,
	[RealIpTotal] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[CounterShow] [smallint] NOT NULL ,
	[ShowType] [int] NOT NULL ,
	[CounterHiddenPic] [int] NOT NULL ,
	[CounterSite] [int] NOT NULL ,
	[ImgCounterShow] [smallint] NOT NULL ,
	[ImgShowType] [int] NOT NULL ,
	[ImgFileName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ImgFontName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ImgFontSize] [int] NOT NULL ,
	[ImgFontColor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ImgFontTop] [int] NOT NULL ,
	[ImgFontLeft] [int] NOT NULL ,
	[ImgFontLingHeight] [int] NOT NULL ,
	[ImgSelfText] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Online] [smallint] NOT NULL ,
	[OnlineTime] [int] NOT NULL ,
	[OnlineShow] [smallint] NOT NULL ,
	[TodayShow] [smallint] NOT NULL ,
	[TodayIpShow] [smallint] NOT NULL ,
	[IpShow] [smallint] NOT NULL ,
	[VisitShow] [smallint] NOT NULL ,
	[TjOpen] [smallint] NOT NULL ,
	[SurveyOpen] [smallint] NOT NULL ,
	[TodayLyOpen] [smallint] NOT NULL ,
	[OnlineOpen] [smallint] NOT NULL ,
	[TodayHourOpen] [smallint] NOT NULL ,
	[EveryDayOpen] [smallint] NOT NULL ,
	[State] [smallint] NOT NULL ,
	[EndDate] [datetime] NOT NULL ,
	[UpLoadState] [int] NOT NULL ,
	[VipState] [smallint] NOT NULL ,
	[VipEndDate] [datetime] NOT NULL ,
	[VipAddSubNum] [int] NOT NULL ,
	[OtherSet] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LoginTotal] [int] NOT NULL ,
	[LastLoginTime] [datetime] NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EmailCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdminDesc] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Web] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WebUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Web_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WebUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Web_Month] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WebUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddMonth] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFCount_Web_Week] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WebUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MyCounter] [int] NOT NULL ,
	[AddYear] [int] NOT NULL ,
	[AddWeek] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

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

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

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

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Alexa] ON [dbo].[CFCount_Alexa_Day]([UserName], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Alexa_Month] ON [dbo].[CFCount_Alexa_Month]([UserName], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Alexa_Week] ON [dbo].[CFCount_Alexa_Week]([UserName], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Area] ON [dbo].[CFCount_Area]([UserName], [Area]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Area_Day] ON [dbo].[CFCount_Area_Day]([UserName], [Area], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Area_Month] ON [dbo].[CFCount_Area_Month]([UserName], [Area], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Area_Week] ON [dbo].[CFCount_Area_Week]([UserName], [Area], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

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

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Back_Day] ON [dbo].[CFCount_Back_Day]([UserName], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Back_Month] ON [dbo].[CFCount_Back_Month]([UserName], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Back_Week] ON [dbo].[CFCount_Back_Week]([UserName], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Count_Day] ON [dbo].[CFCount_Count_Day]([UserName], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Count_Hour] ON [dbo].[CFCount_Count_Hour]([UserName], [AddDate], [AddHour]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Count_Month] ON [dbo].[CFCount_Count_Month]([UserName], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Count_Week] ON [dbo].[CFCount_Count_Week]([UserName], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_IPHead_Week] ON [dbo].[CFCount_IPHead_Week]([UserName], [IpHead], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_IpAddress] ON [dbo].[CFCount_IpAddress]([Ip_1], [Ip_2]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_IpHead_Day] ON [dbo].[CFCount_IpHead_Day]([UserName], [IpHead], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_IpHead_Month] ON [dbo].[CFCount_IpHead_Month]([UserName], [IpHead], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Ly] ON [dbo].[CFCount_Ly]([UserName], [LyHead]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Ly_Day] ON [dbo].[CFCount_Ly_Day]([UserName], [LyHead], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Ly_Month] ON [dbo].[CFCount_Ly_Month]([UserName], [LyHead], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Ly_Week] ON [dbo].[CFCount_Ly_Week]([UserName], [LyHead], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_OtherSet] ON [dbo].[CFCount_OtherSet]([BName], [HName], [LName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Search] ON [dbo].[CFCount_Search]([UserName], [SiteFlag]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_SearchKeyword] ON [dbo].[CFCount_SearchKeyword]([UserName], [SiteFlag], [KeyWord]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_SearchKeyword_Day] ON [dbo].[CFCount_SearchKeyword_Day]([UserName], [SiteFlag], [KeyWord], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_SearchKeyword_Month] ON [dbo].[CFCount_SearchKeyword_Month]([UserName], [SiteFlag], [KeyWord], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_SearchKeyword_Week] ON [dbo].[CFCount_SearchKeyword_Week]([UserName], [SiteFlag], [KeyWord], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Search_Day] ON [dbo].[CFCount_Search_Day]([UserName], [SiteFlag], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Search_Month] ON [dbo].[CFCount_Search_Month]([UserName], [SiteFlag], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Search_Set] ON [dbo].[CFCount_Search_Set]([SiteFlag]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Search_Week] ON [dbo].[CFCount_Search_Week]([UserName], [SiteFlag], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Transfer] ON [dbo].[CFCount_Transfer]([UserName], [Transfer_Type]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Upfile_1] ON [dbo].[CFCount_Upfile]([FileName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

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

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Web] ON [dbo].[CFCount_Web]([UserName], [WebUrl]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Web_Day] ON [dbo].[CFCount_Web_Day]([UserName], [WebUrl], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Web_Month] ON [dbo].[CFCount_Web_Month]([UserName], [WebUrl], [AddYear], [AddMonth]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFCount_Web_Week] ON [dbo].[CFCount_Web_Week]([UserName], [WebUrl], [AddYear], [AddWeek]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Admin] ADD 
	CONSTRAINT [DF_CFCount_Admin_Pwd] DEFAULT ('254a978baaa071ad') FOR [Pwd],
	CONSTRAINT [DF_CFCount_Admin_Title] DEFAULT ('˷û') FOR [Title],
	CONSTRAINT [DF_CFCount_Admin_TjTextName] DEFAULT ('˷ͳ') FOR [TjTextName],
	CONSTRAINT [DF_CFCount_Admin_LastCleanTime] DEFAULT (getdate()) FOR [LastCleanTime],
	CONSTRAINT [DF_CFCount_Admin_LyKeep] DEFAULT ((-1)) FOR [LyKeep],
	CONSTRAINT [DF_CFCount_Admin_OnlineKeep] DEFAULT ((-1)) FOR [OnlineKeep],
	CONSTRAINT [DF_CFCount_Admin_WebKeep] DEFAULT ((-1)) FOR [WebKeep],
	CONSTRAINT [DF_CFCount_Admin_StyleTotal] DEFAULT (60) FOR [StyleTotal],
	CONSTRAINT [DF_CFCount_Admin_LogoUrl] DEFAULT ('images/logo.gif') FOR [LogoUrl],
	CONSTRAINT [DF_CFCount_Admin_IpArea] DEFAULT (0) FOR [IpArea],
	CONSTRAINT [DF_CFCount_Admin_TopList] DEFAULT (0) FOR [TopList],
	CONSTRAINT [DF_CFCount_Admin_SkinType] DEFAULT (0) FOR [SkinType],
	CONSTRAINT [DF_CFCount_Admin_SkinColor] DEFAULT ('BFE7F1') FOR [SkinColor],
	CONSTRAINT [DF_CFCount_Admin_EmailSendType] DEFAULT (1) FOR [EmailSendType],
	CONSTRAINT [DF_CFCount_Admin_JmailAddress] DEFAULT ('-') FOR [JmailAddress],
	CONSTRAINT [DF_CFCount_Admin_JmailUser] DEFAULT ('-') FOR [JmailUser],
	CONSTRAINT [DF_CFCount_Admin_JmailPassword] DEFAULT ('-') FOR [JmailPassword],
	CONSTRAINT [DF_CFCount_Admin_AllSearch] DEFAULT ('zhongsou.com,word|yahoo.com.cn,p|sogou.com,query|sina.com,searchkey|qq.com,w|google.com,q|qqcf.com,qqcf|baidu.com,wd|3721.com,p') FOR [AllSearch],
	CONSTRAINT [DF_CFCount_Admin_Store_Ly] DEFAULT (0) FOR [Store_Ly],
	CONSTRAINT [DF_CFCount_Admin_Store_TotalLy] DEFAULT (0) FOR [Store_TotalLy],
	CONSTRAINT [DF_CFCount_Admin_RegeditState] DEFAULT ((-1)) FOR [RegState],
	CONSTRAINT [DF_CFCount_Admin_RegAdminCheck] DEFAULT (0) FOR [RegAdminCheck],
	CONSTRAINT [DF_CFCount_Admin_UserAddSub] DEFAULT ((-1)) FOR [UserAddSub],
	CONSTRAINT [DF_CFCount_Admin_UserAddSubNum] DEFAULT (10) FOR [UserAddSubNum],
	CONSTRAINT [DF_CFCount_Admin_UserUseDayState] DEFAULT (0) FOR [UserUseDayState],
	CONSTRAINT [DF_CFCount_Admin_UserUseDay] DEFAULT (365) FOR [UserUseDay],
	CONSTRAINT [DF_CFCount_Admin_UserUpload] DEFAULT ((-1)) FOR [UserUpload],
	CONSTRAINT [DF_CFCount_Admin_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_CFCount_Admin_LoginTotal] DEFAULT (0) FOR [LoginTotal],
	CONSTRAINT [DF_CFCount_Admin_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_CFCount_Admin_Ip] DEFAULT ('-') FOR [Ip],
	CONSTRAINT [DF_CFCount_Admin_LicensedCode] DEFAULT ('-') FOR [LicensedCode],
	CONSTRAINT [DF_CFCount_Admin_Cookies] DEFAULT ('-') FOR [Cookies],
	CONSTRAINT [PK_CFCount_Admin] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFCount_Admin_1] ON [dbo].[CFCount_Admin]([Cookies]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Alexa_Day] ADD 
	CONSTRAINT [DF_CFCount_Alexa_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Alexa_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFCount_Alexa_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Alexa_Month] ADD 
	CONSTRAINT [DF_Alexa_Month_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_Alexa_Month_AddYea] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_Alexa_Month_AddWeek] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [PK_CFCount_Alexa_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Alexa_Week] ADD 
	CONSTRAINT [DF_CFCount_Alexa_Week_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Alexa_Week_AddDate] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Alexa_Week_AddWeek] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [PK_CFCount_Alexa_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Area] ADD 
	CONSTRAINT [DF_CFCount_Area_Area] DEFAULT ('-') FOR [Area],
	CONSTRAINT [DF_CFCount_Area_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Area_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Area_AddDate] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Area] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Area_1] ON [dbo].[CFCount_Area]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Area_Day] ADD 
	CONSTRAINT [DF_CFCount_Area_Count_Area] DEFAULT ('-') FOR [Area],
	CONSTRAINT [DF_CFCount_Area_Count_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Area_Count_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_Area_Day_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Area_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Area_Day_1] ON [dbo].[CFCount_Area_Day]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Area_Month] ADD 
	CONSTRAINT [DF_CFCount_Area_Month_Area] DEFAULT ('-') FOR [Area],
	CONSTRAINT [DF_CFCount_Area_Month_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Area_Month_AddDate] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Area_Month_AddMonth] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [DF_CFCount_Area_Month_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Area_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Area_Month_1] ON [dbo].[CFCount_Area_Month]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Area_Week] ADD 
	CONSTRAINT [DF_CFCount_Area_Week_Area] DEFAULT ('-') FOR [Area],
	CONSTRAINT [DF_CFCount_Area_Week_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Area_Week_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Area_Week_AddMonth] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [DF_CFCount_Area_Week_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Area_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Area_Week_1] ON [dbo].[CFCount_Area_Week]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Back] ADD 
	CONSTRAINT [DF_CFCount_Back_BackNum_1] DEFAULT (0) FOR [BackNum_1],
	CONSTRAINT [DF_CFCount_Back_BackNum_2] DEFAULT (0) FOR [BackNum_2],
	CONSTRAINT [DF_CFCount_Back_BackNum_3] DEFAULT (0) FOR [BackNum_3],
	CONSTRAINT [DF_CFCount_Back_BackNum_4] DEFAULT (0) FOR [BackNum_4],
	CONSTRAINT [DF_CFCount_Back_BackNum_5] DEFAULT (0) FOR [BackNum_5],
	CONSTRAINT [DF_CFCount_Back_BackNum_6] DEFAULT (0) FOR [BackNum_6],
	CONSTRAINT [DF_CFCount_Back_BackNum_7] DEFAULT (0) FOR [BackNum_7],
	CONSTRAINT [DF_CFCount_Back_BackNum_8] DEFAULT (0) FOR [BackNum_8],
	CONSTRAINT [DF_CFCount_Back_BackNum_9] DEFAULT (0) FOR [BackNum_9],
	CONSTRAINT [DF_CFCount_Back_BackNum_10] DEFAULT (0) FOR [BackNum_10],
	CONSTRAINT [DF_CFCount_Back_BackNum_Higher] DEFAULT (0) FOR [BackNum_Higher],
	CONSTRAINT [PK_CFCount_Back] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Back_Day] ADD 
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_1] DEFAULT (0) FOR [BackNum_1],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_2] DEFAULT (0) FOR [BackNum_2],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_3] DEFAULT (0) FOR [BackNum_3],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_4] DEFAULT (0) FOR [BackNum_4],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_5] DEFAULT (0) FOR [BackNum_5],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_6] DEFAULT (0) FOR [BackNum_6],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_7] DEFAULT (0) FOR [BackNum_7],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_8] DEFAULT (0) FOR [BackNum_8],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_9] DEFAULT (0) FOR [BackNum_9],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_10] DEFAULT (0) FOR [BackNum_10],
	CONSTRAINT [DF_CFCount_Back_Day_BackNum_Higher] DEFAULT (0) FOR [BackNum_Higher],
	CONSTRAINT [DF_CFCount_Back_Day_AddDate_6] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFCount_Back_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Back_Month] ADD 
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_1] DEFAULT (0) FOR [BackNum_1],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_2] DEFAULT (0) FOR [BackNum_2],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_3] DEFAULT (0) FOR [BackNum_3],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_4] DEFAULT (0) FOR [BackNum_4],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_5] DEFAULT (0) FOR [BackNum_5],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_6] DEFAULT (0) FOR [BackNum_6],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_7] DEFAULT (0) FOR [BackNum_7],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_8] DEFAULT (0) FOR [BackNum_8],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_9] DEFAULT (0) FOR [BackNum_9],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_10] DEFAULT (0) FOR [BackNum_10],
	CONSTRAINT [DF_CFCount_Back_Month_BackNum_Higher] DEFAULT (0) FOR [BackNum_Higher],
	CONSTRAINT [DF_CFCount_Back_Month_AddYear_4] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Back_Month_AddWeek_3] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [PK_CFCount_Back_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Back_Week] ADD 
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_1] DEFAULT (0) FOR [BackNum_1],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_2] DEFAULT (0) FOR [BackNum_2],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_3] DEFAULT (0) FOR [BackNum_3],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_4] DEFAULT (0) FOR [BackNum_4],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_5] DEFAULT (0) FOR [BackNum_5],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_6] DEFAULT (0) FOR [BackNum_6],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_7] DEFAULT (0) FOR [BackNum_7],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_8] DEFAULT (0) FOR [BackNum_8],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_9] DEFAULT (0) FOR [BackNum_9],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_10] DEFAULT (0) FOR [BackNum_10],
	CONSTRAINT [DF_CFCount_Back_Week_BackNum_Higher] DEFAULT (0) FOR [BackNum_Higher],
	CONSTRAINT [DF_CFCount_Back_Week_AddDate_7] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Back_Week_AddWeek_2] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [PK_CFCount_Back_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Count_Day] ADD 
	CONSTRAINT [DF_CFCount_Day_Count_Counter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Day_Count_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Day_Count_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFCount_Count_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Count_Hour] ADD 
	CONSTRAINT [DF_CFCount_Hour_Count_Counter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Hour_Count_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Hour_Count_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_Hour_Count_AddHour] DEFAULT (convert(int,datename(hour,getdate()))) FOR [AddHour],
	CONSTRAINT [PK_CFCount_Count_Hour] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Count_Month] ADD 
	CONSTRAINT [DF_CFCount_Month_Count_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Month_Count_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Month_Count_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Month_Count_AddMonth] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [PK_CFCount_Count_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Count_Week] ADD 
	CONSTRAINT [DF_CFCount_Count_Week_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Count_Week_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Count_Week_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Count_Week_AddWeek] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [PK_CFCount_Count_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_IPHead_Week] ADD 
	CONSTRAINT [DF_CFCount_IPHead_Week_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_IPHead_Week_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_IPHead_Week_AddWeek] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [DF_CFCount_IPHead_Week_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_IPHead_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_IPHead_Week_1] ON [dbo].[CFCount_IPHead_Week]([LastTime]) ON [PRIMARY]
GO

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

ALTER TABLE [dbo].[CFCount_IpHead] ADD 
	CONSTRAINT [DF_CFCount_IpHead_IPCounter_1] DEFAULT (1) FOR [IPCounter],
	CONSTRAINT [DF_CFCount_IpHead_LastTime] DEFAULT (getdate()) FOR [LastTime]
GO

 CREATE  UNIQUE  INDEX [IX_CFCount_IpHead] ON [dbo].[CFCount_IpHead]([UserName], [IpHead]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  INDEX [IX_CFCount_IpHead_1] ON [dbo].[CFCount_IpHead]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_IpHead_Day] ADD 
	CONSTRAINT [DF_CFCount_IpHead_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_IpHead_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_IpHead_Day_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_IpHead_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_IpHead_Day_1] ON [dbo].[CFCount_IpHead_Day]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_IpHead_Month] ADD 
	CONSTRAINT [DF_CFCount_IpHead_Month_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_IpHead_Month_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_IpHead_Month_AddMonth] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [DF_CFCount_IpHead_Month_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_IpHead_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_IpHead_Month_1] ON [dbo].[CFCount_IpHead_Month]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Ly] ADD 
	CONSTRAINT [DF_CFCount_Ly_MyCounter_1] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Ly_IpCounter_1] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Ly_AddDate_1] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_Ly_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Ly] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Ly_1] ON [dbo].[CFCount_Ly]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Ly_Day] ADD 
	CONSTRAINT [DF_CFCount_Ly_Day_Counter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Ly_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Ly_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_Ly_Day_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_Ly_Day_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Ly_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Ly_Day_1] ON [dbo].[CFCount_Ly_Day]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Ly_Month] ADD 
	CONSTRAINT [DF_CFCount_Ly_Month_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Ly_Month_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Ly_Month_AddDate] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Ly_Month_AddTime] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [DF_CFCount_Ly_Month_AddTime_1] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_Ly_Month_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Ly_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Ly_Month_1] ON [dbo].[CFCount_Ly_Month]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Ly_Week] ADD 
	CONSTRAINT [DF_CFCount_Ly_Week_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Ly_Week_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Ly_Week_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Ly_Week_AddMonth] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [DF_CFCount_Ly_Week_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_Ly_Week_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Ly_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Ly_Week_1] ON [dbo].[CFCount_Ly_Week]([LastTime]) ON [PRIMARY]
GO

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

ALTER TABLE [dbo].[CFCount_Search] ADD 
	CONSTRAINT [DF_CFCount_Search_Count_Counter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Search_Count_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [PK_CFCount_Search] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_SearchKeyword] ADD 
	CONSTRAINT [DF_CFCount_SearchKeyword_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_SearchKeyword_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_SearchKeyword] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_SearchKeyword_1] ON [dbo].[CFCount_SearchKeyword]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_SearchKeyword_Day] ADD 
	CONSTRAINT [DF_CFCount_SearchKeyword_Count_Counter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_Count_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_SearchKeyword_Day_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_SearchKeyword_Count_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_SearchKeyword_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_SearchKeyword_Day_1] ON [dbo].[CFCount_SearchKeyword_Day]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_SearchKeyword_Month] ADD 
	CONSTRAINT [DF_CFCount_SearchKeyword_Month_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_Month_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_Month_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_SearchKeyword_Month_AddMonth] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [DF_CFCount_SearchKeyword_Month_AddDate] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_SearchKeyword_Month_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_SearchKeyword_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_SearchKeyword_Month_1] ON [dbo].[CFCount_SearchKeyword_Month]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_SearchKeyword_Week] ADD 
	CONSTRAINT [DF_CFCount_SearchKeyword_Week_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_Week_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_SearchKeyword_Week_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_SearchKeyword_Week_AddMonth] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [DF_CFCount_SearchKeyword_Week_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_SearchKeyword_Week_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_SearchKeyword_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_SearchKeyword_Week_1] ON [dbo].[CFCount_SearchKeyword_Week]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Search_Day] ADD 
	CONSTRAINT [DF_CFCount_Search_Day_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Search_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Search_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFCount_Search_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Search_Month] ADD 
	CONSTRAINT [DF_CFCount_Search_Month_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Search_Month_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Search_Month_AddDate] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Search_Month_AddMonth] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [PK_CFCount_Search_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

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

ALTER TABLE [dbo].[CFCount_Search_Week] ADD 
	CONSTRAINT [DF_CFCount_Search_Week_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Search_Week_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFCount_Search_Week_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Search_Week_AddMonth] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [PK_CFCount_Search_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFCount_Temp] ADD 
	CONSTRAINT [DF_CFCount_Temp_MyID] DEFAULT (0) FOR [MyID],
	CONSTRAINT [DF_CFCount_Temp_MyStr] DEFAULT ('-') FOR [MyStr]
GO

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

ALTER TABLE [dbo].[CFCount_Upfile] ADD 
	CONSTRAINT [DF_CFCount_Upfile_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_CFCount_Upfile] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFCount_Upfile] ON [dbo].[CFCount_Upfile]([FileName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_User] ADD 
	CONSTRAINT [DF_CFCount_User_Pwd] DEFAULT ('254a978baaa071ad') FOR [Pwd],
	CONSTRAINT [DF_CFCount_User_Pwd_2] DEFAULT ('254a978baaa071ad') FOR [Pwd_View],
	CONSTRAINT [DF_CFCount_User_ParentName] DEFAULT ('-') FOR [ParentName],
	CONSTRAINT [DF_CFCount_User_PassWordAsk] DEFAULT ('-') FOR [PassWordAsk],
	CONSTRAINT [DF_CFCount_User_PassWordAnswer] DEFAULT ('-') FOR [PassWordAnswer],
	CONSTRAINT [DF_CFCount_User_Email] DEFAULT ('-') FOR [Email],
	CONSTRAINT [DF_CFCount_User_QQ] DEFAULT ('-') FOR [QQ],
	CONSTRAINT [DF_CFCount_User_PageName] DEFAULT ('-') FOR [PageName],
	CONSTRAINT [DF_CFCount_User_PageUrl] DEFAULT ('-') FOR [PageUrl],
	CONSTRAINT [DF_CFCount_User_Style] DEFAULT (1) FOR [Style],
	CONSTRAINT [DF_CFCount_User_PicNum] DEFAULT (8) FOR [PicNum],
	CONSTRAINT [DF_CFCount_User_ShowTotal] DEFAULT (0) FOR [ShowTotal],
	CONSTRAINT [DF_CFCount_User_RealShowTotal] DEFAULT (0) FOR [RealShowTotal],
	CONSTRAINT [DF_CFCount_User_RealIpTotal] DEFAULT (0) FOR [RealIpTotal],
	CONSTRAINT [DF_CFCount_User_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_User_CounterShow] DEFAULT (0) FOR [CounterShow],
	CONSTRAINT [DF_CFCount_User_ShowType] DEFAULT (1) FOR [ShowType],
	CONSTRAINT [DF_CFCount_User_CounterHiddenPic] DEFAULT (1) FOR [CounterHiddenPic],
	CONSTRAINT [DF_CFCount_User_CounterSite] DEFAULT (3) FOR [CounterSite],
	CONSTRAINT [DF_CFCount_User_ImgCounterShow] DEFAULT ((-1)) FOR [ImgCounterShow],
	CONSTRAINT [DF_CFCount_User_ImgShowType] DEFAULT (1) FOR [ImgShowType],
	CONSTRAINT [DF_CFCount_User_ImgFileName] DEFAULT ('default.jpg') FOR [ImgFileName],
	CONSTRAINT [DF_CFCount_User_ImgFont] DEFAULT ('') FOR [ImgFontName],
	CONSTRAINT [DF_CFCount_User_ImgFontSize] DEFAULT (12) FOR [ImgFontSize],
	CONSTRAINT [DF_CFCount_User_ImgFontColor] DEFAULT ('black') FOR [ImgFontColor],
	CONSTRAINT [DF_CFCount_User_ImgFontTop] DEFAULT (15) FOR [ImgFontTop],
	CONSTRAINT [DF_CFCount_User_ImgFontLeft] DEFAULT (15) FOR [ImgFontLeft],
	CONSTRAINT [DF_CFCount_User_ImgFontLingHeight] DEFAULT (15) FOR [ImgFontLingHeight],
	CONSTRAINT [DF_CFCount_User_ImgSelfText] DEFAULT ('-') FOR [ImgSelfText],
	CONSTRAINT [DF_CFCount_User_Online] DEFAULT ((-1)) FOR [Online],
	CONSTRAINT [DF_CFCount_User_OnlineTime] DEFAULT (30) FOR [OnlineTime],
	CONSTRAINT [DF_CFCount_User_OnlineShow] DEFAULT ((-1)) FOR [OnlineShow],
	CONSTRAINT [DF_CFCount_User_TodayShow] DEFAULT (0) FOR [TodayShow],
	CONSTRAINT [DF_CFCount_User_TodayIpShow] DEFAULT (0) FOR [TodayIpShow],
	CONSTRAINT [DF_CFCount_User_IpShow] DEFAULT ((-1)) FOR [IpShow],
	CONSTRAINT [DF_CFCount_User_VisitShow] DEFAULT ((-1)) FOR [VisitShow],
	CONSTRAINT [DF_CFCount_User_TjOpen] DEFAULT (0) FOR [TjOpen],
	CONSTRAINT [DF_CFCount_User_SurveyOpen] DEFAULT ((-1)) FOR [SurveyOpen],
	CONSTRAINT [DF_CFCount_User_TodayLyOpen] DEFAULT ((-1)) FOR [TodayLyOpen],
	CONSTRAINT [DF_CFCount_User_OnlineOpen] DEFAULT ((-1)) FOR [OnlineOpen],
	CONSTRAINT [DF_CFCount_User_TodayHourOpen] DEFAULT ((-1)) FOR [TodayHourOpen],
	CONSTRAINT [DF_CFCount_User_EveryDayOpen] DEFAULT ((-1)) FOR [EveryDayOpen],
	CONSTRAINT [DF_CFCount_User_State] DEFAULT ((-1)) FOR [State],
	CONSTRAINT [DF_CFCount_User_EndDate] DEFAULT (dateadd(day,365,convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate()))))) FOR [EndDate],
	CONSTRAINT [DF_CFCount_User_UpLoadState] DEFAULT ((-1)) FOR [UpLoadState],
	CONSTRAINT [DF_CFCount_User_VipState] DEFAULT (0) FOR [VipState],
	CONSTRAINT [DF_CFCount_User_VipEndDate] DEFAULT (dateadd(day,365,convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate()))))) FOR [VipEndDate],
	CONSTRAINT [DF_CFCount_User_VipAddSubNum] DEFAULT (0) FOR [VipAddSubNum],
	CONSTRAINT [DF_CFCount_User_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_CFCount_User_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_User_LoginTotal] DEFAULT (0) FOR [LoginTotal],
	CONSTRAINT [DF_CFCount_User_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_CFCount_User_Cookies] DEFAULT (convert(varchar,datediff(second,'2000-1-1',getdate()))) FOR [Cookies],
	CONSTRAINT [DF_CFCount_User_EmailCode] DEFAULT ('-') FOR [EmailCode],
	CONSTRAINT [DF_CFCount_User_AdminDesc] DEFAULT ('-') FOR [AdminDesc],
	CONSTRAINT [PK_CFCount_User] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFCount_User_1] ON [dbo].[CFCount_User]([Cookies]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Web] ADD 
	CONSTRAINT [DF_CFCount_Web_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Web_AddDate] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_Web_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Web] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Web_1] ON [dbo].[CFCount_Web]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Web_Day] ADD 
	CONSTRAINT [DF_CFCount_WebCount_Counter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_WebCount_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_Web_Day_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_WebCount_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Web_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Web_Day_1] ON [dbo].[CFCount_Web_Day]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Web_Month] ADD 
	CONSTRAINT [DF_CFCount_Web_Month_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Web_Month_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Web_Month_AddMonth] DEFAULT (convert(int,datename(month,getdate()))) FOR [AddMonth],
	CONSTRAINT [DF_CFCount_Web_Month_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFCount_Web_Month_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_Web_Month_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Web_Month] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Web_Month_1] ON [dbo].[CFCount_Web_Month]([LastTime]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFCount_Web_Week] ADD 
	CONSTRAINT [DF_CFCount_Web_Week_MyCounter] DEFAULT (1) FOR [MyCounter],
	CONSTRAINT [DF_CFCount_Web_Week_AddYear] DEFAULT (convert(int,datename(year,getdate()))) FOR [AddYear],
	CONSTRAINT [DF_CFCount_Web_Week_AddDate] DEFAULT (datepart(week,getdate())) FOR [AddWeek],
	CONSTRAINT [DF_CFCount_Web_Week_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFCount_Web_Week_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFCount_Web_Week] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_CFCount_Web_Week_1] ON [dbo].[CFCount_Web_Week]([LastTime]) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO


CREATE Proc CFCount_Clear_Proc
@AlexaKeepDay Int,
@AreaKeepDay Int,
@AreaKeepWeek Int,
@BackKeepDay Int,
@CountKeepDay Int,
@HourCountKeepDay Int,
@IpHeadKeepDay Int,
@LyKeepDay Int,
@SearchKeepDay Int,
@KeywordKeepDay Int,
@KeywordKeepWeek Int,
@WebKeepDay Int,
@WebKeepWeek Int,
@TdayNum Int,
@TdayBFNum Int,
@TweekNum Int,
@TweekBFNum Int,
@TMonthNum Int,
@TMonthBFNum Int,
@TableJLNum Int
As
/*
====================================================
 *  @Author     ˷
 *  @Web      http://www.qqcf.com
 *  @Describe   
====================================================
 */
declare
@sql varchar(1000),
@MyCounter int,
@AddYear Int,
@AddWeek Int,
@AddMonth Int
set @AddYear = convert(int,(datename(year,getdate())))
set @AddWeek = datepart(week,getdate())
set @AddMonth = convert(int,(datename(month,getdate())))
set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction ClearTrans
Delete From CFCount_Alexa_Day Where DateDiff(d,AddDate,GetDate())>@AlexaKeepDay
Delete From CFCount_Area_Day Where DateDiff(d,AddDate,GetDate())>@AreaKeepDay
Delete From CFCount_Back_Day Where DateDiff(d,AddDate,GetDate())>@BackKeepDay
Delete From CFCount_Count_Day Where DateDiff(d,AddDate,GetDate())>@CountKeepDay
Delete From CFCount_Count_Hour Where DateDiff(d,AddDate,GetDate())>@HourCountKeepDay
Delete From CFCount_IpHead_Day Where DateDiff(d,AddDate,GetDate())>@IpHeadKeepDay
Delete From CFCount_Ly_Day Where DateDiff(d,AddDate,GetDate())>@LyKeepDay
Delete From CFCount_Search_Day Where DateDiff(d,AddDate,GetDate())>@SearchKeepDay
Delete From CFCount_SearchKeyword_Day Where DateDiff(d,AddDate,GetDate())>@KeywordKeepDay
Delete From CFCount_Web_Day Where DateDiff(d,AddDate,GetDate())>@WebKeepDay
set @sql= 'Delete CFCount_Area Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TableJLNum ) + ' LastTime From CFCount_Area  order by LastTime desc) a)'
Exec(@sql)
set @sql= 'Delete CFCount_IpHead Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TableJLNum ) + ' LastTime From CFCount_IpHead  order by LastTime desc) a)'
Exec(@sql)
set @sql= 'Delete CFCount_Ly Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TableJLNum ) + ' LastTime From CFCount_Ly  order by LastTime desc) a)'
Exec(@sql)
set @sql= 'Delete CFCount_SearchKeyword Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TableJLNum ) + ' LastTime From CFCount_SearchKeyword  order by LastTime desc) a)'
Exec(@sql)
set @sql= 'Delete CFCount_SearchKeyword_Day Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TdayNum ) + ' LastTime From CFCount_SearchKeyword_Day Where DateDiff(d,AddDate,GetDate())=0 order by LastTime desc) a) And DateDiff(d,AddDate,GetDate())=0'
Exec(@sql)
set @sql= 'Delete CFCount_SearchKeyword_Day Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TdayBFNum ) + ' LastTime From CFCount_SearchKeyword_Day Where DateDiff(d,AddDate,GetDate())>0 order by LastTime desc) a) And DateDiff(d,AddDate,GetDate())>0'
Exec(@sql)
set @sql= 'Delete CFCount_Web Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TableJLNum ) + ' LastTime From CFCount_Web  order by LastTime desc) a)'
Exec(@sql)
set @sql= 'Delete CFCount_Web_Day Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TdayNum ) + ' LastTime From CFCount_Web_Day Where DateDiff(d,AddDate,GetDate())=0 order by LastTime desc) a) And DateDiff(d,AddDate,GetDate())=0'
Exec(@sql)
set @sql= 'Delete CFCount_Web_Day Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TdayBFNum ) + ' LastTime From CFCount_Web_Day Where DateDiff(d,AddDate,GetDate())>0 order by LastTime desc) a) And DateDiff(d,AddDate,GetDate())>0'
Exec(@sql)
set @sql= 'Delete CFCount_Alexa_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekNum ) + ' ID From CFCount_Alexa_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_Alexa_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekBFNum ) + ' ID From CFCount_Alexa_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Alexa_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthNum ) + ' ID From CFCount_Alexa_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_Alexa_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' ID From CFCount_Alexa_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Area_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekNum ) + ' LastTime From CFCount_Area_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_Area_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekBFNum ) + ' LastTime From CFCount_Area_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Area_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthNum ) + ' LastTime From CFCount_Area_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_Area_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' LastTime From CFCount_Area_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Back_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekNum ) + ' ID From CFCount_Back_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_Back_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekBFNum ) + ' ID From CFCount_Back_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Back_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthNum ) + ' ID From CFCount_Back_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_Back_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' ID From CFCount_Back_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Count_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekNum ) + ' ID From CFCount_Count_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_Count_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekBFNum ) + ' ID From CFCount_Count_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Count_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthNum ) + ' ID From CFCount_Count_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_Count_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' ID From CFCount_Count_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_IPHead_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekNum ) + ' LastTime From CFCount_IPHead_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_IPHead_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekBFNum ) + ' LastTime From CFCount_IPHead_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_IPHead_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthNum ) + ' LastTime From CFCount_IPHead_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_IPHead_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' LastTime From CFCount_IPHead_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Ly_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekNum ) + ' LastTime From CFCount_Ly_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_Ly_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekBFNum ) + ' LastTime From CFCount_Ly_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Ly_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthNum ) + ' LastTime From CFCount_Ly_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_Ly_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' LastTime From CFCount_Ly_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Search_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekNum ) + ' ID From CFCount_Search_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_Search_Week Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TweekBFNum ) + ' ID From CFCount_Search_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Search_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthNum ) + ' ID From CFCount_Search_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by id desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_Search_Month Where ID < (select Min(ID) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' ID From CFCount_Search_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by id desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_SearchKeyword_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekNum ) + ' LastTime From CFCount_SearchKeyword_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_SearchKeyword_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekBFNum ) + ' LastTime From CFCount_SearchKeyword_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_SearchKeyword_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthNum ) + ' LastTime From CFCount_SearchKeyword_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_SearchKeyword_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' LastTime From CFCount_SearchKeyword_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Web_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekNum ) + ' LastTime From CFCount_Web_Week where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@sql)
set @sql= 'Delete CFCount_Web_Week Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TweekBFNum ) + ' LastTime From CFCount_Web_Week where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek) + ')'
Exec(@sql)
set @sql= 'Delete CFCount_Web_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthNum ) + ' LastTime From CFCount_Web_Month where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +' order by LastTime desc) a Where AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')  And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@sql)
set @sql= 'Delete CFCount_Web_Month Where LastTime < (select Min(LastTime) From (select Top ' + convert(varchar, @TMonthBFNum ) + ' LastTime From CFCount_Web_Month where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +') order by LastTime desc) a Where Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) +')) And Not(AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth) + ')'
Exec(@sql)
Update CFCount_Admin Set LastCleanTime = GetDate()
IF @@error<>0
Begin
goto error_handler
End
Commit Transaction ClearTrans
Return
Error_handler: 
BEGIN
RollBack Transaction ClearTrans
Return
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO


CREATE Proc CFCount_TjSurvey_Proc
@UserName Varchar(50),
@BzksDate Varchar(50),
@SzksDate Varchar(50),
@SzmDate Varchar(50),
@SyDate Varchar(50)
As
/*
====================================================
 *  @Author     ˷
 *  @Web      http://www.qqcf.com
 *  @Describe   ͳƸſ
====================================================
 */
Declare
@AddHour int,
@AddYear int,
@AddMonth int,
@SyYear int,
@SyMonth int,
@Sql Varchar(1000),
@MyStr Varchar(1000),
@ParentName Varchar(50),
@State int,
@EndDate DateTime,
@VipState int,
@VipEndDate DateTime,
@VipAddSubNum int,
@PageName Varchar(50),
@PageUrl Varchar(50),
@AddTime DateTime,
@RealShowTotal Int,
@RealIpTotal Int,
@TodayShow int,
@TodayIp int,
@TodayTopIp int,
@TodayTopIpTime Int,
@TodayLowIp int,
@TodayLowIpTime Int,
@YesShow int,
@YesIp int,
@YesTopIp int,
@YesTopIpTime Int,
@YesLowIp int,
@YesLowIpTime Int,
@TWeekShow int,
@TWeekIp int,
@TWeekTopIp int,
@TWeekTopIpTime DateTime,
@TWeekLowIp int,
@TWeekLowIpTime DateTime,
@YWeekShow int,
@YWeekIp int,
@YWeekTopIp int,
@YWeekTopIpTime DateTime,
@YWeekLowIp int,
@YWeekLowIpTime DateTime,
@TMonthShow int,
@TMonthIp int,
@TMonthTopIp int,
@TMonthTopIpTime DateTime,
@TMonthLowIp int,
@TMonthLowIpTime DateTime,
@YMonthShow int,
@YMonthIp int,
@YMonthTopIp int,
@YMonthTopIpTime DateTime,
@YMonthLowIp int,
@YMonthLowIpTime DateTime,
@TYearShow int,
@TYearIp int,
@TYearTopIp int,
@TYearTopIpTime DateTime,
@TYearLowIp int,
@TYearLowIpTime DateTime,
@OnlineNum Varchar(255)
set @AddYear = convert(int,(datename(year,getdate())))
set @AddMonth = convert(int,(datename(month,getdate())))
set @AddHour = convert(int,(datename(hour,getdate())))
set @SyYear = convert(int,datename(year,convert(datetime , @SyDate)))
set @SyMonth = convert(int,datename(month,convert(datetime , @SyDate)))
set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction TjSurveyTrans
Select
@ParentName = ParentName,
@State = State,
@EndDate = EndDate,
@VipState = VipState,
@VipEndDate = VipEndDate,
@VipAddSubNum = VipAddSubNum,
@PageName = PageName,
@PageUrl = PageUrl,
@AddTime = AddTime,
@RealShowTotal = RealShowTotal,
@RealIpTotal = RealIpTotal
From CFCount_User Where UserName = @UserName
Select @TodayShow = MyCounter , @TodayIp = IpCounter From CFCount_Count_Day Where UserName = @UserName And DateDiff(d,AddDate,GetDate())=0
Select Top 1 @TodayTopIp = IpCounter , @TodayTopIpTime = AddHour From CFCount_Count_Hour Where UserName = @UserName And DateDiff(d,AddDate,GetDate())=0 Order By IpCounter Desc
Select Top 1 @TodayLowIp = IpCounter , @TodayLowIpTime = AddHour From CFCount_Count_Hour Where UserName = @UserName And DateDiff(d,AddDate,GetDate())=0 And AddHour<>@AddHour Order By IpCounter
Select @YesShow = MyCounter , @YesIp = IpCounter From CFCount_Count_Day Where UserName = @UserName And DateDiff(d,AddDate,GetDate())=1
Select Top 1 @YesTopIp = IpCounter , @YesTopIpTime = AddHour From CFCount_Count_Hour Where UserName = @UserName And DateDiff(d,AddDate,GetDate())=1 Order By IpCounter Desc
Select Top 1 @YesLowIp = IpCounter , @YesLowIpTime = AddHour From CFCount_Count_Hour Where UserName = @UserName And DateDiff(d,AddDate,GetDate())=1 Order By IpCounter
Select @TWeekShow = Sum(MyCounter) , @TWeekIp = Sum(IpCounter) From CFCount_Count_Day Where UserName = @UserName And AddDate >= @BzksDate
Select Top 1 @TWeekTopIp = IpCounter, @TWeekTopIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And AddDate >= @BzksDate Order By IpCounter Desc
Select Top 1 @TWeekLowIp = IpCounter , @TWeekLowIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And AddDate >= @BzksDate And AddDate<>GetDate() Order By IpCounter
Select @YWeekShow = Sum(MyCounter) , @YWeekIp = Sum(IpCounter) From CFCount_Count_Day Where UserName = @UserName And AddDate >= @SzksDate And AddDate <= @SzmDate
Select Top 1 @YWeekTopIp = IpCounter , @YWeekTopIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And AddDate >= @SzksDate And AddDate <= @SzmDate Order By IpCounter Desc
Select Top 1 @YWeekLowIp = IpCounter , @YWeekLowIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And AddDate >= @SzksDate And AddDate <= @SzmDate Order By IpCounter
Select @TMonthShow = Sum(MyCounter) , @TMonthIp = Sum(IpCounter) From CFCount_Count_Month Where UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Select Top 1 @TMonthTopIp = IpCounter , @TMonthTopIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And DateDiff(m,AddDate,GetDate())=0 Order By IpCounter Desc
Select Top 1 @TMonthLowIp = IpCounter , @TMonthLowIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And DateDiff(m,AddDate,GetDate())=0 Order By IpCounter
If Exists(Select ID From CFCount_Count_Month Where UserName = @UserName And AddYear = @SyYear And AddMonth = @SyMonth)
Begin
TrunCate Table CFCount_Temp
Set @Sql = 'Insert CFCount_Temp (MyStr) Select Convert(Varchar,Sum(MyCounter))+' + '''|''' + '+Convert(Varchar,Sum(IpCounter)) From CFCount_Count_Month Where UserName = ''' + @UserName + ''' And AddYear=' + Convert(varchar , @SyYear) +' And AddMonth=' + Convert(varchar , @SyMonth)
Exec(@Sql)
Select @MyStr = Mystr From CFCount_Temp Order By Id Desc
Set @YMonthShow = Convert(int,SubString(@MyStr, 0, CHARINDEX('|' , @MyStr)))
Set @YMonthIp = Convert(int,SubString(@MyStr, CHARINDEX('|' , @MyStr)+1, 100))
End
Else
Begin
Set @YMonthShow = 0
Set @YMonthIp = 0
End
Select Top 1 @YMonthTopIp = IpCounter, @YMonthTopIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And DateDiff(m,AddDate,GetDate())=1 Order By IpCounter Desc
Select Top 1 @YMonthLowIp = IpCounter, @YMonthLowIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And DateDiff(m,AddDate,GetDate())=1 Order By IpCounter
Select @TYearShow = Sum(MyCounter) , @TYearIp = Sum(IpCounter) From CFCount_Count_Month Where UserName = @UserName And AddYear = @AddYear
Select Top 1 @TYearTopIp = IpCounter , @TYearTopIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName Order By IpCounter Desc
Select Top 1 @TYearLowIp = IpCounter , @TYearLowIpTime = AddDate From CFCount_Count_Day Where UserName = @UserName And DateDiff(d , @AddTime , AddDate)>0 And DateDiff(d,AddDate,GetDate())>0 Order By IpCounter
Select @OnlineNum = Transfer_Value From CFCount_Transfer Where UserName = @UserName And Transfer_Type=3
IF @@error<>0
Begin
goto error_handler
End
Commit Transaction TjSurveyTrans
Select
@ParentName As ParentName,
@State As State,
@EndDate As EndDate,
@VipState As VipState,
@VipEndDate As VipEndDate,
@VipAddSubNum As VipAddSubNum,
@PageName As PageName,
@PageUrl As PageUrl,
@AddTime As AddTime,
@RealShowTotal As RealShowTotal,
@RealIpTotal As RealIpTotal,
@TodayShow As TodayShow,
@TodayIp As TodayIp,
@TodayTopIp As TodayTopIp,
@TodayTopIpTime As TodayTopIpTime,
@TodayLowIp As TodayLowIp,
@TodayLowIpTime As TodayLowIpTime,
@YesShow As YesShow,
@YesIp As YesIp,
@YesTopIp As YesTopIp,
@YesTopIpTime As YesTopIpTime,
@YesLowIp As YesLowIp,
@YesLowIpTime As YesLowIpTime,
@TWeekShow As TWeekShow,
@TWeekIp As TWeekIp,
@TWeekTopIp As TWeekTopIp,
@TWeekTopIpTime As TWeekTopIpTime,
@TWeekLowIp As TWeekLowIp,
@TWeekLowIpTime As TWeekLowIpTime,
@YWeekShow As YWeekShow,
@YWeekIp As YWeekIp,
@YWeekTopIp As YWeekTopIp,
@YWeekTopIpTime As YWeekTopIpTime,
@YWeekLowIp As YWeekLowIp,
@YWeekLowIpTime As YWeekLowIpTime,
@TMonthShow As TMonthShow,
@TMonthIp As TMonthIp,
@TMonthTopIp As TMonthTopIp,
@TMonthTopIpTime As TMonthTopIpTime,
@TMonthLowIp As TMonthLowIp,
@TMonthLowIpTime As TMonthLowIpTime,
@YMonthShow As YMonthShow,
@YMonthIp As YMonthIp,
@YMonthTopIp As YMonthTopIp,
@YMonthTopIpTime As YMonthTopIpTime,
@YMonthLowIp As YMonthLowIp,
@YMonthLowIpTime As YMonthLowIpTime,
@TYearShow As TYearShow,
@TYearIp As TYearIp,
@TYearTopIp As TYearTopIp,
@TYearTopIpTime As TYearTopIpTime,
@TYearLowIp As TYearLowIp,
@TYearLowIpTime As TYearLowIpTime,
@OnlineNum As OnlineNum
Return
Error_handler: 
BEGIN
RollBack Transaction TjSurveyTrans
Return
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


CREATE Proc CFCount_Tj_Proc
@UserUseDayState Int,
@UserName varchar(50),
@Ly varchar(1000),
@LyHead varchar(50),
@CurrWeb varchar(1000),
@Ip varchar(50),
@InIpNum BigInt,
@Alexa Int,
@SearchExist Int,
@KeywordExist Int,
@SiteFlag varchar(50),
@KeyWord varchar(50),
@OnlineKeep Int,
@LyKeep Int,
@WebKeep Int,
@AreaTj Int,
@IpHeadTj Int,
@SearchKeywrodTj Int,
@CFCountVisitTotal int,
@CFCount int
As
/*
====================================================
 *  @Author     ˷
 *  @Web      http://www.qqcf.com
 *  @Describe   ͳ
====================================================
 */
Declare
@AddYear int,
@AddMonth int,
@AddWeek int,
@AddDate varchar(50),
@AddHour int,
@Area varchar(50),
@Ip_1 varchar(50),
@Ip_2 varchar(50),
@IpHead varchar(50),
@ReturnFlag int,
@State int,
@EndDate DateTime,
@VipState int,
@VipEndDate DateTime,
@Sql varchar(1000),
@MyCounter Int,
@RowNum Int,
@ID Int,
@PageName varchar(50),
@Style Int,
@PicNum Int,
@ShowTotal Int,
@RealShowTotal Int,
@RealIpTotal Int,
@CounterShow Int,
@ShowType Int,
@CounterHiddenPic Int,
@CounterSite Int,
@ImgCounterShow Int,
@ImgShowType Int,
@ImgFileName varchar(50),
@ImgFontName varchar(50),
@ImgFontSize Int,
@ImgFontColor varchar(50),
@ImgFontTop Int,
@ImgFontLeft Int,
@ImgFontLingHeight Int,
@ImgSelfText varchar(255),
@Online Int,
@OnlineTime Int,
@OnlineShow Int,
@TodayShow Int,
@TodayIpShow Int,
@IpShow Int,
@TodayIpTotal Int,
@TodayTotal Int,
@VisitShow Int,
@Tjopen Int
set @AddYear = convert(int,(datename(year,getdate())))
set @AddMonth = convert(int,(datename(month,getdate())))
set @AddWeek = datepart(week,getdate())
set @AddDate = convert(varchar,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))
set @AddHour = convert(int,(datename(hour,getdate())))
Set @IP_1 = SubString(@IP, 0, CHARINDEX('.' , @IP))
Set @IP_2 = SUBSTRING(SUBSTRING(@IP, CHARINDEX('.', @IP)+1,100), 0,CHARINDEX('.', SUBSTRING(@IP, CHARINDEX('.', @IP)+1,100)) )
Set @IPHead = @IP_1 + '.' + @IP_2
set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction TjTrans
Set @ReturnFlag=0
Select @ID=ID,
@State = State,
@EndDate = EndDate,
@VipState = VipState,
@VipEndDate = VipEndDate,
@PageName = PageName,
@Style = Style,
@PicNum = PicNum,
@ShowTotal = ShowTotal,
@RealShowTotal = RealShowTotal,
@RealIpTotal = RealIpTotal,
@CounterShow = CounterShow,
@ShowType = ShowType,
@CounterHiddenPic = CounterHiddenPic,
@CounterSite = CounterSite,
@ImgCounterShow = ImgCounterShow,
@ImgShowType = ImgShowType,
@ImgFileName = ImgFileName,
@ImgFontName = ImgFontName,
@ImgFontSize = ImgFontSize,
@ImgFontColor = ImgFontColor,
@ImgFontTop = ImgFontTop,
@ImgFontLeft = ImgFontLeft,
@ImgFontLingHeight = ImgFontLingHeight,
@ImgSelfText = ImgSelfText,
@Online = Online,
@OnlineTime = OnlineTime,
@OnlineShow = OnlineShow,
@TodayShow = TodayShow,
@TodayIpShow = TodayIpShow,
@IpShow = IpShow,
@VisitShow = VisitShow,
@Tjopen = Tjopen
From CFCount_User Where UserName = @UserName
If @ID Is Null
Begin
Set @ReturnFlag=1
goto error_handler
End
If @State=0
Begin
Set @ReturnFlag=2
goto error_handler
End
If @VipState=0 And @UserUseDayState=-1
Begin
If DateDiff(d,GetDate() , @EndDate)<0
Begin
Set @ReturnFlag=3
goto error_handler
End
End
If @VipState=-1
Begin
If DateDiff(d,GetDate() , @VipEndDate)<0
Begin
Update CFCount_User Set VipState = 0 Where UserName = @UserName
End
End
If @Alexa=-1 And @CFCount = 0
Begin
Update CFCount_Alexa_Day Set IpCounter = IpCounter +1 Where UserName = @UserName And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Alexa_Day (UserName) values (@UserName)
End
Update CFCount_Alexa_Week Set IpCounter = IpCounter +1 Where UserName = @UserName And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Alexa_Week (UserName) values (@UserName)
End
Update CFCount_Alexa_Month Set IpCounter = IpCounter +1 Where UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Alexa_Month (UserName) values (@UserName)
End
End
If @AreaTj = 1 And @CFCount = 0
Begin
Select @Area = Area from CFCount_IpAddress where ip_1 <= @InIpNum and ip_2 >= @InIpNum
If (@Area Is Null) Or (@Area='')
Begin
Set @Area = '-'
End
Update CFCount_Area_Day Set IpCounter =IpCounter+1,LastTime=GetDate() Where UserName = @UserName And Area = @Area And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Area_Day (UserName,Area) values (@UserName , @Area)
End
Update CFCount_Area_Week Set IpCounter =IpCounter+1,LastTime=GetDate() Where UserName = @UserName And Area = @Area And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Area_Week (UserName,Area) values (@UserName , @Area)
End
Update CFCount_Area_Month Set IpCounter =IpCounter+1,LastTime=GetDate() Where UserName = @UserName And Area = @Area And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Area_Month (UserName,Area) values (@UserName , @Area)
End
Update CFCount_Area Set IpCounter =IpCounter+1,LastTime=GetDate() Where UserName = @UserName And Area = @Area
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Area (UserName,Area) values (@UserName , @Area)
End
End
If @CFCountVisitTotal = 1 And @CFCount = 0
Begin
Update CFCount_Back_Day Set BackNum_1=BackNum_1+1 Where UserName = @UserName And AddDate = @AddDate
Set @RowNum = @@rowcount
End
If (@CFCountVisitTotal >= 2 And @CFCountVisitTotal <= 10) And @CFCount = 0
Begin
Set @Sql = 'Update CFCount_Back_Day Set BackNum_' + convert(varchar, @CFCountVisitTotal) + '=BackNum_' + convert(varchar, @CFCountVisitTotal) + '+1,BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '=BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '-1 Where UserName = ''' + @UserName + ''' And AddDate=''' + Convert(varchar, @AddDate) + ''''
Exec(@Sql)
Set @RowNum = @@rowcount
End
If @CFCountVisitTotal = 11 And @CFCount = 0
Begin
Update CFCount_Back_Day Set BackNum_Higher=BackNum_Higher+1,BackNum_10=BackNum_10-1 Where UserName = @UserName And AddDate = @AddDate
Set @RowNum = @@rowcount
End
If @RowNum = 0 And @CFCount = 0
Begin
Insert Into CFCount_Back_Day (UserName,BackNum_1) values(@UserName,1)
End
If @CFCountVisitTotal=1 And @CFCount = 0
Begin
Update CFCount_Back_Week Set BackNum_1=BackNum_1+1 Where UserName = @UserName And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
If (@CFCountVisitTotal>=2 And @CFCountVisitTotal<=10) And @CFCount = 0
Begin
Set @Sql='Update CFCount_Back_Week Set BackNum_' + convert(varchar, @CFCountVisitTotal) + '=BackNum_' + convert(varchar, @CFCountVisitTotal) + '+1,BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '=BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '-1 Where UserName = ''' + @UserName + ''' And AddYear = ' + Convert(varchar, @AddYear) + ' And AddWeek = ' + Convert(varchar, @AddWeek)
Exec(@Sql)
Set @RowNum = @@rowcount
End
If @CFCountVisitTotal=11 And @CFCount = 0
Begin
Update CFCount_Back_Week Set BackNum_Higher=BackNum_Higher+1,BackNum_10=BackNum_10-1 Where UserName = @UserName And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
If @RowNum = 0 And @CFCount = 0
Begin
Insert Into CFCount_Back_Week (UserName,BackNum_1) values(@UserName,1)
End
If @CFCountVisitTotal=1 And @CFCount = 0
Begin
Update CFCount_Back_Month Set BackNum_1=BackNum_1+1 Where UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
If (@CFCountVisitTotal>=2 And @CFCountVisitTotal<=10) And @CFCount = 0
Begin
Set @Sql='Update CFCount_Back_Month Set BackNum_' + convert(varchar, @CFCountVisitTotal) + '=BackNum_' + convert(varchar, @CFCountVisitTotal) + '+1,BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '=BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '-1 Where UserName = ''' + @UserName + ''' And AddYear = ' + Convert(varchar, @AddYear) + ' And AddMonth = ' + Convert(varchar, @AddMonth)
Exec(@Sql)
Set @RowNum = @@rowcount
End
If @CFCountVisitTotal=11 And @CFCount = 0
Begin
Update CFCount_Back_Month Set BackNum_Higher=BackNum_Higher+1,BackNum_10=BackNum_10-1 Where UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
If @RowNum = 0 And @CFCount = 0
Begin
Insert Into CFCount_Back_Month (UserName,BackNum_1) values(@UserName,1)
End
If @CFCountVisitTotal=1 And @CFCount = 0
Begin
Update CFCount_Back Set BackNum_1=BackNum_1+1 Where UserName = @UserName
Set @RowNum = @@rowcount
End
If (@CFCountVisitTotal>=2 And @CFCountVisitTotal<=10) And @CFCount = 0
Begin
Set @Sql='Update CFCount_Back Set BackNum_' + convert(varchar, @CFCountVisitTotal) + '=BackNum_' + convert(varchar, @CFCountVisitTotal) + '+1,BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '=BackNum_' + convert(varchar, @CFCountVisitTotal-1) + '-1 Where UserName = ''' + @UserName + ''''
Exec(@Sql)
Set @RowNum = @@rowcount
End
If @CFCountVisitTotal=11 And @CFCount = 0
Begin
Update CFCount_Back Set BackNum_Higher=BackNum_Higher+1,BackNum_10=BackNum_10-1 Where UserName = @UserName
Set @RowNum = @@rowcount
End
If @RowNum = 0 And @CFCount = 0
Begin
Insert Into CFCount_Back (UserName,BackNum_1) values(@UserName,1)
End
If @CFCount = 0
Begin
Update CFCount_Count_Hour Set MyCounter=MyCounter+1,IpCounter=IpCounter+1 Where UserName = @UserName And AddDate = @AddDate And AddHour = @AddHour
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Count_Hour Set MyCounter=MyCounter+1 Where UserName = @UserName And AddDate = @AddDate And AddHour = @AddHour
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Count_Hour (UserName) Values (@UserName)
End
If @CFCount = 0
Begin
Update CFCount_Count_Day Set MyCounter=MyCounter+1,IpCounter=IpCounter+1 Where UserName = @UserName And AddDate = @AddDate
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Count_Day Set MyCounter=MyCounter+1 Where UserName = @UserName And AddDate = @AddDate
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Count_Day (UserName) Values (@UserName)
End
If @CFCount = 0
Begin
Update CFCount_Count_Week Set MyCounter=MyCounter+1,IpCounter=IpCounter+1 Where UserName = @UserName And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Count_Week Set MyCounter=MyCounter+1 Where UserName = @UserName And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Count_Week (UserName) Values (@UserName)
End
If @CFCount = 0
Begin
Update CFCount_Count_Month Set MyCounter=MyCounter+1,IpCounter=IpCounter+1 Where UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Count_Month Set MyCounter=MyCounter+1 Where UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Count_Month (UserName) Values (@UserName)
End
If @IpHeadTj = 1 And @CFCount = 0
Begin
Update CFCount_IpHead_Day Set IpCounter =IpCounter+1 Where UserName = @UserName And IpHead = @IpHead And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_IpHead_Day (UserName,IpHead) values (@UserName , @IpHead)
End
Update CFCount_IPHead_Week Set IpCounter =IpCounter+1 Where UserName = @UserName And IpHead = @IpHead And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_IPHead_Week (UserName,IpHead) values (@UserName , @IpHead)
End
Update CFCount_IpHead_Month Set IpCounter =IpCounter+1 Where UserName = @UserName And IpHead = @IpHead And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_IpHead_Month (UserName,IpHead) values (@UserName , @IpHead)
End
Update CFCount_IpHead Set IpCounter =IpCounter+1,LastTime=GetDate() Where UserName = @UserName And IpHead = @IpHead
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_IpHead (UserName,IpHead) values (@UserName , @IpHead)
End
End
If @LyKeep=-1
Begin
If  CHARINDEX(@LyHead,@CurrWeb)=0
Begin
If @CFCount = 0
Begin
Update CFCount_Ly_Day Set MyCounter = MyCounter+1 , IpCounter = IpCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead And AddDate = @AddDate
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Ly_Day Set MyCounter = MyCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead And AddDate = @AddDate
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Ly_Day (UserName,Ip,LyHead,Ly) Values (@UserName , @Ip , @LyHead , @Ly)
Update CFCount_Admin Set Store_Ly = Store_Ly+1,Store_TotalLy = Store_TotalLy+1
End
End
If  CHARINDEX(@LyHead,@CurrWeb)=0
Begin
If @CFCount = 0
Begin
Update CFCount_Ly_Week Set MyCounter = MyCounter+1 , IpCounter = IpCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Ly_Week Set MyCounter = MyCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Ly_Week (UserName,Ip,LyHead,Ly) Values (@UserName , @Ip , @LyHead , @Ly)
End
End
If  CHARINDEX(@LyHead,@CurrWeb)=0
Begin
If @CFCount = 0
Begin
Update CFCount_Ly_Month Set MyCounter = MyCounter+1 , IpCounter = IpCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Ly_Month Set MyCounter = MyCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Ly_Month (UserName,Ip,LyHead,Ly) Values (@UserName , @Ip , @LyHead , @Ly)
End
End
If  CHARINDEX(@LyHead,@CurrWeb)=0
Begin
If @CFCount = 0
Begin
Update CFCount_Ly Set MyCounter = MyCounter+1 , IpCounter = IpCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Ly Set MyCounter = MyCounter+1 , Ip = @Ip , Ly = @Ly , LastTime = GetDate() Where UserName = @UserName And LyHead = @LyHead
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Ly (UserName,Ip,LyHead,Ly) Values (@UserName , @Ip , @LyHead , @Ly)
End
End
End
If @SearchExist=-1
Begin
If @CFCount = 0
Begin
Update CFCount_Search_Day Set MyCounter = MyCounter+1,IpCounter = IpCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName And AddDate = @AddDate
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Search_Day Set MyCounter = MyCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName And AddDate = @AddDate
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Search_Day (UserName,SiteFlag) values (@UserName , @SiteFlag)
End
If @CFCount = 0
Begin
Update CFCount_Search_Week Set MyCounter = MyCounter+1,IpCounter = IpCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Search_Week Set MyCounter = MyCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Search_Week (UserName,SiteFlag) values (@UserName , @SiteFlag)
End
If @CFCount = 0
Begin
Update CFCount_Search_Month Set MyCounter = MyCounter+1,IpCounter = IpCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Search_Month Set MyCounter = MyCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Search_Month (UserName,SiteFlag) values (@UserName , @SiteFlag)
End
If @CFCount = 0
Begin
Update CFCount_Search Set MyCounter = MyCounter+1,IpCounter = IpCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_Search Set MyCounter = MyCounter+1 Where SiteFlag = @SiteFlag And UserName = @UserName
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_Search (UserName,SiteFlag) values (@UserName , @SiteFlag)
End
End
If @SearchKeywrodTj = 1 And @KeywordExist=-1
Begin
If @CFCount = 0
Begin
Update CFCount_SearchKeyword_Day Set MyCounter = MyCounter+1,IpCounter = IpCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag And AddDate = @AddDate
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_SearchKeyword_Day Set MyCounter = MyCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag And AddDate = @AddDate
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_SearchKeyword_Day (UserName , SiteFlag , KeyWord,LastLy) values (@UserName , @SiteFlag , @KeyWord , @Ly)
End
If @CFCount = 0
Begin
Update CFCount_SearchKeyword_Week Set MyCounter = MyCounter+1,IpCounter = IpCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_SearchKeyword_Week Set MyCounter = MyCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_SearchKeyword_Week (UserName , SiteFlag , KeyWord,LastLy) values (@UserName , @SiteFlag , @KeyWord , @Ly)
End
If @CFCount = 0
Begin
Update CFCount_SearchKeyword_Month Set MyCounter = MyCounter+1,IpCounter = IpCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_SearchKeyword_Month Set MyCounter = MyCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_SearchKeyword_Month (UserName , SiteFlag , KeyWord,LastLy) values (@UserName , @SiteFlag , @KeyWord , @Ly)
End
If @CFCount = 0
Begin
Update CFCount_SearchKeyword Set MyCounter = MyCounter+1,IpCounter = IpCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag
Set @RowNum = @@rowcount
End
Else
Begin
Update CFCount_SearchKeyword Set MyCounter = MyCounter+1,LastTime = GetDate(),LastLy = @Ly Where UserName = @UserName And KeyWord = @KeyWord And SiteFlag = @SiteFlag
Set @RowNum = @@rowcount
End
If @RowNum=0
Begin
Insert Into CFCount_SearchKeyword (UserName , SiteFlag , KeyWord,LastLy) values (@UserName , @SiteFlag , @KeyWord , @Ly)
End
End
If @WebKeep=-1 And @CurrWeb<>"-"
Begin
Update CFCount_Web_Day Set MyCounter=MyCounter+1,LastTime=GetDate() Where UserName = @UserName And WebUrl = @CurrWeb And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Web_Day (UserName,WebUrl) values (@UserName, @CurrWeb)
End
Update CFCount_Web_Week Set MyCounter=MyCounter+1,LastTime=GetDate() Where UserName = @UserName And WebUrl = @CurrWeb And AddYear = @AddYear And AddWeek = @AddWeek
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Web_Week (UserName,WebUrl) values (@UserName, @CurrWeb)
End
Update CFCount_Web_Month Set MyCounter=MyCounter+1,LastTime=GetDate() Where UserName = @UserName And WebUrl = @CurrWeb And AddYear = @AddYear And AddMonth = @AddMonth
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Web_Month (UserName,WebUrl) values (@UserName, @CurrWeb)
End
Update CFCount_Web Set MyCounter=MyCounter+1,LastTime=GetDate() Where UserName = @UserName And WebUrl = @CurrWeb
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Web (UserName,WebUrl) values (@UserName, @CurrWeb)
End
End
If @CFCount = 0
Begin
Update CFCount_User Set ShowTotal = ShowTotal+1,RealShowTotal = RealShowTotal+1,RealIpTotal = RealIpTotal+1 Where UserName = @UserName
End
Else
Begin
Update CFCount_User Set ShowTotal = ShowTotal+1,RealShowTotal = RealShowTotal+1 Where UserName = @UserName
End
If @Tjopen=-1 Or @TodayShow = -1 Or @TodayIpShow = -1
Begin
Select @TodayTotal = MyCounter , @TodayIpTotal = IpCounter From CFCount_Count_Day Where UserName = @UserName And DateDiff(d,AddDate,GetDate()) = 0
End
Else
Begin
Set @TodayTotal =0
Set @TodayIpTotal =0
End
Set @ShowTotal = @ShowTotal + 1
If @CFCount = 0
Begin
Set @RealShowTotal = @RealShowTotal + 1
Set @RealIpTotal = @RealIpTotal + 1
End
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Commit Transaction TjTrans
Select @ReturnFlag As ReturnFlag,
@VipState As VipState,
@PageName As PageName,
@Style As Style,
@PicNum As PicNum,
@ShowTotal As ShowTotal,
@RealShowTotal As RealShowTotal,
@RealIpTotal As RealIpTotal,
@CounterShow As CounterShow,
@ShowType As ShowType,
@CounterHiddenPic As CounterHiddenPic,
@CounterSite As CounterSite,
@ImgCounterShow As ImgCounterShow,
@ImgShowType As ImgShowType,
@ImgFileName As ImgFileName,
@ImgFontName As ImgFontName,
@ImgFontSize As ImgFontSize,
@ImgFontColor As ImgFontColor,
@ImgFontTop As ImgFontTop,
@ImgFontLeft As ImgFontLeft,
@ImgFontLingHeight As ImgFontLingHeight,
@ImgSelfText As ImgSelfText,
@Online As Online,
@OnlineTime As OnlineTime,
@OnlineShow As OnlineShow,
@TodayShow As TodayShow,
@TodayIpShow As TodayIpShow,
@IpShow As IpShow,
@TodayIpTotal As TodayIpTotal,
@TodayTotal As TodayTotal,
@VisitShow As VisitShow,
@Tjopen As Tjopen
return
Error_handler: 
BEGIN
RollBack Transaction TjTrans
Select @ReturnFlag As ReturnFlag
return
END


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


CREATE Proc CFCount_Transfer_Proc
@UserName Varchar(50),
@Transfer_Type Int,
@Transfer_Value Text
As
/*
====================================================
 *  @Author     ˷
 *  @Web      http://www.qqcf.com
 *  @Describe   
====================================================
 */
Declare
@RowNum Int
set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction TransferTrans
Update CFCount_Transfer Set Transfer_Value = @Transfer_Value Where UserName = @UserName And Transfer_Type = @Transfer_Type
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFCount_Transfer (UserName,Transfer_Type,Transfer_Value) values (@UserName , @Transfer_Type , @Transfer_Value)
End
IF @@error<>0
Begin
goto error_handler
End
Commit Transaction TransferTrans
return
Error_handler: 
BEGIN
RollBack Transaction TransferTrans
return
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO


CREATE Proc CFCount_UserDel_Proc
@UserName Varchar(50)
As
/*
====================================================
 *  @Author     ˷
 *  @Web      http://www.qqcf.com
 *  @Describe   ûɾ
====================================================
 */
set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction UserDelTrans
Delete From CFCount_Alexa_Day Where UserName = @UserName
Delete From CFCount_Alexa_Month Where UserName = @UserName
Delete From CFCount_Alexa_Week Where UserName = @UserName
Delete From CFCount_Area Where UserName = @UserName
Delete From CFCount_Area_Day Where UserName = @UserName
Delete From CFCount_Area_Month Where UserName = @UserName
Delete From CFCount_Area_Week Where UserName = @UserName
Delete From CFCount_Back Where UserName = @UserName
Delete From CFCount_Back_Day Where UserName = @UserName
Delete From CFCount_Back_Month Where UserName = @UserName
Delete From CFCount_Back_Week Where UserName = @UserName
Delete From CFCount_Count_Day Where UserName = @UserName
Delete From CFCount_Count_Hour Where UserName = @UserName
Delete From CFCount_Count_Month Where UserName = @UserName
Delete From CFCount_Count_Week Where UserName = @UserName
Delete From CFCount_IpHead Where UserName = @UserName
Delete From CFCount_IpHead_Day Where UserName = @UserName
Delete From CFCount_IpHead_Month Where UserName = @UserName
Delete From CFCount_IPHead_Week Where UserName = @UserName
Delete From CFCount_Ly Where UserName = @UserName
Delete From CFCount_Ly_Day Where UserName = @UserName
Delete From CFCount_Ly_Month Where UserName = @UserName
Delete From CFCount_Ly_Week Where UserName = @UserName
Delete From CFCount_User Where UserName = @UserName
Delete From CFCount_Search Where UserName = @UserName
Delete From CFCount_Search_Day Where UserName = @UserName
Delete From CFCount_Search_Month Where UserName = @UserName
Delete From CFCount_Search_Week Where UserName = @UserName
Delete From CFCount_SearchKeyword Where UserName = @UserName
Delete From CFCount_SearchKeyword_Day Where UserName = @UserName
Delete From CFCount_SearchKeyword_Month Where UserName = @UserName
Delete From CFCount_SearchKeyword_Week Where UserName = @UserName
Delete From CFCount_Transfer Where UserName = @UserName
Delete From CFCount_Web_Day Where UserName = @UserName
Delete From CFCount_Web_Day Where UserName = @UserName
Delete From CFCount_Web_Month Where UserName = @UserName
Delete From CFCount_Web_Week Where UserName = @UserName
IF @@error<>0
Begin
goto error_handler
End
Commit Transaction UserDelTrans
Return
Error_handler: 
BEGIN
RollBack Transaction UserDelTrans
Return
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

