Hi all,

Would like to have a serial primary key on the currencyapi table. That way my db-editor (Webmin) can edit rows or delete them in case of bad data from the exchange rates provider. Now I can only truncate the whole table and hope that the exchange rates will all be good when I get new ones. Patch coming.

CommentFileSizeAuthor
#2 add_primary_key-1225222-2.patch2.59 KBsplash112
#1 add_primary_key-1225222.patch1.8 KBsplash112

Comments

splash112’s picture

splash112 commented
StatusFileSize
new add_primary_key-1225222.patch1.8 KB

And the patch

ps. had to create another column first and change that to serial, so the update function looks a little odd. Sadly, no real other way around it afaik.

splash112’s picture

splash112 commented
StatusFileSize
new add_primary_key-1225222-2.patch2.59 KB

Sorry, forgot to edit the module

amateescu’s picture

amateescu commented
Status: Active » Closed (won't fix)

Sorry for replying so late.. but I don't think there's a real need for this change in the current stable release.