/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1,1433
 Source Server Type    : SQL Server
 Source Server Version : 11007001
 Source Host           : 127.0.0.1:1433
 Source Catalog        : LXZN_TEST_430_NEW
 Source Schema         : dbo

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

 Date: 10/07/2025 14:54:07
*/


-- ----------------------------
-- Table structure for sys_params
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_params]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_params]
GO

CREATE TABLE [dbo].[sys_params] (
  [id] varchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [setting_key] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [setting_value] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_by] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(0)  NULL,
  [update_by] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime2(0)  NULL,
  [setting_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

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

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数键',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'setting_key'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数值',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'setting_value'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建日期',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新日期',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_params',
'COLUMN', N'setting_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统参数表',
'SCHEMA', N'dbo',
'TABLE', N'sys_params'
GO


-- ----------------------------
-- Records of sys_params
-- ----------------------------
INSERT INTO [dbo].[sys_params] ([id], [setting_key], [setting_value], [remark], [create_by], [create_time], [update_by], [update_time], [setting_name]) VALUES (N'1', N'maintenance_import_type', N'0', N'保养规范导入是否启动流程    0 否  1是', N'admin', N'2025-02-11 14:00:21', N'admin', N'2025-02-11 16:08:28', N'系统类型配置')
GO


-- ----------------------------
-- Primary Key structure for table sys_params
-- ----------------------------
ALTER TABLE [dbo].[sys_params] ADD CONSTRAINT [PK__sys_para__3213E83F7A8FD449] 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