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 '';
|