SQL update for Tax Exempt Status module

[TheMusician]

Hello,

I have been working on installing the Tax Exempt Status module for a client of mine. The SQL update throws an error when I run the query. The error is as follows:

1146 Table 'bostec_zencart.bos_zen_customers' doesn't exist
in:
[show fields from bos_zen_customers]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

The query that is supplied with the module is this.

CREATE TABLE `zen_tax_exempt` (
  `tax_exempt_id` int(11) NOT NULL auto_increment,
  `tax_exempt_name` varchar(32) NOT NULL default '',
  `tax_exempt_percentage` decimal(5,2) NOT NULL default '0.00',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`tax_exempt_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

ALTER TABLE zen_customers ADD COLUMN customers_tax_exempt int(11) NOT NULL default '0' AFTER customers_group_pricing;

My database is named bostec_zencart and the tables are all prefixed with bos_

To correct the error I need to change the zen_tax_exempt to bos_tax_exempt amd zen_customers to bos_customers.

Is there anything else that I need to change? Thank you.

[Ajeh]

That SQL will not work well as it has added the zen_ to all the references to table names as the prefix ...

You would need to remove those to run that ...

[TheMusician]

That SQL will not work well as it has added the zen_ to all the references to table names as the prefix ...

You would need to remove those to run that ...

Thank you. That worked perfectly.