Great solution Redwine but seems that you forgot the most important part...
Without setting the links status table to accept "pending", it will set it empty...
I had to search for your other posts to find a solution...
Code:
alter TABLE table prefix_links
change link_status link_status enum('discard','queued','published','abuse','duplicated','pending') NOT NULL default 'discard'
;
Again thanks for the trick and the tutorial