webinterface.sql

-- ----------------------------
-- 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]
GO

CREATE TABLE [dbo].[groups_grants] (
  [groupID] INT  NOT NULL,
  [page] VARCHAR(64) COLLATE French_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[groups_grants] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of groups_grants
-- ----------------------------
INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'char_find')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'user_check')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'ban_user')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'change_game_email')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'change_password')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'char_manage')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'char_rename')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'customer_info')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'item_mod')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'item_del')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'list_of_banned_users')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'log')
GO

INSERT INTO [dbo].[groups_grants] VALUES (N'1', N'item_add')
GO

INSERT 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]
GO

CREATE TABLE [dbo].[groups_users] (
  [groupID] INT  NOT NULL,
  [userID] INT  NULL
)
GO

ALTER 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]
GO

CREATE 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
)
GO

ALTER 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'')
GO

INSERT 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'')
GO

INSERT INTO [dbo].[log] VALUES (N'1', N'item_add', N'2019-05-26 20:00:29', N'100002', N'20180', N'', N'', N'', N'')
GO

INSERT 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]
GO

CREATE 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
)
GO

ALTER 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