dbDeltafunction examines the current table structure, compares it to the desired table structure, and either adds or modifies the table as necessary, so it can be very handy for updates.
dbDeltafunction is rather picky, however. For instance:
PRIMARY KEYand the definition of your primary key.
KEYrather than its synonym
INDEXand you must include at least one KEY.
CREATE TABLEmust be capitalised.