|
Discuz! info: MySQL Query Error
User: HKLKC
Time: 2006-8-4 6:58pm
Script: /friends_install.php
SQL: CREATE TABLE `cdb_friends` (
`uid` int(4) NOT NULL,
`username` varchar(15) NOT NULL,
`identify` tinyint(1) DEFAULT '0' NOT NULL,
`allowfriend` tinyint(1) DEFAULT '0' NOT NULL,
`nature` varchar(15) DEFAULT '不提供',
`body` VARCHAR(15) DEFAULT '不提供',
`smoke` VARCHAR(15) DEFAULT '不提供',
`drunk` VARCHAR(15) DEFAULT '不提供',
`god` VARCHAR(15) DEFAULT '不提供',
`job` VARCHAR(15) DEFAULT '不提供',
`education` VARCHAR(15) DEFAULT '不提供' ,
`love` VARCHAR(15) DEFAULT '不提供' ,
`friend` VARCHAR(15) DEFAULT '不提供' ,
`hobby` VARCHAR(255) DEFAULT '不提供' ,
`choice` VARCHAR(255) DEFAULT '不提供' ,
`other` VARCHAR(255) DEFAULT '不提供' ,
`age` VARCHAR(2),
`hits` VARCHAR(50) DEFAULT '0',
`avatype` tinyint(1) DEFAULT '0',
`friendsavatar` VARCHAR(255),
`location` VARCHAR(30) DEFAULT '不提供',
`lastvisitip` VARCHAR(15),
PRIMARY KEY (`uid`)
)
Error: Invalid default value for 'nature'
Errno.: 1067
Similar error report has beed dispatched to administrator before.
|