aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate
diff options
context:
space:
mode:
authorSean Dague2008-06-18 20:51:42 +0000
committerSean Dague2008-06-18 20:51:42 +0000
commit6711adb8b1581801b0244fd01084697432e7fff2 (patch)
tree510098b9ff7525fb5e58fdc74e3e34129396c5f8 /OpenSim/Data/NHibernate
parentcontribute weather map cycling script using osDynamicTextures. (diff)
downloadopensim-SC-6711adb8b1581801b0244fd01084697432e7fff2.zip
opensim-SC-6711adb8b1581801b0244fd01084697432e7fff2.tar.gz
opensim-SC-6711adb8b1581801b0244fd01084697432e7fff2.tar.bz2
opensim-SC-6711adb8b1581801b0244fd01084697432e7fff2.tar.xz
add inventory store migration
Diffstat (limited to 'OpenSim/Data/NHibernate')
-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;