Posted by tacituseu on October 19, 2009 at 10:15am
Jump to:
| Project: | Password policy |
| Version: | 6.x-1.0-alpha2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
Issue Summary
see http://bugs.mysql.com/bug.php?id=25520
BLOB/TEXT column 'policy' can't have a default value query: CREATE TABLE password_policy ( `pid` INT NOT NULL auto_increment, `name` VARCHAR(64) NOT NULL DEFAULT '', `description` VARCHAR(255) DEFAULT '', `enabled` TINYINT NOT NULL DEFAULT 0, `policy` TEXT NOT NULL DEFAULT '', `created` INT NOT NULL DEFAULT 0, `expiration` INT DEFAULT NULL, `warning` VARCHAR(64) DEFAULT NULL, PRIMARY KEY (pid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
Comments
#1
#583902: Performance - slow mysql queries caused by use of TEXT type for policy column