phpBB.nl

Code: Selecteer alles

CREATE TABLE phpbb_shmk_feedback_tot (
	fb_user smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
	fb_pos smallint(4) DEFAULT '0' NOT NULL,
	fb_neg smallint(4) DEFAULT '0' NOT NULL,
	fb_neu smallint(4) DEFAULT '0' NOT NULL,
	PRIMARY KEY (fb_user)
) COLLATE utf8_bin;


CREATE TABLE phpbb_shmk_feedback (
	fb_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	fb_to mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	fb_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	fb_role tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	fb_vote tinyint(1) UNSIGNED DEFAULT '2' NOT NULL,
	fb_link mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	fb_comment text NOT NULL,
	fb_ip varchar(40) DEFAULT '' NOT NULL,
	fb_date int(11) UNSIGNED DEFAULT '0' NOT NULL,
	bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
	bbcode_uid varchar(8) DEFAULT '' NOT NULL,
	PRIMARY KEY (fb_id),
	KEY fb_to (fb_to)
) COLLATE utf8_bin;


CREATE TABLE phpbb_shmk_feedback_config (
	fb_config varchar(255) DEFAULT '' NOT NULL,
	fb_config_val varchar(255) DEFAULT '' NOT NULL,
	PRIMARY KEY (fb_config)
) COLLATE utf8_bin;


INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_minchars','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_maxchars','500');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_bbcode','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_smilies','1');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_url','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_enable','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_force','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_force_in','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_forum','');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('m_haspower','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('role_enable','1');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('top_best','50');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('top_main','10');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('top_worst','50');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('u_canedit','1');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('u_morethenone','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('antiflood','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('antiflood_same','0');

INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score','0','1');
INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score_pos','1','1');
INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score_neu','0','1');
INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score_neg','-1','1');

INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_access',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_add',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_edit',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_delete',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_addmore',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_ignoreflood',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_bbcode',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_smilies',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('m_fb_edit',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('m_fb_delete',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('m_fb_viewip',1,0,0);