6gzSVL4A

1-- phpMyAdmin SQL Dump
2-- version 3.5.8.1
3-- http://www.phpmyadmin.net
4--
5-- Host: tananets.com.mysql:3306
6-- Generation Time: Jul 11, 2016 at 12:13 PM
7-- Server version: 5.5.49-MariaDB-1~wheezy
8-- PHP Version: 5.4.45-0+deb7u4
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `tananets.com`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `clicks`
27--
28
29CREATE TABLE IF NOT EXISTS `clicks` (
30  `id` int(20) NOT NULL AUTO_INCREMENT,
31  `ip` varchar(255) NOT NULL,
32  `data` varchar(20) NOT NULL,
33  `pais` varchar(255) NOT NULL,
34  `owner` varchar(20) NOT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
37
38--
39-- Dumping data for table `clicks`
40--
41
42INSERT INTO `clicks` (`id`, `ip`, `data`, `pais`, `owner`) VALUES
43(1, '179.67.210.41', '11-07-16', 'brasil', '6');
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `news`
49--
50
51CREATE TABLE IF NOT EXISTS `news` (
52  `id` int(255) NOT NULL AUTO_INCREMENT,
53  `owner` varchar(255) NOT NULL,
54  `titulo` varchar(255) NOT NULL,
55  `image` varchar(255) NOT NULL,
56  `descri` varchar(255) NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
59
60-- --------------------------------------------------------
61
62--
63-- Table structure for table `users`
64--
65
66CREATE TABLE IF NOT EXISTS `users` (
67  `id` int(255) NOT NULL AUTO_INCREMENT,
68  `email` varchar(255) NOT NULL,
69  `senha` varchar(255) NOT NULL,
70  PRIMARY KEY (`id`)
71) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
72
73--
74-- Dumping data for table `users`
75--
76
77INSERT INTO `users` (`id`, `email`, `senha`) VALUES
78(1, 'buzzytjr@gmail.com', '123456'),
79(2, 'joao@email.com', '123456'),
80(3, 'donato@email.com', '123456'),
81(4, 'nayara@hotmail.com', 'nayara123'),
82(5, 'idemar@hotmail.com', 'idemar123'),
83(6, 'cristiano@monteiro.com', 'cristiano123'),
84(7, 'gabrielminharola@live.com', 'gabriel123');
85
86/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
87/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
88/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;