[imp] Feeling stupid

m.ibarra@cdcixis-na.com m.ibarra@cdcixis-na.com
Tue, 16 Apr 2002 19:47:07 -0400


>From Chucks answer to this same question I posted.

You want the second option, I had to change table names
in turba as well. So,

ALTER TABLE tablename ADD COLUMN fieldname field_type options

becomes

mysql -u root -p

mysql> use horde;

mysql> alter table horde_prefs add column object_pgppublickey text;

mysql> alter table turba_objects add column object_pgppublickey text;

Hope this helps, afaik, it can't hurt because you can always drop it.

-mike

PS I ran flush privileges, don't know if I had to or not.

-----Original Message-----
From: Chuck Hagenbuch [mailto:chuck@horde.org]
Sent: Monday, April 15, 2002 12:21 PM
To: turba@lists.horde.org
Subject: RE: [turba] Changes in table to all lower (???)


Quoting m.ibarra@cdcixis-na.com:

> OK, sorry for this off topic question, but how do I
> change the name of a column within a table in mysql?
> as well as add a column within a table (for the pgp
> addon).

ALTER TABLE tablename CHANGE COLUMN old_fieldname new_fieldname field_type 
    options

and

ALTER TABLE tablename ADD COLUMN fieldname field_type options

-chuck


-----Original Message-----
From: Harry Hoffman [mailto:hhoffman@ip-solutions.net]
Sent: Tuesday, April 16, 2002 7:20 PM
To: imp@lists.horde.org
Subject: [imp] Feeling stupid


Hi All,
   I'm not sure how to update the MySQL db to allow the turba_objects to
contain
object_pgppublickey text. Can someone shed some light??

Thanks,
Harry




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

-- 
IMP mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: imp-unsubscribe@lists.horde.org