From: Alan Knowles <alan@roojs.com>
Date: Thu, 14 Jul 2016 05:21:05 +0000 (+0800)
Subject: sql/Companies.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=e4a68f9d166c5caceb53572ea3a3a198c9a2d919

sql/Companies.sql
---

diff --git a/sql/Companies.sql b/sql/Companies.sql
index de1966ff..b5abaf66 100644
--- a/sql/Companies.sql
+++ b/sql/Companies.sql
@@ -12,7 +12,7 @@ ALTER TABLE Companies ADD COLUMN    address text ;
 ALTER TABLE Companies ADD COLUMN    tel varchar(32)  default NULL;
 ALTER TABLE Companies ADD COLUMN    fax varchar(32)  default NULL;
 ALTER TABLE Companies ADD COLUMN    email varchar(128)  default NULL;
---ALTER TABLE Companies ADD COLUMN    isOwner int(11) default NULL;
+-- ALTER TABLE Companies ADD COLUMN    isOwner int(11) default NULL;
 ALTER TABLE Companies ADD COLUMN    logo_id INT(11)  NOT NULL DEFAULT 0;;
 ALTER TABLE Companies ADD COLUMN    background_color varchar(8)  NOT NULL;
 ALTER TABLE Companies ADD COLUMN    url varchar(254)  NOT NULL DEFAULT '';
@@ -35,7 +35,7 @@ ALTER TABLE Companies ADD COLUMN    comptype_id INT(11) DEFAULT 0;
 ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11);
 ALTER TABLE Companies CHANGE COLUMN comptype comptype  VARCHAR(32) DEFAULT '';
 -- postres
---ALTER TABLE Companies ALTER isOwner TYPE int(11);
+-- ALTER TABLE Companies ALTER isOwner TYPE int(11);
 ALTER TABLE Companies ALTER owner_id SET DEFAULT 0;
 ALTER TABLE Companies ALTER url SET DEFAULT '';