· 10 years ago · Feb 24, 2016, 03:39 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Feb 23, 2016 at 09:49 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
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: `internoodle`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `user`
27--
28
29CREATE TABLE IF NOT EXISTS `user` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `user_type` int(11) NOT NULL DEFAULT '1',
32 `first_name` varchar(255) DEFAULT NULL,
33 `last_name` varchar(255) DEFAULT NULL,
34 `user_name` varchar(255) CHARACTER SET latin1 NOT NULL,
35 `email` varchar(255) CHARACTER SET latin1 NOT NULL,
36 `password` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
37 `active_key` varchar(255) CHARACTER SET latin1 NOT NULL,
38 `salt` varchar(255) CHARACTER SET latin1 NOT NULL,
39 `password_strategy` varchar(255) CHARACTER SET latin1 NOT NULL,
40 `requires_new_password` tinyint(1) NOT NULL,
41 `login_ip` varchar(32) CHARACTER SET latin1 NOT NULL,
42 `update_time` datetime NOT NULL,
43 `last_login` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
44 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
45 PRIMARY KEY (`id`),
46 UNIQUE KEY `username` (`user_name`),
47 UNIQUE KEY `email` (`email`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
49
50--
51-- Dumping data for table `user`
52--
53
54INSERT INTO `user` (`id`, `user_type`, `first_name`, `last_name`, `user_name`, `email`, `password`, `active_key`, `salt`, `password_strategy`, `requires_new_password`, `login_ip`, `update_time`, `last_login`, `timestamp`) VALUES
55(7, 1, 'Khan', 'jee', 'khanjee', 'khan@gmail.com', '$2a$14$1P0Ikv58vGJYE7ZcqUPpTeL5LRAZViftQQS30Bm5CAZFNvLQNO9kW', '', '$2a$14$1P0Ikv58vGJYE7ZcqUPpTg', 'bcrypt', 0, '', '0000-00-00 00:00:00', NULL, '2016-02-23 18:39:14'),
56(8, 1, 'naveed', 'khan', 'naveedkhan', 'naveed1491@gmail.com', '$2a$14$DaKVjNfH2JufQzWb.sDgGevFR9O6xzVCk.YgOdfuEHsIIPxWGVL4C', 'be379bcd7150149482f7f79f5093af99', '$2a$14$DaKVjNfH2JufQzWb.sDgGg', 'bcrypt', 0, '', '0000-00-00 00:00:00', NULL, '2016-02-23 19:53:53'),
57(9, 2, 'javeed', 'khan', 'javeed', 'jav@gmail.com', '$2a$14$zaG3UCPtHOMuWkOESKaLwOhgVXyQWVpQCYwsy2Z3HXWnQjXVyGSGu', '', '$2a$14$zaG3UCPtHOMuWkOESKaLwQ', 'bcrypt', 0, '::1', '0000-00-00 00:00:00', NULL, '2016-02-23 18:47:48'),
58(10, 2, 'gul', 'khan', 'gulkhan', 'gul@gmail.com', '$2a$14$/l5JWceSJkJGSlPh1zoh8.6oNvDApTiokAde53CPXO5RpP9avozqe', '', '$2a$14$/l5JWceSJkJGSlPh1zoh8A', 'bcrypt', 0, '::1', '0000-00-00 00:00:00', '2016-02-23 18:50:02', '2016-02-23 18:50:07'),
59(11, 2, 'kalim', 'khan', 'kalim', 'kalim@gmail.com', '$2a$14$vrtBNsEccVAIDKTXSr5Roeiendksu5PQSFVQ/WaOypOMVKqBewbMW', 'e6ba129643543842e3893f287cc99c2f', '$2a$14$vrtBNsEccVAIDKTXSr5Rog', 'bcrypt', 0, '::1', '0000-00-00 00:00:00', '2016-02-23 19:10:45', '2016-02-23 19:32:27'),
60(12, 2, '', '', 'kjhkhk', 'aa@ff.ff', '$2a$14$uA9h8965Pdi4cMD2jgAP6eM4emmDUt3e00C1uQXgp78/5D3s/NA2K', '', '$2a$14$uA9h8965Pdi4cMD2jgAP6g', 'bcrypt', 0, '::1', '0000-00-00 00:00:00', '2016-02-23 19:57:29', '2016-02-23 19:57:34');
61
62/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
63/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
64/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;