| Author |
mpn_links_links table problem..... |
|
smartvicky
Just popping in Joined: 02-Oct-2008 Posts: 2
|
Posted: 2008-10-02 08:20
after database creation  setup create all table but displayed as mpn_links_links is already created. due to this setup is not completed..... but in database this table is not present.. how to solve this problem...? 
|
|
Kang
Home away from home Joined: 15-Feb-2003 Posts: 163
From: Malaysia
|
Posted: 2008-10-04 03:12
Use this: !!! CODE !!! CREATE TABLE mpn_links_links ( lid int(11) NOT NULL auto_increment, cid int(11) NOT NULL default '0', sid int(11) NOT NULL default '0', title varchar(100) NOT NULL default '', url varchar(255) NOT NULL default '', description text NOT NULL, date datetime default NULL, name varchar(60) NOT NULL default '', email varchar(60) NOT NULL default '', hits int(11) NOT NULL default '0', submitter varchar(25) NOT NULL default '', linkratingsummary double(6,4) NOT NULL default '0.0000', totalvotes int(11) NOT NULL default '0', totalcomments int(11) NOT NULL default '0', PRIMARY KEY (lid), KEY idxlinkslinkscid (cid), KEY idxlinkslinkstitle (title), KEY idxlinkslinkstitlecid (title,cid), KEY idxlinkslinkstitlesid (title,sid), KEY idxlinkslinksurl (url), KEY idxlinkslinkssid (sid), KEY idxlinkslinksdate (date), KEY idxlinkslinksdatedesccid (date,cid), KEY idxlinkslinkstitledate (title,date), KEY idxlinkslinkslinkratingsummary (linkratingsummary), KEY idxlinkslinkshitsdesc (hits) ) TYPE=MyISAM COMMENT='Links module: link details' AUTO_INCREMENT=1 ; ----------------- Warm regard from Malaysia!
|