OpenStack之Swift：swift表结构

表account_stat

 

ID

名称

类型/长度

缺省值

备注

account

 

TEXT

 

 

created_at

 

TEXT

 

 

put_timestamp

 

TEXT

0

 

delete_timestamp

 

TEXT

0

 

container_count

 

INTEGER

 

 

object_count

 

INTEGER

0

 

bytes_used

 

INTEGER

0

 

hash

 

TEXT

 

32个0

id

 

TEXT

 

 

status

 

TEXT

‘’

 

status_changed_at

 

TEXT

0

 

metadata

 

TEXT

‘’

 

表outgoing_sync

ID

名称

类型/长度

缺省值

备注

remote_id

 

TEXT

 

UNIQUE

sync_point

 

INTEGER

 

 

updated_at

 

TEXT

0

 

表incoming_sync

ID

名称

类型/长度

缺省值

备注

remote_id

 

TEXT

 

UNIQUE

sync_point

 

INTEGER

 

 

updated_at

 

TEXT

0

 

 容器表 container

ID

名称

类型/长度

缺省值

备注

ROWID

 

INTEGER

 

PK AUTOINCREMENT

name

 

TEXT

 

 

put_timestamp

 

TEXT

0

 

delete_timestamp

 

TEXT

 

 

object_count

 

INTEGER

 

 

bytes_used

 

INTEGER

 

 

deleted

 

INTEGER

0

 

对象表 object

ID

名称

类型/长度

缺省值

备注

ROWID

 

INTEGER

 

PK AUTOINCREMENT

name

 

TEXT

 

 

created_at

 

TEXT

0

 

size

 

INTEGER

 

 

Content_type

 

INTEGER

 

 

etag

 

TEXT

 

 

deleted

 

INTEGER

0

 

container_stat

ID

名称

类型/长度

缺省值

备注

ID

名称

类型/长度

缺省值

备注

account

 

TEXT

 

 

container

 

TEXT

 

 

created_at

 

TEXT

 

 

put_timestamp

 

TEXT

0

 

delete_timestamp

 

TEXT

0

 

reported_put_timestamp

 

TEXT

0

 

reported_delete_timestamp

 

TEXT

0

 

reported_object_count

 

INTEGER

0

 

reported_bytes_used

 

INTEGER

0

 

object_count

 

INTEGER

 

 

bytes_used

 

INTEGER

 

 

hash

 

TEXT

 

32个0

id

 

TEXT

 

 

status

 

TEXT

‘’

 

status_changed_at

 

TEXT

0

 

metadata

 

TEXT

‘’

 

x_container_sync_point1

 

INTEGER

-1

 

x_container_sync_point2

 

INTEGER

-1

 

 

在账户数据库中，详情如下：

table|outgoing_sync|outgoing_sync|2|CREATETABLE outgoing_sync (

                remote_id TEXT UNIQUE,

                sync_point INTEGER,

                updated_at TEXT DEFAULT 0

            )

table|incoming_sync|incoming_sync|4|CREATETABLE incoming_sync (

                remote_id TEXT UNIQUE,

                sync_point INTEGER,

                updated_at TEXT DEFAULT 0

            )

table|container|container|8|CREATETABLE container (

                ROWID INTEGER PRIMARY KEYAUTOINCREMENT,

                name TEXT,

                put_timestamp TEXT,

                delete_timestamp TEXT,

                object_count INTEGER,

                bytes_used INTEGER,

                deleted INTEGER DEFAULT 0

            )

table|sqlite_sequence|sqlite_sequence|10|CREATETABLE sqlite_sequence(name,seq)

table|account_stat|account_stat|14|CREATETABLE account_stat (

                account TEXT,

                created_at TEXT,

                put_timestamp TEXT DEFAULT '0',

                delete_timestamp TEXT DEFAULT'0',

                container_count INTEGER,

                object_count INTEGER DEFAULT 0,

                bytes_used INTEGER DEFAULT 0,

                hash TEXT default'00000000000000000000000000000000',

                id TEXT,

                status TEXT DEFAULT '',

                status_changed_at TEXT DEFAULT'0',

                metadata TEXT DEFAULT ''

            )

在内容服务器数据库中，数据表详情如下：

sqlite>  select * from sqlite_master WHERE type ="table";

table|outgoing_sync|outgoing_sync|2|CREATETABLE outgoing_sync (

                remote_id TEXT UNIQUE,

                sync_point INTEGER,

                updated_at TEXT DEFAULT 0

            )

table|incoming_sync|incoming_sync|4|CREATETABLE incoming_sync (

                remote_id TEXT UNIQUE,

                sync_point INTEGER,

                updated_at TEXT DEFAULT 0

            )

table|object|object|8|CREATETABLE object (

                ROWID INTEGER PRIMARY KEYAUTOINCREMENT,

                name TEXT,

                created_at TEXT,

                size INTEGER,

                content_type TEXT,

                etag TEXT,

                deleted INTEGER DEFAULT 0

            )

table|sqlite_sequence|sqlite_sequence|10|CREATETABLE sqlite_sequence(name,seq)

table|container_stat|container_stat|13|CREATETABLE container_stat (

                account TEXT,

                container TEXT,

                created_at TEXT,

                put_timestamp TEXT DEFAULT '0',

                delete_timestamp TEXT DEFAULT'0',

                object_count INTEGER,

                bytes_used INTEGER,

                reported_put_timestamp TEXTDEFAULT '0',

                reported_delete_timestamp TEXTDEFAULT '0',

                reported_object_count INTEGERDEFAULT 0,

                reported_bytes_used INTEGERDEFAULT 0,

                hash TEXT default'00000000000000000000000000000000',

                id TEXT,

                status TEXT DEFAULT '',

                status_changed_at TEXT DEFAULT'0',

                metadata TEXT DEFAULT '',

                x_container_sync_point1 INTEGERDEFAULT -1,

                x_container_sync_point2 INTEGERDEFAULT -1

            )