save the product tier on ordering

[bse.git] / site / util / mysql.str

diff --git a/site/util/mysql.str b/site/util/mysql.str
index 2bf7bfb180c827d2b4511c987d5e4b75aa1f3edb..457e3ac88b89b7ce37b9a6a9ff1e3bdca388c87f 100644 (file)
--- a/site/util/mysql.str
+++ b/site/util/mysql.str
@@ -125,8 +125,9 @@ Column name;varchar(20);NO;NULL;
 Column content_type;varchar(80);NO;text/plain;
 Column value;longblob;NO;NULL;
 Column appdata;int(11);NO;0;
+Column owner_type;varchar(20);NO;bse_file;
 Index PRIMARY;1;[id]
-Index file_name;1;[file_id;name]
+Index file_name;1;[file_id;owner_type;name]
 Table bse_article_groups
 Engine InnoDB
 Column article_id;int(11);NO;NULL;
@@ -596,8 +597,10 @@ Column subscription_period;int(11);NO;0;
 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;
 Index PRIMARY;1;[id]
 Index order_item_order;0;[orderId;id]
+Index tier_id;0;[tier_id]
 Table orders
 Engine InnoDB
 Column id;int(11);NO;NULL;auto_increment
@@ -676,10 +679,12 @@ Column freight_tracking;varchar(255);NO;;
 Column stage;varchar(20);NO;;
 Column ccPAN;varchar(4);NO;;
 Column paid_manually;int(11);NO;0;
-Column coupon_code;varchar(40);NO;;
+Column coupon_id;int(11);YES;NULL;
 Column coupon_code_discount_pc;double;NO;0;
+Column delivery_in;int(11);YES;NULL;
 Index PRIMARY;1;[id]
 Index order_cchash;0;[ccNumberHash]
+Index order_coupon;0;[coupon_id]
 Index order_userId;0;[userId;orderDate]
 Table other_parents
 Engine InnoDB
@@ -713,7 +718,7 @@ Column width;int(11);NO;0;
 Column height;int(11);NO;0;
 Index PRIMARY;1;[articleId]
 Table searchindex
-Engine InnoDB
+Engine MyISAM
 Column id;varbinary(200);NO;;
 Column articleIds;varchar(255);NO;;
 Column sectionIds;varchar(255);NO;;