CREATE TABLE BANNER_STATS_TABLE( banner_id MEDIUMINT( 8 ) UNSIGNED NOT NULL , click_date int( 11 ) NOT NULL , click_ip char( 8 ) NOT NULL , click_user MEDIUMINT( 8 ) NOT NULL , user_duration int( 11 ) NOT NULL );