3ZveUpq3

1CREATE TABLE IF NOT EXISTS `clicks` (
2  `id` int(20) NOT NULL AUTO_INCREMENT,
3  `ip` varchar(255) NOT NULL,
4  `data` varchar(20) NOT NULL,
5  `pais` varchar(255) NOT NULL,
6  `owner` varchar(20) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
9 
10INSERT INTO `clicks` (`id`, `ip`, `data`, `pais`, `owner`) VALUES
11(1, '179.67.210.41', '11-07-16', 'brasil', '6');
12
13CREATE TABLE IF NOT EXISTS `news` (
14  `id` int(255) NOT NULL AUTO_INCREMENT,
15  `owner` varchar(255) NOT NULL,
16  `titulo` varchar(255) NOT NULL,
17  `image` varchar(255) NOT NULL,
18  `descri` varchar(255) NOT NULL,
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
21 
22CREATE TABLE IF NOT EXISTS `users` (
23  `id` int(255) NOT NULL AUTO_INCREMENT,
24  `email` varchar(255) NOT NULL,
25  `senha` varchar(255) NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
28 
29INSERT INTO `users` (`id`, `email`, `senha`) VALUES
30(1, 'buzzytjr@gmail.com', '123456'),
31(2, 'joao@email.com', '123456'),
32(3, 'donato@email.com', '123456'),
33(4, 'nayara@hotmail.com', 'nayara123'),
34(5, 'idemar@hotmail.com', 'idemar123'),
35(6, 'cristiano@monteiro.com', 'cristiano123'),
36(7, 'gabrielminharola@live.com', 'gabriel123');