summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-02-21 19:00:12 +0100
committerYorhel <git@yorhel.nl>2009-02-21 19:00:12 +0100
commitd03465b573c10b10819201bba8257e59362589f1 (patch)
tree20a33650240526978f7557b07cb262fe0d53af14 /util
parent6ac451d39e12f5960ca5a5aed6be6fb1c4532ca8 (diff)
Aliases field to producer entries
Diffstat (limited to 'util')
-rw-r--r--util/dump.sql3
-rw-r--r--util/updates/update_2.3.sql5
2 files changed, 7 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 470a8aeb..e3652a0f 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -58,7 +58,8 @@ CREATE TABLE producers_rev (
original varchar(200) NOT NULL DEFAULT '',
website varchar(250) NOT NULL DEFAULT '',
lang varchar NOT NULL DEFAULT 'ja',
- "desc" text NOT NULL DEFAULT ''
+ "desc" text NOT NULL DEFAULT '',
+ alias varchar(500) NOT NULL DEFAULT ''
);
diff --git a/util/updates/update_2.3.sql b/util/updates/update_2.3.sql
index d43718c9..21db32ca 100644
--- a/util/updates/update_2.3.sql
+++ b/util/updates/update_2.3.sql
@@ -9,3 +9,8 @@ CREATE TABLE quotes (
-- catalog numbers for releases
ALTER TABLE releases_rev ADD COLUMN catalog varchar(50) NOT NULL DEFAULT '';
+
+
+-- aliases field for producers
+ALTER TABLE producers_rev ADD COLUMN alias varchar(500) NOT NULL DEFAULT '';
+