-- ALTER TABLE affiliation_FLI_SCHEMA.clic ADD COLUMN clic_id_shard BIGINT DEFAULT affiliation_FLI_SCHEMA.next_id_shard();
/*ALTER TABLE affiliation_FLI_SCHEMA.clic ALTER COLUMN clic_id_shard SET DEFAULT affiliation_FLI_SCHEMA.next_id_shard();
ALTER TABLE affiliation_FLI_SCHEMA.clic ALTER COLUMN clic_id_shard SET NOT NULL;*/

DROP TABLE IF EXISTS affiliation_FLI_SCHEMA.clic CASCADE;
DROP TABLE IF EXISTS affiliation_FLI_SCHEMA.affichage CASCADE;
DROP TABLE IF EXISTS affiliation_FLI_SCHEMA.lead CASCADE;
DROP TABLE IF EXISTS affiliation_FLI_SCHEMA.vente CASCADE;