Title: Enum Type
Last modified: August 21, 2016

---

# Enum Type

 *  Resolved [MattWilby](https://wordpress.org/support/users/mattwilby/)
 * (@mattwilby)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/enum-type/)
 * Hi, Im using adminer and trying to create a table where one field uses the enum
   type but it keep rejecting it. How/where do I set what the possible options are?
 * currently SQL command example of what I am trying to add
 * ALTER TABLE `Players`
    ADD `Team` enum NOT NULL DEFAULT ”U12s’,’U13s” AFTER `
   Firstname`, COMMENT=”; — 0.000 s
 * Thanks
 * [https://wordpress.org/plugins/adminer/](https://wordpress.org/plugins/adminer/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Frank Bueltge](https://wordpress.org/support/users/bueltge/)
 * (@bueltge)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/enum-type/#post-4866216)
 * I can not help you in this topic. You should ask the question on the [adminer forum](http://sourceforge.net/p/adminer/discussion/960418/).
   This plugin include the Adminer only in WP and is not the right place for functions
   in this topic.

Viewing 1 replies (of 1 total)

The topic ‘Enum Type’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/adminer_efefef.svg)
 * [Adminer](https://wordpress.org/plugins/adminer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/adminer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/adminer/)
 * [Active Topics](https://wordpress.org/support/plugin/adminer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/adminer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/adminer/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Frank Bueltge](https://wordpress.org/support/users/bueltge/)
 * Last activity: [11 years, 11 months ago](https://wordpress.org/support/topic/enum-type/#post-4866216)
 * Status: resolved