Symfony + Doctrine: the correct YAML syntax for the default value for a logical field

Question

I am working on the schema of my Symfony application and I need to set the default value for two boolean fields to false. However, with all the ways I tried to do it, when sql is generated, it exits with the default keyword, but after it has no default value.

my last attempt:

negotiable: 
    type: bool
    default: "false"
complete: 
    type: bool
    default: "false"

but I also tried default: false, default: 'false', default: 0because false - it is simply an alias for 0 in MySQL,default: '0'

Bad request:

CREATE TABLE dormcode_project (id BIGINT AUTO_INCREMENT, client_id BIGINT, title VARCHAR(255), briefdesc LONGTEXT, spec LONGTEXT, coder_id BIGINT, paytype VARCHAR(30), negotiable bool DEFAULT , complete bool DEFAULT , created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX coder_id_idx (coder_id), INDEX client_id_idx (client_id), PRIMARY KEY(id)) ENGINE = INNODB

Note negotiable bool DEFAULT , complete bool DEFAULT ,

, , - /config/doctrine/schema.yml. symfony/doctrine. , , , . symfony cc sql, , . , , ...

Answer 1

Boolean TINYINT. integer(1) 0/1.

:

http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html

http://www.symfony-project.org/doctrine/1_2/en/04-Schema-Files

Answer 2

, , Google, , . , .

Symfony 2.5 ( ) YAML :

negotiable: 
    type: boolean
    options:
        default: 0
complete: 
    type: boolean
    options:
        default: 0

Answer 3

"bool" "boolean" . , : false .