X-Git-Url: http://git.imager.perl.org/bse.git/blobdiff_plain/edfb4d9407659b3bcc0aaa5b947df523958d1055..b55d4af1f019abe979f7eb407d53c9e7d048a6e0:/site/util/mysql.str

diff --git a/site/util/mysql.str b/site/util/mysql.str
index 457e3ac8..b1274a55 100644
--- a/site/util/mysql.str
+++ b/site/util/mysql.str
@@ -183,10 +183,12 @@ Column code;varchar(40);NO;NULL;
 Column description;text;NO;NULL;
 Column release;date;NO;NULL;
 Column expiry;date;NO;NULL;
-Column discount_percent;double;NO;NULL;
+Column discount_percent;double;YES;NULL;
 Column campaign;varchar(20);NO;NULL;
 Column last_modified;datetime;NO;NULL;
 Column untiered;int(11);NO;0;
+Column classid;varchar(20);NO;bse_simple;
+Column config;blob;NO;NULL;
 Index PRIMARY;1;[id]
 Index codes;1;[code]
 Table bse_file_access_log
@@ -598,6 +600,8 @@ Column max_lapsed;int(11);NO;0;
 Column session_id;int(11);NO;-1;
 Column product_code;varchar(80);NO;;
 Column tier_id;int(11);YES;NULL;
+Column product_discount;int(11);NO;0;
+Column product_discount_units;int(11);NO;0;
 Index PRIMARY;1;[id]
 Index order_item_order;0;[orderId;id]
 Index tier_id;0;[tier_id]
@@ -680,8 +684,11 @@ Column stage;varchar(20);NO;;
 Column ccPAN;varchar(4);NO;;
 Column paid_manually;int(11);NO;0;
 Column coupon_id;int(11);YES;NULL;
-Column coupon_code_discount_pc;double;NO;0;
+Column coupon_code_discount_pc;double;YES;0;
 Column delivery_in;int(11);YES;NULL;
+Column product_cost_discount;int(11);NO;0;
+Column coupon_cart_wide;int(11);NO;1;
+Column coupon_description;varchar(255);NO;;
 Index PRIMARY;1;[id]
 Index order_cchash;0;[ccNumberHash]
 Index order_coupon;0;[coupon_id]