song_update_20240417.sql 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. create table fox_account
  2. (
  3. id bigint auto_increment
  4. primary key,
  5. account varchar(255) null,
  6. endpoint varchar(255) null,
  7. api_key varchar(255) not null,
  8. expired int(2) default 0 not null,
  9. songs_left int default 0 not null,
  10. points_update_time datetime null,
  11. status int default 0 not null
  12. );
  13. create table fox_song
  14. (
  15. song_id varchar(64) not null
  16. primary key,
  17. video_url varchar(255) null,
  18. audio_url varchar(255) null,
  19. image_url varchar(255) null,
  20. image_large_url varchar(255) null,
  21. model_name varchar(255) null,
  22. user_id varchar(64) null,
  23. status varchar(64) null,
  24. title varchar(255) null,
  25. meta_tags varchar(255) null,
  26. meta_prompt varchar(5000) default '0' null,
  27. meta_duration double default 0 null,
  28. meta_error_msg varchar(255) default '0' null,
  29. meta_error_type varchar(255) null,
  30. created_time datetime not null on update CURRENT_TIMESTAMP
  31. );
  32. create table fox_song_generate_log
  33. (
  34. task_id varchar(64) not null
  35. primary key,
  36. user_id varchar(64) null,
  37. ssid varchar(64) null,
  38. device_id varchar(64) null,
  39. phone varchar(32) null,
  40. prompt varchar(5000) null,
  41. custom int(2) null,
  42. tags varchar(1000) null,
  43. instrumental int(2) default 0 null,
  44. title varchar(1000) null,
  45. description varchar(1000) null,
  46. song_id varchar(255) null,
  47. start_time datetime null,
  48. send_time datetime null,
  49. handle_time datetime null,
  50. finish_time datetime null,
  51. fail_reason varchar(5000) null
  52. );