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/初始化-mysql-2.6.9.sql | 8 ++++---- sql/old/clean.sql | 0 sql/更新-postgresql-kingbase-2.6.9.sql | 0 sql/old/2.6.8补丁更新.sql | 0 sql/old/2.6.6-2.6.7更新.sql | 0 sql/old/2.6.8升级2.6.9.sql | 0 sql/更新-mysql-2.6.9.sql | 0 sql/初始化-postgresql-kingbase-2.6.9.sql | 8 ++++---- 8 files changed, 8 insertions(+), 8 deletions(-) diff --git "a/sql/2.6.6-2.6.7\346\233\264\346\226\260.sql" "b/sql/old/2.6.6-2.6.7\346\233\264\346\226\260.sql" similarity index 100% rename from "sql/2.6.6-2.6.7\346\233\264\346\226\260.sql" rename to "sql/old/2.6.6-2.6.7\346\233\264\346\226\260.sql" diff --git "a/sql/2.6.8\345\215\207\347\272\2472.6.9.sql" "b/sql/old/2.6.8\345\215\207\347\272\2472.6.9.sql" similarity index 100% rename from "sql/2.6.8\345\215\207\347\272\2472.6.9.sql" rename to "sql/old/2.6.8\345\215\207\347\272\2472.6.9.sql" diff --git "a/sql/2.6.8\350\241\245\344\270\201\346\233\264\346\226\260.sql" "b/sql/old/2.6.8\350\241\245\344\270\201\346\233\264\346\226\260.sql" similarity index 100% rename from "sql/2.6.8\350\241\245\344\270\201\346\233\264\346\226\260.sql" rename to "sql/old/2.6.8\350\241\245\344\270\201\346\233\264\346\226\260.sql" diff --git a/sql/clean.sql b/sql/old/clean.sql similarity index 100% rename from sql/clean.sql rename to sql/old/clean.sql 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-mysql-2.6.9.sql" similarity index 98% rename from "sql/\345\210\235\345\247\213\345\214\226.sql" rename to "sql/\345\210\235\345\247\213\345\214\226-mysql-2.6.9.sql" index 9a90db7..78f9e9a 100644 --- "a/sql/\345\210\235\345\247\213\345\214\226.sql" +++ "b/sql/\345\210\235\345\247\213\345\214\226-mysql-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 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 float, + file_size bigint, + time_len bigint, constraint uk_stream_push_app_stream_path unique (app, stream, file_path) ); 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) ); diff --git "a/sql/2.6.9\346\233\264\346\226\260-mysql.sql" "b/sql/\346\233\264\346\226\260-mysql-2.6.9.sql" similarity index 100% rename from "sql/2.6.9\346\233\264\346\226\260-mysql.sql" rename to "sql/\346\233\264\346\226\260-mysql-2.6.9.sql" diff --git "a/sql/2.6.9\346\233\264\346\226\260-postgresql-kingbase.sql" "b/sql/\346\233\264\346\226\260-postgresql-kingbase-2.6.9.sql" similarity index 100% rename from "sql/2.6.9\346\233\264\346\226\260-postgresql-kingbase.sql" rename to "sql/\346\233\264\346\226\260-postgresql-kingbase-2.6.9.sql" -- Gitblit v1.8.0