From 5a70a4742dad4dded0916365a0c9591501233ec0 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期二, 28 五月 2024 10:39:26 +0800
Subject: [PATCH] 修正数据库sql文件
---
数据库/2.7.1/初始化-postgresql-kingbase-2.7.1.sql | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.7.1.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.7.1.sql"
index 86a63d9..eb2bc83 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.7.1.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.7.1.sql"
@@ -154,8 +154,13 @@
rtp_proxy_port integer,
rtsp_port integer,
rtsp_ssl_port integer,
+ flv_port integer,
+ flv_ssl_port integer,
+ ws_flv_port integer,
+ ws_flv_ssl_port integer,
auto_config bool default false,
secret character varying(50),
+ type character varying(50) default 'zlm',
rtp_enable bool default false,
rtp_port_range character varying(50),
send_rtp_port_range character varying(50),
@@ -316,6 +321,18 @@
path character varying(255)
);
+create table wvp_user_api_key (
+ id serial primary key ,
+ user_id bigint,
+ app character varying(255) ,
+ api_key text,
+ expired_at bigint,
+ remark character varying(255),
+ enable bool default true,
+ create_time character varying(50),
+ update_time character varying(50)
+);
+
/*鍒濆鏁版嵁*/
INSERT INTO wvp_user VALUES (1, 'admin','21232f297a57a5a743894a0e4a801fc3',1,'2021-04-13 14:14:57','2021-04-13 14:14:57','3e80d1762a324d5b0ff636e0bd16f1e3');
--
Gitblit v1.8.0