module Invidious::Database::Migrations
  class CreateAnnotationsTable < Migration
    version 7

    def up(conn : DB::Connection)
      conn.exec <<-SQL
      CREATE TABLE IF NOT EXISTS public.annotations
      (
        id text NOT NULL,
        annotations xml,
        CONSTRAINT annotations_id_key UNIQUE (id)
      );
      SQL

      conn.exec <<-SQL
      GRANT ALL ON TABLE public.annotations TO current_user;
      SQL
    end
  end
end