From e6d47d438b6862f3fd2640deb43762723023e297 Mon Sep 17 00:00:00 2001 From: Maxime Bourget Date: Sat, 4 May 2013 12:08:16 +0100 Subject: [PATCH] Hooks to alter/clean table work! --- hooks.php | 4 ++-- sql/clean_sales_order_details.sql | 4 ++++ 2 files changed, 6 insertions(+), 2 deletions(-) create mode 100644 sql/clean_sales_order_details.sql diff --git a/hooks.php b/hooks.php index 70d4948..1f571a5 100644 --- a/hooks.php +++ b/hooks.php @@ -9,7 +9,7 @@ define ('SS_ORDERLINEX', 131<<8); class hooks_order_line_extra extends hooks { - var $module_name = 'Order Line Extra'; + var $module_name = 'order_line_extra'; /* Install additonal menu options provided by module @@ -36,7 +36,7 @@ class hooks_order_line_extra extends hooks { global $db_connections; $updates = array( - 'alter_sales_order_details.sql' => array('0_sales_order_details', 'required_date') + 'alter_sales_order_details.sql' => array('sales_order_details', 'required_date') ); return $this->update_databases($company, $updates, $check_only); diff --git a/sql/clean_sales_order_details.sql b/sql/clean_sales_order_details.sql new file mode 100644 index 0000000..2b5fc16 --- /dev/null +++ b/sql/clean_sales_order_details.sql @@ -0,0 +1,4 @@ +ALTER TABlE 0_sales_order_details +DROP COLUMN required_date , +DROP COLUMN comments , +DROP COLUMN priority ; -- 2.30.2