phpBB España Oficial

Código: Seleccionar todo

CREATE TABLE `phpbb_autolinks` (
  `link_id` mediumint(5) unsigned NOT NULL auto_increment,
  `link_keyword` varchar(50) NOT NULL,
  `link_title` varchar(50) NOT NULL,
  `link_url` varchar(200) NOT NULL,
  `link_comment` varchar(200) NOT NULL,
  `link_style` varchar(200) NOT NULL,
  `link_forum` tinyint(1) NOT NUL default '0',
  `link_int` tinyint(1) NOT NULL default '0',
  KEY `link_id` (`link_id`)
) TYPE=MyISAM;

INSERT INTO `phpbb_autolinks` VALUES (1, 'phpbb', 'phpBB', 'http://www.phpbb.com', 'phpBB creating communities', 'text-decoration: none;', '0', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('autolink_first', '0');

Código: Seleccionar todo

Error
consulta SQL: 

CREATE TABLE `phpbb_autolinks` (

`link_id` mediumint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`link_keyword` varchar( 50 ) NOT NULL ,
`link_title` varchar( 50 ) NOT NULL ,
`link_url` varchar( 200 ) NOT NULL ,
`link_comment` varchar( 200 ) NOT NULL ,
`link_style` varchar( 200 ) NOT NULL ,
`link_forum` tinyint( 1 ) NOT NUL default '0',
`link_int` tinyint( 1 ) NOT NULL default '0',
KEY `link_id` ( `link_id` ) 
) TYPE = MYISAM ;



MySQL ha dicho:  

#1064 - 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 'NUL default '0',
  `link_int` tinyint(1) NOT NULL default '0',
  KEY `link_id`' at line 8 

Código: Seleccionar todo

CREATE TABLE `phpbb_autolinks` (
  `link_id` mediumint(5) unsigned NOT NULL auto_increment,
  `link_keyword` varchar(50) NOT NULL,
  `link_title` varchar(50) NOT NULL,
  `link_url` varchar(200) NOT NULL,
  `link_comment` varchar(200) NOT NULL,
  `link_style` varchar(200) NOT NULL,
  `link_forum` tinyint(1) NOT NULL default '0',
  `link_int` tinyint(1) NOT NULL default '0',
  KEY `link_id` (`link_id`)
) TYPE=MyISAM;

INSERT INTO `phpbb_autolinks` VALUES (1, 'phpbb', 'phpBB', 'http://www.phpbb.com', 'phpBB creating communities', 'text-decoration: none;', '0', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('autolink_first', '0');