'use strict';

exports.up = function(db, cb) {
    db.runSql(
        `
    ALTER TABLE client_instances ADD PRIMARY KEY (app_name, instance_id);
  `,
        cb,
    );
};

exports.down = function(db, cb) {
    db.runSql(
        `
        ALTER TABLE client_instances DROP CONSTRAINT client_instances_pkey;
        DROP INDEX client_instance_pkey
    `,
        cb,
    );
};

@@ -61,24 +61,181 @@
 (%0A        %60%0A
+    DELETE FROM client_instances a USING client_instances b WHERE a.app_name = b.app_name AND a.instance_id = b.instance_id AND a.created_at %3C b.created_at;%0A
     ALTER TA
@@ -478,16 +478,26 @@
 P INDEX 
+IF EXISTS 
 client_i

delete duplicate client instances