· 7 years ago · Oct 20, 2018, 05:26 PM
1-- --------------------------------------------------------
2-- Host: localhost
3-- Server version: 5.7.19 - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for pcm_hris
16CREATE DATABASE IF NOT EXISTS `pcm_hris` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `pcm_hris`;
18
19-- Dumping structure for table pcm_hris.users
20CREATE TABLE IF NOT EXISTS `users_old` (
21 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
22 `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
23 `nik` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
24 `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
25 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
26 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
27 `no_telp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
28 `position_id` int(10) unsigned DEFAULT NULL,
29 `role` enum('User','Admin','Super Admin') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
30 `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
31 `status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
32 `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
33 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
34 `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
35 `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
36 `deleted_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
37 `created_at` datetime DEFAULT NULL,
38 `updated_at` datetime DEFAULT NULL,
39 `deleted_at` datetime DEFAULT NULL,
40 PRIMARY KEY (`id`),
41 UNIQUE KEY `users_email_unique` (`email`),
42 UNIQUE KEY `username` (`username`),
43 UNIQUE KEY `email` (`email`)
44) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
45
46-- Dumping data for table pcm_hris.users: ~5 rows (approximately)
47/*!40000 ALTER TABLE `users_old` DISABLE KEYS */;
48INSERT INTO `users_old` (`id`, `code`, `nik`, `username`, `name`, `email`, `no_telp`, `position_id`, `role`, `image`, `status`, `password`, `remember_token`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
49 (1, 'abc123', '10331101932', 'super.admin', 'Super Administrator', 'superadmin@mailinator.com', NULL, 1, 'Super Admin', NULL, 'Active', '$2y$10$S9tO9rmPUPnmJkYU/oFFUeg6t3c7CIA.MsLF8794H0veRmDKDEqtq', NULL, NULL, 'super@gmail.com', NULL, '2018-09-19 01:14:26', '2018-10-10 02:16:59', NULL),
50 (2, 'abc456', '10331101934', 'admin', 'superadmins', 'admins@mailinator.com', '08562605588', 1, 'Admin', NULL, 'ACTIVE', '$2y$10$kY4Bj18sjNlUj50ORhDlCuNlR7jYmrFjD2HCY0hBPnhIMGbhVRabK', NULL, 'super@gmail.com', NULL, NULL, '2018-09-30 09:52:54', '2018-10-05 20:24:44', NULL),
51 (3, 'abc789', '10331101936', 'super', 'Super Admin', 'super@gmail.com', '076253653', 2, 'Super Admin', NULL, 'ACTIVE', '$2y$10$4km/YO9aGeWU9gZFWQwhke3yObPlMW5jmlOkJKfhx8DGBOYI8vP8O', 's2bzCLitvvxnFieUa2Kh1pfsYxpWRPGLNwHkqDqJLO2aX4tsKw3ii2TBC2vk', NULL, NULL, NULL, '2018-10-02 15:02:56', '2018-10-02 15:02:58', NULL),
52 (4, '1yIpAanX5GqB2Jc71NlH', '13231232131', 'sefriandsz', 'strevecloud', 'anang.awan@rebelworks.co', '234324324', 1, 'Admin', NULL, 'ACTIVE', '$2y$10$VJTy4VNNr0v6LmzR2vpvIu42JFJC7IcmngC5yHmSewb35SRBThGoG', NULL, 'super@gmail.com', NULL, NULL, '2018-10-05 18:09:55', '2018-10-05 18:09:55', NULL),
53 (5, 'vTKuM4hcZamShIROFAbS', '134544646464', 'cat', 'cat', 'cat@gmail.com', '75656576', 2, 'User', NULL, 'ACTIVE', '$2y$10$UbrU.LiYdSPO5VCYlvwNIuiWSppkw8Cg0h7i2NQ.STy9lEtnrR3r.', NULL, 'super@gmail.com', NULL, NULL, '2018-10-05 18:35:49', '2018-10-05 18:35:49', NULL),
54 (6, 'HrHkA9j2v3pKgL8TTnXC', '2173672163', 'safdsaf', 'testing', 'shd@gmail.com', '1276323', 2, 'User', 'User/0tijvsg7hlbqgf3e2rng.jpg', 'ACTIVE', '$2y$10$M74KfGJkFyYc1wgK1AFaje95GSS4YdlVqS5CYYc/d/bpP9HKJaX3m', NULL, 'super@gmail.com', NULL, NULL, '2018-10-07 22:37:05', '2018-10-07 22:46:09', NULL);
55/*!40000 ALTER TABLE `users` ENABLE KEYS */;
56
57/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
58/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
59/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;