-- ------------------------------ Table structure for groups_grants-- ----------------------------IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[groups_grants]') AND type IN ('U')) DROP TABLE [dbo].[groups_grants]GOCREATE TABLE [dbo].[groups_grants] ( [groupID] int NOT NULL, [page] varchar(64) COLLATE French_CI_AS NULL)GOALTER TABLE [dbo].[groups_grants] SET (LOCK_ESCALATION = TABLE)GO-- ------------------------------ Records of groups_grants-- ----------------------------INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'char_find')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'user_check')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'ban_user')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'change_game_email')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'change_password')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'char_manage')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'char_rename')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'customer_info')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'item_mod')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'item_del')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'list_of_banned_users')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'log')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'item_add')GOINSERT INTO [dbo].[groups_grants] VALUES (N'1', N'unban_user')GO-- ------------------------------ Table structure for groups_users-- ----------------------------IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[groups_users]') AND type IN ('U')) DROP TABLE [dbo].[groups_users]GOCREATE TABLE [dbo].[groups_users] ( [groupID] int NOT NULL, [userID] int NULL)GOALTER TABLE [dbo].[groups_users] SET (LOCK_ESCALATION = TABLE)GO-- ------------------------------ Records of groups_users-- ----------------------------INSERT INTO [dbo].[groups_users] VALUES (N'1', N'1')GO-- ------------------------------ Table structure for log-- ----------------------------IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[log]') AND type IN ('U')) DROP TABLE [dbo].[log]GOCREATE TABLE [dbo].[log] ( [userID] nvarchar(64) COLLATE French_CI_AS NULL, [page] varchar(64) COLLATE French_CI_AS NULL, [timestamp] nvarchar(64) COLLATE French_CI_AS NULL, [userID2] nvarchar(64) COLLATE French_CI_AS NULL, [msg] nvarchar(64) COLLATE French_CI_AS DEFAULT ((0)) NULL, [msg2] nvarchar(64) COLLATE French_CI_AS DEFAULT ((0)) NULL, [msg3] nvarchar(64) COLLATE French_CI_AS DEFAULT ((0)) NULL, [msg4] nvarchar(64) COLLATE French_CI_AS DEFAULT ((0)) NULL, [msg5] nvarchar(64) COLLATE French_CI_AS DEFAULT ((0)) NULL)GOALTER TABLE [dbo].[log] SET (LOCK_ESCALATION = TABLE)GO-- ------------------------------ Records of log-- ----------------------------INSERT INTO [dbo].[log] VALUES (N'1', N'item_add', N'2019-03-30 22:33:46', N'1000002', N'20180', N'', N'', N'', N'')GOINSERT INTO [dbo].[log] VALUES (N'1', N'unban_user', N'2019-03-30 22:42:43', N'1000002', N'test (web from 127.0.0.1 by admin)', N'', N'', N'', N'')GOINSERT INTO [dbo].[log] VALUES (N'1', N'item_add', N'2019-05-26 20:00:29', N'100002', N'20180', N'', N'', N'', N'')GOINSERT INTO [dbo].[log] VALUES (N'1', N'unban_user', N'2019-05-31 15:33:01', N'1004655', N'not reason for banned (web from 127.0.0.1 by admin)', N'', N'', N'', N'')GO-- ------------------------------ Table structure for users-- ----------------------------IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[users]') AND type IN ('U')) DROP TABLE [dbo].[users]GOCREATE TABLE [dbo].[users] ( [id] int NOT NULL, [name] varchar(64) COLLATE French_CI_AS NULL, [password] varchar(64) COLLATE French_CI_AS NULL, [session] nvarchar(64) COLLATE French_CI_AS NULL, [access] nvarchar(64) COLLATE French_CI_AS NULL)GOALTER TABLE [dbo].[users] SET (LOCK_ESCALATION = TABLE)GO-- ------------------------------ Records of users-- ----------------------------INSERT INTO [dbo].[users] VALUES (N'1', N'admin', N'2a1da1e23f38403dbb258359ace90e11', N'5cfbf8833eaa9', N'2019-06-08 15:03:47')GO-- ------------------------------ Primary Key structure for table users-- ----------------------------ALTER TABLE [dbo].[users] ADD CONSTRAINT [PK__users__3213E83F7F60ED59] PRIMARY KEY CLUSTERED ([id])WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GO