乘风多用户计数器sql.txt

这是一个用ASP编制而成的网业计数器

/*----
注：只能在
新安装时使用，否则会导致以前乘风多用户计数器所建立的表内数据丢失，但不会对其它
非乘风多用户计数器的表有任何影响
------*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WWW_QQCF_COM_Cfcount_Tj_Proc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[WWW_QQCF_COM_Cfcount_Tj_Proc]
GO

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[WWW_QQCF_COM_CfCount_Admin] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Admin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PassWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RegeditState] [smallint] NOT NULL ,
	[LyKeep] [smallint] NOT NULL ,
	[OnlineKeep] [smallint] NOT NULL ,
	[StyleTotal] [int] NOT NULL ,
	[LogoUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EamilSendType] [int] NOT NULL ,
	[JmailAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JmailUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JmailPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AllSearch] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Store_Ly] [int] NOT NULL ,
	[Store_Online] [int] NOT NULL ,
	[Store_TotalLy] [int] NOT NULL ,
	[Store_TotalOnline] [int] 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 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfCount_Back] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [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].[WWW_QQCF_COM_CfCount_Day_Count] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Counter] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[WWW_QQCF_COM_CfCount_Ly] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [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 ,
	[Counter] [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].[WWW_QQCF_COM_CfCount_Online] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Online_Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ly] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CurrWeb] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VisitTotal] [int] NOT NULL ,
	[ReadTotal] [int] NOT NULL ,
	[Online_AddTime] [datetime] NOT NULL ,
	[Online_LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_CfCount_RegUser] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PassWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[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 ,
	[ShowType] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LoginTotal] [int] NOT NULL ,
	[LastLoginTime] [datetime] NOT NULL ,
	[CounterShow] [smallint] NOT NULL ,
	[CounterSite] [int] NOT NULL ,
	[ImgCounterShow] [smallint] 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 ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EmailCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdminDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[WWW_QQCF_COM_CfCount_Site] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Site] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Counter] [int] NOT NULL ,
	[Ly] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WWW_QQCF_COM_Cfcount_Search] (
	[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].[WWW_QQCF_COM_Cfcount_SearchKeywrod_Count] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KeyWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Counter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[LastDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfCount_Admin] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_Title] DEFAULT ('乘风多用户计数器') FOR [Title],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_RegeditState] DEFAULT ((-1)) FOR [RegeditState],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_LyKeep] DEFAULT ((-1)) FOR [LyKeep],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_OnlineKeep] DEFAULT ((-1)) FOR [OnlineKeep],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_StyleTotal] DEFAULT (40) FOR [StyleTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_LogoUrl] DEFAULT ('qqcf_pic/logo.gif') FOR [LogoUrl],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_EamilSendType] DEFAULT (1) FOR [EamilSendType],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_JmailAddress] DEFAULT ('-') FOR [JmailAddress],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_JmailUser] DEFAULT ('-') FOR [JmailUser],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_JmailPassword] DEFAULT ('-') FOR [JmailPassword],
	CONSTRAINT [DF_WWW_QQCF_COM_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_WWW_QQCF_COM_CfCount_Admin_Store_Ly] DEFAULT (0) FOR [Store_Ly],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_Store_Online] DEFAULT (0) FOR [Store_Online],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_Store_TotalLy] DEFAULT (0) FOR [Store_TotalLy],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_Store_TotalOnline] DEFAULT (0) FOR [Store_TotalOnline],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_LoginTotal] DEFAULT (0) FOR [LoginTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_Ip] DEFAULT ('-') FOR [Ip],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Admin_LicensedCode] DEFAULT ('-') FOR [LicensedCode],
	CONSTRAINT [PK_WWW_QQCF_COM_CfCount_Admin] PRIMARY KEY  CLUSTERED 
	(
		[Admin]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfCount_Back] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_1] DEFAULT (0) FOR [BackNum_1],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_2] DEFAULT (0) FOR [BackNum_2],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_3] DEFAULT (0) FOR [BackNum_3],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_4] DEFAULT (0) FOR [BackNum_4],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_5] DEFAULT (0) FOR [BackNum_5],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_6] DEFAULT (0) FOR [BackNum_6],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_7] DEFAULT (0) FOR [BackNum_7],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_8] DEFAULT (0) FOR [BackNum_8],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_9] DEFAULT (0) FOR [BackNum_9],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_10] DEFAULT (0) FOR [BackNum_10],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Back_BackNum_Higher] DEFAULT (0) FOR [BackNum_Higher],
	CONSTRAINT [PK_WWW_QQCF_COM_CfCount_Back] PRIMARY KEY  CLUSTERED 
	(
		[User_Name]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfCount_Day_Count] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Day_Count_Counter] DEFAULT (1) FOR [Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Day_Count_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [PK_WWW_QQCF_COM_CfCount_Day_Count] PRIMARY KEY  CLUSTERED 
	(
		[User_Name],
		[AddDate]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfCount_Hour_Count] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Hour_Count_Counter] DEFAULT (1) FOR [Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Hour_Count_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [PK_WWW_QQCF_COM_CfCount_Hour_Count] PRIMARY KEY  CLUSTERED 
	(
		[User_Name],
		[AddDate],
		[AddHour]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfCount_Ly] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Ly_Counter] DEFAULT (1) FOR [Counter],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Ly_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Ly_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfCount_Ly] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfCount_Online] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Online_VisitTotal] DEFAULT (1) FOR [VisitTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Online_ReadTotal] DEFAULT (1) FOR [ReadTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Online_Online_AddTime] DEFAULT (getdate()) FOR [Online_AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_Online_Online_LastTime] DEFAULT (getdate()) FOR [Online_LastTime],
	CONSTRAINT [PK_WWW_QQCF_COM_CfCount_Online] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[WWW_QQCF_COM_CfCount_RegUser] ADD 
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_PassWord] DEFAULT ('254a978baaa071ad') FOR [PassWord],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_PassWordAsk] DEFAULT ('-') FOR [PassWordAsk],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_PassWordAnswer] DEFAULT ('-') FOR [PassWordAnswer],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_Email] DEFAULT ('-') FOR [Email],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_QQ] DEFAULT ('-') FOR [QQ],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_PageName] DEFAULT ('-') FOR [PageName],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_PageUrl] DEFAULT ('-') FOR [PageUrl],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_Style] DEFAULT (1) FOR [Style],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_PicNum] DEFAULT (8) FOR [PicNum],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_ShowTotal] DEFAULT (0) FOR [ShowTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_RealShowTotal] DEFAULT (0) FOR [RealShowTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_RealIpTotal] DEFAULT (0) FOR [RealIpTotal],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_ShowType] DEFAULT (1) FOR [ShowType],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_WWW_QQCF_COM_CfCount_RegUser_LoginTotal] DEFAULT (0) FOR [LoginTotal],