[wellwell-devel] [wellwell] Add missing primary key to coupons table definition.

Stefan Hornburg wellwell-devel at rt.icdevgroup.org
Tue Jul 20 14:13:58 UTC 2010


commit e6332f5388d6238cface3d641ed9abf7a24e5a65
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Tue Jul 20 16:13:38 2010 +0200

    Add missing primary key to coupons table definition.

 plugins/coupons/database/mysql/coupons.sql |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)
---
diff --git a/plugins/coupons/database/mysql/coupons.sql b/plugins/coupons/database/mysql/coupons.sql
index 7c9c6c8..6b7a038 100644
--- a/plugins/coupons/database/mysql/coupons.sql
+++ b/plugins/coupons/database/mysql/coupons.sql
@@ -1,5 +1,6 @@
 CREATE TABLE coupons (
 	code int NOT NULL auto_increment,
 	coupon_number varchar(32) not null default '',
-    amount decimal(11,2) NOT NULL DEFAULT 0
+    amount decimal(11,2) NOT NULL DEFAULT 0,
+	PRIMARY KEY(code)
 );



More information about the wellwell-devel mailing list