diff options
| author | Justin Clark-Casey (justincc) | 2013-04-02 00:45:29 +0100 |
|---|---|---|
| committer | Justin Clark-Casey (justincc) | 2013-04-02 00:45:29 +0100 |
| commit | 4153cfbf14132931b981168b7b3e7c5b8d5be8b5 (patch) | |
| tree | e919ad6145458f1bdeb19e498af4d4f8ae859366 /OpenSim/Data/MSSQL/Resources | |
| parent | In the flotasm asset cache, if we get a request for a file that we're activel... (diff) | |
| download | opensim-SC-4153cfbf14132931b981168b7b3e7c5b8d5be8b5.zip opensim-SC-4153cfbf14132931b981168b7b3e7c5b8d5be8b5.tar.gz opensim-SC-4153cfbf14132931b981168b7b3e7c5b8d5be8b5.tar.bz2 opensim-SC-4153cfbf14132931b981168b7b3e7c5b8d5be8b5.tar.xz | |
Change recent MSSQL migrations to drop COLUMN from ALTER TABLE which is either not syntactical or unnecessary.
May fix http://opensimulator.org/mantis/view.php?id=6593
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/RegionStore.migrations | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations index b84c2a4..4549801 100644 --- a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations | |||
| @@ -1153,7 +1153,7 @@ COMMIT | |||
| 1153 | 1153 | ||
| 1154 | BEGIN TRANSACTION | 1154 | BEGIN TRANSACTION |
| 1155 | 1155 | ||
| 1156 | ALTER TABLE prims ADD COLUMN DynAttrs TEXT; | 1156 | ALTER TABLE prims ADD DynAttrs TEXT; |
| 1157 | 1157 | ||
| 1158 | COMMIT | 1158 | COMMIT |
| 1159 | 1159 | ||
| @@ -1161,10 +1161,10 @@ COMMIT | |||
| 1161 | 1161 | ||
| 1162 | BEGIN TRANSACTION | 1162 | BEGIN TRANSACTION |
| 1163 | 1163 | ||
| 1164 | ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; | 1164 | ALTER TABLE prims ADD `PhysicsShapeType` tinyint(4) NOT NULL default '0'; |
| 1165 | ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000'; | 1165 | ALTER TABLE prims ADD `Density` double NOT NULL default '1000'; |
| 1166 | ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1'; | 1166 | ALTER TABLE prims ADD `GravityModifier` double NOT NULL default '1'; |
| 1167 | ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6'; | 1167 | ALTER TABLE prims ADD `Friction` double NOT NULL default '0.6'; |
| 1168 | ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5'; | 1168 | ALTER TABLE prims ADD `Restitution` double NOT NULL default '0.5'; |
| 1169 | 1169 | ||
| 1170 | COMMIT | 1170 | COMMIT |