=== modified file 'resources/sql/div.sql' --- resources/sql/div.sql 2013-12-29 17:27:07 +0000 +++ resources/sql/div.sql 2014-02-04 14:12:45 +0000 @@ -208,6 +208,10 @@ created = (created + interval '1 year'), lastupdated = (lastupdated + interval '1 year'); +-- Replace first digit in invalid uid with letter a + +update organisationunit set uid = regexp_replace(uid,'\d','a') where uid SIMILAR TO '[0-9]%'; + -- (Write) Insert random org unit codes create function setrandomcode() returns integer AS $$