diff options
Diffstat (limited to 'Echo/db_patches/patch-multiple_target_pages.sql')
-rw-r--r-- | Echo/db_patches/patch-multiple_target_pages.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/Echo/db_patches/patch-multiple_target_pages.sql b/Echo/db_patches/patch-multiple_target_pages.sql new file mode 100644 index 00000000..5d574f95 --- /dev/null +++ b/Echo/db_patches/patch-multiple_target_pages.sql @@ -0,0 +1,3 @@ +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); |