diff options
author | Justin Clarke Casey | 2009-01-12 17:51:43 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2009-01-12 17:51:43 +0000 |
commit | af0fcb96a43137bfd1de0c8cca190522a549e492 (patch) | |
tree | fa28d846c81c21b7c0c6274eeb372ff57048b6dd /OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql | |
parent | * Apply http://opensimulator.org/mantis/view.php?id=2980 (diff) | |
download | opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.zip opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.gz opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.bz2 opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.xz |
* Apply http://opensimulator.org/mantis/view.php?id=2965
* Adds first version of MsSql2005Dialect support for NHibernate
* Thanks mpallari
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql new file mode 100644 index 0000000..37ba733 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql | |||
@@ -0,0 +1,36 @@ | |||
1 | create table InventoryFolders ( | ||
2 | ID NVARCHAR(255) not null, | ||
3 | Type SMALLINT null, | ||
4 | Version SMALLINT null, | ||
5 | ParentID NVARCHAR(255) null, | ||
6 | Owner NVARCHAR(255) null, | ||
7 | Name NVARCHAR(64) null, | ||
8 | primary key (ID) | ||
9 | ) | ||
10 | create table InventoryItems ( | ||
11 | ID NVARCHAR(255) not null, | ||
12 | InvType INT null, | ||
13 | AssetType INT null, | ||
14 | AssetID NVARCHAR(255) null, | ||
15 | Folder NVARCHAR(255) null, | ||
16 | Owner NVARCHAR(255) null, | ||
17 | Creator NVARCHAR(255) null, | ||
18 | Name NVARCHAR(64) null, | ||
19 | Description NVARCHAR(64) null, | ||
20 | NextPermissions INT null, | ||
21 | CurrentPermissions INT null, | ||
22 | BasePermissions INT null, | ||
23 | EveryOnePermissions INT null, | ||
24 | GroupID NVARCHAR(255) null, | ||
25 | GroupOwned BIT null, | ||
26 | SalePrice INT null, | ||
27 | SaleType TINYINT null, | ||
28 | Flags INT null, | ||
29 | CreationDate INT null, | ||
30 | primary key (ID) | ||
31 | ) | ||
32 | create index item_group_id on InventoryItems (GroupID) | ||
33 | create index item_folder_id on InventoryItems (Folder) | ||
34 | create index item_owner_id on InventoryItems (Owner) | ||
35 | create index folder_owner_id on InventoryFolders (Owner) | ||
36 | create index folder_parent_id on InventoryFolders (ParentID) | ||