TyZGiwHF

1CREATE DATABASE IF NOT EXISTS `prueba` DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci;
2USE `prueba`
3CREATE TABLE IF NOT EXISTS `users` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `nombre` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
6 `apellido` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
7 `email` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
8 `password` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=3 ;
11INSERT INTO `users` (`id`, `nombre`, `apellido`, `email`, `password`) VALUES
12(1, 'Pepito', 'de los Palotes', 'pepito@gmail.com', '1234'),
13(2, 'Filemon', 'Pi', 'filemon@gmail.com', '1234');