summaryrefslogtreecommitdiff
path: root/util/updates/update_1.4.sql
blob: 783c00294ed3c88a775db791dfd8e99418a3887d (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
28
29
30
31
32
33
34
35
36
37
UPDATE vn_categories SET category = 'aaa' WHERE category = 'ami';

--CREATE TABLE changes (
--  id SERIAL NOT NULL PRIMARY KEY,
--  "type" smallint DEFAULT 0 NOT NULL,
--  rel integer DEFAULT 0 NOT NULL,
--  vrel integer DEFAULT 0 NOT NULL,
--  uid integer DEFAULT 0 NOT NULL,
--  status smallint DEFAULT 0 NOT NULL,
--  added bigint DEFAULT 0 NOT NULL,
--  lastmod bigint DEFAULT 0 NOT NULL,
--  changes bytea DEFAULT ''::bytea NOT NULL,
--  comments text DEFAULT '' NOT NULL
--);


CREATE LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION get_new_id() RETURNS integer AS $$
DECLARE
  i integer := 1;
  r RECORD;
BEGIN
  FOR r IN SELECT id FROM vn ORDER BY id ASC LOOP
    IF i <> r.id THEN
      EXIT;
    END IF;
    i := i+1;
  END LOOP;
  RETURN i;
END;
$$ LANGUAGE plpgsql;

ALTER TABLE vn ALTER COLUMN id SET DEFAULT get_new_id();
DROP SEQUENCE vn_id_seq;


ALTER TABLE vnr ADD COLUMN notes varchar(250) DEFAULT '';