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