diff options
Diffstat (limited to 'util')
| -rw-r--r-- | util/dump.sql | 3 | ||||
| -rw-r--r-- | util/updates/update_2.3.sql | 5 |
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 ''; + |