{"id":4866052,"date":"2014-04-30T14:23:24","date_gmt":"2014-04-30T14:23:24","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/enum-type\/"},"modified":"2016-08-21T19:54:11","modified_gmt":"2016-08-21T19:54:11","slug":"enum-type","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/enum-type\/","title":{"rendered":"Enum Type"},"content":{"rendered":"<p>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?<\/p>\n<p>currently SQL command example of what I am trying to add<\/p>\n<p>ALTER TABLE <code>Players<\/code><br \/>\nADD <code>Team<\/code> enum NOT NULL DEFAULT &#8221;U12s&#8217;,&#8217;U13s&#8221; AFTER <code>Firstname<\/code>,<br \/>\nCOMMENT=&#8221;; &#8212; 0.000 s<\/p>\n<p>Thanks<\/p>\n<p>https:\/\/wordpress.org\/plugins\/adminer\/<\/p>\n","protected":false},"template":"","class_list":["post-4866052","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4866052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4866052\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4866052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}