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