M1m6Qieb

1CREATE DATABASE `ijhaet` DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish2_ci;
2USE `ijhaet`;
3
4CREATE TABLE IF NOT EXISTS `students` (
5  `name` varchar(30) COLLATE utf8_spanish2_ci NOT NULL,
6  `surname` varchar(100) COLLATE utf8_spanish2_ci NOT NULL,
7  `dni` varchar(9) COLLATE utf8_spanish2_ci NOT NULL,
8  `telephone` varchar(8) COLLATE utf8_spanish2_ci NOT NULL,
9  `email` varchar(100) COLLATE utf8_spanish2_ci NOT NULL,
10  `locality` varchar(50) COLLATE utf8_spanish2_ci NOT NULL,
11  `province` varchar(50) COLLATE utf8_spanish2_ci NOT NULL,
12  `address` varchar(100) COLLATE utf8_spanish2_ci NOT NULL,
13  `postalcode` varchar(5) COLLATE utf8_spanish2_ci NOT NULL,
14  `cyclename` varchar(100) COLLATE utf8_spanish2_ci NOT NULL,
15  `sex` varchar(30) COLLATE utf8_spanish2_ci NOT NULL,
16  `underage` varchar(10) COLLATE utf8_spanish2_ci NOT NULL,
17  `observ` text COLLATE utf8_spanish2_ci NOT NULL,
18  `id` int(3) NOT NULL AUTO_INCREMENT,
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci AUTO_INCREMENT=7 ;
21
22INSERT INTO `students` (`name`, `surname`, `dni`, `telephone`, `email`, `locality`, `province`, `address`, `postalcode`, `cyclename`, `sex`, `underage`, `observ`, `id`) VALUES
23('Jose Manuel', 'Fernández Molina', '12345678A', '12345678', 'jose@gooeyapps.com', 'Gooland', 'Tarragona', 'C/ Goo, 706', '12345', 'ASIX', 'Masculí', 'Major', 'Observació.', 1),
24('Ian', 'Talamantes Castrejón', '12345678A', '12345678', 'ian@gooeyapps.com', 'Gooland', 'Tarragona', 'C/ Goo, 706', '12345', 'ASIX', 'Masculí', 'Major', 'Observació.', 2),
25('Goodra', 'Goop Maw', '12345678A', '1234567', 'goo@gooeyapps.com', 'Gootown', 'Barcelona', 'C/ Goo, 706', '12345', 'DAM', 'Masculí', 'Major', 'Observació.', 3),
26('Isneu', 'Furrure Woof', '12345678A', '1234567', 'isneu@gooeyapps.com', 'Gootown', 'Barcelona', 'C/ Goo, 706', '12345', 'DAM', 'Masculí', 'Major', 'Observació.', 4),
27('Mario', 'Mario Spaghetti', '12345678A', '1234567', 'mario@gooeyapps.com', 'Marioland', 'Lleida', 'C/ Mario, 1985', '12345', 'DAM', 'Masculí', 'Major', 'Observació.', 5),
28('Twilight', 'Sparkle', '12345678A', '1234567', 'twi@gooeyapps.com', 'Twiland', 'Girona', 'C/ Twi, 1', '12345', 'ASIX', 'Femení', 'Menor', 'Observació.', 6);
29
30CREATE TABLE IF NOT EXISTS `users` (
31  `id` int(3) NOT NULL AUTO_INCREMENT,
32  `username` varchar(30) COLLATE utf8_spanish2_ci NOT NULL,
33  `password` varchar(30) COLLATE utf8_spanish2_ci NOT NULL,
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci AUTO_INCREMENT=4 ;
36
37INSERT INTO `users` (`id`, `username`, `password`) VALUES
38(1, 'admin', 'admin'),
39(2, 'jose', 'jose'),
40(3, 'ian', 'ian');