summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2014-12-02 11:39:35 +0100
committerYorhel <git@yorhel.nl>2014-12-02 11:39:35 +0100
commit65db0718f4a3e42930dbf660068c1c309d47b08a (patch)
tree2a47031435820efa88e9aa5a804c60faf9ce829d /util/sql
parent42e5a4793fc02ef54805ab5706830bbb2e1bd086 (diff)
Completely drop l_vnn column from VN info
Used to link to a visual-novels.net review or something. Links have been hidden and dead since ages. No need to keep the column around.
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/func.sql4
-rw-r--r--util/sql/schema.sql1
2 files changed, 2 insertions, 3 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql
index 4bcc8d99..360f52f6 100644
--- a/util/sql/func.sql
+++ b/util/sql/func.sql
@@ -275,7 +275,7 @@ BEGIN
INSERT INTO edit_vn DEFAULT VALUES;
-- otherwise, load revision
ELSE
- INSERT INTO edit_vn SELECT title, alias, img_nsfw, length, "desc", l_wp, l_vnn, image, l_encubed, l_renai, original FROM vn_rev WHERE id = cid;
+ INSERT INTO edit_vn SELECT title, alias, img_nsfw, length, "desc", l_wp, image, l_encubed, l_renai, original FROM vn_rev WHERE id = cid;
INSERT INTO edit_vn_anime SELECT aid FROM vn_anime WHERE vid = cid;
INSERT INTO edit_vn_relations SELECT vid2, relation, official FROM vn_relations WHERE vid1 = cid;
INSERT INTO edit_vn_screenshots SELECT scr, nsfw, rid FROM vn_screenshots WHERE vid = cid;
@@ -293,7 +293,7 @@ BEGIN
RAISE 'edit_vn must have exactly one row!';
END IF;
SELECT INTO r * FROM edit_commit();
- INSERT INTO vn_rev SELECT r.cid, r.iid, title, alias, img_nsfw, length, "desc", l_wp, l_vnn, image, l_encubed, l_renai, original FROM edit_vn;
+ INSERT INTO vn_rev SELECT r.cid, r.iid, title, alias, img_nsfw, length, "desc", l_wp, image, l_encubed, l_renai, original FROM edit_vn;
INSERT INTO vn_anime SELECT r.cid, aid FROM edit_vn_anime;
INSERT INTO vn_relations SELECT r.cid, vid, relation, official FROM edit_vn_relations;
INSERT INTO vn_screenshots SELECT r.cid, scr, nsfw, rid FROM edit_vn_screenshots;
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 32561dc9..a3bb29b0 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -439,7 +439,6 @@ CREATE TABLE vn_rev (
length smallint NOT NULL DEFAULT 0,
"desc" text NOT NULL DEFAULT '',
l_wp varchar(150) NOT NULL DEFAULT '',
- l_vnn integer NOT NULL DEFAULT 0,
image integer NOT NULL DEFAULT 0,
l_encubed varchar(100) NOT NULL DEFAULT '',
l_renai varchar(100) NOT NULL DEFAULT '',