USE [gameweb]
GO
/****** Object: Table [dbo].[Game_DownLoad] Script Date: 07/20/2008 10:56:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_DownLoad](
[DownId] [int] IDENTITY(1,1) NOT NULL,
[DownClass] [int] NULL DEFAULT (0),
[DownType] [int] NULL DEFAULT (0),
[DownTitle] [nvarchar](50) NULL,
[DownContent] [text] NULL,
[DownTime] [datetime] NULL,
[DownUrl1] [nvarchar](50) NULL,
[DownUrl2] [nvarchar](50) NULL,
[DownUrl3] [nvarchar](50) NULL,
[Focus] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_UserPhoto] Script Date: 07/20/2008 10:57:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_UserPhoto](
[PhotoId] [int] IDENTITY(1,1) NOT NULL,
[PhotoType] [int] NULL,
[PhotoTitle] [nvarchar](50) NULL,
[PhotoContent] [text] NULL,
[PhotoTime] [datetime] NULL,
[PhotoUrl] [nvarchar](50) NULL,
[PhotoUser] [nvarchar](50) NULL,
[PhotoHist] [int] NULL DEFAULT (0),
[Focus] [int] NULL DEFAULT (0),
[ShenHe] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_System] Script Date: 07/20/2008 10:57:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_System](
[WebName] [nvarchar](50) NULL,
[WebUrl] [nvarchar](50) NULL,
[WebMail] [nvarchar](50) NULL,
[WebQQ] [nvarchar](50) NULL,
[WebCopy] [text] NULL,
[WebSm] [text] NULL,
[SvrIp] [nvarchar](50) NULL,
[SvrPort] [int] NULL,
[UpFile] [nvarchar](50) NULL,
[UpMax] [int] NULL DEFAULT (200)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_GameSet] Script Date: 07/20/2008 10:57:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_GameSet](
[Set1] [int] NULL DEFAULT (0),
[Set2] [int] NULL DEFAULT (0),
[Set3] [int] NULL DEFAULT (0),
[Set4] [int] NULL DEFAULT (0),
[Set5] [int] NULL DEFAULT (0),
[Set6] [int] NULL DEFAULT (0),
[Set7] [int] NULL DEFAULT (0),
[Set8] [int] NULL DEFAULT (0),
[Set9] [int] NULL DEFAULT (0),
[Set10] [int] NULL DEFAULT (0),
[Set11] [int] NULL DEFAULT (0),
[Set12] [int] NULL DEFAULT (0),
[Set13] [int] NULL DEFAULT (0),
[Set14] [int] NULL DEFAULT (0),
[Set15] [int] NULL DEFAULT (0),
[Set16] [int] NULL DEFAULT (0),
[Set17] [int] NULL DEFAULT (0),
[Set18] [int] NULL DEFAULT (0),
[Set19] [int] NULL DEFAULT (0),
[Set21] [int] NULL DEFAULT (0),
[Set22] [int] NULL DEFAULT (0),
[Set23] [int] NULL DEFAULT (0),
[Set24] [int] NULL DEFAULT (0),
[Set25] [int] NULL DEFAULT (0),
[Set26] [int] NULL DEFAULT (0),
[Set27] [int] NULL DEFAULT (0),
[Set28] [int] NULL DEFAULT (0),
[Set29] [int] NULL DEFAULT (0),
[Set30] [int] NULL DEFAULT (0)
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_Cards] Script Date: 07/20/2008 10:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_Cards](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CardCon] [nvarchar](50) NULL,
[CardTime] [datetime] NULL,
[CardUser] [nvarchar](50) NULL,
[UserTime] [datetime] NULL,
[CardFlag] [int] NULL,
[CardWorth] [int] NULL,
[CardType] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_WebLog] Script Date: 07/20/2008 10:57:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_WebLog](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Logs] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_WebIp] Script Date: 07/20/2008 10:57:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_WebIp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Head_Ip] [nvarchar](50) NULL,
[Foot_Ip] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_FAQ] Script Date: 07/20/2008 10:56:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_FAQ](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Issue] [text] NULL,
[Answer] [text] NULL,
[AddTime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[PingMac_AddUser] Script Date: 07/20/2008 10:56:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [PingMac_AddUser]
@UserName varchar(50),
@PassWord varchar(50),
@PassWord2 varchar(50),
@RealName varchar(32),
@IDcard varchar(64),
@Email varchar(32),
@Sex integer,
@Qicq varchar(32),
@Phone varchar(32),
@Household varchar(32),
@Signed varchar(64),
@LoginIp varchar(32),
@Recommended integer
AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON
SET XACT_ABORT ON
BEGIN TRAN
INSERT INTO PingMac_User (UserName,PassWord,PassWord2,UserLv,RealName,IDcard,Email,Sex,Qicq,Phone,Household,Signed,RegTime,LoginIp,Recommended) VALUES(@UserName,@PassWord,@PassWord2,1,@RealName,@IDcard,@Email,@Sex,@Qicq,@Phone,@Household,@Signed,getdate(),@LoginIp,@Recommended)
commit
GO
/****** Object: Table [dbo].[PingMac_User] Script Date: 07/20/2008 10:57:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_User](
[Id] [int] NOT NULL CONSTRAINT [DF__PingMac_User__Id__60A75C0F] DEFAULT ((0)),
[UserName] [nvarchar](50) NULL,
[PassWord] [nvarchar](50) NULL,
[PassWord2] [nvarchar](50) NULL,
[UserLv] [int] NULL CONSTRAINT [DF__PingMac_U__UserL__619B8048] DEFAULT ((0)),
[UserVip] [int] NULL CONSTRAINT [DF__PingMac_U__UserV__628FA481] DEFAULT ((0)),
[MacNum] [int] NULL CONSTRAINT [DF__PingMac_U__MacNu__6383C8BA] DEFAULT ((0)),
[RealName] [nvarchar](50) NULL,
[IDcard] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
[Sex] [int] NULL CONSTRAINT [DF__PingMac_Use__Sex__6477ECF3] DEFAULT ((0)),
[Qicq] [nvarchar](50) NULL,
[Phone] [nvarchar](50) NULL,
[Household] [nvarchar](50) NULL,
[Signed] [text] NULL,
[RegTime] [datetime] NULL,
[LoginNum] [int] NULL CONSTRAINT [DF__PingMac_U__Login__656C112C] DEFAULT ((0)),
[LoginTime] [datetime] NULL,
[LoginIp] [nvarchar](50) NULL,
[NewUser] [int] NULL CONSTRAINT [DF__PingMac_U__NewUs__66603565] DEFAULT ((0)),
[Recommended] [int] NULL CONSTRAINT [DF__PingMac_U__Recom__6754599E] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[PingMac_Acting] Script Date: 07/20/2008 10:57:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_Acting](
[ID] [int] NOT NULL,
[ACTname] [nvarchar](50) NOT NULL,
[UserId] [nvarchar](50) NOT NULL,
[ACTEffective] [int] NOT NULL,
[ACTAbout] [text] NULL,
[ACTWealth] [money] NOT NULL,
[ACTContact] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[PingMac_Cards] Script Date: 07/20/2008 10:57:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_Cards](
[ID] [int] NOT NULL,
[ActingID] [int] NULL,
[CardCon] [nvarchar](50) NULL,
[CardTime] [datetime] NULL,
[CardUser] [nvarchar](50) NULL,
[UserTime] [datetime] NULL,
[CardFlag] [int] NULL,
[CardWorth] [int] NULL,
[CardType] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[PingMac_Items] Script Date: 07/20/2008 10:57:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_Items](
[ID] [int] NOT NULL,
[ItemMain] [int] NULL,
[ItemSub] [int] NULL,
[ItemName] [nvarchar](50) NULL,
[ItemCons] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[ShopItemMap] Script Date: 07/20/2008 10:57:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [ShopItemMap](
[ProductNum] [int] NOT NULL,
[ItemMain] [int] NULL,
[ItemSub] [int] NULL,
[ItemName] [varchar](100) NULL,
[ItemType] [int] NULL,
[ItemTj] [int] NULL,
[ItemMac] [int] NULL,
[ItemMoney] [money] NULL,
[ItemNum] [int] NULL,
[ItemCon] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Game_Admin] Script Date: 07/20/2008 10:56:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_Admin](
[AdminId] [int] IDENTITY(1,1) NOT NULL,
[LevelInt] [int] NULL DEFAULT (0),
[AdminName] [nvarchar](50) NULL,
[AdminPassword] [nvarchar](50) NULL,
[AdminLoginIp] [nvarchar](50) NULL,
[AdminLoginTime] [nvarchar](50) NULL,
[LoginNum] [int] NULL DEFAULT (0),
[UserOnline] [int] NULL DEFAULT (0)
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_TempLogin] Script Date: 07/20/2008 10:57:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Game_TempLogin](
[ID] [int] IDENTITY(1,1) NOT NULL,
[SessionID] [varchar](50) NULL,
[UserName] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Game_News] Script Date: 07/20/2008 10:57:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_News](
[NewsId] [int] IDENTITY(1,1) NOT NULL,
[NewsClass] [int] NULL DEFAULT (0),
[NewsType] [int] NULL DEFAULT (0),
[NewsTitle] [nvarchar](50) NULL,
[NewsContent] [text] NULL,
[NewsUser] [nchar](10) NOT NULL,
[NewsTime] [datetime] NULL,
[NewsHist] [int] NULL DEFAULT (0),
[Focus] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Game_Userarticle] Script Date: 07/20/2008 10:57:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_Userarticle](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Class] [int] NULL DEFAULT (0),
[Type] [int] NULL DEFAULT (0),
[Title] [nvarchar](50) NULL,
[Content] [text] NULL,
[User] [nchar](10) NOT NULL,
[AddTime] [datetime] NULL,
[Hist] [int] NULL DEFAULT (0),
[Focus] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[PingMac_UserLogin] Script Date: 07/20/2008 10:56:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [PingMac_UserLogin]
(
@UserID varchar(50) ,
@Password varchar(50),
@UserIp varchar(50),
@OptDescription int output
)
AS
begin tran
select UserName from PingMac_User where UserName = @UserID
if (@@RowCount<1)
begin ----1
set @OptDescription =-1
rollback
end------1
else
begin ----2
SELECT UserName FROM PingMac_User WHERE (UserName = @UserID) AND (PassWord = @Password )
if (@@RowCount<1)
begin -----3
set @OptDescription =-1
rollback
end-------3
else
begin -----4
UPDATE PingMac_User SET LoginNum=LoginNum+1,LoginTime=getdate(),LoginIp=@UserIp where UserName= @UserID ---登陆纪录
set @OptDescription=0
commit
end ------4
end------2
GO
/****** Object: StoredProcedure [dbo].[PingMac_AdminLogin] Script Date: 07/20/2008 10:56:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [PingMac_AdminLogin]
(
@UserID varchar(50) ,
@Password varchar(50),
@Level int output ,
@OptDescription int output
)
AS
begin tran
select AdminName from Game_Admin where AdminName = @UserID
if (@@RowCount<1)
begin ----1
set @OptDescription =-1
rollback
end------1
else
begin ----2
SELECT AdminName ,LevelInt FROM Game_Admin WHERE (AdminName = @UserID) AND (AdminPassword = @Password )
if (@@RowCount<1)
begin -----3
set @OptDescription =-1
rollback
end-------3
else
begin -----4
set @OptDescription=0
set @Level =20
commit
end ------4
end------2
GO