phpBB.de

Code: Alles auswählen

CREATE TABLE phpbb_BANNERS_TABLE (
	banner_id MEDIUMINT(8) UNSIGNED NOT NULL, 
	banner_name TEXT NOT NULL, 
	banner_spot SMALLINT(1) UNSIGNED NOT NULL, 
	banner_forum MEDIUMINT(8) UNSIGNED NOT NULL, 
	banner_description VARCHAR(30) NOT NULL, 
	banner_url VARCHAR(128) NOT NULL, 
	banner_owner MEDIUMINT(8) NOT NULL, 
	banner_click MEDIUMINT(8) UNSIGNED NOT NULL,
	banner_view MEDIUMINT(8) UNSIGNED NOT NULL,
	banner_weigth TINYINT(1) UNSIGNED DEFAULT "50" NOT NULL, 
	banner_active TINYINT(1) NOT NULL, 
	banner_timetype TINYINT(1) NOT NULL, 
	time_begin INT(11) NOT NULL, 
	time_end INT(11) NOT NULL, 
	date_begin INT(11) NOT NULL, 
	date_end INT(11) NOT NULL,
	banner_level TINYINT(1) NOT NULL,
	banner_level_type TINYINT(1) NOT NULL,
	banner_comment VARCHAR(50) NOT NULL,
	banner_type MEDIUMINT(5) NOT NULL, 
	banner_width MEDIUMINT(5) UNSIGNED NOT NULL,
	banner_height MEDIUMINT(5) UNSIGNED NOT NULL,
	banner_filter TINYINT(1) NOT NULL,
	banner_filter_time MEDIUMINT(5) DEFAULT "600" NOT NULL,
	INDEX (banner_id))'
);


CREATE TABLE phpbb_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)');
);