CREATE TABLE cdb_changename (
id smallint(6) NOT NULL auto_increment,
uid int NOT NULL default '',
oldname varchar(20) NOT NULL default '',
newname varchar(20) NOT NULL default '',
reason text NOT NULL default '',
time varchar(10) NOT NULL default '',
ischeck Tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
);
有点自相矛盾。。。
NOT NULL 但是 default 为 ' '
应该改成:
- CREATE TABLE cdb_changename (
- id smallint(6) NOT NULL auto_increment,
- uid int NOT NULL,
- oldname varchar(20) NOT NULL,
- newname varchar(20) NOT NULL,
- reason text NOT NULL,
- time varchar(10) NOT NULL,
- ischeck Tinyint(1) NOT NULL default '0',
- PRIMARY KEY (id)
- );
复制代码 |