Code: Selecteer alles
This list is a result of the SQL queries needed for mod
Banner mod
[Already added] line: 1 , CREATE TABLE phpbb_banner ( 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))
[Already added] line: 2 , CREATE TABLE phpbb_banner_stats ( 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)
