20170220193303_insert_into_projects_organization_ids.php

<?php

class InsertIntoProjectsOrganizationIds extends AbstractMatecatMigration
{

    public $sql_up = array(

            "LOCK TABLES `projects` WRITE, `users` READ, `organizations` READ ",

            "UPDATE projects
                LEFT JOIN users ON users.email = projects.id_customer
                LEFT JOIN organizations ON organizations.created_by = users.uid AND organizations.type = 'personal'
              SET projects.id_organization = organizations.id 
              WHERE projects.id_organization IS NULL 
              AND projects.id_customer != 'translated_user' ",

            "UNLOCK TABLES ",

    );

    public $sql_down = array(
            " UPDATE projects SET id_organization = NULL WHERE 1 "
    );

}