summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-08-26 13:31:03 +0200
committerYorhel <git@yorhel.nl>2019-08-26 13:31:36 +0200
commit27ff73213928994e7e1117293c4a751fe99b215b (patch)
tree23ef55a51d44c91eae6d6da83410ff5bac6e80e0 /util/sql
parentf4cbd0c722a92ce249a2a4a74bc153868553847c (diff)
Display shop+price info on VN pages + delete old affiliate code
The current affiliate links format doesn't display as much information as before but it's also a lot less messy.
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/perms.sql2
-rw-r--r--util/sql/schema.sql14
2 files changed, 0 insertions, 16 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql
index a94b7374..440c8354 100644
--- a/util/sql/perms.sql
+++ b/util/sql/perms.sql
@@ -5,7 +5,6 @@ GRANT CONNECT, TEMP ON DATABASE :DBNAME TO vndb_site;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO vndb_site;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO vndb_site;
-GRANT SELECT, INSERT, UPDATE, DELETE ON affiliate_links TO vndb_site;
GRANT SELECT, INSERT ON anime TO vndb_site;
GRANT SELECT, INSERT ON changes TO vndb_site;
GRANT SELECT, INSERT, UPDATE ON chars TO vndb_site;
@@ -99,7 +98,6 @@ GRANT CONNECT, TEMP ON DATABASE :DBNAME TO vndb_multi;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO vndb_multi;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO vndb_multi;
-GRANT SELECT, INSERT, UPDATE ON affiliate_links TO vndb_multi;
GRANT SELECT, UPDATE ON anime TO vndb_multi;
GRANT SELECT ON changes TO vndb_multi;
GRANT SELECT ON chars TO vndb_multi;
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index cb150030..a2ee854a 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -73,20 +73,6 @@ CREATE SEQUENCE charimg_seq;
--- affiliate_links
-CREATE TABLE affiliate_links (
- id SERIAL PRIMARY KEY,
- rid integer NOT NULL,
- hidden boolean NOT NULL DEFAULT false,
- priority smallint NOT NULL DEFAULT 0,
- affiliate smallint NOT NULL DEFAULT 0,
- url varchar NOT NULL,
- version varchar NOT NULL DEFAULT '',
- lastfetch timestamptz,
- price varchar NOT NULL DEFAULT '',
- data varchar NOT NULL DEFAULT ''
-);
-
-- anime
CREATE TABLE anime (
id integer NOT NULL PRIMARY KEY, -- [pub]