From 23beb4fde063b4a648c2a273f17cf5c423fa0ae6 Mon Sep 17 00:00:00 2001
From: leesam <leesam@leesam.cn>
Date: 星期一, 01 四月 2024 09:19:46 +0800
Subject: [PATCH] Merge branch 'master' into develop-add-api-key
---
数据库/初始化-postgresql-kingbase.sql | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git "a/\346\225\260\346\215\256\345\272\223/\345\210\235\345\247\213\345\214\226-postgresql-kingbase.sql" "b/\346\225\260\346\215\256\345\272\223/\345\210\235\345\247\213\345\214\226-postgresql-kingbase.sql"
index ed239c3..17ef270 100644
--- "a/\346\225\260\346\215\256\345\272\223/\345\210\235\345\247\213\345\214\226-postgresql-kingbase.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/\345\210\235\345\247\213\345\214\226-postgresql-kingbase.sql"
@@ -92,6 +92,7 @@
latitude_wgs84 double precision,
business_group_id character varying(50),
gps_time character varying(50),
+ stream_identification character varying(50),
constraint uk_wvp_device_channel_unique_device_channel unique (device_id, channel_id)
);
@@ -261,6 +262,7 @@
create_time character varying(50),
alive_second integer,
media_server_id character varying(50),
+ server_id character varying(50),
push_time character varying(50),
status bool default false,
update_time character varying(50),
@@ -312,7 +314,17 @@
parentId integer,
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