-- Licensed to the Apache Software Foundation (ASF) under one

-- or more contributor license agreements. See the NOTICE file

-- distributed with this work for additional information

-- regarding copyright ownership. The ASF licenses this file

-- to you under the Apache License, Version 2.0 (the

-- "License"); you may not use this file except in compliance

-- with the License. You may obtain a copy of the License at

--

-- http://www.apache.org/licenses/LICENSE-2.0

--

-- Unless required by applicable law or agreed to in writing,

-- software distributed under the License is distributed on an

-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

-- KIND, either express or implied. See the License for the

-- specific language governing permissions and limitations

-- under the License.

USE cloudbridge;

-- This file can be applied to an existing cloudbridge database. It is used

-- to keep track of in progress multipart file uploads.

--

SET foreign_key_checks = 0;

DROP TABLE IF EXISTS multipart_uploads;

DROP TABLE IF EXISTS multipart_meta;

DROP TABLE IF EXISTS multipart_parts;

-- We need to keep track of the multipart uploads and all the parts of each upload until they

-- are completed or aborted.

-- The AccessKey is where we store the AWS account id

--

CREATE TABLE multipart_uploads (

ID BIGINT NOT NULL AUTO_INCREMENT,

AccessKey VARCHAR(150) NOT NULL, -- this is the initiator of the request

BucketName VARCHAR(64) NOT NULL,

NameKey VARCHAR(255) NOT NULL,

x_amz_acl VARCHAR(64) NULL,

CreateTime DATETIME,

PRIMARY KEY(ID)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- We need to store all the meta data for an object being mutlipart uploaded

-- UploadID is a foreign key to an entry in the mutipart_uploads table

--

CREATE TABLE multipart_meta (

ID BIGINT NOT NULL AUTO_INCREMENT,

UploadID BIGINT NOT NULL,

Name VARCHAR(64) NOT NULL,

Value VARCHAR(256),

PRIMARY KEY(ID)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Each part of a multipart upload gets a row in this table

-- UploadId is a foreign key to an entry in the mutipart_uploads table

--

CREATE TABLE multipart_parts (

ID BIGINT NOT NULL AUTO_INCREMENT,

UploadID BIGINT NOT NULL,

partNumber INT NOT NULL,

MD5 VARCHAR(128),

StoredPath VARCHAR(256), -- relative to mount point of the root

StoredSize BIGINT NOT NULL DEFAULT 0,

CreateTime DATETIME,

PRIMARY KEY(ID)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET foreign_key_checks = 1;