/* Navicat Premium Data Transfer Source Server : sqlserver_172.16.4.12 Source Server Type : SQL Server Source Server Version : 13001601 Source Host : 172.16.4.12:1433 Source Catalog : FT562-WCS Source Schema : dbo Target Server Type : SQL Server Target Server Version : 13001601 File Encoding : 65001 Date: 20/04/2026 09:26:00 */ -- ---------------------------- -- Table structure for bas_cargo_space -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bas_cargo_space]') AND type IN ('U')) DROP TABLE [dbo].[bas_cargo_space] GO CREATE TABLE [dbo].[bas_cargo_space] ( [cargo_space_id] varchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [warehouse_id] varchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [roadway_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [cargo_area_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [the_type] varchar(5) COLLATE Chinese_PRC_CI_AS NULL, [the_type_name] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [cargo_space_name] varchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [the_platoon] int NOT NULL, [the_column] int NOT NULL, [the_floor] int NOT NULL, [status] varchar(5) COLLATE Chinese_PRC_CI_AS NOT NULL, [locked] varchar(5) COLLATE Chinese_PRC_CI_AS NOT NULL, [tray_code] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [cargo_hight] numeric(18) NULL, [iss_double] varchar(2) COLLATE Chinese_PRC_CI_AS NULL, [group_coding_no] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [group_coding] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [cargo_space_logo] varchar(2) COLLATE Chinese_PRC_CI_AS NULL, [this_cargo_area] varchar(10) COLLATE Chinese_PRC_CI_AS NULL, [wms_cargo_space_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[bas_cargo_space] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'货位id 主键 ', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'cargo_space_id' GO EXEC sp_addextendedproperty 'MS_Description', N'仓库id（不允许为空）', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'warehouse_id' GO EXEC sp_addextendedproperty 'MS_Description', N'巷道id（允许为空）562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'roadway_id' GO EXEC sp_addextendedproperty 'MS_Description', N'货区id（允许为空）', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'cargo_area_id' GO EXEC sp_addextendedproperty 'MS_Description', N'货位类型（允许为空）562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'the_type' GO EXEC sp_addextendedproperty 'MS_Description', N'货位类型名称 562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'the_type_name' GO EXEC sp_addextendedproperty 'MS_Description', N'货位名称（不允许为空）562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'cargo_space_name' GO EXEC sp_addextendedproperty 'MS_Description', N'排（不允许为空）562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'the_platoon' GO EXEC sp_addextendedproperty 'MS_Description', N'列（不允许为空）562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'the_column' GO EXEC sp_addextendedproperty 'MS_Description', N'层（不允许为空）562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'the_floor' GO EXEC sp_addextendedproperty 'MS_Description', N'562货位状态1空2满 3入库分配 4出库分配 5入库盘点 6出库盘点', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'是否锁定（不允许为空） Y锁、N开 562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'locked' GO EXEC sp_addextendedproperty 'MS_Description', N'托盘条码（允许为空）562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'tray_code' GO EXEC sp_addextendedproperty 'MS_Description', N'货位高度 562', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'cargo_hight' GO EXEC sp_addextendedproperty 'MS_Description', N'是否双伸 Y N ', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'iss_double' GO EXEC sp_addextendedproperty 'MS_Description', N'双货位分组编码（标识区分）', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'group_coding_no' GO EXEC sp_addextendedproperty 'MS_Description', N'双货位分组编码1、2… ', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'group_coding' GO EXEC sp_addextendedproperty 'MS_Description', N'双货位标识 0 外1内', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'cargo_space_logo' GO EXEC sp_addextendedproperty 'MS_Description', N'本仓库区域 1--8 A 9--15 B', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space', 'COLUMN', N'this_cargo_area' GO EXEC sp_addextendedproperty 'MS_Description', N'库存信息表', 'SCHEMA', N'dbo', 'TABLE', N'bas_cargo_space' GO -- ---------------------------- -- Table structure for bas_fault_record -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bas_fault_record]') AND type IN ('U')) DROP TABLE [dbo].[bas_fault_record] GO CREATE TABLE [dbo].[bas_fault_record] ( [id] varchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [device_id] varchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [device_name] varchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [device_type] varchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [task_no] varchar(10) COLLATE Chinese_PRC_CI_AS NULL, [job_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [fault] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [start_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [finish_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[bas_fault_record] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'id 主键', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'id' GO EXEC sp_addextendedproperty 'MS_Description', N'设备id（不允许为空）', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'device_id' GO EXEC sp_addextendedproperty 'MS_Description', N'设备名称（不允许为空）', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'device_name' GO EXEC sp_addextendedproperty 'MS_Description', N'设备类型（不允许为空）', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'device_type' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'task_no' GO EXEC sp_addextendedproperty 'MS_Description', N'作业id ', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'job_id' GO EXEC sp_addextendedproperty 'MS_Description', N'报警信息', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'fault' GO EXEC sp_addextendedproperty 'MS_Description', N'报警开始时间', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'start_time' GO EXEC sp_addextendedproperty 'MS_Description', N'报警结束时间', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record', 'COLUMN', N'finish_time' GO EXEC sp_addextendedproperty 'MS_Description', N'设备故障记录', 'SCHEMA', N'dbo', 'TABLE', N'bas_fault_record' GO -- ---------------------------- -- Table structure for ddj_device_execution_queue -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[ddj_device_execution_queue]') AND type IN ('U')) DROP TABLE [dbo].[ddj_device_execution_queue] GO CREATE TABLE [dbo].[ddj_device_execution_queue] ( [uuid] nvarchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [rwh] int NOT NULL, [dev_name] nvarchar(80) COLLATE Chinese_PRC_CI_AS NULL, [dev_id] int NOT NULL, [rwzt] int NULL, [yph] int NULL, [ylh] int NULL, [ych] int NULL, [mbph] int NULL, [mblh] int NULL, [mbch] int NULL, [ddjxf] nvarchar(80) COLLATE Chinese_PRC_CI_AS NULL, [rwlx] int NULL, [scsj] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [xfsj] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [jssj] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [mlfs] int NULL, [spare1] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare2] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare3] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare4] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare5] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare6] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[ddj_device_execution_queue] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'uuid', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'uuid' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'rwh' GO EXEC sp_addextendedproperty 'MS_Description', N'设备名称', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'dev_name' GO EXEC sp_addextendedproperty 'MS_Description', N'设备id', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'dev_id' GO EXEC sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'rwzt' GO EXEC sp_addextendedproperty 'MS_Description', N'原排', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'yph' GO EXEC sp_addextendedproperty 'MS_Description', N'原列', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'ylh' GO EXEC sp_addextendedproperty 'MS_Description', N'原层', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'ych' GO EXEC sp_addextendedproperty 'MS_Description', N'目标排', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'mbph' GO EXEC sp_addextendedproperty 'MS_Description', N'目标列', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'mblh' GO EXEC sp_addextendedproperty 'MS_Description', N'目标层', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'mbch' GO EXEC sp_addextendedproperty 'MS_Description', N'堆垛机下发', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'ddjxf' GO EXEC sp_addextendedproperty 'MS_Description', N'任务类型 1-入库取货 2-入库放货 3-出库', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'rwlx' GO EXEC sp_addextendedproperty 'MS_Description', N'生成时间', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'scsj' GO EXEC sp_addextendedproperty 'MS_Description', N'下发时间', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'xfsj' GO EXEC sp_addextendedproperty 'MS_Description', N'结束时间', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'jssj' GO EXEC sp_addextendedproperty 'MS_Description', N'命令方式', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'mlfs' GO EXEC sp_addextendedproperty 'MS_Description', N'是否正在执行 0否 1是', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'spare1' GO EXEC sp_addextendedproperty 'MS_Description', N'出库ssj', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'spare2' GO EXEC sp_addextendedproperty 'MS_Description', N'重量', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'spare3' GO EXEC sp_addextendedproperty 'MS_Description', N'托盘码', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue', 'COLUMN', N'spare4' GO EXEC sp_addextendedproperty 'MS_Description', N'堆垛机执行队列', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue' GO -- ---------------------------- -- Table structure for ddj_device_execution_queue_finish -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[ddj_device_execution_queue_finish]') AND type IN ('U')) DROP TABLE [dbo].[ddj_device_execution_queue_finish] GO CREATE TABLE [dbo].[ddj_device_execution_queue_finish] ( [uuid] nvarchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [rwh] int NOT NULL, [dev_name] nvarchar(80) COLLATE Chinese_PRC_CI_AS NOT NULL, [dev_id] int NULL, [rwzt] int NULL, [yph] int NULL, [ylh] int NULL, [ych] int NULL, [mbph] int NULL, [mblh] int NULL, [mbch] int NULL, [ddjxf] nvarchar(80) COLLATE Chinese_PRC_CI_AS NULL, [rwlx] int NULL, [scsj] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [xfsj] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [jssj] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [mlfs] int NULL, [spare1] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare2] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare3] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare4] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare5] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare6] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[ddj_device_execution_queue_finish] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'uuid', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'uuid' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'rwh' GO EXEC sp_addextendedproperty 'MS_Description', N'设备名称', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'dev_name' GO EXEC sp_addextendedproperty 'MS_Description', N'设备id', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'dev_id' GO EXEC sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'rwzt' GO EXEC sp_addextendedproperty 'MS_Description', N'原排', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'yph' GO EXEC sp_addextendedproperty 'MS_Description', N'原列', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'ylh' GO EXEC sp_addextendedproperty 'MS_Description', N'原层', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'ych' GO EXEC sp_addextendedproperty 'MS_Description', N'目标排', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'mbph' GO EXEC sp_addextendedproperty 'MS_Description', N'目标列', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'mblh' GO EXEC sp_addextendedproperty 'MS_Description', N'目标层', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'mbch' GO EXEC sp_addextendedproperty 'MS_Description', N'堆垛机下发', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'ddjxf' GO EXEC sp_addextendedproperty 'MS_Description', N'任务类型', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'rwlx' GO EXEC sp_addextendedproperty 'MS_Description', N'生成时间', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'scsj' GO EXEC sp_addextendedproperty 'MS_Description', N'下发时间', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'xfsj' GO EXEC sp_addextendedproperty 'MS_Description', N'结束时间', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'jssj' GO EXEC sp_addextendedproperty 'MS_Description', N'命令方式', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish', 'COLUMN', N'mlfs' GO EXEC sp_addextendedproperty 'MS_Description', N'堆垛机完成队列', 'SCHEMA', N'dbo', 'TABLE', N'ddj_device_execution_queue_finish' GO -- ---------------------------- -- Table structure for device_ssj -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[device_ssj]') AND type IN ('U')) DROP TABLE [dbo].[device_ssj] GO CREATE TABLE [dbo].[device_ssj] ( [id] bigint IDENTITY(1,1) NOT NULL, [device_code ] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [name ] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [type] varchar(1) COLLATE Chinese_PRC_CI_AS NULL, [ip_address] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [plc_db_read_address] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [is_active] varchar(1) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime NULL, [plc_db_write_address] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [rkqq] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [kx] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [dw] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [tray_code] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [task_no] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [exception] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [tray_size] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [allow_put] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [height] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [jxdw] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [sbzt] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare1] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[device_ssj] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'设备唯一编码', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'device_code ' GO EXEC sp_addextendedproperty 'MS_Description', N'设备名称', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'name ' GO EXEC sp_addextendedproperty 'MS_Description', N'类型', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'type' GO EXEC sp_addextendedproperty 'MS_Description', N'设备IP', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'ip_address' GO EXEC sp_addextendedproperty 'MS_Description', N'PLC读取地址', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'plc_db_read_address' GO EXEC sp_addextendedproperty 'MS_Description', N'0-F 1-T', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'is_active' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'PLC写入地址', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'plc_db_write_address' GO EXEC sp_addextendedproperty 'MS_Description', N'入库请求', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'rkqq' GO EXEC sp_addextendedproperty 'MS_Description', N'空闲', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'kx' GO EXEC sp_addextendedproperty 'MS_Description', N'到位', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'dw' GO EXEC sp_addextendedproperty 'MS_Description', N'条码', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'tray_code' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'task_no' GO EXEC sp_addextendedproperty 'MS_Description', N'异常', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'exception' GO EXEC sp_addextendedproperty 'MS_Description', N'托盘尺寸', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'tray_size' GO EXEC sp_addextendedproperty 'MS_Description', N'允许放货', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'allow_put' GO EXEC sp_addextendedproperty 'MS_Description', N'高度', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'height' GO EXEC sp_addextendedproperty 'MS_Description', N'拣选到位', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'jxdw' GO EXEC sp_addextendedproperty 'MS_Description', N'状态', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'sbzt' GO EXEC sp_addextendedproperty 'MS_Description', N'备用', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj', 'COLUMN', N'spare1' GO EXEC sp_addextendedproperty 'MS_Description', N'输送机设备表', 'SCHEMA', N'dbo', 'TABLE', N'device_ssj' GO -- ---------------------------- -- Table structure for gen_table -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[gen_table]') AND type IN ('U')) DROP TABLE [dbo].[gen_table] GO CREATE TABLE [dbo].[gen_table] ( [table_id] bigint IDENTITY(1,1) NOT NULL, [table_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [table_comment] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL, [sub_table_name] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [sub_table_fk_name] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [class_name] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [tpl_category] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT 'crud' NULL, [tpl_web_type] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [package_name] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [module_name] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [business_name] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [function_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [function_author] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [gen_type] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [gen_path] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '/' NULL, [options] nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[gen_table] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'编号', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'table_id' GO EXEC sp_addextendedproperty 'MS_Description', N'表名称', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'table_name' GO EXEC sp_addextendedproperty 'MS_Description', N'表描述', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'table_comment' GO EXEC sp_addextendedproperty 'MS_Description', N'关联子表的表名', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'sub_table_name' GO EXEC sp_addextendedproperty 'MS_Description', N'子表关联的外键名', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'sub_table_fk_name' GO EXEC sp_addextendedproperty 'MS_Description', N'实体类名称', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'class_name' GO EXEC sp_addextendedproperty 'MS_Description', N'使用的模板（crud单表操作 tree树表操作）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'tpl_category' GO EXEC sp_addextendedproperty 'MS_Description', N'前端模板类型（element-ui模版 element-plus模版）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'tpl_web_type' GO EXEC sp_addextendedproperty 'MS_Description', N'生成包路径', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'package_name' GO EXEC sp_addextendedproperty 'MS_Description', N'生成模块名', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'module_name' GO EXEC sp_addextendedproperty 'MS_Description', N'生成业务名', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'business_name' GO EXEC sp_addextendedproperty 'MS_Description', N'生成功能名', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'function_name' GO EXEC sp_addextendedproperty 'MS_Description', N'生成功能作者', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'function_author' GO EXEC sp_addextendedproperty 'MS_Description', N'生成代码方式（0zip压缩包 1自定义路径）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'gen_type' GO EXEC sp_addextendedproperty 'MS_Description', N'生成路径（不填默认项目路径）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'gen_path' GO EXEC sp_addextendedproperty 'MS_Description', N'其它生成选项', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'options' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'gen_table', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'代码生成业务表', 'SCHEMA', N'dbo', 'TABLE', N'gen_table' GO -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[gen_table_column]') AND type IN ('U')) DROP TABLE [dbo].[gen_table_column] GO CREATE TABLE [dbo].[gen_table_column] ( [column_id] bigint IDENTITY(1,1) NOT NULL, [table_id] bigint NULL, [column_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [column_comment] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL, [column_type] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [java_type] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL, [java_field] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [is_pk] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [is_increment] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [is_required] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [is_insert] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [is_edit] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [is_list] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [is_query] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [query_type] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT 'EQ' NULL, [html_type] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [dict_type] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL, [sort] int NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL ) GO ALTER TABLE [dbo].[gen_table_column] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'编号', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'column_id' GO EXEC sp_addextendedproperty 'MS_Description', N'归属表编号', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'table_id' GO EXEC sp_addextendedproperty 'MS_Description', N'列名称', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'column_name' GO EXEC sp_addextendedproperty 'MS_Description', N'列描述', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'column_comment' GO EXEC sp_addextendedproperty 'MS_Description', N'列类型', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'column_type' GO EXEC sp_addextendedproperty 'MS_Description', N'JAVA类型', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'java_type' GO EXEC sp_addextendedproperty 'MS_Description', N'JAVA字段名', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'java_field' GO EXEC sp_addextendedproperty 'MS_Description', N'是否主键（1是）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'is_pk' GO EXEC sp_addextendedproperty 'MS_Description', N'是否自增（1是）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'is_increment' GO EXEC sp_addextendedproperty 'MS_Description', N'是否必填（1是）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'is_required' GO EXEC sp_addextendedproperty 'MS_Description', N'是否为插入字段（1是）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'is_insert' GO EXEC sp_addextendedproperty 'MS_Description', N'是否编辑字段（1是）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'is_edit' GO EXEC sp_addextendedproperty 'MS_Description', N'是否列表字段（1是）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'is_list' GO EXEC sp_addextendedproperty 'MS_Description', N'是否查询字段（1是）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'is_query' GO EXEC sp_addextendedproperty 'MS_Description', N'查询方式（等于、不等于、大于、小于、范围）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'query_type' GO EXEC sp_addextendedproperty 'MS_Description', N'显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'html_type' GO EXEC sp_addextendedproperty 'MS_Description', N'字典类型', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'dict_type' GO EXEC sp_addextendedproperty 'MS_Description', N'排序', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'sort' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'代码生成业务表字段', 'SCHEMA', N'dbo', 'TABLE', N'gen_table_column' GO -- ---------------------------- -- Table structure for job_call_back -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[job_call_back]') AND type IN ('U')) DROP TABLE [dbo].[job_call_back] GO CREATE TABLE [dbo].[job_call_back] ( [id] bigint IDENTITY(1,1) NOT NULL, [type] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [task_no] int NULL, [mydojob_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [status] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [create_time] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare1] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare2] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare3] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[job_call_back] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'类型 1-入库 2-出库 3-清空货位', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'type' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'task_no' GO EXEC sp_addextendedproperty 'MS_Description', N'mydojob作业号', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'mydojob_id' GO EXEC sp_addextendedproperty 'MS_Description', N'状态 0-创建 1-成功 2-失败', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备用字段1', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'spare1' GO EXEC sp_addextendedproperty 'MS_Description', N'备用字段2', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'spare2' GO EXEC sp_addextendedproperty 'MS_Description', N'备用字段3', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back', 'COLUMN', N'spare3' GO EXEC sp_addextendedproperty 'MS_Description', N'任务完成回传表', 'SCHEMA', N'dbo', 'TABLE', N'job_call_back' GO -- ---------------------------- -- Table structure for msg_ddj -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[msg_ddj]') AND type IN ('U')) DROP TABLE [dbo].[msg_ddj] GO CREATE TABLE [dbo].[msg_ddj] ( [id] int NOT NULL, [name] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [rwh] int NULL, [jdbz] int NULL, [sbzt] int NULL, [czfs] int NULL, [yxxf] int NULL, [yph] int NULL, [ylh] int NULL, [ych] int NULL, [mbph] int NULL, [mblh] int NULL, [mbch] int NULL, [xtxh] int NULL, [dqxd] int NULL, [hczt] int NULL, [spare1] int NULL, [spare2] int NULL, [spare3] int NULL, [ip] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [port] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [plc_db_read_address] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [plc_db_write_address] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[msg_ddj] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'id', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'id' GO EXEC sp_addextendedproperty 'MS_Description', N'堆垛机名称', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'name' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'rwh' GO EXEC sp_addextendedproperty 'MS_Description', N'阶段标志', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'jdbz' GO EXEC sp_addextendedproperty 'MS_Description', N'状态', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'sbzt' GO EXEC sp_addextendedproperty 'MS_Description', N'操作方式', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'czfs' GO EXEC sp_addextendedproperty 'MS_Description', N'允许下发', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'yxxf' GO EXEC sp_addextendedproperty 'MS_Description', N'原排', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'yph' GO EXEC sp_addextendedproperty 'MS_Description', N'原列', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'ylh' GO EXEC sp_addextendedproperty 'MS_Description', N'原层', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'ych' GO EXEC sp_addextendedproperty 'MS_Description', N'目标排', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'mbph' GO EXEC sp_addextendedproperty 'MS_Description', N'目标列', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'mblh' GO EXEC sp_addextendedproperty 'MS_Description', N'目标层', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'mbch' GO EXEC sp_addextendedproperty 'MS_Description', N'心跳信号', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'xtxh' GO EXEC sp_addextendedproperty 'MS_Description', N'当前巷道', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'dqxd' GO EXEC sp_addextendedproperty 'MS_Description', N'货叉状态', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'hczt' GO EXEC sp_addextendedproperty 'MS_Description', N'设备锁 1锁定 0解锁', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'spare1' GO EXEC sp_addextendedproperty 'MS_Description', N'备用字段2', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'spare2' GO EXEC sp_addextendedproperty 'MS_Description', N'备用字段3', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj', 'COLUMN', N'spare3' GO EXEC sp_addextendedproperty 'MS_Description', N'堆垛机监控表', 'SCHEMA', N'dbo', 'TABLE', N'msg_ddj' GO -- ---------------------------- -- Table structure for mydo_job_wcs -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[mydo_job_wcs]') AND type IN ('U')) DROP TABLE [dbo].[mydo_job_wcs] GO CREATE TABLE [dbo].[mydo_job_wcs] ( [job_id] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [status] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [task_no] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [roadway_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [cargo_space_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [target_roadway_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [target_cargo_space_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [priority] int NULL, [execution_phase] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [in_or_out] int NULL, [create_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [start_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [finish_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [entrance_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [exit_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [warehouse_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [fault_flag] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [tray_code] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [line_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[mydo_job_wcs] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'任务ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'job_id' GO EXEC sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'task_no' GO EXEC sp_addextendedproperty 'MS_Description', N'巷道ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'roadway_id' GO EXEC sp_addextendedproperty 'MS_Description', N'货位ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'cargo_space_id' GO EXEC sp_addextendedproperty 'MS_Description', N'高度', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'target_roadway_id' GO EXEC sp_addextendedproperty 'MS_Description', N'重量', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'target_cargo_space_id' GO EXEC sp_addextendedproperty 'MS_Description', N'优先级', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'priority' GO EXEC sp_addextendedproperty 'MS_Description', N'执行阶段', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'execution_phase' GO EXEC sp_addextendedproperty 'MS_Description', N'任务类型', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'in_or_out' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'开始时间', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'start_time' GO EXEC sp_addextendedproperty 'MS_Description', N'结束时间', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'finish_time' GO EXEC sp_addextendedproperty 'MS_Description', N'入口ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'entrance_id' GO EXEC sp_addextendedproperty 'MS_Description', N'出口ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'exit_id' GO EXEC sp_addextendedproperty 'MS_Description', N'仓库ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'warehouse_id' GO EXEC sp_addextendedproperty 'MS_Description', N'重分标志', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'fault_flag' GO EXEC sp_addextendedproperty 'MS_Description', N'托盘码', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'tray_code' GO EXEC sp_addextendedproperty 'MS_Description', N'拣选方式 1-线上 2-线下', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs', 'COLUMN', N'line_id' GO EXEC sp_addextendedproperty 'MS_Description', N'作业信息表', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs' GO -- ---------------------------- -- Table structure for mydo_job_wcs_finish -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[mydo_job_wcs_finish]') AND type IN ('U')) DROP TABLE [dbo].[mydo_job_wcs_finish] GO CREATE TABLE [dbo].[mydo_job_wcs_finish] ( [job_id] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [status] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [task_no] varchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL, [roadway_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [cargo_space_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [target_roadway_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [target_cargo_space_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [priority] int NULL, [execution_phase] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [in_or_out] int NULL, [create_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [start_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [finish_time] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [entrance_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [exit_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [warehouse_id] varchar(80) COLLATE Chinese_PRC_CI_AS NULL, [fault_flag] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [tray_code] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [line_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[mydo_job_wcs_finish] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'任务ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'job_id' GO EXEC sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'任务号', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'task_no' GO EXEC sp_addextendedproperty 'MS_Description', N'巷道ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'roadway_id' GO EXEC sp_addextendedproperty 'MS_Description', N'货位ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'cargo_space_id' GO EXEC sp_addextendedproperty 'MS_Description', N'目标巷道ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'target_roadway_id' GO EXEC sp_addextendedproperty 'MS_Description', N'目标货位ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'target_cargo_space_id' GO EXEC sp_addextendedproperty 'MS_Description', N'优先级', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'priority' GO EXEC sp_addextendedproperty 'MS_Description', N'执行阶段', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'execution_phase' GO EXEC sp_addextendedproperty 'MS_Description', N'任务类型', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'in_or_out' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'开始时间', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'start_time' GO EXEC sp_addextendedproperty 'MS_Description', N'结束时间', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'finish_time' GO EXEC sp_addextendedproperty 'MS_Description', N'入口ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'entrance_id' GO EXEC sp_addextendedproperty 'MS_Description', N'出口ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'exit_id' GO EXEC sp_addextendedproperty 'MS_Description', N'仓库ID', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'warehouse_id' GO EXEC sp_addextendedproperty 'MS_Description', N'重分标志', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'fault_flag' GO EXEC sp_addextendedproperty 'MS_Description', N'拣选方式', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish', 'COLUMN', N'line_id' GO EXEC sp_addextendedproperty 'MS_Description', N'作业信息表', 'SCHEMA', N'dbo', 'TABLE', N'mydo_job_wcs_finish' GO -- ---------------------------- -- Table structure for qrtz_blob_triggers -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_blob_triggers]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_blob_triggers] GO CREATE TABLE [dbo].[qrtz_blob_triggers] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [blob_data] varbinary(max) NULL ) GO ALTER TABLE [dbo].[qrtz_blob_triggers] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_blob_triggers', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_name的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_blob_triggers', 'COLUMN', N'trigger_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_group的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_blob_triggers', 'COLUMN', N'trigger_group' GO EXEC sp_addextendedproperty 'MS_Description', N'存放持久化Trigger对象', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_blob_triggers', 'COLUMN', N'blob_data' GO EXEC sp_addextendedproperty 'MS_Description', N'Blob类型的触发器表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_blob_triggers' GO -- ---------------------------- -- Table structure for qrtz_calendars -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_calendars]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_calendars] GO CREATE TABLE [dbo].[qrtz_calendars] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [calendar_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [calendar] varbinary(max) NOT NULL ) GO ALTER TABLE [dbo].[qrtz_calendars] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_calendars', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'日历名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_calendars', 'COLUMN', N'calendar_name' GO EXEC sp_addextendedproperty 'MS_Description', N'存放持久化calendar对象', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_calendars', 'COLUMN', N'calendar' GO EXEC sp_addextendedproperty 'MS_Description', N'日历信息表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_calendars' GO -- ---------------------------- -- Table structure for qrtz_cron_triggers -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_cron_triggers]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_cron_triggers] GO CREATE TABLE [dbo].[qrtz_cron_triggers] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [cron_expression] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [time_zone_id] nvarchar(80) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[qrtz_cron_triggers] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_cron_triggers', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_name的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_cron_triggers', 'COLUMN', N'trigger_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_group的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_cron_triggers', 'COLUMN', N'trigger_group' GO EXEC sp_addextendedproperty 'MS_Description', N'cron表达式', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_cron_triggers', 'COLUMN', N'cron_expression' GO EXEC sp_addextendedproperty 'MS_Description', N'时区', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_cron_triggers', 'COLUMN', N'time_zone_id' GO EXEC sp_addextendedproperty 'MS_Description', N'Cron类型的触发器表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_cron_triggers' GO -- ---------------------------- -- Table structure for qrtz_fired_triggers -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_fired_triggers]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_fired_triggers] GO CREATE TABLE [dbo].[qrtz_fired_triggers] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [entry_id] nvarchar(95) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [instance_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [fired_time] bigint NOT NULL, [sched_time] bigint NOT NULL, [priority] int NOT NULL, [state] nvarchar(16) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [job_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [is_nonconcurrent] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL, [requests_recovery] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[qrtz_fired_triggers] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'调度器实例id', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'entry_id' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_name的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'trigger_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_group的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'trigger_group' GO EXEC sp_addextendedproperty 'MS_Description', N'调度器实例名', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'instance_name' GO EXEC sp_addextendedproperty 'MS_Description', N'触发的时间', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'fired_time' GO EXEC sp_addextendedproperty 'MS_Description', N'定时器制定的时间', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'sched_time' GO EXEC sp_addextendedproperty 'MS_Description', N'优先级', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'priority' GO EXEC sp_addextendedproperty 'MS_Description', N'状态', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'state' GO EXEC sp_addextendedproperty 'MS_Description', N'任务名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'job_name' GO EXEC sp_addextendedproperty 'MS_Description', N'任务组名', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'job_group' GO EXEC sp_addextendedproperty 'MS_Description', N'是否并发', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'is_nonconcurrent' GO EXEC sp_addextendedproperty 'MS_Description', N'是否接受恢复执行', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers', 'COLUMN', N'requests_recovery' GO EXEC sp_addextendedproperty 'MS_Description', N'已触发的触发器表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_fired_triggers' GO -- ---------------------------- -- Table structure for qrtz_job_details -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_job_details]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_job_details] GO CREATE TABLE [dbo].[qrtz_job_details] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [description] nvarchar(250) COLLATE Chinese_PRC_CI_AS NULL, [job_class_name] nvarchar(250) COLLATE Chinese_PRC_CI_AS NOT NULL, [is_durable] nvarchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL, [is_nonconcurrent] nvarchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL, [is_update_data] nvarchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL, [requests_recovery] nvarchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_data] varbinary(max) NULL ) GO ALTER TABLE [dbo].[qrtz_job_details] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'任务名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'job_name' GO EXEC sp_addextendedproperty 'MS_Description', N'任务组名', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'job_group' GO EXEC sp_addextendedproperty 'MS_Description', N'相关介绍', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'description' GO EXEC sp_addextendedproperty 'MS_Description', N'执行任务类名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'job_class_name' GO EXEC sp_addextendedproperty 'MS_Description', N'是否持久化', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'is_durable' GO EXEC sp_addextendedproperty 'MS_Description', N'是否并发', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'is_nonconcurrent' GO EXEC sp_addextendedproperty 'MS_Description', N'是否更新数据', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'is_update_data' GO EXEC sp_addextendedproperty 'MS_Description', N'是否接受恢复执行', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'requests_recovery' GO EXEC sp_addextendedproperty 'MS_Description', N'存放持久化job对象', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details', 'COLUMN', N'job_data' GO EXEC sp_addextendedproperty 'MS_Description', N'任务详细信息表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_job_details' GO -- ---------------------------- -- Table structure for qrtz_locks -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_locks]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_locks] GO CREATE TABLE [dbo].[qrtz_locks] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [lock_name] nvarchar(40) COLLATE Chinese_PRC_CI_AS NOT NULL ) GO ALTER TABLE [dbo].[qrtz_locks] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_locks', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'悲观锁名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_locks', 'COLUMN', N'lock_name' GO EXEC sp_addextendedproperty 'MS_Description', N'存储的悲观锁信息表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_locks' GO -- ---------------------------- -- Table structure for qrtz_paused_trigger_grps -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_paused_trigger_grps]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_paused_trigger_grps] GO CREATE TABLE [dbo].[qrtz_paused_trigger_grps] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL ) GO ALTER TABLE [dbo].[qrtz_paused_trigger_grps] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_paused_trigger_grps', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_group的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_paused_trigger_grps', 'COLUMN', N'trigger_group' GO EXEC sp_addextendedproperty 'MS_Description', N'暂停的触发器表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_paused_trigger_grps' GO -- ---------------------------- -- Table structure for qrtz_scheduler_state -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_scheduler_state]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_scheduler_state] GO CREATE TABLE [dbo].[qrtz_scheduler_state] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [instance_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [last_checkin_time] bigint NOT NULL, [checkin_interval] bigint NOT NULL ) GO ALTER TABLE [dbo].[qrtz_scheduler_state] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_scheduler_state', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'实例名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_scheduler_state', 'COLUMN', N'instance_name' GO EXEC sp_addextendedproperty 'MS_Description', N'上次检查时间', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_scheduler_state', 'COLUMN', N'last_checkin_time' GO EXEC sp_addextendedproperty 'MS_Description', N'检查间隔时间', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_scheduler_state', 'COLUMN', N'checkin_interval' GO EXEC sp_addextendedproperty 'MS_Description', N'调度器状态表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_scheduler_state' GO -- ---------------------------- -- Table structure for qrtz_simple_triggers -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_simple_triggers]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_simple_triggers] GO CREATE TABLE [dbo].[qrtz_simple_triggers] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [repeat_count] bigint NOT NULL, [repeat_interval] bigint NOT NULL, [times_triggered] bigint NOT NULL ) GO ALTER TABLE [dbo].[qrtz_simple_triggers] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simple_triggers', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_name的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simple_triggers', 'COLUMN', N'trigger_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_group的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simple_triggers', 'COLUMN', N'trigger_group' GO EXEC sp_addextendedproperty 'MS_Description', N'重复的次数统计', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simple_triggers', 'COLUMN', N'repeat_count' GO EXEC sp_addextendedproperty 'MS_Description', N'重复的间隔时间', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simple_triggers', 'COLUMN', N'repeat_interval' GO EXEC sp_addextendedproperty 'MS_Description', N'已经触发的次数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simple_triggers', 'COLUMN', N'times_triggered' GO EXEC sp_addextendedproperty 'MS_Description', N'简单触发器的信息表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simple_triggers' GO -- ---------------------------- -- Table structure for qrtz_simprop_triggers -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_simprop_triggers]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_simprop_triggers] GO CREATE TABLE [dbo].[qrtz_simprop_triggers] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [str_prop_1] nvarchar(512) COLLATE Chinese_PRC_CI_AS NULL, [str_prop_2] nvarchar(512) COLLATE Chinese_PRC_CI_AS NULL, [str_prop_3] nvarchar(512) COLLATE Chinese_PRC_CI_AS NULL, [int_prop_1] int NULL, [int_prop_2] int NULL, [long_prop_1] bigint NULL, [long_prop_2] bigint NULL, [dec_prop_1] decimal(13,4) NULL, [dec_prop_2] decimal(13,4) NULL, [bool_prop_1] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL, [bool_prop_2] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[qrtz_simprop_triggers] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_name的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'trigger_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_triggers表trigger_group的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'trigger_group' GO EXEC sp_addextendedproperty 'MS_Description', N'String类型的trigger的第一个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'str_prop_1' GO EXEC sp_addextendedproperty 'MS_Description', N'String类型的trigger的第二个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'str_prop_2' GO EXEC sp_addextendedproperty 'MS_Description', N'String类型的trigger的第三个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'str_prop_3' GO EXEC sp_addextendedproperty 'MS_Description', N'int类型的trigger的第一个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'int_prop_1' GO EXEC sp_addextendedproperty 'MS_Description', N'int类型的trigger的第二个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'int_prop_2' GO EXEC sp_addextendedproperty 'MS_Description', N'long类型的trigger的第一个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'long_prop_1' GO EXEC sp_addextendedproperty 'MS_Description', N'long类型的trigger的第二个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'long_prop_2' GO EXEC sp_addextendedproperty 'MS_Description', N'decimal类型的trigger的第一个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'dec_prop_1' GO EXEC sp_addextendedproperty 'MS_Description', N'decimal类型的trigger的第二个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'dec_prop_2' GO EXEC sp_addextendedproperty 'MS_Description', N'Boolean类型的trigger的第一个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'bool_prop_1' GO EXEC sp_addextendedproperty 'MS_Description', N'Boolean类型的trigger的第二个参数', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers', 'COLUMN', N'bool_prop_2' GO EXEC sp_addextendedproperty 'MS_Description', N'同步机制的行锁表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_simprop_triggers' GO -- ---------------------------- -- Table structure for qrtz_triggers -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_triggers]') AND type IN ('U')) DROP TABLE [dbo].[qrtz_triggers] GO CREATE TABLE [dbo].[qrtz_triggers] ( [sched_name] nvarchar(120) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_group] nvarchar(200) COLLATE Chinese_PRC_CI_AS NOT NULL, [description] nvarchar(250) COLLATE Chinese_PRC_CI_AS NULL, [next_fire_time] bigint NULL, [prev_fire_time] bigint NULL, [priority] int NULL, [trigger_state] nvarchar(16) COLLATE Chinese_PRC_CI_AS NOT NULL, [trigger_type] nvarchar(8) COLLATE Chinese_PRC_CI_AS NOT NULL, [start_time] bigint NOT NULL, [end_time] bigint NULL, [calendar_name] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [misfire_instr] smallint NULL, [job_data] varbinary(max) NULL ) GO ALTER TABLE [dbo].[qrtz_triggers] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'调度名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'sched_name' GO EXEC sp_addextendedproperty 'MS_Description', N'触发器的名字', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'trigger_name' GO EXEC sp_addextendedproperty 'MS_Description', N'触发器所属组的名字', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'trigger_group' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_job_details表job_name的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'job_name' GO EXEC sp_addextendedproperty 'MS_Description', N'qrtz_job_details表job_group的外键', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'job_group' GO EXEC sp_addextendedproperty 'MS_Description', N'相关介绍', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'description' GO EXEC sp_addextendedproperty 'MS_Description', N'上一次触发时间（毫秒）', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'next_fire_time' GO EXEC sp_addextendedproperty 'MS_Description', N'下一次触发时间（默认为-1表示不触发）', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'prev_fire_time' GO EXEC sp_addextendedproperty 'MS_Description', N'优先级', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'priority' GO EXEC sp_addextendedproperty 'MS_Description', N'触发器状态', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'trigger_state' GO EXEC sp_addextendedproperty 'MS_Description', N'触发器的类型', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'trigger_type' GO EXEC sp_addextendedproperty 'MS_Description', N'开始时间', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'start_time' GO EXEC sp_addextendedproperty 'MS_Description', N'结束时间', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'end_time' GO EXEC sp_addextendedproperty 'MS_Description', N'日程表名称', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'calendar_name' GO EXEC sp_addextendedproperty 'MS_Description', N'补偿执行的策略', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'misfire_instr' GO EXEC sp_addextendedproperty 'MS_Description', N'存放持久化job对象', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers', 'COLUMN', N'job_data' GO EXEC sp_addextendedproperty 'MS_Description', N'触发器详细信息表', 'SCHEMA', N'dbo', 'TABLE', N'qrtz_triggers' GO -- ---------------------------- -- Table structure for request_log -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[request_log]') AND type IN ('U')) DROP TABLE [dbo].[request_log] GO CREATE TABLE [dbo].[request_log] ( [request_id] bigint IDENTITY(1,1) NOT NULL, [request_time] datetime2(7) NULL, [source_system] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [target_system] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [endpoint] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [request_url] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [request_method] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [request_headers] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [request_body] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL, [response_time] datetime2(7) NULL, [response_body] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL, [response_status] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [error_details] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL, [duration] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [Is_successful] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[request_log] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'请求id', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'request_id' GO EXEC sp_addextendedproperty 'MS_Description', N'请求时间', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'request_time' GO EXEC sp_addextendedproperty 'MS_Description', N'来源系统', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'source_system' GO EXEC sp_addextendedproperty 'MS_Description', N'目标系统', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'target_system' GO EXEC sp_addextendedproperty 'MS_Description', N'url路径', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'endpoint' GO EXEC sp_addextendedproperty 'MS_Description', N'请求方式', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'request_method' GO EXEC sp_addextendedproperty 'MS_Description', N'请求头信息', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'request_headers' GO EXEC sp_addextendedproperty 'MS_Description', N'请求参数', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'request_body' GO EXEC sp_addextendedproperty 'MS_Description', N'响应时间', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'response_time' GO EXEC sp_addextendedproperty 'MS_Description', N'响应主体', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'response_body' GO EXEC sp_addextendedproperty 'MS_Description', N'响应状态', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'response_status' GO EXEC sp_addextendedproperty 'MS_Description', N'错误信息', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'error_details' GO EXEC sp_addextendedproperty 'MS_Description', N'耗时', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'duration' GO EXEC sp_addextendedproperty 'MS_Description', N'是否成功', 'SCHEMA', N'dbo', 'TABLE', N'request_log', 'COLUMN', N'Is_successful' GO EXEC sp_addextendedproperty 'MS_Description', N'接口记录', 'SCHEMA', N'dbo', 'TABLE', N'request_log' GO -- ---------------------------- -- Table structure for sys_config -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_config]') AND type IN ('U')) DROP TABLE [dbo].[sys_config] GO CREATE TABLE [dbo].[sys_config] ( [config_id] int IDENTITY(1,1) NOT NULL, [config_name] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [config_key] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [config_value] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL, [config_type] nchar(1) COLLATE Chinese_PRC_CI_AS NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT 'N' NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_config] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'参数主键', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'config_id' GO EXEC sp_addextendedproperty 'MS_Description', N'参数名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'config_name' GO EXEC sp_addextendedproperty 'MS_Description', N'参数键名', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'config_key' GO EXEC sp_addextendedproperty 'MS_Description', N'参数键值', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'config_value' GO EXEC sp_addextendedproperty 'MS_Description', N'系统内置（Y是 N否）', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'config_type' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_config', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'参数配置表', 'SCHEMA', N'dbo', 'TABLE', N'sys_config' GO -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dept]') AND type IN ('U')) DROP TABLE [dbo].[sys_dept] GO CREATE TABLE [dbo].[sys_dept] ( [dept_id] bigint IDENTITY(1,1) NOT NULL, [parent_id] bigint DEFAULT 0 NULL, [ancestors] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [dept_name] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [order_num] int DEFAULT 0 NULL, [leader] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [phone] nvarchar(11) COLLATE Chinese_PRC_CI_AS NULL, [email] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [del_flag] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL ) GO ALTER TABLE [dbo].[sys_dept] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'部门id', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'dept_id' GO EXEC sp_addextendedproperty 'MS_Description', N'父部门id', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'parent_id' GO EXEC sp_addextendedproperty 'MS_Description', N'祖级列表', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'ancestors' GO EXEC sp_addextendedproperty 'MS_Description', N'部门名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'dept_name' GO EXEC sp_addextendedproperty 'MS_Description', N'显示顺序', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'order_num' GO EXEC sp_addextendedproperty 'MS_Description', N'负责人', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'leader' GO EXEC sp_addextendedproperty 'MS_Description', N'联系电话', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'phone' GO EXEC sp_addextendedproperty 'MS_Description', N'邮箱', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'email' GO EXEC sp_addextendedproperty 'MS_Description', N'部门状态（0正常 1停用）', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'删除标志（0代表存在 2代表删除）', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'del_flag' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'部门表', 'SCHEMA', N'dbo', 'TABLE', N'sys_dept' GO -- ---------------------------- -- Table structure for sys_dict_data -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict_data]') AND type IN ('U')) DROP TABLE [dbo].[sys_dict_data] GO CREATE TABLE [dbo].[sys_dict_data] ( [dict_code] bigint IDENTITY(1,1) NOT NULL, [dict_sort] int NULL, [dict_label] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [dict_value] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [dict_type] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [css_class] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [list_class] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [is_default] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 'N' NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_dict_data] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'字典编码', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'dict_code' GO EXEC sp_addextendedproperty 'MS_Description', N'字典排序', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'dict_sort' GO EXEC sp_addextendedproperty 'MS_Description', N'字典标签', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'dict_label' GO EXEC sp_addextendedproperty 'MS_Description', N'字典键值', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'dict_value' GO EXEC sp_addextendedproperty 'MS_Description', N'字典类型', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'dict_type' GO EXEC sp_addextendedproperty 'MS_Description', N'样式属性（其他样式扩展）', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'css_class' GO EXEC sp_addextendedproperty 'MS_Description', N'表格回显样式', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'list_class' GO EXEC sp_addextendedproperty 'MS_Description', N'是否默认（Y是 N否）', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'is_default' GO EXEC sp_addextendedproperty 'MS_Description', N'状态（0正常 1停用）', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'字典数据表', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_data' GO -- ---------------------------- -- Table structure for sys_dict_type -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict_type]') AND type IN ('U')) DROP TABLE [dbo].[sys_dict_type] GO CREATE TABLE [dbo].[sys_dict_type] ( [dict_id] bigint IDENTITY(1,1) NOT NULL, [dict_name] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [dict_type] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_dict_type] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'字典主键', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'dict_id' GO EXEC sp_addextendedproperty 'MS_Description', N'字典名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'dict_name' GO EXEC sp_addextendedproperty 'MS_Description', N'字典类型', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'dict_type' GO EXEC sp_addextendedproperty 'MS_Description', N'状态（0正常 1停用）', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'字典类型表', 'SCHEMA', N'dbo', 'TABLE', N'sys_dict_type' GO -- ---------------------------- -- Table structure for sys_job -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_job]') AND type IN ('U')) DROP TABLE [dbo].[sys_job] GO CREATE TABLE [dbo].[sys_job] ( [job_id] bigint IDENTITY(1,1) NOT NULL, [job_name] nvarchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_group] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT 'DEFAULT' NOT NULL, [invoke_target] nvarchar(500) COLLATE Chinese_PRC_CI_AS NOT NULL, [cron_expression] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [misfire_policy] nvarchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT 3 NULL, [concurrent] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 1 NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_job] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'任务ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'job_id' GO EXEC sp_addextendedproperty 'MS_Description', N'任务名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'job_name' GO EXEC sp_addextendedproperty 'MS_Description', N'任务组名', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'job_group' GO EXEC sp_addextendedproperty 'MS_Description', N'调用目标字符串', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'invoke_target' GO EXEC sp_addextendedproperty 'MS_Description', N'cron执行表达式', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'cron_expression' GO EXEC sp_addextendedproperty 'MS_Description', N'计划执行错误策略（1立即执行 2执行一次 3放弃执行）', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'misfire_policy' GO EXEC sp_addextendedproperty 'MS_Description', N'是否并发执行（0允许 1禁止）', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'concurrent' GO EXEC sp_addextendedproperty 'MS_Description', N'状态（0正常 1暂停）', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注信息', 'SCHEMA', N'dbo', 'TABLE', N'sys_job', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'定时任务调度表', 'SCHEMA', N'dbo', 'TABLE', N'sys_job' GO -- ---------------------------- -- Table structure for sys_job_log -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_job_log]') AND type IN ('U')) DROP TABLE [dbo].[sys_job_log] GO CREATE TABLE [dbo].[sys_job_log] ( [job_log_id] bigint IDENTITY(1,1) NOT NULL, [job_name] nvarchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_group] nvarchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL, [invoke_target] nvarchar(500) COLLATE Chinese_PRC_CI_AS NOT NULL, [job_message] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [exception_info] nvarchar(2000) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL ) GO ALTER TABLE [dbo].[sys_job_log] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'任务日志ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'job_log_id' GO EXEC sp_addextendedproperty 'MS_Description', N'任务名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'job_name' GO EXEC sp_addextendedproperty 'MS_Description', N'任务组名', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'job_group' GO EXEC sp_addextendedproperty 'MS_Description', N'调用目标字符串', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'invoke_target' GO EXEC sp_addextendedproperty 'MS_Description', N'日志信息', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'job_message' GO EXEC sp_addextendedproperty 'MS_Description', N'执行状态（0正常 1失败）', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'异常信息', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'exception_info' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'定时任务调度日志表', 'SCHEMA', N'dbo', 'TABLE', N'sys_job_log' GO -- ---------------------------- -- Table structure for sys_logininfor -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_logininfor]') AND type IN ('U')) DROP TABLE [dbo].[sys_logininfor] GO CREATE TABLE [dbo].[sys_logininfor] ( [info_id] bigint IDENTITY(1,1) NOT NULL, [user_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [ipaddr] nvarchar(128) COLLATE Chinese_PRC_CI_AS NULL, [login_location] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [browser] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [os] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [msg] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [login_time] datetime2(7) NULL ) GO ALTER TABLE [dbo].[sys_logininfor] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'访问ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'info_id' GO EXEC sp_addextendedproperty 'MS_Description', N'用户账号', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'user_name' GO EXEC sp_addextendedproperty 'MS_Description', N'登录IP地址', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'ipaddr' GO EXEC sp_addextendedproperty 'MS_Description', N'登录地点', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'login_location' GO EXEC sp_addextendedproperty 'MS_Description', N'浏览器类型', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'browser' GO EXEC sp_addextendedproperty 'MS_Description', N'操作系统', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'os' GO EXEC sp_addextendedproperty 'MS_Description', N'登录状态（0成功 1失败）', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'提示消息', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'msg' GO EXEC sp_addextendedproperty 'MS_Description', N'访问时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor', 'COLUMN', N'login_time' GO EXEC sp_addextendedproperty 'MS_Description', N'系统访问记录', 'SCHEMA', N'dbo', 'TABLE', N'sys_logininfor' GO -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_menu]') AND type IN ('U')) DROP TABLE [dbo].[sys_menu] GO CREATE TABLE [dbo].[sys_menu] ( [menu_id] bigint IDENTITY(1,1) NOT NULL, [menu_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL, [parent_id] bigint DEFAULT 0 NULL, [order_num] int DEFAULT 0 NULL, [path] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL, [component] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [query] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [route_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL, [is_frame] int DEFAULT 1 NULL, [is_cache] int DEFAULT 0 NULL, [menu_type] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL, [visible] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [perms] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [icon] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '#' NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL ) GO ALTER TABLE [dbo].[sys_menu] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'菜单ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'menu_id' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'menu_name' GO EXEC sp_addextendedproperty 'MS_Description', N'父菜单ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'parent_id' GO EXEC sp_addextendedproperty 'MS_Description', N'显示顺序', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'order_num' GO EXEC sp_addextendedproperty 'MS_Description', N'路由地址', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'path' GO EXEC sp_addextendedproperty 'MS_Description', N'组件路径', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'component' GO EXEC sp_addextendedproperty 'MS_Description', N'路由参数', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'query' GO EXEC sp_addextendedproperty 'MS_Description', N'路由名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'route_name' GO EXEC sp_addextendedproperty 'MS_Description', N'是否为外链（0是 1否）', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'is_frame' GO EXEC sp_addextendedproperty 'MS_Description', N'是否缓存（0缓存 1不缓存）', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'is_cache' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单类型（M目录 C菜单 F按钮）', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'menu_type' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单状态（0显示 1隐藏）', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'visible' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单状态（0正常 1停用）', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'权限标识', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'perms' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单图标', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'icon' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单权限表', 'SCHEMA', N'dbo', 'TABLE', N'sys_menu' GO -- ---------------------------- -- Table structure for sys_notice -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_notice]') AND type IN ('U')) DROP TABLE [dbo].[sys_notice] GO CREATE TABLE [dbo].[sys_notice] ( [notice_id] int IDENTITY(1,1) NOT NULL, [notice_title] nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL, [notice_type] nchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL, [notice_content] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_notice] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'公告ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'notice_id' GO EXEC sp_addextendedproperty 'MS_Description', N'公告标题', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'notice_title' GO EXEC sp_addextendedproperty 'MS_Description', N'公告类型（1通知 2公告）', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'notice_type' GO EXEC sp_addextendedproperty 'MS_Description', N'公告内容', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'notice_content' GO EXEC sp_addextendedproperty 'MS_Description', N'公告状态（0正常 1关闭）', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'通知公告表', 'SCHEMA', N'dbo', 'TABLE', N'sys_notice' GO -- ---------------------------- -- Table structure for sys_oper_log -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_oper_log]') AND type IN ('U')) DROP TABLE [dbo].[sys_oper_log] GO CREATE TABLE [dbo].[sys_oper_log] ( [oper_id] bigint IDENTITY(1,1) NOT NULL, [title] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [business_type] int DEFAULT 0 NULL, [method] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, [request_method] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL, [operator_type] int DEFAULT 0 NULL, [oper_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [dept_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [oper_url] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [oper_ip] nvarchar(128) COLLATE Chinese_PRC_CI_AS NULL, [oper_location] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [oper_param] nvarchar(2000) COLLATE Chinese_PRC_CI_AS NULL, [json_result] nvarchar(2000) COLLATE Chinese_PRC_CI_AS NULL, [status] int DEFAULT 0 NULL, [error_msg] nvarchar(2000) COLLATE Chinese_PRC_CI_AS NULL, [oper_time] datetime2(7) NULL, [cost_time] bigint DEFAULT 0 NULL ) GO ALTER TABLE [dbo].[sys_oper_log] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'操作记录表', 'SCHEMA', N'dbo', 'TABLE', N'sys_oper_log' GO -- ---------------------------- -- Table structure for sys_post -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_post]') AND type IN ('U')) DROP TABLE [dbo].[sys_post] GO CREATE TABLE [dbo].[sys_post] ( [post_id] bigint IDENTITY(1,1) NOT NULL, [post_code] nvarchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL, [post_name] nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL, [post_sort] int NOT NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_post] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'岗位ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'post_id' GO EXEC sp_addextendedproperty 'MS_Description', N'岗位编码', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'post_code' GO EXEC sp_addextendedproperty 'MS_Description', N'岗位名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'post_name' GO EXEC sp_addextendedproperty 'MS_Description', N'显示顺序', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'post_sort' GO EXEC sp_addextendedproperty 'MS_Description', N'状态（0正常 1停用）', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_post', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'岗位信息表', 'SCHEMA', N'dbo', 'TABLE', N'sys_post' GO -- ---------------------------- -- Table structure for sys_role -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role]') AND type IN ('U')) DROP TABLE [dbo].[sys_role] GO CREATE TABLE [dbo].[sys_role] ( [role_id] bigint IDENTITY(1,1) NOT NULL, [role_name] nvarchar(30) COLLATE Chinese_PRC_CI_AS NOT NULL, [role_key] nvarchar(100) COLLATE Chinese_PRC_CI_AS NOT NULL, [role_sort] int NOT NULL, [data_scope] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 1 NULL, [menu_check_strictly] tinyint DEFAULT 1 NULL, [dept_check_strictly] tinyint DEFAULT 1 NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL, [del_flag] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_role] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'角色ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'role_id' GO EXEC sp_addextendedproperty 'MS_Description', N'角色名称', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'role_name' GO EXEC sp_addextendedproperty 'MS_Description', N'角色权限字符串', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'role_key' GO EXEC sp_addextendedproperty 'MS_Description', N'显示顺序', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'role_sort' GO EXEC sp_addextendedproperty 'MS_Description', N'数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'data_scope' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单树选择项是否关联显示', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'menu_check_strictly' GO EXEC sp_addextendedproperty 'MS_Description', N'部门树选择项是否关联显示', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'dept_check_strictly' GO EXEC sp_addextendedproperty 'MS_Description', N'角色状态（0正常 1停用）', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'删除标志（0代表存在 2代表删除）', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'del_flag' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_role', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'角色信息表', 'SCHEMA', N'dbo', 'TABLE', N'sys_role' GO -- ---------------------------- -- Table structure for sys_role_dept -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_dept]') AND type IN ('U')) DROP TABLE [dbo].[sys_role_dept] GO CREATE TABLE [dbo].[sys_role_dept] ( [role_id] bigint NOT NULL, [dept_id] bigint NOT NULL ) GO ALTER TABLE [dbo].[sys_role_dept] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'角色ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_role_dept', 'COLUMN', N'role_id' GO EXEC sp_addextendedproperty 'MS_Description', N'部门ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_role_dept', 'COLUMN', N'dept_id' GO EXEC sp_addextendedproperty 'MS_Description', N'角色和部门关联表', 'SCHEMA', N'dbo', 'TABLE', N'sys_role_dept' GO -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_menu]') AND type IN ('U')) DROP TABLE [dbo].[sys_role_menu] GO CREATE TABLE [dbo].[sys_role_menu] ( [role_id] bigint NOT NULL, [menu_id] bigint NOT NULL ) GO ALTER TABLE [dbo].[sys_role_menu] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'角色ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_role_menu', 'COLUMN', N'role_id' GO EXEC sp_addextendedproperty 'MS_Description', N'菜单ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_role_menu', 'COLUMN', N'menu_id' GO EXEC sp_addextendedproperty 'MS_Description', N'角色和菜单关联表', 'SCHEMA', N'dbo', 'TABLE', N'sys_role_menu' GO -- ---------------------------- -- Table structure for sys_user -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user]') AND type IN ('U')) DROP TABLE [dbo].[sys_user] GO CREATE TABLE [dbo].[sys_user] ( [user_id] bigint IDENTITY(1,1) NOT NULL, [dept_id] bigint NULL, [user_name] nvarchar(30) COLLATE Chinese_PRC_CI_AS NOT NULL, [nick_name] nvarchar(30) COLLATE Chinese_PRC_CI_AS NOT NULL, [user_type] nvarchar(2) COLLATE Chinese_PRC_CI_AS DEFAULT '00' NULL, [email] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [phonenumber] nvarchar(11) COLLATE Chinese_PRC_CI_AS NULL, [sex] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [avatar] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [password] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, [status] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [del_flag] nchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL, [login_ip] nvarchar(128) COLLATE Chinese_PRC_CI_AS NULL, [login_date] datetime2(7) NULL, [create_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [create_time] datetime2(7) NULL, [update_by] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, [update_time] datetime2(7) NULL, [remark] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[sys_user] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'用户ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'user_id' GO EXEC sp_addextendedproperty 'MS_Description', N'部门ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'dept_id' GO EXEC sp_addextendedproperty 'MS_Description', N'用户账号', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'user_name' GO EXEC sp_addextendedproperty 'MS_Description', N'用户昵称', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'nick_name' GO EXEC sp_addextendedproperty 'MS_Description', N'用户类型（00系统用户）', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'user_type' GO EXEC sp_addextendedproperty 'MS_Description', N'用户邮箱', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'email' GO EXEC sp_addextendedproperty 'MS_Description', N'手机号码', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'phonenumber' GO EXEC sp_addextendedproperty 'MS_Description', N'用户性别（0男 1女 2未知）', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'sex' GO EXEC sp_addextendedproperty 'MS_Description', N'头像地址', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'avatar' GO EXEC sp_addextendedproperty 'MS_Description', N'密码', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'password' GO EXEC sp_addextendedproperty 'MS_Description', N'账号状态（0正常 1停用）', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'删除标志（0代表存在 2代表删除）', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'del_flag' GO EXEC sp_addextendedproperty 'MS_Description', N'最后登录IP', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'login_ip' GO EXEC sp_addextendedproperty 'MS_Description', N'最后登录时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'login_date' GO EXEC sp_addextendedproperty 'MS_Description', N'创建者', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'create_by' GO EXEC sp_addextendedproperty 'MS_Description', N'创建时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'create_time' GO EXEC sp_addextendedproperty 'MS_Description', N'更新者', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'update_by' GO EXEC sp_addextendedproperty 'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'update_time' GO EXEC sp_addextendedproperty 'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'sys_user', 'COLUMN', N'remark' GO EXEC sp_addextendedproperty 'MS_Description', N'用户信息表', 'SCHEMA', N'dbo', 'TABLE', N'sys_user' GO -- ---------------------------- -- Table structure for sys_user_post -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_post]') AND type IN ('U')) DROP TABLE [dbo].[sys_user_post] GO CREATE TABLE [dbo].[sys_user_post] ( [user_id] bigint NOT NULL, [post_id] bigint NOT NULL ) GO ALTER TABLE [dbo].[sys_user_post] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'用户ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_user_post', 'COLUMN', N'user_id' GO EXEC sp_addextendedproperty 'MS_Description', N'岗位ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_user_post', 'COLUMN', N'post_id' GO EXEC sp_addextendedproperty 'MS_Description', N'用户与岗位关联表', 'SCHEMA', N'dbo', 'TABLE', N'sys_user_post' GO -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_role]') AND type IN ('U')) DROP TABLE [dbo].[sys_user_role] GO CREATE TABLE [dbo].[sys_user_role] ( [user_id] bigint NOT NULL, [role_id] bigint NOT NULL ) GO ALTER TABLE [dbo].[sys_user_role] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'用户ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_user_role', 'COLUMN', N'user_id' GO EXEC sp_addextendedproperty 'MS_Description', N'角色ID', 'SCHEMA', N'dbo', 'TABLE', N'sys_user_role', 'COLUMN', N'role_id' GO EXEC sp_addextendedproperty 'MS_Description', N'用户和角色关联表', 'SCHEMA', N'dbo', 'TABLE', N'sys_user_role' GO -- ---------------------------- -- Table structure for wcs_port -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[wcs_port]') AND type IN ('U')) DROP TABLE [dbo].[wcs_port] GO CREATE TABLE [dbo].[wcs_port] ( [id] bigint IDENTITY(1,1) NOT NULL, [port_code] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [port_name] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [port_type] varchar(1) COLLATE Chinese_PRC_CI_AS NULL, [port_region] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare1] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare2] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [spare3] varchar(255) COLLATE Chinese_PRC_CI_AS NULL, [status] varchar(255) COLLATE Chinese_PRC_CI_AS NULL ) GO ALTER TABLE [dbo].[wcs_port] SET (LOCK_ESCALATION = TABLE) GO EXEC sp_addextendedproperty 'MS_Description', N'主键', 'SCHEMA', N'dbo', 'TABLE', N'wcs_port', 'COLUMN', N'id' GO EXEC sp_addextendedproperty 'MS_Description', N'点位编码', 'SCHEMA', N'dbo', 'TABLE', N'wcs_port', 'COLUMN', N'port_code' GO EXEC sp_addextendedproperty 'MS_Description', N'点位名称', 'SCHEMA', N'dbo', 'TABLE', N'wcs_port', 'COLUMN', N'port_name' GO EXEC sp_addextendedproperty 'MS_Description', N'点位类型 1-输送机拣选工位 2-agv搬运点位', 'SCHEMA', N'dbo', 'TABLE', N'wcs_port', 'COLUMN', N'port_type' GO EXEC sp_addextendedproperty 'MS_Description', N'1-正常出库 2-出库回流', 'SCHEMA', N'dbo', 'TABLE', N'wcs_port', 'COLUMN', N'status' GO EXEC sp_addextendedproperty 'MS_Description', N'输送机拣选工位', 'SCHEMA', N'dbo', 'TABLE', N'wcs_port' GO -- ---------------------------- -- View structure for mydojob_ddj -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[mydojob_ddj]') AND type IN ('V')) DROP VIEW [dbo].[mydojob_ddj] GO CREATE VIEW [dbo].[mydojob_ddj] AS select job_id,status,task_no,roadway_id,cargo_space_id,warehouse_id,tray_code,uuid,ddjxf from mydo_job_wcs mjw left join ddj_device_execution_queue ddeq on mjw.task_no = ddeq.rwh GO -- ---------------------------- -- procedure structure for proc_job_finish -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[proc_job_finish]') AND type IN ('P', 'PC', 'RF', 'X')) DROP PROCEDURE[dbo].[proc_job_finish] GO CREATE PROCEDURE [dbo].[proc_job_finish] @v_rwh varchar(80), @v_ssj_code varchar(80), @v_result int OUTPUT, @v_resultmsg varchar(80) OUTPUT AS declare @v_count1 INT declare @v_current_time varchar(255) declare @v_in_or_out int declare @v_mydojob_id varchar(255) declare @v_tray_code varchar(255) declare @v_line_id varchar(255) BEGIN select @v_current_time = CONVERT(varchar, GETDATE(), 120); select @v_count1 = count(1) from mydo_job_wcs where task_no = @v_rwh if @v_count1 = 0 BEGIN set @v_result = 1; set @v_resultmsg = 'mydo_job_wcs 任务不存在 rwh:' + @v_rwh return END BEGIN TRANSACTION begin try --查询任务 select @v_in_or_out = in_or_out, @v_mydojob_id = job_id, @v_tray_code = tray_code,@v_line_id=line_id from mydo_job_wcs where task_no = @v_rwh --修改任务状态 update mydo_job_wcs set status = '4', execution_phase='1', finish_time=@v_current_time WHERE task_no = @v_rwh; --插入历史 insert into mydo_job_wcs_finish select * from mydo_job_wcs WHERE task_no = @v_rwh; --删除任务 delete from mydo_job_wcs where task_no = @v_rwh --插入回传 insert into job_call_back([type], [task_no], [mydojob_id], [status], [create_time], [spare1], [spare2], [spare3]) values (2, @v_rwh, @v_mydojob_id, 0, @v_current_time, @v_tray_code, '', '') --修改输送机出口状态 IF @v_line_id = '1' BEGIN -- if @v_in_or_out = 20 -- BEGIN -- update wcs_port set status = '1' where port_code = @v_ssj_code -- END -- ELSE -- BEGIN -- update wcs_port set status = '2' where port_code = @v_ssj_code -- END update wcs_port set status = '2' where port_code = @v_ssj_code END ELSE BEGIN update wcs_port set status = '1' where port_code = @v_ssj_code END end try BEGIN catch rollback transaction PRINT '错误: ' + ERROR_MESSAGE(); PRINT '发生在: ' + ISNULL(ERROR_PROCEDURE(), '顶层批处理') + ' 的第' + CAST(ERROR_LINE() AS VARCHAR) + '行'; set @v_result = 9 set @v_resultmsg = '存储过程异常' return END catch SET @v_result = 10; set @v_resultmsg = '操作成功' commit transaction END GO -- ---------------------------- -- procedure structure for proc_ddj_finish -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[proc_ddj_finish]') AND type IN ('P', 'PC', 'RF', 'X')) DROP PROCEDURE[dbo].[proc_ddj_finish] GO CREATE PROCEDURE [dbo].[proc_ddj_finish] @v_rwh varchar(80), @v_ddj_id int, @v_result int OUTPUT, @v_resultmsg varchar(80) OUTPUT AS declare @v_count1 INT declare @v_count2 INT declare @v_current_time varchar(255) declare @v_in_or_out int declare @v_mydojob_id varchar(255) declare @v_tray_code varchar(255) BEGIN select @v_current_time = CONVERT(varchar, GETDATE(), 120); select @v_count1 = count(1) from ddj_device_execution_queue where rwh = @v_rwh and dev_id = @v_ddj_id if @v_count1 = 0 BEGIN set @v_result = 1; set @v_resultmsg = '堆垛机执行任务不存在rwh:' + @v_rwh return; END select @v_count2 = count(1) from mydo_job_wcs where task_no = @v_rwh if @v_count2 = 0 BEGIN set @v_result = 1; set @v_resultmsg = 'mydo_job_wcs 任务不存在 rwh:' + @v_rwh return END BEGIN TRANSACTION begin try if @v_in_or_out < 20 BEGIN --查询任务 select @v_in_or_out = in_or_out, @v_mydojob_id = job_id, @v_tray_code = tray_code from mydo_job_wcs where task_no = @v_rwh --堆垛机执行任务完成 update ddj_device_execution_queue set jssj = @v_current_time, rwzt = 5 where rwh = @v_rwh --插入堆垛机执行历史 insert into ddj_device_execution_queue_finish select * from ddj_device_execution_queue where rwh = @v_rwh --删除堆垛机执行任务 delete from ddj_device_execution_queue where rwh = @v_rwh --修改任务状态 update mydo_job_wcs set status = '4', finish_time=@v_current_time WHERE task_no = @v_rwh; --插入历史 insert into mydo_job_wcs_finish select * from mydo_job_wcs WHERE task_no = @v_rwh; --删除任务 delete from mydo_job_wcs where task_no = @v_rwh --插入回传 insert into job_call_back([type], [task_no], [mydojob_id], [status], [create_time], [spare1], [spare2], [spare3]) values (1, @v_rwh, @v_mydojob_id, 0, @v_current_time, @v_tray_code, '', '') END else BEGIN --查询任务 select @v_in_or_out = in_or_out, @v_mydojob_id = job_id, @v_tray_code = tray_code from mydo_job_wcs where task_no = @v_rwh --堆垛机执行任务完成 update ddj_device_execution_queue set jssj = @v_current_time, rwzt = 5 where rwh = @v_rwh --插入堆垛机执行历史 insert into ddj_device_execution_queue_finish select * from ddj_device_execution_queue where rwh = @v_rwh --删除堆垛机执行任务 delete from ddj_device_execution_queue where rwh = @v_rwh --修改任务状态 update mydo_job_wcs set execution_phase = 2 WHERE task_no = @v_rwh; --插入清空货位回传 insert into job_call_back([type], [task_no], [mydojob_id], [status], [create_time], [spare1], [spare2], [spare3]) values (3, @v_rwh, @v_mydojob_id, 0, @v_current_time, @v_tray_code, '', '') END end try BEGIN catch rollback transaction PRINT '错误: ' + ERROR_MESSAGE(); PRINT '发生在: ' + ISNULL(ERROR_PROCEDURE(), '顶层批处理') + ' 的第' + CAST(ERROR_LINE() AS VARCHAR) + '行'; set @v_result = 9 set @v_resultmsg = '存储过程异常' return END catch SET @v_result = 10; set @v_resultmsg = '操作成功' commit transaction END GO -- ---------------------------- -- procedure structure for proc_mydojob_invalid -- ---------------------------- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[proc_mydojob_invalid]') AND type IN ('P', 'PC', 'RF', 'X')) DROP PROCEDURE[dbo].[proc_mydojob_invalid] GO CREATE PROCEDURE [dbo].[proc_mydojob_invalid] @v_rwh int, @v_ddj_id int, @v_result int OUTPUT, @v_resultmsg varchar(80) OUTPUT AS declare @v_count1 INT declare @v_count2 INT declare @v_current_time varchar(255) declare @v_in_or_out int declare @v_mydojob_id varchar(255) BEGIN select @v_current_time = CONVERT(varchar, GETDATE(), 120); select @v_count1 = count(1) from ddj_device_execution_queue where rwh = @v_rwh if @v_count1 = 0 BEGIN set @v_result = 1; set @v_resultmsg = '堆垛机执行任务不存在rwh:' + @v_rwh return; END select @v_count2 = count(1) from mydo_job_wcs where task_no = @v_rwh if @v_count2 > 0 BEGIN set @v_result = 1; set @v_resultmsg = 'mydo_job_wcs 任务不存在 rwh:' + @v_rwh return END select @v_in_or_out = in_or_out, @v_mydojob_id = job_id from mydo_job_wcs where task_no = @v_rwh BEGIN TRANSACTION begin try update mydo_job_wcs set status = '5', finish_time=@v_current_time WHERE task_no = @v_rwh insert into mydo_job_wcs_finish select * from mydo_job_wcs WHERE task_no = @v_rwh delete from mydo_job_wcs where task_no = @v_rwh update ddj_device_execution_queue set jssj = @v_current_time where rwh = @v_rwh insert into ddj_device_execution_queue_finish select * from ddj_device_execution_queue where rwh = @v_rwh delete from ddj_device_execution_queue where rwh = @v_rwh end try BEGIN catch rollback transaction PRINT '错误: ' + ERROR_MESSAGE(); PRINT '发生在: ' + ISNULL(ERROR_PROCEDURE(), '顶层批处理') + ' 的第' + CAST(ERROR_LINE() AS VARCHAR) + '行'; set @v_result = 9 set @v_resultmsg = '存储过程异常' return END catch SET @v_result = 10; set @v_resultmsg = '操作成功' commit transaction END GO -- ---------------------------- -- Primary Key structure for table bas_cargo_space -- ---------------------------- ALTER TABLE [dbo].[bas_cargo_space] ADD CONSTRAINT [PK__bas_carg__A8E6BAEEB03513E4] PRIMARY KEY CLUSTERED ([cargo_space_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table ddj_device_execution_queue -- ---------------------------- ALTER TABLE [dbo].[ddj_device_execution_queue] ADD CONSTRAINT [PK__wms_devi__7F427930BB49FF3F] PRIMARY KEY CLUSTERED ([uuid]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table ddj_device_execution_queue_finish -- ---------------------------- ALTER TABLE [dbo].[ddj_device_execution_queue_finish] ADD CONSTRAINT [PK__wms_devi__7F42793074413CE3] PRIMARY KEY CLUSTERED ([uuid]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for device_ssj -- ---------------------------- DBCC CHECKIDENT ('[dbo].[device_ssj]', RESEED, 126) GO -- ---------------------------- -- Primary Key structure for table device_ssj -- ---------------------------- ALTER TABLE [dbo].[device_ssj] ADD CONSTRAINT [PK__device_c__3213E83F718A5C26] 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 -- ---------------------------- -- Auto increment value for gen_table -- ---------------------------- DBCC CHECKIDENT ('[dbo].[gen_table]', RESEED, 1) GO -- ---------------------------- -- Primary Key structure for table gen_table -- ---------------------------- ALTER TABLE [dbo].[gen_table] ADD CONSTRAINT [PK__gen_tabl__B21E8F243C1D8150] PRIMARY KEY CLUSTERED ([table_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for gen_table_column -- ---------------------------- DBCC CHECKIDENT ('[dbo].[gen_table_column]', RESEED, 1) GO -- ---------------------------- -- Primary Key structure for table gen_table_column -- ---------------------------- ALTER TABLE [dbo].[gen_table_column] ADD CONSTRAINT [PK__gen_tabl__E301851F366156BE] PRIMARY KEY CLUSTERED ([column_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for job_call_back -- ---------------------------- DBCC CHECKIDENT ('[dbo].[job_call_back]', RESEED, 31098) GO -- ---------------------------- -- Primary Key structure for table job_call_back -- ---------------------------- ALTER TABLE [dbo].[job_call_back] ADD CONSTRAINT [PK__job_call__3213E83F5A28E12A] 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 -- ---------------------------- -- Primary Key structure for table msg_ddj -- ---------------------------- ALTER TABLE [dbo].[msg_ddj] ADD CONSTRAINT [PK__msg_ddj__3213E83F80CA19AC] 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 -- ---------------------------- -- Primary Key structure for table mydo_job_wcs -- ---------------------------- ALTER TABLE [dbo].[mydo_job_wcs] ADD CONSTRAINT [PK__mydo_job__6E32B6A5B7F37A58] PRIMARY KEY CLUSTERED ([job_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table mydo_job_wcs_finish -- ---------------------------- ALTER TABLE [dbo].[mydo_job_wcs_finish] ADD CONSTRAINT [PK__mydo_job__6E32B6A5A466108A] PRIMARY KEY CLUSTERED ([job_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_blob_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_blob_triggers] ADD CONSTRAINT [PK__qrtz_blo__009FEA1CB6121B9A] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_calendars -- ---------------------------- ALTER TABLE [dbo].[qrtz_calendars] ADD CONSTRAINT [PK__qrtz_cal__E21C98699D6CB05A] PRIMARY KEY CLUSTERED ([sched_name], [calendar_name]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_cron_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_cron_triggers] ADD CONSTRAINT [PK__qrtz_cro__009FEA1C53BC1BEB] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_fired_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_fired_triggers] ADD CONSTRAINT [PK__qrtz_fir__5E6EA63BB7CA81F5] PRIMARY KEY CLUSTERED ([sched_name], [entry_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_job_details -- ---------------------------- ALTER TABLE [dbo].[qrtz_job_details] ADD CONSTRAINT [PK__qrtz_job__1642BB8C39CE31C6] PRIMARY KEY CLUSTERED ([sched_name], [job_name], [job_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_locks -- ---------------------------- ALTER TABLE [dbo].[qrtz_locks] ADD CONSTRAINT [PK__qrtz_loc__F1C0211F6ABB233D] PRIMARY KEY CLUSTERED ([sched_name], [lock_name]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_paused_trigger_grps -- ---------------------------- ALTER TABLE [dbo].[qrtz_paused_trigger_grps] ADD CONSTRAINT [PK__qrtz_pau__3D845B2BF45A768C] PRIMARY KEY CLUSTERED ([sched_name], [trigger_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_scheduler_state -- ---------------------------- ALTER TABLE [dbo].[qrtz_scheduler_state] ADD CONSTRAINT [PK__qrtz_sch__FDC0ABB11E4829A8] PRIMARY KEY CLUSTERED ([sched_name], [instance_name]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_simple_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_simple_triggers] ADD CONSTRAINT [PK__qrtz_sim__009FEA1CF4A91CFF] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table qrtz_simprop_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_simprop_triggers] ADD CONSTRAINT [PK__qrtz_sim__009FEA1C23FD15F4] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Indexes structure for table qrtz_triggers -- ---------------------------- CREATE NONCLUSTERED INDEX [sched_name] ON [dbo].[qrtz_triggers] ( [sched_name] ASC, [job_name] ASC, [job_group] ASC ) GO -- ---------------------------- -- Primary Key structure for table qrtz_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_triggers] ADD CONSTRAINT [PK__qrtz_tri__009FEA1CEE47D41C] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for request_log -- ---------------------------- DBCC CHECKIDENT ('[dbo].[request_log]', RESEED, 36191) GO -- ---------------------------- -- Primary Key structure for table request_log -- ---------------------------- ALTER TABLE [dbo].[request_log] ADD CONSTRAINT [PK__request___18D3B90FD058AC36] PRIMARY KEY CLUSTERED ([request_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_config -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_config]', RESEED, 6) GO -- ---------------------------- -- Primary Key structure for table sys_config -- ---------------------------- ALTER TABLE [dbo].[sys_config] ADD CONSTRAINT [PK__sys_conf__4AD1BFF13C668C4B] PRIMARY KEY CLUSTERED ([config_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_dept -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_dept]', RESEED, 109) GO -- ---------------------------- -- Primary Key structure for table sys_dept -- ---------------------------- ALTER TABLE [dbo].[sys_dept] ADD CONSTRAINT [PK__sys_dept__DCA65974B7D9529A] PRIMARY KEY CLUSTERED ([dept_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_dict_data -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_dict_data]', RESEED, 177) GO -- ---------------------------- -- Primary Key structure for table sys_dict_data -- ---------------------------- ALTER TABLE [dbo].[sys_dict_data] ADD CONSTRAINT [PK__sys_dict__19CBC34B9FB1E808] PRIMARY KEY CLUSTERED ([dict_code]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_dict_type -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_dict_type]', RESEED, 50) GO -- ---------------------------- -- Indexes structure for table sys_dict_type -- ---------------------------- CREATE UNIQUE NONCLUSTERED INDEX [dict_type] ON [dbo].[sys_dict_type] ( [dict_type] ASC ) GO -- ---------------------------- -- Primary Key structure for table sys_dict_type -- ---------------------------- ALTER TABLE [dbo].[sys_dict_type] ADD CONSTRAINT [PK__sys_dict__3BD4186C844DEAF3] PRIMARY KEY CLUSTERED ([dict_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_job -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_job]', RESEED, 1) GO -- ---------------------------- -- Primary Key structure for table sys_job -- ---------------------------- ALTER TABLE [dbo].[sys_job] ADD CONSTRAINT [PK__sys_job__2E0E56DCB4D2CB2F] PRIMARY KEY CLUSTERED ([job_id], [job_name], [job_group]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_job_log -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_job_log]', RESEED, 1) GO -- ---------------------------- -- Primary Key structure for table sys_job_log -- ---------------------------- ALTER TABLE [dbo].[sys_job_log] ADD CONSTRAINT [PK__sys_job___0CA0EBC96AF21375] PRIMARY KEY CLUSTERED ([job_log_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_logininfor -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_logininfor]', RESEED, 80666) GO -- ---------------------------- -- Indexes structure for table sys_logininfor -- ---------------------------- CREATE NONCLUSTERED INDEX [idx_sys_logininfor_s] ON [dbo].[sys_logininfor] ( [status] ASC ) GO CREATE NONCLUSTERED INDEX [idx_sys_logininfor_lt] ON [dbo].[sys_logininfor] ( [login_time] ASC ) GO -- ---------------------------- -- Primary Key structure for table sys_logininfor -- ---------------------------- ALTER TABLE [dbo].[sys_logininfor] ADD CONSTRAINT [PK__sys_logi__3D8A9C1A68B9F120] PRIMARY KEY CLUSTERED ([info_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_menu -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_menu]', RESEED, 1347) GO -- ---------------------------- -- Primary Key structure for table sys_menu -- ---------------------------- ALTER TABLE [dbo].[sys_menu] ADD CONSTRAINT [PK__sys_menu__4CA0FADCF223BAA9] PRIMARY KEY CLUSTERED ([menu_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_notice -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_notice]', RESEED, 1) GO -- ---------------------------- -- Primary Key structure for table sys_notice -- ---------------------------- ALTER TABLE [dbo].[sys_notice] ADD CONSTRAINT [PK__sys_noti__3E82A5DB16172F3D] PRIMARY KEY CLUSTERED ([notice_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_oper_log -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_oper_log]', RESEED, 11578) GO -- ---------------------------- -- Primary Key structure for table sys_oper_log -- ---------------------------- ALTER TABLE [dbo].[sys_oper_log] ADD CONSTRAINT [PK__sys_oper__34723BF922648E41] PRIMARY KEY CLUSTERED ([oper_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_post -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_post]', RESEED, 4) GO -- ---------------------------- -- Primary Key structure for table sys_post -- ---------------------------- ALTER TABLE [dbo].[sys_post] ADD CONSTRAINT [PK__sys_post__3ED787669116C110] PRIMARY KEY CLUSTERED ([post_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_role -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_role]', RESEED, 4) GO -- ---------------------------- -- Primary Key structure for table sys_role -- ---------------------------- ALTER TABLE [dbo].[sys_role] ADD CONSTRAINT [PK__sys_role__760965CCA7C5092B] PRIMARY KEY CLUSTERED ([role_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table sys_role_dept -- ---------------------------- ALTER TABLE [dbo].[sys_role_dept] ADD CONSTRAINT [PK__sys_role__2BC3005B086CF21A] PRIMARY KEY CLUSTERED ([role_id], [dept_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table sys_role_menu -- ---------------------------- ALTER TABLE [dbo].[sys_role_menu] ADD CONSTRAINT [PK__sys_role__A2C36A61FC40B771] PRIMARY KEY CLUSTERED ([role_id], [menu_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for sys_user -- ---------------------------- DBCC CHECKIDENT ('[dbo].[sys_user]', RESEED, 4) GO -- ---------------------------- -- Primary Key structure for table sys_user -- ---------------------------- ALTER TABLE [dbo].[sys_user] ADD CONSTRAINT [PK__sys_user__B9BE370F6DE6DE07] PRIMARY KEY CLUSTERED ([user_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table sys_user_post -- ---------------------------- ALTER TABLE [dbo].[sys_user_post] ADD CONSTRAINT [PK__sys_user__CA534F793E3D9B8E] PRIMARY KEY CLUSTERED ([user_id], [post_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Primary Key structure for table sys_user_role -- ---------------------------- ALTER TABLE [dbo].[sys_user_role] ADD CONSTRAINT [PK__sys_user__6EDEA153D8B8F83E] PRIMARY KEY CLUSTERED ([user_id], [role_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO -- ---------------------------- -- Auto increment value for wcs_port -- ---------------------------- DBCC CHECKIDENT ('[dbo].[wcs_port]', RESEED, 10) GO -- ---------------------------- -- Primary Key structure for table wcs_port -- ---------------------------- ALTER TABLE [dbo].[wcs_port] ADD CONSTRAINT [PK__wcs_port__3213E83F6227673E] 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 -- ---------------------------- -- Foreign Keys structure for table qrtz_blob_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_blob_triggers] ADD CONSTRAINT [qrtz_blob_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION GO -- ---------------------------- -- Foreign Keys structure for table qrtz_cron_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_cron_triggers] ADD CONSTRAINT [qrtz_cron_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION GO -- ---------------------------- -- Foreign Keys structure for table qrtz_simple_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_simple_triggers] ADD CONSTRAINT [qrtz_simple_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION GO -- ---------------------------- -- Foreign Keys structure for table qrtz_simprop_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_simprop_triggers] ADD CONSTRAINT [qrtz_simprop_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION GO -- ---------------------------- -- Foreign Keys structure for table qrtz_triggers -- ---------------------------- ALTER TABLE [dbo].[qrtz_triggers] ADD CONSTRAINT [qrtz_triggers_ibfk_1] FOREIGN KEY ([sched_name], [job_name], [job_group]) REFERENCES [dbo].[qrtz_job_details] ([sched_name], [job_name], [job_group]) ON DELETE NO ACTION ON UPDATE NO ACTION GO