# Remove the private columns as they are no longer needed
# (the privacy status is now held in the status column)

ALTER TABLE %DB_TBL_PREFIX%entry 
DROP COLUMN private;

ALTER TABLE %DB_TBL_PREFIX%repeat 
DROP COLUMN private;