Simple SQL help

[jond]

Hi,

 

Im installing the Separate Pricing mod. What would be the SQL to use to run the following?

 

Database Changes:

 

Add to the customers table:

customers_group_name (char 27) Default value: Retail

customers_group_id (int 11) Default value: 0

 

Create

products_groups table

 

Add to the products_groups table:

customers_group_id (int 11)

customers_group_price (decimal 15, 4)

products_id (int 11)

products_price (decimal 15,4)

[Guest]

there should be a sql statement with the contribution, or in the instructions the sql statements should be in the text file / readme file somewhere