-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `tp6exo4`
--

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

--
-- Table structure for table `codes`
--

CREATE TABLE `codes` (
  `id` int(11) NOT NULL,
  `site` varchar(100) NOT NULL,
  `login` varchar(100) NOT NULL,
  `mdp` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `codes`
--

INSERT INTO `codes` (`id`, `site`, `login`, `mdp`) VALUES
(1, 'Gmail', 'azerty@gmail.com', 'hucAf9G2BqDE'),
(2, 'Netflix', 'azerty@gmail.com', '8KQxpPFTibtf');

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

--
-- Table structure for table `motdepasse`
--

CREATE TABLE `motdepasse` (
  `id` int(11) NOT NULL,
  `mdp` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `motdepasse`
--

INSERT INTO `motdepasse` (`id`, `mdp`) VALUES
(1, 'e99a18c428cb38d5f260853678922e03'),
(2, 'f26c2f431a8f57ae8013881556f8e279'),
(3, '8195bde6f76982023b6a4638e3930230');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `codes`
--
ALTER TABLE `codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `motdepasse`
--
ALTER TABLE `motdepasse`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `codes`
--
ALTER TABLE `codes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `motdepasse`
--
ALTER TABLE `motdepasse`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

