Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

sql help


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)



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)



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



Shelton Brown

Web/Graphic Designer

Link to comment
Share on other sites


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

  • Create New...