From a01295603af6ef75776bdee328c9df18b1a9a9f2 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期五, 03 十一月 2023 17:32:37 +0800 Subject: [PATCH] 简化配置 --- sql/初始化.sql | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git "a/sql/\345\210\235\345\247\213\345\214\226.sql" "b/sql/\345\210\235\345\247\213\345\214\226.sql" index 273da91..b95dd87 100644 --- "a/sql/\345\210\235\345\247\213\345\214\226.sql" +++ "b/sql/\345\210\235\345\247\213\345\214\226.sql" @@ -79,7 +79,7 @@ custom_longitude double precision, latitude double precision, custom_latitude double precision, - stream_id character varying(50), + stream_id character varying(255), device_id character varying(50) not null, parental character varying(50), has_audio bool default false, @@ -194,6 +194,7 @@ create_time character varying(50), update_time character varying(50), as_message_channel bool default false, + auto_push_channel bool default false, constraint uk_platform_unique_server_gb_id unique (server_gb_id) ); @@ -243,6 +244,7 @@ create_time character varying(50), name character varying(255), update_time character varying(50), + stream_key character varying(255), enable_disable_none_reader bool default false, constraint uk_stream_proxy_app_stream unique (app, stream) ); @@ -283,7 +285,6 @@ create_time character varying(50), update_time character varying(50) ); - create table wvp_resources_tree ( id serial primary key , is_catalog bool default true, @@ -294,6 +295,7 @@ path character varying(255) ); + /*鍒濆鏁版嵁*/ 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'); -- Gitblit v1.8.0