diff options
| author | Melanie Thielker | 2015-07-14 21:22:53 +0200 |
|---|---|---|
| committer | Melanie Thielker | 2015-07-14 21:22:53 +0200 |
| commit | c7f6e248e8544200871a1bf814f34e2ee0f9d977 (patch) | |
| tree | 13fa2e1eae6dd42d6733b6409a3425453b0a55f6 | |
| parent | Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim! (diff) | |
| download | opensim-SC-c7f6e248e8544200871a1bf814f34e2ee0f9d977.zip opensim-SC-c7f6e248e8544200871a1bf814f34e2ee0f9d977.tar.gz opensim-SC-c7f6e248e8544200871a1bf814f34e2ee0f9d977.tar.bz2 opensim-SC-c7f6e248e8544200871a1bf814f34e2ee0f9d977.tar.xz | |
Correcting errors in previous change: MySQL needs int unsigned, not
unsigned int. PGSQL has no unsigned types, changing to bigint.
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 2 | ||||
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/RegionStore.migrations | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index 7aefadb..ac31380 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
| @@ -944,7 +944,7 @@ COMMIT; | |||
| 944 | 944 | ||
| 945 | BEGIN; | 945 | BEGIN; |
| 946 | 946 | ||
| 947 | ALTER TABLE land CHANGE COLUMN LandFlags LandFlags unsigned default null; | 947 | ALTER TABLE land CHANGE COLUMN LandFlags LandFlags int unsigned default null; |
| 948 | 948 | ||
| 949 | COMMIT; | 949 | COMMIT; |
| 950 | 950 | ||
diff --git a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations index 3852e3a..d3277f2 100644 --- a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations | |||
| @@ -1153,10 +1153,10 @@ ALTER TABLE regionwindlight ALTER COLUMN draw_classic_clouds SET DEFAULT FALSE; | |||
| 1153 | 1153 | ||
| 1154 | COMMIT; | 1154 | COMMIT; |
| 1155 | 1155 | ||
| 1156 | VERSION 41 #-- Change Landlags to unsigned | 1156 | VERSION 41 #-- Change Landlags to bigint |
| 1157 | 1157 | ||
| 1158 | BEGIN TRANSACTION; | 1158 | BEGIN TRANSACTION; |
| 1159 | 1159 | ||
| 1160 | ALTER TABLE land ALTER LandFlags TYPE unsigned; | 1160 | ALTER TABLE land ALTER LandFlags TYPE bigint; |
| 1161 | 1161 | ||
| 1162 | COMMIT; | 1162 | COMMIT; |