--------------------- SEQUENCE DDL ---------------------
---------------------TABLE DDL: BUS_DEVICE_INFO---------------------
CREATE TABLE VIDEO_USER.BUS_DEVICE_INFO
(
ID numeric(20,0) DEFAULT NULL ,
STATION_NAME character varying(32) DEFAULT NULL ,
MONITOR_NAME character varying(32) DEFAULT NULL ,
DEVICE_IP character varying(32) DEFAULT NULL ,
DEVICE_PORT numeric(11,0) DEFAULT NULL ,
DEVICE_USER character varying(32) DEFAULT NULL ,
DEVICE_PASSWORD character varying(32) DEFAULT NULL ,
NVR_IP character varying(32) DEFAULT NULL ,
NVR_PORT numeric(11,0) DEFAULT NULL ,
NVR_USER character varying(32) DEFAULT NULL ,
NVR_PASSWORD character varying(32) DEFAULT NULL ,
NVR_CHANNEL character varying(32) DEFAULT NULL ,
DEVICE_TYPE character varying(32) DEFAULT NULL ,
"DESCRIPTION" character varying(256) DEFAULT NULL ,
DEVICE_STATUS numeric(6,0) DEFAULT NULL ,
SECRET_LEVEL numeric(6,0) DEFAULT NULL ,
DEPT_ID numeric(20,0) DEFAULT NULL ,
LONGITUDE numeric(10,6) DEFAULT NULL ,
LATITUDE numeric(10,6) DEFAULT NULL ,
BF_FLAG numeric(6,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
AREA character varying(32) DEFAULT NULL ,
PLAY_URL character varying(255) DEFAULT NULL ,
CAMERA_INDEX_CODE character varying(64) DEFAULT NULL ,
"LOCATION" character varying(255) DEFAULT NULL ,
NVR_MANUFACTURE character varying(255) DEFAULT NULL ,
DEVICE_MANUFACTURE character varying(255) DEFAULT NULL ,
NVR_INDEX_CODE character varying(255)
)
BINLOG ON ;
---------------------TABLE INSERT SQL: BUS_DEVICE_INFO---------------------
INSERT INTO VIDEO_USER.BUS_DEVICE_INFO ( ID,STATION_NAME,MONITOR_NAME,DEVICE_IP,DEVICE_PORT,DEVICE_USER,DEVICE_PASSWORD,NVR_IP,NVR_PORT,NVR_USER,NVR_PASSWORD,NVR_CHANNEL,DEVICE_TYPE,DESCRIPTION,DEVICE_STATUS,SECRET_LEVEL,DEPT_ID,LONGITUDE,LATITUDE,BF_FLAG,CREATE_TIME,UPDATE_TIME,AREA,PLAY_URL,CAMERA_INDEX_CODE,LOCATION,NVR_MANUFACTURE,DEVICE_MANUFACTURE,NVR_INDEX_CODE) VALUES ('1788491058556604418',null,'大华-监控1','192.168.83.172','37777','admin','admin123','192.168.83.171','5060','admin','admin123','1','0',null,'1','0','1394541964580085762','116.258555','39.908447','0','2024-05-09 08:47:52','2024-05-09 08:47:52','1788158902110785537',null,'34020000001110000013','永定路社区设备点','Dahua','Dahua','41010500002000000003' );
INSERT INTO VIDEO_USER.BUS_DEVICE_INFO ( ID,STATION_NAME,MONITOR_NAME,DEVICE_IP,DEVICE_PORT,DEVICE_USER,DEVICE_PASSWORD,NVR_IP,NVR_PORT,NVR_USER,NVR_PASSWORD,NVR_CHANNEL,DEVICE_TYPE,DESCRIPTION,DEVICE_STATUS,SECRET_LEVEL,DEPT_ID,LONGITUDE,LATITUDE,BF_FLAG,CREATE_TIME,UPDATE_TIME,AREA,PLAY_URL,CAMERA_INDEX_CODE,LOCATION,NVR_MANUFACTURE,DEVICE_MANUFACTURE,NVR_INDEX_CODE) VALUES ('1788491058556604419',null,'海康-监控2','192.168.83.170','8000','admin','1234qwer','192.168.83.41','5060','admin','1234qwer','5','0',null,'1','0','1394541964580085762',null,null,'0','2024-05-09 08:47:52','2024-05-09 08:47:52','1788158902110785537',null,'34020000001320000003',null,'HIKVISION','Manufacturer','34020000001110000002' );
---------------------TABLE DDL: DEVICE_GROUP_INFO---------------------
CREATE TABLE VIDEO_USER.DEVICE_GROUP_INFO
(
ID numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
GROUP_NAME character varying(32) DEFAULT NULL ,
CAMERA_NUM numeric(11,0) DEFAULT NULL ,
"DESCRIPTION" character varying(256) DEFAULT NULL ,
CAMERA_IDS character varying(4000) ,
SAFE numeric(4,0) DEFAULT 0
)
BINLOG ON ;
---------------------TABLE COMMENT: DEVICE_GROUP_INFO---------------------
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."UPDATE_TIME" IS '修改时间';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."GROUP_NAME" IS '分组名称';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."CAMERA_NUM" IS '分组相机数量';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."DESCRIPTION" IS '描述';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."CAMERA_IDS" IS '分组相机id,用逗号隔开';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_GROUP_INFO"."SAFE" IS '密级（0，一般 1 重要 2 秘密）';
---------------------TABLE INSERT SQL: DEVICE_GROUP_INFO---------------------
INSERT INTO VIDEO_USER.DEVICE_GROUP_INFO ( ID,CREATE_TIME,UPDATE_TIME,GROUP_NAME,CAMERA_NUM,DESCRIPTION,CAMERA_IDS,SAFE) VALUES ('1789196828496109569','2024-05-11 07:32:20','2024-05-11 07:32:20','all','2',null,'1788491058556604418,1788491058556604419','0' );
---------------------TABLE DDL: DEVICE_ONLINE_LOG---------------------
CREATE TABLE VIDEO_USER.DEVICE_ONLINE_LOG
(
ID numeric(20,0) DEFAULT NULL ,
AREA character varying(32) DEFAULT NULL ,
ONLINE_NUM numeric(11,0) DEFAULT NULL ,
OFFLINE_NUM numeric(11,0) DEFAULT NULL ,
TOTAL numeric(11,0) DEFAULT NULL ,
LOG_TIME character varying(32) DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
DEVICE_ID numeric(20,0) ,
DEVICE_STATUS tinyint
)
BINLOG ON ;
---------------------TABLE COMMENT: DEVICE_ONLINE_LOG---------------------
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_ONLINE_LOG"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_ONLINE_LOG"."AREA" IS '区域字典';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_ONLINE_LOG"."ONLINE_NUM" IS '在线量';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_ONLINE_LOG"."OFFLINE_NUM" IS '离线数量';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_ONLINE_LOG"."TOTAL" IS '总数';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_ONLINE_LOG"."LOG_TIME" IS '记录时间';
COMMENT ON COLUMN "VIDEO_USER"."DEVICE_ONLINE_LOG"."UPDATE_TIME" IS '修改时间';
---------------------TABLE INSERT SQL: DEVICE_ONLINE_LOG---------------------
INSERT INTO VIDEO_USER.DEVICE_ONLINE_LOG ( ID,AREA,ONLINE_NUM,OFFLINE_NUM,TOTAL,LOG_TIME,UPDATE_TIME,DEVICE_ID,DEVICE_STATUS) VALUES ('1810619907180965890',null,null,null,null,'2024-07-09','2024-07-09 18:45:00','1788491058556604418','1' );
INSERT INTO VIDEO_USER.DEVICE_ONLINE_LOG ( ID,AREA,ONLINE_NUM,OFFLINE_NUM,TOTAL,LOG_TIME,UPDATE_TIME,DEVICE_ID,DEVICE_STATUS) VALUES ('1810619907180965891',null,null,null,null,'2024-07-09','2024-07-09 18:45:00','1788491058556604419','1' );
---------------------TABLE DDL: RISK_POINT_INFO---------------------
CREATE TABLE VIDEO_USER.RISK_POINT_INFO
(
ID bigint ,
CREATE_TIME date ,
UPDATE_TIME date ,
RISK_NAME character varying(32) ,
LONGITUDE numeric(10,6) ,
LATITUDE numeric(10,6) ,
DEPT_ID bigint ,
"DESCRIPTION" character varying(512)
)
BINLOG ON ;
---------------------TABLE COMMENT: RISK_POINT_INFO---------------------
COMMENT ON TABLE "VIDEO_USER"."RISK_POINT_INFO" IS '风险点管理信息';
---------------------TABLE INSERT SQL: RISK_POINT_INFO---------------------
---------------------TABLE DDL: RISK_REL_DEVICE---------------------
CREATE TABLE VIDEO_USER.RISK_REL_DEVICE
(
ID bigint ,
RISK_ID bigint ,
CREATE_TIME date ,
DEVICE_ID bigint
)
BINLOG ON ;
---------------------TABLE INSERT SQL: RISK_REL_DEVICE---------------------
---------------------TABLE DDL: SYS_AREA---------------------
CREATE TABLE VIDEO_USER.SYS_AREA
(
ID numeric(20,0) NOT NULL,
PID numeric(20,0) DEFAULT NULL ,
AREA_NAME character varying(100) DEFAULT NULL ,
SIMPLE_NAME character varying(50) DEFAULT NULL ,
LNG character varying(32) DEFAULT NULL ,
LAT character varying(32) DEFAULT NULL ,
"LEVEL" numeric(11,0) DEFAULT NULL ,
PIDS character varying(100) DEFAULT NULL ,
NUM numeric(4,0) DEFAULT NULL ,
SYNC_ID character varying(32) DEFAULT NULL ,
SYNC_PID character varying(32) DEFAULT NULL ,
IS_SYNC numeric(4,0) DEFAULT NULL ,
TENANT_ID character varying(64) DEFAULT NULL ,
CONSTRAINT SYS_AREA_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_AREA---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."ID" IS '编码';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."PID" IS '父级';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."AREA_NAME" IS '区域名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."SIMPLE_NAME" IS '区域简称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."LNG" IS '经度';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."LAT" IS '纬度';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."LEVEL" IS '层级';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."PIDS" IS '全部父级别';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."NUM" IS '排序';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."SYNC_ID" IS '同步id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."SYNC_PID" IS '同步父ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."IS_SYNC" IS '是否同步';
COMMENT ON COLUMN "VIDEO_USER"."SYS_AREA"."TENANT_ID" IS '租户ID';
---------------------TABLE INSERT SQL: SYS_AREA---------------------
INSERT INTO VIDEO_USER.SYS_AREA ( ID,PID,AREA_NAME,SIMPLE_NAME,LNG,LAT,LEVEL,PIDS,NUM,SYNC_ID,SYNC_PID,IS_SYNC,TENANT_ID) VALUES ('110000','0','根节点','根节点','116.405289','39.904987','1','[0],','1','root00000000','-1',null,null );
INSERT INTO VIDEO_USER.SYS_AREA ( ID,PID,AREA_NAME,SIMPLE_NAME,LNG,LAT,LEVEL,PIDS,NUM,SYNC_ID,SYNC_PID,IS_SYNC,TENANT_ID) VALUES ('1788158902110785537','110000','永定路A区域','永定路A区域',null,null,'2','[0],[110000],',null,'d141f1a3bd2645aeb3bed2f5bfe5a929','root00000000',null,null );
INSERT INTO VIDEO_USER.SYS_AREA ( ID,PID,AREA_NAME,SIMPLE_NAME,LNG,LAT,LEVEL,PIDS,NUM,SYNC_ID,SYNC_PID,IS_SYNC,TENANT_ID) VALUES ('1788158904023388162','110000','成都A区','成都A区',null,null,'2','[0],[110000],',null,'2222f9c4bb6548e3ac005826e5d60b55','root00000000',null,null );
---------------------TABLE DDL: SYS_CONFIG---------------------
CREATE TABLE VIDEO_USER.SYS_CONFIG
(
ID numeric(20,0) NOT NULL,
"VALUE" character varying(255) DEFAULT NULL ,
TARGET_NAME character varying(255) DEFAULT NULL ,
CLASS_NAME character varying(255) DEFAULT NULL ,
"DESCRIPTION" character varying(255) DEFAULT NULL ,
TENANT_ID character varying(64) DEFAULT NULL
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_CONFIG---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_CONFIG"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_CONFIG"."VALUE" IS '变量值(相关json串)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_CONFIG"."TARGET_NAME" IS '变量KEY';
COMMENT ON COLUMN "VIDEO_USER"."SYS_CONFIG"."CLASS_NAME" IS '类名全称(保留)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_CONFIG"."DESCRIPTION" IS '变量描述';
COMMENT ON COLUMN "VIDEO_USER"."SYS_CONFIG"."TENANT_ID" IS '租户ID';
---------------------TABLE INSERT SQL: SYS_CONFIG---------------------
INSERT INTO VIDEO_USER.SYS_CONFIG ( ID,VALUE,TARGET_NAME,CLASS_NAME,DESCRIPTION,TENANT_ID) VALUES ('1','1.0.0.191209_alpha','casic.base.version',null,'版本号',null );
INSERT INTO VIDEO_USER.SYS_CONFIG ( ID,VALUE,TARGET_NAME,CLASS_NAME,DESCRIPTION,TENANT_ID) VALUES ('2','false','casic.db.init.enable',null,'默认启用',null );
INSERT INTO VIDEO_USER.SYS_CONFIG ( ID,VALUE,TARGET_NAME,CLASS_NAME,DESCRIPTION,TENANT_ID) VALUES ('3','false','casic.db.init.enable',null,'默认启用',null );
INSERT INTO VIDEO_USER.SYS_CONFIG ( ID,VALUE,TARGET_NAME,CLASS_NAME,DESCRIPTION,TENANT_ID) VALUES ('9','150','casic.base.device.offLine',null,'设备离线时间判定(分钟)',null );
INSERT INTO VIDEO_USER.SYS_CONFIG ( ID,VALUE,TARGET_NAME,CLASS_NAME,DESCRIPTION,TENANT_ID) VALUES ('10','false','casic.base.user.onLineListenerEnable',null,'默认不开启（是否开启用户在线状态）',null );
---------------------TABLE DDL: SYS_DEPT---------------------
CREATE TABLE VIDEO_USER.SYS_DEPT
(
ID numeric(20,0) NOT NULL,
NUM numeric(4,0) DEFAULT NULL ,
PID numeric(20,0) DEFAULT NULL ,
PIDS character varying(255) DEFAULT NULL ,
SIMPLE_NAME character varying(45) DEFAULT NULL ,
FULL_NAME character varying(255) DEFAULT NULL ,
TIPS character varying(255) DEFAULT NULL ,
"VERSION" numeric(11,0) DEFAULT NULL ,
SYNC_ID character varying(255) DEFAULT NULL ,
SYNC_PID character varying(255) DEFAULT NULL ,
IS_SYNC numeric(4,0) DEFAULT NULL ,
IS_PARENT numeric(4,0) DEFAULT NULL ,
IP_SEGMENT character varying(255) DEFAULT NULL ,
DEPT_TYPE character(2) DEFAULT NULL ,
TENANT_ID character varying(255) DEFAULT NULL ,
CREATE_USER numeric(20,0) DEFAULT NULL ,
UPDATE_USER numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
DEL_FLAG character varying(32) DEFAULT '0' ,
CONSTRAINT SYS_DEPT_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_DEPT---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."ID" IS '主键id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."NUM" IS '排序';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."PID" IS '父部门ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."PIDS" IS '父级IDS';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."SIMPLE_NAME" IS '简称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."FULL_NAME" IS '全称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."TIPS" IS '标签';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."VERSION" IS '版本（乐观锁保留字段）';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."SYNC_ID" IS '外部组织ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."SYNC_PID" IS '外部父类主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."IS_SYNC" IS '是否同步数据 1为同步';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."IS_PARENT" IS '是否是父类';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."IP_SEGMENT" IS '登录IP段限制(逗号拼接)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."DEPT_TYPE" IS '组织类型(03 公司 04 部门/组)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."TENANT_ID" IS '租户ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."CREATE_USER" IS '创建用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."UPDATE_USER" IS '修改用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."UPDATE_TIME" IS '修改时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DEPT"."DEL_FLAG" IS '删除标识';
---------------------TABLE INSERT SQL: SYS_DEPT---------------------
INSERT INTO VIDEO_USER.SYS_DEPT ( ID,NUM,PID,PIDS,SIMPLE_NAME,FULL_NAME,TIPS,VERSION,SYNC_ID,SYNC_PID,IS_SYNC,IS_PARENT,IP_SEGMENT,DEPT_TYPE,TENANT_ID,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG) VALUES ('0','1','-1',null,'顶级','顶级',null,null,null,null,'0','0',null,'03',null,null,null,null,null,'0' );
INSERT INTO VIDEO_USER.SYS_DEPT ( ID,NUM,PID,PIDS,SIMPLE_NAME,FULL_NAME,TIPS,VERSION,SYNC_ID,SYNC_PID,IS_SYNC,IS_PARENT,IP_SEGMENT,DEPT_TYPE,TENANT_ID,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG) VALUES ('24','1','0','[0],','运行指挥调度中心','运行指挥调度中心',null,null,null,null,'0','0',null,'03','1',null,null,null,null,'0' );
INSERT INTO VIDEO_USER.SYS_DEPT ( ID,NUM,PID,PIDS,SIMPLE_NAME,FULL_NAME,TIPS,VERSION,SYNC_ID,SYNC_PID,IS_SYNC,IS_PARENT,IP_SEGMENT,DEPT_TYPE,TENANT_ID,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG) VALUES ('1394541964580085762','2','0','[0],','203','203所',null,null,null,null,'0','0',null,'03',null,null,null,null,null,'0' );
INSERT INTO VIDEO_USER.SYS_DEPT ( ID,NUM,PID,PIDS,SIMPLE_NAME,FULL_NAME,TIPS,VERSION,SYNC_ID,SYNC_PID,IS_SYNC,IS_PARENT,IP_SEGMENT,DEPT_TYPE,TENANT_ID,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG) VALUES ('1429999819396530178','1','0','[0],','中国航天科工1','中国航天科工集团203所',null,null,null,null,null,null,null,'03',null,'1','1','2021-08-24 02:51:40','2021-08-24 03:26:40','0' );
INSERT INTO VIDEO_USER.SYS_DEPT ( ID,NUM,PID,PIDS,SIMPLE_NAME,FULL_NAME,TIPS,VERSION,SYNC_ID,SYNC_PID,IS_SYNC,IS_PARENT,IP_SEGMENT,DEPT_TYPE,TENANT_ID,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG) VALUES ('1780179168070664194','0','1429999819396530178','[0],[1429999819396530178],','测试组织','测试组织',null,null,null,null,null,null,null,'03',null,'1',null,'2024-04-16 10:19:22',null,'0' );
---------------------TABLE DDL: SYS_DICT---------------------
CREATE TABLE VIDEO_USER.SYS_DICT
(
ID numeric(20,0) NOT NULL,
NUM character varying(32) DEFAULT NULL ,
PID numeric(20,0) DEFAULT NULL ,
"NAME" character varying(255) DEFAULT NULL ,
TIPS character varying(255) DEFAULT NULL ,
CODE character varying(255) DEFAULT NULL ,
TENANT_ID character varying(64) DEFAULT NULL ,
CONSTRAINT SYS_DICT_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_DICT---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_DICT"."ID" IS '主键id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DICT"."NUM" IS '排序';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DICT"."PID" IS '父级字典';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DICT"."NAME" IS '名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DICT"."TIPS" IS '提示';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DICT"."CODE" IS '值';
COMMENT ON COLUMN "VIDEO_USER"."SYS_DICT"."TENANT_ID" IS '租户ID';
---------------------TABLE INSERT SQL: SYS_DICT---------------------
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('35','0','0','账号状态',null,'accountStatus',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('36','1','35','启用',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('37','2','35','已冻结',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('38','3','35','已删除',null,'3',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('57','0','0','日志类型',null,'logType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('58','0','57','业务日志',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('59','1','57','异常日志',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('75','0','0','组织类型','组织类型','deptType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('76','1','75','公司',null,'03',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('77','2','75','组/部门',null,'04',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('159','0','0','数据权限类型',null,'dataScopeType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('160','0','159','所有数据',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('161','0','159','所属及下级部门',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('162','0','159','本部门',null,'3',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('163','0','159','自定义',null,'4',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1191959474021052418','0','0','状态',null,'sysStatus',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1191959474033635330','1','1191959474021052418','启用',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1191959474037829633','2','1191959474021052418','禁用',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1191961164497457154','0','0','性别',null,'sysSex',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1191961164510040066','1','1191961164497457154','男',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1191961164535205890','2','1191961164497457154','女',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1345920683299459074','0','0','性别',null,'sex',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1345920683299459075','0','1345920683299459074','男',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1345920683366567938','0','1345920683299459074','女',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1392315332146458625','0','0','资源类型',null,'resourceType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1392315332163235841','1','1392315332146458625','菜单',null,'03',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1392315332175818753','2','1392315332146458625','按钮',null,'04',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1392315332200984577','0','1392315332146458625','系统',null,'02',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1392315332213567489','5','1392315332146458625','移动端模块',null,'05',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397019628332453889','0','0','结果集类型',null,'viewResType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397019628403757057','0','1397019628332453889','实体对象',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397019628462477313','0','1397019628332453889','集合',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397021674825650177','0','0','访问类型','view视图是访问类型','viewRouteType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397021674846621697','0','1397021674825650177','资源库',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397021674896953345','0','1397021674825650177','接口',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397021674896953346','0','0','开启状态',null,'trackStatus',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397021674896953347','0','1397021674896953346','未开启',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1397021674896953348','0','1397021674896953346','已开启',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1774629992403734530','0','0','角色日志类型',null,'logRoleType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1774629992403734531','0','1774629992403734530','普通用户',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1774629992403734532','1','1774629992403734530','管理员',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1774629992403734533','2','1774629992403734530','保密员',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1774629992403734534','3','1774629992403734530','审计员',null,'3',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777504193142067202','0','0','是否关键区域','是否关键区域','keyArea',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777504193267896321','0','1777504193142067202','否',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777504193389531138','1','1777504193142067202','是',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777508904209485825','0','0','布防状态',null,'bfFlag',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777508904373063681','0','1777508904209485825','撤防',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777508904566001665','1','1777508904209485825','布防',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777589297931620353','0','0','所属区域',null,'area',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777589298011312129','0','1777589297931620353','永定路',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1777589298074226689','1','1777589297931620353','成都',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1778309657278812162','0','0','设备类型',null,'deviceType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1778309657434001409','0','1778309657278812162','枪机',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1778309657547247617','1','1778309657278812162','半球',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1778309657547247618','1','1778309657278812162','快球',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1778309657547247619','1','1778309657278812162','云台枪机',null,'3',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788482431670235138','0','0','区域类型',null,'levelType',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788482432190328833','0','1788482431670235138','一级',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788482432639119361','0','1788482431670235138','二级',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788482434295869442','0','1788482431670235138','三级',null,'3',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788482434815963137','0','1788482431670235138','四级',null,'4',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788484551878266882','0','0','设备状态',null,'status',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788484552519995393','0','1788484551878266882','离线',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1788484553107197953','1','1788484551878266882','在线',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1805808827719774210','0','0','密级',null,'secretLevel',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1805808827719774211','0','1805808827719774210','未定密',null,'0',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1805808827723968513','1','1805808827719774210','非密',null,'1',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1805808827723968514','2','1805808827719774210','秘密',null,'2',null );
INSERT INTO VIDEO_USER.SYS_DICT ( ID,NUM,PID,NAME,TIPS,CODE,TENANT_ID) VALUES ('1805808827723968515','3','1805808827719774210','机密',null,'3',null );
---------------------TABLE DDL: SYS_GROUP_DEVICE---------------------
CREATE TABLE VIDEO_USER.SYS_GROUP_DEVICE
(
ID numeric(18,0) NOT NULL,
GROUP_ID numeric(18,0) ,
CREATE_TIME date ,
DEVICE_ID numeric(18,0) ,
CONSTRAINT PK_SYS_GROUP_DEVICE PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE INSERT SQL: SYS_GROUP_DEVICE---------------------
---------------------TABLE DDL: SYS_GROUP_REL_USER---------------------
CREATE TABLE VIDEO_USER.SYS_GROUP_REL_USER
(
ID numeric(18,0) NOT NULL,
GROUP_ID numeric(18,0) ,
USER_ID numeric(18,0) ,
CREATE_TIME date ,
CONSTRAINT PK_SYS_GROUP_REL_USER PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE INSERT SQL: SYS_GROUP_REL_USER---------------------
---------------------TABLE DDL: SYS_LOGIN_LOG---------------------
CREATE TABLE VIDEO_USER.SYS_LOGIN_LOG
(
ID numeric(20,0) NOT NULL,
LOG_NAME character varying(255) DEFAULT NULL ,
USER_ID numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
SUCCEED character varying(255) DEFAULT NULL ,
MESSAGE clob ,
"IP" character varying(255) DEFAULT NULL ,
TENANT_ID character varying(64) DEFAULT NULL ,
ROLE_TYPE tinyint DEFAULT 0 ,
CONSTRAINT SYS_LOGIN_LOG_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_LOGIN_LOG---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."LOG_NAME" IS '日志名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."USER_ID" IS '管理员id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."SUCCEED" IS '是否执行成功';
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."MESSAGE" IS '具体消息';
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."IP" IS '登录ip';
COMMENT ON COLUMN "VIDEO_USER"."SYS_LOGIN_LOG"."TENANT_ID" IS '租户ID';
---------------------TABLE INSERT SQL: SYS_LOGIN_LOG---------------------
---------------------TABLE DDL: SYS_OPERATION_LOG---------------------
CREATE TABLE VIDEO_USER.SYS_OPERATION_LOG
(
ID numeric(20,0) NOT NULL,
LOG_TYPE character varying(255) DEFAULT NULL ,
LOG_NAME character varying(255) DEFAULT NULL ,
USER_ID numeric(20,0) DEFAULT NULL ,
CLASS_NAME character varying(255) DEFAULT NULL ,
METHOD clob ,
CREATE_TIME date DEFAULT NULL ,
SUCCEED character varying(255) DEFAULT NULL ,
MESSAGE clob ,
TENANT_ID character varying(64) DEFAULT NULL ,
APP_ID character varying(32) DEFAULT NULL ,
ROLE_TYPE numeric(4,0) DEFAULT 0 ,
CONSTRAINT SYS_OPERATION_LOG_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_OPERATION_LOG---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."LOG_TYPE" IS '日志类型';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."LOG_NAME" IS '日志名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."USER_ID" IS '用户id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."CLASS_NAME" IS '类名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."METHOD" IS '方法名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."SUCCEED" IS '是否成功';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."MESSAGE" IS '备注';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."TENANT_ID" IS '租户ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."APP_ID" IS '应用';
COMMENT ON COLUMN "VIDEO_USER"."SYS_OPERATION_LOG"."ROLE_TYPE" IS '0 普通用户 1 管理员 2 保密员 3 审计员';
---------------------TABLE INSERT SQL: SYS_OPERATION_LOG---------------------
---------------------TABLE DDL: SYS_PERSON---------------------
CREATE TABLE VIDEO_USER.SYS_PERSON
(
ID numeric(20,0) NOT NULL,
TENANT_ID character varying(64) DEFAULT NULL ,
CREATE_USER numeric(20,0) DEFAULT NULL ,
UPDATE_USER numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
DEL_FLAG character varying(32) DEFAULT '0' ,
PERSON_NAME character varying(32) DEFAULT NULL ,
SEX character(1) DEFAULT NULL ,
CARD_TYPE character(3) DEFAULT NULL ,
ID_CARD_NO character varying(32) DEFAULT NULL ,
DEPTID numeric(20,0) DEFAULT NULL ,
PERSON_TYPE character varying(32) DEFAULT NULL ,
REMARKS character varying(255) DEFAULT NULL ,
PERSON_CODE character varying(32) DEFAULT NULL ,
NATION character varying(32) DEFAULT NULL ,
BIRTHDAY date DEFAULT NULL ,
PHOTO character varying(64) DEFAULT NULL ,
PHONE character varying(32) DEFAULT NULL ,
CONSTRAINT SYS_PERSON_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_PERSON---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."TENANT_ID" IS '租户ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."CREATE_USER" IS '创建用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."UPDATE_USER" IS '修改用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."UPDATE_TIME" IS '修改时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."DEL_FLAG" IS '删除标识';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."PERSON_NAME" IS '姓名';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."SEX" IS '性别(1:男 2:女)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."CARD_TYPE" IS '证件类型';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."ID_CARD_NO" IS '证件号码';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."DEPTID" IS '所属部门';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."PERSON_TYPE" IS '人员类型';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."REMARKS" IS '备注';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."PERSON_CODE" IS '人员编码';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."NATION" IS '民族';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."BIRTHDAY" IS '出生日期';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."PHOTO" IS '证件照';
COMMENT ON COLUMN "VIDEO_USER"."SYS_PERSON"."PHONE" IS '电话号码';
---------------------TABLE INSERT SQL: SYS_PERSON---------------------
---------------------TABLE DDL: SYS_RESOURCE---------------------
CREATE TABLE VIDEO_USER.SYS_RESOURCE
(
ID numeric(20,0) NOT NULL,
PID numeric(20,0) DEFAULT NULL ,
CODE character varying(64) DEFAULT NULL ,
P_CODE character varying(64) DEFAULT NULL ,
P_CODES character varying(255) DEFAULT NULL ,
"NAME" character varying(64) DEFAULT NULL ,
ICON character varying(255) DEFAULT NULL ,
URL character varying(255) DEFAULT NULL ,
NUM numeric(4,0) DEFAULT NULL ,
LEVELS numeric(4,0) DEFAULT NULL ,
IS_MENU character(1) DEFAULT NULL ,
TIPS character varying(255) DEFAULT NULL ,
IS_OPEN character(1) DEFAULT NULL ,
RESOURCE_TYPE character(2) DEFAULT NULL ,
CREATE_USER numeric(20,0) DEFAULT NULL ,
UPDATE_USER numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
DEL_FLAG character varying(32) DEFAULT '0' ,
TENANT_ID character varying(64) DEFAULT NULL ,
STATUS character(1) DEFAULT NULL ,
CONSTRAINT SYS_RESOURCE_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_RESOURCE---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."ID" IS '主键id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."PID" IS '父ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."CODE" IS '菜单编号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."P_CODE" IS '菜单父编号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."P_CODES" IS '当前菜单的所有父菜单编号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."NAME" IS '菜单名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."ICON" IS '菜单图标';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."URL" IS 'URL地址';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."NUM" IS '菜单排序号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."LEVELS" IS '菜单层级';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."IS_MENU" IS '是否是菜单（1：是 0：不是）';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."TIPS" IS '备注';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."IS_OPEN" IS '是否打开: 1:打开 0:不打开';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."RESOURCE_TYPE" IS '资源类型';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."CREATE_USER" IS '创建用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."UPDATE_USER" IS '修改用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."UPDATE_TIME" IS '修改时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."DEL_FLAG" IS '删除标志';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."TENANT_ID" IS '租户ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RESOURCE"."STATUS" IS '状态';
---------------------TABLE INSERT SQL: SYS_RESOURCE---------------------
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('105','0','system','0','[0],','系统管理','icon-setting','/system','4','1','1',null,'1','03',null,'1',null,'2023-03-10 07:06:42','0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('106','105','mgr','system','[0],[system]','用户管理',null,'/sys/mgr','1','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('107','106','mgr_add','mgr','[0],[system],[mgr]','添加用户',null,'/sys/mgr/add','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('108','106','mgr_edit','mgr','[0],[system],[mgr]','修改用户',null,'/sys/mgr/update','2','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('109','106','mgr_delete','mgr','[0],[system],[mgr]','删除用户',null,'/sys/mgr/delete','3','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('110','106','mgr_reset','mgr','[0],[system],[mgr]','重置密码',null,'/sys/mgr/reset','4','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('111','106','mgr_freeze','mgr','[0],[system],[mgr]','冻结用户',null,'/sys/mgr/freeze','5','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('112','106','mgr_unfreeze','mgr','[0],[system],[mgr]','解除冻结用户',null,'/sys/mgr/unfreeze','6','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('113','106','mgr_setRole','mgr','[0],[system],[mgr]','分配角色',null,'/sys/mgr/roleAssign','7','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('114','105','role','system','[0],[system]','角色管理',null,'/sys/role','2','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('115','114','role_add','role','[0],[system],[role]','添加角色',null,'/sys/role/add','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('116','114','role_edit','role','[0],[system],[role]','修改角色',null,'/sys/role/update','2','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('117','114','role_remove','role','[0],[system],[role]','删除角色',null,'/sys/role/delete','3','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('118','114','role_setAuthority','role','[0],[system],[role]','配置权限',null,'/sys/role/funcAuthor','4','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('119','105','menu','system','[0],[system]','资源管理',null,'/sys/resource','4','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('120','119','menu_add','menu','[0],[system],[menu]','添加菜单',null,'/sys/resource/add','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('121','119','menu_edit','menu','[0],[system],[menu]','修改菜单',null,'/sys/resource/update','2','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('122','119','menu_remove','menu','[0],[system],[menu]','删除菜单',null,'/sys/resource/delete','3','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('128','105','log','system','[0],[system]','日志管理',null,'/sys/log','6','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('131','105','dept','system','[0],[system]','组织管理',null,'/sys/dept','3','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('132','105','dict','system','[0],[system]','字典管理',null,'/sys/dict','4','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('133','105','loginLog','system','[0],[system]','登录日志',null,'/sys/loginLog','6','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('134','128','log_clean','log','[0],[system][log],','清空日志',null,'/sys/log/biz/delLog','3','4','0',null,'0','04',null,'1',null,'2024-03-27 03:26:23','0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('135','131','dept_add','dept','[0],[system],[dept]','添加部门',null,'/sys/dept/add','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('136','131','dept_update','dept','[0],[system],[dept]','修改部门',null,'/sys/dept/update','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('137','131','dept_delete','dept','[0],[system],[dept]','删除部门',null,'/sys/dept/delete','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('138','132','dict_add','dict','[0],[system],[dict]','添加字典',null,'/sys/dict/add','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('139','132','dict_update','dict','[0],[system],[dict]','修改字典',null,'/sys/dict/update','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('140','132','dict_delete','dict','[0],[system],[dict]','删除字典',null,'/sys/dict/delete','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('151','119','menu_list','menu','[0],[system],[menu]','菜单列表',null,'/sys/resource/list','5','2','0',null,'0','0 ',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('153','131','dept_list','dept','[0],[system],[dept]','部门列表',null,'/sys/dept/list','5','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('154','131','dept_detail','dept','[0],[system],[dept]','部门详情',null,'/sys/dept/detail','6','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('156','132','dict_list','dict','[0],[system],[dict]','字典列表',null,'/sys/dict/list','5','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('157','132','dict_detail','dict','[0],[system],[dict]','字典详情',null,'/sys/dict/detail','6','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('158','128','log_list','log','[0],[system][log],','日志列表',null,'/sys/log/biz/list','2','4','1',null,'0','03',null,'1',null,'2024-03-27 03:28:29','0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('159','128','log_detail','log','[0],[system],[log]','日志详情',null,'/sys/log/biz/detail','3','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('160','133','del_login_log','loginLog','[0],[system],[loginLog]','清空登录日志',null,'/sys/loginLog/delLoginLog','1','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('161','133','login_log_list','loginLog','[0],[system],[loginLog]','登录日志列表',null,'/sys/loginLog/list','2','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('164','114','role_list','role','[0],[system],[role]','角色列表',null,'/sys/role/list','7','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('167','106','mgr_list','mgr','[0],[system],[mgr]','用户列表',null,'/sys/mgr/list','10','3','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1138364388198715393','114','data_author','role','[0],[system],[role]','数据权限',null,'/sys/role/dataAuthor','0','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1170945119300976642','105','AreaAdmin','system','[0],[system]','区域管理',null,'/sys/area','0','3','1',null,'0','03',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1191975090689810434','1170945119300976642','area_listPage','AreaAdmin','[0],[system],[AreaAdmin]','区域列表',null,'/sys/area/listPage','0','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1191975312815955969','1170945119300976642','area_add','AreaAdmin','[0],[system],[AreaAdmin]','新增区域',null,'/sys/area/add','0','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1191975427559530497','1170945119300976642','area_update','AreaAdmin','[0],[system],[AreaAdmin]','修改区域',null,'/sys/area/update','0','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1191975543687225346','1170945119300976642','area_delete','AreaAdmin','[0],[system],[AreaAdmin]','区域删除',null,'/sys/area/delete','0','4','0',null,'0','04',null,null,null,null,'0',null,null );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1780485097439432706','0','dashboard','0','[0],','首页','icon-map','/dashboard','0','1','1',null,'0','03','1','1','2024-04-17 06:35:02','2024-04-17 06:41:04','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1780485390394789889','0','monitor','0','[0],','远程监控','icon-yc','/monitor','0','1','1',null,'0','03','1','1','2024-04-17 06:36:12','2024-04-17 06:41:41','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1780485479381143554','1780485390394789889','realTime','monitor','[0],[monitor],','实时监控','icon-camera','/realTime','0','2','1',null,'0','03','1','1','2024-04-17 06:36:33','2024-04-17 06:45:42','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1780485764610592770','1780485390394789889','broadcast','monitor','[0],[monitor],','安全播报','icon-bb','/broadcast','0','2','1',null,'0','03','1','1','2024-04-17 06:37:41','2024-04-17 06:42:30','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1780485860056174593','1780485390394789889','playback','monitor','[0],[monitor],','场景回放','icon-hf','/playback','0','2','1',null,'0','03','1','1','2024-04-17 06:38:04','2024-04-17 06:42:39','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1780485944827252738','1780485390394789889','statistics','monitor','[0],[monitor],','数据统计','icon-line','/statistics','0','2','1',null,'0','03','1','1','2024-04-17 06:38:24','2024-04-17 06:42:49','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_RESOURCE ( ID,PID,CODE,P_CODE,P_CODES,NAME,ICON,URL,NUM,LEVELS,IS_MENU,TIPS,IS_OPEN,RESOURCE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,STATUS) VALUES ('1780486033650028545','1780485390394789889','device','monitor','[0],[monitor],','设备管理','icon-device','/device','0','2','1',null,'0','03','1','1','2024-04-17 06:38:45','2024-04-17 06:42:55','0',null,'0' );
---------------------TABLE DDL: SYS_RM_RELATION---------------------
CREATE TABLE VIDEO_USER.SYS_RM_RELATION
(
ID numeric(20,0) NOT NULL,
MENUID numeric(20,0) DEFAULT NULL ,
ROLEID numeric(20,0) DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
OPERATOR_ID numeric(20,0) DEFAULT NULL ,
TENANT_ID character varying(64) DEFAULT NULL ,
CONSTRAINT SYS_RM_RELATION_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_RM_RELATION---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_RM_RELATION"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RM_RELATION"."MENUID" IS '菜单id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RM_RELATION"."ROLEID" IS '角色id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RM_RELATION"."UPDATE_TIME" IS '授权时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RM_RELATION"."OPERATOR_ID" IS '授权人';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RM_RELATION"."TENANT_ID" IS '租户ID';
---------------------TABLE INSERT SQL: SYS_RM_RELATION---------------------
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538576408578','105','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517441','106','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517442','110','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517443','111','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517444','112','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517445','113','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517446','167','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517447','114','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538643517448','115','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432001','116','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432002','118','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432003','164','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432004','1138364388198715393','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432005','128','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432006','134','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432007','158','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1772826538706432008','159','2',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1776850835934433281','105','3',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1776850835934433282','128','3',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1776850835934433283','158','3',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1776850835934433284','159','3',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486167611904002','105','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486167704178689','106','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486167767093250','107','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486167888728065','108','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486167985197058','109','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168090054657','113','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168199106562','167','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168274604034','114','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168392044545','115','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168551428097','116','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168639508481','117','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168723394562','118','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168815669249','164','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486168916332545','1138364388198715393','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486169042161666','119','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486169176379394','120','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486169352540162','121','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486169528700930','122','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486169679695874','151','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486169830690818','128','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170036211714','134','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170141069314','158','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170275287042','159','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170367561729','131','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170447253505','135','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170577276929','136','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170652774402','137','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170761826305','153','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486170870878210','154','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171026067457','132','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171139313666','138','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171214811138','139','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171298697218','140','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171353223170','156','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171437109250','157','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171512606721','133','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171621658625','160','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171709739010','161','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171818790914','1170945119300976642','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171906871298','1191975090689810434','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486171982368769','1191975312815955969','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172070449153','1191975427559530497','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172171112449','1191975543687225346','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172275970050','1780485097439432706','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172347273218','1780485390394789889','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172431159298','1780485479381143554','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172728954882','1780485764610592770','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172871561218','1780485860056174593','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486172972224514','1780485944827252738','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486173030944769','1780486033650028545','1',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486214164484098','1780485097439432706','1398227452970446850',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486214244175874','1780485390394789889','1398227452970446850',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486214286118913','1780485479381143554','1398227452970446850',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486214395170817','1780485764610592770','1398227452970446850',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486214474862594','1780485860056174593','1398227452970446850',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486214550360066','1780485944827252738','1398227452970446850',null,null,null );
INSERT INTO VIDEO_USER.SYS_RM_RELATION ( ID,MENUID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780486214613274625','1780486033650028545','1398227452970446850',null,null,null );
---------------------TABLE DDL: SYS_ROLE---------------------
CREATE TABLE VIDEO_USER.SYS_ROLE
(
ID numeric(20,0) NOT NULL,
NUM numeric(4,0) DEFAULT NULL ,
PID numeric(20,0) DEFAULT NULL ,
"NAME" character varying(255) DEFAULT NULL ,
DEPT_ID numeric(20,0) DEFAULT NULL ,
"VERSION" numeric(11,0) DEFAULT NULL ,
TIPS character varying(255) DEFAULT NULL ,
DATASCOPE character varying(255) DEFAULT NULL ,
IS_DEFAULT numeric(6,0) DEFAULT NULL ,
DATA_SCOPE_TYPE character(1) DEFAULT NULL ,
CREATE_USER numeric(20,0) DEFAULT NULL ,
UPDATE_USER numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
DEL_FLAG character varying(32) DEFAULT '0' ,
TENANT_ID character varying(64) DEFAULT NULL ,
IS_SYS numeric(4,0) DEFAULT 0 ,
CONSTRAINT SYS_ROLE_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_ROLE---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."ID" IS '主键id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."NUM" IS '序号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."PID" IS '父角色ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."NAME" IS '角色名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."DEPT_ID" IS '部门ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."VERSION" IS '保留字段(暂时没用）';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."TIPS" IS '角色标识';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."DATASCOPE" IS '数据权限';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."IS_DEFAULT" IS '是否是默认角色(同步)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."DATA_SCOPE_TYPE" IS '数据权限类型( 1 所有数据 2 当前及子级部门 3 本部门 4 自定义)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."CREATE_USER" IS '创建用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."UPDATE_USER" IS '修改用户';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."UPDATE_TIME" IS '修改时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."DEL_FLAG" IS '删除状态';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."TENANT_ID" IS '租户ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_ROLE"."IS_SYS" IS '是否系统内置';
---------------------TABLE INSERT SQL: SYS_ROLE---------------------
INSERT INTO VIDEO_USER.SYS_ROLE ( ID,NUM,PID,NAME,DEPT_ID,VERSION,TIPS,DATASCOPE,IS_DEFAULT,DATA_SCOPE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS) VALUES ('1','1','0','系统管理角色','0','1','administrator','0,24','0','1',null,'1',null,'2024-04-07 05:39:43','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_ROLE ( ID,NUM,PID,NAME,DEPT_ID,VERSION,TIPS,DATASCOPE,IS_DEFAULT,DATA_SCOPE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS) VALUES ('2','0','0','安全保密角色','0',null,'security_admin',null,'0','1','1',null,'2024-03-26 07:25:45',null,'0',null,'0' );
INSERT INTO VIDEO_USER.SYS_ROLE ( ID,NUM,PID,NAME,DEPT_ID,VERSION,TIPS,DATASCOPE,IS_DEFAULT,DATA_SCOPE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS) VALUES ('3','0','0','安全审计角色','0',null,'audit_admin',null,'0','1','1','1','2024-03-26 07:50:37','2024-06-20 18:59:35','0',null,'0' );
INSERT INTO VIDEO_USER.SYS_ROLE ( ID,NUM,PID,NAME,DEPT_ID,VERSION,TIPS,DATASCOPE,IS_DEFAULT,DATA_SCOPE_TYPE,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS) VALUES ('1398227452970446850','99','1','普通管理角色','24',null,'normalAdmin',null,'0','4',null,null,null,null,'0',null,'0' );
---------------------TABLE DDL: SYS_RU_RELATION---------------------
CREATE TABLE VIDEO_USER.SYS_RU_RELATION
(
ID numeric(20,0) NOT NULL,
USERID numeric(20,0) DEFAULT NULL ,
ROLEID numeric(20,0) DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
OPERATOR_ID numeric(20,0) DEFAULT NULL ,
TENANT_ID character varying(64) DEFAULT NULL ,
CONSTRAINT SYS_RU_RELATION_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_RU_RELATION---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_RU_RELATION"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RU_RELATION"."USERID" IS '用户id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RU_RELATION"."ROLEID" IS '角色id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RU_RELATION"."UPDATE_TIME" IS '授权时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RU_RELATION"."OPERATOR_ID" IS '授权人';
COMMENT ON COLUMN "VIDEO_USER"."SYS_RU_RELATION"."TENANT_ID" IS '租户ID';
---------------------TABLE INSERT SQL: SYS_RU_RELATION---------------------
INSERT INTO VIDEO_USER.SYS_RU_RELATION ( ID,USERID,ROLEID,UPDATE_TIME,OPERATOR_ID,TENANT_ID) VALUES ('1780491863451570178','1780491861748682754','1',null,null,null );
---------------------TABLE DDL: SYS_TABLE_VIEW_CONFIG---------------------
CREATE TABLE VIDEO_USER.SYS_TABLE_VIEW_CONFIG
(
ID numeric(20,0) NOT NULL,
VIEW_KEY character varying(64) DEFAULT NULL ,
SQL_CONTENT character varying(512) DEFAULT NULL ,
TITLE character varying(256) DEFAULT NULL ,
RES_TYPE character varying(2) DEFAULT NULL ,
REMARKS character varying(255) DEFAULT NULL ,
PARAMS_NUM numeric(11,0) DEFAULT 0 ,
ROUTE_TYPE character(1) DEFAULT NULL ,
HOST character varying(255) DEFAULT NULL ,
RULE_CLASS character varying(255) DEFAULT NULL ,
CONSTRAINT SYS_TABLE_VIEW_CONFIG_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_TABLE_VIEW_CONFIG---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."VIEW_KEY" IS '视图key值';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."SQL_CONTENT" IS '执行sql';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."TITLE" IS '标题';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."RES_TYPE" IS '1 实体对象 2 集合';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."REMARKS" IS '备注信息';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."PARAMS_NUM" IS '参数个数';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."ROUTE_TYPE" IS '转发类型(1 本地库读取 2 接口访问 3 转换数据)';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."HOST" IS '请求地址';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TABLE_VIEW_CONFIG"."RULE_CLASS" IS '转换规则类';
---------------------TABLE INSERT SQL: SYS_TABLE_VIEW_CONFIG---------------------
---------------------TABLE DDL: SYS_TENANT---------------------
CREATE TABLE VIDEO_USER.SYS_TENANT
(
ID numeric(20,0) DEFAULT NULL ,
TENANT_NAME character varying(255) DEFAULT NULL ,
TENANT_CODE character varying(255) DEFAULT NULL ,
LINK_PERSON character varying(50) DEFAULT NULL ,
TEL character varying(20) DEFAULT NULL ,
CLEARDAY numeric(11,0) DEFAULT NULL ,
FLAG character(1) DEFAULT NULL ,
TS date DEFAULT NULL
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_TENANT---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."ID" IS '自增主键';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."TENANT_NAME" IS '租户名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."TENANT_CODE" IS '租户编码';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."LINK_PERSON" IS '联系人';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."TEL" IS '电话';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."CLEARDAY" IS '历史数据保存天数';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."FLAG" IS '状态';
COMMENT ON COLUMN "VIDEO_USER"."SYS_TENANT"."TS" IS '更新时间戳';
---------------------TABLE INSERT SQL: SYS_TENANT---------------------
---------------------TABLE DDL: SYS_USER---------------------
CREATE TABLE VIDEO_USER.SYS_USER
(
ID numeric(20,0) NOT NULL,
AVATAR character varying(255) DEFAULT NULL ,
ACCOUNT character varying(45) DEFAULT NULL ,
"PASSWORD" character varying(45) DEFAULT NULL ,
SALT character varying(45) DEFAULT NULL ,
"NAME" character varying(45) DEFAULT NULL ,
BIRTHDAY date DEFAULT NULL ,
SEX character(1) DEFAULT NULL ,
EMAIL character varying(45) DEFAULT NULL ,
PHONE character varying(45) DEFAULT NULL ,
ROLE_ID character varying(255) DEFAULT NULL ,
DEPT_ID numeric(20,0) DEFAULT NULL ,
STATUS character(1) DEFAULT NULL ,
"VERSION" numeric(11,0) DEFAULT NULL ,
SYNC_ID character varying(32) DEFAULT NULL ,
SYNC_NAME character varying(255) DEFAULT NULL ,
SYNC_PWD character varying(45) DEFAULT NULL ,
SYNC_DEPTID character varying(255) DEFAULT NULL ,
IS_SYNC numeric(6,0) DEFAULT 0 ,
LOGIN_IP character varying(255) DEFAULT NULL ,
LOGIN_MAC character varying(255) DEFAULT NULL ,
POSITION_LNG numeric(19,8) DEFAULT NULL ,
POSITION_LAT numeric(19,8) DEFAULT NULL ,
ATTR1 character varying(32) DEFAULT NULL ,
LAST_TIME timestamp(0) without time zone DEFAULT ('NOW'::text)::timestamp(0) with time zone ,
CREATE_USER numeric(20,0) DEFAULT NULL ,
UPDATE_USER numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
DEL_FLAG character varying(32) DEFAULT '0' ,
TENANT_ID character varying(64) DEFAULT NULL ,
IS_SYS numeric(4,0) DEFAULT 0 ,
SECRET_LEVEL numeric(4,0) DEFAULT 0 ,
CONSTRAINT SYS_USER_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_USER---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."ID" IS '主键id';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."AVATAR" IS '头像';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."ACCOUNT" IS '账号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."PASSWORD" IS '密码';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."SALT" IS 'md5密码盐';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."NAME" IS '名字';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."BIRTHDAY" IS '生日';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."SEX" IS '性别';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER"."EMAIL" IS '电子邮件';
---------------------TABLE INSERT SQL: SYS_USER---------------------
INSERT INTO VIDEO_USER.SYS_USER ( ID,AVATAR,ACCOUNT,PASSWORD,SALT,NAME,BIRTHDAY,SEX,EMAIL,PHONE,ROLE_ID,DEPT_ID,STATUS,VERSION,SYNC_ID,SYNC_NAME,SYNC_PWD,SYNC_DEPTID,IS_SYNC,LOGIN_IP,LOGIN_MAC,POSITION_LNG,POSITION_LAT,ATTR1,LAST_TIME,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS,SECRET_LEVEL) VALUES ('1','girl.gif','admin','270fa3ef938fb1277d1ab23e9971566a','jg8q8','系统管理员','2017-05-04 16:00:00','1','sn93@qq.com','18200000000','1,1398227452970446850','0','1','25',null,null,null,null,'0',null,null,null,null,null,'2024-04-12 13:59:44',null,null,'2016-01-29 00:49:53',null,'0',null,'0','0' );
INSERT INTO VIDEO_USER.SYS_USER ( ID,AVATAR,ACCOUNT,PASSWORD,SALT,NAME,BIRTHDAY,SEX,EMAIL,PHONE,ROLE_ID,DEPT_ID,STATUS,VERSION,SYNC_ID,SYNC_NAME,SYNC_PWD,SYNC_DEPTID,IS_SYNC,LOGIN_IP,LOGIN_MAC,POSITION_LNG,POSITION_LAT,ATTR1,LAST_TIME,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS,SECRET_LEVEL) VALUES ('2','girl.gif','security_admin','270fa3ef938fb1277d1ab23e9971566a','jg8q8','安全管理员','2017-05-04 16:00:00','1','sn93@qq.com','18200000000','2','0','1','25',null,null,null,null,'0',null,null,null,null,null,'2024-04-07 05:53:46',null,'2','2016-01-29 00:49:53','2024-03-27 02:53:49','0',null,'1','0' );
INSERT INTO VIDEO_USER.SYS_USER ( ID,AVATAR,ACCOUNT,PASSWORD,SALT,NAME,BIRTHDAY,SEX,EMAIL,PHONE,ROLE_ID,DEPT_ID,STATUS,VERSION,SYNC_ID,SYNC_NAME,SYNC_PWD,SYNC_DEPTID,IS_SYNC,LOGIN_IP,LOGIN_MAC,POSITION_LNG,POSITION_LAT,ATTR1,LAST_TIME,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS,SECRET_LEVEL) VALUES ('3','girl.gif','audit_admin','270fa3ef938fb1277d1ab23e9971566a','jg8q8','安全审计员','2017-05-04 16:00:00','1','sn93@qq.com','18200000000','3,1398227452970446850','0','1','25',null,null,null,null,'0',null,null,null,null,null,'2024-04-07 06:20:34',null,null,'2016-01-29 00:49:53',null,'0',null,'1','0' );
INSERT INTO VIDEO_USER.SYS_USER ( ID,AVATAR,ACCOUNT,PASSWORD,SALT,NAME,BIRTHDAY,SEX,EMAIL,PHONE,ROLE_ID,DEPT_ID,STATUS,VERSION,SYNC_ID,SYNC_NAME,SYNC_PWD,SYNC_DEPTID,IS_SYNC,LOGIN_IP,LOGIN_MAC,POSITION_LNG,POSITION_LAT,ATTR1,LAST_TIME,CREATE_USER,UPDATE_USER,CREATE_TIME,UPDATE_TIME,DEL_FLAG,TENANT_ID,IS_SYS,SECRET_LEVEL) VALUES ('1780491861748682754',null,'wxt','09e3d04c2c44e96095446e4af12db5ab','59vmr','wxt',null,null,null,null,'1','1394541964580085762','1',null,null,null,null,null,'0',null,null,null,null,null,'2024-04-17 15:01:54','1',null,'2024-04-17 07:01:54',null,'0',null,'0','0' );
---------------------TABLE DDL: SYS_USER_DEVICE---------------------
CREATE TABLE VIDEO_USER.SYS_USER_DEVICE
(
ID numeric(20,0) NOT NULL,
IMEI character varying(255) DEFAULT NULL ,
USER_ID numeric(20,0) DEFAULT NULL ,
NETWORK_NUMBER character varying(255) DEFAULT NULL ,
TARGET_ID character varying(255) DEFAULT NULL ,
LAST_TIME timestamp(0) without time zone DEFAULT NULL ,
POSITION_LNG numeric(19,8) DEFAULT NULL ,
POSITION_LAT numeric(19,8) DEFAULT NULL ,
DEVICE_NAME character varying(255) DEFAULT NULL ,
TENANT_ID character varying(64) DEFAULT NULL ,
CONSTRAINT SYS_USER_DEVICE_PKEY PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE COMMENT: SYS_USER_DEVICE---------------------
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."ID" IS '用户设备IMEI号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."IMEI" IS '用户设备IMEI号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."NETWORK_NUMBER" IS '入网号';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."TARGET_ID" IS '同步数据ID';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."LAST_TIME" IS '最后在线时间';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."POSITION_LNG" IS '经度';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."POSITION_LAT" IS '纬度';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."DEVICE_NAME" IS '设备名称';
COMMENT ON COLUMN "VIDEO_USER"."SYS_USER_DEVICE"."TENANT_ID" IS '租户ID';
---------------------TABLE INSERT SQL: SYS_USER_DEVICE---------------------
---------------------TABLE DDL: SYS_USER_GROUP---------------------
CREATE TABLE VIDEO_USER.SYS_USER_GROUP
(
ID numeric(18,0) NOT NULL,
GROUP_NAME character varying(256) ,
CREATE_TIME date ,
DEPT_ID numeric(18,0) ,
CREATE_ID numeric(18,0) ,
"DESCRIPTION" character varying(256) ,
SAFE smallint ,
CONSTRAINT PK_SYS_USER_GROUP PRIMARY KEY (ID)
)
BINLOG ON ;
---------------------TABLE INSERT SQL: SYS_USER_GROUP---------------------
---------------------TABLE DDL: UPLOAD_LOG---------------------
CREATE TABLE VIDEO_USER.UPLOAD_LOG
(
ID numeric(20,0) DEFAULT NULL ,
FILE_PATH character varying(256) DEFAULT NULL ,
FILE_NAME character varying(256) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
DEVICE_ID numeric(20,0) DEFAULT NULL ,
CREATE_ID numeric(20,0) DEFAULT NULL
)
BINLOG ON ;
---------------------TABLE COMMENT: UPLOAD_LOG---------------------
COMMENT ON COLUMN "VIDEO_USER"."UPLOAD_LOG"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."UPLOAD_LOG"."FILE_PATH" IS '文件路径';
COMMENT ON COLUMN "VIDEO_USER"."UPLOAD_LOG"."FILE_NAME" IS '文件名称';
COMMENT ON COLUMN "VIDEO_USER"."UPLOAD_LOG"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."UPLOAD_LOG"."DEVICE_ID" IS '设备ID';
COMMENT ON COLUMN "VIDEO_USER"."UPLOAD_LOG"."CREATE_ID" IS '创建者ID';
---------------------TABLE INSERT SQL: UPLOAD_LOG---------------------
---------------------TABLE DDL: VOICE_LOG---------------------
CREATE TABLE VIDEO_USER.VOICE_LOG
(
ID numeric(20,0) DEFAULT NULL ,
CREATE_TIME date DEFAULT NULL ,
UPDATE_TIME date DEFAULT NULL ,
VOICE_LONG character varying(64) DEFAULT NULL ,
VOICE_URL character varying(256) DEFAULT NULL ,
VOICE_NAME character varying(64) DEFAULT NULL ,
GROUP_ID numeric(20,0) DEFAULT NULL
)
BINLOG ON ;
---------------------TABLE COMMENT: VOICE_LOG---------------------
COMMENT ON COLUMN "VIDEO_USER"."VOICE_LOG"."ID" IS '主键';
COMMENT ON COLUMN "VIDEO_USER"."VOICE_LOG"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "VIDEO_USER"."VOICE_LOG"."UPDATE_TIME" IS '修改时间';
COMMENT ON COLUMN "VIDEO_USER"."VOICE_LOG"."VOICE_LONG" IS '时长';
COMMENT ON COLUMN "VIDEO_USER"."VOICE_LOG"."VOICE_URL" IS '音频文件';
COMMENT ON COLUMN "VIDEO_USER"."VOICE_LOG"."VOICE_NAME" IS '广播名称';
COMMENT ON COLUMN "VIDEO_USER"."VOICE_LOG"."GROUP_ID" IS '分组ID';
---------------------TABLE INSERT SQL: VOICE_LOG---------------------
