View Single Post
Old 2007-10-20, 12:18 AM   #4
Beaver Bob
Porn Blog Addict
 
Beaver Bob's Avatar
 
Join Date: Oct 2005
Location: Las Vegas, Nevada
Posts: 715
Send a message via ICQ to Beaver Bob
from what i can see it needs to tables, `cats` and `links`. what we don't see is the names of the fields inside the cats table, or the constraints on the fields in the links table. It would be kinda tricky.. backups are your friend

TRY THIS:
PHP Code:
CREATE TABLE `cats` (
  `
idint(11NOT NULL auto_increment,
  `
name`  varchar(100NOT NULL default '',
  
PRIMARY KEY  (`id`)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=;

CREATE TABLE `links` (
  `
idint(11NOT NULL auto_increment,
  `
lrss`  varchar(255NOT NULL default '',
  `
site`  varchar(255NOT NULL default '',
  `
lback`  varchar(255NOT NULL default '',
  `
titlevarchar(255NOT NULL default '',
  `
descriptionvarchar(255NOT NULL default '',
  `
catint(11NOT NULL,
  `
namevarchar(255NOT NULL default '',
  `
mailvarchar(255NOT NULL default '',
  `
datedate NOT NULL default '0000-00-00',
  
PRIMARY KEY  (`id`)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=
if this doesn't work, try changing the cat field to varchar, or the date field to datetime.
Beaver Bob is offline   Reply With Quote