Bravo List - bti tracker 1.4.8

Bravo List (http://www.bvlist.com/index.php)

- Community Cafe (http://www.bvlist.com/forumdisplay.php?f=18)

- - bti tracker 1.4.8 (http://www.bvlist.com/showthread.php?t=10578)

bti tracker 1.4.8

Processing file: ../sql/database.sql

Starting at the line: 1

Error at the line 28: ) TYPE=MyISAM;

Quote:

Query: -- -- -- -- -- CREATE TABLE `bannedip` ( `id` int(10) unsigned NOT NULL auto_increment, `added` int(11) NOT NULL default '0', `addedby` int(10) unsigned NOT NULL default '0', `comment` varchar(255) NOT NULL default '', `first` bigint(11) unsigned default NULL, `last` bigint(11) unsigned default NULL, PRIMARY KEY (`id`), KEY `first_last` (`first`,`last`) ) TYPE=MyISAM;

MySQL: 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 15

Stopped on error

?????

remove the

Code:

TYPE=MyISAM

like so

Code:

CREATE TABLE bannedip ( 

id int(10) unsigned NOT NULL auto_increment, 

added int(11) NOT NULL default '0', 

addedby int(10) unsigned NOT NULL default '0', 

comment varchar(255) NOT NULL default '', 

first bigint(11) unsigned default NULL, 

last bigint(11) unsigned default NULL, 

PRIMARY KEY (id), 

KEY first_last (first,last) 

);