[vbmark]

Go into your MySQL control panel and run the following SQL statement. This will make the table. I just needed to add TYPE = MyISAM to the end.

CREATE TABLE links (
  link_id int(20) NOT NULL auto_increment,
  link_author int(20) NOT NULL default '0',
  link_blog int(20) default '0',
  link_status enum('discard','queued','published','abuse','duplicated') NOT NULL default 'discard',
  link_randkey int(20) NOT NULL default '0',
  link_votes int(20) NOT NULL default '0',
  link_karma decimal(10,2) NOT NULL default '0.00',
  link_modified timestamp NOT NULL,
  link_date timestamp NOT NULL default '0000-00-00 00:00:00',
  link_published_date timestamp NOT NULL default '0000-00-00 00:00:00',
  link_category int(11) NOT NULL default '0',
  link_lang int(11) NOT NULL default '1',
  link_url varchar(200) NOT NULL default '',
  link_url_title text,
  link_title text NOT NULL,
  link_content text NOT NULL,
  link_tags text,
  link_field1 varchar(255) NOT NULL default '',
  link_field2 varchar(255) NOT NULL default '',
  link_field3 varchar(255) NOT NULL default '',
  link_field4 varchar(255) NOT NULL default '',
  link_field5 varchar(255) NOT NULL default '',
  link_field6 varchar(255) NOT NULL default '',
  link_field7 varchar(255) NOT NULL default '',
  link_field8 varchar(255) NOT NULL default '',
  link_field9 varchar(255) NOT NULL default '',
  link_field10 text NOT NULL default '',
  link_field11 text NOT NULL default '',
  link_field12 text NOT NULL default '',
  link_field13 text NOT NULL default '',
  link_field14 text NOT NULL default '',
  link_field15 text NOT NULL default '',
  PRIMARY KEY  (link_id),
  KEY link_author (link_author),
  KEY link_url (link_url),
  KEY link_date (link_date),
  KEY link_published_date (link_published_date),
  FULLTEXT KEY link_url_2 (link_url,link_url_title,link_title,link_content,link_tags),
  FULLTEXT KEY link_tags (link_tags)
) AUTO_INCREMENT=15,TYPE = MyISAM

EDIT: I wrapped everything in the Code tag which fixed the spacing problems mentioned in the below posts.

[webfanatic]

Thanks for the fix. I put it right into createtables.php and it did the trick.

[WinBear]

Thanks, you've got a couple of trivial typos (excess spaces in the wrong places) but easily fixed.

[los5lau]

Yea, that space at the end messed me up,

For people using this code make sure you take out the space between "l" & "ink_tags"

this is how it looks below
"FULLTEXT KEY link_url_2 (link_url,link_url_title,link_title,link_content,l ink_tags),"

make it
FULLTEXT KEY link_url_2 (link_url,link_url_title,link_title,link_content,l ink_tags),