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 'OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql')
| -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; |