¬ísrjava.util.ArrayListx�Ò™Ça�
Isizexp¦wÈt
 t
 t
 t`INSERT INTO jforum_groups ( group_name, group_description ) VALUES ('General', 'General Users');tSET @GENERAL_GROUP_ID = 1;tteINSERT INTO jforum_groups ( group_name, group_description ) VALUES ('Administration', 'Admin Users');tSET @ADMIN_GROUP_ID = 2;tt
 t
 t
 tiINSERT INTO jforum_users ( username, user_password, user_regdate ) VALUES ('Anonymous', 'nopass', NOW());tSET @ANONYMOUS_ID = 1;ttŽINSERT INTO jforum_users ( username, user_password, user_regdate, user_posts ) VALUES ('Admin', '21232f297a57a5a743894a0e4a801fc3', NOW(), 1);tSET @ADMIN_ID = 2;tt
 t
 t
 t]INSERT INTO jforum_user_groups (group_id, user_id) VALUES (@GENERAL_GROUP_ID, @ANONYMOUS_ID);tWINSERT INTO jforum_user_groups (group_id, user_id) VALUES (@ADMIN_GROUP_ID, @ADMIN_ID);tt
 t
 t
 tjINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@GENERAL_GROUP_ID, 'perm_administration', 0);tfINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@GENERAL_GROUP_ID, 'perm_moderation', 0);trINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@GENERAL_GROUP_ID, 'perm_moderation_post_remove', 0);tpINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@GENERAL_GROUP_ID, 'perm_moderation_post_edit', 0);tqINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@GENERAL_GROUP_ID, 'perm_moderation_topic_move', 0);twINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@GENERAL_GROUP_ID, 'perm_moderation_topic_lockUnlock', 0);tt
 thINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@ADMIN_GROUP_ID, 'perm_administration', 1);tdINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@ADMIN_GROUP_ID, 'perm_moderation', 1);tpINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@ADMIN_GROUP_ID, 'perm_moderation_post_remove', 1);tnINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@ADMIN_GROUP_ID, 'perm_moderation_post_edit', 1);toINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@ADMIN_GROUP_ID, 'perm_moderation_topic_move', 1);tuINSERT INTO jforum_roles (group_id, name, role_type) VALUES (@ADMIN_GROUP_ID, 'perm_moderation_topic_lockUnlock', 1);tt SET @ROLE_ID = LAST_INSERT_ID();tt
 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,':?:','','0a4d7238daa496a758252d0a2b1a1384.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,':?','','136dd33cba83140c7ce38db096d05aed.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');tt
 t
 t
 t=INSERT INTO jforum_categories VALUES (1,'Category Test',1,0);tSINSERT INTO jforum_forums VALUES (1,1,'Test Forum','This is a test forum',1,1,1,0);tcINSERT INTO jforum_topics VALUES (1,1,'Welcome to JForum',2,'2005-01-04 16:59:54',1,0,0,0,0,1,1,0);trINSERT 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');tt
 t
 t
 tyINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 1, 'perm_forum', @GENERAL_GROUP_ID, 0);twINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 2, 'perm_forum', @ADMIN_GROUP_ID, 0);tt`INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 1, '1', 1);t`INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 2, '1', 1);tt
 t
 t
 t‚INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 3, 'perm_anonymous_post', @GENERAL_GROUP_ID, 0);t€INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 4, 'perm_anonymous_post', @ADMIN_GROUP_ID, 0);tt`INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 3, '1', 1);t`INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 4, '1', 1);tt
 t
 t
 t|INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 5, 'perm_category', @GENERAL_GROUP_ID, 0);tzINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 6, 'perm_category', @ADMIN_GROUP_ID, 0);tt`INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 5, '1', 1);t`INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 6, '1', 1);tt
 t
 t
 t•INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 7, 'perm_create_sticky_announcement_topics', @GENERAL_GROUP_ID, 1);t“INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 8, 'perm_create_sticky_announcement_topics', @ADMIN_GROUP_ID, 1);tt
 t
 t
 t„INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 9, 'perm_read_only_forums', @GENERAL_GROUP_ID, 0);tƒINSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 10, 'perm_read_only_forums', @ADMIN_GROUP_ID, 0);tt`INSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 9, '1', 1);taINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 10, '1', 1);tt
 t
 t
 t‚INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 11, 'perm_html_disabled', @GENERAL_GROUP_ID, 0);t€INSERT INTO jforum_roles (role_id, name, group_id, role_type ) VALUES (@ROLE_ID + 12, 'perm_html_disabled', @ADMIN_GROUP_ID, 0);ttaINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 11, '1', 1);taINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 12, '1', 1);tt
 t
 t
 t‡INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 13, 'perm_attachments_enabled', @GENERAL_GROUP_ID, 0);t…INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 14, 'perm_attachments_enabled', @ADMIN_GROUP_ID, 0);tˆINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 15, 'perm_attachments_download', @GENERAL_GROUP_ID, 1);t†INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 16, 'perm_attachments_download', @ADMIN_GROUP_ID, 1);ttaINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 13, '1', 1);taINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 14, '1', 1);tt
 t
 t
 t…INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 17, 'perm_bookmarks_enabled', @GENERAL_GROUP_ID, 1);tƒINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 18, 'perm_bookmarks_enabled', @ADMIN_GROUP_ID, 1);tt
 t
 t
 t�INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 19, 'perm_karma_enabled', @GENERAL_GROUP_ID, 1);tINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 20, 'perm_karma_enabled', @ADMIN_GROUP_ID, 1);tt
 t
 t
 tINSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 21, 'perm_reply_only',  @GENERAL_GROUP_ID, 0);t|INSERT INTO jforum_roles (role_id, name, group_id, role_type) VALUES (@ROLE_ID + 22, 'perm_reply_only', @ADMIN_GROUP_ID, 0);ttaINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 21, '1', 1);taINSERT INTO jforum_role_values ( role_id, role_value, role_type ) VALUES (@ROLE_ID + 22, '1', 1);x