Code: Alles auswählen
CREATE TABLE phpbb_downloads (
id INT(11) auto_increment NOT NULL,
description VARCHAR(255),
file_name VARCHAR(255) DEFAULT '',
klicks INT(11) DEFAULT '0',
free TINYINT(1) DEFAULT '0',
extern TINYINT(1) DEFAULT '0',
long_desc TEXT DEFAULT '',
sort INT(11) DEFAULT '0',
cat INT(11) DEFAULT '0',
hacklist TINYINT(1) DEFAULT '0',
hack_author VARCHAR(255) DEFAULT '',
hack_author_email VARCHAR(255) DEFAULT '',
hack_author_website TINYTEXT DEFAULT '',
hack_version VARCHAR(32) DEFAULT '',
hack_dl_url TINYTEXT DEFAULT '',
test varchar(50) DEFAULT '',
req TEXT DEFAULT '',
todo varchar(255) DEFAULT '',
warning TEXT DEFAULT '',
mod_desc TEXT DEFAULT '',
bbcode_uid VARCHAR(10) DEFAULT '',
mod_list TINYINT(1) DEFAULT '0',
file_size BIGINT(20) NOT NULL DEFAULT '0',
change_time INT(11) DEFAULT '0',
add_time INT(11) DEFAULT '0',
rating SMALLINT(5) DEFAULT '0' NOT NULL,
file_traffic BIGINT(20) NOT NULL DEFAULT '0',
overall_klicks INT(11) DEFAULT '0',
approve TINYINT(1) DEFAULT '0',
add_user MEDIUMINT(8) DEFAULT '0',
change_user MEDIUMINT(8) DEFAULT '0',
last_time INT(11) DEFAULT '0',
down_user MEDIUMINT(8) DEFAULT '0' NOT NULL,
thumbnail VARCHAR(255) DEFAULT '' NOT NULL,
broken TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
CREATE TABLE phpbb_downloads_cat (
id INT(11) auto_increment NOT NULL,
parent INT(11) DEFAULT '0',
path VARCHAR(255) DEFAULT '',
cat_name VARCHAR(255) DEFAULT '',
sort INT(11) DEFAULT '0',
description TEXT DEFAULT '',
bbcode_uid VARCHAR(10) DEFAULT '',
auth_view TINYINT(1) NOT NULL DEFAULT '1',
auth_dl TINYINT(1) NOT NULL DEFAULT '1',
auth_up TINYINT(1) NOT NULL DEFAULT '0',
auth_mod TINYINT(1) NOT NULL DEFAULT '0',
must_approve TINYINT(1) NOT NULL DEFAULT '0',
allow_mod_desc TINYINT(1) NOT NULL DEFAULT '0',
statistics TINYINT(1) NOT NULL DEFAULT '1',
stats_prune MEDIUMINT(8) NOT NULL DEFAULT '0',
comments TINYINT(1) NOT NULL DEFAULT '1',
cat_traffic BIGINT(20) NOT NULL DEFAULT '0',
cat_traffic_use BIGINT(20) NOT NULL DEFAULT '0',
allow_thumbs TINYINT(1) NOT NULL DEFAULT '0',
auth_cread TINYINT(1) NOT NULL DEFAULT '0',
auth_cpost TINYINT(1) NOT NULL DEFAULT '1',
approve_comments TINYINT(1) NOT NULL DEFAULT '1',
PRIMARY KEY (id)
);
CREATE TABLE phpbb_dl_auth (
cat_id INT(11) NOT NULL,
group_id INT(11) NOT NULL,
auth_view TINYINT(1) DEFAULT '1' NOT NULL,
auth_dl TINYINT(1) DEFAULT '1' NOT NULL,
auth_up TINYINT(1) DEFAULT '1' NOT NULL,
auth_mod TINYINT(1) DEFAULT '0' NOT NULL
);
CREATE TABLE phpbb_dl_comments (
dl_id BIGINT(20) unsigned NOT NULL auto_increment,
id INT(11) NOT NULL DEFAULT '0',
cat_id INT(11) NOT NULL DEFAULT '0',
user_id MEDIUMINT(8) NOT NULL DEFAULT '0',
username VARCHAR(32) NOT NULL DEFAULT '',
comment_time INT(11) NOT NULL DEFAULT '0',
comment_edit_time INT(11) NOT NULL DEFAULT '0',
comment_text TEXT NOT NULL DEFAULT '',
bbcode_uid VARCHAR(10) NOT NULL DEFAULT '',
approve TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (dl_id)
);
CREATE TABLE phpbb_dl_ratings (
dl_id INT(11) DEFAULT '0',
user_id MEDIUMINT(8) DEFAULT '0',
rate_point VARCHAR(10) DEFAULT '0'
);
CREATE TABLE phpbb_dl_stats (
dl_id BIGINT(20) unsigned NOT NULL auto_increment,
id INT(11) NOT NULL DEFAULT '0',
cat_id INT(11) NOT NULL DEFAULT '0',
user_id MEDIUMINT(8) NOT NULL DEFAULT '0',
username VARCHAR(32) NOT NULL DEFAULT '',
traffic BIGINT(20) NOT NULL DEFAULT '0',
direction TINYINT(1) NOT NULL DEFAULT '0',
user_ip VARCHAR(8) NOT NULL DEFAULT '',
browser VARCHAR(20) NOT NULL DEFAULT '',
time_stamp INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (dl_id)
);
CREATE TABLE phpbb_dl_config (
config_name VARCHAR(255) NOT NULL DEFAULT '',
config_value VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (config_name)
);
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('delay_auto_traffic', '30');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('delay_post_traffic', '30');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('disable_email', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('disable_popup', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('disable_popup_notify', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_click_reset_time', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_edit_time', '3');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_links_per_page', '10');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_method', '2');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_method_quota', '2097152');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_mod_version', '5.0.18');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_new_time', '3');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_posts', '25');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_stats_perm', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('download_dir', 'downloads/');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('enable_post_dl_traffic', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('guest_report_broken', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('guest_stats_show', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('hotlink_action', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('limit_desc_on_index', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('newtopic_traffic', '524288');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('overall_traffic', '104857600');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('physical_quota', '524288000');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('prevent_hotlink', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('recent_downloads', '10');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('remain_traffic', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('reply_traffic', '262144');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('show_footer_legend', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('show_footer_stat', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('show_real_filetime', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('stop_uploads', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('thumb_fsize', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('thumb_xsize', '200');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('thumb_ysize', '150');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('traffic_retime', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('upload_traffic_count', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('use_ext_blacklist', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('use_hacklist', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('user_dl_auto_traffic', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('user_traffic_once', '0');
ALTER TABLE phpbb_groups ADD COLUMN group_dl_auto_traffic BIGINT(20) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_allow_new_download_email TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_allow_fav_download_email TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_allow_new_download_popup TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_allow_fav_download_popup TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_dl_update_time INT( 11 ) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_new_download TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD COLUMN user_traffic BIGINT(20) DEFAULT '0' NOT NULL;
CREATE TABLE phpbb_dl_ext_blacklist (
extention VARCHAR(10) DEFAULT '' NOT NULL
);
INSERT INTO phpbb_dl_ext_blacklist (extention) VALUES
('asp'), ('cgi'), ('dhtm'), ('dhtml'), ('exe'), ('htm'), ('html'), ('jar'), ('js'), ('php'), ('php3'), ('pl'), ('sh'), ('shtm'), ('shtml');
CREATE TABLE phpbb_dl_banlist(
ban_id INT(11) AUTO_INCREMENT,
user_id MEDIUMINT(8) DEFAULT 0 NOT NULL,
user_ip CHAR(8) DEFAULT '' NOT NULL,
user_agent VARCHAR(50) DEFAULT '' NOT NULL,
username VARCHAR(25) DEFAULT '' NOT NULL,
guests TINYINT(1) DEFAULT 0 NOT NULL,
PRIMARY KEY (ban_id)
);
INSERT INTO phpbb_dl_banlist (user_agent) VALUES ('n/a');
CREATE TABLE phpbb_dl_favorites (
fav_id INT(11) AUTO_INCREMENT,
fav_dl_id INT(11) DEFAULT 0 NOT NULL,
fav_dl_cat INT(11) DEFAULT 0 NOT NULL,
fav_user_id MEDIUMINT(8) DEFAULT 0 NOT NULL,
PRIMARY KEY (fav_id)
);
CREATE TABLE phpbb_dl_notraf (
user_id MEDIUMINT(8) NOT NULL DEFAULT 0,
dl_id INT(11) NOT NULL DEFAULT 0
);
CREATE TABLE phpbb_dl_hotlink (
user_id MEDIUMINT(8) DEFAULT 0 NOT NULL,
session_id VARCHAR(32) DEFAULT '' NOT NULL,
hotlink_id VARCHAR(32) DEFAULT '' NOT NULL
);