0QmVNLaS

1CREATE TABLE IF NOT EXISTS `jos_banner` (
2`bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
3`cid` int( 11 ) NOT NULL default '0',
4`type` varchar( 10 ) NOT NULL default 'banner',
5`name` varchar( 50 ) NOT NULL default '',
6`imptotal` int( 11 ) NOT NULL default '0',
7`impmade` int( 11 ) NOT NULL default '0',
8`clicks` int( 11 ) NOT NULL default '0',
9`imageurl` varchar( 100 ) NOT NULL default '',
10`clickurl` varchar( 200 ) NOT NULL default '',
11`date` datetime default NULL ,
12`showBanner` tinyint( 1 ) NOT NULL default '0',
13`checked_out` tinyint( 1 ) NOT NULL default '0',
14`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
15`editor` varchar( 50 ) default NULL ,
16`custombannercode` text,
17PRIMARY KEY ( `bid` ) ,
18KEY `viewbanner` ( `showBanner` ) 
19) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4;
20
21
22MySQL sa:  
23#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4' at line 19