Sorry kein zeit dafüf aber Tabelle ist
ZitatAlles anzeigenCREATE TABLE IF NOT EXISTS `coupons` (
`coupon_id` int(11) NOT NULL AUTO_INCREMENT,
`coupon_type` char(1) NOT NULL DEFAULT 'F',
`coupon_code` varchar(32) NOT NULL DEFAULT '',
`coupon_amount` decimal(8,4) NOT NULL DEFAULT '0.0000',
`coupon_minimum_order` decimal(8,4) NOT NULL DEFAULT '0.0000',
`coupon_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`coupon_expire_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`uses_per_coupon` int(5) NOT NULL DEFAULT '1',
`uses_per_user` int(5) NOT NULL DEFAULT '0',
`restrict_to_products` varchar(255) DEFAULT NULL,
`restrict_to_categories` varchar(255) DEFAULT NULL,
`restrict_to_customers` text,
`coupon_active` char(1) NOT NULL DEFAULT 'Y',
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;