#6144: Console Schema generation should support "comments"
--------------------------+-------------------------------------------------
Reporter: euromark | Type: Enhancement
Status: new | Priority: High
Milestone: 1.3.x.x | Component: Console
Version: 1.2 Final | Severity: Normal
Keywords: | Php_version: n/a
Cake_version: |
--------------------------+-------------------------------------------------
If you work with some guys using version control
you will experience some major loss of information when using
the console with "cake schema run update" + "cake schema generate -s"
as the comments of both the tables themselves and the fields are not
written into the schema_x.php
[[BR]]
[[BR]]
this can be a real problem if the comment is essential for knowing what
this field is supposed to be for (or what values it is supposed to have
etc)
[[BR]]
[[BR]]
it would be really nice if the comments would be synced as well.[[BR]]
This way less information is lost using console schema functions
[[BR]]
[[BR]]
Example of a fully commented table by using "normal" sql export methods
fro PHPMYADMIN:
{{{
CREATE TABLE IF NOT EXISTS `telbuch_roles_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`role_id` int(10) unsigned NOT NULL,
`active` tinyint(1) unsigned NOT NULL default '0' COMMENT 'if confirmed
by any admin',
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='HABTM join table between ROLES and USERS'
AUTO_INCREMENT=29 ;
}}}
in our case both comments here would be permanently lost using the above
way to update database
[[BR]]
[[BR]]
I am not sure if other "optional" fields containing possible information
are not synced as well - but if so, maybe they can be added as well.
--
Ticket URL: <https://trac.cakephp.org/ticket/6144>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to tickets-cakephp@googlegroups.com
To unsubscribe from this group, send email to
tickets-cakephp+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
