Add table structure for coupon_targets.

interchange · Sep 15, 2010 · 218bd08 · 218bd08
1 parent 19cdc04
commit 218bd08
Showing 1 changed file with 7 additions and 0 deletions.
diff --git a/plugins/coupons/database/mysql/coupon_targets.sql b/plugins/coupons/database/mysql/coupon_targets.sql
@@ -0,0 +1,7 @@
+CREATE TABLE coupon_targets (
+	code int NOT NULL auto_increment,
+    discount_code int NOT NULL,
+	value varchar(255) NOT NULL default '',
+	PRIMARY KEY(code),
+	KEY(discount_code)
+);