• Home
• com.serphacker.serposcope
• core
• 2.10.0
• source code
• 3-4.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.patch.3-4.sql Maven / Gradle / Ivy

delete from `GOOGLE_SERP` where run_id in (select id from `RUN` where group_id is not null);
delete from `GOOGLE_RANK` where run_id in (select id from `RUN` where group_id is not null);
delete from `GOOGLE_TARGET_SUMMARY` where run_id in (select id from `RUN` where group_id is not null);
drop table if exists `GROUP_RUN`;
delete from `RUN` where group_id is not null;
alter table `RUN` drop column `group_id`;


INSERT INTO `CONFIG` VALUES ('app.dbversion','4') ON DUPLICATE KEY UPDATE `value` = '4';