From 46a0cd122367576da823e0ec3d84f5c97d97e7c3 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 8 Apr 2009 19:57:31 +0000 Subject: [PATCH] Longer customer name field. --- sales/manage/customers.php | 2 +- sql/alter2.2.php | 2 +- sql/alter2.2.sql | 2 ++ sql/en_US-demo.sql | 2 +- sql/en_US-new.sql | 2 +- 5 files changed, 6 insertions(+), 4 deletions(-) diff --git a/sales/manage/customers.php b/sales/manage/customers.php index 87389b60..dd77466b 100644 --- a/sales/manage/customers.php +++ b/sales/manage/customers.php @@ -240,7 +240,7 @@ else table_section_title(_("Name and Address")); -text_row(_("Customer Name:"), 'CustName', $_POST['CustName'], 40, 40); +text_row(_("Customer Name:"), 'CustName', $_POST['CustName'], 40, 80); textarea_row(_("Address:"), 'address', $_POST['address'], 35, 5); email_row(_("E-mail:"), 'email', null, 40, 40); diff --git a/sql/alter2.2.php b/sql/alter2.2.php index bcd772e1..c839df17 100644 --- a/sql/alter2.2.php +++ b/sql/alter2.2.php @@ -45,7 +45,7 @@ class fa2_2 { if (check_table($pref, 'company', 'default_delivery_required')) return false; if (check_table($pref, 'stock_category', 'dflt_dim2')) return false; if (check_table($pref, 'users', 'sticky_doc_date')) return false; - return true; + return true; } }; diff --git a/sql/alter2.2.sql b/sql/alter2.2.sql index 07e80959..7167b801 100644 --- a/sql/alter2.2.sql +++ b/sql/alter2.2.sql @@ -24,3 +24,5 @@ ALTER TABLE `0_stock_category` ADD COLUMN `dflt_dim1` int(11) default NULL; ALTER TABLE `0_stock_category` ADD COLUMN `dflt_dim2` int(11) default NULL; ALTER TABLE `0_users` ADD `sticky_doc_date` TINYINT(1) DEFAULT '0'; + +ALTER TABLE `0_debtors_master` MODIFY COLUMN `name` varchar(100) NOT NULL default ''; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index af0448ad..d30c577d 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -670,7 +670,7 @@ DROP TABLE IF EXISTS `0_debtors_master`; CREATE TABLE `0_debtors_master` ( `debtor_no` int(11) NOT NULL auto_increment, - `name` varchar(60) NOT NULL default '', + `name` varchar(80) NOT NULL default '', `address` tinytext, `email` varchar(100) NOT NULL default '', `tax_id` varchar(55) NOT NULL default '', diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 3131e6b7..616bfc4f 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -507,7 +507,7 @@ DROP TABLE IF EXISTS `0_debtors_master`; CREATE TABLE `0_debtors_master` ( `debtor_no` int(11) NOT NULL auto_increment, - `name` varchar(60) NOT NULL default '', + `name` varchar(80) NOT NULL default '', `address` tinytext, `email` varchar(100) NOT NULL default '', `tax_id` varchar(55) NOT NULL default '', -- 2.30.2