22,207
社区成员
发帖
与我相关
我的任务
分享
USE [smartadmin]
GO
/****** 对象: Table [dbo].[smartadmin_data] 脚本日期: 03/16/2018 22:09:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[smartadmin_data](
[id] [int] IDENTITY(1,1) NOT NULL,
[Device] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Device_ID] [int] NOT NULL,
[Device_Property] [int] NOT NULL,
[project_ID] [int] NOT NULL,
[username] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[password] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[email] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[gameRegion] [int] NOT NULL,
[gameServer] [int] NOT NULL,
[character] [int] NULL,
[characterName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Status] [int] NOT NULL CONSTRAINT [DF_smartadmin_data_Status] DEFAULT ((0)),
[FirstTime] [datetime] NOT NULL,
[FirstIP] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[RequestTime] [datetime] NOT NULL,
[RequestIP] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Switch] [int] NULL,
[SwitchTime] [datetime] NULL,
[SwitchIP] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[gold] [int] NULL,
[diamond] [int] NULL,
[silver] [int] NULL,
[servers] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[descriptions] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[useDeviceID] [int] NULL,
[sell] [int] NULL,
[sellTime] [datetime] NULL,
[sellIP] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[sellDeviceID] [int] NULL,
[Processing] [int] NULL,
[Client] [int] NULL,
CONSTRAINT [PK__smartadmin_data] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF