# MySQL dump 5.13
#
# Host: localhost    Database: plnews
#--------------------------------------------------------
# Server version	3.22.22

#
# Table structure for table 'articles'
#
CREATE TABLE articles (
  id int(11) NOT NULL auto_increment,
  author varchar(48),
  email varchar(48),
  title text,
  msg text,
  category char(3),
  homepage text,
  download text,
  datetime datetime,
  PRIMARY KEY (id)
);

#
# Dumping data for table 'articles'
#

INSERT INTO articles VALUES (1,'chiller2','kelv@planetlinux.org.uk','PlanetLinux beta','Welcome to the PlanetLinux website. We hope to bring you a nice mixture of UK based Linux content, including news from the global community and events of specific interest to UK Linux users.','1','http://www.planetlinux.org.uk','','1999-09-13 00:31:55');
INSERT INTO articles VALUES (2,'chiller2','kelv@kelv.net','Slackware 5.0 glibc\'d','The historically libc5 based <b>Slackware Linux</b> has been upgraded to use the newer, and much more popular glibc based libaries upon which\r\nRedHat Linux, Debian, etc are based. If you\'re interested, check out \r\n<a href=\"ftp://sunsite.doc.ic.ac.uk/Mirrors/ftp.cdrom.com/pub/linux/slackware-current\">ftp.cdrom.com</a>.','1','http://www.slackware.com','','1999-09-13 03:50:09');
INSERT INTO articles VALUES (3,'Nagasaqi','pete@astra.ky','Just a test........','This has got to be one of the coolest things around.','1','www.astra.ky','','1999-09-13 18:06:52');
INSERT INTO articles VALUES (4,'chiller2','kelv@kelv.net','KDE 1.1.2 Released','KDE 1.1.2 is now available for <a href=\"http://www.kde.org/mirrors.html\">download</a>. I haven\'t had a lot of time to dig out its finer points but it certainly has more themes and pretty icons. Available as tarball (gzip & bz2) and debian packages. Enjoy!','2','http://www.kde.org','http://www.kde.org/mirrors.html','1999-09-14 11:58:02');
INSERT INTO articles VALUES (5,'chiller2','kelv@kelv.net','Linux @ Work Conference','Among the speakers will be <b>SuSE</b>, demonstrating effective use of Linux within enterprise, and also giving their take on the future of the OS\'s \r\ndevelopment. <b>Inprise</b> (Borland) will be talking on porting their development tools. Other speakers will include database big boys <b>Oracle</b> \r\nand <b>Informix</b>, and <b>Redhat Software</b>. The event takes place on 30th September at the Mayfair Intercontinental, London.\r\nIf you\'d like to know more, visit <a href=\"http://www.ltt.de/linux_lon.html\">the Linux@Work</a> site. ','1','http://www.ltt.de/linux_lon.html','','1999-09-14 12:36:38');
INSERT INTO articles VALUES (6,'chiller2','kelv@kelv.net','UK Linux distributor','Looking for a good deal on getting hold of Linux distribution CDs, books, etc? The chaps at <a href=\"https://ssl.dgc.co.uk/dgc-nms/web_store.cgi\">DGC</a> seem fairly cheap, and have a substantial range of Linux (and FreeBSD,BeOS) products available for online purchase or via a local rate phone number. Any feedback on their service would be much appreciated :)','1','https://ssl.dgc.co.uk/dgc-nms/web_store.cgi','','1999-09-14 12:59:25');
INSERT INTO articles VALUES (7,'chiller2','kelv@kelv.net','Star Office 5.2 Preview','If you\'ve the patience for the 100MB download, get your mits on the preview version of StarOffice 5.2. Improvements include much better support for Microsoft Office file formats, even as recent as Office 2000. There are both Linux and Windows versions available.','1','http://www.sun.com/products/staroffice/preview/','http://www.sun.com/products/staroffice/preview/download.html','2000-04-07 16:08:28');
INSERT INTO articles VALUES (8,'chiller2','kelv@kelv.net','RedHat Is Not Linux','With the intention of enlightening PHBs and software/hardware vendors who think that RedHat *is* Linux, rather than just a distribution, Gavin Roy from <a href=\"http://www.readysetnet.com/\" target=\"_new\">Ready Set Net</a> has created the <b><a href=\"http://www.redhatisnotlinux.org/\" target=\"_new\">RedHatIsNotLinux</a></b>(.org). Quite a few have signed the petition, which will be forwarded to the vendors soon. Worth a look :)','1','http://www.redhatisnotlinux.org/','','2000-04-28 08:35:27');

