On Tue, Jan 27, 2009 at 02:12:15PM +0100, Davide Alberani wrote:
> What we need is a way to execute a SQL statement like (for MySQL):
> ALTER TABLE my_info ADD FOREIGN KEY (kind_id) REFERENCES info_type;
The question was 'how to add', not 'how to change'. SQLObject cannot
change column types, but you can just execute the query:
connection.query('ALTER TABLE my_info ADD FOREIGN KEY (kind_id) REFERENCES
info_type')
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
