From cccfdace5b0af0c38627dbdce84b9c650b6c2082 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期三, 25 十月 2023 10:11:33 +0800 Subject: [PATCH] 优化sql --- sql/初始化-postgresql-kingbase-2.6.9.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 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-postgresql-kingbase-2.6.9.sql" similarity index 98% copy from "sql/\345\210\235\345\247\213\345\214\226.sql" copy to "sql/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.6.9.sql" index 9a90db7..97a3694 100644 --- "a/sql/\345\210\235\345\247\213\345\214\226.sql" +++ "b/sql/\345\210\235\345\247\213\345\214\226-postgresql-kingbase-2.6.9.sql" @@ -273,16 +273,16 @@ 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 float, + file_size int8, + time_len int8, constraint uk_stream_push_app_stream_path unique (app, stream, file_path) ); -- Gitblit v1.8.0