aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/InventoryStore.migrations
diff options
context:
space:
mode:
authorMelanie2011-10-11 21:31:48 +0100
committerMelanie2011-10-11 21:31:48 +0100
commit0fa21b7b5e18457e72a23e9319501c3ab068d275 (patch)
tree3de073e8d4e50e7358b85ba97fc9b7f3b9c09b26 /OpenSim/Data/MSSQL/Resources/InventoryStore.migrations
parentMerge commit '1458fab82c4dab9901d81419e6b515f47ea7320f' into bigmerge (diff)
parentMSSQL Bug fix in user account retrieval, plus migrations for FriendsStore and... (diff)
downloadopensim-SC_OLD-0fa21b7b5e18457e72a23e9319501c3ab068d275.zip
opensim-SC_OLD-0fa21b7b5e18457e72a23e9319501c3ab068d275.tar.gz
opensim-SC_OLD-0fa21b7b5e18457e72a23e9319501c3ab068d275.tar.bz2
opensim-SC_OLD-0fa21b7b5e18457e72a23e9319501c3ab068d275.tar.xz
Merge commit 'd4043c084a86da5f462356ec5c65eab2b861564d' into bigmerge
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/InventoryStore.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/InventoryStore.migrations32
1 files changed, 32 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/InventoryStore.migrations b/OpenSim/Data/MSSQL/Resources/InventoryStore.migrations
index 4a3cb27..4e43653 100644
--- a/OpenSim/Data/MSSQL/Resources/InventoryStore.migrations
+++ b/OpenSim/Data/MSSQL/Resources/InventoryStore.migrations
@@ -244,4 +244,36 @@ ALTER TABLE inventoryitems
244ADD CONSTRAINT DF_inventoryitems_creatorID 244ADD CONSTRAINT DF_inventoryitems_creatorID
245DEFAULT '00000000-0000-0000-0000-000000000000' FOR creatorID 245DEFAULT '00000000-0000-0000-0000-000000000000' FOR creatorID
246 246
247:GO
248
249:VERSION 9
250
251BEGIN TRANSACTION
252
253# CreatorID goes up to VARCHAR(255)
254
255exec sp_rename 'inventoryitems.CreatorID', 'cr_old', 'COLUMN'
256
257:GO
258
259alter table inventoryitems
260 add creatorID varchar(255) NULL
261
262:GO
263
264update inventoryitems set creatorID = cr_old
265
266alter table inventoryitems
267drop CONSTRAINT DF_inventoryitems_creatorID
268:GO
269
270alter table inventoryitems
271 drop column cr_old
272 :GO
273COMMIT
274
275ALTER TABLE inventoryitems
276ADD CONSTRAINT DF_inventoryitems_creatorID
277DEFAULT '00000000-0000-0000-0000-000000000000' FOR creatorID
278
247:GO \ No newline at end of file 279:GO \ No newline at end of file