Help adding sql patch

[ariasparkle]

Help adding a sql patch? How to add patch?

[dataman]

You'll probably have to be a bit more specific... what are you hoping to accomplish?

DataMan

[ariasparkle]

I am installing a zen cart module and need to add a sql patch for it to work. It is a no account patch. I need to add the patch. There is no INSTALL sql patches button on my tool area so i am confused. Read manual but confused me even more.

[ariasparkle]

This is what i need to add.


ALTER TABLE customers ADD COWOA_account tinyint(1) NOT NULL default 0;
ALTER TABLE orders ADD COWOA_order tinyint(1) NOT NULL default 0;
INSERT INTO query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');

[ariasparkle]

Ok i got the first 2 lines figured out but i can't get this to work.

INSERT INTO query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');

I tried to edit, but i get a syntax error. I put this into the files:
VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');

Is this correct? what do i need to change and do i add this to each of the above files or i file as a whole?