jforum example source code file (oracle_data_dump.sql)

This example jforum source code file (oracle_data_dump.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

admin, context, context, d, general, group, insert, insert, into, into, p, users, values, values

The jforum oracle_data_dump.sql source code

-- 
-- General Grop
--
INSERT INTO jforum_groups ( group_id, group_name, group_description ) VALUES (jforum_groups_seq.nextval, 'General', 'General Users');

INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_vote');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_karma_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_anonymous_post');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_create_poll');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_bookmarks_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_attachments_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_attachments_download');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_create_sticky_announcement_topics');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation_log');
	
INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_forum', jforum_groups_seq.currval);
INSERT INTO jforum_role_values (role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_anonymous_post', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_category', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_read_only_forums', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_html_disabled', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_attachments_enabled', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_reply_only', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_reply_without_moderation',  jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value ) VALUES (jforum_roles_seq.currval, '1');

--
--  Users from General Group
--
INSERT INTO jforum_users ( user_id, username, user_password, user_regdate ) VALUES ( jforum_users_seq.nextval, 'Anonymous', 'nopass', SYSDATE);
INSERT INTO jforum_user_groups (group_id, user_id) VALUES (jforum_groups_seq.currval, jforum_users_seq.currval);

-- 
--  Admin Group
--
INSERT INTO jforum_groups ( group_id, group_name, group_description ) VALUES (jforum_groups_seq.nextval, 'Administration', 'Admin Users');

INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_administration');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation_post_remove');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation_post_edit');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation_topic_move');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation_topic_lockUnlock');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation_approve_messages');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_create_sticky_announcement_topics');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_vote');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_create_poll');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_karma_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_bookmarks_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_attachments_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_attachments_download');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_moderation_log');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (jforum_roles_seq.nextval, jforum_groups_seq.currval, 'perm_full_moderation_log');
	
INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_forum', jforum_groups_seq.currval);
INSERT INTO jforum_role_values (role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_anonymous_post', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_category', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_read_only_forums', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_html_disabled', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_attachments_enabled', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_reply_only', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_reply_without_moderation',  jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value ) VALUES (jforum_roles_seq.currval, '1');

INSERT INTO jforum_roles (role_id, name, group_id) VALUES (jforum_roles_seq.nextval, 'perm_moderation_forums', jforum_groups_seq.currval);
INSERT INTO jforum_role_values ( role_id, role_value ) VALUES (jforum_roles_seq.currval, '1');

-- 
--  Users from Admin Group
--
INSERT INTO jforum_users ( user_id, username, user_password, user_regdate, user_posts ) VALUES (jforum_users_seq.nextval, 'Admin', '21232f297a57a5a743894a0e4a801fc3', SYSDATE, 1);
INSERT INTO jforum_user_groups (group_id, user_id) VALUES (jforum_groups_seq.currval, jforum_users_seq.currval );

--
-- Demonstration forum
--
INSERT INTO jforum_categories VALUES (jforum_categories_seq.nextval,'Category Test',1,0);
INSERT INTO jforum_forums VALUES (jforum_forums_seq.nextval,jforum_categories_seq.currval,'Test Forum','This is a test forum',1,0,1,0);

-- 
--  Smilies
--
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':)', '<img src=\"#CONTEXT#/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif\" />', '3b63d1616c5dfcf29f8a7a031aaa7cad.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':-)', '<img src=\"#CONTEXT#/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif\"/>', '3b63d1616c5dfcf29f8a7a031aaa7cad.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':D', '<img src=\"#CONTEXT#/images/smilies/283a16da79f3aa23fe1025c96295f04f.gif\" />', '283a16da79f3aa23fe1025c96295f04f.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':-D', '<img src=\"#CONTEXT#/images/smilies/283a16da79f3aa23fe1025c96295f04f.gif\" />', '283a16da79f3aa23fe1025c96295f04f.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':(', '<img src=\"#CONTEXT#/images/smilies/9d71f0541cff0a302a0309c5079e8dee.gif\" />', '9d71f0541cff0a302a0309c5079e8dee.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':mrgreen:', '<img src=\"#CONTEXT#/images/smilies/ed515dbff23a0ee3241dcc0a601c9ed6.gif\" />', 'ed515dbff23a0ee3241dcc0a601c9ed6.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':-o', '<img src=\"#CONTEXT#/images/smilies/47941865eb7bbc2a777305b46cc059a2.gif\"  />', '47941865eb7bbc2a777305b46cc059a2.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':shock:', '<img src=\"#CONTEXT#/images/smilies/385970365b8ed7503b4294502a458efa.gif\" />', '385970365b8ed7503b4294502a458efa.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':?:', '<img src=\"#CONTEXT#/images/smilies/0a4d7238daa496a758252d0a2b1a1384.gif\" />', '0a4d7238daa496a758252d0a2b1a1384.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, '8)', '<img src=\"#CONTEXT#/images/smilies/b2eb59423fbf5fa39342041237025880.gif\"  />', 'b2eb59423fbf5fa39342041237025880.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':lol:', '<img src=\"#CONTEXT#/images/smilies/97ada74b88049a6d50a6ed40898a03d7.gif\" />', '97ada74b88049a6d50a6ed40898a03d7.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':x', '<img src=\"#CONTEXT#/images/smilies/1069449046bcd664c21db15b1dfedaee.gif\"  />', '1069449046bcd664c21db15b1dfedaee.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':P', '<img src=\"#CONTEXT#/images/smilies/69934afc394145350659cd7add244ca9.gif\" />', '69934afc394145350659cd7add244ca9.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':-P', '<img src=\"#CONTEXT#/images/smilies/69934afc394145350659cd7add244ca9.gif\" />', '69934afc394145350659cd7add244ca9.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':oops:', '<img src=\"#CONTEXT#/images/smilies/499fd50bc713bfcdf2ab5a23c00c2d62.gif\" />', '499fd50bc713bfcdf2ab5a23c00c2d62.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':cry:', '<img src=\"#CONTEXT#/images/smilies/c30b4198e0907b23b8246bdd52aa1c3c.gif\" />', 'c30b4198e0907b23b8246bdd52aa1c3c.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':evil:', '<img src=\"#CONTEXT#/images/smilies/2e207fad049d4d292f60607f80f05768.gif\" />', '2e207fad049d4d292f60607f80f05768.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':twisted:', '<img src=\"#CONTEXT#/images/smilies/908627bbe5e9f6a080977db8c365caff.gif\" />', '908627bbe5e9f6a080977db8c365caff.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':roll:', '<img src=\"#CONTEXT#/images/smilies/2786c5c8e1a8be796fb2f726cca5a0fe.gif\" />', '2786c5c8e1a8be796fb2f726cca5a0fe.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':wink:', '<img src=\"#CONTEXT#/images/smilies/8a80c6485cd926be453217d59a84a888.gif\" />', '8a80c6485cd926be453217d59a84a888.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ';)', '<img src=\"#CONTEXT#/images/smilies/8a80c6485cd926be453217d59a84a888.gif\" />', '8a80c6485cd926be453217d59a84a888.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ';-)', '<img src=\"#CONTEXT#/images/smilies/8a80c6485cd926be453217d59a84a888.gif\" />', '8a80c6485cd926be453217d59a84a888.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':!:', '<img src=\"#CONTEXT#/images/smilies/9293feeb0183c67ea1ea8c52f0dbaf8c.gif\" />', '9293feeb0183c67ea1ea8c52f0dbaf8c.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':?', '<img src=\"#CONTEXT#/images/smilies/136dd33cba83140c7ce38db096d05aed.gif\" />', '136dd33cba83140c7ce38db096d05aed.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':idea:', '<img src=\"#CONTEXT#/images/smilies/8f7fb9dd46fb8ef86f81154a4feaada9.gif\" />', '8f7fb9dd46fb8ef86f81154a4feaada9.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':arrow:', '<img src=\"#CONTEXT#/images/smilies/d6741711aa045b812616853b5507fd2a.gif\" />', 'd6741711aa045b812616853b5507fd2a.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':hunf:', '<img src=\"#CONTEXT#/images/smilies/0320a00cb4bb5629ab9fc2bc1fcc4e9e.gif\" />', '0320a00cb4bb5629ab9fc2bc1fcc4e9e.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':-(', '<img src=\"#CONTEXT#/images/smilies/9d71f0541cff0a302a0309c5079e8dee.gif\"  />', '9d71f0541cff0a302a0309c5079e8dee.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':XD:', '<img src=\"#CONTEXT#/images/smilies/49869fe8223507d7223db3451e5321aa.gif\" />', '49869fe8223507d7223db3451e5321aa.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':thumbup:', '<img src=\"#CONTEXT#/images/smilies/e8a506dc4ad763aca51bec4ca7dc8560.gif\" />', 'e8a506dc4ad763aca51bec4ca7dc8560.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':thumbdown:', '<img src=\"#CONTEXT#/images/smilies/e78feac27fa924c4d0ad6cf5819f3554.gif\" />', 'e78feac27fa924c4d0ad6cf5819f3554.gif');
INSERT INTO jforum_smilies VALUES (jforum_smilies_seq.nextval, ':|', '<img src=\"#CONTEXT#/images/smilies/1cfd6e2a9a2c0cf8e74b49b35e2e46c7.gif\" />', '1cfd6e2a9a2c0cf8e74b49b35e2e46c7.gif');