TABELA UTILIZADOR - 08

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `regDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `firstName` varchar(255) DEFAULT NULL,
  `lastName` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `users`
--

INSERT INTO `users` (`id`, `username`, `pass`, `regDate`, `firstName`, `lastName`, `status`) VALUES
(1, 'Mloureiro@mail.pt', '1231', '2019-11-07 16:51:13', 'Manuel', 'Loureiro', 0),
(2, 'diogomartins@gmail.com', '1235476', '2019-11-07 16:51:13', NULL, NULL, 0),
(3, 'catarina@mail.pt', '1234', '2019-11-14 14:22:25', 'Catarina', 'Bernardo', 0),
(4, 'vitor@mail.pt', '1234', '2019-11-14 14:22:25', 'Vitor', 'Caldeira', 0),
(5, 'andre@mail.pt', '1234', '2019-11-14 14:23:20', 'André', 'Teixeira', 0),
(6, 'pedro@mail.pt', '1234', '2019-11-14 14:23:20', 'Pedro', 'Melo', 0),
(7, 'bruno@mail.pt', '1234', '2019-11-14 00:00:00', 'Bruno', 'Martins', 0),
(8, 'anacarvalho@mail.pt', '1234', '2019-11-14 14:24:13', 'Ana', 'Carvalho', 0),
(9, 'juliana@mail.pt', '1234', '2019-11-14 14:35:48', 'Juliana', 'Sousa', 0),
(10, 'celia@mail.pt', '1234', '2019-11-14 14:35:48', 'Célia', 'Lima', 0),
(11, 'claudia@mail.pt', '1234', '2019-11-14 14:36:20', 'Claúdia', 'Pereira', 0),
(12, 'diana@mail.pt', '1234', '2019-11-14 14:36:20', 'Diana', 'Barros', 0),
(13, 'ivo@mail.pt', '1234', '2019-11-14 14:36:48', 'Ivo', 'Martins', 0),
(14, 'diogo@mail.pt', '1234', '2019-11-14 14:36:48', 'Diogo', 'Martins', 0),
(15, 'luis@mail.pt', '1234', '2019-11-14 14:37:13', 'Luís', 'Nunes', 0),
(16, 'joao@mail.pt', '1234', '2019-11-14 14:37:13', 'João', 'Fontes', 0),
(17, 'artur@mail.pt', '1234', '2019-11-14 00:00:00', 'Artur', 'Lopes', 0),
(18, 'brunomesquita@mail.pt', '1234', '2019-11-14 14:37:55', 'Bruno', 'Mesquita', 0),
(19, 'claudiamarques@mail.pt', '1234', '2019-11-14 14:38:37', 'Claúdia', 'Marques', 0),
(20, 'jorge@mail.pt', '1234', '2019-11-14 14:38:37', 'Jorge', 'Teixeira', 0),
(21, 'beatriz@mail.pt', '1234', '2019-11-14 14:39:06', 'Beatriz', 'Pereira', 0),
(22, 'miguel@mail.pt', '1234', '2019-11-14 14:39:06', 'Miguel', 'Pacheco', 0),
(23, 'andreia@mail.pt', '1234', '2019-11-14 14:39:35', 'Andreia', 'Estanqueiro', 0),
(24, 'edgar@mail.pt', '1234', '2019-11-14 14:39:35', 'Edgar', 'Brito', 0);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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