· 11 years ago · Aug 13, 2015, 03:35 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.13.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: 12-Ago-2015 Ã s 23:32
7-- Versão do servidor: 5.5.44-0ubuntu0.12.04.1
8-- PHP Version: 5.3.10-1ubuntu3.19
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 utf8mb4 */;
18
19--
20-- Database: `pullchat`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura da tabela `usuarios`
27--
28
29CREATE TABLE IF NOT EXISTS `usuarios` (
30 `id` int(11) NOT NULL,
31 `nome` varchar(200) NOT NULL,
32 `email` varchar(200) DEFAULT NULL,
33 `senha` varchar(50) DEFAULT NULL,
34 `hora` datetime DEFAULT NULL,
35 `limite` datetime DEFAULT NULL,
36 `status` varchar(255) NOT NULL DEFAULT 'Olá, estou no Pull Chat!',
37 `my_groups` varchar(24) DEFAULT NULL,
38 `optNotify` varchar(5) DEFAULT NULL,
39 `optSound` varchar(5) DEFAULT NULL,
40 `type` varchar(5) DEFAULT NULL,
41 `usersGroup` varchar(220) DEFAULT NULL,
42 `idAdmins` varchar(220) DEFAULT NULL,
43 `nomeAdmin` varchar(100) DEFAULT NULL,
44 `creationDate` datetime DEFAULT NULL
45) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
46
47--
48-- Extraindo dados da tabela `usuarios`
49--
50
51INSERT INTO `usuarios` (`id`, `nome`, `email`, `senha`, `hora`, `limite`, `status`, `my_groups`, `optNotify`, `optSound`, `type`, `usersGroup`, `idAdmins`, `nomeAdmin`, `creationDate`) VALUES
52(1, 'David Sadan', 'davidguns2@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '2015-08-13 00:25:45', '2015-08-13 00:26:45', 'Olá, estou no Pull Chat!', NULL, '', '', 'user', NULL, NULL, NULL, NULL),
53(2, 'Jose da Silva', 'josedasilva@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '2015-08-13 00:25:30', '2015-08-13 00:26:30', 'Olá, estou no Pull Chat!', NULL, '', '', 'user', NULL, NULL, NULL, NULL),
54(3, 'Amanda Sousa', 'amanda@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '2015-08-12 17:21:08', '2015-08-12 17:22:08', 'Olá, estou no Pull Chat!', NULL, '', '', 'user', NULL, NULL, NULL, NULL),
55(4, 'Claudia Vanuza', 'claudia@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '2015-08-01 12:43:01', '2015-08-01 12:44:01', 'Olá, estou no Pull Chat!', NULL, '', '', 'user', NULL, NULL, NULL, NULL),
56(5, 'Universo Curioso', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '3,4,2', '1', 'David Sadan', '2015-07-28 22:29:41'),
57(6, 'Grupo 2', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '1,3', '2', 'Jose da Silva', '2015-07-30 02:13:53'),
58(7, 'TESTE TESTE', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '4,2', '1', 'David Sadan', '2015-07-30 22:20:10'),
59(8, 'FamÃÂlia', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '4', '1', 'David Sadan', '2015-08-01 14:35:48'),
60(9, 'Meu Grupo', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '4', '1', 'David Sadan', '2015-08-01 14:52:55'),
61(10, 'Grupo 09/08/15', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '3,4,2', '1', 'David Sadan', '2015-08-09 16:19:58'),
62(11, 'Grupo Danilo', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '2,3', '1', 'David Sadan', '2015-08-11 00:51:36'),
63(12, 'saqw', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '', '1', 'David Sadan', '2015-08-11 00:55:10'),
64(13, 'mais um grupo de teste', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '2,3', '1', 'David Sadan', '2015-08-11 01:00:37'),
65(14, 'asdasd', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '2,3', '1', 'David Sadan', '2015-08-11 01:09:06'),
66(15, 'mais um grupo', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '4,2,3', '1', 'David Sadan', '2015-08-11 01:13:40'),
67(16, 'tetetetet', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '3,2', '1', 'David Sadan', '2015-08-11 01:14:33'),
68(17, 'aqaqaq', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '2,3', '1', 'David Sadan', '2015-08-11 01:31:09'),
69(18, 'Ola Mundo :D', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '3,2', '1', 'David Sadan', '2015-08-11 01:41:05'),
70(19, 'Olá Mundo :D', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '3,2', '1', 'David Sadan', '2015-08-11 01:42:18'),
71(20, 'Grupo do José', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '1', '2', 'Jose da Silva', '2015-08-11 01:42:40'),
72(21, 'Grupo do José', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '', '2', 'Jose da Silva', '2015-08-11 01:43:33'),
73(22, 'Grupo Teste', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '1', '2', 'Jose da Silva', '2015-08-11 01:44:23'),
74(23, 'Grupo Amanda', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '3', '2', 'Jose da Silva', '2015-08-11 01:44:40'),
75(24, 'Linda Hellen', 'linda@pullchat.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '2015-08-12 23:15:11', '2015-08-12 23:16:11', 'Olá, estou no Pull Chat!', NULL, '', '', 'user', NULL, NULL, NULL, NULL),
76(25, 'COisando', NULL, NULL, NULL, NULL, 'Olá, estou no Pull Chat!', NULL, NULL, NULL, 'group', '1,2,3,4', '24', 'Linda Hellen', '2015-08-12 22:11:40');
77
78--
79-- Indexes for dumped tables
80--
81
82--
83-- Indexes for table `usuarios`
84--
85ALTER TABLE `usuarios`
86 ADD PRIMARY KEY (`id`);
87
88--
89-- AUTO_INCREMENT for dumped tables
90--
91
92--
93-- AUTO_INCREMENT for table `usuarios`
94--
95ALTER TABLE `usuarios`
96 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
97/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
98/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
99/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;