Cakephp CakePHP → Future

Comments and changes to this ticket

• 

  euromark December 19th, 2011 @ 06:11 AM

  I second this.
  The 2.0 schema already supports the full range of attributes now (including comments) which is great.
  adding support for unsigned would make it complete.

  I got a 2.0 schema here for reference:
  

  public $meals = array(
      'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'length' => 10, 'key' => 'primary', 'collate' => NULL, 'comment' => ''),
      'name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 60, 'collate' => 'utf8_unicode_ci', 'comment' => '', 'charset' => 'utf8'),
      'is_master' => array('type' => 'boolean', 'null' => false, 'default' => NULL, 'collate' => NULL, 'comment' => ''),
      'type' => array('type' => 'integer', 'null' => false, 'default' => '0', 'length' => 2, 'collate' => NULL, 'comment' => 'economy, premium'),
      'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)),
      'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_unicode_ci', 'engine' => 'MyISAM')
  );
  

  "id", "type" and "is_master" are unsigned in the DB - but do not show. Additionally, boolean fields like "is_master" here could be made unsigned by default (no need for negative values ever).

• 

  ADmad December 19th, 2011 @ 06:22 AM

  • → Tag changed from “datatypes, enhancement, mysql, unsigned” to “cakeschema, datatypes, enhancement, mysql, unsigned”
  • → Milestone set to “Future”

  Enhancement patches for 2.1 are welcome.