diff options
| author | Yorhel <git@yorhel.nl> | 2009-11-14 11:51:31 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-11-14 11:51:31 +0100 |
| commit | aef1e3f073df3494711e949eb2aa31c60cad8460 (patch) | |
| tree | ab796d96e7de3147de8c8a568858fb03a8f1f1e9 /util | |
| parent | 0a4f97f0186d6941a4cab2e3bd05201f1fed1441 (diff) | |
Added wikipedia links for producers
Diffstat (limited to 'util')
| -rw-r--r-- | util/dump.sql | 3 | ||||
| -rw-r--r-- | util/updates/update_2.9.sql | 4 |
2 files changed, 6 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql index 8edf56c5..dfdeb021 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -69,7 +69,8 @@ CREATE TABLE producers_rev ( website varchar(250) NOT NULL DEFAULT '', lang varchar NOT NULL DEFAULT 'ja', "desc" text NOT NULL DEFAULT '', - alias varchar(500) NOT NULL DEFAULT '' + alias varchar(500) NOT NULL DEFAULT '', + l_wp varchar(150) ); -- quotes diff --git a/util/updates/update_2.9.sql b/util/updates/update_2.9.sql index 4321f898..9bb00979 100644 --- a/util/updates/update_2.9.sql +++ b/util/updates/update_2.9.sql @@ -38,3 +38,7 @@ ALTER TABLE releases_rev ALTER COLUMN minage DROP NOT NULL; ALTER TABLE releases_rev ALTER COLUMN minage DROP DEFAULT; UPDATE releases_rev SET minage = NULL WHERE minage < 0; + +-- wikipedia link for producers +ALTER TABLE producers_rev ADD COLUMN l_wp varchar(150); + |