File is corrupt and I am having problem with zip. Trying to reload.

Here is what I changed. Hopefully monitors will allow code in description to stay in case file is corrupt again.


in original file by rmh at about line 107 look for:
# //rmh M-S_pricing
###########################

CREATE TABLE customers_groups (
customers_groups_id int NOT NULL auto_increment,
customers_groups_name varchar(32) NOT NULL DEFAULT '',
customers_groups_type char(1) NOT NULL DEFAULT '0',
customers_groups_discount varchar(4) DEFAULT NULL,
PRIMARY KEY (customers_groups_id)
);

INSERT INTO customers_groups (customers_groups_id, customers_groups_name) VALUES ('1', 'Retail');
INSERT INTO customers_groups (customers_groups_id, customers_groups_name) VALUES ('2', 'Wholesale');


Change it to:

###########################

CREATE TABLE customers_groups (
customers_groups_id int NOT NULL auto_increment,
customers_groups_name varchar(32) NOT NULL DEFAULT '',
customers_groups_type char(1) NOT NULL DEFAULT '0',
customers_groups_discount varchar(4) DEFAULT NULL,
PRIMARY KEY (customers_groups_id)
);

INSERT INTO customers_groups (customers_groups_id, customers_groups_name, customers_groups_type, customers_groups_discount) VALUES ('1', 'Retail','0', NULL);
INSERT INTO customers_groups (customers_groups_id, customers_groups_name, customers_groups_type, customers_groups_discount) VALUES ('2', 'Wholesale', '0', NULL);


More...