# insert admin data
INSERT INTO board_posters VALUES ('1', 'AdminName', 'AdminPassword', 'MailAddress', '', '', '', '', '', '', '', '', '', '', '1', '0', '1', 'TimeFormat', '0', '5', '0');

# insert test main category
INSERT INTO board_main_categories VALUES ('1', 'MainCategory');

# insert test sub category
INSERT INTO board_sub_categories VALUES ('1', '1', 'SubCategory', 'SubCategoryText');

# insert default config data
INSERT INTO board_config VALUES ('language', 'DefaultLanguage');
INSERT INTO board_config VALUES ('template', 'easyins');
INSERT INTO board_config VALUES ('time_format', 'TimeFormat');
INSERT INTO board_config VALUES ('time_zone', '1');
INSERT INTO board_config VALUES ('enable_bbcode', '1');
INSERT INTO board_config VALUES ('enable_html', '0');
INSERT INTO board_config VALUES ('enable_smilies', '1');
INSERT INTO board_config VALUES ('board_name', 'BoardName');
INSERT INTO board_config VALUES ('board_description', 'BoardDescription');
INSERT INTO board_config VALUES ('activate_board', '1');
INSERT INTO board_config VALUES ('account_activation', '0');
INSERT INTO board_config VALUES ('num_threads', '30');
INSERT INTO board_config VALUES ('num_entries', '15');
INSERT INTO board_config VALUES ('enable_personal_templates', '1');
INSERT INTO board_config VALUES ('enable_signature', '1');
INSERT INTO board_config VALUES ('email_admin', 'MailAddress');
INSERT INTO board_config VALUES ('signature_admin', 'SignatureAdmin');
INSERT INTO board_config VALUES ('allowed_html_tags', 'b, u, i, pre');
INSERT INTO board_config VALUES ('smilies_path', 'SmiliesPath');
INSERT INTO board_config VALUES ('max_letters', '0');

# insert default rank names
INSERT INTO board_ranks VALUES ('1', 'Guest');
INSERT INTO board_ranks VALUES ('2', 'UnauthorizedUser');
INSERT INTO board_ranks VALUES ('3', 'RegisteredUser');
INSERT INTO board_ranks VALUES ('4', 'Moderator');
INSERT INTO board_ranks VALUES ('5', 'Administrator');

# insert test post
INSERT INTO board_posts VALUES ('1', '0', '1', '1', 'TestTitle', 'TestText', 'CurrentTime', 'CurrentTime', '1', '1', '0', '1');

# insert smilies
INSERT INTO board_smilies VALUES ('1', '(fight)', 'SmileyURL/16.gif');
INSERT INTO board_smilies VALUES ('2', '(cool)', 'SmileyURL/11.gif');
INSERT INTO board_smilies VALUES ('3', '(devil)', 'SmileyURL/12.gif');
INSERT INTO board_smilies VALUES ('4', '(wink)', 'SmileyURL/13.gif');
INSERT INTO board_smilies VALUES ('5', '(fire)', 'SmileyURL/15.gif');
INSERT INTO board_smilies VALUES ('7', '(angel)', 'SmileyURL/18.gif');
INSERT INTO board_smilies VALUES ('8', '(good-bad)', 'SmileyURL/19.gif');
INSERT INTO board_smilies VALUES ('9', '(party)', 'SmileyURL/20.gif');
INSERT INTO board_smilies VALUES ('10', '(pie)', 'SmileyURL/21.gif');
INSERT INTO board_smilies VALUES ('11', '(B-Day)', 'SmileyURL/22.gif');
INSERT INTO board_smilies VALUES ('12', ':D', 'SmileyURL/23.gif');
INSERT INTO board_smilies VALUES ('13', '(good)', 'SmileyURL/24.gif');
INSERT INTO board_smilies VALUES ('14', 'zZz', 'SmileyURL/25.gif');
INSERT INTO board_smilies VALUES ('15', '(w)', 'SmileyURL/26.gif');
INSERT INTO board_smilies VALUES ('16', '(m)', 'SmileyURL/27.gif');
INSERT INTO board_smilies VALUES ('17', '(homer)', 'SmileyURL/28.gif');
INSERT INTO board_smilies VALUES ('18', '(scary)', 'SmileyURL/29.gif');
INSERT INTO board_smilies VALUES ('19', ':]', 'SmileyURL/47.gif');
INSERT INTO board_smilies VALUES ('20', '(alien)', 'SmileyURL/48.gif');
INSERT INTO board_smilies VALUES ('21', '(lol)', 'SmileyURL/49.gif');
INSERT INTO board_smilies VALUES ('22', '(thx)', 'SmileyURL/50.gif');
INSERT INTO board_smilies VALUES ('23', '(help)', 'SmileyURL/51.gif');
INSERT INTO board_smilies VALUES ('24', 'O.O', 'SmileyURL/52.gif');
INSERT INTO board_smilies VALUES ('25', '(cry1)', 'SmileyURL/53.gif');
INSERT INTO board_smilies VALUES ('26', '(cry2)', 'SmileyURL/54.gif');
INSERT INTO board_smilies VALUES ('27', '(comfort)', 'SmileyURL/55.gif');
INSERT INTO board_smilies VALUES ('28', '(ataloss1)', 'SmileyURL/56.gif');
INSERT INTO board_smilies VALUES ('29', '(ataloss2)', 'SmileyURL/57.gif');
INSERT INTO board_smilies VALUES ('32', ':(', 'SmileyURL/61.gif');
INSERT INTO board_smilies VALUES ('33', '(boing)', 'SmileyURL/62.gif');
INSERT INTO board_smilies VALUES ('34', '(argue)', 'SmileyURL/63.gif');
INSERT INTO board_smilies VALUES ('35', ':)', 'SmileyURL/64.gif');
INSERT INTO board_smilies VALUES ('36', '(bad)', 'SmileyURL/65.gif');
INSERT INTO board_smilies VALUES ('40', '(fresse)', 'SmileyURL/fresse.gif');