ошибка в запросе Sql
Запрос
CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
Ошибка
[Err] 1050 - Table 'l2top' already exists
[Err] CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Запрос
ALTER TABLE `donate` CHANGE `state` `state` ENUM( '0', 'I', 'E', 'P', 'S' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' ;
ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
ALTER TABLE `donate` ADD `payer_purse` VARCHAR( 13 ) NOT NULL AFTER `payer_wm` ;
ALTER TABLE `donate` ADD `invs_no` VARCHAR( 11 ) NOT NULL AFTER `payer_purse` ;
ALTER TABLE `donate` ADD `trans_no` VARCHAR( 11 ) NOT NULL AFTER `invs_no` ;
ALTER TABLE `donate` ADD `trans_date` VARCHAR( 17 ) NOT NULL AFTER `trans_no` ;
Ошибка
[Err] 1060 - Duplicate column name 'payer_wm'
[Err] ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Ошибка
[Err] 1060 - Duplicate column name 'email'
[Err] ALTER TABLE `accounts` ADD `email` VARCHAR( 50 ) NULL ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Запрос
ALTER TABLE `characters` ADD `lastteleport` DECIMAL( 20, 0 ) NULL DEFAULT NULL;
Ошибка
[Err] 1060 - Duplicate column name 'lastteleport'
[Err] ALTER TABLE `characters` ADD `lastteleport` DECIMAL( 20, 0 ) NULL DEFAULT NULL;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Запрос
CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
Ошибка
[Err] 1050 - Table 'l2top' already exists
[Err] CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Запрос
ALTER TABLE `donate` CHANGE `state` `state` ENUM( '0', 'I', 'E', 'P', 'S' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' ;
ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
ALTER TABLE `donate` ADD `payer_purse` VARCHAR( 13 ) NOT NULL AFTER `payer_wm` ;
ALTER TABLE `donate` ADD `invs_no` VARCHAR( 11 ) NOT NULL AFTER `payer_purse` ;
ALTER TABLE `donate` ADD `trans_no` VARCHAR( 11 ) NOT NULL AFTER `invs_no` ;
ALTER TABLE `donate` ADD `trans_date` VARCHAR( 17 ) NOT NULL AFTER `trans_no` ;
Ошибка
[Err] 1060 - Duplicate column name 'payer_wm'
[Err] ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Сори Сори, затупил, это ошибка дубликации, что уже такое существует....модераторы удалите тему(уже 2 сутки не сплю, и туплю)

