|
@@ 157-165 (lines=9) @@
|
| 154 |
|
]; |
| 155 |
|
} |
| 156 |
|
|
| 157 |
|
public function renameColumnProvider() |
| 158 |
|
{ |
| 159 |
|
return [ |
| 160 |
|
[new MySqlPlatform(), 'ALTER TABLE test_table CHANGE old_column new_column VARCHAR(100) NOT NULL'], |
| 161 |
|
[new PostgreSqlPlatform(), 'ALTER TABLE test_table RENAME COLUMN old_column TO new_column'], |
| 162 |
|
[new OraclePlatform(), 'ALTER TABLE test_table RENAME COLUMN old_column TO new_column'], |
| 163 |
|
[new SQLServer2005Platform(), "sp_RENAME 'test_table.old_column', 'new_column', 'COLUMN'",], |
| 164 |
|
]; |
| 165 |
|
} |
| 166 |
|
|
| 167 |
|
public function addIndexProvider() |
| 168 |
|
{ |
|
@@ 167-175 (lines=9) @@
|
| 164 |
|
]; |
| 165 |
|
} |
| 166 |
|
|
| 167 |
|
public function addIndexProvider() |
| 168 |
|
{ |
| 169 |
|
return [ |
| 170 |
|
[new MySqlPlatform(), 'CREATE INDEX idx_test_table_new_column ON test_table (new_column)'], |
| 171 |
|
[new PostgreSqlPlatform(), 'CREATE INDEX idx_test_table_new_column ON test_table (new_column)'], |
| 172 |
|
[new OraclePlatform(), 'CREATE INDEX idx_test_table_new_column ON test_table (new_column)'], |
| 173 |
|
[new SQLServer2005Platform(), 'CREATE INDEX idx_test_table_new_column ON test_table (new_column)'], |
| 174 |
|
]; |
| 175 |
|
} |
| 176 |
|
|
| 177 |
|
public function addUniqueIndexProvider() |
| 178 |
|
{ |
|
@@ 177-188 (lines=12) @@
|
| 174 |
|
]; |
| 175 |
|
} |
| 176 |
|
|
| 177 |
|
public function addUniqueIndexProvider() |
| 178 |
|
{ |
| 179 |
|
return [ |
| 180 |
|
[new MySqlPlatform(), 'CREATE UNIQUE INDEX uniq_test_table_new_column ON test_table (new_column)'], |
| 181 |
|
[new PostgreSqlPlatform(), 'CREATE UNIQUE INDEX uniq_test_table_new_column ON test_table (new_column)'], |
| 182 |
|
[new OraclePlatform(), 'CREATE UNIQUE INDEX uniq_test_table_new_column ON test_table (new_column)'], |
| 183 |
|
[ |
| 184 |
|
new SQLServer2005Platform(), |
| 185 |
|
'CREATE UNIQUE INDEX uniq_test_table_new_column ON test_table (new_column) WHERE new_column IS NOT NULL' |
| 186 |
|
], |
| 187 |
|
]; |
| 188 |
|
} |
| 189 |
|
|
| 190 |
|
public function addForeignKeyConstraintProvider() |
| 191 |
|
{ |