From 60920d3a88a780ef144cc6ae01c585f9fc0d4c9e Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 4 Jan 2013 10:30:38 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 8fbe3096..8d1f08ac 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -13,7 +13,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 comptype varchar(32) NOT NULL DEFAULT ''; @@ -33,7 +33,7 @@ ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11); ALTER TABLE Companies CHANGE COLUMN comptype comptype VARCHAR(32) DEFAULT ''; ALTER TABLE Companies ADD COLUMN comptype_id INT(11) DEFAULT 0; -- 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