Typecho数据库设计&实操指南
Typecho 数据库操作
数据库设计
Typecho数据库设计文档: https://docs.typecho.org/database
控制台操作
登录 Mysql/MariaDB:
mysql -u root -p表操作：
# 显示数据库
show databases;
# 切换到 typecho 数据库
use typecho;
# 显示数据表
show tables;
# +-----------------------+
# | Tables_in_typecho |
# +-----------------------+
# | typecho_comments | # 评论表
# | typecho_contents | # 内容表
# | typecho_fields | # 字段表
# | typecho_metas | # 分类表
# | typecho_options | # 配置表
# | typecho_relationships | # 关联表
# | typecho_users | # 用户表
# +-----------------------+
# 查看表字段
describe typecho_fields;
# +-------------+------------------+------+-----+---------+-------+
# | Field | Type | Null | Key | Default | Extra |
# +-------------+------------------+------+-----+---------+-------+
# | cid | int(10) unsigned | NO | PRI | NULL | |
# | name | varchar(150) | NO | PRI | NULL | |
# | type | varchar(8) | YES | | str | |
# | str_value | text | YES | | NULL | |
# | int_value | int(10) | YES | MUL | 0 | |
# | float_value | float | YES | MUL | 0 | |
# +-------------+------------------+------+-----+---------+-------+
describe typecho_users;
# +------------+------------------+------+-----+---------+----------------+
# | Field | Type | Null | Key | Default | Extra |
# +------------+------------------+------+-----+---------+----------------+
# | uid | int(10) unsigned | NO | PRI | NULL | auto_increment |
# | name | varchar(32) | YES | UNI | NULL | |
# | password | varchar(64) | YES | | NULL | |
# | mail | varchar(150) | YES | UNI | NULL | |
# | url | varchar(150) | YES | | NULL | |
# | screenName | varchar(32) | YES | | NULL | |
# | created | int(10) unsigned | YES | | 0 | |
# | activated | int(10) unsigned | YES | | 0 | |
# | logged | int(10) unsigned | YES | | 0 | |
# | group | varchar(16) | YES | | visitor | |
# | authCode | varchar(64) | YES | | NULL | |
# +------------+------------------+------+-----+---------+----------------+
describe typecho_comments;
# +----------+------------------+------+-----+----------+----------------+
# | Field | Type | Null | Key | Default | Extra |
# +----------+------------------+------+-----+----------+----------------+
# | coid | int(10) unsigned | NO | PRI | NULL | auto_increment |
# | cid | int(10) unsigned | YES | MUL | 0 | |
# | created | int(10) unsigned | YES | MUL | 0 | |
# | author | varchar(150) | YES | | NULL | |
# | authorId | int(10) unsigned | YES | | 0 | |
# | ownerId | int(10) unsigned | YES | | 0 | |
# | mail | varchar(150) | YES | | NULL | |
# | url | varchar(255) | YES | | NULL | |
# | ip | varchar(64) | YES | | NULL | |
# | agent | varchar(511) | YES | | NULL | |
# | text | text | YES | | NULL | |
# | type | varchar(16) | YES | | comment | |
# | status | varchar(16) | YES | | approved | |
# | parent | int(10) unsigned | YES | | 0 | |
# +----------+------------------+------+-----+----------+----------------+
describe typecho_contents;
# +--------------+------------------+------+-----+---------+----------------+
# | Field | Type | Null | Key | Default | Extra |
# +--------------+------------------+------+-----+---------+----------------+
# | cid | int(10) unsigned | NO | PRI | NULL | auto_increment |
# | title | varchar(150) | YES | | NULL | |
# | slug | varchar(150) | YES | UNI | NULL | |
# | created | int(10) unsigned | YES | MUL | 0 | |
# | modified | int(10) unsigned | YES | | 0 | |
# | text | longtext | YES | | NULL | |
# | order | int(10) unsigned | YES | | 0 | |
# | authorId | int(10) unsigned | YES | | 0 | |
# | template | varchar(32) | YES | | NULL | |
# | type | varchar(16) | YES | | post | |
# | status | varchar(16) | YES | | publish | |
# | password | varchar(32) | YES | | NULL | |
# | commentsNum | int(10) unsigned | YES | | 0 | |
# | allowComment | char(1) | YES | | 0 | |
# | allowPing | char(1) | YES | | 0 | |
# | allowFeed | char(1) | YES | | 0 | |
# | parent | int(10) unsigned | YES | | 0 | |
# | views | int(10) | NO | | 0 | |
# | agree | int(10) | NO | | 0 | |
# +--------------+------------------+------+-----+---------+----------------+
describe typecho_metas;
# +-------------+------------------+------+-----+---------+----------------+
# | Field | Type | Null | Key | Default | Extra |
# +-------------+------------------+------+-----+---------+----------------+
# | mid | int(10) unsigned | NO | PRI | NULL | auto_increment |
# | name | varchar(150) | YES | | NULL | |
# | slug | varchar(150) | YES | MUL | NULL | |
# | type | varchar(32) | NO | | NULL | |
# | description | varchar(150) | YES | | NULL | |
# | count | int(10) unsigned | YES | | 0 | |
# | order | int(10) unsigned | YES | | 0 | |
# | parent | int(10) unsigned | YES | | 0 | |
# +-------------+------------------+------+-----+---------+----------------+
describe typecho_options;
# +-------+------------------+------+-----+---------+-------+
# | Field | Type | Null | Key | Default | Extra |
# +-------+------------------+------+-----+---------+-------+
# | name | varchar(32) | NO | PRI | NULL | |
# | user | int(10) unsigned | NO | PRI | 0 | |
# | value | text | YES | | NULL | |
# +-------+------------------+------+-----+---------+-------+
describe typecho_relationships;
# +-------+------------------+------+-----+---------+-------+
# | Field | Type | Null | Key | Default | Extra |
# +-------+------------------+------+-----+---------+-------+
# | cid | int(10) unsigned | NO | PRI | NULL | |
# | mid | int(10) unsigned | NO | PRI | NULL | |
# +-------+------------------+------+-----+---------+-------+