1 files changed, 37 insertions, 0 deletions
diff --git a/util/updates/update_1.4.sql b/util/updates/update_1.4.sql
new file mode 100644
index 00000000..783c0029
--- /dev/null
+++ b/util/updates/update_1.4.sql
@@ -0,0 +1,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 '';