From e11671a1fbbf2ba7cdc0ebe0915b7cc8168afb3f Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期二, 24 十月 2023 18:20:24 +0800
Subject: [PATCH] 优化sql
---
sql/2.6.9更新-postgresql-kingbase.sql | 14 +++++++-------
sql/2.6.9更新-mysql.sql | 14 +++++++-------
2 files changed, 14 insertions(+), 14 deletions(-)
diff --git "a/sql/2.6.9\346\233\264\346\226\260.sql" "b/sql/2.6.9\346\233\264\346\226\260-mysql.sql"
similarity index 74%
copy from "sql/2.6.9\346\233\264\346\226\260.sql"
copy to "sql/2.6.9\346\233\264\346\226\260-mysql.sql"
index 6532d32..15b9e27 100644
--- "a/sql/2.6.9\346\233\264\346\226\260.sql"
+++ "b/sql/2.6.9\346\233\264\346\226\260-mysql.sql"
@@ -1,27 +1,27 @@
alter table wvp_device_channel
- change stream_id stream_id varying(255)
+ change stream_id stream_id character varying(255);
alter table wvp_platform
- add auto_push_channel bool default false
+ add auto_push_channel bool default false;
alter table wvp_stream_proxy
- add stream_key character varying(255)
+ add stream_key character varying(255);
create table wvp_cloud_record (
id serial primary key,
app character varying(255),
stream character varying(255),
call_id character varying(255),
- start_time integer,
- end_time integer,
+ start_time bigint,
+ end_time bigint,
media_server_id character varying(50),
file_name character varying(255),
folder character varying(255),
file_path character varying(255),
collect bool default false,
reserve bool default false,
- file_size integer,
- time_len integer,
+ file_size bigint,
+ time_len bigint,
constraint uk_stream_push_app_stream_path unique (app, stream, file_path)
);
diff --git "a/sql/2.6.9\346\233\264\346\226\260.sql" "b/sql/2.6.9\346\233\264\346\226\260-postgresql-kingbase.sql"
similarity index 75%
rename from "sql/2.6.9\346\233\264\346\226\260.sql"
rename to "sql/2.6.9\346\233\264\346\226\260-postgresql-kingbase.sql"
index 6532d32..9681052 100644
--- "a/sql/2.6.9\346\233\264\346\226\260.sql"
+++ "b/sql/2.6.9\346\233\264\346\226\260-postgresql-kingbase.sql"
@@ -1,27 +1,27 @@
alter table wvp_device_channel
- change stream_id stream_id varying(255)
+ rename "stream_id" to stream_id ;
alter table wvp_platform
- add auto_push_channel bool default false
+ add auto_push_channel bool default false;
alter table wvp_stream_proxy
- add stream_key character varying(255)
+ add stream_key character varying(255);
create table wvp_cloud_record (
id serial primary key,
app character varying(255),
stream character varying(255),
call_id character varying(255),
- start_time integer,
- end_time integer,
+ start_time int8,
+ end_time int8,
media_server_id character varying(50),
file_name character varying(255),
folder character varying(255),
file_path character varying(255),
collect bool default false,
reserve bool default false,
- file_size integer,
- time_len integer,
+ file_size int8,
+ time_len int8,
constraint uk_stream_push_app_stream_path unique (app, stream, file_path)
);
--
Gitblit v1.8.0