-- Required DB modifications to go from 
-- the PATCHED latest official release to current version.
-- 
-- $Id: db_mods.sql,v 1.4 2003/07/17 21:14:13 andr Exp $

-- ################################################################
--in db18: 
--in db18: -- Fix broken query with "x = NULL" condition for Postgres 7.2
--in db18: 
--in db18: DROP FUNCTION sernum2id(integer);
--in db18: CREATE FUNCTION "sernum2id" (integer) RETURNS integer AS 'select 
--in db18:            CASE WHEN iscustomid($1) IS NULL
--in db18: 		THEN NULL
--in db18:            	WHEN iscustomid($1)
--in db18: 		THEN find_customid($1)
--in db18: 		ELSE $1
--in db18: 	   END
--in db18: 	from custom_id;' LANGUAGE 'sql';
--in db18: 
-- ################################################################
-- 2003-07-11 AG: rename target module types, since we'll probably
--                stay with asymmetric target.
-- applied to db18 20030711: 
-- applied to db18 20030711: UPDATE chamber_mod_types SET description='Symmetric target' WHERE type=53;
-- applied to db18 20030711: UPDATE chamber_mod_types SET description='Target' WHERE type=54;
-- applied to db18 20030711: 
-- ################################################################
-- EOF
