use of reserved word in table action_defs
Brought to you by:
hroberts
The newer versions of MySQL (my version is 3.23.27) will not accept
the name 'when' in table action_defs (when enum('before','after') NOT NULL,).
I changed it to e_when and the creation went ok!
Then I had to replace some php3 files calling 'when' to 'e_when'
Maybe the other enum in that table, 'trigger' will stop working in a later version
og MySQL ?
It is not a good practice to use potentially reserved words in tables ;-)
O.J.
Ole.J.Utnes@hive.no
(- sorry I did not log inn before submitting this)