THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Page History
...
The goal is to provide the S3 REST API calls in CloudStack. Specifically
Provide ##Provide a REST API for CloudStack which provides the same services as Amazon AWS S3.
Allow ##Allow the installation-specific one-time definition of a custom endpoint and storage nodes.
Provide ##Provide operations with parameters, responses and errors which match or are very similar to the Amazon S3 API.
Allow the solution to be installable via a self contained virtual system server within a CloudStack management server.
...
Scope of this document is to provide a functional specification for the EC2 integration and fidelity work planned for the Bonita release of CloudStack.
References
**Solution must comply with Amazon Simple Storage Service API Reference (API Version 2006-03-01) at http://aws.amazon.com/documentation/s3/
**Specific part of specification used is REST API as described at http://docs.amazonwebservices.com/AmazonS3/latest/dev/Introduction.html#API.
**For driver tooling examples see http://aws.amazon.com/developertools/
...
Ideally the following should be accomplished
1. Provide #Provide a list of supported operations which have been tested to provide correct behaviour.
2. Allow #Allow the data model to be held in the CLOUDBRIDGE database (shared with EC2 API) as part of the build of the CloudStack 3.0x release management server.
3. Ensure #Ensure that the formats of requests, responses and errors match those documented as doc.s3.amazonaws.com/2006-03-01/ (being the current API Version).
4. Extend #Extend all supported operations to cover requests in hostname-relative style; subdomain style; and - if time permits - virtual hosting style.
5. Enforce #Enforce lexical rules such as the bucket naming constraints of the API as given for cross-region (or “region-independent”) requests.
6. Test #Test typical request-response behavior for compatibility with the REST capabilities of popular S3 toolsets. The currently used toolkits include: boto, s3cmd, jets3.
7. Document #Document any exceptions to the above.
...
Fidelity to the Amazon S3 API embraces:
**Ability to process requests for the services listed above using the documented HTTP requests formats and undertake the CRUD actions implied by those requests
**Ability to process the correct controls, viz holding the public-private key pair of the user, preserving granter-grantee relationships for bucket or object resources, managing ACLs.
**Ability to provide responses, including XML response bodies where necessary, which are sufficiently accurate to follow the Amazon S3 spec.
**Provide a robust implementation for holding the operational metadata, together with an Object-Model mapping of this. Also allow the XML content of the web service request to include large binary stream content via optimised transmission (MTOM), supported by the Apache AXIOM library employing pull parsing. This list of critical capabilities has already been developed in 2011.
To allow the above to be configurable to the resources, especially simple storage resources, at a given cloud management installation.
...
No regions – The Amazon AWS S3 provision for geographic regions, plus additionally a default ‘US Standard’ pan-regional option, will not be present in this design. Consequently when a location constraint is processed it will be ignored and, if created, will be empty by default.
...
Omissions at this time - may be revisited
The list of supported operations will not be fully coextensive with those at s3.amazonaws.com at this release. A list of Amazon S3 operations which are not supported within the current release are as follows.
...
The capabilities of the S3 API are intended to satisfy the following use cases. For an overview of the expected capabilities, see docs.amazonwebservices.com/AmazonS3/latest/API/APIRest.htm.
**List All Buckets,
Example using the simplest GET request, http://myhost:8080/awsapi/rest/AmazonS3
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTServiceGET.htm
**GET Bucket's Objects,
Example using GET http://myhost:8080/awsapi/rest/AmazonS3/mybucket1
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketGET.htm
**GET a Bucket
Example using GET http://myhost:8080/awsapi/rest/AmazonS3/mybucket1?max-keys=10
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTServiceGET.htm
**GET Bucket acl,
Example using GET http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/?acl
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketGETacl.html
**List a Bucket's versions,
Example using HEAD http://myhost:8080/awsapi/rest/AmazonS3/mybucket3/?versions&max-keys=999
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketGETVersion.html
**GET Bucket versioning status,
Example using GET http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/?versioning
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketGETversioningStatus.html
**Retrieve a Bucket's metadata,
Example using HEAD http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/?keyname3
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketHEAD.html
**List Multipart Uploads,
Example using GET http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/my_upload_1?uploadId=6
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/mpUploadListParts.html
**PUT Bucket,
Example using PUT http://myhost:8080/awsapi/rest/AmazonS3/mybucket1
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketPUT.html
**PUT Bucket acl,
Example using PUT http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/?acl
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketPUTacl.html
**PUT Bucket versioning status,
Example using PUT http://myhost:8080/awsapi/rest/AmazonS3/mybucket2/?versioning
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketPUTVersioningStatus.html
**DELETE Bucket,
Example using DELETE http://myhost:8080/awsapi/rest/AmazonS3/mybucket2
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketDELETE.html
**GET a Bucket's Objects,
Example using GET http://myhost:8080/awsapi/rest/AmazonS3/mybucket1
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketGET.htm
**GET an Object from a Bucket,
Example using GET http:/myhost:8080/awsapi/rest/AmazonS3/mybucket2/keyname1
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTObjectGET.html
**GET Object acl,
Example using GET http://myhost:8080./awsapi/rest/AmazonS3/mybucket1/?acl
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTBucketGETacl.html
**PUT an Object into a Bucket,
Example using PUT http://myhost:8080/awsapi/rest/AmazonS3/mybucket2/keyname1
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTObjectPUT.html
**POST a file Object into a Bucket,
Example using example HTML forms to send, POST http://myhost:8080/awsapi/rest/AmazonS3
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTObjectPOST.html
**PUT Object acl,
Example using PUT http://myhost:8080/awsapi/rest/AmazonS3/mybucket4/thirdk4?acl
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTObjectPUTacl.html
**Initiate Multipart Upload,
Example using POST http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/my_upload_1?uploads
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/mpUploadInitiate.html
**Upload Part,
Example using PUT http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/my_upload_1?uploadId=6&partNumber=1
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/mpUploadUploadPart.html
**Complete Multipart Upload,
Example using POST http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/my_upload_1?uploadId=6
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/mpUploadComplete.html
**Abort Multipart Upload,
Example using DELETE http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/my_upload_1?uploadId=6
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/mpUploadAbort.html
**List Parts for Upload,
Example using GET http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/my_upload_1?uploadId=6
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/mpUploadListParts.html
**DELETE Object,
Example using DELETE http://myhost:8080/awsapi/rest/AmazonS3/mybucket1/?key_name_01
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTObjectDELETE.html
**Delete Multiple Objects in one command,
Example using POST http://myhost:8080/awsapi/rest/AmazonS3/mybucket3/?delete
Specified at aws.amazon.com/releasenotes/Amazon-S3/7816383882128829
**Copy an Object between Buckets,
Example using PUT http://myhost:8080/awsapi/rest/AmazonS3/mybucket2/key_k1b1
Specified at docs.amazonwebservices.com/AmazonS3/latest/API/RESTObjectCopy.html
...
It is not envisaged that any other CloudStack software need access these tables.
| Code Block |
|---|
Tables |
| Tables | +------------------- |
...
acl
+ | acl | | bucket_policies |
...
meta
...
mhost
| | meta | | mhost | | mhost_mount |
...
| | multipart_meta |
...
| | multipart_parts |
...
| | multipart_uploads |
...
| | offering_bundle |
...
sbucket
...
shost
...
sobject
...
sobject_item
...
|
| sbucket |
| shost |
| sobject |
| sobject_item |
| usercredentials |
|
The tables used are: acl, bucket_policies, meta, mhost, mhost_mount, multipart_meta, multipart_parts, multipart_uploads, offering_bundle, sbucket , shost, sobject, sobject_item, usercredentials
...
The design imposes a service lifecycle in which
#The ##The incoming request is interpreted.
#The ##The authentication of the request is appended to it.
#The ##The service which processes the request provides a response.
#The ##The informational response is returned if successful or an error response provided otherwise, in accordance with http://docs.amazonwebservices.com/AmazonS3/latest/dev/UsingRESTError.html.
To validate the request data structure (termed the canonical string) the following rules are enforced by the design:
#List ##List 4 properties of the request delimited by \n: HTTP verb, MD5 hash of uploaded data, content type of uploaded data, datetimestamp for request might be time request will expire. All except MD5 hash are mandatory. Datetimestamp has to be Rfc2616 compliant indicating the ISO 8601 format.
#Add ##Add x-amz- headers to description in alpha order, converting to lowercase.
#Add ##Add path component of URI without any parameters.
#Include ##Include query parameters iff they are mandatory to identify the resource: specifically acl, torrent, logging and location.
In processing the URI, three formats can be distinguished:
#uri ##uri including default service hostname, with bucket name and object name (if any) in path
#uri ##uri with bucket name prepended the service hostname, i.e. subdomain style
#uri ##uri with virtual hostname matching bucket name, providing that the bucket name is a DNS entry providing a CNAME for the entry as if it were a subdomain.
...
A hibernate layer coordinates between the business logic executed in the rest servlet and the SQL definitions in the MySQL database. See also Appendix 2.
Appendix
Usage
#Get ##Get CloudStack running on the latest 3.0.x series
#Enable ##Enable the S3 API by setting the flag enable.s3.api to 'true' in the configuration table. This can be done through the UI or directly in MySQL:
update configuration set value='true' where name='enable.s3.api';
#Choose ##Choose a local filesystem path where the objects will be stored. We can mount an NFS store or use the local filesystem. E.g,:
***mkdir -p /mnt/s3
***Ensure that the 'cloud' user can write to this directory
#Edit ##Edit the file $TOMCAT_HOME/conf/cloud-bridge.properties:
host ***host=http://localhost:8080/awsapi
storage.multipartDir=_multipartuploads_
bucket.dns=false
storage.root=<mount point or filesystem path>
serviceEndpoint=localhost:8080
#Restart ##Restart CloudStack.
#Obtain ##Obtain API and secret keys for a user (available in the Admin ui under Accounts -> Users)
***CloudStack Api key = this is the same as the AWS access key id
***CloudStack Secret key = this is the same as the AWS secret access key
#Generate ##Generate a private key and a self-signed X.509 certificate. Substitute your own desired storage location for /path/to/… below.
***$ openssl req -x509 -nodes -days 365 -newkey rsa:2048 <http://rsa:2048/> -keyout /path/to/private_key.pem -out /path/to/cert.pem
#Register ##Register the mapping from the X.509 certificate to your accounts API keys with CloudStack.
***$ cloudstack-aws-api-register --apikey=<User’s Cloudstack API key> --secretkey=<User’s CloudStack Secret key> --cert=</path/to/cert.pem> --url=http://<cloudstack-server>:8080/awsapi/rest/AmazonS3
#Configure ##Configure the boto S3Connection object as follows:
| Code Block |
|---|
calling_format= OrdinaryCallingFormat() |
...
connection = S3Connection(aws_access_key_id=<your api key>, |
...
aws_secret_access_key=<your secret key> |
...
is_secure=False, |
...
host='<cloudstack-server>', |
...
port=7080, |
...
calling_format=calling_format, |
...
path="/awsapi/rest/AmazonS3") |
Appendix 1
CLOUDBRIDGE data definitions
| Code Block |
|---|
acl |
...
+--------------------+--------------+------+-----+--------- |
...
+ |
...
Field | Type | Null | Key | Default | Extra |
---------------- |
...
+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+---------+--------- |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
Target | varchar(64) | NO | MUL | NULL |
|
TargetID | bigint(20) | NO |
| NULL |
|
GranteeType | int(11) | NO |
| 0 |
|
GranteeCanonicalID | varchar(150) | YES |
| NULL |
|
Permission | int(11) | NO |
| 0 |
|
GrantOrder | int(11) | NO |
| 0 |
|
CreateTime | datetime | YES |
| NULL |
|
LastModifiedTime | datetime | YES | MUL | NULL |
|
-------+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | Target | varchar(64) | NO | MUL | NULL | | | TargetID | bigint(20) | NO | | NULL | | | GranteeType | int(11) | NO | | 0 | | | GranteeCanonicalID | varchar(150) | YES | | NULL | | | Permission | int(11) | NO | | 0 | | | GrantOrder | int(11) | NO | | 0 | | | CreateTime | datetime | YES | | NULL | | | LastModifiedTime | datetime | YES | MUL | NULL | | +--------------------+--------------+------+-----+--------- |
...
+ |
...
----------------+ bucket_policies +------------------+---------------- |
...
+------+ |
...
Field | Type | Null | Key | Default | Extra |
-----+--------- |
...
+---------------- |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
BucketName | varchar(64) | NO | UNI | NULL |
|
OwnerCanonicalID | varchar(150) | NO |
| NULL |
|
Policy | varchar(20000) | NO |
| NULL |
|
+ | Field | Type | Null | Key | Default | Extra | +------------------+----------------+------+-----+--------- |
...
+ |
...
---------------- |
...
Field | Type | Null | Key | Default | Extra |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
Target | varchar(64) | NO | MUL | NULL |
|
TargetID | bigint(20) | NO |
| NULL |
|
Name | varchar(64) | NO |
| NULL |
|
Value | varchar(256) | YES |
| NULL |
|
+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | BucketName | varchar(64) | NO | UNI | NULL | | | OwnerCanonicalID | varchar(150) | NO | | NULL | | | Policy | varchar(20000) | NO | | NULL | | +------------------+----------------+------+-----+----- |
...
----+----------------+ meta +----------+--------------+------+-----+---- |
...
Field | Type | Null | Key | Default | Extra |
-----+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+--------- |
...
ID
-------+ | ID | bigint(20) |
...
NO
...
PRI
...
NULL
...
auto_increment
...
MHostKey
...
varchar(128)
...
NO
...
MUL
...
NULL
...
...
Host
...
varchar(128)
...
YES
...
UNI
...
NULL
...
...
Version
...
varchar(64)
...
YES
...
...
NULL
...
...
LastHeartbeatTime
...
datetime
...
YES
...
MUL
...
NULL
...
| NO | PRI | NULL | auto_increment | | Target | varchar(64) | NO | MUL | NULL | | | TargetID | bigint(20) | NO | | NULL | | | Name | varchar(64) | NO | | NULL | | | Value | varchar(256) | YES | | NULL | | +----------+--------------+------+-----+---------+----------------+ |
...
mhost +-------------------+--------------+------+----- |
...
+--------- |
...
+ |
...
Field | Type | Null | Key | Default | Extra |
---------------- |
...
+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+----------------+ |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
MHostID | bigint(20) | NO | MUL | NULL |
|
SHostID | bigint(20) | NO | MUL | NULL |
|
MountPath | varchar(256) | YES |
| NULL |
|
LastMountTime | datetime | YES | MUL | NULL |
|
...
| ID | bigint(20) | NO | PRI | NULL | auto_increment | | MHostKey | varchar(128) | NO | MUL | NULL | | | Host | varchar(128) | YES | UNI | NULL | | | Version | varchar(64) | YES | | NULL | | | LastHeartbeatTime | datetime | YES | MUL | NULL | | +-------------------+--------------+------+-----+---- |
...
-----+----------------+ mhost_mount +---------------+--------------+------+-----+ |
...
Field | Type | Null | Key | Default | Extra |
---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+ |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
UploadID | bigint(20) | NO | MUL | NULL |
|
Name | varchar(64) | NO |
| NULL |
|
Value | varchar(256) | YES |
| NULL |
|
------+-----+--------- |
...
+----------------+ |
...
Field | Type | Null | Key | Default | Extra |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
UploadID | bigint(20) | NO | MUL | NULL |
|
partNumber | int(11) | NO |
| NULL |
|
MD5 | varchar(128) | YES |
| NULL |
|
StoredPath | varchar(256) | YES |
| NULL |
|
StoredSize | bigint(20) | NO |
| 0 |
|
CreateTime | datetime | YES |
| NULL |
|
...
| ID | bigint(20) | NO | PRI | NULL | auto_increment | | MHostID | bigint(20) | NO | MUL | NULL | | | SHostID | bigint(20) | NO | MUL | NULL | | | MountPath | varchar(256) | YES | | NULL | | | LastMountTime | datetime | YES | MUL | NULL | | +---------------+--------------+------+-----+---------+ |
...
----------------+ multipart_meta +----------+--------------+------+----- |
...
Field | Type | Null | Key | Default | Extra |
+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+---- |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
AccessKey | varchar(150) | NO |
| NULL |
|
BucketName | varchar(64) | NO |
| NULL |
|
NameKey | varchar(255) | NO |
| NULL |
|
x_amz_acl | varchar(64) | YES |
| NULL |
|
CreateTime | datetime | YES |
| NULL |
|
...
--+-----+---------+---------------- |
...
Field | Type | Null | Key | Default | Extra |
+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | UploadID | bigint(20) | NO | MUL | NULL | | | Name | varchar(64) | NO | | NULL | | | Value | varchar(256) | YES | | NULL | | +----------+--------------+------+-----+---------+---------------- |
...
ID | int(11) | NO | PRI | NULL | auto_increment |
AmazonEC2Offering | varchar(100) | NO | UNI | NULL |
|
CloudStackOffering | varchar(20) | NO |
| NULL |
|
+ multipart_parts +------------+--------------+------+-----+---------+---------------- |
...
+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+------------ |
...
Field | Type | Null | Key | Default | Extra |
...
----+ |
...
ID
| ID | bigint(20) |
...
NO
...
PRI
...
NULL
...
auto_increment
...
Name
...
varchar(64)
...
NO
...
UNI
...
NULL
...
...
OwnerCanonicalID
...
varchar(150)
...
NO
...
MUL
...
NULL
...
...
SHostID
...
bigint(20)
...
YES
...
MUL
...
NULL
...
...
CreateTime
...
datetime
...
YES
...
MUL
...
NULL
...
...
VersioningStatus
...
int(11)
...
NO
...
...
0
...
...
| NO | PRI | NULL | auto_increment | | UploadID | bigint(20) | NO | MUL | NULL | | | partNumber | int(11) | NO | | NULL | | | MD5 | varchar(128) | YES | | NULL | | | StoredPath | varchar(256) | YES | | NULL | | | StoredSize | bigint(20) | NO | | 0 | | | CreateTime | datetime | YES | | NULL | | +------------+--------------+------ |
...
+----- |
...
+ |
...
---------+----------------+ multipart_uploads +------------+-------------- |
...
+ |
...
Field | Type | Null | Key | Default | Extra |
------+-----+---------+---------------- |
...
+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+------------- |
...
ID
---+ | ID | bigint(20) |
...
NO
...
PRI
...
NULL
...
auto_increment
...
Host
...
varchar(128)
...
NO
...
MUL
...
NULL
...
...
HostType
...
int(11)
...
NO
...
...
0
...
...
ExportRoot
...
varchar(128)
...
NO
...
...
NULL
...
...
MHostID
...
bigint(20)
...
YES
...
MUL
...
NULL
...
...
UserOnHost
...
varchar(64)
...
YES
...
...
NULL
...
...
UserPasssword
...
varchar(128)
...
YES
...
...
NULL
...
...
UserPassword
...
varchar(255)
...
YES
...
...
NULL
...
| NO | PRI | NULL | auto_increment | | AccessKey | varchar(150) | NO | | NULL | | | BucketName | varchar(64) | NO | | NULL | | | NameKey | varchar(255) | NO | | NULL | | | x_amz_acl | varchar(64) | YES | | NULL | | | CreateTime | datetime | YES | | NULL | | +------------+--------------+------+----- |
...
+--------- |
...
+ |
...
----------------+ offering_bundle +--------------------+--------------+------ |
...
+ |
...
Field | Type | Null | Key | Default | Extra |
-----+---------+---------------- |
...
+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+ |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
SBucketID | bigint(20) | NO | MUL | NULL |
|
NameKey | varchar(255) | NO |
| NULL |
|
OwnerCanonicalID | varchar(150) | NO | MUL | NULL |
|
NextSequence | int(11) | NO |
| 1 |
|
DeletionMark | varchar(150) | YES |
| NULL |
|
CreateTime | datetime | YES | MUL | NULL |
|
------+-----+---------+---------------- |
...
+ | ID | int(11) | NO | PRI | NULL | auto_increment | | AmazonEC2Offering | varchar(100) | NO | UNI | NULL | | | CloudStackOffering | varchar(20) | NO | | NULL | | +--------------------+-------------- |
...
+------+ |
...
Field | Type | Null | Key | Default | Extra |
-----+---------+----------------+ sbucket +------------------+--------------+------+-----+---------+---------- |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
SObjectID | bigint(20) | NO | MUL | NULL |
|
Version | varchar(64) | YES |
| NULL |
|
MD5 | varchar(128) | YES |
| NULL |
|
StoredPath | varchar(256) | YES |
| NULL |
|
StoredSize | bigint(20) | NO | MUL | 0 |
|
CreateTime | datetime | YES | MUL | NULL |
|
LastModifiedTime | datetime | YES | MUL | NULL |
|
LastAccessTime | datetime | YES | MUL | NULL |
|
------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+----- |
...
+--------- |
...
+ |
...
---------------- |
...
Field | Type | Null | Key | Default | Extra |
...
+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | Name | varchar(64) | NO | UNI | NULL | | | OwnerCanonicalID | varchar(150) | NO | MUL | NULL | | | SHostID | bigint(20) | YES | MUL | NULL | | | CreateTime | datetime | YES | MUL | NULL | | | VersioningStatus | int(11) | NO | | 0 | | +------------------+--------------+------+-----+---------+----------------+ shost +---------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+----------------+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | Host | varchar(128) | NO | MUL | NULL | | | HostType | int(11) | NO | | 0 | | | ExportRoot | varchar(128) | NO | | NULL | | | MHostID | bigint(20) | YES | MUL | NULL | | | UserOnHost | varchar(64) | YES | | NULL | | | UserPasssword | varchar(128) | YES | | NULL | | | UserPassword | varchar(255) | YES | | NULL | | +---------------+--------------+------+-----+---------+----------------+ sobject +------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+----------------+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | SBucketID | bigint(20) | NO | MUL | NULL | | | NameKey | varchar(255) | NO | | NULL | | | OwnerCanonicalID | varchar(150) | NO | MUL | NULL | | | NextSequence | int(11) | NO | | 1 | | | DeletionMark | varchar(150) | YES | | NULL | | | CreateTime | datetime | YES | MUL | NULL | | +------------------+--------------+------+-----+---------+----------------+ sobject_item +------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+----------------+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | SObjectID | bigint(20) | NO | MUL | NULL | | | Version | varchar(64) | YES | | NULL | | | MD5 | varchar(128) | YES | | NULL | | | StoredPath | varchar(256) | YES | | NULL | | | StoredSize | bigint(20) | NO | MUL | 0 | | | CreateTime | datetime | YES | MUL | NULL | | | LastModifiedTime | datetime | YES | MUL | NULL | | | LastAccessTime | datetime | YES | MUL | NULL | | +------------------+--------------+------+-----+---------+----------------+ usercredentials +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | AccessKey | varchar(150) | NO | UNI | NULL | | | SecretKey | varchar(150) | NO | | NULL | | | CertUniqueId | varchar(200) | YES | UNI | NULL | | +--------------+-------------- |
...
+ |
...
ID | bigint(20) | NO | PRI | NULL | auto_increment |
AccessKey | varchar(150) | NO | UNI | NULL |
|
SecretKey | varchar(150) | NO |
| NULL |
|
CertUniqueId | varchar(200) | YES | UNI | NULL |
|
------+-----+--------- |
...
+---------------- |
...
+
|
Appendix 2
OR mapping definitions
Overview
Content Tools
Apps