немогу залить запрос

Код:

CREATE TABLE IF NOT EXISTS `l2top` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `account` varchar(45) NOT NULL,
  `character` varchar(30) NOT NULL,
  `charid` INT NULL DEFAULT '0' ;
  `server` tinyint(3) NOT NULL DEFAULT '0',
  `time` varchar(20) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 ;

Liiion911 пишет:Ошибку покажи

Код:

ERROR 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 '' at line 5
ERROR 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 '`server` tinyint(3) NOT NULL DEFAULT '0',
  `time` varchar(20) NOT NULL,
  `da' at line 1

Код:

CREATE TABLE IF NOT EXISTS `l2top` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `account` varchar(45) NOT NULL,
  `character` varchar(30) NOT NULL,
  `charid` INT NULL DEFAULT '0',
  `server` tinyint(3) NOT NULL DEFAULT '0',
  `time` varchar(20) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251

Liiion911 пишет:

Код:

CREATE TABLE IF NOT EXISTS `l2top` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `account` varchar(45) NOT NULL,
  `character` varchar(30) NOT NULL,
  `charid` INT NULL DEFAULT '0',
  `server` tinyint(3) NOT NULL DEFAULT '0',
  `time` varchar(20) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251

Liiion911 пишет:может уже есть таблица l2top ? удали и запрос заного...

Код:

[Err] 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 '' at line 10
[Err] CREATE TABLE IF NOT EXISTS `l2top` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `account` varchar(45) NOT NULL,
  `character` varchar(30) NOT NULL,
  `charid` INT NULL DEFAULT '0',
  `server` tinyint(3) NOT NULL DEFAULT '0',
  `time` varchar(20) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
[Msg] Finished - Unsuccessfully
--------------------------------------------------


CREATE TABLE IF NOT EXISTS `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`account` varchar(45) NOT NULL,
`character` varchar(30) NOT NULL,
`charid` INT NULL DEFAULT '0',
`server` tinyint(3) NOT NULL DEFAULT '0',
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`active` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

ArtiShok пишет:

CREATE TABLE IF NOT EXISTS `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`account` varchar(45) NOT NULL,
`character` varchar(30) NOT NULL,
`charid` INT NULL DEFAULT '0',
`server` tinyint(3) NOT NULL DEFAULT '0',
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`active` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

Иногда переводите ошибки.
Исправил пробуй