playlist_videos.sql 411 B

1234567891011121314151617181920
  1. -- Table: public.playlist_videos
  2. -- DROP TABLE public.playlist_videos;
  3. CREATE TABLE IF NOT EXISTS public.playlist_videos
  4. (
  5. title text,
  6. id text,
  7. author text,
  8. ucid text,
  9. length_seconds integer,
  10. published timestamptz,
  11. plid text references playlists(id),
  12. index int8,
  13. live_now boolean,
  14. PRIMARY KEY (index,plid)
  15. );
  16. GRANT ALL ON TABLE public.playlist_videos TO current_user;