-- Tabellenstruktur für Tabelle `uc_coupons`
-- 

CREATE TABLE `uc_coupons` (
  `cid` int(11) NOT NULL auto_increment,
  `name` varchar(30) character set utf8 NOT NULL default '',
  `code` varchar(40) character set utf8 NOT NULL default 'coupon_code',
  `value` decimal(6,2) NOT NULL default '0.00',
  `type` varchar(12) character set utf8 NOT NULL default 'price',
  `status` int(1) NOT NULL default '1',
  `valid_until` int(11) default NULL,
  `max_uses` int(4) NOT NULL default '0',
  `max_user_uses` int(4) NOT NULL default '0',
  `users` text character set utf8,
  `roles` text character set utf8,
  `minimum_order` decimal(6,2) NOT NULL default '0.00',
  `weight` tinyint(2) default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `uc_coupons`
-- 

INSERT INTO `uc_coupons` (`cid`, `name`, `code`, `value`, `type`, `status`, `valid_until`, `max_uses`, `max_user_uses`, `users`, `roles`, `minimum_order`, `weight`) VALUES (1, 'nick', 'nick', 1.00, 'price', 1, 1229040000, 0, 0, '', '1,2,3,', 0.00, 0);


-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `uc_coupons_orders`
-- 

CREATE TABLE `uc_coupons_orders` (
  `cuid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `oid` int(11) NOT NULL default '0',
  `value` decimal(10,2) NOT NULL default '0.00',
  `code` varchar(40) collate latin1_general_ci NOT NULL default 'default_code',
  PRIMARY KEY  (`cuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `uc_coupons_orders`
-- 

INSERT INTO `uc_coupons_orders` (`cuid`, `cid`, `oid`, `value`, `code`) VALUES (1, 1, 26, 1.00, 'nick');