Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Native SQL, Schema Files
-
Labels:None
-
Environment:HideOS: FreeBSD 8.0-RELEASE-p2 FreeBSD 8.0-RELEASE-p2 amd64
PHP: 5.2.13 (cli) (built: May 6 2010 01:51:58), Zend Engine v2.2.0, with Xdebug v2.0.5
Symfony: 1.4.6-DEV (/web/vendor/symfony/1.4-svn/lib)
MySQL: Ver 14.14 Distrib 5.1.46, for portbld-freebsd8.0 (amd64) using 5.2ShowOS: FreeBSD 8.0-RELEASE-p2 FreeBSD 8.0-RELEASE-p2 amd64 PHP: 5.2.13 (cli) (built: May 6 2010 01:51:58), Zend Engine v2.2.0, with Xdebug v2.0.5 Symfony: 1.4.6-DEV (/web/vendor/symfony/1.4-svn/lib) MySQL: Ver 14.14 Distrib 5.1.46, for portbld-freebsd8.0 (amd64) using 5.2
Description
I have found in official docs of MySQL v5.0:
Decimals can be unsigned: DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]
Here above is my "schema.yml" file:
schema.yml
Project:
columns:
id:
type: integer(4)
unsigned: true
primary: true
autoincrement: true
salary_range_from:
type: decimal(12)
scale: 2
unsigned: true
After i run:
./symfony doctrine:build --all
my "schema.sql" is:
schema.sql
CREATE TABLE `project` ( `id` INT AUTO_INCREMENT, `salary_range_from` DECIMAL(12, 2), INDEX `company_id_idx` (`company_id`), PRIMARY KEY(`id`) ) DEFAULT CHARACTER SET utf8 ENGINE = INNODB;
Activity
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
- Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DC-752, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)