YovoAds

Это старая версия документа!

---

    CREATE TABLE IF NOT EXISTS shows_new LIKE shows;
    INSERT INTO shows_new SELECT * FROM shows WHERE EventTimeStamp >= unix_timestamp(AddDate(Now(),interval -14 day));
     ALTER TABLE shows RENAME TO shows_old;
    ALTER TABLE shows_new RENAME TO shows;
    DROP TABLE shows_old;
    
    TRUNCATE TABLE failed;
    
    CREATE TABLE IF NOT EXISTS clicks_new LIKE clicks;
    INSERT INTO clicks_new SELECT * FROM clicks WHERE EventTimeStamp >= unix_timestamp(AddDate(Now(),interval -60 day));
    ALTER TABLE clicks RENAME TO clicks_old;
    ALTER TABLE clicks_new RENAME TO clicks;
    DROP TABLE clicks_old;
    
    CREATE TABLE IF NOT EXISTS redirects_new LIKE redirects;
    INSERT INTO redirects_new SELECT * FROM redirects WHERE EventTimeStamp >= unix_timestamp(AddDate(Now(),interval -30 day));
    ALTER TABLE redirects RENAME TO redirects_old;
    ALTER TABLE redirects_new RENAME TO redirects;
    DROP TABLE redirects_old;