文章表news都有字段status,为何还要另外做一个表,将处于审核状态的文章复制到这个审核表,直接修改文章表的status字段不是一样的吗?
news 12为字段status
1 id mediumint(8) UNSIGNED
2 catid smallint(5) UNSIGNED
3 typeid smallint(5) UNSIGNED
4 title varchar(200) utf8_general_ci
5 style char(24) utf8_general_ci
6 thumb varchar(100) utf8_general_ci
7 keywords varchar(80) utf8_general_ci
8 description mediumtext utf8_general_ci
9 posids tinyint(1) UNSIGNED
10 url char(100) utf8_general_ci
11 listorder tinyint(3) UNSIGNED
12 status tinyint(2) UNSIGNED
13 sysadd tinyint(1) UNSIGNED
14 islink tinyint(1) UNSIGNED
15 username char(20) utf8_general_ci
16 inputtime int(10) UNSIGNED
17 updatetime int(10) UNSIGNED
content_check 7为字段status
1 checkid char(15) utf8_general_ci
2 catid smallint(5) UNSIGNED
3 siteid smallint(5) UNSIGNED
4 title char(80) utf8_general_ci
5 username char(20) utf8_general_ci
6 inputtime int(10) UNSIGNED
7 status tinyint(1)