CREATE OR REPLACE FUNCTION affiliation_FLI_SCHEMA.next_clic_id_shard(OUT result bigint) AS $$
DECLARE
    our_epoch bigint := 1177977600000;
    seq_id bigint;
    now_millis bigint;
    shard_id int := FLI_SCHEMA;
BEGIN
    SELECT nextval('affiliation_FLI_SCHEMA.clic_clic_id_seq') % 1024 INTO seq_id;

    SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;
    result := (now_millis - our_epoch) << 23;
    result := result | (shard_id << 10);
    result := result | (seq_id);
END;
$$ LANGUAGE PLPGSQL;
ALTER FUNCTION affiliation_FLI_SCHEMA.next_clic_id_shard() OWNER TO FLI_USER;

ALTER TABLE affiliation_FLI_SCHEMA.clic ADD COLUMN clic_id_shard BIGINT DEFAULT affiliation_FLI_SCHEMA.next_clic_id_shard();
ALTER TABLE affiliation_FLI_SCHEMA.clic ADD COLUMN clic_id_shard_migration BIGINT;


CREATE OR REPLACE FUNCTION affiliation_FLI_SCHEMA.next_affichage_id_shard(OUT result bigint) AS $$
DECLARE
    our_epoch bigint := 1177977600000;
    seq_id bigint;
    now_millis bigint;
    shard_id int := FLI_SCHEMA;
BEGIN
    SELECT nextval('affiliation_FLI_SCHEMA.affichage_affichage_id_seq') % 1024 INTO seq_id;

    SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;
    result := (now_millis - our_epoch) << 23;
    result := result | (shard_id << 10);
    result := result | (seq_id);
END;
$$ LANGUAGE PLPGSQL;
ALTER FUNCTION affiliation_FLI_SCHEMA.next_affichage_id_shard() OWNER TO FLI_USER;

ALTER TABLE affiliation_FLI_SCHEMA.affichage ADD COLUMN affichage_id_shard BIGINT DEFAULT affiliation_FLI_SCHEMA.next_affichage_id_shard();
ALTER TABLE affiliation_FLI_SCHEMA.affichage ADD COLUMN affichage_id_shard_migration BIGINT;



CREATE OR REPLACE FUNCTION affiliation_FLI_SCHEMA.next_lead_id_shard(OUT result bigint) AS $$
DECLARE
    our_epoch bigint := 1177977600000;
    seq_id bigint;
    now_millis bigint;
    shard_id int := FLI_SCHEMA;
BEGIN
    SELECT nextval('affiliation_FLI_SCHEMA.lead_lead_id_seq') % 1024 INTO seq_id;

    SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;
    result := (now_millis - our_epoch) << 23;
    result := result | (shard_id << 10);
    result := result | (seq_id);
END;
$$ LANGUAGE PLPGSQL;
ALTER FUNCTION affiliation_FLI_SCHEMA.next_lead_id_shard() OWNER TO FLI_USER;

ALTER TABLE affiliation_FLI_SCHEMA.lead ADD COLUMN lead_id_shard BIGINT DEFAULT affiliation_FLI_SCHEMA.next_lead_id_shard();
ALTER TABLE affiliation_FLI_SCHEMA.lead ADD COLUMN lead_clic_shard BIGINT DEFAULT 0;
ALTER TABLE affiliation_FLI_SCHEMA.lead ADD COLUMN lead_affichage_shard BIGINT DEFAULT 0;
ALTER TABLE affiliation_FLI_SCHEMA.lead ADD COLUMN lead_id_shard_migration BIGINT;



CREATE OR REPLACE FUNCTION affiliation_FLI_SCHEMA.next_vente_id_shard(OUT result bigint) AS $$
DECLARE
    our_epoch bigint := 1177977600000;
    seq_id bigint;
    now_millis bigint;
    shard_id int := FLI_SCHEMA;
BEGIN
    SELECT nextval('affiliation_FLI_SCHEMA.vente_vente_id_seq') % 1024 INTO seq_id;

    SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;
    result := (now_millis - our_epoch) << 23;
    result := result | (shard_id << 10);
    result := result | (seq_id);
END;
$$ LANGUAGE PLPGSQL;
ALTER FUNCTION affiliation_FLI_SCHEMA.next_vente_id_shard() OWNER TO FLI_USER;

ALTER TABLE affiliation_FLI_SCHEMA.vente ADD COLUMN vente_id_shard BIGINT DEFAULT affiliation_FLI_SCHEMA.next_vente_id_shard();
ALTER TABLE affiliation_FLI_SCHEMA.vente ADD COLUMN vente_clic_shard BIGINT DEFAULT 0;
ALTER TABLE affiliation_FLI_SCHEMA.vente ADD COLUMN vente_affichage_shard BIGINT DEFAULT 0;
ALTER TABLE affiliation_FLI_SCHEMA.vente ADD COLUMN vente_id_shard_migration BIGINT;