CREATE TABLE `pages` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `keywords` varchar(200) NOT NULL default '',
  `active` varchar(5) NOT NULL default 'No',
  `ip` varchar(15) NOT NULL default '',
  `catID` int(11) NOT NULL default '0',
  `pdate` date NOT NULL default '0000-00-00',
  `exp` int(11) NOT NULL default '0',
  `mid` tinyint(1) NOT NULL default '0',
  `completed` tinyint(1) NOT NULL default '0',
  `email` varchar(100) default NULL,
  `rLink` varchar(255) default NULL,
  `rLinkStatus` char(1) default '1',
  `reciprocalCheckText` text,
  `coupon` varchar(16) default NULL,
  `paymentData` text NOT NULL,
  `paymentProcessor` VARCHAR( 32 ) default NULL,
  `link_checked` int(11) NOT NULL default '0',
  `link_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)