-- MySQL dump 9.11 -- -- Host: localhost Database: oswikihk -- ------------------------------------------------------ -- Server version 4.0.24_Debian-10sarge1-log -- -- Table structure for table `categorylinks` -- DROP TABLE IF EXISTS `categorylinks`; CREATE TABLE `categorylinks` ( `cl_from` int(8) unsigned NOT NULL default '0', `cl_to` varchar(255) binary NOT NULL default '', `cl_sortkey` varchar(255) binary NOT NULL default '', `cl_timestamp` timestamp(14) NOT NULL, UNIQUE KEY `cl_from` (`cl_from`,`cl_to`), KEY `cl_sortkey` (`cl_to`,`cl_sortkey`(128)), KEY `cl_timestamp` (`cl_to`,`cl_timestamp`) ) TYPE=MyISAM; -- -- Dumping data for table `categorylinks` -- INSERT INTO `categorylinks` VALUES (885,'小作品','Template:Stub',20050512133136); INSERT INTO `categorylinks` VALUES (886,'特殊条目','小作品',20041213035132); INSERT INTO `categorylinks` VALUES (777,'小作品','How to upgrade Debian',20041213035357); INSERT INTO `categorylinks` VALUES (772,'小作品','How to connect Internet',20050518012013); INSERT INTO `categorylinks` VALUES (924,'Mirror_in_Hong_Kong','Chinese 2000 Linux mirror in Hong Kong',20050106210043); INSERT INTO `categorylinks` VALUES (925,'Mirror_in_Hong_Kong','Chinese Linux Extension mirror in Hong Kong',20050106210211); INSERT INTO `categorylinks` VALUES (926,'Mirror_in_Hong_Kong','Kernel.org mirror in Hong Kong',20050106210954); INSERT INTO `categorylinks` VALUES (927,'Mirror_in_Hong_Kong','Debian mirror in Hong Kong',20050106210404); INSERT INTO `categorylinks` VALUES (928,'Mirror_in_Hong_Kong','Darwin mirror in Hong Kong',20050106210505); INSERT INTO `categorylinks` VALUES (929,'Mirror_in_Hong_Kong','FreeBSD mirror in Hong Kong',20050605093554); INSERT INTO `categorylinks` VALUES (931,'Mirror_in_Hong_Kong','Gentoo Linux mirror in Hong Kong',20050106210832); INSERT INTO `categorylinks` VALUES (990,'Mirror_in_Hong_Kong','Mandrake Linux mirror in Hong Kong',20050119084258); INSERT INTO `categorylinks` VALUES (933,'Mirror_in_Hong_Kong','OpenBSD mirror in Hong Kong',20050106211415); INSERT INTO `categorylinks` VALUES (934,'Mirror_in_Hong_Kong','Red Flag Linux mirror in Hong Kong',20050106213440); INSERT INTO `categorylinks` VALUES (935,'Mirror_in_Hong_Kong','Red Hat Linux mirror in Hong Kong',20050804071837); INSERT INTO `categorylinks` VALUES (800,'中文化','Make Debian support Chinese',20050908230938); INSERT INTO `categorylinks` VALUES (800,'Debian','Make Debian support Chinese',20050908230938); INSERT INTO `categorylinks` VALUES (801,'Java','Install Java on Debian',20051023191842); INSERT INTO `categorylinks` VALUES (778,'中文化','How to join Open Source Software Interface Translation',20050204230858); INSERT INTO `categorylinks` VALUES (916,'Mail','Use Procmail to delivery email',20051011211014); INSERT INTO `categorylinks` VALUES (920,'Mail','Authenticate user for Courier imapd and pop3d via LDAP',20050613012245); INSERT INTO `categorylinks` VALUES (2281,'IMAP','Authenticate IMAP server via SASL',20051020160313); INSERT INTO `categorylinks` VALUES (913,'Printing','Why Samba can printing',20050613010513); INSERT INTO `categorylinks` VALUES (913,'Samba','Why Samba can printing',20050613010513); INSERT INTO `categorylinks` VALUES (905,'Samba','Print PDF in Samba',20050613020325); INSERT INTO `categorylinks` VALUES (905,'列印','Print PDF in Samba',20050613020325); INSERT INTO `categorylinks` VALUES (947,'Mirror_in_Hong_Kong','Slackware Linux mirror in Hong Kong',20050106211924); INSERT INTO `categorylinks` VALUES (948,'Mirror_in_Hong_Kong','SuSE Linux mirror in Hong Kong',20050216155500); INSERT INTO `categorylinks` VALUES (949,'Mirror_in_Hong_Kong','TurboLinux mirror in Hong Kong',20050428175108); INSERT INTO `categorylinks` VALUES (950,'Mirror_in_Hong_Kong','Template:HKMirror',20050511073849); INSERT INTO `categorylinks` VALUES (952,'Mirror_in_Hong_Kong','Coyote Linux mirror in Hong Kong',20050106205323); INSERT INTO `categorylinks` VALUES (953,'Mirror_in_Hong_Kong','Fedora Linux mirror in Hong Kong',20050802210807); INSERT INTO `categorylinks` VALUES (969,'Mirror_in_Hong_Kong','WinLinux mirror in Hong Kong',20050106212544); INSERT INTO `categorylinks` VALUES (970,'Mirror_in_Hong_Kong','White Box Linux mirror in Hong Kong',20050325195057); INSERT INTO `categorylinks` VALUES (973,'Mirror_in_Hong_Kong','Yellow Dog Linux mirror in Hong Kong',20050106213818); INSERT INTO `categorylinks` VALUES (974,'Mirror_in_Hong_Kong','Solaris mirror in Hong Kong',20050106214515); INSERT INTO `categorylinks` VALUES (975,'Mirror_in_Hong_Kong','Apache mirror in Hong Kong',20050805061346); INSERT INTO `categorylinks` VALUES (976,'Mirror_in_Hong_Kong','CPAN mirror in Hong Kong',20050106220307); INSERT INTO `categorylinks` VALUES (977,'Mirror_in_Hong_Kong','GNU Software mirror in Hong Kong',20050106220014); INSERT INTO `categorylinks` VALUES (978,'Mirror_in_Hong_Kong','IFCSS Chinese Software mirror in Hong Kong',20050106220858); INSERT INTO `categorylinks` VALUES (979,'Mirror_in_Hong_Kong','Cpatch mirror in Hong Kong',20050106221155); INSERT INTO `categorylinks` VALUES (980,'Mirror_in_Hong_Kong','Ibiblio mirror in Hong Kong',20050106222017); INSERT INTO `categorylinks` VALUES (981,'Mirror_in_Hong_Kong','Mozilla mirror in Hong Kong',20050106222408); INSERT INTO `categorylinks` VALUES (982,'Mirror_in_Hong_Kong','Netscape mirror in Hong Kong',20050106223015); INSERT INTO `categorylinks` VALUES (983,'Mirror_in_Hong_Kong','RFC mirror in Hong Kong',20050106224542); INSERT INTO `categorylinks` VALUES (984,'Mirror_in_Hong_Kong','TeX mirror in Hong Kong',20050106223717); INSERT INTO `categorylinks` VALUES (985,'Mirror_in_Hong_Kong','Usenet FAQ mirror in Hong Kong',20050106224055); INSERT INTO `categorylinks` VALUES (986,'Mirror_in_Hong_Kong','X11 mirror in Hong Kong',20050524095039); INSERT INTO `categorylinks` VALUES (991,'Mirror_in_Hong_Kong','Mirror in Hong Kong',20050119085504); INSERT INTO `categorylinks` VALUES (995,'Fedora','How to install application with YUM',20050512202158); INSERT INTO `categorylinks` VALUES (799,'中文化','Where can I find fonts for GNU/Linux',20051028180923); INSERT INTO `categorylinks` VALUES (810,'中文化','Xcin',20050204231332); INSERT INTO `categorylinks` VALUES (997,'中文化','Make Debian support Chinese (eng)',20051023191818); INSERT INTO `categorylinks` VALUES (997,'Debian','Make Debian support Chinese (eng)',20051023191818); INSERT INTO `categorylinks` VALUES (801,'Debian','Install Java on Debian',20051023191842); INSERT INTO `categorylinks` VALUES (1007,'MediaWiki','How to make MediaWiki search less then 4 chars',20050316052000); INSERT INTO `categorylinks` VALUES (1008,'MediaWiki','How to configure MediaWiki allow Image upload',20050316053306); INSERT INTO `categorylinks` VALUES (1010,'MediaWiki','How to make MediaWiki display math formula',20050518201123); INSERT INTO `categorylinks` VALUES (1011,'MediaWiki','How to display RSS feed headline in MediaWiki',20050510010451); INSERT INTO `categorylinks` VALUES (2206,'Free_Windows','StarDict in Windows',20051022013618); INSERT INTO `categorylinks` VALUES (2208,'Multimedia','Video via internet',20051023054112); INSERT INTO `categorylinks` VALUES (2225,'小小作品','Template:Substub',20050511075441); INSERT INTO `categorylinks` VALUES (2226,'未完成列表','OSWikiHK:Templates',20050511083259); INSERT INTO `categorylinks` VALUES (2228,'未完成列表','Template:Listdev',20050511080618); INSERT INTO `categorylinks` VALUES (2230,'中立性有爭議的作品','Template:NPOV',20050511081557); INSERT INTO `categorylinks` VALUES (2226,'小作品','OSWikiHK:Templates',20050511083259); INSERT INTO `categorylinks` VALUES (2226,'小小作品','OSWikiHK:Templates',20050511083259); INSERT INTO `categorylinks` VALUES (2231,'準確性有爭議准的作品','Template:Disputed',20050511082603); INSERT INTO `categorylinks` VALUES (2226,'中立性有爭議的作品','OSWikiHK:Templates',20050511083259); INSERT INTO `categorylinks` VALUES (2226,'準確性有爭議准的作品','OSWikiHK:Templates',20050511083259); INSERT INTO `categorylinks` VALUES (808,'Debian','Install Debian GNU/Linux',20051020104647); INSERT INTO `categorylinks` VALUES (995,'小作品','How to install application with YUM',20050512202158); INSERT INTO `categorylinks` VALUES (2245,'Postfix','Migration from Sendmail to Postfix',20051024203906); INSERT INTO `categorylinks` VALUES (2245,'Sendmail','Migration from Sendmail to Postfix',20051024203906); INSERT INTO `categorylinks` VALUES (2258,'Mail','Postfix',20050514143353); INSERT INTO `categorylinks` VALUES (1017,'Mail','Filter spam with HELO check',20050613015652); INSERT INTO `categorylinks` VALUES (1018,'Mail','SMTP',20050514145356); INSERT INTO `categorylinks` VALUES (2248,'Postfix','Migration from Sendmail to Postfix Mailgate',20050514150936); INSERT INTO `categorylinks` VALUES (2269,'教育','虚拟教研',20050518215136); INSERT INTO `categorylinks` VALUES (2270,'教育','经典教育',20050518222114); INSERT INTO `categorylinks` VALUES (2276,'Time_Server','Setup OpenNTPD',20051010111253); INSERT INTO `categorylinks` VALUES (2276,'OpenBSD','Setup OpenNTPD',20051010111253); INSERT INTO `categorylinks` VALUES (2290,'Mail','IMAP',20050612212744); INSERT INTO `categorylinks` VALUES (832,'PHP','PEAR',20050612221105); INSERT INTO `categorylinks` VALUES (832,'PEAR','PEAR',20050612221105); INSERT INTO `categorylinks` VALUES (1021,'User_Administration','Add many users in GNU/Linux',20050613020152); INSERT INTO `categorylinks` VALUES (2293,'System_Administration','User Administration',20050612222046); INSERT INTO `categorylinks` VALUES (862,'Security','Generate SSL cert',20050613001706); INSERT INTO `categorylinks` VALUES (862,'Open_Source','Generate SSL cert',20050613001706); INSERT INTO `categorylinks` VALUES (2297,'WWW','Apache',20050612231450); INSERT INTO `categorylinks` VALUES (840,'Open_Source','Free Software',20050612223349); INSERT INTO `categorylinks` VALUES (848,'名人','Bruce Perens',20050612223541); INSERT INTO `categorylinks` VALUES (848,'Open_Source','Bruce Perens',20050612223541); INSERT INTO `categorylinks` VALUES (771,'GNU/Linux_Distribution','Debian GNU/Linux',20050612224606); INSERT INTO `categorylinks` VALUES (769,'GNU/Linux_Distribution','GNU/Linux Distribution',20050612225231); INSERT INTO `categorylinks` VALUES (847,'名人','Eric S. Raymond',20050612225321); INSERT INTO `categorylinks` VALUES (2186,'Mail','E-mail System',20050612225406); INSERT INTO `categorylinks` VALUES (843,'組織','Free Software Foundation',20050612225837); INSERT INTO `categorylinks` VALUES (841,'Open_Source','Free Software History',20050612230037); INSERT INTO `categorylinks` VALUES (844,'Open_Source','GNU',20050612230137); INSERT INTO `categorylinks` VALUES (908,'Open_Source','GNU/GPL Software',20050612230237); INSERT INTO `categorylinks` VALUES (809,'Open_Source','GNU/GPL Software on Linux',20050612230354); INSERT INTO `categorylinks` VALUES (907,'Open_Source','GNU/GPL Software on Windows',20050623155433); INSERT INTO `categorylinks` VALUES (2221,'Open_Source','GNU/Linux Newbie Reference',20050612230623); INSERT INTO `categorylinks` VALUES (910,'Open_Source','GPL Software on Linux',20050612230812); INSERT INTO `categorylinks` VALUES (846,'Open_Source','Hacker',20050713043147); INSERT INTO `categorylinks` VALUES (1014,'WWW','Virtual hosting with Apache',20050615025919); INSERT INTO `categorylinks` VALUES (1014,'Apache','Virtual hosting with Apache',20050615025919); INSERT INTO `categorylinks` VALUES (735,'Encryption','How to download GnuPGKey from Keyserver',20050614213047); INSERT INTO `categorylinks` VALUES (739,'Encryption','How to download GnuPG Key from Keyserver',20050612232004); INSERT INTO `categorylinks` VALUES (842,'名人','Richard M. Stallman',20050612232133); INSERT INTO `categorylinks` VALUES (1027,'PHP','Generate transparent gif in PHP',20050613020107); INSERT INTO `categorylinks` VALUES (734,'Encryption','How to generate GnuPG Revoke Certificate',20050612232939); INSERT INTO `categorylinks` VALUES (732,'Encryption','How to generate GnuPG Key',20050612234622); INSERT INTO `categorylinks` VALUES (2192,'WWW','Fix transparent PNGs on MSIE',20050613020039); INSERT INTO `categorylinks` VALUES (737,'Encryption','How to export GnuPG Key',20050612234855); INSERT INTO `categorylinks` VALUES (774,'Open_Source','Ridiculous Patent',20050612235200); INSERT INTO `categorylinks` VALUES (2272,'OpenBSD','Setup Kerberos in OpenBSD',20050612235752); INSERT INTO `categorylinks` VALUES (2272,'Security','Setup Kerberos in OpenBSD',20050612235752); INSERT INTO `categorylinks` VALUES (850,'Open_Source','Open Source',20050613000655); INSERT INTO `categorylinks` VALUES (768,'Open_Source','Who use Open Source Software',20050613000805); INSERT INTO `categorylinks` VALUES (855,'Open_Source','Why Use Linux',20050613000848); INSERT INTO `categorylinks` VALUES (851,'Open_Source','Why use Free Software',20050613000944); INSERT INTO `categorylinks` VALUES (817,'Open_Source','Why use Open Source Software',20050613001031); INSERT INTO `categorylinks` VALUES (865,'Get_Started','Windows Software Replacement',20050613001320); INSERT INTO `categorylinks` VALUES (865,'Open_Source','Windows Software Replacement',20050613001320); INSERT INTO `categorylinks` VALUES (2308,'Open_Source','OpenBSD',20050613001446); INSERT INTO `categorylinks` VALUES (861,'Encryption','How to have your own CA',20050613001617); INSERT INTO `categorylinks` VALUES (862,'WWW','Generate SSL cert',20050613001706); INSERT INTO `categorylinks` VALUES (862,'Apache','Generate SSL cert',20050613001706); INSERT INTO `categorylinks` VALUES (862,'IMAP','Generate SSL cert',20050613001706); INSERT INTO `categorylinks` VALUES (2220,'Open_Source','Install Mandrake Linux',20050613001816); INSERT INTO `categorylinks` VALUES (2220,'Get_Started','Install Mandrake Linux',20050613001816); INSERT INTO `categorylinks` VALUES (857,'Get_Started','Linux Hardware Requirement',20050613001946); INSERT INTO `categorylinks` VALUES (836,'PHP','PEAR::DB fetchRow',20050613002044); INSERT INTO `categorylinks` VALUES (837,'PHP','PEAR::DB Sequence',20050613002114); INSERT INTO `categorylinks` VALUES (835,'PHP','PEAR::DB SQL statement',20050613002141); INSERT INTO `categorylinks` VALUES (838,'PHP','PEAR::DB Error',20050613002224); INSERT INTO `categorylinks` VALUES (834,'PHP','PEAR::DB::Connect',20050613002258); INSERT INTO `categorylinks` VALUES (833,'PHP','PEAR::DB',20050613002337); INSERT INTO `categorylinks` VALUES (1027,'WWW','Generate transparent gif in PHP',20050613020107); INSERT INTO `categorylinks` VALUES (773,'Mail','Prevent to be Open Relay mail server',20050615114014); INSERT INTO `categorylinks` VALUES (1000,'System_Administration','How to reset root password',20050613003237); INSERT INTO `categorylinks` VALUES (1024,'中文化','How to use chinese on X Terminal',20050613003311); INSERT INTO `categorylinks` VALUES (875,'System_Administration','How to use CPU manage LDAP server',20050613003356); INSERT INTO `categorylinks` VALUES (733,'Encryption','How to upload GnuPG Key to Keyserver',20050613003438); INSERT INTO `categorylinks` VALUES (736,'Encryption','How to sign GnuPG Key',20050613003528); INSERT INTO `categorylinks` VALUES (874,'組織','SambaHongKong',20050704101134); INSERT INTO `categorylinks` VALUES (849,'組織','Software In Public Interest',20050613003745); INSERT INTO `categorylinks` VALUES (858,'Office_Suite','How to install OpenOffice.org',20050613004130); INSERT INTO `categorylinks` VALUES (1020,'Mandrake','Install software via urpmi',20050613021739); INSERT INTO `categorylinks` VALUES (775,'Get_Started','Install GNU/Linux',20050613035224); INSERT INTO `categorylinks` VALUES (738,'Encryption','How to import GnuPG Key',20050613004547); INSERT INTO `categorylinks` VALUES (730,'Encryption','How to join GNUPG key signing Party',20050613004632); INSERT INTO `categorylinks` VALUES (856,'Open_Source','Is Free Software Secure',20050613004702); INSERT INTO `categorylinks` VALUES (878,'Samba','Scan virus on Samba with ClamAV',20050613011158); INSERT INTO `categorylinks` VALUES (878,'Security','Scan virus on Samba with ClamAV',20050613011158); INSERT INTO `categorylinks` VALUES (2282,'Mail','Use virtual mailbox in Postfix',20050613015110); INSERT INTO `categorylinks` VALUES (2282,'Postfix','Use virtual mailbox in Postfix',20050613015110); INSERT INTO `categorylinks` VALUES (2282,'IMAP','Use virtual mailbox in Postfix',20050613015110); INSERT INTO `categorylinks` VALUES (1020,'Get_Started','Install software via urpmi',20050613021739); INSERT INTO `categorylinks` VALUES (2331,'Get_Started','Install software via APT',20050624131909); INSERT INTO `categorylinks` VALUES (2331,'System_Administration','Install software via APT',20050624131909); INSERT INTO `categorylinks` VALUES (2335,'Gnome','GTK File Chooser Bookmark',20050613153551); INSERT INTO `categorylinks` VALUES (2352,'小作品','Login via SSH without password',20050624115314); INSERT INTO `categorylinks` VALUES (2352,'Encryption','Login via SSH without password',20050624115314); INSERT INTO `categorylinks` VALUES (2331,'Debian','Install software via APT',20050624131909); INSERT INTO `categorylinks` VALUES (2331,'Fedora','Install software via APT',20050624131909); INSERT INTO `categorylinks` VALUES (2207,'User_Administration','Webmin ldap users and groups',20051020103903); INSERT INTO `categorylinks` VALUES (2373,'Mirror_in_Hong_Kong','CentOS Linux mirror in Hong Kong',20050802220757); INSERT INTO `categorylinks` VALUES (2374,'Mirror_in_Hong_Kong','PHP mirror in Hong Kong',20050802213540); INSERT INTO `categorylinks` VALUES (2375,'Mirror_in_Hong_Kong','ProFTPD mirror in Hong Kong',20050802214230); INSERT INTO `categorylinks` VALUES (2376,'Mirror_in_Hong_Kong','CAos Linux mirror in Hong Kong',20050802220921); INSERT INTO `categorylinks` VALUES (2377,'Mirror_in_Hong_Kong','The Linux Documentation Project Mirror in Hong Kong',20050803003339); INSERT INTO `categorylinks` VALUES (2437,'Wiki','天下维客',20051002171914); INSERT INTO `categorylinks` VALUES (2437,'系统文档','天下维客',20051002171914); INSERT INTO `categorylinks` VALUES (2438,'超文本','Wiki',20051002171941); INSERT INTO `categorylinks` VALUES (919,'Mail','Mail Receive Agent',20051010112030); INSERT INTO `categorylinks` VALUES (808,'Open_Source','Install Debian GNU/Linux',20051020104647); INSERT INTO `categorylinks` VALUES (808,'Get_Started','Install Debian GNU/Linux',20051020104647);