Phoca Forum

Posted: **14 Apr 2009, 18:10**

I'm going to write a PHP script to parse through a CSV file of URL changes I have and spit out the appropriate SQL insert statement so I can mass insert all my old urls with their new url locations (i have a site with 500+ old urls).

What tables/cells are the Phoca SEF urls stored in?

Thanks!

Posted: **15 Apr 2009, 17:40**

Hi,

this is the table structure for Phoca SEF:

Code: Select all

DROP TABLE IF EXISTS `#__phocasef_url`;
CREATE TABLE `#__phocasef_url` (
  `id` int(11) NOT NULL auto_increment,
  `cw` int(11) NOT NULL default '0',
  `cr` int(11) NOT NULL default '0',
  `new_url` varchar(255) NOT NULL default '',
  `old_url` varchar(255) NOT NULL default '',
  `date_url` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM CHARACTER SET `utf8`;

DROP TABLE IF EXISTS `#__phocasef_ref`;
CREATE TABLE `#__phocasef_ref` (
  `id` int(11) NOT NULL auto_increment,
  `count_url` int(11) NOT NULL default '0',
  `ref_url` varchar(255) NOT NULL default '',
  `ref_to_url` varchar(255) NOT NULL default '',
  `date_url` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM CHARACTER SET `utf8`;

Phoca Forum

DB table question

DB table question

Re: DB table question