CREATE TABLE banners (
banners_id int(5) NOT NULL auto_increment,
banners_title varchar(64) NOT NULL default '',
banners_url varchar(64) NOT NULL default '',
banners_image varchar(64) NOT NULL default '',
banners_group varchar(10) NOT NULL default '',
banners_html_text text,
expires_impressions int(7) default NULL,
expires_date datetime default NULL,
date_scheduled datetime default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
date_status_change datetime default NULL,
status int(1) default '1',
PRIMARY KEY  (banners_id)
) TYPE=MyISAM