jforum example source code file (mysql_2.1.7_to_2.1.8.sql)

This example jforum source code file (mysql_2.1.7_to_2.1.8.sql) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - jforum tags/keywords

add, add, alter, alter, default, drop, index, index, int, key, not, null, table, table

The jforum mysql_2.1.7_to_2.1.8.sql source code

ALTER TABLE jforum_banlist ADD INDEX(banlist_email);
ALTER TABLE jforum_posts ADD INDEX(need_moderate);
ALTER TABLE jforum_posts ADD INDEX(post_time);
ALTER TABLE jforum_topics ADD topic_moved_id INT DEFAULT 0;
ALTER TABLE jforum_topics ADD INDEX(topic_moved_id);
ALTER TABLE jforum_users CHANGE rank_id rank_id INT DEFAULT 0;
ALTER TABLE jforum_sessions CHANGE session_ip session_ip VARCHAR(15) DEFAULT '';
ALTER TABLE jforum_vote_desc ADD INDEX(topic_id);
ALTER TABLE jforum_vote_results ADD INDEX(vote_id);
ALTER TABLE jforum_vote_voters ADD INDEX(vote_id);
ALTER TABLE jforum_vote_voters ADD INDEX(vote_user_id);
ALTER TABLE jforum_extensions ADD INDEX(extension);

DROP TABLE jforum_search_words;
DROP TABLE jforum_search_wordmatch;
DROP TABLE jforum_search_results;
DROP TABLE jforum_search_topics;

DROP TABLE IF EXISTS jforum_moderation_log;
CREATE TABLE jforum_moderation_log (
	log_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	user_id INT NOT NULL,
	log_description TEXT NOT NULL,
	log_original_message TEXT,
	log_date DATETIME NOT NULL,
	log_type TINYINT DEFAULT 0,
	post_id INT DEFAULT 0,
	topic_id INT DEFAULT 0,
	post_user_id INT DEFAULT 0,
	KEY(user_id),
	KEY(post_user_id)
) TYPE=InnoDB;