
--
-- Table structure for table `s_user`
--

CREATE TABLE `s_user` (
  `id` int(1) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL DEFAULT '',
  `jwt_key` text DEFAULT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `mobile` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `level` tinyint(3) NOT NULL DEFAULT 1 COMMENT '1=admin,2=SPV,3=manager,4=Superadmin',
  `status` tinyint(1) unsigned DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `access_payroll` tinyint(3) NOT NULL DEFAULT 0,
  `access_cashbon` tinyint(3) NOT NULL DEFAULT 0,
  `access_asset` tinyint(3) NOT NULL DEFAULT 0,
  `access_ticket` tinyint(3) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `s_user`
--

INSERT INTO `s_user` VALUES (1,'abdul.r4hman@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Abdul Rahman','081318227996','',4,1,'2018-01-26 13:39:56','2018-01-26 13:39:56',1,0,0,0),(2,'r4cheem@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Abdul Rahim','081320325846','',4,1,'2018-01-26 13:39:56','2018-01-26 13:39:56',1,0,0,0),(3,'srifitriah.jtk11@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Sri Fitriah','08996161700','',4,1,'2018-01-16 17:23:54','2018-01-16 17:23:54',1,0,0,0),(4,'sastra.afandi@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Setia Darmawan Afandi','','',4,1,'2018-01-16 17:23:54','2018-01-16 17:23:54',1,0,0,0),(5,'febby.jefany@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Febby Olivia Jefany','085271644554','',1,0,'2018-01-29 22:04:57','2018-01-29 22:04:57',0,0,0,0),(6,'vc.ganesha@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Staff Keuangan','081320325846','',2,1,'2018-07-14 11:02:54','2018-07-14 11:02:54',0,0,0,0),(7,'delfcode@gmail.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','Superadmin','628','',4,1,'2021-07-30 09:27:33','2021-07-30 09:27:33',1,0,0,0),(8,'widi@agroka.com','$2y$12$kagbflrH6f.QV/7f/16OoO0nVa5ui8/McqLL7PY4tKhGt339tt5JK','','widi','62','',2,1,'2022-02-05 02:24:24','2022-02-05 02:24:24',0,0,0,0),(9,'widia@agroka.com','$2y$12$fumGY5kai96.hlgKaQ8HbOoJny0fwWQ3RhWlnJmAPp1TzNDUoYFNa','','widia','62','',2,1,'2022-02-05 02:31:23','2024-07-04 10:36:56',0,0,0,0);

--
-- Table structure for table `s_user_account`
--

CREATE TABLE `s_user_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `transaction_account_id` int(11) NOT NULL DEFAULT 0,
  `created` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `s_user_account`
--

INSERT INTO `s_user_account` VALUES (1,1,1,'2020-01-15 19:36:19',1),(2,1,3,'2020-01-15 19:36:19',1),(3,1,4,'2020-01-15 19:36:19',1),(4,1,2,'2020-01-15 19:36:19',1),(5,1,5,'2020-01-15 19:36:19',1),(11,2,1,'2020-01-15 19:47:01',2),(12,2,3,'2020-01-15 19:47:02',2),(13,2,4,'2020-01-15 19:47:02',2),(14,2,2,'2020-01-15 19:47:02',2),(15,2,5,'2020-01-15 19:47:02',2),(17,3,1,'2020-02-03 13:12:42',3),(18,3,3,'2020-02-03 13:12:42',3),(19,3,4,'2020-02-03 13:12:42',3),(20,3,2,'2020-02-03 13:12:42',3),(21,3,5,'2020-02-03 13:12:42',3),(30,6,3,'2022-02-05 02:26:38',4),(31,6,5,'2022-02-05 02:26:38',4),(32,6,7,'2022-02-05 02:26:38',4),(36,4,1,'2022-02-15 11:41:33',4),(37,4,2,'2022-02-15 11:41:33',4),(38,4,3,'2022-02-15 11:41:33',4),(39,4,5,'2022-02-15 11:41:33',4),(40,4,6,'2022-02-15 11:41:33',4),(41,4,7,'2022-02-15 11:41:33',4),(42,4,8,'2022-02-15 11:41:33',4),(43,9,3,'2022-02-15 11:41:45',4),(44,9,5,'2022-02-15 11:41:45',4),(45,9,7,'2022-02-15 11:41:45',4),(46,9,8,'2022-02-15 11:41:45',4),(385,9,63,'2024-07-11 13:51:25',4);


