Application\Migrations\Version20120630111620::up PHP Метод

    public function up(Schema $schema)
    {
        // this up() migration is autogenerated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
        $this->addSql("ALTER TABLE bundle ADD nbRecommenders INT NOT NULL");
        $recommendersSql = <<<EOF
UPDATE bundle
JOIN (
    SELECT id, name, (
        SELECT COUNT(*) FROM bundles_usage WHERE bundle_id = bundle.id
    ) AS usages
    FROM bundle AS bundle
) AS number
ON number.id = bundle.id
SET bundle.nbRecommenders = number.usages
EOF;
        $this->addSql($recommendersSql);
    }