diff options
| author | Justin Clarke Casey | 2008-04-30 19:28:36 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2008-04-30 19:28:36 +0000 |
| commit | 8ed9e578968539ff991ffa8215e715c0e4c3be5d (patch) | |
| tree | 36a5de69d383f9219d53cb17783331d97a911e3c /OpenSim/Data/MSSQL/Resources | |
| parent | * Change new inventory groupID field to 36 rather than 63 (diff) | |
| download | opensim-SC_OLD-8ed9e578968539ff991ffa8215e715c0e4c3be5d.zip opensim-SC_OLD-8ed9e578968539ff991ffa8215e715c0e4c3be5d.tar.gz opensim-SC_OLD-8ed9e578968539ff991ffa8215e715c0e4c3be5d.tar.bz2 opensim-SC_OLD-8ed9e578968539ff991ffa8215e715c0e4c3be5d.tar.xz | |
* Add a scratch implementation of the new inventory fields to the mssql database adapter
* I don't use mssql so this may not work, corrections (in the form of patches) are welcome.
* Unlike mysql, mssql requires manual updating of existing tables here (which should mean just adding the new fields manually)
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql index 435d269..6f6bb43 100644 --- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | |||
| @@ -19,10 +19,10 @@ CREATE TABLE [inventoryitems] ( | |||
| 19 | [inventoryBasePermissions] [int] NOT NULL default 0, | 19 | [inventoryBasePermissions] [int] NOT NULL default 0, |
| 20 | [inventoryEveryOnePermissions] [int] NOT NULL default 0, | 20 | [inventoryEveryOnePermissions] [int] NOT NULL default 0, |
| 21 | [salePrice] [int] default NULL, | 21 | [salePrice] [int] default NULL, |
| 22 | [saleType] [smallint] default NULL, | 22 | [saleType] [tinyint] default NULL, |
| 23 | [creationDate] [int] default NULL, | 23 | [creationDate] [int] default NULL, |
| 24 | [groupID] [varchar](36) default NULL, | 24 | [groupID] [varchar](36) default NULL, |
| 25 | [groupOwned] [smallint] default NULL, | 25 | [groupOwned] [tinyint] default NULL, |
| 26 | [flags] [int] unsigned default NULL, | 26 | [flags] [int] unsigned default NULL, |
| 27 | PRIMARY KEY CLUSTERED | 27 | PRIMARY KEY CLUSTERED |
| 28 | ( | 28 | ( |