-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : lun. 04 août 2025 à 14:43
-- Version du serveur : 8.2.0
-- Version de PHP : 8.1.26

START TRANSACTION;



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

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

--
-- Structure de la table `coproprietaires`
--

CREATE TABLE IF NOT EXISTS `coproprietaires` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `numero_copro` int DEFAULT NULL,
  `nom` varchar(50) DEFAULT NULL,
  `numero` int DEFAULT '0',
  `tantiemes` int DEFAULT '0',
  `pouvoir` int NOT NULL DEFAULT '0',
  `fonction` varchar(40) NOT NULL DEFAULT 'MEMBRE',
  `e_mail` varchar(100) NOT NULL,
  `e_mail2` varchar(100) DEFAULT NULL,
  `PresenceAG` int NOT NULL DEFAULT '0',
  `code` int NOT NULL DEFAULT '0',
  `valide` int NOT NULL DEFAULT '0',
  `mdp` varchar(250) DEFAULT NULL,
  `mutation` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

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

INSERT INTO `coproprietaires` (`id`, `numero_copro`, `nom`, `numero`, `tantiemes`, `pouvoir`, `fonction`, `e_mail`, `e_mail2`, `PresenceAG`, `code`, `valide`, `mdp`, `mutation`) VALUES
(2, 1234567890, 'Leduc', 1, 59, 0, 'MEMBRE', '', NULL, 1, 0, 0, NULL, 0),
(3, 1234567890, 'Lanfranchini', 2, 56, 0, 'MEMBRE', 'jmbrodin64@gmail.com', 'jean-marie.brodin@orange.fr', 1, 0, 0, NULL, 0),
(4, 1234567890, 'Cuillandre', 3, 66, 0, 'MEMBRE', '', NULL, 1, 0, 0, NULL, 0),
(5, 1234567890, 'Cabedoce', 4, 66, 0, 'MEMBRE', 'jmbrodin64@gmail.com', NULL, 1, 0, 0, NULL, 0),
(6, 1234567890, 'Montibus', 5, 69, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', NULL, 1, 0, 0, NULL, 0),
(7, 1234567890, 'Remazeilles', 6, 70, 0, 'MEMBRE', '', NULL, 1, 0, 0, NULL, 0),
(9, 1234567890, 'Toffoli', 8, 55, 0, 'PRESIDENT', '', NULL, 1, 0, 0, NULL, 0),
(10, 1234567890, 'Dupieux', 9, 56, 0, 'CONSEILLER', 'jmbrodin64@gmail.com', NULL, 1, 0, 0, NULL, 0),
(11, 1234567890, 'Moniolle', 10, 66, 0, 'CONSEILLER', 'jean-marie.brodin@orange.fr', NULL, 1, 0, 0, NULL, 0),
(12, 1234567890, 'Pangrani', 11, 66, 0, 'MEMBRE', 'jmbrodin64@gmail.com', NULL, 1, 0, 0, NULL, 0),
(13, 1234567890, 'Bourcier', 12, 58, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', NULL, 1, 0, 0, NULL, 0),
(14, 1234567890, 'Fourest', 13, 59, 0, 'MEMBRE', 'jmbrodin64@gmail.com', NULL, 1, 0, 0, NULL, 0),
(15, 1234567890, 'Morer', 14, 68, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', NULL, 1, 0, 0, NULL, 0),
(16, 1234567890, 'Pontoizeau', 15, 69, 0, 'CONSEILLER', 'jmbrodin64@gmail.com', NULL, 1, 0, 0, NULL, 0),
(19, 1234567890, 'Gorgeon', 7, 57, 0, 'MEMBRE', '', NULL, 1, 0, 0, NULL, 0),
(20, 1234567890, 'Deveaux', 16, 60, 0, 'MEMBRE', '', NULL, 1, 0, 0, NULL, 0),
(21, 987654321, 'Cornevin', 1, 45, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', NULL, 0, 12345, 0, '54321!', 0),
(22, 987654321, 'Guilcher', 2, 52, 0, 'CONSEILLER', '', NULL, 0, 0, 0, NULL, 0),
(23, 987654321, 'Pellat', 3, 53, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(24, 987654321, 'Vollmer', 4, 58, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(25, 987654321, 'Bass', 5, 46, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(26, 987654321, 'Milner', 6, 46, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(27, 987654321, 'Decaux', 7, 52, 0, 'PRESIDENT', '', NULL, 0, 0, 0, NULL, 0),
(28, 987654321, 'Lachaux', 8, 49, 0, 'CONSEILLER', '', NULL, 0, 0, 0, NULL, 0),
(29, 987654321, 'Fabre', 9, 48, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(30, 2, 'Gonin', 10, 51, 0, 'CONSEILLER', '', NULL, 0, 0, 0, NULL, 0),
(31, 2, 'Rodary', 11, 44, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(32, 2, 'Caradec', 12, 52, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(33, 2, 'Bintein', 13, 54, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(34, 2, 'Dey', 14, 56, 0, 'MEMBRE', '', NULL, 0, 0, 0, NULL, 0),
(35, 0, 'Bethbeder', 15, 0, 46, '15', '', NULL, 0, 0, 0, NULL, 0),
(36, 0, 'Rech', 16, 0, 48, '16', '', NULL, 0, 0, 0, NULL, 0),
(37, 0, 'Gremare', 17, 0, 60, '17', '', NULL, 0, 0, 0, NULL, 0),
(38, 0, 'Dethiers', 18, 0, 44, '18', '', NULL, 0, 0, 0, NULL, 0),
(39, 0, 'Lelong', 19, 0, 46, '19', '', NULL, 0, 0, 0, NULL, 0),
(40, 0, 'Petit', 20, 0, 50, '20', '', NULL, 0, 0, 0, NULL, 0),
(41, 94192474, 'Ampere', 1, 147, 2, 'CONSEIL SYNDICAL', '', '', 5, 678543, 1, 'Ampere64!', 0),
(42, 94192474, 'Becquerel', 2, 146, 0, 'CONSEIL SYNDICAL', '', '', 0, 897635, 1, 'Becquerel64!', 0),
(43, 94192474, 'Bohr', 3, 169, 0, 'MEMBRE', '', '', 0, 874398, 1, 'Bohr64!', 0),
(44, 94192474, 'Heisenberg', 4, 146, 0, 'MEMBRE', '', '', 0, 840968, 1, 'Heisenberg64!', 0),
(45, 94192474, 'Carnot', 5, 166, 0, 'MEMBRE', '', '', 0, 645908, 1, 'Carnot64!', 0),
(46, 94192474, 'Einstein', 6, 112, 0, 'MEMBRE', '', '', 0, 245765, 1, 'Einstein64!', 0),
(47, 94192474, 'Dirac', 7, 114, 0, 'CONSEIL SYNDICAL', '', '', 0, 768345, 1, 'Dirac64!', 0),
(48, 97636766, 'Drevez', 1, 170, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', 'jean-marie.brodin@orange.fr', 0, 12345, 1, 'Drevez', 0),
(49, 97636766, 'Laplanche', 2, 153, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', 'jean-marie.brodin@orange.fr', 0, 12345, 1, 'Laplanche', 0),
(50, 97636766, 'Noguez', 3, 160, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', 'jean-marie.brodin@orange.fr', 0, 12345, 1, 'Noguez', 0),
(51, 97636766, 'Delaby', 4, 294, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', 'jean-marie.brodin@orange.fr', 0, 12345, 1, 'Delaby', 0),
(52, 97636766, 'Iniesta', 5, 223, 0, 'MEMBRE', 'jean-marie.brodin@orange.fr', 'jean-marie.brodin@orange.fr', 0, 12345, 1, 'Iniesta', 0),
(53, 97042847, 'Ampere', 1, 147, 2, 'CONSEIL SYNDICAL', ' ', ' ', 5, 678543, 1, 'Ampere64!', 0),
(54, 97042847, 'Becquerel', 2, 146, 0, 'CONSEIL SYNDICAL', ' ', ' ', 0, 897635, 1, 'Becquerel64!', 0),
(55, 97042847, 'Bohr', 3, 169, 0, 'MEMBRE', ' ', ' ', 0, 874398, 1, 'Bohr64!', 0),
(56, 97042847, 'Heisenberg', 4, 146, 0, 'MEMBRE', ' ', ' ', 0, 840968, 1, 'Heisenberg64!', 0),
(57, 97042847, 'Carnot', 5, 166, 0, 'MEMBRE', ' ', ' ', 0, 645908, 1, 'Carnot64!', 0),
(58, 97042847, 'Einstein', 6, 112, 0, 'MEMBRE', ' ', ' ', 0, 245765, 1, 'Einstein64!', 0),
(59, 97042847, 'Dirac', 7, 114, 0, 'CONSEIL SYNDICAL', ' ', ' ', 0, 768345, 1, 'Dirac64!', 0);
COMMIT;

