TikiWiki

http://tikiwiki.org
Requires MySQL

Reference http://tikiwiki.org/tiki-index.php?page=InstallTikiDoc

tar zxvf
chmod 755 setup.sh

su -c './setup.sh apache apache'
mysqladmin create wiki
mysql -u root -ppassword mysql
GRANT ALL PRIVILEGES ON wiki.* TO wiki@localhost IDENTIFIED BY 'wiki' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON wiki.* TO wiki@"%" IDENTIFIED BY 'wiki' WITH GRANT OPTION;


update tiki_file_galleries set public='y', show_size='y',show_name='n', maxRows=25;


update tiki_galleries
set maxRows=100, rowImages=5;

update tiki_galleries
set thumbSizeX=120, thumbSizeY=120;




mysql> select * from tiki_directory_categories ;
+---+--+---------+-----+----+---+------+----+-----+-----+----+ | categId | parent | name | description | childrenType | sites | viewableChildren | allowSites | showCount | editorGroup | hits |
+---+--+---------+-----+----+---+------+----+-----+-----+----+ | 7 | 0 | Language | | c | 0 | 3 | y | y | | 0 |
| 13 | 7 | Java | | c | 0 | 3 | y | y | | 0 |
| 14 | 0 | Database | | c | 0 | 3 | y | y | | 0 |
| 15 | 14 | MySQL | | c | 0 | 3 | y | y | | 2 |
| 16 | 14 | Oracle | | c | 0 | 3 | y | y | | 0 |
| 17 | 0 | Tools | | c | 0 | 3 | y | y | | 0 |
| 18 | 17 | Ant | | c | 0 | 3 | y | y | | 0 |
| 19 | 17 | CVS | | c | 0 | 3 | y | y | | 0 |
| 20 | 16 | PDF's | | c | 0 | 3 | y | y | | 0 |
| 21 | 16 | Test | | c | 0 | 3 | y | y | | 0 |
| 22 | 16 | Installation | | c | 0 | 3 | y | y | | 0 |
| 23 | 17 | Apache | | c | 0 | 3 | y | y | | 0 |
| 24 | 17 | Tomcat | | c | 0 | 3 | y | y | | 0 |
| 25 | 24 | Off-Site Installation | | c | 0 | 3 | y | y | | 0 |
| 26 | 24 | Mailing Lists | | c | 0 | 3 | y | y | | 0 |
+---+--+---------+-----+----+---+------+----+-----+-----+----+


insert into tiki_directory_sites (
name,
url,
country,
isValid,
created,
lastModif,
hits
) values (
'Local usr/share/doc',
'http://www.john-purcell.com/tech/usr_share_doc/',
'None',
'y',
1088344515,
1088344515,
0
);
insert into tiki_category_sites (categId , siteId)
values (
1 , 7
);


insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'UNIX CD Bookshelf',
'http://www.john-purcell.com/tech/unix/index.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 8 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Power Tools',
'http://www.john-purcell.com/tech/unix/upt/index.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 9 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'UNIX in a Nutshell',
'http://www.john-purcell.com/tech/unix/unixnut/index.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 10 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Learning vi',
'http://www.john-purcell.com/tech/unix/vi/index.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 11 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'sed & awk',
'http://www.john-purcell.com/tech/unix/sedawk/index.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 12 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Learning Korn Shell',
'http://www.john-purcell.com/tech/unix/ksh/index.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 13 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Learning UNIX',
'http://www.john-purcell.com/tech/unix/lrnunix/index.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 14 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Search All 6 Books',
'http://www.john-purcell.com/tech/unix/search/allsrch.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 1 , 15 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Fedora Extras Home Page',
'http://www.fedora.us/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 3 , 16 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Fedora @ Redhat',
'http://fedora.redhat.com/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 3 , 17 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'vi Quick Reference',
'http://www.john-purcell.com/tech/unix/vi/appa_01.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 4 , 18 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'UNIX test statement File test operators',
'http://www.john-purcell.com/tech/unix/unixnut/c04_051.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 4 , 19 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'BASH if statement File test operators',
'http://www.tldp.org/LDP/abs/html/fto.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 4 , 20 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Linux Command Directory',
'http://www.john-purcell.com/tech/linux/Linux-Command-Directory.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 5 , 21 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Linux Newbie Administrator Guide',
'http://www.john-purcell.com/tech/linux/Linux-Newbie-Administrator-Guide.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 5 , 22 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Linux Newbie Guide',
'http://www.john-purcell.com/tech/linux/Linux-Newbie-Guide.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 5 , 23 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'One Page Linux',
'http://www.john-purcell.com/tech/linux/One-Page-Linux.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 5 , 24 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Unix & Linux Reference',
'http://www.john-purcell.com/tech/linux/Unix-&-Linux-Reference.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 5 , 25 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Linux Network Administrator\'s Guide 2nd Ed',
'http://www.john-purcell.com/tech/linux/Linux-Network-Administrators-Guide-2nd-Ed.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 5 , 26 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Mastering Regular Expressions',
'http://www.john-purcell.com/tech/linux/Mastering-Regular-Expressions.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 5 , 27 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Practice Note',
'http://www.dit.gov.bt/~takeshi/material/linux/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 28 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'tldp.org: How-To\'s Index',
'http://www.tldp.org/docs.html#howto',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 29 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Linux Questions',
'http://www.linuxquestions.org/questions/history.php',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 30 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Linux Newbie Site',
'http://sunsite.dk/linux-newbie/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 31 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Self-Help',
'http://www.linuxselfhelp.com/index.shtml',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 32 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Redhat Resources',
'http://www.redhat.com/apps/support/resources/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 33 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Redhat HOWTO',
'http://www.europe.redhat.com/documentation/HOWTO/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 34 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Redhat mini-HOWTO',
'http://www.europe.redhat.com/documentation/mini-HOWTO/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 6 , 35 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HTML Reference',
'http://www.john-purcell.com/tech/html/HTML-Reference.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 36 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Colors: RGB Mixer',
'http://www.john-purcell.com/tech/html/RGB-Color-Mixer.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 37 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Colors: Alpha Order',
'http://www.john-purcell.com/tech/html/Color-Table-Alpha.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 38 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Colors: Numeric Order',
'http://www.john-purcell.com/tech/html/Color-Table-Numeric.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 39 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Colors: Pairs',
'http://www.john-purcell.com/tech/html/Color-Pairs.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 40 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Special Characters',
'http://www.john-purcell.com/tech/html/HTML-Special-Characters.htm',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 41 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HTML & Javascript Visual Learners (PDF)',
'http://www.john-purcell.com/tech/html/HTML-&-JavaScript-Visual-Learners-Tutorial.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 42 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Master\'s Reference to HTML 4.0 (PDF)',
'http://www.john-purcell.com/tech/html/Masters-Reference-To-HTML-4.0.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 43 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HTML The Definitive Guide (PDF)',
'http://www.john-purcell.com/tech/html/HTML-The-Definitive-Guide.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 44 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Web Design in a Nutshell (PDF)',
'http://www.john-purcell.com/tech/html/Web-Design-Nutshell.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 45 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HTML Code Tutorial',
'http://www.htmlcodetutorial.com/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 46 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HTML Code Tutorial: Quick List',
'http://www.htmlcodetutorial.com/quicklist.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 47 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HTML Code Tutorial: Tables',
'http://www.htmlcodetutorial.com/tables/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 48 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HTML Code Tutorial: Forms',
'http://www.htmlcodetutorial.com/forms/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 49 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'XHTML Reference',
'http://www.w3schools.com/xhtml/xhtml_reference.asp',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 50 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'W3C XHTML Validator',
'http://validator.w3.org/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 8 , 51 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Perl Syntax',
'http://www.perldoc.com/perl5.6/pod/perlsyn.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 9 , 52 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Perl DBI',
'http://dbi.perl.org/doc/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 9 , 53 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Perl & MySQL Test',
'http://www.john-purcell.com/cgi-bin/mysql-perl-test.cgi',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 9 , 54 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Perl & Oracle Test',
'http://www.john-purcell.com/cgi-bin/oracle-perl-test.cgi',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 9 , 55 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Perl in a Nutshell (PDF)',
'http://www.john-purcell.com/tech/perl/Perl-In-A-Nutshell.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 9 , 56 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Perl Cookbook (PDF)',
'http://www.john-purcell.com/tech/perl/Perl-Cookbook.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 9 , 57 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Advanced Perl Programming (PDF)',
'http://www.john-purcell.com/tech/perl/Advanced-Perl-Programming.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 9 , 58 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Reference',
'http://www.htmlhelp.com/reference/css/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 10 , 59 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Properties',
'http://www.htmlhelp.com/reference/css/properties.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 10 , 60 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Usage',
'http://www.htmlhelp.com/reference/css/style-html.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 10 , 61 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'PHP Test',
'http://www.john-purcell.com/tech/cgi-bin/php-test.php',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 62 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'PHP & MySQL Test',
'http://www.john-purcell.com/tech/cgi-bin/mysql-php-test.php',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 63 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'PHP & Oracle Test',
'http://www.john-purcell.com/tech/cgi-bin/oracle-php-test.php',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 64 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Database Reference',
'http://www.john-purcell.com/tech/cgi-bin/dbms.php',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 65 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'MySql/PHP Database Applications (PDF)',
'http://www.john-purcell.com/tech/general/MySQL-PHP.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 66 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Home',
'http://www.php.net',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 67 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Documentation',
'http://www.john-purcell.com/tech/php/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 68 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'PHP & MySQL Reference',
'http://www.php.net/manual/en/ref.mysql.php',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 69 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'PHP & Oracle Reference',
'http://www.php.net/manual/en/ref.oracle.php',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 11 , 70 );


insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'ASP in a Nutshell (PDF)',
'http://www.john-purcell.com/tech/general/ASP-In-A-Nutshell.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 12 , 71 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Java API 1.4.x',
'http://www.john-purcell.com/tech/java/j2sdk1.4/docs/api/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 72 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'J2SE Documentation',
'http://www.john-purcell.com/tech/java/j2sdk1.4/docs/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 73 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'JSP 1.2',
'http://www.john-purcell.com/tech/java/jsp1.2/javadoc_jsp/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 74 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Servlet 2.3',
'http://www.john-purcell.com/tech/java/servlet2.3/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 75 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Java Mail 1.3',
'http://www.john-purcell.com/tech/java/javamail-1.3/docs/javadocs/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 76 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Java Application Framework 1.0.2',
'http://www.john-purcell.com/tech/java/jaf-1.0.2/docs/javadocs/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 77 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'JDOM Beta 8',
'http://www.john-purcell.com/tech/java/jdom-b8/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 78 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Performance Tuning',
'http://www.javaperformancetuning.com/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 79 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'JDBC Profiling',
'http://www.onjava.com/pub/a/onjava/2001/12/05/optimization.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 13 , 80);



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Processing XML with Java',
'http://www.ibiblio.org/xml/books/xmljava/chapters/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 81);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Processing XML with Java... JDOM',
'http://www.ibiblio.org/xml/books/xmljava/chapters/ch14.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 82);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'JDOM Home<',
'http://www.jdom.org/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 83);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'XOM Home',
'http://www.cafeconleche.org/XOM/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 84);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Web Services Tutorial',
'http://java.sun.com/webservices/docs/1.0/tutorial/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 85);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'JAXP Tutorial',
'http://java.sun.com/webservices/docs/1.0/tutorial/doc/JAXPIntro.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 86);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'SAX Tutorial',
'http://java.sun.com/webservices/docs/1.0/tutorial/doc/JAXPSAX.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 87);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'XSLT Tutorial',
'http://java.sun.com/webservices/docs/1.0/tutorial/doc/JAXPXSLT.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 88);

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'JDOM Examples',
'http://www.cs.montana.edu/~frederic/xmlGuide/examples.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 27 , 89);



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Java Design Patterns',
'http://www.john-purcell.com/tech/java/Java-Design-Patterns.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 90 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Java Cookbook',
'http://www.john-purcell.com/tech/java/Java-Servlet-Programming.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 91 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Core Servlets and JSP',
'http://www.john-purcell.com/tech/java/Core-Servlets-and-JSP.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 92 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Pure JSP',
'http://www.john-purcell.com/tech/java/Java-Pure-JSP.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 93 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Java and XML',
'http://www.john-purcell.com/tech/java/Java-and-XML.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 94 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'J2EE and XML',
'http://www.john-purcell.com/tech/java/J2EE-and-XML-Development.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 95 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Core J2EE Patterns',
'http://www.john-purcell.com/tech/java/Java-Core-J2EE-Patterns.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 96 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Network Programming 2nd Ed 2001',
'http://www.john-purcell.com/tech/java/Java-Network-Programming-2nd-Ed-2001.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 28 , 97 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Home',
'http://www.apache.org',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 23 , 98 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Apache 2.0',
'http://www.john-purcell.com/tech/apache/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 23 , 99 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Virtual Hosts',
'http://www.john-purcell.com/tech/apache/vhosts/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 23 , 100 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Apache Status (only works from localhost)',
'http://localhost/server-status',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 23 , 101 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Mailing List',
'http://httpd.apache.org/userslist.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 23 , 102 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'All Apache Mailing Lists',
'http://nagoya.apache.org/eyebrowse/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 23 , 103 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Apache Definitive (PDF)',
'http://www.john-purcell.com/tech/linux/Apache-Definitive.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 23 , 104 );



--insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
-- 'Home',
-- 'http://www.mysql.com/',
-- 'None', 'y', 1088344515, 1088344515, 0);
--insert into tiki_category_sites (categId , siteId) values ( 15 , 2 );

--insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
-- 'Documentation',
-- 'http://www.mysql.com/documentation/mysql/bychapter/',
-- 'None', 'y', 1088344515, 1088344515, 0);
--insert into tiki_category_sites (categId , siteId) values ( 15 , 3 );

--insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
-- 'Perl & MySQL Test',
-- 'http://www.john-purcell.com/cgi-bin/mysql-perl-test.cgi',
-- 'None', 'y', 1088344515, 1088344515, 0);
--insert into tiki_category_sites (categId , siteId) values ( 15 , 4 );

--insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
-- 'PHP & MySQL Test',
-- 'http://www.john-purcell.com/tech/cgi-bin/mysql-php-test.php',
-- 'None', 'y', 1088344515, 1088344515, 0);
--insert into tiki_category_sites (categId , siteId) values ( 15 , 5 );

--insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
-- 'Tomcat, Java, & MySQL Test',
-- 'http://www.john-purcell.com/MysqlSample.jsp',
-- 'None', 'y', 1088344515, 1088344515, 0);
--insert into tiki_category_sites (categId , siteId) values ( 15 , 6 );

--insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
-- 'MySQL & PHP (PDF)',
-- 'http://www.john-purcell.com/tech/general/MySQL-PHP.pdf',
-- 'None', 'y', 1088344515, 1088344515, 0);
--insert into tiki_category_sites (categId , siteId) values ( 15 , 7 );


insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Home',
'http://jakarta.apache.org/tomcat',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 24 , 105 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Tomcat Documentation 4.1.x (LAN only)',
'http://192.168.1.99:7080/index.jsp',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 24 , 106 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Administration and Test Page',
'http://www.john-purcell.com/tech/tomcat-test.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 24 , 107 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Admin Tool',
'http://purcell-linux/admin/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 24 , 108 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Manager Tool',
'http://purcell-linux/manager/html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 24 , 109 );


insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Tomcat Install Instructions Connectors',
'http://jakarta.apache.org/tomcat/tomcat-4.1-doc/config/connectors.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 25 , 110 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Tomcat Install Instructions JK2',
'http://jakarta.apache.org/builds/jakarta-tomcat-connectors/jk2/release/v2.0.1/doc/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 25 , 111 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Demystifying Tomcat 4\'s server.xml File',
'http://www.onjava.com/pub/a/onjava/2002/07/31/tomcat.html?page=1',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 25 , 112 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Apache & Tomcat Install Instructions Connectors ',
'http://www.johnturner.com/howto/apache2-tomcat4112-sol8-howto.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 25 , 113 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Apache & Tomcat Install Instructions',
'http://bruno.vernay.free.fr/HowTo/Apache-tomcat/bWebServer/bWebServer.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 25 , 114 );


insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Jakarta Mailing Lists',
'http://jakarta.apache.org/site/mail2.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 26 , 115 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Tomcat-Users Mailing List Archive',
'http://www.mail-archive.com/tomcat-user@jakarta.apache.org/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 26 , 116 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Home',
'http://ant.apache.org/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 18 , 117 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Ant',
'http://www.john-purcell.com/tech/ant/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 18 , 118 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Documentation 1.5',
'http://www.john-purcell.com/tech/ant/manual/index.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 18 , 119 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Ant: The Definitive Guide 1st Ed 2002 (PDF)',
'http://www.john-purcell.com/tech/general/Ant-The-Definitive-Guide-1st-Ed-2002.pdf',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 18 , 120 );



insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Home',
'http://www.cvshome.org/',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 19 , 121 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Documentation',
'http://www.cvshome.org/docs/manual/cvs-1.12.1/cvs.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 19 , 122 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'Command Quick Ref.',
'http://www.cvshome.org/docs/manual/cvs-1.12.1/cvs_16.html#SEC113',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 19 , 123 );

insert into tiki_directory_sites (name,url,country,isValid,created,lastModif,hits) values (
'HOW-TO',
'http://www.linux.org/docs/ldp/howto/CVS-RCS-HOWTO.html',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 19 , 124 );




insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com:7779/','Oracle Local Documentation and Jserv',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 125 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://purcell-linux:7779/isqlplus','iSQL*plus' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 126 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/Oracle-SQLPlus.html','Oracle SQLPlus' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 127 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.orafaq.com/faqplus.htm','Oracle FAQ: SQLPlus' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 128 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://technet.oracle.com/tech/linux/content.html','Oracle on Linux' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 129 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.orafaq.net/faq2.htm','Oracle FAQ Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 130 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.orafaq.net/faqscrpt.htm','Oracle FAQ Scripts' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 131 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.jlcomp.demon.co.uk/faq/ind_faq.html','Oracle Users Co-Operative FAQ' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 132 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://otn.oracle.com/pls/db92/db92.homepage','Oracle9i Database Online Documentation' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 133 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://search.cpan.org/author/TIMB/DBD-Oracle-1.12/Oracle.pm','Oracle & Perl DBI' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 134 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.cs.iupui.edu/~ateal/n311/plsql/','PL/SQL Examples' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 16 , 135 );


insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/Oracle-Complete-Reference.pdf','Oracle Complete Reference' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 20 , 136 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/Oracle-Complete-Reference-Appendix-A.pdf','Oracle Complete Reference Appendix A' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 20 , 137 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/SQLPlus-Users-Guide-And-Reference.pdf','SQLPlus Users Guide and Reference (Oracle)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 20 , 138 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/PL-SQL-Users-Guide-And-Reference.pdf','PL/SQL Users Guide and Reference (Oracle)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 20 , 139 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/Oracle-PL-SQL-Programming.pdf','PL/SQL Programming (O\'Reilly)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 20 , 140 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/Oracle-Pocket-Reference.pdf','Pocket Reference (O\'Reilly)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 20 , 141 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/oracle/Oracle-DBA-Survial-Guide.pdf','Oracle DBA Survial Guide' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 20 , 142 );



insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/cgi-bin/oracle-php-test.php','PHP & Oracle Test' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 21 , 143 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/cgi-bin/oracle-perl-test.cgi','Perl & Oracle Test' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 21 , 144 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/OracleSample.jsp','Tomcat, Java, & Oracle Test' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 21 , 145 );


insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.e-gineer.com/instructions/install-oracle9i-on-linux.phtml','Oracle 9i Install Instructions ' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 22 , 146 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.akadia.com/services/ora_linux_install_9i.html#Download%20Scripts%20for%20RedHat%20Linux%207.2','Oracle 9i Install Instructions',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 22 , 147 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.puschitz.com/OracleOnLinux.shtml','Oracle 9i Install Instructions' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 22 , 148 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://download-east.oracle.com/docs/html/A96167_01/toc.htm','Oracle 9i Installation Guide' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 22 , 149 );




insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.tldp.org/HOWTO/Bash-Prog-Intro-HOWTO.html','Bash Intro' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 29 , 150 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.tldp.org/LDP/abs/html/index.html','Bash Advanced' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 29 , 151 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.tldp.org/LDP/abs/html/string-manipulation.html','Bash Strings' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 29 , 152 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.tldp.org/LDP/abs/html/internalvariables.html','Bash Internal Vars' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 29 , 153 );


insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://us1.samba.org/samba/samba.html','Samba Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 30 , 154 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://192.168.1.99:901','Samba Swat Config (LAN only)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 30 , 155 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.siliconvalleyccie.com/samba.htm','HOW-TO' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 30 , 156 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://hr.uoregon.edu/davidrl/samba/samba-security.html#ssh','SSH Tunnel' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 30 , 157 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.linux-sxs.org/networking/PDF_creation_using_Samba.html','PDF Printing' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 30 , 158 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.linuxgazette.com/issue72/bright.html','PDF Printing' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 30 , 159 );


insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://vsftpd.beasts.org/','vsftpd Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 160 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.realvnc.com','VNC Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 161 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://burry.ca:4141/ddclient/','Dynamic DNS Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 162 );




insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.openldap.org/','OpenLDAP Home',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 163 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.europe.redhat.com/documentation/HOWTO/LDAP-HOWTO.php3','OpenLDAP HOW-TO' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 164 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.imagemagick.org','ImageMagick Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 165 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://webmagick.sourceforge.net/','Webmagick Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 166 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.webmin.com','Webmin Home',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 17 , 167 );



insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://share.whichever.com/','Whichever.com' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 31 , 168 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.sourceforge.com/','SourceForge' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 31 , 169 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.freshmeat.net/','Freshmeat.net' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 31 , 170 );




insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.squirrelmail.org/','Squirrel Mail Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32 , 171 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.clamav.org/','ClamAV Antivirus Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32, 172 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/clamav.html','ClamAV Antivirus Virus List' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32, 173 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.sng.ecs.soton.ac.uk/mailscanner/','MailScanner Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32, 174 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://mailscannermrtg.sourceforge.net/','MailScanner with MRTG' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32, 175 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.sendmail.org','Sendmail Home' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32, 176 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.siliconvalleyccie.com/sendmail.htm','Sendmail HOW-TO',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32, 177 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/linux/sendmail-Desktop-Reference.pdf','Sendmail Desktop Reference (PDF)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 32, 178 );




insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/general/UML-Reference-Manual.pdf','UML Reference Manual (PDF)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 33 , 179 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/general/WinChars.pdf','Windows Font Symbols (PDF)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 33 , 180 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/general/The-Little-Black-Book-of-Project-Management.pdf','The Little Black Book of Project Management (PDF)',
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 33 , 181 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/tech/general/Physics.pdf','Physics (PDF)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 33 , 182 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.2convert.com/home.htm','Convert to PDF (Word, Excel, Powerpoint)' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 33 , 183 );



insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/webmail/src/login.php','Webmail' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 34 , 184 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/webalizer/','Webalizer' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 34 , 185 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com:10000/','Webmin' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 34 , 186 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/mrtg/detail/index.html','MRTG Performance ' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 34 , 187 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/mailscanner-mrtg/','MRTG MailScanner' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 34 , 188 );

insert into tiki_directory_sites (url,name,country,isValid,created,lastModif,hits) values (
'http://www.john-purcell.com/nagios/','Nagios ' ,
'None', 'y', 1088344515, 1088344515, 0);
insert into tiki_category_sites (categId , siteId) values ( 34 , 189 );

update tiki_directory_sites set country='United_States';