aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources
diff options
context:
space:
mode:
authorJustin Clarke Casey2008-04-30 19:28:36 +0000
committerJustin Clarke Casey2008-04-30 19:28:36 +0000
commit8ed9e578968539ff991ffa8215e715c0e4c3be5d (patch)
tree36a5de69d383f9219d53cb17783331d97a911e3c /OpenSim/Data/MSSQL/Resources
parent* Change new inventory groupID field to 36 rather than 63 (diff)
downloadopensim-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 '')
-rw-r--r--OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql4
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(