summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'Echo/db_patches/patch-multiple_target_pages.sql')
-rw-r--r--Echo/db_patches/patch-multiple_target_pages.sql3
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);