-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : mar. 19 avr. 2022 à 17:18
-- Version du serveur :  8.0.28-0ubuntu0.20.04.3
-- Version de PHP : 7.4.28

START TRANSACTION;



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

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

--
-- Structure de la table `action`
--

CREATE TABLE `action` (
  `id` int NOT NULL,
  `ville_depart` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ville_arrive` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `km` int NOT NULL,
  `raisons` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `heure_depart` time DEFAULT NULL,
  `heure_arrivee` time DEFAULT NULL,
  `date` date NOT NULL,
  `user_id` int NOT NULL,
  `association_id` int DEFAULT NULL,
  `duree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frais` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `frais_kilometrique` decimal(10,0) DEFAULT NULL,
  `charges` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `groupe` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dons` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heures_valorisees` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `a_payer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `action` (`id`, `ville_depart`, `ville_arrive`, `km`, `raisons`, `heure_depart`, `heure_arrivee`, `date`, `user_id`, `association_id`, `duree`, `frais`, `created_at`, `frais_kilometrique`, `charges`, `groupe`, `dons`, `heures_valorisees`, `a_payer`) VALUES
(2, 'bourg en bresse', 'arbois', 150, 'test test test tes', '03:00:00', '04:05:00', '2019-03-03', 5, NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, NULL),
(3, 'une autre ville', 'moncku', 540, 'idk', '05:00:00', '05:00:00', '2023-07-04', 5, NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, NULL),
(5, 'test lol', 'dsqjkdfsjfdskl', 50, 'ntm', '06:00:00', '11:00:00', '2027-01-01', 10, 8, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, NULL),
(9, 'une eniemeine saisie', 'qsddqsdqsdqs', 10000000, 'salut salut', '04:00:00', '02:00:00', '2022-03-31', 22, 17, '00:00:20', 10, NULL, NULL, '0', '', NULL, NULL, NULL),
(14, 'latest ?', 'dsqdqsd', 12, 'dqsdqs', '02:00:00', '02:00:00', '2022-03-08', 23, NULL, '00:00:12', 12, '2022-03-07 10:43:44', NULL, '0', '', NULL, NULL, NULL),
(16, 'test1adminlololol', 'qsdqsdqs', 123, 'sqdsqdsq', '02:00:00', '03:00:00', '2022-03-01', 24, 17, '00:00:54', 12, '2022-03-08 11:38:36', NULL, '0', '', NULL, NULL, NULL),
(17, 'fdptest', 'dqsdqsdqs', 12, 'test test', '02:00:00', '03:00:00', '2028-03-03', 24, 17, '00:00:12', 12, '2022-03-08 11:46:19', NULL, '0', '', NULL, NULL, NULL),
(18, 'fraiskm', 'qsdqsdqs', 23, 'qsdqsdqs', '04:05:00', '04:05:00', '2022-03-24', 24, 17, '00:00:12', 50, '2022-03-09 15:35:39', '34', '0', '', NULL, NULL, NULL),
(19, 'fraiskmsqdq', 'qsdqsdqsd', 4, 'qsdqsdqsd', '03:00:00', '02:00:00', '2012-03-16', 24, 16, '00:00:12', 23, '2022-03-09 15:43:02', NULL, '0', '', NULL, NULL, NULL),
(27, 'premiere saisie', '123456', 420, 'salut bg', '08:00:00', '10:30:00', '2022-03-02', 25, 17, '2h30', 50, '2022-03-11 10:16:46', '12', '0', '', NULL, NULL, NULL),
(28, 'premiere saisie', '123456', 420, 'salut bg', '08:00:00', '10:30:00', '2022-03-02', 25, 17, '2h30', 50, '2022-03-11 10:16:46', '12', '0', '', NULL, NULL, NULL),
(29, 'deuxieme saisie', 'galardo', 40, 'une raison', '11:00:00', '15:45:00', '2022-03-01', 25, 17, '4h45', 60, '2022-03-11 10:17:51', '1', '0', '', NULL, NULL, NULL),
(34, 'paris', 'roubaix', 20, 'salut salut', '10:00:00', '23:00:00', '2022-03-03', 26, 8, '13h00', 18, '2022-03-21 10:13:36', '14', '1.42', '10.04', '10', NULL, '20'),
(35, 'test heures valorisées', 'fsfsdf', 15, 'fsdfsd', '12:00:00', '17:30:00', '2022-03-31', 4, 8, '5h30', 25, '2022-03-21 11:13:30', '15', '1.42', '11.22', '18', '84.44', '20'),
(37, 'pas cette année', 'fqfsdf', 10, 'sdfdsfds', '10:00:00', '11:00:00', '2021-03-18', 4, 8, '1h00', 5, '2022-03-21 11:45:55', '3', '1.42', '10.04', '3.1899999999999995', '14.26', '5'),
(38, 'assoc and user this year', 'fdskjhfdsjkf', 15, 'fsddsfds', '04:00:00', '07:00:00', '2022-12-17', 4, 8, '3h00', 20, '2022-03-21 14:21:47', '5', '1.42', '10.04', '24', '42.77', '0'),
(39, 'dijon', 'lol', 12, 'dsqsqd', '05:00:00', '08:00:00', '2021-03-12', 27, 17, '3h00', 14, '2022-03-21 14:59:37', '4', '1.42', '11.22', '17', '47.80', '0'),
(40, '2022', 'sqdsd', 12, 'sqdsqdsq', '09:00:00', '11:00:00', '2022-03-19', 27, 17, '2h00', 22, '2022-03-21 15:00:16', '4', '1.42', '11.91', '20', '33.82', '5'),
(41, 'sqdsqdq', 'sqdsqd', 15, 'sqdqs', '02:00:00', '04:00:00', '2021-03-12', 27, 17, '2h00', 12, '2022-03-21 15:19:35', '5', '1.42', '13.33', '15', '37.86', '1'),
(42, 'arbois', 'galardo', 15, 'fdsfklsdmf', '03:00:00', '06:00:00', '2013-01-11', 4, 10, '3h00', 10, '2022-03-21 16:13:35', '8', '1.42', '16.64', '10', '70.89', '7'),
(43, 'Dijon', 'Paris', 15, 'une raison', '07:00:00', '09:00:00', '2022-03-03', 4, 12, '2h00', 20, '2022-03-25 11:17:10', '5', '1.42', '16.64', '13', '47.26', '10'),
(44, 'tm', 'dsqdq', 15, 'sqdsqdsq', '02:00:00', '05:00:00', '1999-03-04', 4, 8, '3h00', 13, '2022-03-25 14:58:38', '5', '1.42', '11.91', '17', '50.74', '0'),
(47, 'dsqdsqd', 'sqdsqdsqdqsq', 15, 'sqdsqsq', '05:00:00', '11:00:00', '1987-04-11', 4, 17, '6h00', 12, '2022-04-01 16:26:21', '5', '1.42', '13.33', '5', '113.57', '10');

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

--
-- Structure de la table `associations`
--

CREATE TABLE `associations` (
  `id` int NOT NULL,
  `name` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `numero_siret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `associations` (`id`, `name`, `logo`, `description`, `user_id`, `numero_siret`) VALUES
(4, 'rugby Arbois', 'ccfc95e05d44a2f446fdcae757a715e5.png', 'une petite description de l\'association ehehe', NULL, ''),
(5, 'rugby Dijon', '633550bca9534817e84ae383fd444d77.png', 'club de rugby de dijon', NULL, ''),
(7, 'rugby all blacks', '29bd588b51a0c9818b7ce3daefef3a32.png', 'dsfkjds  dsfkljsdkflds dskfldsjfkdlsfj sdklfjsdkflmdsf sdlkfjdskfldjs sdklfjdsklfjds lskdfj dklsfjds sdlfjksdklf lmksdjf lsdf', NULL, ''),
(8, 'handball besancon', 'f6531770110e43a0fbd21d719aaaf2fb.jpg', 'dkljqskldqskldmq', NULL, ''),
(9, 'test', '722098a4736d6889b622aaef2bda71a9.jpg', 'ddm;qsdùmqs', NULL, ''),
(10, 'testlouis', '8e92f619a173aa652863e49ca14dc7fd.jpg', 'ddm;qsdùmqs', NULL, ''),
(11, 'rugby club arbois', '24b9bc4ebb8c093c633361a5cf8c209e.jpg', 'ddm;qsdùmqs', NULL, ''),
(12, 'une assoc', '541719e06c8f0f4ff496b913d39e8c70.png', 'qsdqsdqsdqs', 9, ''),
(14, 'une autre assoc dans le dd', 'a93bee28c423df8190044f11b5c8a782.jpg', 'ljhkjkhjk', 10, ''),
(15, 'une assoc dans le dd', '6c03a64a4e3b7b21b185ee3166dc45b7.jpg', 'salut ca va ?', 10, ''),
(16, 'une assoc dans le dd', '32294eeee986568719eae71d4efe74af.jpg', 'qsdqsdqs', 10, ''),
(17, 'deuxieme assoc', 'd692b9736f445a175f48864a4b0bf2db.jpg', 'dsqdqsdqs', 4, ''),
(18, 'issou', '83da4c876074b6d3945fc2d85b7d6293.png', 'dqsdqsdqs', 12, ''),
(19, 'testimg', '991c806a2ead8bd6895dd03e54175d02.png', 'une petite description', 4, ''),
(20, 'handball club Arbois', '4736ac94bcf1ead134fe5f5af2ff2892.jpg', 'le club de handball d\'arbois', 4, ''),
(21, 'test role admin', '82f810b8356388865ef6be55af8effd8.png', 'test de role mysql', 4, ''),
(22, 'premiere association', '283fb071b055ad3a5d11d9e815c78f72.png', '123', 24, ''),
(23, 'deuxieme assoc test admin', '95eca8b444f7a19d33e965fb209f25c5.png', 'sqdsqdqs', 24, ''),
(24, 'test logout', '4bf723b1703204c5ab2706eff1ef6656.jpg', 'sdfsdfds', 24, ''),
(25, 'test logout', '51a26bfe8d79c9a0875b4d487a6575bc.png', 'sfjskldfjsd', 4, ''),
(26, 'wtest taff', '66620d991088bf7d3fdd0f34bf00d90f.png', 'dqsdsqdsqqs', 4, ''),
(27, 'un numéro de siret', '8f81336355441332f05e598e19434701.png', 'blablabla', 4, '123 568 941 00056');

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

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

CREATE TABLE `doctrine_migration_versions` (
  `version` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_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\\Version20220221091101', '2022-02-21 10:11:14', 101),
('DoctrineMigrations\\Version20220221092548', '2022-02-21 10:25:54', 91),
('DoctrineMigrations\\Version20220221093757', '2022-02-21 10:38:12', 105),
('DoctrineMigrations\\Version20220221100939', '2022-02-21 11:09:57', 91),
('DoctrineMigrations\\Version20220221111405', '2022-02-21 12:14:17', 198),
('DoctrineMigrations\\Version20220221111734', '2022-02-21 12:17:41', 244),
('DoctrineMigrations\\Version20220221111914', '2022-02-21 12:19:20', 188),
('DoctrineMigrations\\Version20220221134145', '2022-02-21 14:41:55', 158),
('DoctrineMigrations\\Version20220221134323', '2022-02-21 14:43:27', 86),
('DoctrineMigrations\\Version20220223090718', '2022-02-23 10:07:29', 199),
('DoctrineMigrations\\Version20220223091006', '2022-02-23 10:10:11', 101),
('DoctrineMigrations\\Version20220223091301', '2022-02-23 10:13:08', 115),
('DoctrineMigrations\\Version20220223091507', '2022-02-23 10:15:14', 112),
('DoctrineMigrations\\Version20220223141555', '2022-02-23 15:16:05', 144),
('DoctrineMigrations\\Version20220301093700', '2022-03-01 10:37:24', 101),
('DoctrineMigrations\\Version20220302123621', '2022-03-02 13:36:32', 194),
('DoctrineMigrations\\Version20220303094940', '2022-03-03 10:49:55', 73),
('DoctrineMigrations\\Version20220303100400', '2022-03-03 11:04:06', 49),
('DoctrineMigrations\\Version20220307090138', '2022-03-09 15:21:18', 29),
('DoctrineMigrations\\Version20220309141952', '2022-03-09 15:21:18', 31),
('DoctrineMigrations\\Version20220311124507', '2022-03-11 13:45:42', 207),
('DoctrineMigrations\\Version20220311132147', '2022-03-11 14:21:54', 226),
('DoctrineMigrations\\Version20220311135344', '2022-03-11 14:53:53', 126),
('DoctrineMigrations\\Version20220419075849', '2022-04-19 09:59:51', 219);

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

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

CREATE TABLE `messenger_messages` (
  `id` bigint NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `headers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `available_at` datetime NOT NULL,
  `delivered_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `messenger_messages` (`id`, `body`, `headers`, `queue_name`, `created_at`, `available_at`, `delivered_at`) VALUES
(1, 'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:30:\\\"reset_password/email.html.twig\\\";i:1;N;i:2;a:1:{s:10:\\\"resetToken\\\";O:58:\\\"SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\\":4:{s:65:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0token\\\";s:40:\\\"ErTKJyXdMgWgkyoPRbhKIRpGoINNar1Cblou48xY\\\";s:69:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0expiresAt\\\";O:17:\\\"DateTimeImmutable\\\":3:{s:4:\\\"date\\\";s:26:\\\"2022-03-02 14:37:02.897455\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:13:\\\"Europe/Berlin\\\";}s:71:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0generatedAt\\\";i:1646224622;s:73:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0transInterval\\\";i:1;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:27:\\\"testResetPassword@gmail.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:15:\\\"passwordReseter\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:24:\\\"pocheron.louis@gmail.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:27:\\\"Your password reset request\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}', '[]', 'default', '2022-03-02 13:37:02', '2022-03-02 13:37:02', NULL);

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

--
-- Structure de la table `user_associations`
--

CREATE TABLE `user_associations` (
  `user_id` int NOT NULL,
  `associations_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_associations` (`user_id`, `associations_id`) VALUES
(4, 4),
(4, 7),
(4, 8),
(4, 9),
(4, 10),
(4, 12),
(4, 16),
(4, 17),
(4, 20),
(10, 4),
(10, 7),
(10, 8),
(10, 16),
(22, 17),
(24, 4),
(24, 5),
(24, 7),
(24, 8),
(24, 9),
(24, 10),
(24, 11),
(24, 12),
(24, 14),
(24, 15),
(24, 16),
(24, 17),
(25, 17),
(26, 8),
(26, 19),
(27, 17);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `action`
--
ALTER TABLE `action`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_47CC8C92A76ED395` (`user_id`),
  ADD KEY `IDX_47CC8C92EFB9C8A5` (`association_id`);

--
-- Index pour la table `associations`
--
ALTER TABLE `associations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8921C4B1A76ED395` (`user_id`);

--
-- Index pour la table `doctrine_migration_versions`
--
ALTER TABLE `doctrine_migration_versions`
  ADD PRIMARY KEY (`version`);

--
-- Index pour la table `messenger_messages`
--
ALTER TABLE `messenger_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_75EA56E016BA31DB` (`delivered_at`);

--
-- Index pour la table `user_associations`
--
ALTER TABLE `user_associations`
  ADD PRIMARY KEY (`user_id`,`associations_id`),
  ADD KEY `IDX_9EDB8B3A76ED395` (`user_id`),
  ADD KEY `IDX_9EDB8B34122538A` (`associations_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `action`
--
ALTER TABLE `action`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT pour la table `associations`
--
ALTER TABLE `associations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT pour la table `messenger_messages`
--
ALTER TABLE `messenger_messages`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `action`
--
ALTER TABLE `action`
  ADD CONSTRAINT `FK_47CC8C92A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_47CC8C92EFB9C8A5` FOREIGN KEY (`association_id`) REFERENCES `associations` (`id`);

--
-- Contraintes pour la table `associations`
--
ALTER TABLE `associations`
  ADD CONSTRAINT `FK_8921C4B1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `user_associations`
--
ALTER TABLE `user_associations`
  ADD CONSTRAINT `FK_9EDB8B34122538A` FOREIGN KEY (`associations_id`) REFERENCES `associations` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_9EDB8B3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
COMMIT;

