CREATE TABLE `coupons` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`coupons_code` VARCHAR( 16 ) NOT NULL ,
`coupons_start` DATE NOT NULL ,
`coupons_end` DATE NOT NULL ,
`coupons_linktype` VARCHAR( 12 ) NOT NULL ,
`coupons_discountamount` DECIMAL( 9, 2 ) NOT NULL ,
`coupons_discounttype` VARCHAR( 12 ) NOT NULL ,
UNIQUE ( `coupons_code` ) 
)