USE [GameCenterDB]
GO
/****** Object:  Table [dbo].[AdminLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AdminLog](
	[AdminLogID] [int] IDENTITY(1,1) NOT NULL,
	[AdminUserID] [int] NOT NULL,
	[AdminUserName] [varchar](32) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Msg] [nvarchar](4000) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AdminLogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AdminPage]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AdminPage](
	[AdminPageID] [int] NOT NULL,
	[PageName] [nvarchar](32) NOT NULL,
	[PageUrl] [varchar](128) NOT NULL,
	[IsMenu] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AdminPageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AdminSendCoin]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AdminSendCoin](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[OpUserID] [int] NOT NULL,
	[OpUserName] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[WantAmount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AdminUser]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AdminUser](
	[AdminUserID] [int] IDENTITY(1000,1) NOT NULL,
	[AdminUserName] [varchar](32) NOT NULL,
	[LoginPassword] [varchar](32) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[FailureTimes] [int] NOT NULL,
	[Memo] [nvarchar](128) NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AdminUserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AgentApply]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AgentApply](
	[ApplyID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[HigherUserID] [int] NOT NULL,
	[ApplyStatus] [tinyint] NOT NULL,
	[Memo] [nvarchar](128) NOT NULL,
	[DealTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ApplyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AgentBindAward]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AgentBindAward](
	[AwardID] [int] NOT NULL,
	[Members] [int] NOT NULL,
	[Profit] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AwardID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AgentConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AgentConfig](
	[ConfigID] [int] NOT NULL,
	[IsOpen] [tinyint] NOT NULL,
	[BindSend] [int] NOT NULL,
	[BetOneDirect] [smallint] NOT NULL,
	[BetTwoDirect] [smallint] NOT NULL,
	[TaxOneDirect] [smallint] NOT NULL,
	[TaxTwoDirect] [smallint] NOT NULL,
	[PayOneDirect] [smallint] NOT NULL,
	[PayTwoDirect] [smallint] NOT NULL,
	[AuditEnabled] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ConfigID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AgentGroup]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AgentGroup](
	[UserID] [int] NOT NULL,
	[Info] [nvarchar](max) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AgentMember]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AgentMember](
	[MemberID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[HigherUserID] [int] NOT NULL,
	[Commission] [bigint] NOT NULL,
	[BindTime] [datetime] NOT NULL,
	[LoginTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AllGame]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AllGame](
	[GameID] [int] NOT NULL,
	[ChineseName] [nvarchar](32) NOT NULL,
	[EnglishName] [varchar](32) NOT NULL,
	[DisplaySort] [int] NOT NULL,
	[DBName] [varchar](32) NOT NULL,
	[Enabled] [tinyint] NOT NULL,
	[GameType] [tinyint] NOT NULL,
	[NeedLevel] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[GameID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AllRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AllRank](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RankType] [int] NOT NULL,
	[Rank] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AllUser]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AllUser](
	[UserID] [int] NOT NULL,
	[NickName] [nvarchar](32) NOT NULL,
	[IMei] [varchar](64) NOT NULL,
	[deviceid] [varchar](64) NOT NULL,
	[EPassword] [varchar](64) NOT NULL,
	[RegPartnerID] [int] NOT NULL,
	[RegTime] [datetime] NOT NULL,
	[RegIP] [varchar](16) NOT NULL,
	[LoginTime] [datetime] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayMoney] [decimal](18, 2) NOT NULL,
	[UserWords] [nvarchar](256) NOT NULL,
	[DeviceName] [varchar](32) NOT NULL,
	[Version] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Announce]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Announce](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[Title_En] [nvarchar](32) NOT NULL,
	[Content_En] [nvarchar](4000) NOT NULL,
	[Title_Eg] [nvarchar](32) NOT NULL,
	[Content_Eg] [nvarchar](4000) NOT NULL,
	[Priority] [tinyint] NOT NULL,
	[Version] [int] NOT NULL,
	[BeginTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[Enabled] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoom]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoom](
	[RoomID] [int] NOT NULL,
	[RoomName] [nvarchar](32) NOT NULL,
	[RoomImg] [varchar](256) NOT NULL,
	[UserID] [int] NOT NULL,
	[Family] [nvarchar](32) NOT NULL,
	[Country] [nvarchar](32) NOT NULL,
	[Language] [nvarchar](32) NOT NULL,
	[MicCount] [int] NOT NULL,
	[MicMode] [tinyint] NOT NULL,
	[JoinFee] [int] NOT NULL,
	[Announce] [nvarchar](256) NOT NULL,
	[Tag] [nvarchar](32) NOT NULL,
	[MemberCount] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[Level] [int] NOT NULL,
	[Exps] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoomID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomAttention]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomAttention](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoomSet] [varchar](1024) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomBlack]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomBlack](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[BlackType] [tinyint] NOT NULL,
	[ExpireTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomBrowse]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomBrowse](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoomSet] [varchar](1024) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomEnterCondition]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomEnterCondition](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomId] [int] NOT NULL,
	[InviteOnly] [tinyint] NOT NULL,
	[Password] [varchar](16) NOT NULL,
	[PwdExpire] [datetime] NOT NULL,
	[IsHide] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomExpLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomExpLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[RoomID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Exps] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomExt]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomExt](
	[RoomID] [int] NOT NULL,
	[CollectDiamond] [int] NOT NULL,
	[DayExps] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
	[ScreenLock] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoomID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomGiftHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomGiftHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [int] NOT NULL,
	[Sender] [int] NOT NULL,
	[Receiver] [int] NOT NULL,
	[GiftID] [int] NOT NULL,
	[GiftNum] [int] NOT NULL,
	[DiamondAmount] [int] NOT NULL,
	[GoldAmount] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomLastWeekRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomLastWeekRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomMic]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomMic](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [int] NOT NULL,
	[MicInfo] [varchar](1024) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomOperateLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomOperateLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[OperateType] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomPermission]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomPermission](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [int] NOT NULL,
	[PermissionType] [tinyint] NOT NULL,
	[Enabled] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AudioRoomThisWeekRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioRoomThisWeekRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AwardInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AwardInfo](
	[ActiveID] [int] NOT NULL,
	[ActiveName] [nvarchar](32) NOT NULL,
	[TotalTimes] [int] NOT NULL,
	[PerDay] [int] NOT NULL,
	[Awards] [varchar](2048) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ActiveID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BadgeRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BadgeRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BankLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BankLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[WantedAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](256) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Bet]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Bet](
	[RecordID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TransType] [varchar](32) NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTime] [datetime] NOT NULL,
	[BetZone] [varchar](128) NOT NULL,
	[Odds] [decimal](10, 2) NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[ResultTime] [datetime] NOT NULL,
	[ResultZone] [varchar](1024) NOT NULL,
	[Tax] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BetInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BetInfo](
	[RecordID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TransType] [varchar](32) NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTime] [datetime] NOT NULL,
	[BetZone] [varchar](128) NOT NULL,
	[Odds] [decimal](10, 2) NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[ResultTime] [datetime] NOT NULL,
	[ResultZone] [varchar](1024) NOT NULL,
	[Tax] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BetInfoHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BetInfoHistory](
	[RecordID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TransType] [varchar](32) NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTime] [datetime] NOT NULL,
	[BetZone] [varchar](128) NOT NULL,
	[Odds] [decimal](10, 2) NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[ResultTime] [datetime] NOT NULL,
	[ResultZone] [varchar](1024) NOT NULL,
	[Tax] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BetRecord]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BetRecord](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[SerialNumber] [varchar](32) NOT NULL,
	[BetID] [int] NOT NULL,
	[BetAmount] [int] NOT NULL,
	[BetTime] [datetime] NOT NULL,
	[ResultAmount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BlackFriends]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BlackFriends](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CardErrorLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CardErrorLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ErrorTimes] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CasinoOnline]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CasinoOnline](
	[UserID] [int] NOT NULL,
	[LoginTime] [datetime] NOT NULL,
	[ServerName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChairHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChairHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [bigint] NOT NULL,
	[ChairNo] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Fee] [bigint] NOT NULL,
	[Tax] [bigint] NOT NULL,
	[AwardAmount] [bigint] NOT NULL,
	[Score] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChangedNickNameLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChangedNickNameLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[OldNickName] [nvarchar](32) NOT NULL,
	[NewNickName] [nvarchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[chip]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[chip](
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Bank] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipBankLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipBankLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[WantedAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](256) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipBet]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipBet](
	[RecordID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TransType] [varchar](32) NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTime] [datetime] NOT NULL,
	[BetZone] [varchar](128) NOT NULL,
	[Odds] [decimal](10, 2) NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[ResultTime] [datetime] NOT NULL,
	[ResultZone] [varchar](1024) NOT NULL,
	[Tax] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipBetInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipBetInfo](
	[RecordID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TransType] [varchar](32) NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTime] [datetime] NOT NULL,
	[BetZone] [varchar](128) NOT NULL,
	[Odds] [decimal](10, 2) NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[ResultTime] [datetime] NOT NULL,
	[ResultZone] [varchar](1024) NOT NULL,
	[Tax] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipBetInfoHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipBetInfoHistory](
	[RecordID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TransType] [varchar](32) NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTime] [datetime] NOT NULL,
	[BetZone] [varchar](128) NOT NULL,
	[Odds] [decimal](10, 2) NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[ResultTime] [datetime] NOT NULL,
	[ResultZone] [varchar](1024) NOT NULL,
	[Tax] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[MoneyType] [varchar](8) NOT NULL,
	[UserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[ModifyAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[LogType] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipLog_bak]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipLog_bak](
	[LogID] [int] NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[MoneyType] [varchar](8) NOT NULL,
	[UserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[ModifyAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[LogType] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipLoginStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipLoginStat](
	[DateFlag] [smalldatetime] NOT NULL,
	[LoginCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DateFlag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[IsDouble] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipScoreRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipScoreRank](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Rank] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipSendLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipSendLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[IsShow] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipSendLogHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipSendLogHistory](
	[Rid] [int] NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipStat](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[LogType] [int] NOT NULL,
	[MoneySum] [bigint] NOT NULL,
	[TaxSum] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipStatTotal]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipStatTotal](
	[Crdate] [smalldatetime] NOT NULL,
	[TotalAmount] [bigint] NOT NULL,
	[TotalBank] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Crdate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipTax]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipTax](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[Tax] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipTransferLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipTransferLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[NickName] [nvarchar](32) NOT NULL,
	[CurrAmount] [bigint] NOT NULL,
	[WantAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[AcceptUserID] [int] NOT NULL,
	[AcceptNickName] [nvarchar](32) NOT NULL,
	[AcceptCurrAmount] [bigint] NOT NULL,
	[AcceptWantAmount] [bigint] NOT NULL,
	[AcceptStillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Memo] [nvarchar](256) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChipWhiteList]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChipWhiteList](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[WhiteType] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[codaOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[codaOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[codaPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[codaPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CommissionLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CommissionLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[FromUserID] [int] NOT NULL,
	[Tax] [bigint] NOT NULL,
	[WantCommission] [bigint] NOT NULL,
	[StillCommission] [bigint] NOT NULL,
	[Direct] [tinyint] NOT NULL,
	[Memo] [nvarchar](128) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CommissionLogHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CommissionLogHistory](
	[Rid] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[FromUserID] [int] NOT NULL,
	[Tax] [bigint] NOT NULL,
	[WantCommission] [bigint] NOT NULL,
	[StillCommission] [bigint] NOT NULL,
	[Direct] [tinyint] NOT NULL,
	[Memo] [nvarchar](128) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CommissionStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CommissionStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[FromUserID] [int] NOT NULL,
	[Commission] [bigint] NOT NULL,
	[Direct] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ContinueSignInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ContinueSignInfo](
	[Day] [int] NOT NULL,
	[Award] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Day] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CouponStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CouponStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[CouponCount] [bigint] NOT NULL,
	[UserCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CouponTask]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CouponTask](
	[TaskID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[BaseScore] [int] NOT NULL,
	[Players] [int] NOT NULL,
	[DoubleType] [tinyint] NOT NULL,
	[Coupons] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CouponVideoConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CouponVideoConfig](
	[PlayTimes] [tinyint] NOT NULL,
	[CouponLimit] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CroOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CroOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CroPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CroPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CrushOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CrushOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CrushPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CrushPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CrushWithdraw]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CrushWithdraw](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[RealAmount] [int] NOT NULL,
	[Surcharge] [int] NOT NULL,
	[DfTransactionId] [varchar](32) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[DfDesc] [varchar](256) NOT NULL,
	[Balance] [int] NOT NULL,
	[NotifyTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[RealName] [varchar](128) NOT NULL,
	[BankCard] [varchar](32) NOT NULL,
	[BankName] [varchar](128) NOT NULL,
	[Mobile] [varchar](32) NOT NULL,
	[EMail] [varchar](64) NOT NULL,
	[Address] [varchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DailyBetStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DailyBetStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[MoneySum] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[TotalCount] [int] NOT NULL,
	[WinCount] [int] NOT NULL,
	[PlaySeconds] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DailyReport]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DailyReport](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[ItemType] [smallint] NOT NULL,
	[ItemName] [nvarchar](32) NOT NULL,
	[ItemValue] [decimal](18, 2) NOT NULL,
	[ItemTag] [smallint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DailyStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DailyStat](
	[DateFlag] [smalldatetime] NOT NULL,
	[AvgOnlineCount] [int] NOT NULL,
	[MaxOnlineCount] [int] NOT NULL,
	[RegCount] [int] NOT NULL,
	[LoginCount] [int] NOT NULL,
	[ActiveCount] [int] NOT NULL,
	[PayMoney] [decimal](18, 2) NOT NULL,
	[CosumeAmount] [bigint] NOT NULL,
	[PayUserCount] [int] NOT NULL,
	[AvgPayMoney] [decimal](18, 2) NOT NULL,
	[LiveUsers_1] [int] NOT NULL,
	[LiveUsers_3] [int] NOT NULL,
	[LiveUsers_7] [int] NOT NULL,
	[ReturnUserCount] [int] NOT NULL,
	[VideoPlayTimes] [int] NOT NULL,
	[VideoSendAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DateFlag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DiamondMall]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DiamondMall](
	[ProductID] [varchar](32) NOT NULL,
	[ProductName] [nvarchar](32) NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[ShowPrice] [decimal](18, 2) NOT NULL,
	[PayType] [int] NOT NULL,
	[ShopType] [int] NOT NULL,
	[IsHot] [int] NOT NULL,
	[Bonus] [int] NOT NULL,
	[Extra] [varchar](512) NOT NULL,
	[Sort] [int] NOT NULL,
	[AnimationType] [tinyint] NOT NULL,
	[UserType] [tinyint] NOT NULL,
	[IsBottom] [tinyint] NOT NULL,
	[ProductDesc] [nvarchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ProductID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DingpeiOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DingpeiOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DingpeiPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DingpeiPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DingpeiWithdraw]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DingpeiWithdraw](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[RealAmount] [int] NOT NULL,
	[Surcharge] [int] NOT NULL,
	[DfTransactionId] [varchar](32) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[DfDesc] [varchar](256) NOT NULL,
	[Balance] [int] NOT NULL,
	[NotifyTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[RealName] [varchar](128) NOT NULL,
	[BankCard] [varchar](32) NOT NULL,
	[BankName] [varchar](128) NOT NULL,
	[Mobile] [varchar](32) NOT NULL,
	[EMail] [varchar](64) NOT NULL,
	[Address] [varchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Exchange]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Exchange](
	[Id] [int] NOT NULL,
	[ExchangeType] [int] NOT NULL,
	[LeftCount] [int] NOT NULL,
	[LimitOnce] [tinyint] NOT NULL,
	[VipNeed] [int] NOT NULL,
	[VipShow] [int] NOT NULL,
	[GameCountShow] [int] NOT NULL,
	[Price] [int] NOT NULL,
	[Items] [varchar](128) NOT NULL,
	[Memo] [varchar](1024) NOT NULL,
	[Amount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ExchangeCard]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ExchangeCard](
	[CardNo] [varchar](32) NOT NULL,
	[PerDays] [int] NOT NULL,
	[UseTimes] [bigint] NOT NULL,
	[OpenTime] [datetime] NOT NULL,
	[ExpireTime] [datetime] NOT NULL,
	[Items] [varchar](128) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[CardNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ExchangeCardLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ExchangeCardLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[CardNo] [varchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ExchangeHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ExchangeHistory](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ExchangeID] [int] NOT NULL,
	[ExchangeType] [int] NOT NULL,
	[Price] [int] NOT NULL,
	[Items] [varchar](128) NOT NULL,
	[Remark] [nvarchar](1024) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ExchangeRate]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ExchangeRate](
	[Currency] [varchar](32) NOT NULL,
	[CountryName] [nvarchar](32) NOT NULL,
	[CountryCode] [varchar](32) NOT NULL,
	[Rate] [decimal](10, 2) NOT NULL,
	[IsDefault] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Currency] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[fawryOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fawryOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[fawryPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fawryPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Feedback]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Feedback](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[EMail] [nvarchar](64) NOT NULL,
	[ToUserID] [int] NOT NULL,
	[Msg] [nvarchar](512) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[OpUserID] [int] NULL,
	[OpUserName] [varchar](32) NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[FlashOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FlashOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[FlashPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FlashPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[FlashWithdraw]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FlashWithdraw](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[RealAmount] [int] NOT NULL,
	[Surcharge] [int] NOT NULL,
	[DfTransactionId] [varchar](32) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[DfDesc] [varchar](256) NOT NULL,
	[Balance] [int] NOT NULL,
	[NotifyTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[RealName] [varchar](128) NOT NULL,
	[BankCard] [varchar](32) NOT NULL,
	[BankName] [varchar](128) NOT NULL,
	[Mobile] [varchar](32) NOT NULL,
	[EMail] [varchar](64) NOT NULL,
	[Address] [varchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ForbidUser]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ForbidUser](
	[UserID] [int] NOT NULL,
	[Memo] [nvarchar](128) NOT NULL,
	[BeginTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[GameIDs] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ForbidUserLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ForbidUserLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Memo] [nvarchar](128) NOT NULL,
	[BeginTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameCardStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameCardStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[PlayUserCount] [int] NOT NULL,
	[SendAmount] [bigint] NOT NULL,
	[ConsumeAmount] [bigint] NOT NULL,
	[BreakUserCount] [int] NOT NULL,
	[BreakTimes] [int] NOT NULL,
	[PlayCount] [int] NOT NULL,
	[PlaySeconds] [int] NOT NULL,
	[MidwayUserCount] [int] NOT NULL,
	[MidwayTimes] [int] NOT NULL,
	[TypeID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameDailyStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameDailyStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[AvgOnlineCount] [int] NOT NULL,
	[MaxOnlineCount] [int] NOT NULL,
	[ActiveCount] [int] NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameData]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameData](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[RoomName] [varchar](32) NOT NULL,
	[RoomData] [varchar](512) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameDataHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameDataHistory](
	[Rid] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[RoomName] [varchar](32) NOT NULL,
	[RoomData] [varchar](512) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameInventory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameInventory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[GameID] [int] NOT NULL,
	[RoomName] [nvarchar](32) NOT NULL,
	[RoomType] [int] NOT NULL,
	[InventoryValue] [bigint] NOT NULL,
	[ControlRate] [decimal](10, 2) NOT NULL,
	[MinInventoryValue] [bigint] NOT NULL,
	[MaxInventoryValue] [bigint] NOT NULL,
	[MaxControlRate] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameInventoryRecord]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameInventoryRecord](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[GameID] [int] NOT NULL,
	[RoomName] [nvarchar](64) NOT NULL,
	[RoomType] [int] NOT NULL,
	[InventoryValue] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameInventoryTotal]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameInventoryTotal](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[RoomName] [nvarchar](64) NOT NULL,
	[RoomType] [int] NOT NULL,
	[StartInventoryValue] [bigint] NOT NULL,
	[InventoryValue] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameMidwayStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameMidwayStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[PlayUserCount] [int] NOT NULL,
	[PlayCount] [int] NOT NULL,
	[MidwayUserCount] [int] NOT NULL,
	[MidwayTimes] [int] NOT NULL,
	[TypeID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameName]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameName](
	[GameID] [int] NOT NULL,
	[Name] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[GameID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameRecord]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameRecord](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[TotalCount] [int] NOT NULL,
	[WinCount] [int] NOT NULL,
	[PlaySeconds] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameReport]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameReport](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[ItemType] [smallint] NOT NULL,
	[ItemName] [nvarchar](32) NOT NULL,
	[ItemValue] [decimal](18, 2) NOT NULL,
	[ItemTag] [smallint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameRequest]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameRequest](
	[PartnerID] [int] NOT NULL,
	[VersionCode] [int] NOT NULL,
	[GameName] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[PartnerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameServerSendLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameServerSendLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[SourceNo] [varchar](32) NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[WantedAmount] [bigint] NOT NULL,
	[ModifyAmount] [bigint] NOT NULL,
	[UserExtend] [int] NOT NULL,
	[DateID] [int] NOT NULL,
	[WriteTime] [datetime] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Remark] [varchar](128) NOT NULL,
	[Extend] [varbinary](64) NOT NULL,
	[Identity] [varbinary](64) NOT NULL,
 CONSTRAINT [PK_GAMESERVERSENDLOG] PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameServerSendSource]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameServerSendSource](
	[SourceNo] [varchar](32) NOT NULL,
	[SourceName] [varchar](64) NOT NULL,
	[Type] [int] NOT NULL,
	[StartTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[MaxDayCount] [bigint] NOT NULL,
	[MaxDay] [bigint] NOT NULL,
	[MaxUserDay] [bigint] NOT NULL,
	[WriteTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SourceNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameServerSendStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameServerSendStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateID] [int] NOT NULL,
	[SourceNo] [varchar](32) NOT NULL,
	[MoneySum] [bigint] NOT NULL,
 CONSTRAINT [PK_GAMESERVERSENDSTAT] PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameServerSendUserStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameServerSendUserStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateID] [int] NULL,
	[UserID] [int] NULL,
	[SourceNo] [varchar](32) NULL,
	[MoneySum] [bigint] NULL,
 CONSTRAINT [PK_GAMESERVERSENDUSERSTAT] PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GameTax]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameTax](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[Tax] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GiftCard]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GiftCard](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[Key] [varchar](16) NOT NULL,
	[ActivateTime] [int] NOT NULL,
	[OperateStatus] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GiftPack]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GiftPack](
	[GiftPackId] [int] NOT NULL,
	[PackName] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[Limit] [int] NOT NULL,
	[Items] [varchar](1024) NOT NULL,
	[Type] [int] NOT NULL,
	[Duration] [int] NOT NULL,
	[Group] [int] NOT NULL,
	[GroupIndex] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Rate] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[GiftPackId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GoogleLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GoogleLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Token] [varchar](256) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GoogleSuccessLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GoogleSuccessLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[Token] [varchar](256) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[ResponseIAP] [varchar](1024) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Token] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GrowthPack]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GrowthPack](
	[GrowthPackID] [int] NOT NULL,
	[PackName] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[Terms] [varchar](2048) NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Rate] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[GrowthPackID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HighlyProfitable]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HighlyProfitable](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Schedule] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[huaweiOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[huaweiOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[huaweiPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[huaweiPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[IssueStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IssueStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[LabelID] [varchar](32) NOT NULL,
	[ItemType] [tinyint] NOT NULL,
	[ItemName] [nvarchar](32) NOT NULL,
	[ItemValue] [decimal](18, 2) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Item]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Item](
	[ItemID] [int] NOT NULL,
	[ItemName] [nvarchar](32) NOT NULL,
	[ItemType] [int] NOT NULL,
	[ItemDesc] [nvarchar](256) NOT NULL,
	[Start] [int] NOT NULL,
	[Duration] [int] NOT NULL,
	[ActiveId] [int] NOT NULL,
	[Value] [int] NOT NULL,
	[IsShow] [tinyint] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[ShowPrice] [int] NOT NULL,
	[IconUrl] [varchar](256) NOT NULL,
	[DecorationType] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ItemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[JackPot]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JackPot](
	[GameID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[GameID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[JackPotChip]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JackPotChip](
	[GameID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[GameID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[JackPotChipRecord]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JackPotChipRecord](
	[RecordID] [int] IDENTITY(1,1) NOT NULL,
	[GameID] [int] NOT NULL,
	[FromUserID] [int] NOT NULL,
	[PreAmount] [bigint] NOT NULL,
	[WantAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[JackPotRecord]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JackPotRecord](
	[RecordID] [int] IDENTITY(1,1) NOT NULL,
	[GameID] [int] NOT NULL,
	[FromUserID] [int] NOT NULL,
	[PreAmount] [bigint] NOT NULL,
	[WantAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[JackPotRecordHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JackPotRecordHistory](
	[RecordID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[FromUserID] [int] NOT NULL,
	[PreAmount] [bigint] NOT NULL,
	[WantAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[KayaOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KayaOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[KayaPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KayaPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[KayaWithdraw]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KayaWithdraw](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[RealAmount] [int] NOT NULL,
	[Surcharge] [int] NOT NULL,
	[DfTransactionId] [varchar](32) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[DfDesc] [varchar](256) NOT NULL,
	[Balance] [int] NOT NULL,
	[NotifyTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[RealName] [varchar](128) NOT NULL,
	[BankCard] [varchar](32) NOT NULL,
	[BankName] [varchar](128) NOT NULL,
	[Mobile] [varchar](32) NOT NULL,
	[EMail] [varchar](64) NOT NULL,
	[Address] [varchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LabelLiveStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LabelLiveStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[LabelID] [varchar](32) NOT NULL,
	[RegCount] [int] NOT NULL,
	[LiveUsers_1] [int] NOT NULL,
	[LiveUsers_3] [int] NOT NULL,
	[LiveUsers_5] [int] NOT NULL,
	[LiveUsers_7] [int] NOT NULL,
	[LiveUsers_15] [int] NOT NULL,
	[LiveUsers_30] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LabelPool]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LabelPool](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[TypeID] [int] NOT NULL,
	[LabelID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[RegTime] [datetime] NOT NULL,
	[Expire] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LadderSettlementRecord]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LadderSettlementRecord](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Point] [int] NOT NULL,
	[WinCount] [int] NOT NULL,
	[WinType] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[laOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[laOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[laPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[laPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LiveStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LiveStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[RegCount] [int] NOT NULL,
	[LiveUsers_1] [int] NOT NULL,
	[LiveUsers_3] [int] NOT NULL,
	[LiveUsers_5] [int] NOT NULL,
	[LiveUsers_7] [int] NOT NULL,
	[LiveUsers_15] [int] NOT NULL,
	[LiveUsers_30] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LoginStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoginStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[LoginCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LotteryMall]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LotteryMall](
	[Rid] [int] NOT NULL,
	[ShopType] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Ratio] [tinyint] NOT NULL,
	[MinOdds] [tinyint] NOT NULL,
	[MaxOdds] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MachineUser]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MachineUser](
	[UserID] [int] NOT NULL,
	[LoginName] [nvarchar](32) NOT NULL,
	[Password] [varchar](32) NOT NULL,
	[BatchID] [int] NOT NULL,
	[WriteTime] [datetime] NOT NULL,
	[Levels1] [int] NOT NULL,
	[Levels2] [int] NOT NULL,
	[Levels3] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MachineUserLock]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MachineUserLock](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ServerName] [varchar](128) NOT NULL,
	[LoginTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ManualPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ManualPay](
	[OrderID] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[OpUserID] [int] NOT NULL,
	[OpUserName] [varchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Match]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Match](
	[SerialNumber] [varchar](32) NOT NULL,
	[Title] [nvarchar](32) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Result] [nvarchar](32) NOT NULL,
	[StartAt] [datetime] NOT NULL,
	[EndAt] [datetime] NOT NULL,
	[ShowStartAt] [datetime] NOT NULL,
	[ShowEndAt] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SerialNumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MatchBet]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MatchBet](
	[BetID] [int] IDENTITY(1,1) NOT NULL,
	[SerialNumber] [varchar](32) NOT NULL,
	[BetName] [nvarchar](32) NOT NULL,
	[BetOdds] [decimal](10, 2) NOT NULL,
	[BetAmount] [int] NOT NULL,
	[IsWin] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[BetID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MatchCard]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MatchCard](
	[CardNo] [varchar](32) NOT NULL,
	[OpenTime] [datetime] NOT NULL,
	[ExpireTime] [datetime] NOT NULL,
	[TimeMemo] [nvarchar](1024) NOT NULL,
	[SceneMemo] [nvarchar](2048) NOT NULL,
	[UseTimes] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[CardNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MatchCardLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MatchCardLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[CardNo] [varchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MatchDataStatistics]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MatchDataStatistics](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[SerialNumber] [varchar](32) NOT NULL,
	[MatchID] [int] NOT NULL,
	[MatchType] [varchar](64) NOT NULL,
	[GameID] [int] NOT NULL,
	[EnrollFee] [varchar](256) NOT NULL,
	[MaxUserCount] [int] NOT NULL,
	[TableUserCount] [int] NOT NULL,
	[JoinUserCount] [int] NOT NULL,
	[StartTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MatchDataUserList]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MatchDataUserList](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[SerialNumber] [varchar](32) NOT NULL,
	[Rank] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[ItemCount] [int] NOT NULL,
	[EnrollTime] [datetime] NOT NULL,
	[Score] [int] NOT NULL,
	[Prize] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MatchTeam]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MatchTeam](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[SerialNumber] [varchar](32) NOT NULL,
	[TeamID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MaxWinRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MaxWinRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[IsDouble] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[money]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[money](
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Bank] [bigint] NOT NULL,
	[RegisterTime] [datetime] NOT NULL,
	[RefreshTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MoneyFlow]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MoneyFlow](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Tax] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MoneyLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MoneyLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[MoneyType] [varchar](8) NOT NULL,
	[UserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[ModifyAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[LogType] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MoneyLog_bak]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MoneyLog_bak](
	[LogID] [int] NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[MoneyType] [varchar](8) NOT NULL,
	[UserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[ModifyAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[LogType] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MoneyLogType]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MoneyLogType](
	[LogType] [int] NOT NULL,
	[LogTypeName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[ChineseName] [nvarchar](32) NOT NULL,
	[IsGameWin] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MoneyStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MoneyStat](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[LogType] [int] NOT NULL,
	[MoneySum] [bigint] NOT NULL,
	[TaxSum] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MoneyStatTotal]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MoneyStatTotal](
	[Crdate] [smalldatetime] NOT NULL,
	[TotalAmount] [bigint] NOT NULL,
	[TotalBank] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Crdate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MonthlyCard]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MonthlyCard](
	[ProductID] [varchar](32) NOT NULL,
	[ProductName] [nvarchar](32) NOT NULL,
	[Price] [int] NOT NULL,
	[Awards] [varchar](1024) NOT NULL,
	[DayItems] [varchar](1024) NOT NULL,
	[Memo] [nvarchar](512) NOT NULL,
	[Rate] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ProductID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MsgTag]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MsgTag](
	[TagID] [int] NOT NULL,
	[TagName] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[TagID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MyMatch]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MyMatch](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[MatchName] [nvarchar](32) NOT NULL,
	[Rank] [int] NOT NULL,
	[Items] [varchar](128) NOT NULL,
	[Status] [smallint] NOT NULL,
	[Crdate] [varchar](16) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewGiftConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewGiftConfig](
	[DayIndex] [int] NOT NULL,
	[Awards] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DayIndex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewUserGift]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewUserGift](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[DayIndex] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewUserSavingPot]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewUserSavingPot](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[CurrentLevel] [int] NOT NULL,
	[BuyAmount] [int] NOT NULL,
	[BuyTimes] [smallint] NOT NULL,
	[DuringTime] [datetime] NOT NULL,
	[MultiplyStatus] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewUserStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewUserStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Source] [nvarchar](256) NOT NULL,
	[RegCount] [int] NOT NULL,
	[LiveUsers_2] [int] NOT NULL,
	[PayUsers_1] [int] NOT NULL,
	[PayMoney_1] [decimal](18, 2) NOT NULL,
	[PayMoney_2] [decimal](18, 2) NOT NULL,
	[PayMoney_3] [decimal](18, 2) NOT NULL,
	[PayMoney_7] [decimal](18, 2) NOT NULL,
	[PayMoney_14] [decimal](18, 2) NOT NULL,
	[PayMoney_30] [decimal](18, 2) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewUserVip]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewUserVip](
	[RId] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[Level] [smallint] NOT NULL,
	[Point] [int] NOT NULL,
	[Expire] [int] NOT NULL,
	[DailyPackageClaimDay] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewUserVipPurchaseLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewUserVipPurchaseLog](
	[RId] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[ProductId] [varchar](32) NOT NULL,
	[PurchaseTime] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewUserYearGift]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewUserYearGift](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[DayIndex] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NewYearGiftConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewYearGiftConfig](
	[DayIndex] [int] NOT NULL,
	[Awards] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DayIndex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NoviceWelfareBigAward]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NoviceWelfareBigAward](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OnlineStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OnlineStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[OnlineUserCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OnlineStatChip]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OnlineStatChip](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[OnlineUserCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OnlineStatHour]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OnlineStatHour](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[Hour_0] [int] NOT NULL,
	[Hour_1] [int] NOT NULL,
	[Hour_2] [int] NOT NULL,
	[Hour_3] [int] NOT NULL,
	[Hour_4] [int] NOT NULL,
	[Hour_5] [int] NOT NULL,
	[Hour_6] [int] NOT NULL,
	[Hour_7] [int] NOT NULL,
	[Hour_8] [int] NOT NULL,
	[Hour_9] [int] NOT NULL,
	[Hour_10] [int] NOT NULL,
	[Hour_11] [int] NOT NULL,
	[Hour_12] [int] NOT NULL,
	[Hour_13] [int] NOT NULL,
	[Hour_14] [int] NOT NULL,
	[Hour_15] [int] NOT NULL,
	[Hour_16] [int] NOT NULL,
	[Hour_17] [int] NOT NULL,
	[Hour_18] [int] NOT NULL,
	[Hour_19] [int] NOT NULL,
	[Hour_20] [int] NOT NULL,
	[Hour_21] [int] NOT NULL,
	[Hour_22] [int] NOT NULL,
	[Hour_23] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OnlineStatHourChip]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OnlineStatHourChip](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[Hour_0] [int] NOT NULL,
	[Hour_1] [int] NOT NULL,
	[Hour_2] [int] NOT NULL,
	[Hour_3] [int] NOT NULL,
	[Hour_4] [int] NOT NULL,
	[Hour_5] [int] NOT NULL,
	[Hour_6] [int] NOT NULL,
	[Hour_7] [int] NOT NULL,
	[Hour_8] [int] NOT NULL,
	[Hour_9] [int] NOT NULL,
	[Hour_10] [int] NOT NULL,
	[Hour_11] [int] NOT NULL,
	[Hour_12] [int] NOT NULL,
	[Hour_13] [int] NOT NULL,
	[Hour_14] [int] NOT NULL,
	[Hour_15] [int] NOT NULL,
	[Hour_16] [int] NOT NULL,
	[Hour_17] [int] NOT NULL,
	[Hour_18] [int] NOT NULL,
	[Hour_19] [int] NOT NULL,
	[Hour_20] [int] NOT NULL,
	[Hour_21] [int] NOT NULL,
	[Hour_22] [int] NOT NULL,
	[Hour_23] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OnlineStatMin]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OnlineStatMin](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[Hour_0000] [int] NOT NULL,
	[Hour_0030] [int] NOT NULL,
	[Hour_0100] [int] NOT NULL,
	[Hour_0130] [int] NOT NULL,
	[Hour_0200] [int] NOT NULL,
	[Hour_0230] [int] NOT NULL,
	[Hour_0300] [int] NOT NULL,
	[Hour_0330] [int] NOT NULL,
	[Hour_0400] [int] NOT NULL,
	[Hour_0430] [int] NOT NULL,
	[Hour_0500] [int] NOT NULL,
	[Hour_0530] [int] NOT NULL,
	[Hour_0600] [int] NOT NULL,
	[Hour_0630] [int] NOT NULL,
	[Hour_0700] [int] NOT NULL,
	[Hour_0730] [int] NOT NULL,
	[Hour_0800] [int] NOT NULL,
	[Hour_0830] [int] NOT NULL,
	[Hour_0900] [int] NOT NULL,
	[Hour_0930] [int] NOT NULL,
	[Hour_1000] [int] NOT NULL,
	[Hour_1030] [int] NOT NULL,
	[Hour_1100] [int] NOT NULL,
	[Hour_1130] [int] NOT NULL,
	[Hour_1200] [int] NOT NULL,
	[Hour_1230] [int] NOT NULL,
	[Hour_1300] [int] NOT NULL,
	[Hour_1330] [int] NOT NULL,
	[Hour_1400] [int] NOT NULL,
	[Hour_1430] [int] NOT NULL,
	[Hour_1500] [int] NOT NULL,
	[Hour_1530] [int] NOT NULL,
	[Hour_1600] [int] NOT NULL,
	[Hour_1630] [int] NOT NULL,
	[Hour_1700] [int] NOT NULL,
	[Hour_1730] [int] NOT NULL,
	[Hour_1800] [int] NOT NULL,
	[Hour_1830] [int] NOT NULL,
	[Hour_1900] [int] NOT NULL,
	[Hour_1930] [int] NOT NULL,
	[Hour_2000] [int] NOT NULL,
	[Hour_2030] [int] NOT NULL,
	[Hour_2100] [int] NOT NULL,
	[Hour_2130] [int] NOT NULL,
	[Hour_2200] [int] NOT NULL,
	[Hour_2230] [int] NOT NULL,
	[Hour_2300] [int] NOT NULL,
	[Hour_2330] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OnlineStatMinChip]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OnlineStatMinChip](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[Hour_0000] [int] NOT NULL,
	[Hour_0030] [int] NOT NULL,
	[Hour_0100] [int] NOT NULL,
	[Hour_0130] [int] NOT NULL,
	[Hour_0200] [int] NOT NULL,
	[Hour_0230] [int] NOT NULL,
	[Hour_0300] [int] NOT NULL,
	[Hour_0330] [int] NOT NULL,
	[Hour_0400] [int] NOT NULL,
	[Hour_0430] [int] NOT NULL,
	[Hour_0500] [int] NOT NULL,
	[Hour_0530] [int] NOT NULL,
	[Hour_0600] [int] NOT NULL,
	[Hour_0630] [int] NOT NULL,
	[Hour_0700] [int] NOT NULL,
	[Hour_0730] [int] NOT NULL,
	[Hour_0800] [int] NOT NULL,
	[Hour_0830] [int] NOT NULL,
	[Hour_0900] [int] NOT NULL,
	[Hour_0930] [int] NOT NULL,
	[Hour_1000] [int] NOT NULL,
	[Hour_1030] [int] NOT NULL,
	[Hour_1100] [int] NOT NULL,
	[Hour_1130] [int] NOT NULL,
	[Hour_1200] [int] NOT NULL,
	[Hour_1230] [int] NOT NULL,
	[Hour_1300] [int] NOT NULL,
	[Hour_1330] [int] NOT NULL,
	[Hour_1400] [int] NOT NULL,
	[Hour_1430] [int] NOT NULL,
	[Hour_1500] [int] NOT NULL,
	[Hour_1530] [int] NOT NULL,
	[Hour_1600] [int] NOT NULL,
	[Hour_1630] [int] NOT NULL,
	[Hour_1700] [int] NOT NULL,
	[Hour_1730] [int] NOT NULL,
	[Hour_1800] [int] NOT NULL,
	[Hour_1830] [int] NOT NULL,
	[Hour_1900] [int] NOT NULL,
	[Hour_1930] [int] NOT NULL,
	[Hour_2000] [int] NOT NULL,
	[Hour_2030] [int] NOT NULL,
	[Hour_2100] [int] NOT NULL,
	[Hour_2130] [int] NOT NULL,
	[Hour_2200] [int] NOT NULL,
	[Hour_2230] [int] NOT NULL,
	[Hour_2300] [int] NOT NULL,
	[Hour_2330] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[OPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Partner]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Partner](
	[PartnerID] [int] NOT NULL,
	[PartnerName] [nvarchar](32) NOT NULL,
	[PrePartnerID] [int] NOT NULL,
	[EnglishName] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[PartnerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PayerMaxOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PayerMaxOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PayerMaxPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PayerMaxPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PayerMaxWithdraw]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PayerMaxWithdraw](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[RealAmount] [int] NOT NULL,
	[Surcharge] [int] NOT NULL,
	[DfTransactionId] [varchar](32) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[DfDesc] [varchar](256) NOT NULL,
	[Balance] [int] NOT NULL,
	[NotifyTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[RealName] [varchar](128) NOT NULL,
	[BankCard] [varchar](32) NOT NULL,
	[BankName] [varchar](128) NOT NULL,
	[Mobile] [varchar](32) NOT NULL,
	[EMail] [varchar](64) NOT NULL,
	[Address] [varchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[paymobOrder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[paymobOrder](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[GetStatus] [tinyint] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[PayInfo] [varchar](64) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[paymobPay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[paymobPay](
	[OrderID] [varchar](32) NOT NULL,
	[TradeID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PayStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PayStat](
	[DateFlag] [smalldatetime] NOT NULL,
	[RMBMoney] [decimal](18, 2) NOT NULL,
	[UserCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DateFlag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PlatformConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlatformConfig](
	[ConfigID] [int] NOT NULL,
	[RegGoldSend] [int] NOT NULL,
	[DailyTransferAmount] [bigint] NOT NULL,
	[BindFacebook] [int] NOT NULL,
	[BindMobile] [int] NOT NULL,
	[UpgradeAPK] [int] NOT NULL,
	[IsCouponTask] [tinyint] NOT NULL,
	[PlatformName] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ConfigID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PlatformInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlatformInfo](
	[PartnerID] [int] NOT NULL,
	[Version] [varchar](16) NOT NULL,
	[Download] [varchar](128) NOT NULL,
	[ApplePartnerID] [int] NOT NULL,
	[ProductStart] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[PartnerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PotentialFriends]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PotentialFriends](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[FriendUserID] [int] NOT NULL,
	[Memo] [nvarchar](64) NOT NULL,
	[MetTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PrizePool]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PrizePool](
	[RoomName] [varchar](32) NOT NULL,
	[Pool] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoomName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PrizePoolEnergy]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PrizePoolEnergy](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoomName] [varchar](32) NOT NULL,
	[Energy] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PrizeWheel]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PrizeWheel](
	[Rid] [int] NOT NULL,
	[Chance] [smallint] NOT NULL,
	[Items] [varchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Purchase]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Purchase](
	[SN] [int] NOT NULL,
	[BeginTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[LuckNumber] [int] NOT NULL,
	[Status] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SN] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RankAward]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RankAward](
	[AwardID] [int] NOT NULL,
	[RankType] [int] NOT NULL,
	[RankTypeName] [nvarchar](32) NOT NULL,
	[Rank] [int] NOT NULL,
	[Tools] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AwardID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RankHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RankHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RankType] [int] NOT NULL,
	[Rank] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RechargeCard]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RechargeCard](
	[CardNo] [varchar](32) NOT NULL,
	[GoldAmount] [bigint] NOT NULL,
	[UserID] [int] NOT NULL,
	[UseTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[CardNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RegStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RegStat](
	[DateFlag] [smalldatetime] NOT NULL,
	[UserCount] [int] NOT NULL,
	[TotalCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DateFlag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RetentionStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RetentionStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Item] [varchar](32) NOT NULL,
	[UserCount] [int] NOT NULL,
	[LiveUsers_1] [int] NOT NULL,
	[LiveUsers_3] [int] NOT NULL,
	[LiveUsers_5] [int] NOT NULL,
	[LiveUsers_7] [int] NOT NULL,
	[LiveUsers_15] [int] NOT NULL,
	[LiveUsers_30] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RobotClassification]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RobotClassification](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RobotID] [int] NOT NULL,
	[RobotType] [tinyint] NOT NULL,
	[RobotDesc] [nvarchar](256) NOT NULL,
	[AvatarFrame] [int] NOT NULL,
	[CardBack] [int] NOT NULL,
	[Dice] [int] NOT NULL,
	[VipLevel] [int] NOT NULL,
	[Gold] [bigint] NOT NULL,
	[Charm] [int] NOT NULL,
	[Level] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RobotMoneyLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RobotMoneyLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[MoneyType] [varchar](8) NOT NULL,
	[UserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[ModifyAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[LogType] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RobotMoneyLog_bak]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RobotMoneyLog_bak](
	[LogID] [int] NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[MoneyType] [varchar](8) NOT NULL,
	[UserID] [int] NOT NULL,
	[CurrentAmount] [bigint] NOT NULL,
	[ModifyAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[LogType] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ROI]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ROI](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[ItemType] [tinyint] NOT NULL,
	[ItemName] [nvarchar](32) NOT NULL,
	[ItemValue] [decimal](18, 2) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Role]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Role](
	[RoleID] [int] NOT NULL,
	[RoleName] [nvarchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RolePage]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RolePage](
	[RolePageID] [int] IDENTITY(1,1) NOT NULL,
	[RoleID] [int] NOT NULL,
	[PageID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RolePageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RoleUser]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RoleUser](
	[RoleUserID] [int] IDENTITY(1,1) NOT NULL,
	[AdminUserID] [int] NOT NULL,
	[RoleID] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoleUserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RoomCollect]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RoomCollect](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [int] NOT NULL,
	[DayIndex] [int] NOT NULL,
	[Points] [int] NOT NULL,
	[Ratio] [decimal](10, 2) NOT NULL,
	[Award] [varchar](64) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RoomHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RoomHistory](
	[RoomID] [bigint] IDENTITY(1,1) NOT NULL,
	[RoomNo] [varchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[OwnerUserID] [int] NOT NULL,
	[BeginTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[TotalAwardAmount] [bigint] NOT NULL,
	[TotalFee] [bigint] NOT NULL,
	[TotalTax] [bigint] NOT NULL,
	[ExtInfo] [varchar](1024) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoomID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RoomMicLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RoomMicLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoleID] [int] NOT NULL,
	[RoomID] [int] NOT NULL,
	[SN] [smallint] NOT NULL,
	[MicMode] [tinyint] NOT NULL,
	[OnMicTime] [datetime] NOT NULL,
	[OffMicTime] [datetime] NOT NULL,
	[Seconds] [int] NOT NULL,
	[OpUserID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RoomTask]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RoomTask](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[RoomID] [int] NOT NULL,
	[TaskID] [int] NOT NULL,
	[Schedule] [int] NOT NULL,
	[CurrNum] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ScoreRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ScoreRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[IsDouble] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ScoreRankConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ScoreRankConfig](
	[ConfigID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[ChineseName] [nvarchar](32) NOT NULL,
	[RoomName] [varchar](32) NOT NULL,
	[Score] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ConfigID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Server]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Server](
	[ServerID] [int] IDENTITY(1,1) NOT NULL,
	[GameID] [int] NOT NULL,
	[ServerName] [varchar](32) NOT NULL,
	[RollTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ServerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ServiceMessage]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServiceMessage](
	[MessageID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](256) NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[Msg] [nvarchar](512) NOT NULL,
	[IsRead] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[OpUserID] [int] NOT NULL,
	[OpUserName] [varchar](32) NOT NULL,
	[TransMsg] [varchar](512) NOT NULL,
	[TagID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[MessageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ServiceMessageImage]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServiceMessageImage](
	[ImgID] [int] IDENTITY(1,1) NOT NULL,
	[MessageID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Img] [varchar](1024) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ImgID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SettleVideo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SettleVideo](
	[Rid] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[LoseAmount] [bigint] NOT NULL,
	[MaxTimes] [tinyint] NOT NULL,
	[MaxRate] [smallint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SigninConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SigninConfig](
	[ConfigID] [int] NOT NULL,
	[Info] [varchar](1024) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ConfigID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SignInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SignInfo](
	[SignID] [int] NOT NULL,
	[Award] [varchar](128) NOT NULL,
	[DoubleVipLevel] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SignID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SlotAdCfg]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SlotAdCfg](
	[CfgID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TotalAdCount] [int] NOT NULL,
	[FreeSpinCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[CfgID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SlotAdUser]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SlotAdUser](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[StillAdCount] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SlotChipStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SlotChipStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[InvestAmount] [bigint] NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTimes] [int] NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[MaxResultAmount] [bigint] NOT NULL,
	[WinTimes] [int] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[Tax] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SlotStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SlotStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[InvestAmount] [bigint] NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTimes] [int] NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[MaxResultAmount] [bigint] NOT NULL,
	[WinTimes] [int] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[Tax] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SlotStatConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SlotStatConfig](
	[ConfigID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[ChineseName] [nvarchar](32) NOT NULL,
	[InvestAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ConfigID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SNGMatchChairHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SNGMatchChairHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[SerialNumber] [varchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[RankId] [int] NOT NULL,
	[Score] [int] NOT NULL,
	[ItemId] [int] NOT NULL,
	[Fee] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SNGMatchHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SNGMatchHistory](
	[SerialNumber] [bigint] IDENTITY(1,1) NOT NULL,
	[MatchID] [int] NOT NULL,
	[MatchNo] [varchar](32) NOT NULL,
	[MatchName] [varchar](32) NOT NULL,
	[GameID] [int] NOT NULL,
	[GameName] [varchar](32) NOT NULL,
	[StartTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SerialNumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SNGMatchReport]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SNGMatchReport](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[ItemType] [smallint] NOT NULL,
	[ItemName] [nvarchar](32) NOT NULL,
	[ItemValue] [decimal](18, 2) NOT NULL,
	[ItemTag] [smallint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SpreadMember]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SpreadMember](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Code] [int] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SysBroadcast]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SysBroadcast](
	[BroadcastID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Msg] [varchar](1024) NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[Priority] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[BroadcastID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SysLevel]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SysLevel](
	[Lv] [tinyint] NOT NULL,
	[Exp] [int] NOT NULL,
	[Memo] [nvarchar](256) NOT NULL,
	[GiftPack] [varchar](128) NOT NULL,
	[Privilege] [varchar](512) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Lv] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SysLevelExp]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SysLevelExp](
	[GameID] [int] NOT NULL,
	[WinExp] [int] NULL,
	[LoseExp] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[GameID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SysLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SysLog](
	[SysLogID] [int] IDENTITY(1,1) NOT NULL,
	[OpUserID] [int] NOT NULL,
	[OpUserName] [varchar](32) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Msg] [nvarchar](4000) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SysLogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SysMessage]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SysMessage](
	[SysMsgID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Title] [nvarchar](32) NOT NULL,
	[Content] [nvarchar](256) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[SourceName] [nvarchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[Tools] [varchar](256) NOT NULL,
	[MsgType] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SysMsgID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[t_onlinelog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_onlinelog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[ServerName] [nvarchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsChip] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[t_onlinetime]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_onlinetime](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[TotalSeconds] [int] NOT NULL,
	[TodaySeconds] [int] NOT NULL,
	[LoginTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[t_onlinetime_log]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_onlinetime_log](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ServerName] [nvarchar](32) NOT NULL,
	[LoginTime] [datetime] NOT NULL,
	[LogoutTime] [datetime] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[GameTime] [int] NOT NULL,
	[GameID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[t_onlinetimeHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_onlinetimeHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[TodaySeconds] [int] NOT NULL,
	[LoginTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[t_onlineuser]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_onlineuser](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ServerName] [nvarchar](32) NOT NULL,
	[LoginTime] [datetime] NOT NULL,
	[GameID] [int] NOT NULL,
	[IsChip] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Task]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Task](
	[TaskID] [int] NOT NULL,
	[Title] [nvarchar](32) NOT NULL,
	[Desc] [nvarchar](256) NOT NULL,
	[Action] [int] NOT NULL,
	[Scope] [varchar](256) NOT NULL,
	[Target] [int] NOT NULL,
	[Repeatable] [tinyint] NOT NULL,
	[Duration] [int] NOT NULL,
	[PreTask] [int] NOT NULL,
	[LimitedStart] [int] NOT NULL,
	[LimitedDuration] [int] NOT NULL,
	[Awards] [varchar](256) NOT NULL,
	[SceneID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Teacher]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Teacher](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Profit] [bigint] NOT NULL,
	[Students] [int] NOT NULL,
	[TotalProfit] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TeacherBindAward]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TeacherBindAward](
	[AwardID] [int] NOT NULL,
	[Students] [int] NOT NULL,
	[Profit] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AwardID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TeacherBindAwardLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TeacherBindAwardLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[TeacherID] [int] NOT NULL,
	[Students] [int] NOT NULL,
	[Profit] [bigint] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TeacherLoginAward]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TeacherLoginAward](
	[AwardID] [int] NOT NULL,
	[Days] [int] NOT NULL,
	[Profit] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AwardID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TeacherLoginAwardLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TeacherLoginAwardLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Days] [int] NOT NULL,
	[StudentID] [int] NOT NULL,
	[TeacherID] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TeacherProfit]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TeacherProfit](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[StudentID] [int] NOT NULL,
	[TeacherID] [int] NOT NULL,
	[Profit] [bigint] NOT NULL,
	[ProfitType] [tinyint] NOT NULL,
	[Price] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TeacherRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TeacherRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[IsDouble] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Team]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Team](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](32) NOT NULL,
	[Icon] [varchar](128) NOT NULL,
	[ShortName] [nvarchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TimeBroadcast]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TimeBroadcast](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[OpUserID] [int] NOT NULL,
	[OpUserName] [varchar](32) NOT NULL,
	[BeginDate] [datetime] NOT NULL,
	[BeginTime] [varchar](8) NOT NULL,
	[EndDate] [datetime] NOT NULL,
	[EndTime] [varchar](8) NOT NULL,
	[InterMinutes] [int] NOT NULL,
	[Msg] [varchar](1024) NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TimePeriodStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TimePeriodStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[TimePeriod] [nvarchar](32) NOT NULL,
	[UserCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TransferConfig]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TransferConfig](
	[ConfigID] [int] NOT NULL,
	[Fee] [int] NOT NULL,
	[FreeBeginTime] [datetime] NOT NULL,
	[FreeEndTime] [datetime] NOT NULL,
	[RefundBeginTime] [datetime] NOT NULL,
	[RefundEndTime] [datetime] NOT NULL,
	[RefundRatio] [int] NOT NULL,
	[RefundMaxAmount] [bigint] NOT NULL,
	[MinBeginTime] [datetime] NOT NULL,
	[MinEndTime] [datetime] NOT NULL,
	[MinAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ConfigID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TransferLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TransferLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[NickName] [nvarchar](32) NOT NULL,
	[CurrAmount] [bigint] NOT NULL,
	[WantAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[AcceptUserID] [int] NOT NULL,
	[AcceptNickName] [nvarchar](32) NOT NULL,
	[AcceptCurrAmount] [bigint] NOT NULL,
	[AcceptWantAmount] [bigint] NOT NULL,
	[AcceptStillAmount] [bigint] NOT NULL,
	[TaxAmount] [bigint] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Memo] [varchar](128) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TranslateText]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TranslateText](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[Source] [nvarchar](4000) NOT NULL,
	[Target] [nvarchar](4000) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Source] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UpgradeInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UpgradeInfo](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RegPartnerID] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserAchievement]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserAchievement](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[TaskID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserAgent]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserAgent](
	[UserID] [int] NOT NULL,
	[Commission] [bigint] NOT NULL,
	[Profit] [bigint] NOT NULL,
	[Members] [int] NOT NULL,
	[Enabled] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserAudioRoom]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserAudioRoom](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoomID] [int] NOT NULL,
	[RoleID] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[Level] [int] NOT NULL,
	[Exps] [int] NOT NULL,
	[DayExps] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserAwardLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserAwardLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ActiveID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserBadge]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserBadge](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[BadgeId] [int] NOT NULL,
	[Level] [smallint] NOT NULL,
	[Exps] [int] NOT NULL,
	[Points] [tinyint] NOT NULL,
	[Times] [int] NOT NULL,
	[Position] [smallint] NOT NULL,
	[ExpiresTime] [int] NOT NULL,
	[ObtainDate] [varchar](128) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserBankInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserBankInfo](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RealName] [varchar](32) NOT NULL,
	[BankName] [varchar](32) NOT NULL,
	[BankCode] [varchar](16) NOT NULL,
	[BankCard] [varchar](32) NOT NULL,
	[Mobile] [varchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserBehavior]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserBehavior](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[SceneName] [nvarchar](32) NOT NULL,
	[ActTime] [datetime] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[StaySeconds] [int] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[GameCount] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserBetCount]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserBetCount](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[PlayCount] [int] NOT NULL,
	[BetTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserBindFacebook]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserBindFacebook](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[IMei] [varchar](64) NOT NULL,
	[Facebook_1_ID] [varchar](64) NOT NULL,
	[Facebook_2_ID] [varchar](64) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserCharm]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserCharm](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Charm] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserCharmHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserCharmHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[Charm] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserChipScore]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserChipScore](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[Score] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserChipSubsidy]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserChipSubsidy](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserContinueSign]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserContinueSign](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Day] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserContribute]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserContribute](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoomID] [int] NOT NULL,
	[Action] [int] NOT NULL,
	[Exps] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserCountry]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserCountry](
	[UserID] [int] NOT NULL,
	[CountryName] [nvarchar](32) NOT NULL,
	[Currency] [varchar](32) NOT NULL,
	[IsModify] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserCouponInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserCouponInfo](
	[InfoID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[TodayCount] [int] NOT NULL,
	[BaseLimit] [int] NOT NULL,
	[PlayTimes] [int] NOT NULL,
	[TmpAdd] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[InfoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserCouponStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserCouponStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[Remark] [varchar](128) NOT NULL,
	[CouponCount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserCouponTask]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserCouponTask](
	[UserTaskID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[BaseScore] [int] NOT NULL,
	[GameCount] [smallint] NOT NULL,
	[Coupons] [int] NOT NULL,
	[GiftStatus] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserTaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserDailyStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserDailyStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[LoseAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[GameStart] [datetime] NOT NULL,
	[GameEnd] [datetime] NOT NULL,
	[PlaySeconds] [int] NOT NULL,
	[PayMoney] [decimal](18, 2) NOT NULL,
	[LoginCount] [int] NOT NULL,
	[VideoPlayTimes] [int] NOT NULL,
	[VideoSendAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserDailyStatHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserDailyStatHistory](
	[Rid] [int] NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[LoseAmount] [bigint] NOT NULL,
	[StillAmount] [bigint] NOT NULL,
	[GameStart] [datetime] NOT NULL,
	[GameEnd] [datetime] NOT NULL,
	[PlaySeconds] [int] NOT NULL,
	[PayMoney] [decimal](18, 2) NOT NULL,
	[LoginCount] [int] NOT NULL,
	[VideoPlayTimes] [int] NOT NULL,
	[VideoSendAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserDecoration]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserDecoration](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[DecorationType] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserDot]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserDot](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [varchar](16) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Scene] [varchar](32) NOT NULL,
	[Event] [varchar](32) NOT NULL,
	[Action] [tinyint] NOT NULL,
	[Times] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserDotHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserDotHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [varchar](16) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Scene] [varchar](32) NOT NULL,
	[Event] [varchar](32) NOT NULL,
	[Action] [tinyint] NOT NULL,
	[Times] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserDotStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserDotStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Event] [varchar](32) NOT NULL,
	[LabelID] [varchar](32) NOT NULL,
	[Days] [int] NOT NULL,
	[ClickTimes] [int] NOT NULL,
	[ClickUserCount] [int] NOT NULL,
	[CompleteUserCount] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserFace]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserFace](
	[UserID] [int] NOT NULL,
	[Sex] [tinyint] NOT NULL,
	[FaceID] [smallint] NOT NULL,
	[FaceUrl] [varchar](1024) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserFriends]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserFriends](
	[FriendID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[GiftTime] [datetime] NOT NULL,
	[GiveTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[FriendID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserFriendsApply]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserFriendsApply](
	[ApplyID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[DealTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ApplyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserFriendsHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserFriendsHistory](
	[FriendID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[ToUserID] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[DelTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[FriendID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserGameCount]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserGameCount](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[TotalCount] [int] NOT NULL,
	[WinCount] [int] NOT NULL,
	[MaxWinAmount] [bigint] NOT NULL,
	[CardStat] [varchar](1024) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserGameFreeChipLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserGameFreeChipLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[FaceValue] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserGift]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserGift](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[Sender] [int] NOT NULL,
	[Receiver] [int] NOT NULL,
	[GiftID] [int] NOT NULL,
	[GiftType] [tinyint] NOT NULL,
	[SendTime] [int] NOT NULL,
	[ClaimTime] [int] NOT NULL,
	[Items] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserGiftPack]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserGiftPack](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PackageId] [int] NOT NULL,
	[StartDay] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserGiftPackHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserGiftPackHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GiftPackId] [int] NOT NULL,
	[LastPhaseTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserGrowthPack]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserGrowthPack](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GrowthPackID] [int] NOT NULL,
	[TermIndex] [int] NOT NULL,
	[Bullet] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserGrowthTerm]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserGrowthTerm](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PackageId] [int] NOT NULL,
	[TermIndex] [int] NOT NULL,
	[ClaimDay] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserIdentity]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserIdentity](
	[UserID] [int] NOT NULL,
	[IMei] [varchar](64) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserIncome]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserIncome](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ItemType] [tinyint] NOT NULL,
	[Balance] [decimal](10, 2) NOT NULL,
	[TotalProfit] [decimal](18, 2) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserIncomeLevel]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserIncomeLevel](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[IncomeLevel] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserIncomeLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserIncomeLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoomID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[FromUserID] [int] NOT NULL,
	[ItemType] [tinyint] NOT NULL,
	[IncomeType] [int] NOT NULL,
	[UserType] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Profit] [decimal](18, 2) NOT NULL,
	[StillProfit] [decimal](18, 2) NOT NULL,
	[RealProfit] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserItem]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserItem](
	[UserItemID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[ItemCount] [int] NOT NULL,
	[EnegyPoint] [int] NOT NULL,
	[Start] [int] NOT NULL,
	[Duration] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserItemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserItemLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserItemLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[CurrCount] [bigint] NOT NULL,
	[WantCount] [bigint] NOT NULL,
	[StillCount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserItemLogHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserItemLogHistory](
	[LogID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[CurrCount] [bigint] NOT NULL,
	[WantCount] [bigint] NOT NULL,
	[StillCount] [bigint] NOT NULL,
	[Remark] [nvarchar](128) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserLabel]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserLabel](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[TypeID] [int] NOT NULL,
	[LabelID] [varchar](32) NOT NULL,
	[TotalValue] [int] NOT NULL,
	[JsonData] [varchar](4096) NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserLadder]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserLadder](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Point] [int] NOT NULL,
	[MaxCounWin] [int] NOT NULL,
	[WinCount] [int] NOT NULL,
	[LoseCount] [int] NOT NULL,
	[DrawCount] [int] NOT NULL,
	[Record] [varchar](1024) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserLevel]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserLevel](
	[UserID] [int] NOT NULL,
	[Lv] [tinyint] NOT NULL,
	[Exp] [int] NOT NULL,
	[LoginAward] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserLevelRewards]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserLevelRewards](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Level] [int] NOT NULL,
	[PaidPack] [tinyint] NOT NULL,
	[ClaimStatus] [tinyint] NOT NULL,
	[CreateDayIndex] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserLoginLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserLoginLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[IMei] [varchar](64) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Version] [int] NOT NULL,
	[LoginType] [tinyint] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[DeviceName] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserLoginLog_bak]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserLoginLog_bak](
	[LogID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[IMei] [varchar](64) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Version] [int] NOT NULL,
	[LoginType] [tinyint] NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[DeviceName] [varchar](32) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserMaxWin]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserMaxWin](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserMonthlyCard]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserMonthlyCard](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[MonthGift] [datetime] NOT NULL,
	[MonthExpire] [datetime] NOT NULL,
	[WeekGift] [datetime] NOT NULL,
	[WeekExpire] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserNoviceWelfare]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserNoviceWelfare](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[DayIndex] [int] NOT NULL,
	[Scheduled] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[UnlockDayIndex] [smallint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserPayLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserPayLog](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[RMBMoney] [decimal](18, 2) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserPlayTime]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserPlayTime](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RefreshTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserPrizeWheel]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserPrizeWheel](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Times] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserPrizeWheelHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserPrizeWheelHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[WheelID] [int] NOT NULL,
	[Items] [varchar](256) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserPurchase]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserPurchase](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[SN] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Number] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserRechargeProduct]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserRechargeProduct](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[ShopType] [int] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserReview]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserReview](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[AppName] [varchar](32) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserRoomTask]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserRoomTask](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[RoomID] [int] NOT NULL,
	[TaskID] [int] NOT NULL,
	[Schedule] [int] NOT NULL,
	[CurrNum] [int] NOT NULL,
	[Status] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSavingPot]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSavingPot](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[BuyTimes] [smallint] NOT NULL,
	[BuyAmount] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserScore]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserScore](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[Score] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSettleVideo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSettleVideo](
	[SettleID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[LoseAmount] [bigint] NOT NULL,
	[MaxTimes] [tinyint] NOT NULL,
	[SettleTimes] [tinyint] NOT NULL,
	[MaxAmount] [bigint] NOT NULL,
	[SettleAmount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SettleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSign]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSign](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[SignID] [int] NOT NULL,
	[SignTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSigninHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSigninHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Base] [int] NOT NULL,
	[Multiple] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Awards] [varchar](128) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSlotStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSlotStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[InvestAmount] [bigint] NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTimes] [int] NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[WinTimes] [int] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[Tax] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSlotStatHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSlotStatHistory](
	[Rid] [int] NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[GameID] [int] NOT NULL,
	[InvestAmount] [bigint] NOT NULL,
	[BetAmount] [bigint] NOT NULL,
	[BetTimes] [int] NOT NULL,
	[ResultAmount] [bigint] NOT NULL,
	[WinTimes] [int] NOT NULL,
	[WinAmount] [bigint] NOT NULL,
	[Tax] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSubsidy]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSubsidy](
	[SubsidyID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[GiftTimes] [int] NOT NULL,
	[CoolTime] [datetime] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SubsidyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserSwitch]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserSwitch](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[SwitchType] [nvarchar](32) NOT NULL,
	[SwitchStatus] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTask]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTask](
	[UserTaskID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[TaskID] [int] NOT NULL,
	[Scheduled] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Start] [datetime] NOT NULL,
	[Duration] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserTaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTeacher]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTeacher](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[StudentID] [int] NOT NULL,
	[TeacherID] [int] NOT NULL,
	[Profit] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTel]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTel](
	[UserID] [int] NOT NULL,
	[Tel] [varchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTestTest]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTestTest](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTrack]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTrack](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Level_1] [nvarchar](32) NOT NULL,
	[Level_2] [nvarchar](32) NOT NULL,
	[Level_3] [nvarchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTrackHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTrackHistory](
	[Rid] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Level_1] [nvarchar](32) NOT NULL,
	[Level_2] [nvarchar](32) NOT NULL,
	[Level_3] [nvarchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTrackStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTrackStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[Level_1] [nvarchar](32) NOT NULL,
	[Level_2] [nvarchar](32) NOT NULL,
	[Level_3] [nvarchar](32) NOT NULL,
	[Times] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserTrackStatHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTrackStatHistory](
	[Rid] [int] NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[Level_1] [nvarchar](32) NOT NULL,
	[Level_2] [nvarchar](32) NOT NULL,
	[Level_3] [nvarchar](32) NOT NULL,
	[Times] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserVideo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserVideo](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[VideoID] [int] NOT NULL,
	[PlayTimes] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserVideoLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserVideoLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[VideoName] [nvarchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[ModuleName] [nvarchar](32) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserVideoLogHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserVideoLogHistory](
	[Rid] [int] NOT NULL,
	[VideoName] [nvarchar](32) NOT NULL,
	[UserID] [int] NOT NULL,
	[ModuleName] [nvarchar](32) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserVideoStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserVideoStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[VideoName] [nvarchar](32) NOT NULL,
	[ModuleName] [nvarchar](32) NOT NULL,
	[ReqTimes] [int] NOT NULL,
	[PlayTimes] [int] NOT NULL,
	[UnPlayTimes] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserVideoStatHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserVideoStatHistory](
	[Rid] [int] NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[UserID] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[VideoName] [nvarchar](32) NOT NULL,
	[ModuleName] [nvarchar](32) NOT NULL,
	[ReqTimes] [int] NOT NULL,
	[PlayTimes] [int] NOT NULL,
	[UnPlayTimes] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserVip]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserVip](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[VipLevel] [int] NOT NULL,
	[VipPoint] [bigint] NOT NULL,
	[Expire] [int] NOT NULL,
	[DailyPackageClaimDay] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserVitality]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserVitality](
	[VitalityID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[DayIndex] [int] NOT NULL,
	[DayPoint] [int] NOT NULL,
	[WeekIndex] [int] NOT NULL,
	[WeekPoint] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[VitalityID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserWordsPool]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserWordsPool](
	[ApplyID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[UserWords] [nvarchar](256) NOT NULL,
	[TransMsg] [nvarchar](256) NOT NULL,
	[Status] [tinyint] NOT NULL,
	[OpUserID] [int] NOT NULL,
	[OpUserName] [varchar](32) NOT NULL,
	[DealTime] [datetime] NOT NULL,
	[ApplyTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ApplyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UTM]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UTM](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Source] [nvarchar](128) NOT NULL,
	[Medium] [nvarchar](128) NOT NULL,
	[Term] [nvarchar](128) NOT NULL,
	[Content] [nvarchar](256) NOT NULL,
	[Campaign] [nvarchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UTMSource]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UTMSource](
	[Source] [nvarchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Source] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VerifyErrorLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VerifyErrorLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ErrorMsg] [varchar](1024) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VerifyLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VerifyLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[ReceiptBuffer] [varchar](4096) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VerifySuccessLog]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VerifySuccessLog](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[TransactionID] [varchar](64) NOT NULL,
	[UserID] [int] NOT NULL,
	[ProductID] [varchar](64) NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[Memo] [varchar](1024) NOT NULL,
	[IPAddress] [varchar](16) NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsSandBox] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[TransactionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Video]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Video](
	[VideoID] [int] NOT NULL,
	[PlayTimes] [int] NOT NULL,
	[Awards] [varchar](256) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[VideoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VideoRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VideoRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[IsDouble] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VideoStatMin]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VideoStatMin](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Hour_0000] [int] NOT NULL,
	[Hour_0030] [int] NOT NULL,
	[Hour_0100] [int] NOT NULL,
	[Hour_0130] [int] NOT NULL,
	[Hour_0200] [int] NOT NULL,
	[Hour_0230] [int] NOT NULL,
	[Hour_0300] [int] NOT NULL,
	[Hour_0330] [int] NOT NULL,
	[Hour_0400] [int] NOT NULL,
	[Hour_0430] [int] NOT NULL,
	[Hour_0500] [int] NOT NULL,
	[Hour_0530] [int] NOT NULL,
	[Hour_0600] [int] NOT NULL,
	[Hour_0630] [int] NOT NULL,
	[Hour_0700] [int] NOT NULL,
	[Hour_0730] [int] NOT NULL,
	[Hour_0800] [int] NOT NULL,
	[Hour_0830] [int] NOT NULL,
	[Hour_0900] [int] NOT NULL,
	[Hour_0930] [int] NOT NULL,
	[Hour_1000] [int] NOT NULL,
	[Hour_1030] [int] NOT NULL,
	[Hour_1100] [int] NOT NULL,
	[Hour_1130] [int] NOT NULL,
	[Hour_1200] [int] NOT NULL,
	[Hour_1230] [int] NOT NULL,
	[Hour_1300] [int] NOT NULL,
	[Hour_1330] [int] NOT NULL,
	[Hour_1400] [int] NOT NULL,
	[Hour_1430] [int] NOT NULL,
	[Hour_1500] [int] NOT NULL,
	[Hour_1530] [int] NOT NULL,
	[Hour_1600] [int] NOT NULL,
	[Hour_1630] [int] NOT NULL,
	[Hour_1700] [int] NOT NULL,
	[Hour_1730] [int] NOT NULL,
	[Hour_1800] [int] NOT NULL,
	[Hour_1830] [int] NOT NULL,
	[Hour_1900] [int] NOT NULL,
	[Hour_1930] [int] NOT NULL,
	[Hour_2000] [int] NOT NULL,
	[Hour_2030] [int] NOT NULL,
	[Hour_2100] [int] NOT NULL,
	[Hour_2130] [int] NOT NULL,
	[Hour_2200] [int] NOT NULL,
	[Hour_2230] [int] NOT NULL,
	[Hour_2300] [int] NOT NULL,
	[Hour_2330] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VideoUserStatMin]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VideoUserStatMin](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[Hour_0000] [int] NOT NULL,
	[Hour_0030] [int] NOT NULL,
	[Hour_0100] [int] NOT NULL,
	[Hour_0130] [int] NOT NULL,
	[Hour_0200] [int] NOT NULL,
	[Hour_0230] [int] NOT NULL,
	[Hour_0300] [int] NOT NULL,
	[Hour_0330] [int] NOT NULL,
	[Hour_0400] [int] NOT NULL,
	[Hour_0430] [int] NOT NULL,
	[Hour_0500] [int] NOT NULL,
	[Hour_0530] [int] NOT NULL,
	[Hour_0600] [int] NOT NULL,
	[Hour_0630] [int] NOT NULL,
	[Hour_0700] [int] NOT NULL,
	[Hour_0730] [int] NOT NULL,
	[Hour_0800] [int] NOT NULL,
	[Hour_0830] [int] NOT NULL,
	[Hour_0900] [int] NOT NULL,
	[Hour_0930] [int] NOT NULL,
	[Hour_1000] [int] NOT NULL,
	[Hour_1030] [int] NOT NULL,
	[Hour_1100] [int] NOT NULL,
	[Hour_1130] [int] NOT NULL,
	[Hour_1200] [int] NOT NULL,
	[Hour_1230] [int] NOT NULL,
	[Hour_1300] [int] NOT NULL,
	[Hour_1330] [int] NOT NULL,
	[Hour_1400] [int] NOT NULL,
	[Hour_1430] [int] NOT NULL,
	[Hour_1500] [int] NOT NULL,
	[Hour_1530] [int] NOT NULL,
	[Hour_1600] [int] NOT NULL,
	[Hour_1630] [int] NOT NULL,
	[Hour_1700] [int] NOT NULL,
	[Hour_1730] [int] NOT NULL,
	[Hour_1800] [int] NOT NULL,
	[Hour_1830] [int] NOT NULL,
	[Hour_1900] [int] NOT NULL,
	[Hour_1930] [int] NOT NULL,
	[Hour_2000] [int] NOT NULL,
	[Hour_2030] [int] NOT NULL,
	[Hour_2100] [int] NOT NULL,
	[Hour_2130] [int] NOT NULL,
	[Hour_2200] [int] NOT NULL,
	[Hour_2230] [int] NOT NULL,
	[Hour_2300] [int] NOT NULL,
	[Hour_2330] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VipDeal]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VipDeal](
	[VipDealId] [int] NOT NULL,
	[VipDealName] [varchar](32) NOT NULL,
	[VipLevel] [smallint] NOT NULL,
	[Items] [varchar](1024) NOT NULL,
	[Price] [bigint] NOT NULL,
	[ProductID] [varchar](32) NOT NULL,
	[Rate] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[VipDealId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VipDealHistory]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VipDealHistory](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[VipDealId] [int] NOT NULL,
	[LastExchangeTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[VipInfo]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VipInfo](
	[VipLevel] [smallint] NOT NULL,
	[VipPoint] [bigint] NOT NULL,
	[Description] [varchar](512) NOT NULL,
	[GiftPack] [varchar](256) NOT NULL,
	[Privilege] [varchar](512) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[VipLevel] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WaterPool]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WaterPool](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PoolType] [bigint] NOT NULL,
	[PoolValue] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WaterPoolRecord]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WaterPoolRecord](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[PoolValue] [bigint] NOT NULL,
	[WantValue] [bigint] NOT NULL,
	[GenType] [varchar](32) NOT NULL,
	[RoomType] [int] NOT NULL,
	[RoomName] [varchar](32) NOT NULL,
	[Crdate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WaterPoolStat]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WaterPoolStat](
	[Rid] [int] IDENTITY(1,1) NOT NULL,
	[DateFlag] [smalldatetime] NOT NULL,
	[ItemName] [varchar](32) NOT NULL,
	[ItemValue] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WaterPoolTotal]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WaterPoolTotal](
	[DateFlag] [smalldatetime] NOT NULL,
	[PositiveGenAmount] [bigint] NOT NULL,
	[PositiveExecAmount] [bigint] NOT NULL,
	[NagetiveGenAmount] [bigint] NOT NULL,
	[NagetiveExecAmount] [bigint] NOT NULL,
	[GrantAmount] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DateFlag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WealthRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WealthRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WinRank]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WinRank](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
	[IsDouble] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WinRankDay]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WinRankDay](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WinRankMonth]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WinRankMonth](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WinRankWeek]    Script Date: 2024/1/12 11:03:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WinRankWeek](
	[Rank] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[Amount] [bigint] NOT NULL,
	[Crdate] [datetime] NOT NULL,
	[IsGift] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Rank] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO