diff options
Start of Inventory service, currently only (partially) functional in standalone mode and using sqlite).
In standalone mode, if you have account authenticate turned on (setting in opensim.ini) then when you create a new account, a set of inventory is created for that account and stored in database (currently only a set of empty folders). Then during login the database is search for that set and sent to the client in the login response.
More functions will be added soon, like creating new folders (and a bit later items) from the client inventory window.
Diffstat (limited to 'share/sql/sqlite3-inventory.sql')
| -rw-r--r-- | share/sql/sqlite3-inventory.sql | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/share/sql/sqlite3-inventory.sql b/share/sql/sqlite3-inventory.sql new file mode 100644 index 0000000..0575c28 --- /dev/null +++ b/share/sql/sqlite3-inventory.sql | |||
| @@ -0,0 +1,40 @@ | |||
| 1 | -- | ||
| 2 | -- Database schema for inventory storage | ||
| 3 | -- | ||
| 4 | -- | ||
| 5 | -- Some type mappings | ||
| 6 | -- LLUID => char(36) (in ascii hex format) | ||
| 7 | -- uint => integer | ||
| 8 | -- string => varchar(256) until such time as we know we need bigger | ||
| 9 | |||
| 10 | create table inventoryitems ( | ||
| 11 | UUID char(36) primary key, -- inventoryid | ||
| 12 | assetID char(36), | ||
| 13 | assetType integer, | ||
| 14 | invType integer, | ||
| 15 | parentFolderID char(36), | ||
| 16 | avatarID char(36), | ||
| 17 | creatorsID char(36), | ||
| 18 | inventoryName varchar(256), | ||
| 19 | inventoryDescription varchar(256), | ||
| 20 | -- permissions | ||
| 21 | inventoryNextPermissions integer, | ||
| 22 | inventoryCurrentPermissions integer, | ||
| 23 | inventoryBasePermissions integer, | ||
| 24 | inventoryEveryOnePermissions integer | ||
| 25 | ); | ||
| 26 | |||
| 27 | create index inventoryitems_parent on inventoryitems(parentFolderID); | ||
| 28 | create index inventoryitems_ownerid on inventoryitems(avatarID); | ||
| 29 | create index inventoryitems_assetid on inventoryitems(assetID); | ||
| 30 | |||
| 31 | create table inventoryfolders ( | ||
| 32 | -- The same UUID as prim, just to keep them easily linked | ||
| 33 | UUID varchar(36) primary key not null, --folderid | ||
| 34 | name varchar(256), | ||
| 35 | agentID char(36), | ||
| 36 | parentID char(36), | ||
| 37 | type integer, | ||
| 38 | version integer | ||
| 39 | ); | ||
| 40 | |||