aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
diff options
context:
space:
mode:
authorJustin Clarke Casey2009-01-12 17:51:43 +0000
committerJustin Clarke Casey2009-01-12 17:51:43 +0000
commitaf0fcb96a43137bfd1de0c8cca190522a549e492 (patch)
treefa28d846c81c21b7c0c6274eeb372ff57048b6dd /OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
parent* Apply http://opensimulator.org/mantis/view.php?id=2980 (diff)
downloadopensim-SC-af0fcb96a43137bfd1de0c8cca190522a549e492.zip
opensim-SC-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.gz
opensim-SC-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.bz2
opensim-SC-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.sql36
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 @@
1create 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)
10create 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)
32create index item_group_id on InventoryItems (GroupID)
33create index item_folder_id on InventoryItems (Folder)
34create index item_owner_id on InventoryItems (Owner)
35create index folder_owner_id on InventoryFolders (Owner)
36create index folder_parent_id on InventoryFolders (ParentID)