need help
07-05-2006, 03:45 PM
i downloaded this Discount Coupon Codes
http://www.oscommerce.com/community/contributions,4269/category,all/search,discount+coupon
and I get so far in intalation til this point:
**************** STEP 2 ****************
Create the database tables
Run these statements via the SQL tab in phpMyAdmin.
CREATE TABLE discount_coupons (
coupons_id VARCHAR(32) NOT NULL DEFAULT '',
coupons_description VARCHAR(64) NOT NULL DEFAULT '',
coupons_discount_percent DECIMAL(7,4) DEFAULT NULL,
date_start DATETIME DEFAULT NULL,
date_end DATETIME DEFAULT NULL,
max_use INT(3) NOT NULL DEFAULT 0,
min_order DECIMAL(15,4) NOT NULL DEFAULT '0.0000',
number_available INT(3) DEFAULT 0 NOT NULL,
PRIMARY KEY (coupons_id)
);
CREATE TABLE discount_coupons_to_orders (
discount_coupons_to_orders_id INT(11) NOT NULL AUTO_INCREMENT,
coupons_id VARCHAR(32) DEFAULT NULL,
orders_id INT(11) DEFAULT '0',
PRIMARY KEY (discount_coupons_to_orders_id),
KEY coupons_id (coupons_id)
);
I can't find a place to do this-can some one direct me to where this goes?
thanks
http://www.oscommerce.com/community/contributions,4269/category,all/search,discount+coupon
and I get so far in intalation til this point:
**************** STEP 2 ****************
Create the database tables
Run these statements via the SQL tab in phpMyAdmin.
CREATE TABLE discount_coupons (
coupons_id VARCHAR(32) NOT NULL DEFAULT '',
coupons_description VARCHAR(64) NOT NULL DEFAULT '',
coupons_discount_percent DECIMAL(7,4) DEFAULT NULL,
date_start DATETIME DEFAULT NULL,
date_end DATETIME DEFAULT NULL,
max_use INT(3) NOT NULL DEFAULT 0,
min_order DECIMAL(15,4) NOT NULL DEFAULT '0.0000',
number_available INT(3) DEFAULT 0 NOT NULL,
PRIMARY KEY (coupons_id)
);
CREATE TABLE discount_coupons_to_orders (
discount_coupons_to_orders_id INT(11) NOT NULL AUTO_INCREMENT,
coupons_id VARCHAR(32) DEFAULT NULL,
orders_id INT(11) DEFAULT '0',
PRIMARY KEY (discount_coupons_to_orders_id),
KEY coupons_id (coupons_id)
);
I can't find a place to do this-can some one direct me to where this goes?
thanks