INSERT INTO `browser_stats` (`name`, `hitcount`) VALUES ('MSIE', 0),
('Mozilla', 0),
('Firefox', 0),
('Opera', 0),
('Lynx', 0),
('Konqueror', 0),
('Other', 0);

INSERT INTO `categories` (`id`, `name`, `image`, `sort_index`, `cat_desc`, `stylesheet`) VALUES (4, 'Games/Misc', 'cat_games.gif', 4, 'games', 'games'),
(34, 'Music', 'cat_music_music.gif', 0, '', ''),
(25, 'Movies/DVD-R', 'cat_movies_dvdr.gif', 0, '', ''),
(26, 'Movies/SVCD', 'cat_movies_svcd.gif', 0, '', ''),
(29, 'Movies/XviD', 'cat_movies_xvid.gif', 0, '', ''),
(27, 'Movies/VCD', 'cat_movies_vcd.gif', 0, '', ''),
(22, 'Appz/Misc', 'cat_apps.gif', 22, 'appzmisc', 'appzmisc'),
(14, 'Books/Articles/Magazines', 'cat_books.gif', 14, 'books', 'books'),
(30, 'TV', 'cat_episodes.gif', 0, '', ''),
(31, 'Music Videos', 'cat_musicvideos_video.gif', 0, '', ''),
(32, 'Appz/PC ISO', 'cat_apps_pciso.gif', 0, '', ''),
(35, 'Music/Soundtracks', 'cat_music_music.gif', 0, '', '');

INSERT INTO `countries` (`id`, `name`, `flagpic`) VALUES (1, 'Sweden', 'sweden.gif'),
(2, 'United States of America', 'usa.gif'),
(3, 'Russia', 'russia.gif'),
(4, 'Finland', 'finland.gif'),
(5, 'Canada', 'canada.gif'),
(6, 'France', 'france.gif'),
(7, 'Germany', 'germany.gif'),
(8, 'China', 'china.gif'),
(9, 'Italy', 'italy.gif'),
(10, 'Denmark', 'denmark.gif'),
(11, 'Norway', 'norway.gif'),
(12, 'United Kingdom', 'uk.gif'),
(13, 'Ireland', 'ireland.gif'),
(14, 'Poland', 'poland.gif'),
(15, 'Netherlands', 'netherlands.gif'),
(16, 'Belgium', 'belgium.gif'),
(17, 'Japan', 'japan.gif'),
(18, 'Brazil', 'brazil.gif'),
(19, 'Argentina', 'argentina.gif'),
(20, 'Australia', 'australia.gif'),
(21, 'New Zealand', 'newzealand.gif'),
(23, 'Spain', 'spain.gif'),
(24, 'Portugal', 'portugal.gif'),
(25, 'Mexico', 'mexico.gif'),
(26, 'Singapore', 'singapore.gif'),
(70, 'India', 'india.gif'),
(65, 'Albania', 'albania.gif'),
(29, 'South Africa', 'southafrica.gif'),
(30, 'South Korea', 'southkorea.gif'),
(31, 'Jamaica', 'jamaica.gif'),
(32, 'Luxembourg', 'luxembourg.gif'),
(33, 'Hong Kong', 'hongkong.gif'),
(34, 'Belize', 'belize.gif'),
(35, 'Algeria', 'algeria.gif'),
(36, 'Angola', 'angola.gif'),
(37, 'Austria', 'austria.gif'),
(38, 'Yugoslavia', 'yugoslavia.gif'),
(39, 'Western Samoa', 'westernsamoa.gif'),
(40, 'Malaysia', 'malaysia.gif'),
(41, 'Dominican Republic', 'dominicanrep.gif'),
(42, 'Greece', 'greece.gif'),
(43, 'Guatemala', 'guatemala.gif'),
(44, 'Israel', 'israel.gif'),
(45, 'Pakistan', 'pakistan.gif'),
(46, 'Czech Republic', 'czechrep.gif'),
(47, 'Serbia', 'serbia.gif'),
(48, 'Seychelles', 'seychelles.gif'),
(49, 'Taiwan', 'taiwan.gif'),
(50, 'Puerto Rico', 'puertorico.gif'),
(51, 'Chile', 'chile.gif'),
(52, 'Cuba', 'cuba.gif'),
(53, 'Congo', 'congo.gif'),
(54, 'Afghanistan', 'afghanistan.gif'),
(55, 'Turkey', 'turkey.gif'),
(56, 'Uzbekistan', 'uzbekistan.gif'),
(57, 'Switzerland', 'switzerland.gif'),
(58, 'Kiribati', 'kiribati.gif'),
(59, 'Philippines', 'philippines.gif'),
(60, 'Burkina Faso', 'burkinafaso.gif'),
(61, 'Nigeria', 'nigeria.gif'),
(62, 'Iceland', 'iceland.gif'),
(63, 'Nauru', 'nauru.gif'),
(64, 'Slovenia', 'slovenia.gif'),
(66, 'Turkmenistan', 'turkmenistan.gif'),
(67, 'Bosnia Herzegovina', 'bosniaherzegovina.gif'),
(68, 'Andorra', 'andorra.gif'),
(69, 'Lithuania', 'lithuania.gif'),
(71, 'Netherlands Antilles', 'nethantilles.gif'),
(72, 'Ukraine', 'ukraine.gif'),
(73, 'Venezuela', 'venezuela.gif'),
(74, 'Hungary', 'hungary.gif'),
(75, 'Romania', 'romania.gif'),
(76, 'Vanuatu', 'vanuatu.gif'),
(77, 'Vietnam', 'vietnam.gif'),
(78, 'Trinidad & Tobago', 'trinidadandtobago.gif'),
(79, 'Honduras', 'honduras.gif'),
(80, 'Kyrgyzstan', 'kyrgyzstan.gif'),
(81, 'Ecuador', 'ecuador.gif'),
(82, 'Bahamas', 'bahamas.gif'),
(83, 'Peru', 'peru.gif'),
(84, 'Cambodia', 'cambodia.gif'),
(85, 'Barbados', 'barbados.gif'),
(86, 'Bangladesh', 'bangladesh.gif'),
(87, 'Laos', 'laos.gif'),
(88, 'Uruguay', 'uruguay.gif'),
(89, 'Antigua Barbuda', 'antiguabarbuda.gif'),
(90, 'Paraguay', 'paraguay.gif'),
(93, 'Thailand', 'thailand.gif'),
(92, 'Union of Soviet Socialist Republics', 'ussr.gif'),
(94, 'Senegal', 'senegal.gif'),
(95, 'Togo', 'togo.gif'),
(96, 'North Korea', 'northkorea.gif'),
(97, 'Croatia', 'croatia.gif'),
(98, 'Estonia', 'estonia.gif'),
(99, 'Colombia', 'colombia.gif'),
(100, 'Lebanon', 'lebanon.gif'),
(101, 'Latvia', 'latvia.gif'),
(102, 'Costa Rica', 'costarica.gif'),
(103, 'Egypt', 'egypt.gif'),
(104, 'Bulgaria', 'bulgaria.gif'),
(105, 'Isla de Muerte', 'jollyroger.gif');

INSERT INTO `stylesheets` (`id`, `uri`, `name`) VALUES (1, 'filelist.css', '(default)');
INSERT INTO `users` (`id` , `username` , `old_password` , `passhash` , `secret` , `email` , `showemail` , `status` , `added` , `last_login` , `last_access` , `editsecret` , `privacy` , `stylesheet` , `info` , `info_parsed` , `acceptpms` , `ip` , `avatar` , `uploaded` , `downloaded` , `maxtorrents` , `country` , `notifs` , `modcomment` , `enabled` , `avatars` , `donor` , `warned` , `warneduntil` , `torrentsperpage` , `topicsperpage` , `postsperpage` , `deletepms` , `savepms` , `loginhash` , `logintype` , `last_browse` , `class` , `override_class` , `passkey` , `oldpasskey` , `last_check` , `gender` , `age` , `website` , `showwebsite` , `parked` , `title` , `menubar` , `toolbar` , `sidebar` , `leechwarn` , `showsig` , `signatureinfo` , `signatureinfo_parsed` , `donated` , `invited_by` , `invites` , `invitedate` , `comments` , `posts` , `messages` , `inverted_added` , `support` , `supportfor` , `client` ) VALUES ('', 'Admin', '', MD5( 'admin' ) , '', '', 'no', 'confirmed', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'normal', '1', NULL , '', 'yes', '', '', '0', '0', '2', '0', '', '', 'yes', 'yes', 'no', 'no', '0000-00-00 00:00:00', '0', '0', '0', 'yes', 'no', '', 'secure', '0', '60', '255', '', '', '0000-00-00 00:00:00', 'N/A', '', '', 'no', 'no', '', 'yes', 'yes', 'yes', 'no', 'yes', NULL , '', '0', '0', '0', '0000-00-00 00:00:00', '0', '0', '0', '0', 'no', '', '0');