summaryrefslogtreecommitdiffstats
path: root/config/sql
diff options
context:
space:
mode:
authorOmar Roth <omarroth@hotmail.com>2019-04-15 11:13:09 -0500
committerOmar Roth <omarroth@hotmail.com>2019-04-15 11:13:09 -0500
commit3bcb98e644bfeb0ae4127a4749051b2f05fdba8b (patch)
treea54f84dc36afa6757dc093c8062f520e6f7fb80e /config/sql
parent2deb436ccdf5b0bdd86bac251d3ec3dab2664983 (diff)
downloadinvidious-3bcb98e644bfeb0ae4127a4749051b2f05fdba8b.tar.gz
invidious-3bcb98e644bfeb0ae4127a4749051b2f05fdba8b.tar.bz2
invidious-3bcb98e644bfeb0ae4127a4749051b2f05fdba8b.zip
Add config option to cache annotations from IA
Diffstat (limited to 'config/sql')
-rw-r--r--config/sql/annotations.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/config/sql/annotations.sql b/config/sql/annotations.sql
new file mode 100644
index 00000000..4ea077e7
--- /dev/null
+++ b/config/sql/annotations.sql
@@ -0,0 +1,12 @@
+-- Table: public.annotations
+
+-- DROP TABLE public.annotations;
+
+CREATE TABLE public.annotations
+(
+ id text NOT NULL,
+ annotations xml,
+ CONSTRAINT annotations_id_key UNIQUE (id)
+);
+
+GRANT ALL ON TABLE public.annotations TO kemal;