|
jforum example source code file (hsqldb_2.1.7_to_2.1.8.sql)
The jforum hsqldb_2.1.7_to_2.1.8.sql source codeCREATE INDEX idx_banlist_email ON jforum_banlist(banlist_email); CREATE INDEX idx_posts_moderate ON jforum_posts(need_moderate); CREATE INDEX idx_posts_time ON jforum_posts(post_time); ALTER TABLE jforum_topics ADD topic_moved_id INT DEFAULT 0; CREATE INDEX idx_topics_moved ON jforum_topics(topic_moved_id); ALTER TABLE jforum_users ALTER COLUMN rank_id SET DEFAULT 0; ALTER TABLE jforum_sessions ALTER COLUMN session_ip VARCHAR(15); ALTER TABLE jforum_privmsgs ALTER COLUMN privmsgs_ip VARCHAR(15); CREATE INDEX idx_vd_topic ON jforum_vote_desc(topic_id); CREATE INDEX idx_vr_vote ON jforum_vote_results(vote_id); CREATE INDEX idx_vv_vote ON jforum_vote_voters(vote_id); CREATE INDEX idx_vv_user ON jforum_vote_voters(vote_user_id); CREATE INDEX idx_extensions_ext ON jforum_extensions(extension); DROP TABLE jforum_search_words; DROP TABLE jforum_search_wordmatch; DROP TABLE jforum_search_results; DROP TABLE jforum_search_topics; CREATE TABLE jforum_moderation_log ( log_id INT GENERATED BY DEFAULT AS IDENTITY (start with 1), user_id INT NOT NULL, log_description LONGVARCHAR NOT NULL, log_original_message LONGVARCHAR, log_date TIMESTAMP NOT NULL, log_type INT DEFAULT 0, post_id INT, topic_id INT, post_user_id INT, PRIMARY KEY(log_id) ); CREATE INDEX idx_ml_user ON jforum_moderation_log(user_id); CREATE INDEX idx_ml_post_user ON jforum_moderation_log(post_user_id); UPDATE jforum_forums SET forum_topics = (SELECT COUNT(*) FROM jforum_topics t WHERE t.forum_id = jforum_forums.forum_id AND moderated = 0); Other jforum examples (source code examples)Here is a short list of links related to this jforum hsqldb_2.1.7_to_2.1.8.sql source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.