-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.0.0.5919
-- --------------------------------------------------------


-- Dumping structure for table selfinstaller.dmg_user
CREATE TABLE IF NOT EXISTS `dmg_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fullname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_login` int(11) DEFAULT NULL,
  `last_login_attempts` int(11) DEFAULT NULL,
  `login_attempts` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `is_admin` int(11) DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table selfinstaller.dmg_user: ~4 rows (approximately)
INSERT IGNORE INTO `dmg_user` (`id`, `username`, `fullname`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `last_login`, `last_login_attempts`, `login_attempts`, `status`, `is_admin`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
	(1, 'root', '', 'ArSewZXiWVbdIcLKqOjCzQw72OwHIgc_', '$2y$13$DejfLZyUM4t7ixbnANNT4uc3FfYeqiNvna9q9sQZ099HtZCYvspkS', '', 'root@myopensoft.net', 0, 0, 0, 0, 0, '0', 0, '', NULL),
	(3, 'superadmin', 'Super admin', 'zwlkz2PC4yemqJ74lHH2UKJUWSRyeBmK', '$2y$13$hgsgQnE5ZQ96NvFfx/S6Vehwm0yVo0Yomlw.wvk3d7yvHrQlB9zE6', '', 'admin@dynaweb4.com', NULL, NULL, NULL, 10, NULL, '', 1533866609, '', 1615167345),
	(4, 'admin', 'Administrator', NULL, '$2y$13$XFeYKZu5Ypcjv7gOpyPFlezfAvvpB5FmXadOm/6mN7pg0VbrmD01G', NULL, 'admin@gmail.com', NULL, NULL, NULL, 10, NULL, NULL, 1607494914, NULL, 1607517507),
	(5, 'guest', 'Guest', NULL, '$2y$13$yMnJvGqlTVdLL/00YJriruuJbwQFW4TzwG9/F7M88cdIpAkh/MhbW', NULL, 'guest@gmail.com', NULL, NULL, NULL, 10, NULL, NULL, 1607525422, NULL, 1607525422);

