Пытался добавлять вручную:
Код: Выделить всё
CREATE TABLE `phpbb_portal` (
`portal_name ` VARCHAR( 255 ) NOT NULL ,
`portal_value ` TEXT NOT NULL ,
PRIMARY KEY ( `portal_name ` )
);
INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` )
VALUES (
'welcome_text', 'Welcome to <b>My Community</b><br /><br />Thanks for using ezPortal,<br /><br />Have a good time! ^_^'
);
INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` )
VALUES (
'number_of_news', '5'
);
INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` )
VALUES (
'news_length', '200'
);
INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` )
VALUES (
'news_forum', '1'
);
INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` )
VALUES (
'poll_forum', '1'
);
INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` )
VALUES (
'number_recent_topics', '10'
);
INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` )
VALUES (
'last_seen', '5'
);
Код: Выделить всё
SQL-запрос:
CREATE TABLE `phpbb_portal` (
`portal_name ` VARCHAR( 255 ) NOT NULL ,
`portal_value ` TEXT NOT NULL ,
PRIMARY KEY ( `portal_name ` )
);
Ответ MySQL:
#1166 - Incorrect column name 'portal_name '