aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorDiva Canto2010-05-04 09:44:30 -0700
committerDiva Canto2010-05-04 09:44:30 -0700
commit484584b83ce96825c49ccf7c9c129a3961e5c223 (patch)
treedee9f85383d5a71cf800380231eb5a4b1a5e4d65
parentAllow reloading of estate settings into a running region. Move sun update (diff)
downloadopensim-SC_OLD-484584b83ce96825c49ccf7c9c129a3961e5c223.zip
opensim-SC_OLD-484584b83ce96825c49ccf7c9c129a3961e5c223.tar.gz
opensim-SC_OLD-484584b83ce96825c49ccf7c9c129a3961e5c223.tar.bz2
opensim-SC_OLD-484584b83ce96825c49ccf7c9c129a3961e5c223.tar.xz
Fixed: migration #2 for SQLite. Problem was that ATTACH cannot be done inside a transaction.
-rw-r--r--OpenSim/Data/SQLite/Resources/002_XInventoryStore.sql5
1 files changed, 2 insertions, 3 deletions
diff --git a/OpenSim/Data/SQLite/Resources/002_XInventoryStore.sql b/OpenSim/Data/SQLite/Resources/002_XInventoryStore.sql
index 545d233..d38e2b7 100644
--- a/OpenSim/Data/SQLite/Resources/002_XInventoryStore.sql
+++ b/OpenSim/Data/SQLite/Resources/002_XInventoryStore.sql
@@ -1,9 +1,8 @@
1BEGIN TRANSACTION; 1ATTACH 'inventoryStore.db' AS old;
2 2
3ATTACH 'inventoryStore.db' AS old; 3BEGIN TRANSACTION;
4 4
5INSERT INTO inventoryfolders (folderName, type, version, folderID, agentID, parentFolderID) SELECT `name` AS folderName, `type` AS type, `version` AS version, `UUID` AS folderID, `agentID` AS agentID, `parentID` AS parentFolderID from old.inventoryfolders; 5INSERT INTO inventoryfolders (folderName, type, version, folderID, agentID, parentFolderID) SELECT `name` AS folderName, `type` AS type, `version` AS version, `UUID` AS folderID, `agentID` AS agentID, `parentID` AS parentFolderID from old.inventoryfolders;
6
7INSERT INTO inventoryitems (assetID, assetType, inventoryName, inventoryDescription, inventoryNextPermissions, inventoryCurrentPermissions, invType, creatorID, inventoryBasePermissions, inventoryEveryOnePermissions, salePrice, saleType, creationDate, groupID, groupOwned, flags, inventoryID, parentFolderID, avatarID, inventoryGroupPermissions) SELECT `assetID`, `assetType` AS assetType, `inventoryName` AS inventoryName, `inventoryDescription` AS inventoryDescription, `inventoryNextPermissions` AS inventoryNextPermissions, `inventoryCurrentPermissions` AS inventoryCurrentPermissions, `invType` AS invType, `creatorsID` AS creatorID, `inventoryBasePermissions` AS inventoryBasePermissions, `inventoryEveryOnePermissions` AS inventoryEveryOnePermissions, `salePrice` AS salePrice, `saleType` AS saleType, `creationDate` AS creationDate, `groupID` AS groupID, `groupOwned` AS groupOwned, `flags` AS flags, `UUID` AS inventoryID, `parentFolderID` AS parentFolderID, `avatarID` AS avatarID, `inventoryGroupPermissions` AS inventoryGroupPermissions FROM old.inventoryitems; 6INSERT INTO inventoryitems (assetID, assetType, inventoryName, inventoryDescription, inventoryNextPermissions, inventoryCurrentPermissions, invType, creatorID, inventoryBasePermissions, inventoryEveryOnePermissions, salePrice, saleType, creationDate, groupID, groupOwned, flags, inventoryID, parentFolderID, avatarID, inventoryGroupPermissions) SELECT `assetID`, `assetType` AS assetType, `inventoryName` AS inventoryName, `inventoryDescription` AS inventoryDescription, `inventoryNextPermissions` AS inventoryNextPermissions, `inventoryCurrentPermissions` AS inventoryCurrentPermissions, `invType` AS invType, `creatorsID` AS creatorID, `inventoryBasePermissions` AS inventoryBasePermissions, `inventoryEveryOnePermissions` AS inventoryEveryOnePermissions, `salePrice` AS salePrice, `saleType` AS saleType, `creationDate` AS creationDate, `groupID` AS groupID, `groupOwned` AS groupOwned, `flags` AS flags, `UUID` AS inventoryID, `parentFolderID` AS parentFolderID, `avatarID` AS avatarID, `inventoryGroupPermissions` AS inventoryGroupPermissions FROM old.inventoryitems;
8 7
9COMMIT; 8COMMIT;