diff options
author | Sean Dague | 2008-06-18 20:51:42 +0000 |
---|---|---|
committer | Sean Dague | 2008-06-18 20:51:42 +0000 |
commit | 6711adb8b1581801b0244fd01084697432e7fff2 (patch) | |
tree | 510098b9ff7525fb5e58fdc74e3e34129396c5f8 /OpenSim/Data/NHibernate | |
parent | contribute weather map cycling script using osDynamicTextures. (diff) | |
download | opensim-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.sql | 40 |
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 @@ | |||
1 | BEGIN TRANSACTION; | ||
2 | |||
3 | CREATE 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 | |||
12 | create 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 | |||
34 | CREATE INDEX folder_owner_id on InventoryFolders (Owner); | ||
35 | CREATE INDEX folder_parent_id on InventoryFolders (ParentID); | ||
36 | CREATE INDEX item_group_id on InventoryItems (GroupID); | ||
37 | CREATE INDEX item_owner_id on InventoryItems (Owner); | ||
38 | CREATE INDEX item_folder_id on InventoryItems (Folder); | ||
39 | |||
40 | COMMIT; | ||