Manual talk:Image table

Remove Enums

 * Just an idea, from a MS-SQL 2008 dba, why not remove the overhead of the ENUM field types (media_type & major_mime) and make them a reference type to a table, maybe called 'enums', or whatever name you choose. You could consolidate all your ENUM field types out of the tables and into this one single repository.
 * Maybe have a signatures such as, for the enum table:


 * id: (INT ? SMALLINT) control field, either auto-increment or value controlled through system.
 * type: (VARCHAR(50)) identifying type (such as 'media_type', 'major_mime')
 * value: (VARCHAR(255)) value the type could have
 * Just a thought as a future-dev.
 * Goldbishop 06:20, 27 February 2011 (UTC)