[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 

[damain1960]

#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 'TYPE=MyISAM' at line 17

powiesz mi gdzie jest błąd ?

Ten post edytował damain1960 1.10.2016, 09:35:20