 --
 
 CREATE TABLE IF NOT EXISTS `ms_mail_sender` (
+  `uuid_ms_mail_sender` varchar(255) NOT NULL,
   `uuid_ms_mail` varchar(255) NOT NULL,
   `is_viewable` varchar(5) NOT NULL DEFAULT '1',
   `is_removed` varchar(5) NOT NULL DEFAULT '0',

-- Dumping data untuk tabel `ms_mail_receiver`
--

INSERT INTO `ms_mail_receiver` (`uuid_ms_mail`, `is_viewable`, `is_removed`, `dtm_upd`) VALUES
('46b33c27-11d1-11e7-8ed1-c454448293a1', '1', '0', NULL),
('56ab90a3-11d3-11e7-8ed1-c454448293a1', '1', '1', '2017-03-26 11:01:00'),
('ccf4d55c-1104-11e7-ba67-c454448293a1', '1', '0', '2017-03-26 11:00:06');

-- --------------------------------------------------------



INSERT INTO `ms_user` (`uuid_ms_user`, `username`, `password`, `full_name`, `email`, `dtm_crt`, `dtm_upd`, `uuid_ms_subsystem`, `is_logged_in`, `is_active`) VALUES
('022a594f-0864-11e7-ab84-c454448293a1', 'medcoenergi', 'd41d8cd98f00b204e9800998ecf8427e', 'Medco Energi', 'medcoenergi@gmail.com', '2017-03-14 10:12:08', '2017-03-16 22:20:14', 'd8067dd0-06ba-11e7-88db-c454448293a1', '0', '1'),
('08058593-06bc-11e7-88db-c454448293a1', 'wira', '5f4dcc3b5aa765d61d8327deb882cf99', 'Wiratama Paramasatya', 'wiratamaparamasatya@forecasting-product.com', '2017-03-12 07:37:11', '2017-03-12 11:27:03', '4249b7c8-06ba-11e7-88db-c454448293a1', '0', '1'),
('080597de-06bc-11e7-88db-c454448293a1', 'dianekaratnawati', '5f4dcc3b5aa765d61d8327deb882cf99', 'Dian Eka Ratnawati', 'dianekaratnawati@forecasting-product.com', '2017-03-12 07:39:16', '2017-03-12 11:27:03', '4249cbf4-06ba-11e7-88db-c454448293a1', '0', '1'),
('0805a5a1-06bc-11e7-88db-c454448293a1', 'wiratamap', '5f4dcc3b5aa765d61d8327deb882cf99', 'Wiratama Paramasatya', 'wiratamaparamasatya@gmail.com', '2017-03-12 07:37:11', '2017-03-12 11:27:03', 'd8067dd0-06ba-11e7-88db-c454448293a1', '1', '1'),
('094659d8-0865-11e7-ab84-c454448293a1', 'bursaefekindo', '0ed542b815a0d4b0c457ad9def1a21d2', 'Bursa Efek Indonesia', 'bursaefek@bei.co.id', '2017-03-14 10:19:29', '2017-03-25 12:50:19', 'd8067dd0-06ba-11e7-88db-c454448293a1', '0', '0'),
('27f66226-08ba-11e7-be2c-c454448293a1', 'tokopedia', '5f4dcc3b5aa765d61d8327deb882cf99', 'PT Tokopedia', 'tokopedia@tokopedia.com', '2017-03-14 20:28:48', '2017-03-26 10:22:42', 'd8067dd0-06ba-11e7-88db-c454448293a1', '0', '1'),
('37dbb705-08ba-11e7-be2c-c454448293a1', 'ojkindonesia', '5f4dcc3b5aa765d61d8327deb882cf99', 'Otoritas Jasa Keuangan', 'ojkindonesia@ojk.gov.id', '2017-03-14 20:29:15', '2017-03-16 22:42:23', 'd8067dd0-06ba-11e7-88db-c454448293a1', '0', '1'),
