-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : sam. 21 mars 2026 à 14:05
-- Version du serveur : 8.4.7
-- Version de PHP : 8.3.28

START TRANSACTION;



--
-- Base de données : `organizer`
--

-- --------------------------------------------------------

--
-- Structure de la table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `cat` varchar(10) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(180) DEFAULT NULL,
  `status` varchar(20) NOT NULL,
  `next_action` longtext,
  `last_contact` date DEFAULT NULL,
  `note` longtext,
  `created_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4C62E638A76ED395` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `contact_history`
--

CREATE TABLE IF NOT EXISTS `contact_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `note` longtext NOT NULL,
  `created_at` datetime NOT NULL,
  `contact_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BD9551CAE7A1254A` (`contact_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `doctrine_migration_versions`
--

CREATE TABLE IF NOT EXISTS `doctrine_migration_versions` (
  `version` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `doctrine_migration_versions`
--

INSERT INTO `doctrine_migration_versions` (`version`, `executed_at`, `execution_time`) VALUES
('DoctrineMigrations\\Version20260321122742', '2026-03-21 13:27:51', 284),
('DoctrineMigrations\\Version20260321124910', '2026-03-21 13:49:20', 470);

-- --------------------------------------------------------

--
-- Structure de la table `formation`
--

CREATE TABLE IF NOT EXISTS `formation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `type` varchar(10) NOT NULL,
  `day_of_week` smallint NOT NULL,
  `duration` int NOT NULL,
  `done` tinyint NOT NULL,
  `created_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_404021BFA76ED395` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `memo`
--

CREATE TABLE IF NOT EXISTS `memo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` longtext NOT NULL,
  `priority` varchar(20) NOT NULL,
  `category` varchar(50) DEFAULT NULL,
  `cat` varchar(10) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AB4A902AA76ED395` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `memo`
--

INSERT INTO `memo` (`id`, `text`, `priority`, `category`, `cat`, `created_at`, `user_id`) VALUES
(1, 'nono', 'urgent', 'idee', '', '2026-03-21 14:55:32', 1);

-- --------------------------------------------------------

--
-- Structure de la table `messenger_messages`
--

CREATE TABLE IF NOT EXISTS `messenger_messages` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `body` longtext NOT NULL,
  `headers` longtext NOT NULL,
  `queue_name` varchar(190) NOT NULL,
  `created_at` datetime NOT NULL,
  `available_at` datetime NOT NULL,
  `delivered_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_75EA56E0FB7336F0E3BD61CE16BA31DBBF396750` (`queue_name`,`available_at`,`delivered_at`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `micro_action`
--

CREATE TABLE IF NOT EXISTS `micro_action` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL,
  `duration` int NOT NULL,
  `done` tinyint NOT NULL,
  `step_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_286C516C73B21E9C` (`step_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `objectif`
--

CREATE TABLE IF NOT EXISTS `objectif` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` longtext NOT NULL,
  `priority` varchar(20) NOT NULL,
  `completed` tinyint NOT NULL,
  `created_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E2F86851A76ED395` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `planning_event`
--

CREATE TABLE IF NOT EXISTS `planning_event` (
  `id` int NOT NULL AUTO_INCREMENT,
  `week_start_date` date NOT NULL,
  `day_of_week` smallint NOT NULL,
  `start_time` varchar(5) NOT NULL,
  `end_time` varchar(5) NOT NULL,
  `text` longtext NOT NULL,
  `type` varchar(20) DEFAULT NULL,
  `cat` varchar(10) DEFAULT NULL,
  `alert` varchar(5) DEFAULT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AA02B038A76ED395` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project`
--

CREATE TABLE IF NOT EXISTS `project` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `priority` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2FB3D0EEA76ED395` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project_step`
--

CREATE TABLE IF NOT EXISTS `project_step` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `position` int NOT NULL,
  `project_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7A283624166D1F9C` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `rappel`
--

CREATE TABLE IF NOT EXISTS `rappel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` longtext NOT NULL,
  `priority` varchar(20) NOT NULL,
  `cat` varchar(10) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_303A29C9A76ED395` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `revue_semaine`
--

CREATE TABLE IF NOT EXISTS `revue_semaine` (
  `id` int NOT NULL AUTO_INCREMENT,
  `week_start_date` date NOT NULL,
  `victoires` longtext,
  `non_faites` longtext,
  `bien` longtext,
  `mal` longtext,
  `apprentissage` longtext,
  `priorites` longtext,
  `objectif_formation` longtext,
  `engagement_kaizen` longtext,
  `score_productivite` smallint NOT NULL,
  `score_equilibre` smallint NOT NULL,
  `score_bien_etre` smallint NOT NULL,
  `bilan` longtext,
  `notes_pro` longtext,
  `notes_perso` longtext,
  `updated_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_week` (`week_start_date`),
  KEY `IDX_1F09332CA76ED395` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `routine`
--

CREATE TABLE IF NOT EXISTS `routine` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slot` varchar(10) NOT NULL,
  `label` varchar(255) NOT NULL,
  `checked` tinyint NOT NULL,
  `checked_date` date DEFAULT NULL,
  `position` int NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4BF6D8D6A76ED395` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `task`
--

CREATE TABLE IF NOT EXISTS `task` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `text` longtext NOT NULL,
  `priority` varchar(20) NOT NULL,
  `category` varchar(30) DEFAULT NULL,
  `completed` tinyint NOT NULL,
  `created_at` datetime NOT NULL,
  `user_id` int NOT NULL,
  `project_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_527EDB25A76ED395` (`user_id`),
  KEY `IDX_527EDB25166D1F9C` (`project_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `task`
--

INSERT INTO `task` (`id`, `type`, `text`, `priority`, `category`, `completed`, `created_at`, `user_id`, `project_id`) VALUES
(1, 'perso', 'acheter une pomme', 'urgent', 'sante', 0, '2026-03-21 14:44:10', 1, NULL);
COMMIT;

