-- Script de création de la table credentials
-- Exécuter ce script dans votre base de données MySQL

CREATE TABLE IF NOT EXISTS `credentials` (
  `uid` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `credentials_json` text NOT NULL,
  `path_domain` text NOT NULL,
  `nom` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid`),
  KEY `idx_path_domain` (`path_domain`(255)),
  KEY `idx_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; 