I am trying to install the COWA I have it loaded on my localhost, and it worked just fine, However when adding the sql on the hosted server I will not let me alter tables. I get I error that states something like can't alter table there is no table customers
My site was down due to no connection to the database and it would not restore my backup. I had to add a new database - upload the backup to it and change configure files.
I have downloaded a backup copy of my database and want to insert into the sql backup and then add the patch by pasting into the query window.
The zen cart version on my hosted server is 1.3.8
version on localhost is 1.3.9
This is my table customer
Code:
DROP TABLE IF EXISTS `customers`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `customers` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_gender` char(1) NOT NULL default '',
`customers_firstname` varchar(32) NOT NULL default '',
`customers_lastname` varchar(32) NOT NULL default '',
`customers_dob` datetime NOT NULL default '0001-01-01 00:00:00',
`customers_email_address` varchar(96) NOT NULL default '',
`customers_nick` varchar(96) NOT NULL default '',
`customers_default_address_id` int(11) NOT NULL default '0',
`customers_telephone` varchar(32) NOT NULL default '',
`customers_fax` varchar(32) default NULL,
`customers_password` varchar(40) NOT NULL default '',
`customers_newsletter` char(1) default NULL,
`customers_group_pricing` int(11) NOT NULL default '0',
`customers_email_format` varchar(4) NOT NULL default 'TEXT',
`customers_authorization` int(1) NOT NULL default '0',
`customers_referral` varchar(32) NOT NULL default '',
PRIMARY KEY (`customers_id`),
KEY `idx_email_address_zen` (`customers_email_address`),
KEY `idx_referral_zen` (`customers_referral`(10)),
KEY `idx_grp_pricing_zen` (`customers_group_pricing`),
KEY `idx_nick_zen` (`customers_nick`),
KEY `idx_newsletter_zen` (`customers_newsletter`)
) ENGINE=MyISAM AUTO_INCREMENT=274 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
Would I just add to the code?
COWOA_account tinyint(1) NOT NULL default 0;
and would I need some commas around.
and do the same for the orders and then what would I do with the code?
Or is there a better suggestion?
Bookmarks