summaryrefslogtreecommitdiffstats
path: root/config/sql/channels.sql
diff options
context:
space:
mode:
Diffstat (limited to 'config/sql/channels.sql')
-rw-r--r--config/sql/channels.sql23
1 files changed, 10 insertions, 13 deletions
diff --git a/config/sql/channels.sql b/config/sql/channels.sql
index a328bcad..c4259c12 100644
--- a/config/sql/channels.sql
+++ b/config/sql/channels.sql
@@ -4,23 +4,20 @@
CREATE TABLE public.channels
(
- id text COLLATE pg_catalog."default" NOT NULL,
- author text COLLATE pg_catalog."default",
- updated timestamp with time zone,
- CONSTRAINT channels_id_key UNIQUE (id)
-)
-WITH (
- OIDS = FALSE
-)
-TABLESPACE pg_default;
+ id text NOT NULL,
+ author text,
+ updated timestamp with time zone,
+ CONSTRAINT channels_id_key UNIQUE (id)
+);
GRANT ALL ON TABLE public.channels TO kemal;
--- Index: channels_id_idx
+-- Index: public.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
+ ON public.channels
+ USING btree
+ (id COLLATE pg_catalog."default");
+