CREATE OR REPLACE FUNCTION affiliation_FLI_SCHEMA.next_clic_id_shard_migration( IN seq_id bigint, IN date_epoch bigint, OUT result bigint) AS $$
DECLARE
    our_epoch bigint := 1177977600000;
    shard_id int := FLI_SCHEMA;
BEGIN
    result := (date_epoch - 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;