diff options
| author | Teravus Ovares | 2008-04-30 16:08:24 +0000 |
|---|---|---|
| committer | Teravus Ovares | 2008-04-30 16:08:24 +0000 |
| commit | a9cc76e0efba7496909d613c75b81de6a9c5d979 (patch) | |
| tree | e83763d4dfb3b78ead9b5926dce1d2468b496845 /OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql | |
| parent | move IUserService into the OpenSim.Framework.Communications assembly (diff) | |
| download | opensim-SC-a9cc76e0efba7496909d613c75b81de6a9c5d979.zip opensim-SC-a9cc76e0efba7496909d613c75b81de6a9c5d979.tar.gz opensim-SC-a9cc76e0efba7496909d613c75b81de6a9c5d979.tar.bz2 opensim-SC-a9cc76e0efba7496909d613c75b81de6a9c5d979.tar.xz | |
* Long awaited patch from A_Biondi Mantis 923. Kept alive by Melanie. Thanks A_Biondi and Melanie!
* This builds but might not work. JustinCC will examine.. it may work out of the box.
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql new file mode 100644 index 0000000..2b3b1f7 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql | |||
| @@ -0,0 +1,8 @@ | |||
| 1 | ALTER TABLE `inventoryitems` | ||
| 2 | ADD COLUMN `salePrice` int(11) NOT NULL, | ||
| 3 | ADD COLUMN `saleType` tinyint(4) NOT NULL, | ||
| 4 | ADD COLUMN `creationDate` int(11) NOT NULL, | ||
| 5 | ADD COLUMN `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
| 6 | ADD COLUMN `groupOwned` tinyint(4) NOT NULL, | ||
| 7 | ADD COLUMN `flags` int(11) unsigned NOT NULL, | ||
| 8 | COMMENT='Rev. 3'; | ||