util/updates/2022-08-03-tags_vn_direct.sql


1
2
3
4
5
6
7
8
9
10

CREATE TABLE tags_vn_direct (
  tag     vndbid NOT NULL,
  vid     vndbid NOT NULL,
  rating  real NOT NULL,
  spoiler smallint NOT NULL,
  lie     boolean NOT NULL
);
\i sql/func.sql
\i sql/perms.sql
SELECT tag_vn_calc(NULL);