in an effort to reduce the size of my database I accidentally deleted the piwik_log_link_visit_action table (it was huge and I thought it could be deleted just like the archives). Now Piwik, rightfully I guess, tells me this:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_link_visit_action.idvisitor' in 'field list'
How can I fix that? I can use PhpMyAdmin and I created a new table with that name and 5 fields but I don’t know much about Databases and here I am stuck.
Is there a way to create this like an empty table so Piwik can still use the data from piwik_log_visit ?