Feature #5071
Redesign Pithos DB Schema
Status: | New | Start date: | 02/13/2014 | |
---|---|---|---|---|
Priority: | Medium | Due date: | ||
Assignee: | Chrysostomos Nanakos | % Done: | 0% |
|
Category: | Pithos | Spent time: | - | |
Target version: | 0.16 |
Description
- Remove config table
- Merge xfeature with xfeaturevals table
- Separate tables for information about current objects and versions:
- nodes/versions
- attributes/version_attributes
- statistics/version_statistics - Add account and container to most tables with corresponding indexes
- Use object UUID as the unique identifier and remove the 'serial' field
- Misc changes to table columns
The updated DB schema is the following:
attributes / version_attributes
--------------------------------
account
container
domain
uuid
key
value
nodes/versions
--------------
uuid
account
container
path
hash
size
type
source
mtime
muser
checksum
cluster (πάντα 0 στα nodes)
statistics/version_statistics
------------------------------
account
container
size
count
mtime
xfeatures (permissions)
-----------------------
id
account
container
path
key
value
policy
------
account
container
key
value
public
------
id
account
container
path
active
url
groups
------
owner(account)
name
member