Jq2dnF5b

1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jul 10, 2018 at 08:42 PM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
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: `hotmix`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `aauth_users`
27--
28
29CREATE TABLE IF NOT EXISTS `aauth_users` (
30  `id` int(11) unsigned NOT NULL,
31  `email` varchar(100) NOT NULL,
32  `pass` varchar(64) NOT NULL,
33  `username` varchar(100) DEFAULT NULL,
34  `g_photo` tinytext NOT NULL,
35  `g_nik` varchar(50) DEFAULT NULL,
36  `g_nama` varchar(255) NOT NULL,
37  `g_tempat_lahir` varchar(50) NOT NULL,
38  `g_tanggal_lahir` date NOT NULL,
39  `g_jenis_kelamin` varchar(25) NOT NULL,
40  `hp` varchar(16) NOT NULL,
41  `alamat` varchar(255) NOT NULL,
42  `banned` tinyint(1) DEFAULT '0',
43  `last_login` datetime DEFAULT NULL,
44  `last_activity` datetime DEFAULT NULL,
45  `date_created` datetime DEFAULT NULL,
46  `forgot_exp` text,
47  `remember_time` datetime DEFAULT NULL,
48  `remember_exp` text,
49  `verification_code` text,
50  `totp_secret` varchar(16) DEFAULT NULL,
51  `ip_address` text,
52  `updated_at` datetime NOT NULL
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54
55--
56-- Dumping data for table `aauth_users`
57--
58
59INSERT INTO `aauth_users` (`id`, `email`, `pass`, `username`, `g_photo`, `g_nik`, `g_nama`, `g_tempat_lahir`, `g_tanggal_lahir`, `g_jenis_kelamin`, `hp`, `alamat`, `banned`, `last_login`, `last_activity`, `date_created`, `forgot_exp`, `remember_time`, `remember_exp`, `verification_code`, `totp_secret`, `ip_address`, `updated_at`) VALUES
60(1, 'admin@admin.com', 'ec225039f1cb0c48ad528709e8e0184991e637d96db175f094b6b2037ec1a3c2', 'Admin', '97a968e05da52cd31168f3daa8b55ca7.jpg', '', 'Admin', 'Bogor', '2017-06-01', 'pria', '71241741274', 'Jl awesome', 0, '2018-07-10 20:32:55', '2018-07-10 20:32:56', NULL, NULL, NULL, NULL, NULL, NULL, '::1', '2018-04-10 21:56:52');
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 */;