CREATE TABLE IF NOT EXISTS `clicks` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL,
  `data` varchar(20) NOT NULL,
  `pais` varchar(255) NOT NULL,
  `owner` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `clicks` (`id`, `ip`, `data`, `pais`, `owner`) VALUES
(1, '179.67.210.41', '11-07-16', 'brasil', '6');

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `owner` varchar(255) NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `descri` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `senha` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `users` (`id`, `email`, `senha`) VALUES
(1, 'buzzytjr@gmail.com', '123456'),
(2, 'joao@email.com', '123456'),
(3, 'donato@email.com', '123456'),
(4, 'nayara@hotmail.com', 'nayara123'),
(5, 'idemar@hotmail.com', 'idemar123'),
(6, 'cristiano@monteiro.com', 'cristiano123'),
(7, 'gabrielminharola@live.com', 'gabriel123');