CREATE TABLE `associationDirectoryEntries` (
	`id` int AUTO_INCREMENT NOT NULL,
	`nomAssociation` varchar(255) NOT NULL,
	`emailOfficiel` varchar(320),
	`emailOfficielNormalise` varchar(320),
	`siret` varchar(14),
	`rna` varchar(10),
	`adresse` text,
	`codePostal` varchar(10),
	`ville` varchar(100),
	`telephone` varchar(20),
	`siteWeb` varchar(255),
	`dateCreation` timestamp,
	`objetAssociation` text,
	`statutJuridique` enum('association_loi_1901','association_reconnue_utilite_publique','fondation','autre') DEFAULT 'association_loi_1901',
	`nomRepresentant` varchar(255),
	`fonctionRepresentant` varchar(100),
	`sourceFileName` varchar(255),
	`sourceRowNumber` int,
	`sourceFingerprint` varchar(64),
	`isActive` boolean NOT NULL DEFAULT true,
	`importedAt` timestamp NOT NULL DEFAULT now(),
	`updatedAt` timestamp NOT NULL DEFAULT now() ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `associationDirectoryEntries_id` PRIMARY KEY(`id`),
	CONSTRAINT `associationDirectoryEntries_emailOfficielNormalise_unique` UNIQUE(`emailOfficielNormalise`)
);--> statement-breakpoint
ALTER TABLE `associations` ADD `sourceDirectoryEntryId` int;--> statement-breakpoint