No non l'ho fatto perchè non sapevo. Come cancello quindi la SQL inviata in precedenza? E' la prima volta che lo faccio.
Codice: Seleziona tutto
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);