[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