diff options
author | Yorhel <git@yorhel.nl> | 2019-08-26 13:31:03 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-26 13:31:36 +0200 |
commit | 27ff73213928994e7e1117293c4a751fe99b215b (patch) | |
tree | 23ef55a51d44c91eae6d6da83410ff5bac6e80e0 /util/sql | |
parent | f4cbd0c722a92ce249a2a4a74bc153868553847c (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.sql | 2 | ||||
-rw-r--r-- | util/sql/schema.sql | 14 |
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] |