1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
| /*
| 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
|
|
