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

            )