[SQL] błąd Opcje

[damain1960]

Co jest w tym kodzie źle:

[SQL] pobierz, plaintext 
DROP TABLE IF EXISTS `adv_ban`;
CREATE TABLE `adv_ban` (
  `ID` int(20) NOT NULL DEFAULT '0',
  `member` varchar(15) NOT NULL DEFAULT '',
  `referrer` varchar(15) NOT NULL DEFAULT '',
  `timestamp` int(14) NOT NULL DEFAULT '0',
  `email` varchar(40) NOT NULL DEFAULT '',
  `payment_info` varchar(30) NOT NULL DEFAULT '0',
  `ban_url` varchar(200) NOT NULL DEFAULT '',
  `ban_target` varchar(200) NOT NULL DEFAULT '',
  `ad_bought` int(16) NOT NULL DEFAULT '0',
  `ad_rec` int(16) NOT NULL DEFAULT '0',
  `ad_clicks` int(10) NOT NULL DEFAULT '0',
  `lt` float NOT NULL DEFAULT '0',
  `price_ctp` char(2) NOT NULL DEFAULT 'lt',
  `status` varchar(10) NOT NULL DEFAULT '',
  UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM;
[SQL] pobierz, plaintext 

[woxala123]

Tu masz prawidłową tabelę.

[SQL] pobierz, plaintext 
CREATE TABLE `adv_ban` (
	`ID` INT(20) NOT NULL DEFAULT '0',
	`member` VARCHAR(15) NOT NULL DEFAULT '',
	`referrer` VARCHAR(15) NOT NULL DEFAULT '',
	`timestamp` INT(14) NOT NULL DEFAULT '0',
	`email` VARCHAR(40) NOT NULL DEFAULT '',
	`payment_info` VARCHAR(30) NOT NULL DEFAULT '0',
	`ban_url` VARCHAR(200) NOT NULL DEFAULT '',
	`ban_target` VARCHAR(200) NOT NULL DEFAULT '',
	`ad_bought` INT(16) NOT NULL DEFAULT '0',
	`ad_rec` INT(16) NOT NULL DEFAULT '0',
	`ad_clicks` INT(10) NOT NULL DEFAULT '0',
	`lt` FLOAT NOT NULL DEFAULT '0',
	`price_ctp` CHAR(2) NOT NULL DEFAULT 'lt',
	`status` VARCHAR(10) NOT NULL DEFAULT '',
	UNIQUE INDEX `ID` (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
 
[SQL] pobierz, plaintext