|
@@ -24,7 +24,7 @@ discard block |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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"); |
Please login to merge, or discard this patch.