Add table structure for coupon_targets.

interchange · Sep 3, 2010 · 222f431 · 222f431
1 parent 8fdabf3
commit 222f431
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)
+);