优化sql

648540858

2023-10-25 cccfdace5b0af0c38627dbdce84b9c650b6c2082

优化sql

 sql/old/2.6.6-2.6.7更新.sql

 sql/old/2.6.8升级2.6.9.sql

 sql/old/2.6.8补丁更新.sql

 sql/old/clean.sql

 sql/初始化-mysql-2.6.9.sql

File was renamed from sql/初始化.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)
);


 sql/初始化-postgresql-kingbase-2.6.9.sql

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"
File was copied from sql/初始化.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)
);


 sql/更新-mysql-2.6.9.sql

 sql/更新-postgresql-kingbase-2.6.9.sql