CREATE TABLE adminblock (
  title varchar(60),
  content text
);

INSERT INTO adminblock VALUES ('Administration','Admins can have its own box, but just one. Who need more?<br>\r\nAdd the options you like. This box will appear only if you\r\nhas been logged like Admin. No others users can view this.<br>\r\n<li><a href=admin.php>Administration</a>\r\n<li><a href=admin.php?op=logout>Logout</a>');

CREATE TABLE authors (
  aid varchar(30) DEFAULT '' NOT NULL,
  name varchar(50),
  url varchar(60),
  email varchar(60),
  pwd varchar(13),
  counter int(11) DEFAULT '0' NOT NULL,
  radminarticle tinyint(2) DEFAULT '0' NOT NULL,
  radmintopic tinyint(2) DEFAULT '0' NOT NULL,
  radminleft tinyint(2) DEFAULT '0' NOT NULL,
  radminright tinyint(2) DEFAULT '0' NOT NULL,
  radminuser tinyint(2) DEFAULT '0' NOT NULL,
  radminmain tinyint(2) DEFAULT '0' NOT NULL,
  radminsurvey tinyint(2) DEFAULT '0' NOT NULL,
  radminsection tinyint(2) DEFAULT '0' NOT NULL,
  radminlink tinyint(2) DEFAULT '0' NOT NULL,
  radminephem tinyint(2) DEFAULT '0' NOT NULL,
  radminfilem tinyint(2) DEFAULT '0' NOT NULL,
  radminhead tinyint(2) DEFAULT '0' NOT NULL,
  radminsuper tinyint(2) DEFAULT '1' NOT NULL,
  PRIMARY KEY (aid)
);


INSERT INTO authors VALUES ('God','God','http://phpnuke.org','http://phpnuke.org','Password',1,0,0,0,0,0,0,0,0,0,0,0,0,1);


CREATE TABLE autonews (
  anid int(11) NOT NULL auto_increment,
  aid varchar(30) DEFAULT '' NOT NULL,
  title varchar(80) DEFAULT '' NOT NULL,
  time varchar(19) DEFAULT '' NOT NULL,
  hometext text DEFAULT '' NOT NULL,
  bodytext text DEFAULT '' NOT NULL,
  topic int(3) DEFAULT '1' NOT NULL,
  informant varchar(20) DEFAULT '' NOT NULL,
  notes text DEFAULT '' NOT NULL,
  PRIMARY KEY (anid)
);


CREATE TABLE banner (
  bid int(11) NOT NULL auto_increment,
  cid int(11) DEFAULT '0' NOT NULL,
  imptotal int(11) DEFAULT '0' NOT NULL,
  impmade int(11) DEFAULT '0' NOT NULL,
  clicks int(11) DEFAULT '0' NOT NULL,
  imageurl varchar(100) DEFAULT '' NOT NULL,
  clickurl varchar(200) DEFAULT '' NOT NULL,
  date datetime,
  PRIMARY KEY (bid)
);




CREATE TABLE bannerclient (
  cid int(11) NOT NULL auto_increment,
  name varchar(60) DEFAULT '' NOT NULL,
  contact varchar(60) DEFAULT '' NOT NULL,
  email varchar(60) DEFAULT '' NOT NULL,
  login varchar(10) DEFAULT '' NOT NULL,
  passwd varchar(10) DEFAULT '' NOT NULL,
  extrainfo text DEFAULT '' NOT NULL,
  PRIMARY KEY (cid)
);




CREATE TABLE bannerfinish (
  bid int(11) NOT NULL auto_increment,
  cid int(11) DEFAULT '0' NOT NULL,
  impressions int(11) DEFAULT '0' NOT NULL,
  clicks int(11) DEFAULT '0' NOT NULL,
  datestart datetime,
  dateend datetime,
  PRIMARY KEY (bid)
);




CREATE TABLE comments (
  tid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0',
  sid int(11) DEFAULT '0',
  date datetime,
  name varchar(60) DEFAULT '' NOT NULL,
  email varchar(60),
  url varchar(60),
  host_name varchar(60),
  subject varchar(60) DEFAULT '' NOT NULL,
  comment text DEFAULT '' NOT NULL,
  score tinyint(4) DEFAULT '0' NOT NULL,
  reason tinyint(4) DEFAULT '0' NOT NULL,
  PRIMARY KEY (tid)
);


INSERT INTO comments VALUES (1,0,1,'2000-12-04 12:00:00','','','','150.10.10.10','Re: Welcome to PHP-Nuke 4.3','FIRST COMMENT!\r<br>\n\r<br>\nAll my life I wanted to do this ;)',0,0);


CREATE TABLE counter (
  type varchar(80) DEFAULT '' NOT NULL,
  var varchar(80) DEFAULT '' NOT NULL,
  count int(10) unsigned DEFAULT '0' NOT NULL
);


INSERT INTO counter VALUES ('total','hits',1);
INSERT INTO counter VALUES ('browser','WebTV',0);
INSERT INTO counter VALUES ('browser','Lynx',0);
INSERT INTO counter VALUES ('browser','MSIE',0);
INSERT INTO counter VALUES ('browser','Opera',0);
INSERT INTO counter VALUES ('browser','Konqueror',0);
INSERT INTO counter VALUES ('browser','Netscape',1);
INSERT INTO counter VALUES ('browser','Bot',0);
INSERT INTO counter VALUES ('browser','Other',0);
INSERT INTO counter VALUES ('os','Windows',0);
INSERT INTO counter VALUES ('os','Linux',1);
INSERT INTO counter VALUES ('os','Mac',0);
INSERT INTO counter VALUES ('os','FreeBSD',0);
INSERT INTO counter VALUES ('os','SunOS',0);
INSERT INTO counter VALUES ('os','IRIX',0);
INSERT INTO counter VALUES ('os','BeOS',0);
INSERT INTO counter VALUES ('os','OS/2',0);
INSERT INTO counter VALUES ('os','AIX',0);
INSERT INTO counter VALUES ('os','Other',0);


CREATE TABLE ephem (
  eid int(11) NOT NULL auto_increment,
  did int(2) DEFAULT '0' NOT NULL,
  mid int(2) DEFAULT '0' NOT NULL,
  yid int(4) DEFAULT '0' NOT NULL,
  content text DEFAULT '' NOT NULL,
  PRIMARY KEY (eid)
);


CREATE TABLE headlines (
  hid int(11) NOT NULL auto_increment,
  sitename varchar(30) DEFAULT '' NOT NULL,
  url varchar(100) DEFAULT '' NOT NULL,
  headlinesurl varchar(200) DEFAULT '' NOT NULL,
  status tinyint(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (hid)
);


INSERT INTO headlines VALUES (1,'PHP-Nuke','http://phpnuke.org','http://phpnuke.org/backend.php',0);
INSERT INTO headlines VALUES (2,'LinuxPreview','http://linuxpreview.org','http://linuxpreview.org/backend.php3',0);
INSERT INTO headlines VALUES (3,'Slashdot','http://slashdot.org','http://slashdot.org/slashdot.rdf',0);
INSERT INTO headlines VALUES (4,'NewsForge','http://www.newsforge.com','http://www.newsforge.com/newsforge.rdf',0);
INSERT INTO headlines VALUES (5,'PHPBuilder','http://phpbuilder.com','http://phpbuilder.com/rss_feed.php',0);
INSERT INTO headlines VALUES (6,'Linux.com','http://linux.com','http://linux.com/mrn/front_page.rss',0);
INSERT INTO headlines VALUES (7,'Freshmeat','http://freshmeat.net','http://freshmeat.net/backend/fm.rdf',0);
INSERT INTO headlines VALUES (8,'AppWatch','http://static.appwatch.com','http://static.appwatch.com/appwatch.rdf',0);
INSERT INTO headlines VALUES (9,'LinuxWeelyNews','http://lwn.net','http://lwn.net/headlines/rss',0);
INSERT INTO headlines VALUES (10,'HappyPenguin','http://happypenguin.org','http://happypenguin.org/html/news.rdf',0);
INSERT INTO headlines VALUES (11,'Segfault','http://segfault.org','http://segfault.org/stories.xml',0);
INSERT INTO headlines VALUES (13,'KDE','http://www.kde.org','http://www.kde.org/news/kdenews.rdf',0);
INSERT INTO headlines VALUES (14,'Perl.com','http://www.perl.com','http://www.perl.com/pace/perlnews.rdf',0);
INSERT INTO headlines VALUES (15,'Themes.org','http://themes.org','http://www.themes.org/news.rdf.phtml',0);
INSERT INTO headlines VALUES (16,'BrunchingShuttlecocks','http://www.brunching.com','http://www.brunching.com/brunching.rdf',0);
INSERT INTO headlines VALUES (17,'MozillaNewsBot','http://www.mozilla.org/newsbot/','http://www.mozilla.org/newsbot/newsbot.rdf',0);
INSERT INTO headlines VALUES (18,'NewsTrolls','http://newstrolls.com','http://newstrolls.com/newstrolls.rdf',0);
INSERT INTO headlines VALUES (19,'FreakTech','http://sunsite.auc.dk/FreakTech/','http://sunsite.auc.dk/FreakTech/FreakTech.rdf',0);
INSERT INTO headlines VALUES (20,'AbsoluteGames','http://files.gameaholic.com','http://files.gameaholic.com/agfa.rdf',0);
INSERT INTO headlines VALUES (21,'SciFi-News','http://www.technopagan.org/sf-news/','http://www.technopagan.org/sf-news/rdf.php',0);
INSERT INTO headlines VALUES (22,'SisterMachineGun','http://www.smg.org','http://www.smg.org/index/mynetscape.html',0);
INSERT INTO headlines VALUES (23,'LinuxM68k','http://www.linux-m68k.org','http://www.linux-m68k.org/linux-m68k.rdf',0);
INSERT INTO headlines VALUES (24,'Protest.net','http://www.protest.net','http://www.protest.net/netcenter_rdf.cgi',0);
INSERT INTO headlines VALUES (25,'HollywoodBitchslap','http://hollywoodbitchslap.com','http://hollywoodbitchslap.com/hbs.rdf',0);
INSERT INTO headlines VALUES (26,'DrDobbsTechNetCast','http://www.technetcast.com','http://www.technetcast.com/tnc_headlines.rdf',0);
INSERT INTO headlines VALUES (27,'RivaExtreme','http://rivaextreme.com','http://rivaextreme.com/ssi/rivaextreme.rdf.cdf',0);
INSERT INTO headlines VALUES (28,'Linuxpower','http://linuxpower.org','http://linuxpower.org/linuxpower.rdf',0);
INSERT INTO headlines VALUES (29,'PBSOnline','http://www.pbs.org','http://cgi.pbs.org/cgi-registry/featuresrdf.pl',0);
INSERT INTO headlines VALUES (30,'Listology','http://www.listology.com','http://listology.com/recent.rdf',0);
INSERT INTO headlines VALUES (31,'Linuxdev.net','http://linuxdev.net','http://linuxdev.net/archive/news.cdf',0);
INSERT INTO headlines VALUES (32,'LinuxNewbie','http://www.linuxnewbie.org','http://www.linuxnewbie.org/news.cdf',0);
INSERT INTO headlines VALUES (33,'exoScience','http://www.exosci.com','http://www.exosci.com/exosci.rdf',0);
INSERT INTO headlines VALUES (34,'Technocrat','http://www.technocrat.net','http://technocrat.net/rdf',0);
INSERT INTO headlines VALUES (35,'PDABuzz','http://www.pdabuzz.com','http://www.pdabuzz.com/netscape.txt',0);
INSERT INTO headlines VALUES (36,'MicroUnices','http://mu.current.nu','http://mu.current.nu/mu.rdf',0);
INSERT INTO headlines VALUES (37,'TheNextLevel','http://www.the-nextlevel.com','http://www.the-nextlevel.com/rdf/tnl.rdf',0);
INSERT INTO headlines VALUES (38,'Gnotices','http://news.gnome.org/gnome-news/','http://news.gnome.org/gnome-news/rdf',0);
INSERT INTO headlines VALUES (39,'DailyDaemonNews','http://daily.daemonnews.org','http://daily.daemonnews.org/ddn.rdf.php3',0);
INSERT INTO headlines VALUES (40,'PerlMonks','http://www.perlmonks.org','http://www.perlmonks.org/headlines.rdf',0);
INSERT INTO headlines VALUES (41,'PerlNews','http://news.perl.org','http://news.perl.org/perl-news-short.rdf',0);
INSERT INTO headlines VALUES (42,'BSDToday','http://www.bsdtoday.com','http://www.bsdtoday.com/backend/bt.rdf',0);
INSERT INTO headlines VALUES (43,'DotKDE','http://dot.kde.org','http://dot.kde.org/rdf',0);
INSERT INTO headlines VALUES (44,'GeekNik','http://www.geeknik.net','http://www.geeknik.net/backend/weblog.rdf',0);
INSERT INTO headlines VALUES (45,'HotWired','http://www.hotwired.com','http://www.hotwired.com/webmonkey/meta/headlines.rdf',0);
INSERT INTO headlines VALUES (46,'JustLinux','http://www.justlinux.com','http://www.justlinux.com/backend/features.rdf',0);
INSERT INTO headlines VALUES (47,'LAN-Systems','http://www.lansystems.com','http://www.lansystems.com/backend/gazette_news_backend.rdf',0);
INSERT INTO headlines VALUES (48,'LinuxCentral','http://linuxcentral.com','http://linuxcentral.com/backend/lcnew.rdf',0);
INSERT INTO headlines VALUES (49,'Linux.nu','http://www.linux.nu','http://www.linux.nu/backend/lnu.rdf',0);
INSERT INTO headlines VALUES (50,'Lin-x-pert','http://www.lin-x-pert.com','http://www.lin-x-pert.com/linxpert_apps.rdf',0);
INSERT INTO headlines VALUES (51,'MaximumBSD','http://www.maximumbsd.com','http://www.maximumbsd.com/backend/weblog.rdf',0);
INSERT INTO headlines VALUES (52,'SolarisCentral','http://www.SolarisCentral.org','http://www.SolarisCentral.org/news/SolarisCentral.rdf',0);
INSERT INTO headlines VALUES (53,'DigitalTheatre','http://www.dtheatre.com','http://www.dtheatre.com/backend.php3?xml=yes',0);


CREATE TABLE lblocks (
  id tinyint(4) NOT NULL auto_increment,
  title varchar(60),
  content text,
  PRIMARY KEY (id)
);


INSERT INTO lblocks VALUES (1,'First Left Block','You can add/remove/edit blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like <a href=http://phpnuke.org>links</a>, <b>Bold</b> text, images, etc.\r\nJust use you imagination.');
INSERT INTO lblocks VALUES (2,'Special Sections','What about a <a href=sections.php>Special Sections</a>option in the PHP-Nuke code? A place to publish reviews, special articles, interviews, or whatever, independent of the main news.');


CREATE TABLE links_categories (
  cid int(11) NOT NULL auto_increment,
  title varchar(50) DEFAULT '' NOT NULL,
  cdescription text DEFAULT '' NOT NULL,
  PRIMARY KEY (cid)
);


CREATE TABLE links_editorials (
  linkid int(11) DEFAULT '0' NOT NULL,
  adminid varchar(60) DEFAULT '' NOT NULL,
  editorialtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  editorialtext text DEFAULT '' NOT NULL,
  editorialtitle varchar(100) DEFAULT '' NOT NULL,
  PRIMARY KEY (linkid)
);


CREATE TABLE links_links (
  lid int(11) NOT NULL auto_increment,
  cid int(11) DEFAULT '0' NOT NULL,
  sid int(11) DEFAULT '0' NOT NULL,
  title varchar(100) DEFAULT '' NOT NULL,
  url varchar(100) DEFAULT '' NOT NULL,
  description text DEFAULT '' NOT NULL,
  date datetime,
  name varchar(60) DEFAULT '' NOT NULL,
  email varchar(60) DEFAULT '' NOT NULL,
  hits int(11) DEFAULT '0' NOT NULL,
  submitter varchar(60) DEFAULT '' NOT NULL,
  linkratingsummary double(6,4) DEFAULT '0.0000' NOT NULL,
  totalvotes int(11) DEFAULT '0' NOT NULL,
  totalcomments int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (lid)
);




CREATE TABLE links_modrequest (
  requestid int(11) NOT NULL auto_increment,
  lid int(11) DEFAULT '0' NOT NULL,
  cid int(11) DEFAULT '0' NOT NULL,
  sid int(11) DEFAULT '0' NOT NULL,
  title varchar(100) DEFAULT '' NOT NULL,
  url varchar(100) DEFAULT '' NOT NULL,
  description text DEFAULT '' NOT NULL,
  modifysubmitter varchar(60) DEFAULT '' NOT NULL,
  brokenlink int(3) DEFAULT '0' NOT NULL,
  PRIMARY KEY (requestid),
  UNIQUE requestid (requestid)
);




CREATE TABLE links_newlink (
  lid int(11) NOT NULL auto_increment,
  cid int(11) DEFAULT '0' NOT NULL,
  sid int(11) DEFAULT '0' NOT NULL,
  title varchar(100) DEFAULT '' NOT NULL,
  url varchar(100) DEFAULT '' NOT NULL,
  description text DEFAULT '' NOT NULL,
  name varchar(60) DEFAULT '' NOT NULL,
  email varchar(60) DEFAULT '' NOT NULL,
  submitter varchar(60) DEFAULT '' NOT NULL,
  PRIMARY KEY (lid)
);




CREATE TABLE links_subcategories (
  sid int(11) NOT NULL auto_increment,
  cid int(11) DEFAULT '0' NOT NULL,
  title varchar(50) DEFAULT '' NOT NULL,
  PRIMARY KEY (sid)
);




CREATE TABLE links_votedata (
  ratingdbid int(11) NOT NULL auto_increment,
  ratinglid int(11) DEFAULT '0' NOT NULL,
  ratinguser varchar(60) DEFAULT '' NOT NULL,
  rating int(11) DEFAULT '0' NOT NULL,
  ratinghostname varchar(60) DEFAULT '' NOT NULL,
  ratingcomments text DEFAULT '' NOT NULL,
  ratingtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  PRIMARY KEY (ratingdbid)
);




CREATE TABLE mainblock (
  title varchar(60),
  content text
);


INSERT INTO mainblock VALUES ('Main Menu','<li><a href=index.php>Home</a>\r\n<li><a href=topics.php>Topics</a>\r\n<li><a href=sections.php>Sections</a>\r\n<li><a href=links.php>Web Links</a>\r\n<li><a href=friend.php>Recommend Us</a>\r\n<li><a href=memberslist.php>Members List</a>\r\n<li><a href=user.php>Your Account</a>\r\n<li><a href=submit.php>Submit News</a>\r\n<li><a href=stats.php>Stats</a>\r\n<li><a href=top.php>Top 10</a>\r\n<li><a href=faq.php>FAQ</a>');


CREATE TABLE poll_data (
  pollID int(11) DEFAULT '0' NOT NULL,
  optionText char(50) DEFAULT '' NOT NULL,
  optionCount int(11) DEFAULT '0' NOT NULL,
  voteID int(11) DEFAULT '0' NOT NULL
);


INSERT INTO poll_data VALUES (1,'Ummmm, not bad',0,1);
INSERT INTO poll_data VALUES (1,'Cool',0,2);
INSERT INTO poll_data VALUES (1,'Terrific',0,3);
INSERT INTO poll_data VALUES (1,'The best one!',0,4);
INSERT INTO poll_data VALUES (1,'what the hell is this?',0,5);
INSERT INTO poll_data VALUES (1,'',0,6);
INSERT INTO poll_data VALUES (1,'',0,7);
INSERT INTO poll_data VALUES (1,'',0,8);
INSERT INTO poll_data VALUES (1,'',0,9);
INSERT INTO poll_data VALUES (1,'',0,10);
INSERT INTO poll_data VALUES (1,'',0,11);
INSERT INTO poll_data VALUES (1,'',0,12);


CREATE TABLE poll_desc (
  pollID int(11) NOT NULL auto_increment,
  pollTitle char(100) DEFAULT '' NOT NULL,
  timeStamp int(11) DEFAULT '0' NOT NULL,
  voters mediumint(9) DEFAULT '0' NOT NULL,
  PRIMARY KEY (pollID)
);


INSERT INTO poll_desc VALUES (1,'What do you think about PHP-Nuke?',961405160,0);


CREATE TABLE pollcomments (
  tid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0',
  pollID int(11) DEFAULT '0',
  date datetime,
  name varchar(60) DEFAULT '' NOT NULL,
  email varchar(60),
  url varchar(60),
  host_name varchar(60),
  subject varchar(60) DEFAULT '' NOT NULL,
  comment text DEFAULT '' NOT NULL,
  score tinyint(4) DEFAULT '0' NOT NULL,
  reason tinyint(4) DEFAULT '0' NOT NULL,
  PRIMARY KEY (tid)
);




CREATE TABLE queue (
  qid smallint(5) unsigned NOT NULL auto_increment,
  uid mediumint(9) DEFAULT '0' NOT NULL,
  uname varchar(40) DEFAULT '' NOT NULL,
  subject varchar(100) DEFAULT '' NOT NULL,
  story text,
  timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  topic varchar(20) DEFAULT 'Linux' NOT NULL,
  PRIMARY KEY (qid)
);




CREATE TABLE quotes (
  qid int(10) unsigned NOT NULL auto_increment,
  quote text,
  PRIMARY KEY (qid)
);


INSERT INTO quotes VALUES (1,'Nos morituri te salutamus - CBHS');


CREATE TABLE rblocks (
  id tinyint(4) NOT NULL auto_increment,
  title varchar(60),
  content text,
  PRIMARY KEY (id)
);


INSERT INTO rblocks VALUES (1,'First Right Block','You can add/remove/edit blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like <a href=http://phpnuke.org>links</a>, <b>Bold</b> text, images, etc.\r\nJust use you imagination.');
INSERT INTO rblocks VALUES (2,'Information','<center>\r\nSite made with:<br>\r\n<a href=http://phpnuke.org><img src=images/powered/phpnuke.gif border=0></a><br>\r\n');


CREATE TABLE referer (
  rid int(11)  DEFAULT '0' NOT NULL auto_increment,
  url varchar(100) DEFAULT '' NOT NULL,
  PRIMARY KEY (rid)
);


CREATE TABLE related (
  rid int(11) NOT NULL auto_increment,
  tid int(11) DEFAULT '0' NOT NULL,
  name varchar(30) DEFAULT '' NOT NULL,
  url varchar(200) DEFAULT '' NOT NULL,
  PRIMARY KEY (rid)
);


CREATE TABLE seccont (
  artid int(11) NOT NULL auto_increment,
  secid int(11) DEFAULT '0' NOT NULL,
  title text DEFAULT '' NOT NULL,
  content text DEFAULT '' NOT NULL,
  counter int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (artid)
);




CREATE TABLE sections (
  secid int(11) NOT NULL auto_increment,
  secname varchar(40) DEFAULT '' NOT NULL,
  image varchar(50) DEFAULT '' NOT NULL,
  PRIMARY KEY (secid)
);


CREATE TABLE session (
  username varchar(25) DEFAULT '' NOT NULL,
  time varchar(14) DEFAULT '' NOT NULL,
  host_addr varchar(20) DEFAULT '' NOT NULL,
  guest int(1) DEFAULT '0' NOT NULL
);


CREATE TABLE stories (
  sid int(11) NOT NULL auto_increment,
  aid varchar(30) DEFAULT '' NOT NULL,
  title varchar(80),
  time datetime,
  hometext text,
  bodytext text DEFAULT '' NOT NULL,
  comments int(11) DEFAULT '0',
  counter mediumint(8) unsigned,
  topic int(3) DEFAULT '1' NOT NULL,
  informant varchar(20) DEFAULT '' NOT NULL,
  notes text DEFAULT '' NOT NULL,
  PRIMARY KEY (sid)
);


INSERT INTO stories VALUES (1,'god','Welcome to PHP-Nuke!!!','2000-12-04 12:00:00','This is the first <a href=http://phpnuke.org>article in PHP-Nuke</a>. You can delete it. Remember to set/change nickname and/or password for the main admin user. There aren\'t any registered/default user, so maybe you want to set the first one. Pelase read carefully the README file for some details, CREDITS files to see from where comes the things and remember that this is free software under the GPL License (COPYING file for details). Hope you enjoy this software. Please report any bug you find, and you\'ll for sure, so drop me an email when one of this annoying things happens and I\'ll try to fix it for the next releases.','',1,36,10,'god','');


CREATE TABLE topics (
  topicid int(3) NOT NULL auto_increment,
  topicname varchar(20),
  topicimage varchar(20),
  topictext varchar(40),
  counter int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (topicid)
);


INSERT INTO topics VALUES (1,'linux','linux.gif','Linux',0);
INSERT INTO topics VALUES (2,'amd','amd.gif','AMD',0);
INSERT INTO topics VALUES (3,'aol','aol.jpg','America Online',0);
INSERT INTO topics VALUES (4,'caldera','caldera.gif','Caldera Systems',0);
INSERT INTO topics VALUES (5,'apple','mac.gif','Apple / Mac',0);
INSERT INTO topics VALUES (6,'beos','beos.gif','BeOS',0);
INSERT INTO topics VALUES (7,'compaq','compaq.gif','Compaq',0);
INSERT INTO topics VALUES (8,'corel','corel.gif','Corel',0);
INSERT INTO topics VALUES (9,'debian','debian.gif','Debian',0);
INSERT INTO topics VALUES (10,'phpnuke','phpnuke.gif','PHP-Nuke',0);
INSERT INTO topics VALUES (11,'freebsd','freebsd.gif','FreeBSD',0);
INSERT INTO topics VALUES (12,'gimp','gimp.gif','GIMP',0);
INSERT INTO topics VALUES (13,'gnome','gnome.gif','GNOME',0);
INSERT INTO topics VALUES (14,'gnu','gnu.jpg','GNU / GPL',0);
INSERT INTO topics VALUES (15,'hp','hp.gif','Hewlett Packard',0);
INSERT INTO topics VALUES (16,'ibm','ibm.gif','IBM',0);
INSERT INTO topics VALUES (17,'intel','intel.gif','Intel',0);
INSERT INTO topics VALUES (18,'java','java.gif','Java',0);
INSERT INTO topics VALUES (19,'kde','kde.gif','KDE',0);
INSERT INTO topics VALUES (20,'mandrake','mandrake.gif','Mandrake',0);
INSERT INTO topics VALUES (21,'microsoft','microsoft.gif','Microsoft',0);
INSERT INTO topics VALUES (22,'mozilla','mozilla.gif','Mozilla',0);
INSERT INTO topics VALUES (23,'netscape','netscape.gif','Netscape',0);
INSERT INTO topics VALUES (24,'perl','perl.gif','Perl',0);
INSERT INTO topics VALUES (25,'redhat','redhat.gif','Red Hat',0);
INSERT INTO topics VALUES (26,'sgi','sgi.gif','Silicon Graphics',0);
INSERT INTO topics VALUES (27,'sun','sun.gif','Sun Microsystems',0);
INSERT INTO topics VALUES (28,'suse','suse.gif','SuSE',0);
INSERT INTO topics VALUES (29,'x','x.jpg','X Window',0);


CREATE TABLE users (
  uid int(11) NOT NULL auto_increment,
  name varchar(60) DEFAULT '' NOT NULL,
  uname varchar(25) DEFAULT '' NOT NULL,
  email varchar(60) DEFAULT '' NOT NULL,
  femail varchar(60) DEFAULT '' NOT NULL,
  url varchar(100) DEFAULT '' NOT NULL,
  pass varchar(40) DEFAULT '' NOT NULL,
  storynum tinyint(4) DEFAULT '10' NOT NULL,
  umode varchar(10) DEFAULT '' NOT NULL,
  uorder tinyint(1) DEFAULT '0' NOT NULL,
  thold tinyint(1) DEFAULT '0' NOT NULL,
  noscore tinyint(1) DEFAULT '0' NOT NULL,
  bio tinytext DEFAULT '' NOT NULL,
  ublockon tinyint(1) DEFAULT '0' NOT NULL,
  ublock tinytext DEFAULT '' NOT NULL,
  theme varchar(255) DEFAULT '' NOT NULL,
  commentmax int(11) DEFAULT '4096' NOT NULL,
  counter int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (uid)
);

