Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sql help


sheltonjb

Recommended Posts

hi, i've no knowledge of databases and just got gary's discount code contribution, it has a bunch of text in it, this:

 

CREATE TABLE coupon_to_customer (

coupon_id int(11) NOT NULL default '0',

customer_id int(11) NOT NULL default '0',

order_id int(11) NOT NULL default '0',

redeem_date datetime NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY (coupon_id,customer_id,order_id)

) TYPE=MyISAM;

 

CREATE TABLE coupons (

coupon_id int(11) NOT NULL auto_increment,

coupon_code varchar(32) NOT NULL default '',

coupon_amount decimal(15,4) NOT NULL default '0.0000',

coupon_type tinyint(1) NOT NULL default '0',

coupon_status tinyint(1) NOT NULL default '0',

coupon_use tinyint(1) NOT NULL default '0',

PRIMARY KEY (coupon_id)

) TYPE=MyISAM;

 

it's for the database but i'm in phpmyadmin and havent got a clue where to put it, any help please folks?!?

 

Shelton

Shelton Brown

Web/Graphic Designer

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...