4 DROP FUNCTION IF EXISTS core_enum_seqmax_update;
6 CREATE FUNCTION core_enum_seqmax_update( in_etype varchar(128))
7 RETURNS INT(11) DETERMINISTIC
10 DECLARE v_seqmax INT(11);
11 SELECT MAX(seqid) +1 INTO v_seqmax FROM core_enum WHERE
13 UPDATE core_enum SET seqmax = v_seqmax WHERE etype = in_etype;
22 -- usage: SELECT core_enum_seqmax_update(DISTINCT(etype)) FROM core_enum;
23 DROP TABLE IF EXISTS core_enum_tmp;
24 CREATE TEMPORARY TABLE core_enum_tmp SELECT DISTINCT(etype) FROM core_enum;
25 SELECT core_enum_seqmax_update(etype) FROM core_enum_tmp;
26 DROP TABLE IF EXISTS core_enum_tmp;