2.6.9更新.sql 946 B

12345678910111213141516171819202122232425262728293031323334
  1. alter table wvp_device_channel
  2. change stream_id stream_id varying(255)
  3. alter table wvp_platform
  4. add auto_push_channel bool default false
  5. alter table wvp_stream_proxy
  6. add stream_key character varying(255)
  7. create table wvp_cloud_record (
  8. id serial primary key,
  9. app character varying(255),
  10. stream character varying(255),
  11. call_id character varying(255),
  12. start_time integer,
  13. end_time integer,
  14. media_server_id character varying(50),
  15. file_name character varying(255),
  16. folder character varying(255),
  17. file_path character varying(255),
  18. collect bool default false,
  19. reserve bool default false,
  20. file_size integer,
  21. time_len integer,
  22. constraint uk_stream_push_app_stream_path unique (app, stream, file_path)
  23. );
  24. alter table wvp_media_server
  25. add record_path character varying(255);
  26. alter table wvp_media_server
  27. add record_date integer default 7;