|
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
sr java.util.ArrayListxa I sizexp w t t t t lINSERT INTO jforum_groups (group_id, group_name, group_description ) VALUES (1, 'General', 'General Users');t t fINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (1, 1, 'perm_administration', 0);t bINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (2, 1, 'perm_moderation', 0);t nINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (3, 1, 'perm_moderation_post_remove', 0);t lINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (4, 1, 'perm_moderation_post_edit', 0);t mINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (5, 1, 'perm_moderation_topic_move', 0);t sINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (6, 1, 'perm_moderation_topic_lockUnlock', 0);t t t t t tINSERT INTO jforum_users (user_id, username, user_password, user_regdate ) VALUES (1, 'Anonymous', 'nopass', NOW());t AINSERT INTO jforum_user_groups (group_id, user_id) VALUES (1, 1);t t t t t qINSERT INTO jforum_groups (group_id, group_name, group_description ) VALUES (2, 'Administration', 'Admin Users');t t fINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (7, 2, 'perm_administration', 1);t bINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (8, 2, 'perm_moderation', 1);t nINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (9, 2, 'perm_moderation_post_remove', 1);t mINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (10, 2, 'perm_moderation_post_edit', 1);t nINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (11, 2, 'perm_moderation_topic_move', 1);t tINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (12, 2, 'perm_moderation_topic_lockUnlock', 1);t zINSERT INTO jforum_roles (role_id, group_id, name, role_type) VALUES (13, 2, 'perm_create_sticky_announcement_topics', 1);t t t t t INSERT INTO jforum_users (user_id, username, user_password, user_regdate, user_posts ) VALUES (2, 'Admin', '21232f297a57a5a743894a0e4a801fc3', NOW(), 1);t AINSERT INTO jforum_user_groups (group_id, user_id) VALUES (2, 2);t t t t t INSERT INTO jforum_smilies VALUES (1,':)','<img src=\"#CONTEXT#/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif\" border=\"0\">','3b63d1616c5dfcf29f8a7a031aaa7cad.gif');t INSERT INTO jforum_smilies VALUES (2,':-)',' ','3b63d1616c5dfcf29f8a7a031aaa7cad.gif');t INSERT INTO jforum_smilies VALUES (3,':D',' ','283a16da79f3aa23fe1025c96295f04f.gif');t INSERT INTO jforum_smilies VALUES (4,':-D',' ','283a16da79f3aa23fe1025c96295f04f.gif');t INSERT INTO jforum_smilies VALUES (5,':(',' ','9d71f0541cff0a302a0309c5079e8dee.gif');t INSERT INTO jforum_smilies VALUES (6,':-(',' ','9d71f0541cff0a302a0309c5079e8dee.gif');t INSERT INTO jforum_smilies VALUES (7,':-o',' ','47941865eb7bbc2a777305b46cc059a2.gif');t INSERT INTO jforum_smilies VALUES (8,':shock:',' ','385970365b8ed7503b4294502a458efa.gif');t INSERT INTO jforum_smilies VALUES (9,':?:',' ','136dd33cba83140c7ce38db096d05aed.gif');t INSERT INTO jforum_smilies VALUES (10,'8)',' ','b2eb59423fbf5fa39342041237025880.gif');t INSERT INTO jforum_smilies VALUES (11,':lol:',' ','97ada74b88049a6d50a6ed40898a03d7.gif');t INSERT INTO jforum_smilies VALUES (12,':x',' ','1069449046bcd664c21db15b1dfedaee.gif');t INSERT INTO jforum_smilies VALUES (13,':P',' ','69934afc394145350659cd7add244ca9.gif');t INSERT INTO jforum_smilies VALUES (14,':-P',' ','69934afc394145350659cd7add244ca9.gif');t INSERT INTO jforum_smilies VALUES (15,':oops:',' ','499fd50bc713bfcdf2ab5a23c00c2d62.gif');t INSERT INTO jforum_smilies VALUES (16,':cry:',' ','c30b4198e0907b23b8246bdd52aa1c3c.gif');t INSERT INTO jforum_smilies VALUES (17,':evil:',' ','2e207fad049d4d292f60607f80f05768.gif');t INSERT INTO jforum_smilies VALUES (18,':twisted:',' ','908627bbe5e9f6a080977db8c365caff.gif');t INSERT INTO jforum_smilies VALUES (19,':roll:',' ','2786c5c8e1a8be796fb2f726cca5a0fe.gif');t INSERT INTO jforum_smilies VALUES (20,':wink:',' ','8a80c6485cd926be453217d59a84a888.gif');t INSERT INTO jforum_smilies VALUES (21,';)',' ','8a80c6485cd926be453217d59a84a888.gif');t INSERT INTO jforum_smilies VALUES (22,';-)',' ','8a80c6485cd926be453217d59a84a888.gif');t INSERT INTO jforum_smilies VALUES (23,':!:',' ','9293feeb0183c67ea1ea8c52f0dbaf8c.gif');t INSERT INTO jforum_smilies VALUES (24,':?',' ','0a4d7238daa496a758252d0a2b1a1384.gif');t INSERT INTO jforum_smilies VALUES (25,':idea:',' ','8f7fb9dd46fb8ef86f81154a4feaada9.gif');t INSERT INTO jforum_smilies VALUES (26,':arrow:',' ','d6741711aa045b812616853b5507fd2a.gif');t INSERT INTO jforum_smilies VALUES (31,':mrgreen:',' ','ed515dbff23a0ee3241dcc0a601c9ed6.gif');t t t t t =INSERT INTO jforum_categories VALUES (1,'Category Test',1,0);t SINSERT INTO jforum_forums VALUES (1,1,'Test Forum','This is a test forum',1,1,1,0);t cINSERT INTO jforum_topics VALUES (1,1,'Welcome to JForum',2,'2005-01-04 16:59:54',1,0,0,0,0,1,1,0);t rINSERT 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);tvINSERT INTO jforum_posts_text VALUES (1,'[b]Congratulations![/b]. You have completed the installation of JForum. \r\n\r\nTo start administering the board, login as [i]Admin / [/i] and access the [b]Admin Control Panel[/b] using the link that shows up in the bottom of the page. \r\n\r\nThere you will be able to create Categories, Forums and much more. \r\n\r\nFor more information and support, please access [url]http://www.jforum.net/community.htm[/url] and [url]http://www.jforum.net/help.htm[/url]\r\n\r\nThank you for choosing JForum.\r\n\r\nThe JForum Team.','Welcome to JForum');t t t t t _INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (14, 'perm_forum', 1, 0);t _INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (15, 'perm_forum', 2, 0);t t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (14, '1', 1);t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (15, '1', 1);t t t t t hINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (16, 'perm_anonymous_post', 1, 0);t hINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (17, 'perm_anonymous_post', 2, 0);t t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (16, '1', 1);t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (17, '1', 1);t t t t t bINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (18, 'perm_category', 1, 0);t bINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (19, 'perm_category', 2, 0);t t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (18, '1', 1);t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (19, '1', 1);t t t t t {INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (20, 'perm_create_sticky_announcement_topics', 1, 1);t {INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (21, 'perm_create_sticky_announcement_topics', 2, 1);t t t t t jINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (22, 'perm_read_only_forums', 1, 0);t jINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (23, 'perm_read_only_forums', 2, 0);t t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (22, '1', 1);t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (23, '1', 1);t t t t t gINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (24, 'perm_html_disabled', 1, 0);t gINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (25, 'perm_html_disabled', 2, 0);t t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (24, '1', 1);t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (25, '1', 1);t t t t t lINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (26, 'perm_attachments_enabled', 1, 0);t lINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (27, 'perm_attachments_enabled', 2, 0);t mINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (28, 'perm_attachments_download', 1, 1);t mINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (29, 'perm_attachments_download', 2, 1);t t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (26, '1', 1);t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (27, '1', 1);t t t t t jINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (30, 'perm_bookmarks_enabled', 1, 1);t jINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (31, 'perm_bookmarks_enabled', 2, 1);t t t t t fINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (32, 'perm_karma_enabled', 1, 1);t fINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (33, 'perm_karma_enabled', 2, 1);t t t t t cINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (34, 'perm_reply_only', 1, 0);t cINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (35, 'perm_reply_only', 2, 0);t t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (34, '1', 1);t VINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (35, '1', 1);t t t t t t FSELECT SETVAL('jforum_posts_seq', MAX(post_id) + 1) FROM jforum_posts;t VSELECT SETVAL('jforum_categories_seq', MAX(categories_id) + 1) FROM jforum_categories;t ISELECT SETVAL('jforum_forums_seq', MAX(forum_id) + 1) FROM jforum_forums;t ISELECT SETVAL('jforum_topics_seq', MAX(topic_id) + 1) FROM jforum_topics;t FSELECT SETVAL('jforum_roles_seq', MAX(role_id) + 1) FROM jforum_roles;t FSELECT SETVAL('jforum_users_seq', MAX(user_id) + 1) FROM jforum_users;t ISELECT SETVAL('jforum_groups_seq', MAX(group_id) + 1) FROM jforum_groups;t LSELECT SETVAL('jforum_smilies_seq', MAX(smilie_id) + 1) FROM jforum_smilies;x
|