channels.sql 427 B

123456789101112131415161718192021222324
  1. -- Table: public.channels
  2. -- DROP TABLE public.channels;
  3. CREATE TABLE public.channels
  4. (
  5. id text NOT NULL,
  6. author text,
  7. updated timestamp with time zone,
  8. CONSTRAINT channels_id_key UNIQUE (id)
  9. );
  10. GRANT ALL ON TABLE public.channels TO kemal;
  11. -- Index: public.channels_id_idx
  12. -- DROP INDEX public.channels_id_idx;
  13. CREATE INDEX channels_id_idx
  14. ON public.channels
  15. USING btree
  16. (id COLLATE pg_catalog."default");