Converting a database

[mjump]

I "inherited" an OS commerce site from a customer and over the years his previous guy had made all kinds of custom hacks to the OS code - or so it appears. The site is really ugly and I am trying to give it some appeal. I have looked at several templates which are easy to work with from an html point, but the database structure varies greatly between the current site and what the new versions seem to have.

 

Are there any tools to take an existing database structure and convert it to a "standard" structure? If I just try to import the old datbase into the new one, it seems some functionality is missing and I get mixed results in queries (50 products and only 5 may show)

 

Old structure:

CREATE TABLE `categories` (

`categories_id` int(11) NOT NULL auto_increment,

`categories_image` varchar(64) default NULL,

`parent_id` int(11) NOT NULL default '0',

`sort_order` int(3) default NULL,

`date_added` datetime default NULL,

`last_modified` datetime default NULL,

`categories_root` int(11) NOT NULL default '0',

`category_head_title_tag` varchar(80) default NULL,

`category_head_desc_tag` longtext,

`category_head_keywords_tag` longtext,

PRIMARY KEY (`categories_id`),

KEY `idx_categories_parent_id` (`parent_id`),

FULLTEXT KEY `category_head_desc_tag` (`category_head_desc_tag`)

) TYPE=MyISAM AUTO_INCREMENT=308 ;

 

New Structure:

create table categories (

categories_id int(11) not null auto_increment,

categories_image varchar(64) ,

parent_id int(11) default '0' not null ,

sort_order int(3) ,

date_added datetime ,

last_modified datetime ,

PRIMARY KEY (categories_id),

KEY idx_categories_parent_id (parent_id)

);

[satish]

well the added fields that You see are due to some header tag controler contrib.

Which is recommended for SEO.

 

 

I recommend keep the same data base just apply some template to get the design updated.

Satish

[♥Vger]

You could not just delete those extra fields from the db, because they are referenced in the website files - and you'd end up with a broken site with error messages plastered over the screen.

 

You can uninstall the contributions (provided you know what they all are) by downloading the contributions from here and going through the install procedure for them in reverse, and then you can remove the extra db fields.

 

Vger

[mjump]

You could not just delete those extra fields from the db, because they are referenced in the website files - and you'd end up with a broken site with error messages plastered over the screen.

 

You can uninstall the contributions (provided you know what they all are) by downloading the contributions from here and going through the install procedure for them in reverse, and then you can remove the extra db fields.

 

Vger

 

 

As noted I inherited the site so am not sure of all the contributions added to the site over time prior to my taking over the site.. so I guess my assumption is to toss the "templates" and just go in and tweak the existing files to get a look that is more professional