diff options
author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-06-15 07:37:37 +0000 |
---|---|---|
committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-06-15 07:37:37 +0000 |
commit | dfcfb4a402dcfbc1b1873c5ead08584c3e71a5c6 (patch) | |
tree | 816ed80e180bc818d245be54ea90111f59d7ab86 /util | |
parent | f8b467a1a6cff156a55770642e34a1d5c0142079 (diff) |
Permenantly removed the CISV link, added links to renai.us and encubed, and small bugfix in the VNDBID pattern matching
git-svn-id: svn://vndb.org/vndb@28 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/update_1.17.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_1.17.sql b/util/updates/update_1.17.sql index 6cf2a077..bba26069 100644 --- a/util/updates/update_1.17.sql +++ b/util/updates/update_1.17.sql @@ -3,3 +3,8 @@ ALTER TABLE releases_rev ADD COLUMN gtin bigint NOT NULL DEFAULT 0; +-- Permanently delete the CISV link and add links to encubed and renai.us +ALTER TABLE vn_rev DROP COLUMN l_cisv; +ALTER TABLE vn_rev ADD COLUMN l_encubed varchar(100) NOT NULL DEFAULT ''; +ALTER TABLE vn_rev ADD COLUMN l_renai varchar(100) NOT NULL DEFAULT ''; + |