summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-09-02 17:03:56 +0200
committerYorhel <git@yorhel.nl>2019-09-02 17:03:59 +0200
commit5fb0ec840484cf59c4a967fee1308f95b958a6d6 (patch)
tree486cac9b3c4546d3497d8108c0bc67a2ae650b6b /util
parent3540b91daae0be093f8fb8825c749be3ead1d8bb (diff)
Minor cleanup of l_wp/l_encubed link code
The fields are still there in order to keep the edit history somewhat sensible, but we don't need this additional code.
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 2983f290..836c597c 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -225,7 +225,7 @@ CREATE TABLE producers ( -- dbentry_type=p
lang language NOT NULL DEFAULT 'ja', -- [pub]
"desc" text NOT NULL DEFAULT '', -- [pub]
alias varchar(500) NOT NULL DEFAULT '', -- [pub]
- l_wp varchar(150), -- [pub]
+ l_wp varchar(150), -- [pub] (deprecated)
rgraph integer, -- relgraphs.id
l_wikidata integer -- [pub]
);
@@ -518,7 +518,7 @@ CREATE TABLE staff ( -- dbentry_type=s
gender gender NOT NULL DEFAULT 'unknown', -- [pub]
lang language NOT NULL DEFAULT 'ja', -- [pub]
"desc" text NOT NULL DEFAULT '', -- [pub]
- l_wp varchar(150) NOT NULL DEFAULT '', -- [pub]
+ l_wp varchar(150) NOT NULL DEFAULT '', -- [pub] (deprecated)
l_site varchar(250) NOT NULL DEFAULT '', -- [pub]
l_twitter varchar(16) NOT NULL DEFAULT '', -- [pub]
l_anidb integer, -- [pub]
@@ -741,8 +741,8 @@ CREATE TABLE vn ( -- dbentry_type=v
img_nsfw boolean NOT NULL DEFAULT FALSE, -- [pub]
image integer NOT NULL DEFAULT 0, -- [pub]
"desc" text NOT NULL DEFAULT '', -- [pub]
- l_wp varchar(150) NOT NULL DEFAULT '', -- [pub]
- l_encubed varchar(100) NOT NULL DEFAULT '', -- [pub]
+ l_wp varchar(150) NOT NULL DEFAULT '', -- [pub] (deprecated)
+ l_encubed varchar(100) NOT NULL DEFAULT '', -- [pub] (deprecated)
l_renai varchar(100) NOT NULL DEFAULT '', -- [pub]
rgraph integer, -- relgraphs.id
c_released integer NOT NULL DEFAULT 0,