#
# Table structure for table 'tx_p123_coupon'
#
CREATE TABLE tx_p123_coupon (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
    crdate int(11) unsigned DEFAULT '0' NOT NULL,
    fe_cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
    hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
    deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,

    coupon_name tinytext NOT NULL,
    coupon_conf tinytext,
    coupon_used tinyint(1) unsigned DEFAULT '0' NOT NULL,
    coupon_count tinyint(4) unsigned DEFAULT '0',
    coupon_price float(2) DEFAULT '0.0',
    coupon_ext tinytext,
    coupon_pos tinytext,
    coupon_unique tinyint(4) unsigned DEFAULT '0',
    coupon_coupon tinytext,
    coupon_combined tinytext,
    coupon_min tinyint(1) unsigned DEFAULT '0',
    coupon_max tinyint(1) unsigned DEFAULT '0',

    PRIMARY KEY (uid),
    KEY parent (pid)
);

