@@ -24,7 +24,7 @@ discard block |
||
24 | 24 | $this->addSql("ALTER TABLE session_rel_course ENGINE=InnoDB"); |
25 | 25 | $this->addSql("ALTER TABLE session_rel_course_rel_user ENGINE=InnoDB"); |
26 | 26 | $this->addSql("ALTER TABLE session_rel_user ENGINE=InnoDB"); |
27 | - $this->addSql("UPDATE session SET session.id_coach = 1 WHERE id_coach NOT IN ( SELECT user_id FROM user)"); |
|
27 | + $this->addSql("UPDATE session SET session.id_coach = 1 WHERE id_coach NOT IN ( SELECT user_id FROM user)"); |
|
28 | 28 | } |
29 | 29 | |
30 | 30 | /** |
@@ -124,7 +124,7 @@ discard block |
||
124 | 124 | $this->addSql("ALTER TABLE track_e_online CHANGE COLUMN login_ip user_ip varchar(39) NOT NULL DEFAULT ''"); |
125 | 125 | $this->addSql("ALTER TABLE track_e_login CHANGE COLUMN login_ip user_ip varchar(39) NOT NULL DEFAULT ''"); |
126 | 126 | |
127 | - $this->addSql("ALTER TABLE user MODIFY COLUMN user_id int unsigned NOT NULL"); |
|
127 | + $this->addSql("ALTER TABLE user MODIFY COLUMN user_id int unsigned NOT NULL"); |
|
128 | 128 | $this->addSql("ALTER TABLE user DROP PRIMARY KEY"); |
129 | 129 | $this->addSql("ALTER TABLE user MODIFY COLUMN user_id int unsigned DEFAULT NULL"); |
130 | 130 | $this->addSql("ALTER TABLE user ADD COLUMN id INT DEFAULT NULL"); |