表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
)