Change Details

The echo_target_page table currently represents a page that, when visited, will automatically mark the relevant notification as read. This feature is being expanded to allow multiple target pages for a specific notification. To acomplish that the unique index currently acting as a primary key needs to be dropped and replaced with a standard index. Since this primary key is being dropped it also needs a new auto_increment primary key added ALTER TABLE /*_*/echo_target_page ADD etp_id int unsigned not null primary key auto_increment; DROP INDEX /*i*/echo_target_page_user_event ON /*_*/echo_target_page; CREATE INDEX /*i*/echo_target_page_user_event ON /*_*/echo_target_page (etp_user, etp_event);