Add weight, length, width, and height fields to the product table

diff --git a/schema/bse.sql b/schema/bse.sql
index c4a0da1cc042247c998e8b8b0f55ca2c5aef21a1..4263df52ead711a1a81d784aa16f33f342bb2807 100644 (file)
--- a/schema/bse.sql
+++ b/schema/bse.sql
@@ -185,6 +185,12 @@ create table product (
   subscription_required integer not null default -1,
 
   product_code varchar(80) not null,
+
+  -- properties relevant to calculating shipping cost
+  weight integer not null,
+  length integer not null default 0,
+  width integer not null default 0,
+  height integer not null default 0,
   
   primary key(articleId)
 );
@@ -859,4 +865,4 @@ create table bse_order_item_options (
   display varchar(80) not null,
   display_order integer not null,
   index item_order(order_item_id, display_order)
-) type=innodb;
\ No newline at end of file
+) type=innodb;