projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
bd5b8f7
)
DataObjects/core_functions.sql
author
Alan Knowles
<alan@roojs.com>
Sat, 28 Jan 2012 08:30:38 +0000
(16:30 +0800)
committer
Alan Knowles
<alan@roojs.com>
Sat, 28 Jan 2012 08:30:38 +0000
(16:30 +0800)
DataObjects/core_functions.sql
patch
|
blob
|
history
diff --git
a/DataObjects/core_functions.sql
b/DataObjects/core_functions.sql
index
58450f4
..
d35ce1e
100644
(file)
--- a/
DataObjects/core_functions.sql
+++ b/
DataObjects/core_functions.sql
@@
-30,4
+30,8
@@
BEGIN
END $$
DELIMITER ;
--- usage: SELECT core_enum_seqmax_update(DISTINCT(etype)) FROM core_enum;
\ No newline at end of file
+-- usage: SELECT core_enum_seqmax_update(DISTINCT(etype)) FROM core_enum;
+DROP TABLE IF EXISTS core_enum_tmp;
+CREATE TEMPORARY TABLE core_enum_tmp SELECT DISTINCT(etype) FROM core_enum;
+SELECT core_enum_seqmax_update(etype) FROM core_enum_tmp;
+DROP TABLE IF EXISTS core_enum_tmp;
\ No newline at end of file