ALARM/豪恩LHB9000管理软件/Navicat sql/OperateLog.sql

/*
Navicat SQL Server Data Transfer

Source Server         : 9000
Source Server Version : 105000
Source Host           : .\sqlexpress:1433
Source Database       : LHBMS
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2021-05-11 15:33:31
*/


-- ----------------------------
-- Table structure for OperateLog
-- ----------------------------
DROP TABLE [dbo].[OperateLog]
GO
CREATE TABLE [dbo].[OperateLog] (
[ID] uniqueidentifier NOT NULL DEFAULT (newid()) ROWGUIDCOL ,
[UserName] nvarchar(50) NOT NULL ,
[Module] nvarchar(50) NULL ,
[OptContent] nvarchar(1000) NULL ,
[OptDate] datetime NULL ,
[IPAddress] nvarchar(50) NULL ,
[Mac] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of OperateLog
-- ----------------------------
INSERT INTO [dbo].[OperateLog] ([ID], [UserName], [Module], [OptContent], [OptDate], [IPAddress], [Mac]) VALUES (N'A169ED24-20F7-4F51-A3AE-E177397AFBB5', N'admin', N'登录', N'登录系统。', N'2021-03-23 09:28:56.743', N'127.0.0.1:53789', null)
GO
GO

-- ----------------------------
-- Indexes structure for table OperateLog
-- ----------------------------
CREATE INDEX [IX_OperateLog_OptDate] ON [dbo].[OperateLog]
([OptDate] ASC) 
WITH (FILLFACTOR = 30)
GO

-- ----------------------------
-- Primary Key structure for table OperateLog
-- ----------------------------
ALTER TABLE [dbo].[OperateLog] ADD PRIMARY KEY ([ID])
GO