Old database into Indexu5.2.0

[Marty]

Hi All

Iam interested in starting fresh with the indexu5.2.0 software... I already have a search engine on the net but to me its outdated with features, http://web-bin.com from "mewsoft" thus iam thinking of transfering the links and categories over etc... anyone care to comment on what opsticals i might have.

heres a sample of my links tables

CREATE TABLE `links` (
  `ID` int(11) NOT NULL default '0',
  `Cat_ID` int(11) default NULL,
  `User_ID` varchar(50) default NULL,
  `Title` varchar(140) default NULL,
  `URL` varchar(140) default NULL,
  `Description` text,
  `Keywords` text,
  `Status` int(11) default NULL,
  `Expire` int(11) default NULL,
  `Start_Date` int(11) default NULL,
  `End_Date` int(11) default NULL,
  `Update_Date` int(11) default NULL,
  `Template` varchar(20) default NULL,
  `Language` varchar(20) default NULL,
  `Rank` decimal(15,5) default NULL,
  `Price` decimal(10,4) default NULL,
  `Score` varchar(20) default NULL,
  `URL1` varchar(120) default NULL,
  `URL2` varchar(120) default NULL,
  `Location` varchar(50) default NULL,
  `URL_Image` varchar(120) default NULL,
  `URL_Icon` varchar(120) default NULL,
  `FName` varchar(40) default NULL,
  `LName` varchar(20) default NULL,
  `Company` varchar(50) default NULL,
  `Job_Title` varchar(50) default NULL,
  `Street` varchar(50) default NULL,
  `City` varchar(30) default NULL,
  `State` varchar(10) default NULL,
  `Zip` varchar(10) default NULL,
  `Country` varchar(25) default NULL,
  `Phone` varchar(15) default NULL,
  `Fax` varchar(15) default NULL,
  `Website` varchar(140) default NULL,
  `Email` varchar(100) default NULL,
  `Extra1` varchar(250) default NULL,
  `Extra2` varchar(250) default NULL,
  `Extra3` varchar(250) default NULL,
  `Extra4` varchar(250) default NULL,
  `Extra5` varchar(250) default NULL,
  `Extra6` varchar(250) default NULL,
  `Extra7` varchar(250) default NULL,
  `Extra8` varchar(250) default NULL,
  `Extra9` varchar(250) default NULL,
  `Extra10` varchar(250) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Links_idx1` (`Cat_ID`),
  KEY `Links_idx4` (`Price`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

and my categories

CREATE TABLE `categories` (
  `Cat_ID` int(11) NOT NULL default '0',
  `Parent` int(11) NOT NULL default '0',
  `Name` varchar(150) NOT NULL default '',
  `Description` text,
  `Active` int(11) default NULL,
  `Accept` int(11) default NULL,
  `Sort` int(11) default NULL,
  `Teaser` int(11) default NULL,
  `Count` int(11) default NULL,
  `Sub_Count` int(11) default NULL,
  `Mode` int(11) default NULL,
  PRIMARY KEY  (`Cat_ID`),
  KEY `Categories_idx1` (`Name`),
  KEY `Categories_idx2` (`Cat_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Thanks in advance for your comments
Marty

[ezykiwi]

Marty, Did you change this over in the end? I notice the date of the post is a couple of months ago, but just thought Id see if your still there?