blob: b9e58ae631b105f4c6effb8378b73fa6a005bfa0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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
), '/'), '');
|