diff options
Diffstat (limited to 'util/updates/update_1.8.sql')
-rw-r--r-- | util/updates/update_1.8.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/util/updates/update_1.8.sql b/util/updates/update_1.8.sql new file mode 100644 index 00000000..b9e58ae6 --- /dev/null +++ b/util/updates/update_1.8.sql @@ -0,0 +1,27 @@ +ALTER TABLE vn ADD COLUMN length smallint NOT NULL DEFAULT 0; + +DELETE FROM vn_categories WHERE SUBSTR(category, 1, 1) = 'a'; +ALTER TABLE vnr ADD COLUMN minage smallint NOT NULL DEFAULT -1; + +ALTER TABLE vn ADD COLUMN l_wp varchar(150) NOT NULL DEFAULT ''; +ALTER TABLE vn ADD COLUMN l_cisv integer NOT NULL DEFAULT 0; + + +UPDATE vn SET + c_released = COALESCE(( + SELECT SUBSTRING(COALESCE(MIN(released), '0000-00') from 1 for 7) + FROM vnr r1 + WHERE r1.vid = vn.id + AND r1.r_rel = 0 + AND r1.relation NOT ILIKE 'trial' + GROUP BY r1.vid + ), '0000-00'), + c_languages = COALESCE(ARRAY_TO_STRING(ARRAY( + SELECT language + FROM vnr r2 + WHERE r2.vid = vn.id + AND r2.r_rel = 0 + AND r2.relation NOT ILIKE 'trial' + GROUP BY language + ORDER BY language + ), '/'), ''); |