[SilkRoad] vSRO PHP Panel - PurePanel Free (8 Different Themes) V.I.P

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[TB_User] Script Date: 31.10.2019 21:04:41 ******/
DROP TABLE [dbo].[TB_User]
GO

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[TB_User] Script Date: 06.07.2019 16:12:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TB_User](
[JID] [int] IDENTITY(1,1) NOT NULL,
[StrUserID] [varchar](25) NOT NULL,
[password] [varchar](50) NOT NULL,
[Status] [tinyint] NULL,
[GMrank] [tinyint] NULL,
[Name] [nvarchar](50) NULL,
[varchar](50) NULL,
[sex] [char](2) NULL,
[certificate_num] [varchar](30) NULL,
[address] [nvarchar](100) NULL,
[postcode] [varchar](10) NULL,
[phone] [varchar](20) NULL,
[mobile] [varchar](20) NULL,
[regtime] [datetime] NULL,
[reg_ip] [varchar](25) NULL,
[Time_log] [datetime] NULL,
[freetime] [int] NULL,
[sec_primary] [tinyint] NOT NULL CONSTRAINT [DF_TB_User_sec_primary] DEFAULT ((3)),
[sec_content] [tinyint] NOT NULL CONSTRAINT [DF_TB_User_sec_content] DEFAULT ((3)),
[AccPlayTime] [int] NOT NULL CONSTRAINT [DF__TB_User__AccPlay__3BFFE745] DEFAULT ((0)),
[LatestUpdateTime_ToPlayTime] [int] NOT NULL CONSTRAINT [DF__TB_User__LatestU__3CF40B7E] DEFAULT ((0)),
[Play123Time] [int] NOT NULL CONSTRAINT [DF_TB_User_Play123Time] DEFAULT ((0)),
[Ban] [int] NULL CONSTRAINT [DF_TB_User_Ban] DEFAULT ((1)),
[Money] [real] NULL CONSTRAINT [DF_TB_User_Money] DEFAULT ((0)),
[Cafe] [int] NULL CONSTRAINT [DF_TB_User_Cafe] DEFAULT ((0)),
[last_login] [smalldatetime] NULL,
[last_ip] [varchar](50) NULL,
[joindate] [smalldatetime] NULL,
[credit] [int] NOT NULL CONSTRAINT [DF_TB_User_credit] DEFAULT ((0)),
[rememberpass] [varchar](50) NULL,
[game_credit] [int] NULL,
CONSTRAINT [PK_TB_User] PRIMARY KEY CLUSTERED
(
[JID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO


ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF_TB_User_sec_primary] DEFAULT ((3)) FOR [sec_primary]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF_TB_User_sec_content] DEFAULT ((3)) FOR [sec_content]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF__TB_User__AccPlay__3BFFE745] DEFAULT ((0)) FOR [AccPlayTime]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF__TB_User__LatestU__3CF40B7E] DEFAULT ((0)) FOR [LatestUpdateTime_ToPlayTime]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF_TB_User_Play123Time] DEFAULT ((0)) FOR [Play123Time]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF_TB_User_Ban] DEFAULT ((1)) FOR [Ban]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF_TB_User_Money] DEFAULT ((0)) FOR [Money]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF_TB_User_Cafe] DEFAULT ((0)) FOR [Cafe]
GO

ALTER TABLE [dbo].[TB_User] ADD CONSTRAINT [DF_TB_User_credit] DEFAULT ((0)) FOR [credit]
GO