6.1.0升级到7.0.0 正式版问题
Script: /bbs/upgrade11.php
SQL: CREATE TABLE [Table]tasks (
taskid smallint(6) unsigned NOT NULL auto_increment,
relatedtaskid smallint(6) unsigned NOT NULL default '0',
available tinyint(1) NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
description text NOT NULL,
icon varchar(150) NOT NULL default '',
applicants mediumint(8) unsigned NOT NULL default '0',
achievers mediumint(8) unsigned NOT NULL default '0',
tasklimits mediumint(8) unsigned NOT NULL default '0',
applyperm text NOT NULL,
scriptname varchar(50) NOT NULL default '',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
period int(10) unsigned NOT NULL default '0',
reward enum('credit','magic','medal','invite','group') NOT NULL default 'credit',
prize varchar(15) NOT NULL default '',
bonus int(10) NOT NULL default '0',
displayorder smallint(6) unsigned NOT NULL default '0',
version varchar(15) NOT NULL default '',
PRIMARY KEY (taskid)
) ENGINE=MYISAM DEFAULT CHARSET=
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 43
Errno.: 1064 |