diff options
| author | Justin Clarke Casey | 2008-04-30 19:13:06 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2008-04-30 19:13:06 +0000 |
| commit | f57ff4c36bab3b9e26c55d64afde251bf07a2de3 (patch) | |
| tree | 6d0ff3bf8aa7a4c18fcb3ddd4ab8d15f7a3d7693 /OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | |
| parent | * Completely inconsequential inventory odds and ends (actual impact - only on... (diff) | |
| download | opensim-SC_OLD-f57ff4c36bab3b9e26c55d64afde251bf07a2de3.zip opensim-SC_OLD-f57ff4c36bab3b9e26c55d64afde251bf07a2de3.tar.gz opensim-SC_OLD-f57ff4c36bab3b9e26c55d64afde251bf07a2de3.tar.bz2 opensim-SC_OLD-f57ff4c36bab3b9e26c55d64afde251bf07a2de3.tar.xz | |
* Change new inventory groupID field to 36 rather than 63
* Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/CreateItemsTable.sql')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql index c8b7481..24ebccd 100644 --- a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | |||
| @@ -15,7 +15,7 @@ CREATE TABLE `inventoryitems` ( | |||
| 15 | `salePrice` int(11) default NULL, | 15 | `salePrice` int(11) default NULL, |
| 16 | `saleType` tinyint(4) default NULL, | 16 | `saleType` tinyint(4) default NULL, |
| 17 | `creationDate` int(11) default NULL, | 17 | `creationDate` int(11) default NULL, |
| 18 | `groupID` varchar(63) default NULL, | 18 | `groupID` varchar(36) default NULL, |
| 19 | `groupOwned` tinyint(4) default NULL, | 19 | `groupOwned` tinyint(4) default NULL, |
| 20 | `flags` int(11) unsigned default NULL, | 20 | `flags` int(11) unsigned default NULL, |
| 21 | PRIMARY KEY (`inventoryID`), | 21 | PRIMARY KEY (`inventoryID`), |