aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources')
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql40
1 files changed, 40 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
new file mode 100644
index 0000000..89892df
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
@@ -0,0 +1,40 @@
1BEGIN TRANSACTION;
2
3CREATE TABLE InventoryFolders (
4 ID varchar(36) not null primary key,
5 Type int,
6 Version int,
7 ParentID varchar(36),
8 Owner varchar(36),
9 Name varchar(64)
10);
11
12create table InventoryItems (
13 ID varchar(36) not null primary key,
14 InvType int,
15 AssetType int,
16 AssetID varchar(36),
17 Folder varchar(36),
18 Owner varchar(36),
19 Creator varchar(36),
20 Name varchar(64),
21 Description varchar(64),
22 NextPermissions int,
23 CurrentPermissions int,
24 BasePermissions int,
25 EveryOnePermissions int,
26 GroupID varchar(36),
27 GroupOwned int,
28 SalePrice int,
29 SaleType int,
30 Flags int,
31 CreationDate int
32);
33
34CREATE INDEX folder_owner_id on InventoryFolders (Owner);
35CREATE INDEX folder_parent_id on InventoryFolders (ParentID);
36CREATE INDEX item_group_id on InventoryItems (GroupID);
37CREATE INDEX item_owner_id on InventoryItems (Owner);
38CREATE INDEX item_folder_id on InventoryItems (Folder);
39
40COMMIT;