From: Alan Knowles <alan@roojs.com>
Date: Tue, 4 May 2021 07:37:48 +0000 (+0800)
Subject: Fix #6722 - add short code to suppliers
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=5d2ac7b8b3992f6990b429169713e947af4c46f2

Fix #6722 - add short code to suppliers
---

diff --git a/sql/core_company.sql b/sql/core_company.sql
index 60e7f514..cd082d2f 100644
--- a/sql/core_company.sql
+++ b/sql/core_company.sql
@@ -4,8 +4,11 @@ CREATE TABLE core_company (
 );
 
 
-ALTER TABLE core_company ADD COLUMN    code varchar(32)  NOT NULL DEFAULT '';;
-ALTER TABLE core_company ADD COLUMN    name varchar(128)  default NULL ;
+ALTER TABLE core_company CHANGE COLUMN  code  code varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE core_company ADD COLUMN    code varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE core_company CHANGE COLUMN    name name varchar(254)  default NULL ;
+
+ALTER TABLE core_company ADD COLUMN    name varchar(254)  default NULL ;
 ALTER TABLE core_company ADD COLUMN    remarks text ;
 ALTER TABLE core_company ADD COLUMN    owner_id int(11) NOT NULL DEFAULT 0 ;
 ALTER TABLE core_company ADD COLUMN    address text ;
@@ -30,8 +33,7 @@ ALTER TABLE core_company ADD COLUMN    country varchar(4) NOT NULL DEFAULT '';
 ALTER TABLE core_company ADD COLUMN    comptype varchar(32)  NOT NULL DEFAULT '';
 -- not sure if this needs to change.. << there is code in core/update that fills this in??
 ALTER TABLE core_company ADD COLUMN    comptype_id INT(11) DEFAULT 0;
-
-
+ 
 ALTER TABLE core_company CHANGE COLUMN isOwner isOwner int(11);
 ALTER TABLE core_company CHANGE COLUMN comptype comptype  VARCHAR(32) DEFAULT '';
 -- postres