From e4a68f9d166c5caceb53572ea3a3a198c9a2d919 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 14 Jul 2016 13:21:05 +0800 Subject: [PATCH] sql/Companies.sql --- sql/Companies.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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 ''; -- 2.39.2