#
# Table structure for table `phplinks_categories`
#

CREATE TABLE `phplinks_categories` (
  `ID` smallint(5) unsigned NOT NULL auto_increment,
  `Category` varchar(32) NOT NULL default '',
  `PID` smallint(5) unsigned NOT NULL default '0',
  `Children` enum('Top','Rand','Desc','Vert') NOT NULL default 'Top',
  `TopChildren` tinyint(3) unsigned NOT NULL default '3',
  `AllowSites` enum('Y','N') NOT NULL default 'Y',
  `ShowSiteCount` enum('Y','N') NOT NULL default 'Y',
  `Description` text NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `Category` (`Category`),
  KEY `TopChildren` (`TopChildren`),
  KEY `Children` (`Children`),
  KEY `PID` (`PID`)
) TYPE=MyISAM;

#

# --------------------------------------------------------

#
# Table structure for table `phplinks_links`
#

CREATE TABLE `phplinks_links` (
  `ID` smallint(5) unsigned NOT NULL auto_increment,
  `SiteName` varchar(100) NOT NULL default '',
  `SiteURL` varchar(100) NOT NULL default '',
  `RecipURL` varchar(100) NOT NULL default '',
  `LastUpdate` timestamp(14) NOT NULL,
  `Added` varchar(14) default NULL,
  `Description` text NOT NULL,
  `featured` set('0','1') NOT NULL default '0',
  `Category` smallint(5) unsigned NOT NULL default '0',
  `Country` varchar(100) NOT NULL default 'United_States.gif',
  `UserName` varchar(16) NOT NULL default '',
  `Password` varchar(16) NOT NULL default '',
  `Hint` varchar(50) NOT NULL default '',
  `Email` varchar(50) NOT NULL default '',
  `HitsIn` int(7) unsigned NOT NULL default '0',
  `HitsOut` int(7) unsigned NOT NULL default '0',
  `InIP` varchar(15) NOT NULL default '',
  `OutIP` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  KEY `Category` (`Category`),
  KEY `SiteURL` (`SiteURL`)
) TYPE=MyISAM;

#
# Dumping data for table `phplinks_links`
#

INSERT INTO `phplinks_links` VALUES (1, 'Dew-Code.com', 'http://www.dew-code.com/', 'http://www.dew-code.com/index.php', 20040812155625, '20040705194925', 'A resource for aspiring coders and the open source realm. PHP PERL MySQL Linux Bash and other stuff like that. ', '1', 255, 'United_States.gif', 'dewed101', '029d45e171a9c854', 'basic dude', 'duane@dew-code.com', 0, 19, '', '65.54.188.97');
INSERT INTO `phplinks_links` VALUES (2, 'PromoPeddler.com', 'http://www.promopeddler.com', 'http://directory.promopeddler.com/index.php?show=about', 20040718175334, '20040711143950', 'Promotional Products & Gifts\r\nLargest Online Catalog.\r\nOver 975,000 Promotional Products,\r\nCustom Items, & Executive Gifts. Our promotional product experts help you from start to finish.', '1', 521, 'United_States.gif', 'dewed', '029d45e171a9c854', 'basic dude', 'dewed@dew-code.com', 1, 19, '4.4.21.179', '70.240.192.60');

# --------------------------------------------------------

#
# Table structure for table `phplinks_related`
#

CREATE TABLE `phplinks_related` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `cat_id` smallint(5) unsigned NOT NULL default '0',
  `rel_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `phplinks_related`
#

INSERT INTO `phplinks_related` VALUES (1, 5, 453);

# --------------------------------------------------------

#
# Table structure for table `phplinks_reviews`
#

CREATE TABLE `phplinks_reviews` (
  `ID` smallint(5) unsigned NOT NULL auto_increment,
  `SiteID` smallint(5) unsigned NOT NULL default '0',
  `ReviewTitle` varchar(100) NOT NULL default '',
  `Review` text NOT NULL,
  `Reviewer` varchar(50) NOT NULL default '',
  `ReviewerEmail` varchar(50) NOT NULL default '',
  `ReviewerURL` varchar(100) NOT NULL default '',
  `Rating` tinyint(2) unsigned NOT NULL default '0',
  `Status` enum('New','Show','Hide') NOT NULL default 'New',
  `Added` timestamp(14) NOT NULL,
  `ReviewerIP` varchar(15) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Rating` (`Rating`)
) TYPE=MyISAM;

#
# Dumping data for table `phplinks_reviews`
#

INSERT INTO `phplinks_reviews` VALUES (4, 2, 'Promotional products perfection', 'One of our customers had this to say about us.\r\n\r\n"I have used Promopeddler.com for several large jobs. Everything is always handled in a very friendly manner while still maintaining a high level of professionalism. Each product is of the best quality and I have always been pleased with the end result."', 'Dewed', 'dewed@dew-code.com', 'http://www.promopeddler.com', 10, 'Show', 20040718175351, '');
INSERT INTO `phplinks_reviews` VALUES (1, 1, 'Dew-Code is not half bad', 'Shameless self-promotion. Dew-code is really becoming a community thanks to many of its heplful members who graciously contribute their time advice and experience just for the sake of being helpful. Why cant the whole world be like that.\r\n\r\nMore and more people are discovering Dew-Code a site that helps to make the learning curve a little less steep for fledgling PHP and PERL coders.\r\n\r\nIts also the home of Dew-NewPHPLinks a feature rich link exchange program written in PHP that uses a MySQL database. \r\nCertainly worth checking out.', 'Dewed', 'dewed@dew-code.com', 'http://www.dew-code.com', 5, 'Show', 20040722154502, '');

# --------------------------------------------------------

#
# Table structure for table `phplinks_sessions`
#

CREATE TABLE `phplinks_sessions` (
  `id` varchar(32) NOT NULL default '',
  `data` text NOT NULL,
  `expire` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `phplinks_settings`
#

CREATE TABLE `phplinks_settings` (
  `ID` tinyint(4) unsigned NOT NULL auto_increment,
  `SiteTitle` varchar(50) NOT NULL default 'phpLinks',
  `Theme` varchar(16) NOT NULL default 'original',
  `Language` varchar(16) NOT NULL default 'english',
  `Name` varchar(50) NOT NULL default '',
  `Email` varchar(50) NOT NULL default '',
  `DateFormat` varchar(16) NOT NULL default 'M j, Y',
  `DefaultCountry` varchar(50) NOT NULL default 'United States',
  `ColCount` enum('2','3','4') default NULL,
  `ManuallyValidate` enum('Y','N') NOT NULL default 'Y',
  `URLValidate` enum('Y','N') NOT NULL default 'Y',
  `NewSubmissionEmail` enum('Y','N') NOT NULL default 'Y',
  `SiteAdditionEmail` enum('Y','N') NOT NULL default 'Y',
  `SiteDeletionEmail` enum('Y','N') NOT NULL default 'Y',
  `PerPage` tinyint(3) NOT NULL default '10',
  `NavLinks` tinyint(3) NOT NULL default '3',
  `BaseURL` varchar(50) NOT NULL default '',
  `BasePath` varchar(50) NOT NULL default '',
  `OuterFrame` enum('Y','N') NOT NULL default 'Y',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Dumping data for table `phplinks_settings`
#

INSERT INTO `phplinks_settings` VALUES (1, 'Site Name', 'blue-ice', 'english', 'Site owner name', 'user@domain.com', 'M j, Y', 'United_States.gif', '4', 'Y', 'N', 'Y', 'Y', 'Y', 10, 4, 'http://www.domain.com/links', '/links', 'N');

# --------------------------------------------------------

#
# Table structure for table `phplinks_specs`
#

CREATE TABLE `phplinks_specs` (
  `ID` tinyint(3) unsigned NOT NULL auto_increment,
  `SiteNameMin` tinyint(4) NOT NULL default '0',
  `SiteNameMax` tinyint(4) NOT NULL default '0',
  `DescMin` tinyint(4) NOT NULL default '0',
  `DescMax` smallint(4) NOT NULL default '0',
  `UserNameMin` tinyint(4) NOT NULL default '0',
  `UserNameMax` tinyint(4) NOT NULL default '0',
  `PWMin` tinyint(4) NOT NULL default '0',
  `PWMax` tinyint(4) NOT NULL default '0',
  `HintMin` tinyint(4) NOT NULL default '0',
  `HintMax` tinyint(4) NOT NULL default '0',
  `EmailSpec` varchar(255) NOT NULL default '^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+',
  `ReviewTitleMin` tinyint(4) NOT NULL default '5',
  `ReviewTitleMax` tinyint(4) NOT NULL default '120',
  `ReviewerMin` tinyint(4) NOT NULL default '4',
  `ReviewerMax` tinyint(4) NOT NULL default '50',
  `ReviewMin` tinyint(4) NOT NULL default '50',
  `ReviewMax` mediumint(9) NOT NULL default '1000',
  `ReviewerEmailSpec` varchar(255) NOT NULL default '^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Dumping data for table `phplinks_specs`
#

INSERT INTO `phplinks_specs` VALUES (1, 5, 120, 32, 384, 5, 16, 6, 16, 5, 50, '^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\\.[a-zA-Z0-9_-])+', 5, 120, 4, 50, 50, 1000, '^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\\.[a-zA-Z0-9_-])+');

# --------------------------------------------------------

#
# Table structure for table `phplinks_temp`
#

CREATE TABLE `phplinks_temp` (
  `ID` int(7) unsigned NOT NULL auto_increment,
  `SiteName` varchar(100) NOT NULL default '',
  `SiteURL` varchar(100) NOT NULL default '',
  `RecipURL` varchar(100) NOT NULL default '',
  `LastUpdate` timestamp(14) NOT NULL,
  `Added` varchar(14) default NULL,
  `Description` text NOT NULL,
  `featured` set('0','1') NOT NULL default '0',
  `Category` smallint(6) unsigned NOT NULL default '0',
  `Country` varchar(100) NOT NULL default 'United_States.gif',
  `UserName` varchar(16) NOT NULL default '',
  `Password` varchar(16) NOT NULL default '',
  `Hint` varchar(50) NOT NULL default '',
  `Email` varchar(50) NOT NULL default '',
  `HitsIn` int(7) unsigned NOT NULL default '0',
  `HitsOut` int(7) unsigned NOT NULL default '0',
  `InIP` varchar(15) NOT NULL default '',
  `OutIP` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `SiteURL` (`SiteURL`)
) TYPE=MyISAM;


#
# Table structure for table `phplinks_terms`
#

CREATE TABLE `phplinks_terms` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Term` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  KEY `Term` (`Term`)
) TYPE=MyISAM;

#