Discount Groups

[jond]

I would like to use the Discount Groups mod on my store. Can someone confirm that this will work? Also, im having trouble translating the SQL instructions into pure SQL - Could someone translate the following for me?

 

# Database: catalog

# Table: 'customers_groups'

#

CREATE TABLE `customers_groups` (

`customers_groups_id` int(11) NOT NULL auto_increment,

`customers_groups_name` varchar(32) NOT NULL default '',

`customers_groups_discount` int(11) NOT NULL default '0',

PRIMARY KEY (`customers_groups_id`)

) TYPE=MyISAM;

 

# Database: catalog

# Table: 'groups_to_categories'

#

CREATE TABLE `groups_to_categories` (

`customers_groups_id` int(11) NOT NULL default '0',

`categories_id` int(11) NOT NULL default '0',

`discount` int(11) NOT NULL default '0',

PRIMARY KEY (`customers_groups_id`,`categories_id`)

) TYPE=MyISAM; F

 

add to the "customers_groups" table a record with id "1", name "Default" and discount = 0

 

add the column "customers_groups_id" int(11) to "customers" table with default value = 1;

 

execute on table "customers":

UPDATE customers SET customers_groups_id = 1;

 

add the column "category_id" int(11) to "customers_basket" table ;

[ChrisHoward]

It works, But I am having a problem with getting the product_listing price to actually ahow and no just be ?0.00 any ideas?

 

Well here is the SQL file I have made that you can just execute onto your server, its easier than doing it manually! :D

 

CREATE TABLE `customers_groups` (
 `customers_groups_id` int(11) NOT NULL auto_increment,
 `customers_groups_name` varchar(32) NOT NULL default '',
 `customers_groups_discount` int(11) NOT NULL default '0',
 PRIMARY KEY  (`customers_groups_id`)
) TYPE=MyISAM; 

CREATE TABLE `groups_to_categories` (
 `customers_groups_id` int(11) NOT NULL default '0',
 `categories_id` int(11) NOT NULL default '0',
 `discount` int(11) NOT NULL default '0',
 PRIMARY KEY  (`customers_groups_id`,`categories_id`)
) TYPE=MyISAM;

INSERT INTO `customers_groups` VALUES (1, 'default', 0);

ALTER TABLE `customers` ADD `customers_groups_id` int(11) NOT NULL default '1';

UPDATE customers SET customers_groups_id = 1;

ALTER TABLE `customers_basket` ADD `category_id` int(11) NOT NULL;

 

Hope this helps!