Alex,
I had problems trying to add an Enum through the built in table editor, using standard MySQL syntax:
Failed to execute query: 'ALTER TABLE Links ADD COLUMN isLive ENUM('\'No\', \'Yes\'') DEFAULT '\'No\''' Reason: Invalid default value for 'isLive'
Where the enum values were 'No', 'Yes' and the default was both - No and 'No' (neither worked).
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
I had problems trying to add an Enum through the built in table editor, using standard MySQL syntax:
Failed to execute query: 'ALTER TABLE Links ADD COLUMN isLive ENUM('\'No\', \'Yes\'') DEFAULT '\'No\''' Reason: Invalid default value for 'isLive'
Where the enum values were 'No', 'Yes' and the default was both - No and 'No' (neither worked).
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ