diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-03-29 21:41:05 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-03-29 21:41:05 -0500 |
| commit | 6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6 (patch) | |
| tree | 77247323e793eed364769595334ead760516f660 /config/sql/channels.sql | |
| parent | 4a7fc4ea697b238098145cad20b21dee7c04bbd3 (diff) | |
| download | invidious-6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6.tar.gz invidious-6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6.tar.bz2 invidious-6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6.zip | |
Add users table
Diffstat (limited to 'config/sql/channels.sql')
| -rw-r--r-- | config/sql/channels.sql | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/config/sql/channels.sql b/config/sql/channels.sql index d24329f3..a328bcad 100644 --- a/config/sql/channels.sql +++ b/config/sql/channels.sql @@ -6,7 +6,8 @@ CREATE TABLE public.channels ( id text COLLATE pg_catalog."default" NOT NULL, author text COLLATE pg_catalog."default", - updated timestamp with time zone + updated timestamp with time zone, + CONSTRAINT channels_id_key UNIQUE (id) ) WITH ( OIDS = FALSE @@ -14,3 +15,12 @@ WITH ( TABLESPACE pg_default; GRANT ALL ON TABLE public.channels TO kemal; + +-- Index: channels_id_idx + +-- DROP INDEX public.channels_id_idx; + +CREATE INDEX channels_id_idx + ON public.channels USING btree + (id COLLATE pg_catalog."default") + TABLESPACE pg_default;
\ No newline at end of file |