ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11);
ALTER TABLE Companies CHANGE COLUMN comptype comptype VARCHAR(32) 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;
ALTER TABLE Companies ALTER url SET DEFAULT '';
-- postres
ALTER TABLE Companies ALTER isOwner TYPE int(11);
ALTER TABLE Companies ALTER owner_id SET DEFAULT 0;
ALTER TABLE Companies ALTER url SET DEFAULT '';
ALTER TABLE Office ADD COLUMN company_id int(11) NOT NULL default '0';
ALTER TABLE Office ADD COLUMN name varchar(64) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN address text ;
ALTER TABLE Office ADD COLUMN company_id int(11) NOT NULL default '0';
ALTER TABLE Office ADD COLUMN name varchar(64) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN address text ;
ALTER TABLE Office ADD COLUMN phone varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN fax varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN email varchar(128) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN role varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN phone varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN fax varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN email varchar(128) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN role varchar(32) NOT NULL DEFAULT '';