Ticket #462 (closed enhancement: wontfix)

Opened 3 years ago

Last modified 3 years ago

more datatypes for mysql

Reported by: propel@… Owned by: hans
Priority: normal Milestone: 1.3
Component: Generator Version: devel
Severity: normal Keywords: datatype
Cc:

Description

it would be very nice to have some additional datatypes in generator AND runtime, e.g. ENUM, SET, TEXT, MEDIUMTEXT, LONGTEXT, MEDIUMINT and LONGBLOB. specially to permit using this datatypes on schema.xml with DBDesigner.

patch for "1.3/runtime/classes/propel/util/PropelColumnTypes.php" is included

Attachments

PropelColumnTypes.patch Download (9.2 KB) - added by propel@… 3 years ago.
simple patch for more datatypes in runtime
PropelTypes.patch Download (5.5 KB) - added by propel@… 3 years ago.
patch for "1.3/generator/classes/propel/engine/database/model/PropelTypes.php"
MysqlPlatform.patch Download (1.1 KB) - added by b166er 3 years ago.
patch for "1.3/generator/classes/propel/engine/platform/MysqlPlatform.php"

Change History

Changed 3 years ago by propel@…

simple patch for more datatypes in runtime

Changed 3 years ago by propel@…

patch for "1.3/generator/classes/propel/engine/database/model/PropelTypes.php"

Changed 3 years ago by anonymous

tnx

Changed 3 years ago by b166er

patch for "1.3/generator/classes/propel/engine/platform/MysqlPlatform.php"

Changed 3 years ago by hans

  • status changed from new to closed
  • resolution set to wontfix

While this patch would work fine for MySQL it doesn't address how these new MySQL-specific datatypes should be mapped for the other supported RDBMSs. Also, I do not think this patch is necessary because we have a @sqlType attribute which allows you to specify whatever RDBMS-specific SQL datatype you want: 

<column name="enum_col" type="VARCHAR" size="32" sqlType="ENUM"/>
Note: See TracTickets for help on using tickets.