diff options
author | Jeff Ames | 2007-12-20 01:01:42 +0000 |
---|---|---|
committer | Jeff Ames | 2007-12-20 01:01:42 +0000 |
commit | 36a8f70931e24ccdf027966b737d95736be6e3f9 (patch) | |
tree | 541d27bf497ea3f1b7f2a92241c5032e98880d05 /OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql | |
parent | * Re-did the mass calculations in ODE for Prim (diff) | |
download | opensim-SC_OLD-36a8f70931e24ccdf027966b737d95736be6e3f9.zip opensim-SC_OLD-36a8f70931e24ccdf027966b737d95736be6e3f9.tar.gz opensim-SC_OLD-36a8f70931e24ccdf027966b737d95736be6e3f9.tar.bz2 opensim-SC_OLD-36a8f70931e24ccdf027966b737d95736be6e3f9.tar.xz |
Extended svn:eol-style to check some other file types.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql b/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql index c47786c..d1ef504 100644 --- a/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql +++ b/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql | |||
@@ -1,9 +1,9 @@ | |||
1 | ALTER TABLE `inventoryitems` | 1 | ALTER TABLE `inventoryitems` |
2 | CHANGE COLUMN `type` `assetType` int(11) default NULL, | 2 | CHANGE COLUMN `type` `assetType` int(11) default NULL, |
3 | ADD COLUMN `invType` int(11) default NULL, | 3 | ADD COLUMN `invType` int(11) default NULL, |
4 | ADD COLUMN `creatorID` varchar(36) default NULL, | 4 | ADD COLUMN `creatorID` varchar(36) default NULL, |
5 | ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, | 5 | ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, |
6 | ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, | 6 | ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, |
7 | COMMENT='Rev. 2'; | 7 | COMMENT='Rev. 2'; |
8 | 8 | ||
9 | UPDATE `inventoryitems` SET invType=assetType; | 9 | UPDATE `inventoryitems` SET invType=assetType; |