From c13d3aa1cf298a0477097f637d41318e32553a60 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 14 Sep 2012 10:21:17 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 44aefd3d..aa0b3eeb 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -16,7 +16,7 @@ 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 logo_id INT(11) NOT NULL DEFAULT 0;; ALTER TABLE Companies ADD COLUMN background_color varchar(8) NOT NULL; -ALTER TABLE Companies ADD COLUMN comptype varchar(8) NOT NULL DEFAULT ''; +ALTER TABLE Companies ADD COLUMN comptype varchar(32) NOT NULL DEFAULT ''; ALTER TABLE Companies ADD COLUMN url varchar(254) NOT NULL DEFAULT ''; ALTER TABLE Companies ADD COLUMN main_office_id int(11) NOT NULL DEFAULT 0; ALTER TABLE Companies ADD COLUMN created_by int(11) NOT NULL DEFAULT 0; @@ -30,6 +30,7 @@ ALTER TABLE Companies ADD COLUMN country varchar(4) NOT NULL DEFAULT ''; 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 owner_id SET DEFAULT 0; -- 2.39.2