summaryrefslogtreecommitdiff
path: root/invidious/config/sql/annotations.sql
diff options
context:
space:
mode:
Diffstat (limited to 'invidious/config/sql/annotations.sql')
-rw-r--r--invidious/config/sql/annotations.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/invidious/config/sql/annotations.sql b/invidious/config/sql/annotations.sql
new file mode 100644
index 0000000..3705829
--- /dev/null
+++ b/invidious/config/sql/annotations.sql
@@ -0,0 +1,12 @@
+-- Table: public.annotations
+
+-- DROP TABLE public.annotations;
+
+CREATE TABLE IF NOT EXISTS public.annotations
+(
+ id text NOT NULL,
+ annotations xml,
+ CONSTRAINT annotations_id_key UNIQUE (id)
+);
+
+GRANT ALL ON TABLE public.annotations TO current_user;