Add ENUM support for MySQL

[anonymous]

implement enum type, ie

<?xml version="1.0" encoding="ISO-8859-1"?>
<database name="bookstore">
  <table name="book">
    <column name="book_id" type="INTEGER" required="true" primaryKey="true"/>
	   <column name="title" type="VARCHAR" size="50" required="true" />
	   <column name="categories" type="ENUM" values="bla, blabla, blablabla" required="true" />
  </table>
</database>

[david]

Please open a seperate ticket for each feature request, bug report etc.

Note that ENUM is MySQL only. You may use one-to-many relationships to achieve the same thing.

[chjunior@…]

ENUM is mysql, for postgresql you can use a simple check constraint, and I think that is the same for Oracle and MSSQL, so I think that it can be implemented.

When using a check constraint, the column datatype can be a varchar, that the maxlength is the number of chars of the biggest possible ENUM values.

[hans]

I'll see if we can't get some basic ENUM support for 1.3. It sounds possible, but there are some unanswered questions like how to represent the values, etc. (obviously we'd have to adjust the schema).

[hans]

I changed the summary and removed the request for updated validator documentation from the ticket (since this has been done).

[mahmoud.kassem@…]

Just wanted to add that postgresql 8.3 supports enum. Please check postgresql people planet for more information.

This might be a good reason to increase the speed of adding enum to propel.

[hans]

Note that this can be done with @sqlType:

<column name="enum_col" type="VARCHAR" size="32" sqlType="ENUM"/>

Also, see #462 for a duplicate ticket which includes patches (which, however, likely won't be applied given that you can workaround this issue easily).

[anonymous]

Replying to hans:

Note that this can be done with @sqlType: {{{ #!xml <column name="enum_col" type="VARCHAR" size="32" sqlType="ENUM"/> }}} Also, see #462 for a duplicate ticket which includes patches (which, however, likely won't be applied given that you can workaround this issue easily).

I think the example can be better writed as:

<column name="enum_col" type="varchar(2)" sqlType="ENUM('a','b','c')"/>

[Frank]

But has any little atom,

While a-sittin' and a-splittin',

Ever stopped to think or CARE

That E = m c**2 ?

 ordina cialis  http://compraviagraitalia.com/  vendita viagra originale  http://compraviagraitalia.com/notizie/index.php?entry=entry090309-084357

 fioricet worldwide shipping

 http://headachetreatment.net/fioricet_side_effects.html  ordinazione viagra generico in italia  http://compraviagraitalia.com/it/item/generic_viagra.html

 tramadol overnight shipping

 http://relievepain.org/tramadol-news/index.php?entry=entry090120-193241