Time: 2007-12-26 3:06am
Script:
SQL: DROP TABLE IF EXISTS [Table]olympicforums;
CREATE TABLE [Table]olympicforums (
fid smallint(6) unsigned NOT NULL auto_increment,
forumid smallint(6) unsigned NOT NULL,
fup smallint(6) unsigned NOT NULL,
`type` enum('group','forum') NOT NULL default 'forum',
`name` char(50) NOT NULL,
description char(255) NOT NULL,
logo char(255) NOT NULL,
`status` tinyint(1) NOT NULL,
displayorder tinyint(3) NOT NULL,
PRIMARY KEY (fid),
KEY forum (`status`,`type`,displayorder),
KEY fup (fup)
) TYPE=MyISAM;
INSERT INTO [Table]olympicforums (fid, forumid, fup, type, name, description, logo, status, displayorder) VALUES (1, 1, 0, 'group', '奥运社区', '', '', 1, 0);
INSERT INTO [Table]olympicforums (fid, forumid, fup, type, name, description, logo, status, displayorder) VALUES (2, 2, 1, 'forum', '全民奥运 我是冠军', '每个论坛都是“参赛国家”，每个用户都是“奥运选手”，快来参与这场全民的奥运盛会吧', 'http://www.insenz.com/misc/images/shequ2008_logo.gif', 1, 0);
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 ';
CREATE TABLE [Table]olympicforums (
fid smallint(6) unsigned NOT NULL auto_inc' at line 1
Errno.: 1064
