· 4 years ago · Aug 14, 2021, 02:42 AM
1CREATE TABLE IF NOT EXISTS `usuario` (
2 `id` int(10) NOT NULL AUTO_INCREMENT,
3 `nome` varchar(100) NOT NULL,
4 `password` varchar(100) NOT NULL,
5 `email` varchar(100) NOT NULL,
6 `telefone` varchar(100) NOT NULL,
7 `CPF` varchar(100) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
10
11--
12-- Dumping data for table `usuario`
13--
14
15INSERT INTO `usuario` (`id`, `nome`, `password`, `email`, `telefone`, `CPF`) VALUES
16(05, 'José', 'Valente', 'jose@gmail.com', '(86) 91679-6161', '767.369.301-11'),
17(06, 'Ana', 'Vitoria', 'ana@gmail.com', '(62) 94636-1574', '916.567.438-33'),
18(08, 'Maria', 'Francisca', 'maria@gmail.com', '(75) 92870-0335', '017.740.895-21');