From 5a70a4742dad4dded0916365a0c9591501233ec0 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期二, 28 五月 2024 10:39:26 +0800
Subject: [PATCH] 修正数据库sql文件

---
 /dev/null                                   |   23 -------
 数据库/2.7.2/更新-postgresql-kingbase-2.7.2.sql  |    3 +
 数据库/2.7.1/初始化-postgresql-kingbase-2.7.1.sql |   17 +++++
 数据库/2.7.1/更新-mysql-2.7.1.sql                |   26 ++++++++
 数据库/2.7.2/初始化-mysql-2.7.2.sql               |    3 +
 数据库/2.7.2/更新-mysql-2.7.2.sql                |    3 +
 数据库/2.7.1/初始化-mysql-2.7.1.sql               |   17 +++++
 数据库/2.7.1/更新-postgresql-kingbase-2.7.1.sql  |   26 ++++++++
 数据库/2.7.2/初始化-postgresql-kingbase-2.7.2.sql |    3 +
 9 files changed, 96 insertions(+), 25 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-mysql-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-mysql-2.7.1.sql"
index ee828f4..98d4340 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-mysql-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-mysql-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');
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');
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.1.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.1.sql"
index 86e8d0d..dff8570 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.1.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.1.sql"
@@ -1,2 +1,26 @@
 alter table wvp_media_server
-    add transcode_suffix character varying(255);
\ No newline at end of file
+    add transcode_suffix character varying(255);
+
+alter table wvp_media_server
+    add  type character varying(50) default 'zlm';
+
+alter table wvp_media_server
+    add flv_port integer;
+alter table wvp_media_server
+    add flv_ssl_port integer;
+alter table wvp_media_server
+    add ws_flv_port integer;
+alter table wvp_media_server
+    add ws_flv_ssl_port integer;
+
+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)
+);
\ No newline at end of file
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-postgresql-kingbase-2.7.0.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-postgresql-kingbase-2.7.0.sql"
deleted file mode 100644
index b43774f..0000000
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-postgresql-kingbase-2.7.0.sql"
+++ /dev/null
@@ -1,23 +0,0 @@
-alter table wvp_media_server
-    add  type character varying(50) default 'zlm';
-
-alter table wvp_media_server
-    add flv_port integer;
-alter table wvp_media_server
-    add flv_ssl_port integer;
-alter table wvp_media_server
-    add ws_flv_port integer;
-alter table wvp_media_server
-    add ws_flv_ssl_port integer;
-
-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)
-);
\ No newline at end of file
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-postgresql-kingbase-2.7.1.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-postgresql-kingbase-2.7.1.sql"
index 86e8d0d..dff8570 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-postgresql-kingbase-2.7.1.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-postgresql-kingbase-2.7.1.sql"
@@ -1,2 +1,26 @@
 alter table wvp_media_server
-    add transcode_suffix character varying(255);
\ No newline at end of file
+    add transcode_suffix character varying(255);
+
+alter table wvp_media_server
+    add  type character varying(50) default 'zlm';
+
+alter table wvp_media_server
+    add flv_port integer;
+alter table wvp_media_server
+    add flv_ssl_port integer;
+alter table wvp_media_server
+    add ws_flv_port integer;
+alter table wvp_media_server
+    add ws_flv_ssl_port integer;
+
+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)
+);
\ No newline at end of file
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-mysql-2.7.0.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.2/\345\210\235\345\247\213\345\214\226-mysql-2.7.2.sql"
similarity index 98%
rename from "\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-mysql-2.7.0.sql"
rename to "\346\225\260\346\215\256\345\272\223/2.7.2/\345\210\235\345\247\213\345\214\226-mysql-2.7.2.sql"
index 48ed8cb..98d4340 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\345\210\235\345\247\213\345\214\226-mysql-2.7.0.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.2/\345\210\235\345\247\213\345\214\226-mysql-2.7.2.sql"
@@ -171,6 +171,7 @@
                                   hook_alive_interval integer,
                                   record_path character varying(255),
                                   record_day integer default 7,
+                                  transcode_suffix character varying(255),
                                   constraint uk_media_server_unique_ip_http_port unique (ip, http_port)
 );
 
@@ -319,6 +320,7 @@
                                     parentId integer,
                                     path character varying(255)
 );
+
 create table wvp_user_api_key (
                                   id serial primary key ,
                                   user_id bigint,
@@ -331,6 +333,7 @@
                                   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');
 INSERT INTO wvp_user_role VALUES (1, 'admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57');
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.0.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.2/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.7.2.sql"
similarity index 98%
rename from "\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.0.sql"
rename to "\346\225\260\346\215\256\345\272\223/2.7.2/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.7.2.sql"
index 78bafe2..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.0.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.2/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.7.2.sql"
@@ -171,6 +171,7 @@
                                   hook_alive_interval integer,
                                   record_path character varying(255),
                                   record_day integer default 7,
+                                  transcode_suffix character varying(255),
                                   constraint uk_media_server_unique_ip_http_port unique (ip, http_port)
 );
 
@@ -319,6 +320,7 @@
                                     parentId integer,
                                     path character varying(255)
 );
+
 create table wvp_user_api_key (
                                   id serial primary key ,
                                   user_id bigint,
@@ -331,6 +333,7 @@
                                   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');
 INSERT INTO wvp_user_role VALUES (1, 'admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57');
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.0.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.2/\346\233\264\346\226\260-mysql-2.7.2.sql"
similarity index 91%
rename from "\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.0.sql"
rename to "\346\225\260\346\215\256\345\272\223/2.7.2/\346\233\264\346\226\260-mysql-2.7.2.sql"
index b43774f..dff8570 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.0.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.2/\346\233\264\346\226\260-mysql-2.7.2.sql"
@@ -1,4 +1,7 @@
 alter table wvp_media_server
+    add transcode_suffix character varying(255);
+
+alter table wvp_media_server
     add  type character varying(50) default 'zlm';
 
 alter table wvp_media_server
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.0.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.2/\346\233\264\346\226\260-postgresql-kingbase-2.7.2.sql"
similarity index 91%
copy from "\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.0.sql"
copy to "\346\225\260\346\215\256\345\272\223/2.7.2/\346\233\264\346\226\260-postgresql-kingbase-2.7.2.sql"
index b43774f..dff8570 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.1/\346\233\264\346\226\260-mysql-2.7.0.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.2/\346\233\264\346\226\260-postgresql-kingbase-2.7.2.sql"
@@ -1,4 +1,7 @@
 alter table wvp_media_server
+    add transcode_suffix character varying(255);
+
+alter table wvp_media_server
     add  type character varying(50) default 'zlm';
 
 alter table wvp_media_server

--
Gitblit v1.8.0