summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-08-08 14:30:29 +0200
committerYorhel <git@yorhel.nl>2009-08-08 14:50:13 +0200
commit3c0db27f773f99b325dcc7c6a7c7d1c5bbfb69a9 (patch)
tree47e94570f74f2007cc67d36c23be1bd2426fa013 /util/dump.sql
parent56e1cdc886144b85ede74c15d1ced116c790f7c2 (diff)
Convert old category relations to tags and remove vn_categories
This will currently generate a 500 error for VN pages, because they still try to look something up in the vn_categories table. Will fix that soon. Obviously, this conversion script only works on the actual VNDB database, if you run your own VNDB you can safely ignore the INSERT error when executing update_2.6.sql.
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql9
1 files changed, 0 insertions, 9 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 3a470102..acd639d5 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -287,14 +287,6 @@ CREATE TABLE vn_anime (
PRIMARY KEY(vid, aid)
);
--- vn_categories
-CREATE TABLE vn_categories (
- vid integer NOT NULL DEFAULT 0,
- cat character(3) NOT NULL DEFAULT '',
- lvl smallint NOT NULL DEFAULT 3,
- PRIMARY KEY(vid, cat)
-);
-
-- vn_relations
CREATE TABLE vn_relations (
vid1 integer NOT NULL DEFAULT 0,
@@ -390,7 +382,6 @@ ALTER TABLE vn ADD FOREIGN KEY (latest) REFERENCES vn_rev
ALTER TABLE vn ADD FOREIGN KEY (rgraph) REFERENCES relgraph (id);
ALTER TABLE vn_anime ADD FOREIGN KEY (aid) REFERENCES anime (id);
ALTER TABLE vn_anime ADD FOREIGN KEY (vid) REFERENCES vn_rev (id);
-ALTER TABLE vn_categories ADD FOREIGN KEY (vid) REFERENCES vn_rev (id);
ALTER TABLE vn_relations ADD FOREIGN KEY (vid1) REFERENCES vn_rev (id);
ALTER TABLE vn_relations ADD FOREIGN KEY (vid2) REFERENCES vn (id);
ALTER TABLE vn_rev ADD FOREIGN KEY (id) REFERENCES changes (id);