[imp] Feeling stupid

[Ilya]

while of course it wont hurt to have  horde_prefs column
object_pgppublickey, i do not believe it will be used. I have checked sql
scripts for horde, and it is not there. or am i missing something?

private and public keys for owner of login are stored as horde_pref object.



On Tue, Apr 16, 2002 at 07:47:07PM -0400, m.ibarra@cdcixis-na.com wrote:
> >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
> 
> -- 
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>