CREATE TABLE `psi_users` (
  `u_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `u_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_lname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_mname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `u_access_type` bigint(20) DEFAULT '0',
  `u_enabled` tinyint(1) unsigned DEFAULT '1',
  `ug_id` bigint(20) unsigned DEFAULT '0',
  `u_phash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `remember_expiry` datetime DEFAULT NULL,
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_users (u_id, u_username, u_password, u_lname, u_fname, u_mname, u_mobile, u_email, u_access_type, u_enabled, ug_id, u_phash, region_id, synched, sync_date, date_encoded, last_updated, encoder, updater, remember_token, remember_expiry) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Admin', 'Treytor', 'Is', '639151234567', 'admin@dostcalabarzon.ph', 0, 1, 1, 'OK', 6, 0, NULL, NULL, '2019-03-22 23:51:04', '', 'Treytor Is Admin', 'a7fee3d99c860aff01f7c8042b0077ed', '2020-04-05 22:50:19');
