-- MySQL dump 9.10
--
-- Host: localhost    Database: mpn1888rc22
-- ------------------------------------------------------
-- Server version	4.0.18-nt

--
-- Table structure for table `mpn_4nstats_datecnt`
--

CREATE TABLE mpn_4nstats_datecnt (
  date varchar(8) NOT NULL default '',
  hits tinyint(2) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='Statistics module: count per date';

--
-- Dumping data for table `mpn_4nstats_datecnt`
--


--
-- Table structure for table `mpn_4nstats_hourcnt`
--

CREATE TABLE mpn_4nstats_hourcnt (
  hour tinyint(2) unsigned NOT NULL default '0',
  hits int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='Statistics module: count per hour';

--
-- Dumping data for table `mpn_4nstats_hourcnt`
--

INSERT INTO mpn_4nstats_hourcnt VALUES (0,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (1,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (2,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (3,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (4,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (5,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (6,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (7,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (8,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (9,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (10,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (11,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (12,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (13,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (14,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (15,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (16,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (17,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (18,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (19,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (20,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (21,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (22,0);
INSERT INTO mpn_4nstats_hourcnt VALUES (23,0);

--
-- Table structure for table `mpn_4nstats_monthcnt`
--

CREATE TABLE mpn_4nstats_monthcnt (
  month tinyint(2) unsigned NOT NULL default '0',
  hits int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='Statistics module: count per month';

--
-- Dumping data for table `mpn_4nstats_monthcnt`
--

INSERT INTO mpn_4nstats_monthcnt VALUES (1,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (2,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (3,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (4,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (5,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (6,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (7,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (8,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (9,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (10,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (11,0);
INSERT INTO mpn_4nstats_monthcnt VALUES (12,0);

--
-- Table structure for table `mpn_4nstats_weekcnt`
--

CREATE TABLE mpn_4nstats_weekcnt (
  weekday tinyint(1) unsigned NOT NULL default '0',
  hits int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='Statistics module: count per week';

--
-- Dumping data for table `mpn_4nstats_weekcnt`
--

INSERT INTO mpn_4nstats_weekcnt VALUES (0,0);
INSERT INTO mpn_4nstats_weekcnt VALUES (1,0);
INSERT INTO mpn_4nstats_weekcnt VALUES (2,0);
INSERT INTO mpn_4nstats_weekcnt VALUES (3,0);
INSERT INTO mpn_4nstats_weekcnt VALUES (4,0);
INSERT INTO mpn_4nstats_weekcnt VALUES (5,0);
INSERT INTO mpn_4nstats_weekcnt VALUES (6,0);

--
-- Table structure for table `mpn_access`
--

CREATE TABLE mpn_access (
  access_id tinyint(2) NOT NULL auto_increment,
  access_title varchar(20) default NULL,
  PRIMARY KEY  (access_id)
) TYPE=MyISAM COMMENT='Forum module: access titles';

--
-- Dumping data for table `mpn_access`
--

INSERT INTO mpn_access VALUES (1,'User');
INSERT INTO mpn_access VALUES (2,'Moderator');
INSERT INTO mpn_access VALUES (3,'Super Moderator');
INSERT INTO mpn_access VALUES (4,'Author');
INSERT INTO mpn_access VALUES (5,'Webmaster');

--
-- Table structure for table `mpn_authors`
--

CREATE TABLE mpn_authors (
  aid varchar(30) NOT NULL default '',
  name varchar(50) default NULL,
  url varchar(60) default NULL,
  email varchar(60) default NULL,
  pwd varchar(40) default NULL,
  counter int(11) NOT NULL default '0',
  radminarticle tinyint(2) NOT NULL default '0',
  radmintopic tinyint(2) NOT NULL default '0',
  radminleft tinyint(2) NOT NULL default '0',
  radminright tinyint(2) NOT NULL default '0',
  radminuser tinyint(2) NOT NULL default '0',
  radminmain tinyint(2) NOT NULL default '0',
  radminsurvey tinyint(2) NOT NULL default '0',
  radminsection tinyint(2) NOT NULL default '0',
  radminlink tinyint(2) NOT NULL default '0',
  radminephem tinyint(2) NOT NULL default '0',
  radminhead tinyint(2) NOT NULL default '0',
  radminfaq tinyint(2) NOT NULL default '0',
  radmindownload tinyint(2) NOT NULL default '0',
  radminforum tinyint(2) NOT NULL default '0',
  radminreviews tinyint(2) NOT NULL default '0',
  radminguestbook tinyint(2) NOT NULL default '0',
  radminpartner tinyint(2) NOT NULL default '0',
  radminmpn tinyint(2) NOT NULL default '0',
  radminsuper tinyint(2) NOT NULL default '1',
  uid int(11) NOT NULL default '0',
  PRIMARY KEY  (aid),
  KEY idxauthorscounterdesc (counter)
) TYPE=MyISAM COMMENT='Core system: admins and authors';

--
-- Dumping data for table `mpn_authors`
--

INSERT INTO mpn_authors VALUES ('God','God','','none@none.com','dc647eb65e6711e155375218212b3964',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,-1);

--
-- Table structure for table `mpn_autonews`
--

CREATE TABLE mpn_autonews (
  anid int(11) NOT NULL auto_increment,
  catid int(11) NOT NULL default '0',
  aid varchar(30) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  time varchar(19) NOT NULL default '',
  hometext text NOT NULL,
  bodytext text NOT NULL,
  topic int(3) NOT NULL default '1',
  informant varchar(25) NOT NULL default '',
  notes text NOT NULL,
  ihome int(1) NOT NULL default '0',
  PRIMARY KEY  (anid),
  KEY idxautonewstimedesc (time)
) TYPE=MyISAM COMMENT='Core system: automated news items';

--
-- Dumping data for table `mpn_autonews`
--


--
-- Table structure for table `mpn_banner`
--

CREATE TABLE mpn_banner (
  bid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  imptotal int(11) NOT NULL default '0',
  impmade int(11) NOT NULL default '0',
  clicks int(11) NOT NULL default '0',
  imageurl varchar(255) NOT NULL default '',
  clickurl varchar(255) NOT NULL default '',
  date datetime default NULL,
  PRIMARY KEY  (bid),
  KEY idxbannercid (cid),
  KEY idxbannerbidcid (bid,cid)
) TYPE=MyISAM COMMENT='Banner module: banner details';

--
-- Dumping data for table `mpn_banner`
--


--
-- Table structure for table `mpn_bannerclient`
--

CREATE TABLE mpn_bannerclient (
  cid int(11) NOT NULL auto_increment,
  name varchar(60) NOT NULL default '',
  contact varchar(60) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  login varchar(10) NOT NULL default '',
  passwd varchar(10) NOT NULL default '',
  extrainfo text NOT NULL,
  PRIMARY KEY  (cid),
  KEY idxbannerclientlogin (login)
) TYPE=MyISAM COMMENT='Banner module: customer details';

--
-- Dumping data for table `mpn_bannerclient`
--


--
-- Table structure for table `mpn_bannerfinish`
--

CREATE TABLE mpn_bannerfinish (
  bid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  impressions int(11) NOT NULL default '0',
  clicks int(11) NOT NULL default '0',
  datestart datetime default NULL,
  dateend datetime default NULL,
  PRIMARY KEY  (bid),
  KEY idxbannerfinishcid (cid)
) TYPE=MyISAM COMMENT='Banner module: finished banners';

--
-- Dumping data for table `mpn_bannerfinish`
--


--
-- Table structure for table `mpn_blocks`
--

CREATE TABLE mpn_blocks (
  bid int(10) unsigned NOT NULL auto_increment,
  side tinyint(1) NOT NULL default '0',
  weight int(10) NOT NULL default '0',
  admin tinyint(1) NOT NULL default '0',
  position tinyint(1) NOT NULL default '0',
  visible tinyint(1) NOT NULL default '0',
  special int(10) NOT NULL default '0',
  title varchar(60) NOT NULL default '',
  content text NOT NULL,
  category tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (bid)
) TYPE=MyISAM COMMENT='Core system: side blocks definitions';

--
-- Dumping data for table `mpn_blocks`
--

INSERT INTO mpn_blocks VALUES (1,0,1,0,0,1,1,'','',0);
INSERT INTO mpn_blocks VALUES (2,0,2,2,0,1,0,'Administration','<li><a href=\'admin.php\'>Administration</a><li><a href=\'admin.php?op=logout\'>Logout</a>',2);
INSERT INTO mpn_blocks VALUES (3,0,3,2,0,1,12,'','',0);
INSERT INTO mpn_blocks VALUES (4,0,4,0,0,1,0,'Main Menu','<li><a href=\'index.php\'><b>Home</b></a>\n        <li><a href=\'topics.php\'>Topics</a>\n        <li><a href=\'sections.php\'>Sections</a>\n        <li><a href=\'reviews.php\'>Reviews</a>\n        <li><a href=\'myyp.php\'>myYellow Pages</a>\n        <li><a href=\'links.php\'>Web Links</a>\n        <li><a href=\'download.php\'>Downloads</a>\n        <li><a href=\'myegallery.php\'>eGallery</a>\n        <li><a href=\'forum.php\'>Forums</a>\n        <li><a href=\'submit.php\'><b>Submit News</b></a>\n        <li><a href=\'eventcal.php\'>Events Calender</a>\n        <li><a href=\'guestbook.php\'>Guestbook</a>\n        <li><a href=\'user.php?op=logout\'>Logout</a>\n\n        <li><a href=\'user.php\'><b>View Account</b></a>\n        <li><a href=\'user.php?op=register\'>Register</a>\n        <li><a href=\'friend.php\'>Recommend Us</a>\n        <li><a href=\'memberslist.php\'>Members List</a>\n        <li><a href=\'stats.php\'>Stats</a>\n        <li><a href=\'top.php\'>Top 10</a>\n        <li><a href=\'updatelog.php\'>System Updatelog</a>\n        <li><a href=\'contact.php\'>Contact Us</a>\n        <li><a href=\'archive.php\'>News Archive</a>\n        <li><a href=\'allstories.php\'>All Stories</a>\n        <li><a href=\'mailbox.php\'>Email</a>\n        <li><a href=\'npp_ODP.php?enpp=odp\'>Open Directory</a>',0);
INSERT INTO mpn_blocks VALUES (5,0,5,0,0,1,2,'','',0);
INSERT INTO mpn_blocks VALUES (6,0,6,0,0,1,13,'','',0);
INSERT INTO mpn_blocks VALUES (7,0,7,0,0,1,0,'First Left Block','You can add/remove/edit blocks for your site with myPHPNuke.\n                You can also add HTML commands like <a href=\'http://www.myphpnuke.com/\'>links</a>, <b>Bold</b> text, images, etc.\n                Just use you imagination.',3);
INSERT INTO mpn_blocks VALUES (8,0,8,0,0,1,0,'Special Sections','What about a <a href=\'sections.php\'>Special Sections</a> option in the myPHPNuke code? A place to publish reviews, special articles, interviews, or whatever, independent of the main news.',3);
INSERT INTO mpn_blocks VALUES (9,0,1,0,0,0,14,'','',0);
INSERT INTO mpn_blocks VALUES (10,0,2,0,0,0,16,'','',0);
INSERT INTO mpn_blocks VALUES (11,1,3,0,0,1,3,'','',0);
INSERT INTO mpn_blocks VALUES (12,1,4,0,0,1,4,'','',0);
INSERT INTO mpn_blocks VALUES (13,1,5,0,0,1,5,'','',0);
INSERT INTO mpn_blocks VALUES (14,1,6,0,0,1,6,'','',0);
INSERT INTO mpn_blocks VALUES (15,1,7,0,0,1,7,'','',0);
INSERT INTO mpn_blocks VALUES (16,1,8,0,0,1,8,'','',0);
INSERT INTO mpn_blocks VALUES (17,1,9,0,0,1,0,'First Right Block','You can add/remove/edit blocks for your site with myPHPNuke.\n                You can also add HTML commands like <a href=\'http://www.myphpnuke.com/\'>links</a>, <b>Bold</b> text, images, etc.\n                Just use you imagination.',4);
INSERT INTO mpn_blocks VALUES (18,1,10,0,0,0,0,'Information','',0);
INSERT INTO mpn_blocks VALUES (19,1,11,0,0,1,9,'','',0);
INSERT INTO mpn_blocks VALUES (20,1,12,0,0,0,10,'','',0);
INSERT INTO mpn_blocks VALUES (21,1,13,0,0,1,11,'','',0);
INSERT INTO mpn_blocks VALUES (22,1,14,0,0,0,15,'','',0);
INSERT INTO mpn_blocks VALUES (23,1,15,0,0,0,17,'','',0);
INSERT INTO mpn_blocks VALUES (24,0,0,0,0,1,19,'','',0);
INSERT INTO mpn_blocks VALUES (26,1,2,1,0,1,0,'Your messenger','<li><a href=\'mailbox.php\'>Your Mailbox</a>\n        <li><a href=\'contactbook.php\'>Your Addressbook</a>\n        <li><a href=\'settings.php\'>Your Settings</a>\n        <li><a href=\'compose.php\'>Compose</a>\n        <li><a href=\'emailhelp.php\'>Help </a>\n\n        <li><a href=\'viewpmsg.php\'>Private Messages</a>\n        ',5);
INSERT INTO mpn_blocks VALUES (28,1,0,1,1,1,0,'Your personal page','<li><a href=\'user.php?op=edituser\'>Your Profile</a>\n        <li><a href=\'user.php?op=edithome\'>Your Menu</a>\n        <li><a href=\'user.php?op=editcomm\'>Your Comments </a>\n        <li><a href=\'user.php?op=chgtheme\'>Your Theme </a>\n        <li><a href=\'user.php?op=logout\'>Logout</a>\n\n        <li><a href=calendar.php>Your Calender</a>',5);

--
-- Table structure for table `mpn_categories`
--

CREATE TABLE mpn_categories (
  cat_id int(10) NOT NULL auto_increment,
  cat_title varchar(100) default NULL,
  PRIMARY KEY  (cat_id)
) TYPE=MyISAM COMMENT='Core system: news categories';

--
-- Dumping data for table `mpn_categories`
--

INSERT INTO mpn_categories VALUES (1,'General');

--
-- Table structure for table `mpn_chatboxii`
--

CREATE TABLE mpn_chatboxii (
  username varchar(25) default NULL,
  message varchar(75) default NULL,
  date int(15) default NULL
) TYPE=MyISAM COMMENT='Chat module: chat texts';

--
-- Dumping data for table `mpn_chatboxii`
--


--
-- Table structure for table `mpn_click`
--

CREATE TABLE mpn_click (
  num int(10) NOT NULL auto_increment,
  hits int(10) NOT NULL default '0',
  url varchar(100) NOT NULL default '',
  image varchar(100) NOT NULL default '',
  text text NOT NULL,
  PRIMARY KEY  (num),
  UNIQUE KEY num (num)
) TYPE=MyISAM COMMENT='Banners module: number of clicks per URL';

--
-- Dumping data for table `mpn_click`
--


--
-- Table structure for table `mpn_comments`
--

CREATE TABLE mpn_comments (
  tid int(11) NOT NULL auto_increment,
  pid int(11) default '0',
  sid int(11) default '0',
  date datetime default NULL,
  name varchar(60) NOT NULL default '',
  email varchar(60) default NULL,
  url varchar(255) default NULL,
  host_name varchar(60) default NULL,
  subject varchar(85) NOT NULL default '',
  comment text NOT NULL,
  score tinyint(4) NOT NULL default '0',
  reason tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY idxcommentspid (pid),
  KEY idxcommentsdatedesc (date),
  KEY idxcommentssid (sid),
  KEY idxcommentsdatetidpid (date,tid,pid),
  KEY idxcommentssidpid (sid,pid),
  KEY idxcommentstidsid (tid,sid),
  KEY idxcommentstiddescname (tid,name),
  KEY idxcommentsscorename (score,name),
  KEY idxcommentsscorehostname (score,host_name),
  KEY idxcommentspidsidsubject (pid,sid,subject)
) TYPE=MyISAM COMMENT='News module: comments on news items';

--
-- Dumping data for table `mpn_comments`
--

INSERT INTO mpn_comments VALUES (1,0,1,'2004-01-01 12:00:00','','','','150.10.10.10','Re: Welcome to myPHPNuke 1.8.8','FIRST COMMENT!\n        <br>\n\n        <br>\n        All my life I wanted to do this ;)',0,0);

--
-- Table structure for table `mpn_contactbook`
--

CREATE TABLE mpn_contactbook (
  uid int(11) default NULL,
  contactid int(11) NOT NULL auto_increment,
  firstname varchar(50) default NULL,
  lastname varchar(50) default NULL,
  email varchar(255) default NULL,
  company varchar(255) default NULL,
  homeaddress varchar(255) default NULL,
  city varchar(80) default NULL,
  homephone varchar(255) default NULL,
  workphone varchar(255) default NULL,
  homepage varchar(255) default NULL,
  IM varchar(255) default NULL,
  events text,
  reminders int(11) default NULL,
  notes text,
  PRIMARY KEY  (contactid)
) TYPE=MyISAM COMMENT='Webmail module: addressbook';

--
-- Dumping data for table `mpn_contactbook`
--


--
-- Table structure for table `mpn_counter`
--

CREATE TABLE mpn_counter (
  type varchar(80) NOT NULL default '',
  var varchar(80) NOT NULL default '',
  count int(10) unsigned NOT NULL default '0',
  KEY idxcountertypedesc (type)
) TYPE=MyISAM COMMENT='Statistics module: count pageviews per browser type';

--
-- Dumping data for table `mpn_counter`
--

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

--
-- Table structure for table `mpn_downloads_categories`
--

CREATE TABLE mpn_downloads_categories (
  cid int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  cdescription text NOT NULL,
  PRIMARY KEY  (cid)
) TYPE=MyISAM COMMENT='Downloads module: categories';

--
-- Dumping data for table `mpn_downloads_categories`
--


--
-- Table structure for table `mpn_downloads_downloads`
--

CREATE TABLE mpn_downloads_downloads (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  description text NOT NULL,
  date datetime default NULL,
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  hits int(11) NOT NULL default '0',
  submitter varchar(25) NOT NULL default '',
  downloadratingsummary double(6,4) NOT NULL default '0.0000',
  totalvotes int(11) NOT NULL default '0',
  totalcomments int(11) NOT NULL default '0',
  filesize int(11) NOT NULL default '0',
  version varchar(25) NOT NULL default '',
  homepage varchar(255) NOT NULL default '',
  PRIMARY KEY  (lid)
) TYPE=MyISAM COMMENT='Downloads module: download details';

--
-- Dumping data for table `mpn_downloads_downloads`
--


--
-- Table structure for table `mpn_downloads_editorials`
--

CREATE TABLE mpn_downloads_editorials (
  downloadid int(11) NOT NULL default '0',
  adminid varchar(30) NOT NULL default '',
  editorialtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  editorialtext text NOT NULL,
  editorialtitle varchar(100) NOT NULL default '',
  PRIMARY KEY  (downloadid)
) TYPE=MyISAM COMMENT='Downloads module: editorial details';

--
-- Dumping data for table `mpn_downloads_editorials`
--


--
-- Table structure for table `mpn_downloads_modrequest`
--

CREATE TABLE mpn_downloads_modrequest (
  requestid int(11) NOT NULL auto_increment,
  lid int(11) NOT NULL default '0',
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  description text NOT NULL,
  modifysubmitter varchar(25) NOT NULL default '',
  brokendownload int(3) NOT NULL default '0',
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  filesize int(11) NOT NULL default '0',
  version varchar(25) NOT NULL default '',
  homepage varchar(255) NOT NULL default '',
  PRIMARY KEY  (requestid),
  UNIQUE KEY requestid (requestid)
) TYPE=MyISAM COMMENT='Downloads module: modifcation requests';

--
-- Dumping data for table `mpn_downloads_modrequest`
--


--
-- Table structure for table `mpn_downloads_newdownload`
--

CREATE TABLE mpn_downloads_newdownload (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  description text NOT NULL,
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  submitter varchar(25) NOT NULL default '',
  filesize int(11) NOT NULL default '0',
  version varchar(25) NOT NULL default '',
  homepage varchar(255) NOT NULL default '',
  PRIMARY KEY  (lid)
) TYPE=MyISAM COMMENT='Downloads module: new submitted, not yet approved downloads';

--
-- Dumping data for table `mpn_downloads_newdownload`
--


--
-- Table structure for table `mpn_downloads_subcategories`
--

CREATE TABLE mpn_downloads_subcategories (
  sid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM COMMENT='Downloads module: subcategories';

--
-- Dumping data for table `mpn_downloads_subcategories`
--


--
-- Table structure for table `mpn_downloads_votedata`
--

CREATE TABLE mpn_downloads_votedata (
  ratingdbid int(11) NOT NULL auto_increment,
  ratinglid int(11) NOT NULL default '0',
  ratinguser varchar(25) NOT NULL default '',
  rating int(11) NOT NULL default '0',
  ratinghostname varchar(60) NOT NULL default '',
  ratingcomments text NOT NULL,
  ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ratingdbid)
) TYPE=MyISAM COMMENT='Downloads module: voting details';

--
-- Dumping data for table `mpn_downloads_votedata`
--


--
-- Table structure for table `mpn_ephem`
--

CREATE TABLE mpn_ephem (
  eid int(11) NOT NULL auto_increment,
  did int(2) NOT NULL default '0',
  mid int(2) NOT NULL default '0',
  yid int(4) NOT NULL default '0',
  content text NOT NULL,
  PRIMARY KEY  (eid),
  KEY idxephemdidmid (did,mid)
) TYPE=MyISAM COMMENT='Ephemerids module: ephemerids details';

--
-- Dumping data for table `mpn_ephem`
--


--
-- Table structure for table `mpn_eventcal`
--

CREATE TABLE mpn_eventcal (
  id int(6) NOT NULL auto_increment,
  date_from date NOT NULL default '0000-00-00',
  date_to date NOT NULL default '0000-00-00',
  eventname varchar(255) NOT NULL default '',
  eventdesc text NOT NULL,
  uid int(11) NOT NULL default '0',
  eventgo int(2) NOT NULL default '0',
  eventmail varchar(255) NOT NULL default '',
  eventweb varchar(255) NOT NULL default '',
  eventname1 varchar(255) NOT NULL default '',
  eventcatid int(6) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Event calendar module: calendar details';

--
-- Dumping data for table `mpn_eventcal`
--


--
-- Table structure for table `mpn_faqanswer`
--

CREATE TABLE mpn_faqanswer (
  id tinyint(4) NOT NULL auto_increment,
  id_cat tinyint(4) default NULL,
  question varchar(255) default NULL,
  answer text,
  PRIMARY KEY  (id),
  KEY idxfaqansweridcat (id_cat),
  KEY idxfaqanswerididcat (id,id_cat)
) TYPE=MyISAM COMMENT='FAQ module: questions and answers';

--
-- Dumping data for table `mpn_faqanswer`
--


--
-- Table structure for table `mpn_faqcategories`
--

CREATE TABLE mpn_faqcategories (
  id_cat tinyint(3) NOT NULL auto_increment,
  categories varchar(255) default NULL,
  PRIMARY KEY  (id_cat)
) TYPE=MyISAM COMMENT='FAQ module: categories';

--
-- Dumping data for table `mpn_faqcategories`
--


--
-- Table structure for table `mpn_forumconfig`
--

CREATE TABLE mpn_forumconfig (
  allow_html int(2) default NULL,
  allow_bbcode int(2) default NULL,
  allow_sig int(2) default NULL,
  posts_per_page int(10) default NULL,
  hot_threshold int(10) default NULL,
  topics_per_page int(10) default NULL
) TYPE=MyISAM COMMENT='Forum module: configuration details';

--
-- Dumping data for table `mpn_forumconfig`
--

INSERT INTO mpn_forumconfig VALUES (0,1,1,10,10,10);

--
-- Table structure for table `mpn_forummods`
--

CREATE TABLE mpn_forummods (
  forum_id int(10) NOT NULL default '0',
  user_id int(10) NOT NULL default '0'
) TYPE=MyISAM COMMENT='Forum module: moderators per forum';

--
-- Dumping data for table `mpn_forummods`
--


--
-- Table structure for table `mpn_forums`
--

CREATE TABLE mpn_forums (
  forum_id int(10) NOT NULL auto_increment,
  forum_name varchar(150) default NULL,
  forum_desc text,
  forum_access tinyint(1) default '1',
  forum_moderator int(10) default NULL,
  cat_id int(10) default NULL,
  forum_type tinyint(1) default '0',
  forum_pass varchar(60) default NULL,
  PRIMARY KEY  (forum_id),
  KEY idxforumscatid (cat_id),
  KEY idxforums (forum_id,cat_id,forum_type,forum_access)
) TYPE=MyISAM COMMENT='Forum module: forum descriptions';

--
-- Dumping data for table `mpn_forums`
--

INSERT INTO mpn_forums VALUES (1,'Test Forum','This is for testing',0,1,1,0,'');

--
-- Table structure for table `mpn_forumtopics`
--

CREATE TABLE mpn_forumtopics (
  topic_id int(10) NOT NULL auto_increment,
  topic_title varchar(100) default NULL,
  topic_poster int(10) default NULL,
  topic_time varchar(20) default NULL,
  topic_views int(10) NOT NULL default '0',
  forum_id int(10) default NULL,
  topic_status tinyint(1) NOT NULL default '0',
  topic_notify int(2) default '0',
  PRIMARY KEY  (topic_id),
  KEY forum_id (forum_id),
  KEY idxtopics (topic_id,topic_views,topic_poster),
  KEY idxtitletime (forum_id,topic_title,topic_time)
) TYPE=MyISAM COMMENT='Forum module: topics (new threads)';

--
-- Dumping data for table `mpn_forumtopics`
--


--
-- Table structure for table `mpn_gallery_categories`
--

CREATE TABLE mpn_gallery_categories (
  gallid int(3) NOT NULL auto_increment,
  gallname varchar(30) NOT NULL default '',
  gallimg varchar(50) NOT NULL default '',
  galloc longtext,
  description text NOT NULL,
  parent int(3) NOT NULL default '-1',
  visible tinyint(3) unsigned NOT NULL default '0',
  template int(10) unsigned NOT NULL default '2',
  numcol tinyint(3) unsigned NOT NULL default '3',
  total int(10) unsigned NOT NULL default '0',
  lastadd date NOT NULL default '0000-00-00',
  PRIMARY KEY  (gallid),
  KEY gallid (gallid)
) TYPE=MyISAM COMMENT='Gallery module: categories';

--
-- Dumping data for table `mpn_gallery_categories`
--

INSERT INTO mpn_gallery_categories VALUES (1,'Art','gallery.gif','Art','Art Pictures',-1,2,2,2,6,'0000-00-00');

--
-- Table structure for table `mpn_gallery_comments`
--

CREATE TABLE mpn_gallery_comments (
  cid int(10) unsigned NOT NULL auto_increment,
  pid int(10) unsigned NOT NULL default '0',
  comment varchar(255) NOT NULL default '',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  name varchar(255) default NULL,
  member tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (cid)
) TYPE=MyISAM COMMENT='Gallery module: comments';

--
-- Dumping data for table `mpn_gallery_comments`
--


--
-- Table structure for table `mpn_gallery_media_class`
--

CREATE TABLE mpn_gallery_media_class (
  id int(2) NOT NULL default '0',
  class varchar(10) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM COMMENT='Gallery module: media class definitions';

--
-- Dumping data for table `mpn_gallery_media_class`
--

INSERT INTO mpn_gallery_media_class VALUES (1,'Image');
INSERT INTO mpn_gallery_media_class VALUES (2,'Audio');
INSERT INTO mpn_gallery_media_class VALUES (3,'Video');

--
-- Table structure for table `mpn_gallery_media_types`
--

CREATE TABLE mpn_gallery_media_types (
  extension varchar(10) NOT NULL default '',
  description text NOT NULL,
  filetype varchar(10) NOT NULL default '',
  displaytag text NOT NULL,
  thumbnail varchar(255) NOT NULL default '',
  PRIMARY KEY  (extension)
) TYPE=MyISAM COMMENT='Gallery module: media types';

--
-- Dumping data for table `mpn_gallery_media_types`
--

INSERT INTO mpn_gallery_media_types VALUES ('gif','Image/GIF','1','<img src=\":FNAME:\" border=\"0\" width=\":WIDTH:\" height=\":HEIGHT:\" alt=\":DESCRIP:\" />','image_gif.gif');
INSERT INTO mpn_gallery_media_types VALUES ('jpg','Image/JPG','1','<img src=\":FNAME:\" border=\"0\" width=\":WIDTH:\" height=\":HEIGHT:\" alt=\":DESCRIP:\" />','image_jpg.gif');
INSERT INTO mpn_gallery_media_types VALUES ('png','Image/PNG','1','<img src=\":FNAME:\" border=\"0\" width=\":WIDTH:\" height=\":HEIGHT:\" alt=\":DESCRIP:\" />','image_png.gif');
INSERT INTO mpn_gallery_media_types VALUES ('mov','Video/Quicktime','3','<embed controller=\"true\" width=\":WIDTH:\" height=\":HEIGHT:\" src=\":FNAME:\" border=\"0\" pluginspage=\"http://www.apple.com/quicktime/download/indext.html\"></embed>','video_mov.gif');
INSERT INTO mpn_gallery_media_types VALUES ('avi','Video/AVI','3','<embed src=\":FNAME:\" border=\"0\" width=\":WIDTH:\" height=\":HEIGHT:\" type=\"application/x-mplayer2\"></embed>','video_avi.gif');
INSERT INTO mpn_gallery_media_types VALUES ('mpg','Video/MPEG','3','<embed src=\":FNAME:\" border=\"0\" width=\":WIDTH:\" height=\":HEIGHT:\" type=\"application/x-mplayer2\"></embed>','video_mpg.gif');
INSERT INTO mpn_gallery_media_types VALUES ('mp3','Audio/MP3','2','<embed controller=\"true\" width=\"200\" height=\"20\" src=\":FNAME:\" border=\"0\" pluginspage=\"http://www.apple.com/quicktime/download/indext.html\"></embed>','audio_mp3.gif');
INSERT INTO mpn_gallery_media_types VALUES ('mid','Audio/MIDI','2','<embed src=\":FNAME:\" type=\"audio/midi\" hidden=\"false\" autostart=\"true\" loop=\"true\" height=\"20\" width=\"200\"></embed>','audio_mid.gif');
INSERT INTO mpn_gallery_media_types VALUES ('swf','Video/Flash','3','<embed src=\":FNAME:\" pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\" type=\"application/x-shockwave-flash\" width=\":WIDTH:\" height=\":HEIGHT:\" play=\"true\" loop=\"true\" quality=\"high\" scale=\"showall\" menu=\"true\"></embed>','video_swf.gif');
INSERT INTO mpn_gallery_media_types VALUES ('rm','Video/RealMedia','3','<OBJECT ID=RAOCX CLASSID=\"clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA\" width=\":WIDTH:\" height=\":HEIGHT:\">\n        <PARAM NAME=\"CONTROLS\" VALUE=\"ImageWindow\">\n        <PARAM NAME=\"AUTOSTART\" Value=\"true\">\n        <PARAM NAME=\"SRC\" VALUE=\":FNAME:\">\n        <embed height=\":HEIGHT:\" width=\":WIDTH:\" controls=\"ImageWindow\" src=\" :FNAME:?embed\" type=\"audio/x-pn-realaudio-plugin\" autostart=\"true\" nolabels=\"0\" autogotourl=\"-1\"></OBJECT>','video_realmedia.gif');

--
-- Table structure for table `mpn_gallery_pictures`
--

CREATE TABLE mpn_gallery_pictures (
  pid int(10) unsigned NOT NULL auto_increment,
  gid int(3) NOT NULL default '0',
  img varchar(255) NOT NULL default '',
  counter int(10) unsigned NOT NULL default '0',
  submitter varchar(25) NOT NULL default 'Webmaster',
  date datetime default NULL,
  name varchar(255) NOT NULL default '',
  description text NOT NULL,
  votes int(10) unsigned NOT NULL default '0',
  rate float NOT NULL default '0',
  extension varchar(10) NOT NULL default 'image',
  width smallint(5) unsigned NOT NULL default '0',
  height smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY pid (pid)
) TYPE=MyISAM COMMENT='Gallery module: media details';

--
-- Dumping data for table `mpn_gallery_pictures`
--

INSERT INTO mpn_gallery_pictures VALUES (1,1,'1.jpg',4,'Webmaster','2001-06-22 15:05:25','1.jpg','1.jpg',0,0,'jpg',413,271);
INSERT INTO mpn_gallery_pictures VALUES (2,1,'2.jpg',3,'Webmaster','2001-06-22 15:05:25','2.jpg','',0,0,'jpg',490,370);
INSERT INTO mpn_gallery_pictures VALUES (3,1,'3.jpg',1,'Webmaster','2001-06-22 15:05:25','3.jpg','',0,0,'jpg',216,216);
INSERT INTO mpn_gallery_pictures VALUES (4,1,'4.jpg',1,'Webmaster','2001-06-22 15:05:25','4.jpg','',0,0,'jpg',230,290);
INSERT INTO mpn_gallery_pictures VALUES (5,1,'5.jpg',2,'Webmaster','2001-06-22 15:05:25','5.jpg','',0,0,'jpg',232,296);
INSERT INTO mpn_gallery_pictures VALUES (6,1,'6.jpg',3,'Webmaster','2001-06-22 15:05:25','6.jpg','',0,0,'jpg',479,370);
INSERT INTO mpn_gallery_pictures VALUES (7,1,'kodred1.swf',3,'Webmaster','2001-06-22 15:05:25','kodred1.swf','',0,0,'swf',320,240);

--
-- Table structure for table `mpn_gallery_pictures_newpicture`
--

CREATE TABLE mpn_gallery_pictures_newpicture (
  pid int(10) unsigned NOT NULL auto_increment,
  gid int(3) NOT NULL default '0',
  img varchar(255) NOT NULL default '',
  counter int(10) unsigned NOT NULL default '0',
  submitter varchar(25) NOT NULL default 'Webmaster',
  date datetime default NULL,
  name varchar(255) NOT NULL default '',
  description text NOT NULL,
  votes int(10) unsigned NOT NULL default '0',
  rate float NOT NULL default '0',
  extension varchar(10) NOT NULL default 'image',
  width smallint(5) unsigned NOT NULL default '0',
  height smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY pid (pid)
) TYPE=MyISAM COMMENT='Gallery module: new submitted media, to be approved';

--
-- Dumping data for table `mpn_gallery_pictures_newpicture`
--


--
-- Table structure for table `mpn_gallery_rate_check`
--

CREATE TABLE mpn_gallery_rate_check (
  ip varchar(20) NOT NULL default '',
  time varchar(14) NOT NULL default '',
  pid int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='Gallery module: store details about a rate submitter';

--
-- Dumping data for table `mpn_gallery_rate_check`
--


--
-- Table structure for table `mpn_gallery_template_types`
--

CREATE TABLE mpn_gallery_template_types (
  id int(10) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  type tinyint(3) unsigned NOT NULL default '2',
  templateCategory longtext NOT NULL,
  templatePictures longtext NOT NULL,
  templateCSS longtext,
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Gallery module: template types';

--
-- Dumping data for table `mpn_gallery_template_types`
--

INSERT INTO mpn_gallery_template_types VALUES (1,'Default Main Page Template',1,'<table align=\"center\">\n        <tr>\n                <td colspan=\"2\">\n                        :GALLNAME:\n                </td>\n        </tr>\n        <tr>\n                <td>\n                        :IMG:\n                </td>\n                <td valign=\"top\" align=\"left\">\n                        :DESCRIP:\n                </td>\n        </tr>\n        </table>','2','.common_text_black {text-color:#000000}\n.common_text_white {text-color:#ffffff}');
INSERT INTO mpn_gallery_template_types VALUES (2,'Default',2,'<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n        <tr>\n\n                <td>\n                        :IMG:\n                </td>\n                <td valign=\"top\">\n                        <table>\n                        <tr>\n                                <td>\n                                        <table>\n                                        <tr>\n                                                <td align=\"center\">\n                                                        :DATE:\n                                                </td>\n                                                <td align=\"center\">\n                                                        :RATE:\n                                                </td>\n                                                <td align=\"center\">\n                                                        :HITS:\n                                                </td>\n                                                <td align=\"center\">\n                                                        :NEW:\n                                                </td>\n                                        </tr>\n                                        </table>\n                                </td>\n                        </tr>\n                        <tr>\n                                <td>\n                                        :DESCRIP:\n                                </td>\n                        </tr>\n                        <tr>\n                                <td>\n                                        :NBCOMM: | :FMAT: | :SIZE:\n                                </td>\n                        </tr>\n                        </table>\n                </td>\n        </tr>\n        </table>','<table width=\"100%\">\n		    <tr>\n		        <td valign=\"top\" align=\"center\" width=\"30%\">\n		            :NAMESIZE:\n		            <br /><br />\n		            <table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\n		            <tr>\n		                <td valign=\"top\">\n		                    :SUBMITTER:\n		                    :DATE:\n		                    :HITS:\n		                    :RATE:\n		                </td>\n		            </tr>\n		            </table><br />\n		            :RATEBAR:\n		        </td>\n		        <td width=\"70%\" align=\"center\">\n		            :IMG:\n		        </td>\n		    </tr>\n		    <tr>\n		        <td colspan=\"2\">:DESCRIP:</td>\n		    </tr>\n		    <tr>\n		        <td colspan=\"2\">\n		            :COMM:\n		        </td>\n		    </tr>\n		</table>\n		','.common_text_black {text-color:#000000}\n.common_text_white {text-color:#ffffff}');

--
-- Table structure for table `mpn_guestbook`
--

CREATE TABLE mpn_guestbook (
  guest_id int(10) NOT NULL auto_increment,
  guest_title varchar(100) default NULL,
  guest_body text NOT NULL,
  guest_poster int(10) default NULL,
  guest_time varchar(20) default NULL,
  guest_views int(10) NOT NULL default '0',
  guest_image varchar(100) default NULL,
  guest_ip varchar(16) default NULL,
  PRIMARY KEY  (guest_id)
) TYPE=MyISAM COMMENT='Guestbook module: submitted details';

--
-- Dumping data for table `mpn_guestbook`
--


--
-- Table structure for table `mpn_headlines`
--

CREATE TABLE mpn_headlines (
  hid int(11) NOT NULL auto_increment,
  sitename varchar(30) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  headlinesurl varchar(255) NOT NULL default '',
  status tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (hid),
  KEY idxheadlinesstatus (status)
) TYPE=MyISAM COMMENT='News module: headline definitions';

--
-- Dumping data for table `mpn_headlines`
--

INSERT INTO mpn_headlines VALUES (1,'myPHPNuke','http://www.myphpnuke.com','http://www.myphpnuke.com/backend.php',1);
INSERT INTO mpn_headlines VALUES (2,'PHP-Nuke','http://www.phpnuke.org','http://www.phpnuke.org/backend.php',0);
INSERT INTO mpn_headlines VALUES (3,'Slashdot','http://slashdot.org','http://slashdot.org/slashdot.rdf',0);
INSERT INTO mpn_headlines VALUES (4,'NewsForge','http://www.newsforge.com','http://www.newsforge.com/newsforge.rdf',0);
INSERT INTO mpn_headlines VALUES (5,'PHPBuilder','http://phpbuilder.com','http://phpbuilder.com/rss_feed.php',0);
INSERT INTO mpn_headlines VALUES (6,'Linux.com','http://linux.com','http://linux.com/mrn/front_page.rss',0);
INSERT INTO mpn_headlines VALUES (7,'Freshmeat','http://freshmeat.net','http://freshmeat.net/backend/fm.rdf',0);
INSERT INTO mpn_headlines VALUES (8,'LinuxWeelyNews','http://lwn.net','http://lwn.net/headlines/rss',0);
INSERT INTO mpn_headlines VALUES (9,'HappyPenguin','http://happypenguin.org','http://happypenguin.org/html/news.rdf',0);
INSERT INTO mpn_headlines VALUES (10,'KDE','http://www.kde.org','http://www.kde.org/dotkdeorg.rdf',0);
INSERT INTO mpn_headlines VALUES (11,'Perl.com','http://www.perl.com','http://www.perl.com/pace/perlnews.rdf',0);
INSERT INTO mpn_headlines VALUES (12,'BrunchingShuttlecocks','http://www.brunching.com','http://www.brunching.com/brunching.rdf',0);
INSERT INTO mpn_headlines VALUES (13,'AbsoluteGames','http://files.gameaholic.com','http://files.gameaholic.com/agfa.rdf',0);
INSERT INTO mpn_headlines VALUES (14,'SciFi-News','http://www.technopagan.org/sf-news/','http://www.technopagan.org/sf-news/rdf.php',0);
INSERT INTO mpn_headlines VALUES (15,'LinuxM68k','http://www.linux-m68k.org','http://www.linux-m68k.org/linux-m68k.rdf',0);
INSERT INTO mpn_headlines VALUES (16,'Protest.net','http://www.protest.net','http://www.protest.net/netcenter_rdf.cgi',0);
INSERT INTO mpn_headlines VALUES (17,'PBSOnline','http://www.pbs.org','http://cgi.pbs.org/cgi-registry/featuresrdf.pl',0);
INSERT INTO mpn_headlines VALUES (18,'Listology','http://www.listology.com','http://listology.com/recent.rdf',0);
INSERT INTO mpn_headlines VALUES (19,'Technocrat','http://www.technocrat.net','http://technocrat.net/rdf',0);
INSERT INTO mpn_headlines VALUES (20,'PDABuzz','http://www.pdabuzz.com','http://www.pdabuzz.com/netscape.txt',0);
INSERT INTO mpn_headlines VALUES (21,'Gnotices','http://news.gnome.org/gnome-news/','http://news.gnome.org/gnome-news/rdf',0);
INSERT INTO mpn_headlines VALUES (22,'DailyDaemonNews','http://daily.daemonnews.org','http://daily.daemonnews.org/ddn.rdf.php3',0);
INSERT INTO mpn_headlines VALUES (23,'PerlMonks','http://www.perlmonks.org','http://www.perlmonks.org/headlines.rdf',0);
INSERT INTO mpn_headlines VALUES (24,'PerlNews','http://news.perl.org','http://news.perl.org/perl-news-short.rdf',0);
INSERT INTO mpn_headlines VALUES (25,'DotKDE','http://dot.kde.org','http://dot.kde.org/rdf',0);
INSERT INTO mpn_headlines VALUES (26,'GeekNik','http://www.geeknik.net','http://www.geeknik.net/backend/weblog.rdf',0);
INSERT INTO mpn_headlines VALUES (27,'HotWired','http://www.hotwired.com','http://www.hotwired.com/webmonkey/meta/headlines.rdf',0);
INSERT INTO mpn_headlines VALUES (28,'LinuxCentral','http://linuxcentral.com','http://linuxcentral.com/backend/lcnew.rdf',0);
INSERT INTO mpn_headlines VALUES (29,'Linux.nu','http://www.linux.nu','http://www.linux.nu/backend.php',0);
INSERT INTO mpn_headlines VALUES (30,'MaximumBSD','http://www.maximumbsd.com','http://www.maximumbsd.com/rss/',0);
INSERT INTO mpn_headlines VALUES (31,'SolarisCentral','http://www.SolarisCentral.org','http://www.SolarisCentral.org/news/SolarisCentral.rdf',0);
INSERT INTO mpn_headlines VALUES (32,'DigitalTheatre','http://www.dtheatre.com','http://www.dtheatre.com/backend.php3?xml=yes',0);
INSERT INTO mpn_headlines VALUES (33,'PlanetX','http://www.planetx.com','http://www.planetx.com/xml.php',0);

--
-- Table structure for table `mpn_image_dirs`
--

CREATE TABLE mpn_image_dirs (
  folder_id tinyint(4) NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  uri varchar(255) default NULL,
  PRIMARY KEY  (folder_id)
) TYPE=MyISAM COMMENT='Core system: pathnames for image directories';

--
-- Dumping data for table `mpn_image_dirs`
--

INSERT INTO mpn_image_dirs VALUES (1,'/',NULL);
INSERT INTO mpn_image_dirs VALUES (2,'admin/',NULL);
INSERT INTO mpn_image_dirs VALUES (3,'articles/',NULL);
INSERT INTO mpn_image_dirs VALUES (4,'banners/',NULL);
INSERT INTO mpn_image_dirs VALUES (5,'calendar/',NULL);
INSERT INTO mpn_image_dirs VALUES (6,'download/',NULL);
INSERT INTO mpn_image_dirs VALUES (7,'flags/',NULL);
INSERT INTO mpn_image_dirs VALUES (8,'forum/',NULL);
INSERT INTO mpn_image_dirs VALUES (9,'forum/avatar/',NULL);
INSERT INTO mpn_image_dirs VALUES (10,'forum/icons/',NULL);
INSERT INTO mpn_image_dirs VALUES (11,'forum/smilies/',NULL);
INSERT INTO mpn_image_dirs VALUES (12,'forum/subject/',NULL);
INSERT INTO mpn_image_dirs VALUES (13,'links/',NULL);
INSERT INTO mpn_image_dirs VALUES (14,'logos/',NULL);
INSERT INTO mpn_image_dirs VALUES (15,'members/',NULL);
INSERT INTO mpn_image_dirs VALUES (16,'menu/',NULL);
INSERT INTO mpn_image_dirs VALUES (17,'myyp/',NULL);
INSERT INTO mpn_image_dirs VALUES (18,'powered/',NULL);
INSERT INTO mpn_image_dirs VALUES (19,'reviews/',NULL);
INSERT INTO mpn_image_dirs VALUES (20,'sections/',NULL);
INSERT INTO mpn_image_dirs VALUES (21,'stats/',NULL);
INSERT INTO mpn_image_dirs VALUES (22,'topics/',NULL);
INSERT INTO mpn_image_dirs VALUES (23,'misc/',NULL);
INSERT INTO mpn_image_dirs VALUES (24,'gallery/',NULL);
INSERT INTO mpn_image_dirs VALUES (25,'gallery/thumbs',NULL);

--
-- Table structure for table `mpn_lastseen`
--

CREATE TABLE mpn_lastseen (
  id int(15) NOT NULL auto_increment,
  username varchar(25) NOT NULL default '',
  date int(15) NOT NULL default '0',
  ip varchar(20) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY idxlastseenusername (username),
  KEY idxlastseendatedesc (date)
) TYPE=MyISAM COMMENT='Core system: details about recent online users';

--
-- Dumping data for table `mpn_lastseen`
--


--
-- Table structure for table `mpn_links_categories`
--

CREATE TABLE mpn_links_categories (
  cid int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  cdescription text NOT NULL,
  PRIMARY KEY  (cid),
  KEY idxlinkscategoriestitle (title)
) TYPE=MyISAM COMMENT='Links module: categories';

--
-- Dumping data for table `mpn_links_categories`
--


--
-- Table structure for table `mpn_links_editorials`
--

CREATE TABLE mpn_links_editorials (
  linkid int(11) NOT NULL default '0',
  adminid varchar(30) NOT NULL default '',
  editorialtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  editorialtext text NOT NULL,
  editorialtitle varchar(100) NOT NULL default '',
  PRIMARY KEY  (linkid)
) TYPE=MyISAM COMMENT='Links module: editorial details';

--
-- Dumping data for table `mpn_links_editorials`
--


--
-- Table structure for table `mpn_links_links`
--

CREATE TABLE mpn_links_links (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  description text NOT NULL,
  date datetime default NULL,
  name varchar(60) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  hits int(11) NOT NULL default '0',
  submitter varchar(25) NOT NULL default '',
  linkratingsummary double(6,4) NOT NULL default '0.0000',
  totalvotes int(11) NOT NULL default '0',
  totalcomments int(11) NOT NULL default '0',
  PRIMARY KEY  (lid),
  KEY idxlinkslinkscid (cid),
  KEY idxlinkslinkstitle (title),
  KEY idxlinkslinkstitlecid (title,cid),
  KEY idxlinkslinkstitlesid (title,sid),
  KEY idxlinkslinksurl (url),
  KEY idxlinkslinkssid (sid),
  KEY idxlinkslinksdate (date),
  KEY idxlinkslinksdatedesccid (date,cid),
  KEY idxlinkslinkstitledate (title,date),
  KEY idxlinkslinkslinkratingsummary (linkratingsummary),
  KEY idxlinklinkslinkratingsummarydesclinkratingsummarytotalvotes (linkratingsummary,linkratingsummary,totalvotes),
  KEY idxlinkslinkshitsdesc (hits)
) TYPE=MyISAM COMMENT='Links module: link details';

--
-- Dumping data for table `mpn_links_links`
--


--
-- Table structure for table `mpn_links_modrequest`
--

CREATE TABLE mpn_links_modrequest (
  requestid int(11) NOT NULL auto_increment,
  lid int(11) NOT NULL default '0',
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  description text NOT NULL,
  modifysubmitter varchar(25) NOT NULL default '',
  brokenlink int(3) NOT NULL default '0',
  PRIMARY KEY  (requestid),
  UNIQUE KEY requestid (requestid),
  KEY idxlinksmodequestbrokenlink (brokenlink),
  KEY idxlinksmodrequestrequestidbrokenlink (requestid,brokenlink)
) TYPE=MyISAM COMMENT='Links module: modification requests';

--
-- Dumping data for table `mpn_links_modrequest`
--


--
-- Table structure for table `mpn_links_newlink`
--

CREATE TABLE mpn_links_newlink (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  description text NOT NULL,
  name varchar(60) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  submitter varchar(25) NOT NULL default '',
  PRIMARY KEY  (lid)
) TYPE=MyISAM COMMENT='Links module: new submitted links, need to be approved';

--
-- Dumping data for table `mpn_links_newlink`
--


--
-- Table structure for table `mpn_links_subcategories`
--

CREATE TABLE mpn_links_subcategories (
  sid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  PRIMARY KEY  (sid),
  KEY idxlinkssubcategoriestitlecid (title,cid),
  KEY idxlinkssubcategoriescidsid (cid,sid),
  KEY idxlinkssubcategoriestitle (title)
) TYPE=MyISAM COMMENT='Links module: subcategories';

--
-- Dumping data for table `mpn_links_subcategories`
--


--
-- Table structure for table `mpn_links_votedata`
--

CREATE TABLE mpn_links_votedata (
  ratingdbid int(11) NOT NULL auto_increment,
  ratinglid int(11) NOT NULL default '0',
  ratinguser varchar(25) NOT NULL default '',
  rating int(11) NOT NULL default '0',
  ratinghostname varchar(60) NOT NULL default '',
  ratingcomments text NOT NULL,
  ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ratingdbid),
  KEY idxlinksvotedateratinguser (ratinguser),
  KEY idxlinksvotedataratinglid (ratinglid)
) TYPE=MyISAM COMMENT='Links module: rating details';

--
-- Dumping data for table `mpn_links_votedata`
--


--
-- Table structure for table `mpn_mymsg2`
--

CREATE TABLE mpn_mymsg2 (
  message_id int(10) NOT NULL auto_increment,
  title varchar(100) default NULL,
  text text,
  catid int(10) default NULL,
  topicid int(10) default NULL,
  time datetime default NULL,
  display tinyint(1) default NULL,
  PRIMARY KEY  (message_id)
) TYPE=MyISAM COMMENT='mymsg2 module: message details';

--
-- Dumping data for table `mpn_mymsg2`
--


--
-- Table structure for table `mpn_poll_data`
--

CREATE TABLE mpn_poll_data (
  pollID int(11) NOT NULL default '0',
  optionText char(50) NOT NULL default '',
  optionCount int(11) NOT NULL default '0',
  voteID int(11) NOT NULL default '0',
  KEY idxpolldatapollidvoteid (pollID,voteID),
  KEY idxpolldatapolliddesc (pollID)
) TYPE=MyISAM COMMENT='Polls module: voting details';

--
-- Dumping data for table `mpn_poll_data`
--

INSERT INTO mpn_poll_data VALUES (1,'Ummmm, not bad',0,1);
INSERT INTO mpn_poll_data VALUES (1,'Cool',0,2);
INSERT INTO mpn_poll_data VALUES (1,'Terrific',0,3);
INSERT INTO mpn_poll_data VALUES (1,'The best one!',0,4);
INSERT INTO mpn_poll_data VALUES (1,'',0,6);
INSERT INTO mpn_poll_data VALUES (1,'',0,7);
INSERT INTO mpn_poll_data VALUES (1,'',0,8);
INSERT INTO mpn_poll_data VALUES (1,'',0,9);
INSERT INTO mpn_poll_data VALUES (1,'',0,10);
INSERT INTO mpn_poll_data VALUES (1,'',0,11);
INSERT INTO mpn_poll_data VALUES (1,'',0,12);

--
-- Table structure for table `mpn_poll_desc`
--

CREATE TABLE mpn_poll_desc (
  pollID int(11) NOT NULL auto_increment,
  pollTitle char(100) NOT NULL default '',
  timeStamp int(11) NOT NULL default '0',
  voters mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (pollID),
  KEY idxpolldescpolliddesc (pollID),
  KEY idxpolldesctimestamp (timeStamp),
  KEY idxpolldescpolltitle (pollTitle),
  KEY idxpolldescvotersdesc (voters)
) TYPE=MyISAM COMMENT='Polls module: poll descriptions';

--
-- Dumping data for table `mpn_poll_desc`
--

INSERT INTO mpn_poll_desc VALUES (1,'What do you think about myPHPNuke 1.8.8?',991366062,1);

--
-- Table structure for table `mpn_pollcomments`
--

CREATE TABLE mpn_pollcomments (
  tid int(11) NOT NULL auto_increment,
  pid int(11) default '0',
  pollID int(11) default '0',
  date datetime default NULL,
  name varchar(60) NOT NULL default '',
  email varchar(60) default NULL,
  url varchar(255) default NULL,
  host_name varchar(60) default NULL,
  subject varchar(85) NOT NULL default '',
  comment text NOT NULL,
  score tinyint(4) NOT NULL default '0',
  reason tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY idxpollcommentsdatetidpid (date,tid,pid),
  KEY idxpollcommentspollidpid (pollID,pid),
  KEY idxpollcommentstidpollid (pollID,tid)
) TYPE=MyISAM COMMENT='Polls module: submitted comments';

--
-- Dumping data for table `mpn_pollcomments`
--


--
-- Table structure for table `mpn_popsettings`
--

CREATE TABLE mpn_popsettings (
  id int(11) NOT NULL auto_increment,
  uid int(11) default NULL,
  account varchar(50) default NULL,
  popserver varchar(50) default NULL,
  port int(11) default NULL,
  uname varchar(25) default NULL,
  passwd varchar(64) default NULL,
  numshow int(11) default NULL,
  deletefromserver char(1) default NULL,
  refresh int(11) default NULL,
  timeout int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Webmail module: POPbox settings';

--
-- Dumping data for table `mpn_popsettings`
--


--
-- Table structure for table `mpn_posts`
--

CREATE TABLE mpn_posts (
  post_id int(10) NOT NULL auto_increment,
  image varchar(100) NOT NULL default '',
  topic_id int(10) NOT NULL default '0',
  forum_id int(10) NOT NULL default '0',
  poster_id int(10) default NULL,
  post_text text,
  post_time varchar(20) default NULL,
  poster_ip varchar(16) default NULL,
  PRIMARY KEY  (post_id),
  KEY forum_id (forum_id),
  KEY topic_id (topic_id),
  KEY idxtopics (topic_id,forum_id,post_id,poster_id,post_time)
) TYPE=MyISAM COMMENT='Forum module: posts details';

--
-- Dumping data for table `mpn_posts`
--


--
-- Table structure for table `mpn_priv_msgs`
--

CREATE TABLE mpn_priv_msgs (
  msg_id int(10) NOT NULL auto_increment,
  msg_image varchar(100) default NULL,
  subject varchar(100) default NULL,
  from_userid int(10) NOT NULL default '0',
  to_userid int(10) NOT NULL default '0',
  msg_time varchar(20) default NULL,
  msg_text text,
  read_msg tinyint(10) NOT NULL default '0',
  PRIMARY KEY  (msg_id),
  KEY msg_id (msg_id),
  KEY to_userid (to_userid),
  KEY idxprivmsgstouseridreadmsg (to_userid,read_msg),
  KEY idxprivmsgsmsgidfromuserid (msg_id,from_userid)
) TYPE=MyISAM COMMENT='Forum module: private messages details';

--
-- Dumping data for table `mpn_priv_msgs`
--


--
-- Table structure for table `mpn_queue`
--

CREATE TABLE mpn_queue (
  qid smallint(5) unsigned NOT NULL auto_increment,
  uid mediumint(9) NOT NULL default '0',
  uname varchar(40) NOT NULL default '',
  subject varchar(100) NOT NULL default '',
  story text,
  timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  topic varchar(20) NOT NULL default 'Linux',
  PRIMARY KEY  (qid),
  KEY idxqueuetimestamp (timestamp)
) TYPE=MyISAM COMMENT='News module: new submitted news items, to be approved';

--
-- Dumping data for table `mpn_queue`
--


--
-- Table structure for table `mpn_quotes`
--

CREATE TABLE mpn_quotes (
  qid int(10) unsigned NOT NULL auto_increment,
  quote text,
  author varchar(150) NOT NULL default '',
  PRIMARY KEY  (qid)
) TYPE=MyISAM COMMENT='Core systems: random quotes block details';

--
-- Dumping data for table `mpn_quotes`
--


--
-- Table structure for table `mpn_rand_banners`
--

CREATE TABLE mpn_rand_banners (
  banner_id int(10) NOT NULL auto_increment,
  url varchar(255) NOT NULL default '',
  image varchar(150) NOT NULL default '',
  description varchar(255) default NULL,
  PRIMARY KEY  (banner_id)
) TYPE=MyISAM COMMENT='Core system: random banners block details';

--
-- Dumping data for table `mpn_rand_banners`
--


--
-- Table structure for table `mpn_ranks`
--

CREATE TABLE mpn_ranks (
  rank_id int(10) NOT NULL auto_increment,
  rank_title varchar(50) NOT NULL default '',
  rank_min int(10) NOT NULL default '0',
  rank_max int(10) NOT NULL default '0',
  rank_special int(2) default '0',
  PRIMARY KEY  (rank_id),
  KEY rank_min (rank_min),
  KEY rank_max (rank_max),
  KEY idxranksrankminrankmaxranspecial (rank_min,rank_max,rank_special),
  KEY idxranksrankspecial (rank_special)
) TYPE=MyISAM COMMENT='Forums module: user ranks';

--
-- Dumping data for table `mpn_ranks`
--

INSERT INTO mpn_ranks VALUES (1,'Just popping in',0,20,0);
INSERT INTO mpn_ranks VALUES (2,'Not too shy to talk',21,40,0);
INSERT INTO mpn_ranks VALUES (3,'Quite a regular',41,70,0);
INSERT INTO mpn_ranks VALUES (4,'Just can\'t stay away',71,150,0);
INSERT INTO mpn_ranks VALUES (5,'Home away from home',151,10000,0);
INSERT INTO mpn_ranks VALUES (6,'Moderators',-1,-1,1);

--
-- Table structure for table `mpn_referer`
--

CREATE TABLE mpn_referer (
  rid int(11) NOT NULL auto_increment,
  url varchar(255) NOT NULL default '',
  PRIMARY KEY  (rid)
) TYPE=MyISAM COMMENT='Core system: referer details';

--
-- Dumping data for table `mpn_referer`
--


--
-- Table structure for table `mpn_related`
--

CREATE TABLE mpn_related (
  rid int(11) NOT NULL auto_increment,
  tid int(11) NOT NULL default '0',
  name varchar(30) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  PRIMARY KEY  (rid),
  KEY idxrelatedtid (tid)
) TYPE=MyISAM COMMENT='News module: links about related info';

--
-- Dumping data for table `mpn_related`
--


--
-- Table structure for table `mpn_reviews`
--

CREATE TABLE mpn_reviews (
  id int(10) NOT NULL auto_increment,
  date date NOT NULL default '0000-00-00',
  title varchar(150) NOT NULL default '',
  text text NOT NULL,
  reviewer varchar(25) default NULL,
  email varchar(30) default NULL,
  score int(10) NOT NULL default '0',
  cover varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  url_title varchar(50) NOT NULL default '',
  hits int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY idxreviewshitsdesc (hits),
  KEY idxreviewsdatedesc (date)
) TYPE=MyISAM COMMENT='Reviews module: details per review';

--
-- Dumping data for table `mpn_reviews`
--


--
-- Table structure for table `mpn_reviews_add`
--

CREATE TABLE mpn_reviews_add (
  id int(10) NOT NULL auto_increment,
  date date default NULL,
  title varchar(150) NOT NULL default '',
  text text NOT NULL,
  reviewer varchar(25) NOT NULL default '',
  email varchar(30) NOT NULL default '',
  score int(10) NOT NULL default '0',
  url varchar(255) NOT NULL default '',
  url_title varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Reviews module: new submitted reviews';

--
-- Dumping data for table `mpn_reviews_add`
--


--
-- Table structure for table `mpn_reviews_comments`
--

CREATE TABLE mpn_reviews_comments (
  cid int(10) NOT NULL auto_increment,
  rid int(10) NOT NULL default '0',
  userid varchar(25) NOT NULL default '',
  date datetime default NULL,
  comments text,
  score int(10) NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY idxreviewcommentsrid (rid)
) TYPE=MyISAM COMMENT='Reviews module: user comments per review';

--
-- Dumping data for table `mpn_reviews_comments`
--


--
-- Table structure for table `mpn_reviews_main`
--

CREATE TABLE mpn_reviews_main (
  title varchar(100) default NULL,
  description text
) TYPE=MyISAM COMMENT='Reviews module: reviews page title and description';

--
-- Dumping data for table `mpn_reviews_main`
--

INSERT INTO mpn_reviews_main VALUES ('Reviews Section Title','Reviews Section Long Description');

--
-- Table structure for table `mpn_seccont`
--

CREATE TABLE mpn_seccont (
  artid int(11) NOT NULL auto_increment,
  secid int(11) NOT NULL default '0',
  title text NOT NULL,
  byline blob,
  author varchar(255) default NULL,
  authoremail varchar(255) default NULL,
  date datetime default NULL,
  content text NOT NULL,
  counter int(11) NOT NULL default '0',
  PRIMARY KEY  (artid),
  KEY idxseccontsecid (secid),
  KEY idxseccontcounterdesc (counter)
) TYPE=MyISAM COMMENT='Sections module: article contents';

--
-- Dumping data for table `mpn_seccont`
--


--
-- Table structure for table `mpn_sections`
--

CREATE TABLE mpn_sections (
  secid int(11) NOT NULL auto_increment,
  secname varchar(40) NOT NULL default '',
  image varchar(50) NOT NULL default '',
  secdesc blob,
  PRIMARY KEY  (secid),
  KEY idxsectionssecname (secname)
) TYPE=MyISAM COMMENT='Sections module: sections descriptions';

--
-- Dumping data for table `mpn_sections`
--


--
-- Table structure for table `mpn_session`
--

CREATE TABLE mpn_session (
  username varchar(25) NOT NULL default '',
  time varchar(14) NOT NULL default '',
  host_addr varchar(20) NOT NULL default '',
  guest int(1) NOT NULL default '0',
  forum_pass varchar(60) default NULL,
  KEY idxsessionusername (username),
  KEY idxsessionguest (guest)
) TYPE=MyISAM COMMENT='Core system: active sessions';

--
-- Dumping data for table `mpn_session`
--


--
-- Table structure for table `mpn_smiles`
--

CREATE TABLE mpn_smiles (
  id int(10) NOT NULL auto_increment,
  code varchar(50) default NULL,
  smile_url varchar(100) default NULL,
  emotion varchar(75) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Forums module: smile definitions';

--
-- Dumping data for table `mpn_smiles`
--

INSERT INTO mpn_smiles VALUES (1,':D','icon_biggrin.gif','Very Happy');
INSERT INTO mpn_smiles VALUES (2,':-D','icon_biggrin.gif','Very Happy');
INSERT INTO mpn_smiles VALUES (3,':grin:','icon_biggrin.gif','Very Happy');
INSERT INTO mpn_smiles VALUES (4,':)','icon_smile.gif','Smile');
INSERT INTO mpn_smiles VALUES (5,':-)','icon_smile.gif','Smile');
INSERT INTO mpn_smiles VALUES (6,':smile:','icon_smile.gif','Smile');
INSERT INTO mpn_smiles VALUES (7,':(','icon_frown.gif','Sad');
INSERT INTO mpn_smiles VALUES (8,':-(','icon_frown.gif','Sad');
INSERT INTO mpn_smiles VALUES (9,':sad:','icon_frown.gif','Sad');
INSERT INTO mpn_smiles VALUES (10,':O','icon_eek.gif','Surprised');
INSERT INTO mpn_smiles VALUES (11,':-o','icon_eek.gif','Surprised');
INSERT INTO mpn_smiles VALUES (12,':eek:','icon_eek.gif','Suprised');
INSERT INTO mpn_smiles VALUES (13,':-?','icon_confused.gif','Confused');
INSERT INTO mpn_smiles VALUES (14,':???:','icon_confused.gif','Confused');
INSERT INTO mpn_smiles VALUES (15,'8)','icon_cool.gif','Cool');
INSERT INTO mpn_smiles VALUES (16,'8-)','icon_cool.gif','Cool');
INSERT INTO mpn_smiles VALUES (17,':cool:','icon_cool.gif','Cool');
INSERT INTO mpn_smiles VALUES (18,':lol:','icon_lol.gif','Laughing');
INSERT INTO mpn_smiles VALUES (19,':x','icon_mad.gif','Mad');
INSERT INTO mpn_smiles VALUES (20,':-x','icon_mad.gif','Mad');
INSERT INTO mpn_smiles VALUES (21,':mad:','icon_mad.gif','Mad');
INSERT INTO mpn_smiles VALUES (22,':P','icon_razz.gif','Razz');
INSERT INTO mpn_smiles VALUES (23,':-P','icon_razz.gif','Razz');
INSERT INTO mpn_smiles VALUES (24,':razz:','icon_razz.gif','Razz');
INSERT INTO mpn_smiles VALUES (25,':oops:','icon_redface.gif','Embaressed');
INSERT INTO mpn_smiles VALUES (26,':cry:','icon_cry.gif','Crying (very sad)');
INSERT INTO mpn_smiles VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad');
INSERT INTO mpn_smiles VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes');
INSERT INTO mpn_smiles VALUES (29,':wink:','icon_wink.gif','Wink');
INSERT INTO mpn_smiles VALUES (30,';)','icon_wink.gif','Wink');
INSERT INTO mpn_smiles VALUES (31,';-)','icon_wink.gif','Wink');
INSERT INTO mpn_smiles VALUES (32,':pint:','icon_drink.gif','Another pint of beer');
INSERT INTO mpn_smiles VALUES (33,':hammer:','icon_hammer.gif','ToolTimes at work');
INSERT INTO mpn_smiles VALUES (34,':idea:','icon_idea.gif','I have an idea');

--
-- Table structure for table `mpn_stories`
--

CREATE TABLE mpn_stories (
  sid int(11) NOT NULL auto_increment,
  catid int(11) NOT NULL default '0',
  aid varchar(30) NOT NULL default '',
  title varchar(80) default NULL,
  time datetime default NULL,
  hometext text,
  bodytext text NOT NULL,
  comments int(11) default '0',
  counter mediumint(8) unsigned default NULL,
  topic int(3) NOT NULL default '1',
  informant varchar(25) NOT NULL default '',
  notes text NOT NULL,
  ihome int(1) NOT NULL default '0',
  PRIMARY KEY  (sid),
  KEY idxstoriessiddesccatid (sid,catid),
  KEY idxstoriessiddesc (sid),
  KEY idxstoriessiddesctopic (sid,topic),
  KEY idxstoriessiddescihomecatid (sid,ihome,catid),
  KEY idxstoriestime (time),
  KEY idxstoriescounterdesctopic (counter,topic),
  KEY idxstoriescounterdesctime (counter,time),
  KEY idxstoriescatid (catid),
  KEY idxstoriesiddescinformant (sid,informant),
  KEY idxstoriesaid (aid),
  KEY idxstoriestopic (topic),
  KEY idxstoriescounterdesc (counter),
  KEY idxstoriescommentsdesc (comments)
) TYPE=MyISAM COMMENT='News module: details news article';

--
-- Dumping data for table `mpn_stories`
--

INSERT INTO mpn_stories VALUES (1,0,'god','Welcome to myPHPNuke!!!','2004-01-01 12:00:00','This is the first article in <a href=\"http://www.myphpnuke.com/\" target=\"_blank\">myPHPNuke</a>. &nbsp;You can safely delete it.<br>Remember to set/change the nickname and/or password for the main admin user by logging in <a href=\"./admin.php\">here</a>, before the boogie man does it for you. <img src=\"./images/forum/smilies/icon_biggrin.gif\" alt=\"big grin\"><br>There aren\'t any registered/default users, so feel free to <a href=\"./user.php?op=register\">register</a> one. &nbsp;<i><small>(So it makes it look like a real website)</small></i><br>If you have some time on your hands, grab a cup of your favorite java and browse through the <a href=\"http://www.myphpnuke.com/manual188/\" target=\"_blank\">manual</a>.<br>If you want to make your site look <b><i>pretty</i></b>, run over to our <a href=\"http://themes.myphpnuke.com/\" target=\"_blank\">themes</a> site, and choose a theme from its vast collection.<br><br>Remember that this is free software. &nbsp;You can view the lock down license <a href=\"./license.php\"target=\"_blank\">here</a>.<br>If you come across any bugs, or hideous creatures, please report them at our <a href=\"http://sourceforge.net/projects/myphpnuke/\" target=\"_blank\">sourceforge</a> site.<br>Hope you enjoy this software.<p>myPHPNuke Dev Team</p>','',1,1,1,'god','',0);

--
-- Table structure for table `mpn_stories_cat`
--

CREATE TABLE mpn_stories_cat (
  catid int(11) NOT NULL auto_increment,
  title varchar(20) NOT NULL default '',
  counter int(11) NOT NULL default '0',
  PRIMARY KEY  (catid),
  KEY idxstoriescattitle (title),
  KEY idxstoriescatcounterdesc (counter)
) TYPE=MyISAM COMMENT='News module: category definitions';

--
-- Dumping data for table `mpn_stories_cat`
--


--
-- Table structure for table `mpn_topics`
--

CREATE TABLE mpn_topics (
  topicid int(3) NOT NULL auto_increment,
  topicname varchar(20) default NULL,
  topicimage varchar(255) default NULL,
  topictext varchar(40) default NULL,
  counter int(11) NOT NULL default '0',
  PRIMARY KEY  (topicid),
  KEY idxtopicstopictext (topictext),
  KEY idxtopicstopicname (topicname)
) TYPE=MyISAM COMMENT='News module: topic descriptions';

--
-- Dumping data for table `mpn_topics`
--

INSERT INTO mpn_topics VALUES (1,'localhost','myphpnuke.gif','localhost',0);

--
-- Table structure for table `mpn_updatelog`
--

CREATE TABLE mpn_updatelog (
  id smallint(5) unsigned NOT NULL auto_increment,
  name varchar(40) NOT NULL default '',
  email varchar(40) NOT NULL default '',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  files varchar(40) NOT NULL default '',
  updates text,
  bugs text,
  PRIMARY KEY  (id),
  KEY idxupdatelogiddesc (id)
) TYPE=MyISAM COMMENT='Core system: system update log';

--
-- Dumping data for table `mpn_updatelog`
--


--
-- Table structure for table `mpn_users`
--

CREATE TABLE mpn_users (
  uid int(11) NOT NULL default '0',
  name varchar(60) NOT NULL default '',
  uname varchar(25) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  femail varchar(60) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  user_avatar varchar(30) default NULL,
  user_regdate date NOT NULL default '0000-00-00',
  user_icq varchar(15) default NULL,
  user_occ varchar(100) default NULL,
  user_from varchar(100) default NULL,
  user_from_flag varchar(25) default NULL,
  user_intrest varchar(255) default NULL,
  user_sig varchar(255) default NULL,
  user_viewemail tinyint(2) default NULL,
  user_theme int(3) default NULL,
  user_aim varchar(18) default NULL,
  user_yim varchar(25) default NULL,
  user_msnm varchar(60) default NULL,
  pass varchar(40) NOT NULL default '',
  storynum tinyint(4) NOT NULL default '10',
  umode varchar(10) NOT NULL default '',
  uorder tinyint(1) NOT NULL default '0',
  thold tinyint(1) NOT NULL default '0',
  noscore tinyint(1) NOT NULL default '0',
  bio tinytext NOT NULL,
  ublockon tinyint(1) NOT NULL default '0',
  ublock tinytext NOT NULL,
  theme varchar(255) NOT NULL default '',
  commentmax int(11) NOT NULL default '4096',
  counter int(11) NOT NULL default '0',
  allowemail int(11) NOT NULL default '1',
  emailpass varchar(32) NOT NULL default '',
  theme_layout tinyint(1) NOT NULL default '0',
  theme_format tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (uid),
  KEY idxusersuname (uname),
  KEY idxusersemail (email),
  KEY idxuserscounterdesc (counter),
  KEY idxusersuiddesc (uid),
  KEY idxusersname (name),
  KEY idxusersuiduname (uid,uname),
  KEY idxusersemailuid (email,uid),
  KEY idxusersfemail (femail),
  KEY idxusersurl (url),
  KEY idxusersnameuname (name,uname),
  KEY idxusersfemailuname (femail,uname),
  KEY idxusersurluname (url,uname),
  KEY idxusersunamepass (uname,pass),
  FULLTEXT KEY unamefrominterests (uname,user_from,user_intrest,bio)
) TYPE=MyISAM COMMENT='Core system: users';

--
-- Dumping data for table `mpn_users`
--

INSERT INTO mpn_users VALUES (-1,'','Administrator','','','',NULL,'2004-08-30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',10,'',0,0,0,'',0,'','',4096,0,1,'',0,0);
INSERT INTO mpn_users VALUES (1,'','Anonymous','','','','','1999-11-30','','','','','','',0,0,'','','','',10,'',0,0,0,'',0,'','',0,1,1,'',0,0);

--
-- Table structure for table `mpn_users_status`
--

CREATE TABLE mpn_users_status (
  uid int(11) NOT NULL default '0',
  posts int(10) default '0',
  attachsig int(2) default '0',
  rank int(10) default '0',
  level int(10) default '1',
  PRIMARY KEY  (uid)
) TYPE=MyISAM COMMENT='Core system: status info per user';

--
-- Dumping data for table `mpn_users_status`
--

INSERT INTO mpn_users_status VALUES (-1,0,0,0,3);
INSERT INTO mpn_users_status VALUES (1,0,0,0,0);

--
-- Table structure for table `mpn_visits_control`
--

CREATE TABLE mpn_visits_control (
  refresh int(11) NOT NULL default '1'
) TYPE=MyISAM COMMENT='Core system: switch stats generation on-off';

--
-- Dumping data for table `mpn_visits_control`
--

INSERT INTO mpn_visits_control VALUES (1);

--
-- Table structure for table `mpn_visits_counter`
--

CREATE TABLE mpn_visits_counter (
  id int(11) NOT NULL auto_increment,
  date varchar(10) NOT NULL default '',
  count int(11) NOT NULL default '0',
  KEY id (id)
) TYPE=MyISAM COMMENT='Core system: visits counter';

--
-- Dumping data for table `mpn_visits_counter`
--


--
-- Table structure for table `mpn_visits_system`
--

CREATE TABLE mpn_visits_system (
  id int(11) NOT NULL auto_increment,
  date varchar(10) NOT NULL default '',
  ip varchar(50) NOT NULL default '',
  KEY id (id)
) TYPE=MyISAM COMMENT='Core system: visits per ip address';

--
-- Dumping data for table `mpn_visits_system`
--


--
-- Table structure for table `mpn_yp_brokenlink`
--

CREATE TABLE mpn_yp_brokenlink (
  reportid int(11) NOT NULL auto_increment,
  bid int(11) NOT NULL default '0',
  sender varchar(25) NOT NULL default '',
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (reportid)
) TYPE=MyISAM COMMENT='Yellow pages module: reported broken links';

--
-- Dumping data for table `mpn_yp_brokenlink`
--


--
-- Table structure for table `mpn_yp_business`
--

CREATE TABLE mpn_yp_business (
  bid int(11) unsigned NOT NULL auto_increment,
  cid int(11) unsigned NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  phone varchar(20) NOT NULL default '',
  fax varchar(20) NOT NULL default '',
  summary varchar(255) NOT NULL default '',
  address varchar(100) NOT NULL default '',
  city varchar(50) NOT NULL default '',
  state varchar(25) NOT NULL default '',
  zipcode varchar(10) NOT NULL default '',
  country char(3) NOT NULL default '',
  logourl varchar(255) NOT NULL default '',
  submitter varchar(25) NOT NULL default '',
  status tinyint(2) unsigned NOT NULL default '0',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  hits int(11) unsigned NOT NULL default '0',
  rating double(6,4) NOT NULL default '0.0000',
  votes int(11) unsigned NOT NULL default '0',
  comments int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (bid)
) TYPE=MyISAM COMMENT='Yellow pages module: business link details';

--
-- Dumping data for table `mpn_yp_business`
--


--
-- Table structure for table `mpn_yp_businesstxt`
--

CREATE TABLE mpn_yp_businesstxt (
  txtid int(11) unsigned NOT NULL auto_increment,
  bid int(11) unsigned NOT NULL default '0',
  description text NOT NULL,
  PRIMARY KEY  (txtid)
) TYPE=MyISAM COMMENT='Yellow pages module: extended text per business link';

--
-- Dumping data for table `mpn_yp_businesstxt`
--


--
-- Table structure for table `mpn_yp_categories`
--

CREATE TABLE mpn_yp_categories (
  cid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  imgurl varchar(255) NOT NULL default '',
  PRIMARY KEY  (cid)
) TYPE=MyISAM COMMENT='Yellow pages module: categories';

--
-- Dumping data for table `mpn_yp_categories`
--


--
-- Table structure for table `mpn_yp_modrequest`
--

CREATE TABLE mpn_yp_modrequest (
  requestid int(11) unsigned NOT NULL auto_increment,
  bid int(11) unsigned NOT NULL default '0',
  cid int(11) unsigned NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  phone varchar(20) NOT NULL default '',
  fax varchar(20) NOT NULL default '',
  summary varchar(255) NOT NULL default '',
  address varchar(100) NOT NULL default '',
  city varchar(50) NOT NULL default '',
  state varchar(25) NOT NULL default '',
  zipcode varchar(10) NOT NULL default '',
  country char(3) NOT NULL default '',
  logourl varchar(255) NOT NULL default '',
  description text NOT NULL,
  modifysubmitter varchar(25) NOT NULL default '',
  PRIMARY KEY  (requestid)
) TYPE=MyISAM COMMENT='Yellow pages module: submitted modification requests';

--
-- Dumping data for table `mpn_yp_modrequest`
--


--
-- Table structure for table `mpn_yp_votedata`
--

CREATE TABLE mpn_yp_votedata (
  ratingid int(11) unsigned NOT NULL auto_increment,
  bid int(11) unsigned NOT NULL default '0',
  ratinguser varchar(25) NOT NULL default '',
  rating tinyint(3) unsigned NOT NULL default '0',
  ratinghostname varchar(60) NOT NULL default '',
  ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ratingid)
) TYPE=MyISAM COMMENT='Yellow pages module: rating details';

--
-- Dumping data for table `mpn_yp_votedata`
--


