alvinalexander.com | career | drupal | java | mac | mysql | perl | scala | uml | unix  

What this is

This file 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.

Other links

The source code

--
-- Groups
--
INSERT INTO jforum_groups (group_id, group_name, group_description ) VALUES (1,'General', 'General Users');
INSERT INTO jforum_groups (group_id, group_name, group_description ) VALUES (2,'Administration', 'Admin Users');

-- 
-- Users
--
INSERT INTO jforum_users (user_id, username, user_password ) VALUES (1,'Anonymous', 'nopass');
INSERT INTO jforum_users (user_id, username, user_password, user_posts ) VALUES (2,'Admin', '21232f297a57a5a743894a0e4a801fc3', 1);

--
-- User Groups
--
INSERT INTO jforum_user_groups (group_id, user_id) VALUES (1, 1);
INSERT INTO jforum_user_groups (group_id, user_id) VALUES (2, 2);

--
-- Roles
--
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (1, 1, 'perm_administration', 0);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (2, 1, 'perm_moderation', 0);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (3, 1, 'perm_moderation_post_remove', 0);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (4, 1, 'perm_moderation_post_edit', 0);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (5, 1, 'perm_moderation_topic_move', 0);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (6, 1, 'perm_moderation_topic_lockUnlock', 0);

--
-- Admin
--
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (7, 2, 'perm_administration', 1);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (8, 2, 'perm_moderation', 1);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (9, 2, 'perm_moderation_post_remove', 1);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (10, 2, 'perm_moderation_post_edit', 1);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (11, 2, 'perm_moderation_topic_move', 1);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (12, 2, 'perm_moderation_topic_lockUnlock', 1);
INSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (13, 2, 'perm_create_sticky_announcement_topics', 1);
--
-- Smilies
--
INSERT INTO jforum_smilies VALUES (1,':)','<img src=\"#CONTEXT#/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif\" border=\"0\">','3b63d1616c5dfcf29f8a7a031aaa7cad.gif');
INSERT INTO jforum_smilies VALUES (2,':-)','<img src=\"#CONTEXT#/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif\" border=\"0\">','3b63d1616c5dfcf29f8a7a031aaa7cad.gif');
INSERT INTO jforum_smilies VALUES (3,':D','<img src=\"#CONTEXT#/images/smilies/283a16da79f3aa23fe1025c96295f04f.gif\" border=\"0\">','283a16da79f3aa23fe1025c96295f04f.gif');
INSERT INTO jforum_smilies VALUES (4,':-D','<img src=\"#CONTEXT#/images/smilies/283a16da79f3aa23fe1025c96295f04f.gif\" border=\"0\">','283a16da79f3aa23fe1025c96295f04f.gif');
INSERT INTO jforum_smilies VALUES (5,':(','<img src=\"#CONTEXT#/images/smilies/9d71f0541cff0a302a0309c5079e8dee.gif\" border=\"0\">','9d71f0541cff0a302a0309c5079e8dee.gif');
INSERT INTO jforum_smilies VALUES (6,':-(','<img src=\"#CONTEXT#/images/smilies/9d71f0541cff0a302a0309c5079e8dee.gif\" border=\"0\">','9d71f0541cff0a302a0309c5079e8dee.gif');
INSERT INTO jforum_smilies VALUES (7,':-o','<img src=\"#CONTEXT#/images/smilies/47941865eb7bbc2a777305b46cc059a2.gif\" border=\"0\">','47941865eb7bbc2a777305b46cc059a2.gif');
INSERT INTO jforum_smilies VALUES (8,':shock:','<img src=\"#CONTEXT#/images/smilies/385970365b8ed7503b4294502a458efa.gif\" border=\"0\">','385970365b8ed7503b4294502a458efa.gif');
INSERT INTO jforum_smilies VALUES (9,':?:','<img src=\"#CONTEXT#/images/smilies/136dd33cba83140c7ce38db096d05aed.gif\" border=\"0\">','136dd33cba83140c7ce38db096d05aed.gif');
INSERT INTO jforum_smilies VALUES (10,'8)','<img src=\"#CONTEXT#/images/smilies/b2eb59423fbf5fa39342041237025880.gif\" border=\"0\">','b2eb59423fbf5fa39342041237025880.gif');
INSERT INTO jforum_smilies VALUES (11,':lol:','<img src=\"#CONTEXT#/images/smilies/97ada74b88049a6d50a6ed40898a03d7.gif\" border=\"0\">','97ada74b88049a6d50a6ed40898a03d7.gif');
INSERT INTO jforum_smilies VALUES (12,':x','<img src=\"#CONTEXT#/images/smilies/1069449046bcd664c21db15b1dfedaee.gif\" border=\"0\">','1069449046bcd664c21db15b1dfedaee.gif');
INSERT INTO jforum_smilies VALUES (13,':P','<img src=\"#CONTEXT#/images/smilies/69934afc394145350659cd7add244ca9.gif\" border=\"0\">','69934afc394145350659cd7add244ca9.gif');
INSERT INTO jforum_smilies VALUES (14,':-P','<img src=\"#CONTEXT#/images/smilies/69934afc394145350659cd7add244ca9.gif\" border=\"0\">','69934afc394145350659cd7add244ca9.gif');
INSERT INTO jforum_smilies VALUES (15,':oops:','<img src=\"#CONTEXT#/images/smilies/499fd50bc713bfcdf2ab5a23c00c2d62.gif\" border=\"0\">','499fd50bc713bfcdf2ab5a23c00c2d62.gif');
INSERT INTO jforum_smilies VALUES (16,':cry:','<img src=\"#CONTEXT#/images/smilies/c30b4198e0907b23b8246bdd52aa1c3c.gif\" border=\"0\">','c30b4198e0907b23b8246bdd52aa1c3c.gif');
INSERT INTO jforum_smilies VALUES (17,':evil:','<img src=\"#CONTEXT#/images/smilies/2e207fad049d4d292f60607f80f05768.gif\" border=\"0\">','2e207fad049d4d292f60607f80f05768.gif');
INSERT INTO jforum_smilies VALUES (18,':twisted:','<img src=\"#CONTEXT#/images/smilies/908627bbe5e9f6a080977db8c365caff.gif\" border=\"0\">','908627bbe5e9f6a080977db8c365caff.gif');
INSERT INTO jforum_smilies VALUES (19,':roll:','<img src=\"#CONTEXT#/images/smilies/2786c5c8e1a8be796fb2f726cca5a0fe.gif\" border=\"0\">','2786c5c8e1a8be796fb2f726cca5a0fe.gif');
INSERT INTO jforum_smilies VALUES (20,':wink:','<img src=\"#CONTEXT#/images/smilies/8a80c6485cd926be453217d59a84a888.gif\" border=\"0\">','8a80c6485cd926be453217d59a84a888.gif');
INSERT INTO jforum_smilies VALUES (21,';)','<img src=\"#CONTEXT#/images/smilies/8a80c6485cd926be453217d59a84a888.gif\" border=\"0\">','8a80c6485cd926be453217d59a84a888.gif');
INSERT INTO jforum_smilies VALUES (22,';-)','<img src=\"#CONTEXT#/images/smilies/8a80c6485cd926be453217d59a84a888.gif\" border=\"0\">','8a80c6485cd926be453217d59a84a888.gif');
INSERT INTO jforum_smilies VALUES (23,':!:','<img src=\"#CONTEXT#/images/smilies/9293feeb0183c67ea1ea8c52f0dbaf8c.gif\" border=\"0\">','9293feeb0183c67ea1ea8c52f0dbaf8c.gif');
INSERT INTO jforum_smilies VALUES (24,':?','<img src=\"#CONTEXT#/images/smilies/0a4d7238daa496a758252d0a2b1a1384.gif\" border=\"0\">','0a4d7238daa496a758252d0a2b1a1384.gif');
INSERT INTO jforum_smilies VALUES (25,':idea:','<img src=\"#CONTEXT#/images/smilies/8f7fb9dd46fb8ef86f81154a4feaada9.gif\" border=\"0\">','8f7fb9dd46fb8ef86f81154a4feaada9.gif');
INSERT INTO jforum_smilies VALUES (26,':arrow:','<img src=\"#CONTEXT#/images/smilies/d6741711aa045b812616853b5507fd2a.gif\" border=\"0\">','d6741711aa045b812616853b5507fd2a.gif');
INSERT INTO jforum_smilies VALUES (31,':mrgreen:','<img src=\"#CONTEXT#/images/smilies/ed515dbff23a0ee3241dcc0a601c9ed6.gif\" border=\"0\">','ed515dbff23a0ee3241dcc0a601c9ed6.gif');

--
-- Demonstration Forum
--
INSERT INTO jforum_categories VALUES (1,'Category Test',1,0);
INSERT INTO jforum_forums VALUES (1,1,'Test Forum','This is a test forum',1,1,1,0);
INSERT INTO jforum_topics VALUES (1,1,'Welcome to JForum',2,'2005-01-04 16:59:54',1,0,0,0,0,1,1,0);
INSERT INTO jforum_posts VALUES (1,1,1,2,'2005-01-04 16:59:54','127.0.0.1',1,0,1,1,'2005-01-04 17:01:45',2,1,0,0);
INSERT INTO jforum_posts_text VALUES (1,'[b]Congratulations![/b]. You have completed the installation of JForum. To start administering the board, login as [i]Admin / <the password you supplied in the installer>[/i] and access the [b]Admin Control Panel[/b] using the link that shows up in the bottom of the page. There you will be able to create Categories, Forums and much more. For more information and support, please access [url]http://www.jforum.net/community.htm[/url] and [url]http://www.jforum.net/help.htm[/url]. Thank you for choosing JForum. The JForum Team.','Welcome to JForum');

--
-- View Forum
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (14, 'perm_forum', 1, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (15, 'perm_forum', 2, 0);

INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (14, '1', 1);
INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (15, '1', 1);

--
-- Anonymous posts
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (16, 'perm_anonymous_post', 1, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (17, 'perm_anonymous_post', 2, 0);

INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (16, '1', 1);
INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (17, '1', 1);

--
-- View Category
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (18, 'perm_category', 1, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (19, 'perm_category', 2, 0);

INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (18, '1', 1);
INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (19, '1', 1);

--
-- Sticky / Announcements
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (20, 'perm_create_sticky_announcement_topics', 1, 1);
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (21, 'perm_create_sticky_announcement_topics', 2, 1);

--
-- Create / Reply to topics
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (22, 'perm_read_only_forums', 1, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (23, 'perm_read_only_forums', 2, 0);

INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (22, '1', 1);
INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (23, '1', 1);

-- 
-- Enable HTML
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (24, 'perm_html_disabled', 1, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (25, 'perm_html_disabled', 2, 0);

INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (24, '1', 1);
INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (25, '1', 1);

--
-- Attachments
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (26, 'perm_attachments_enabled', 1, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (27, 'perm_attachments_enabled', 2, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (28, 'perm_attachments_download', 1, 1);
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (29, 'perm_attachments_download', 2, 1);

INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (26, '1', 1);
INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (27, '1', 1);

--
-- Bookmarks
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (30, 'perm_bookmarks_enabled', 1, 1);
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (31, 'perm_bookmarks_enabled', 2, 1);

--
-- Karma
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (32, 'perm_karma_enabled', 1, 1);
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (33, 'perm_karma_enabled', 2, 1);

--
-- Reply only
--
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (34, 'perm_reply_only', 1, 0);
INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (35, 'perm_reply_only', 2, 0);

INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (34, '1', 1);
INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (35, '1', 1);
... this post is sponsored by my books ...

#1 New Release!

FP Best Seller

 

new blog posts

 

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.