PX8n1rsK

1-- --------------------------------------------------------
2-- Host:                         localhost
3-- Server version:               10.1.25-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win32
5-- HeidiSQL Version:             10.2.0.5599
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-- Dumping structure for table 145_belanjapasti._vendor
15CREATE TABLE IF NOT EXISTS `_vendor` (
16  `vendor_id` int(11) NOT NULL AUTO_INCREMENT,
17  `vendor_type` enum('jabber','dial') NOT NULL,
18  `vendor_name` varchar(50) DEFAULT NULL,
19  `vendor_address` text,
20  `vendor_account` varchar(50) DEFAULT NULL,
21  `vendor_pin` varchar(50) DEFAULT NULL,
22  `vendor_status` enum('active','non-active') DEFAULT NULL,
23  `vendor_create_date` datetime DEFAULT NULL,
24  PRIMARY KEY (`vendor_id`)
25) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
26
27-- Dumping data for table 145_belanjapasti._vendor: ~0 rows (approximately)
28/*!40000 ALTER TABLE `_vendor` DISABLE KEYS */;
29INSERT INTO `_vendor` (`vendor_id`, `vendor_type`, `vendor_name`, `vendor_address`, `vendor_account`, `vendor_pin`, `vendor_status`, `vendor_create_date`) VALUES
30	(1, 'jabber', 'Salink', 'Yogyakarta', 'trx@salink.com', '1234', 'active', '2019-07-31 11:27:10');
31/*!40000 ALTER TABLE `_vendor` ENABLE KEYS */;
32
33-- Dumping structure for table 145_belanjapasti._vendor_response
34CREATE TABLE IF NOT EXISTS `_vendor_response` (
35  `v_response_id` int(11) NOT NULL AUTO_INCREMENT,
36  `vendor_id` int(11) DEFAULT NULL,
37  `v_response_type` enum('success','pending','process','failed') DEFAULT NULL,
38  `v_response_keyword` text,
39  `v_response_pars` text,
40  `v_response_regex` text,
41  `v_response_create_date` datetime DEFAULT NULL,
42  PRIMARY KEY (`v_response_id`)
43) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
44
45-- Dumping data for table 145_belanjapasti._vendor_response: ~0 rows (approximately)
46/*!40000 ALTER TABLE `_vendor_response` DISABLE KEYS */;
47INSERT INTO `_vendor_response` (`v_response_id`, `vendor_id`, `v_response_type`, `v_response_keyword`, `v_response_pars`, `v_response_regex`, `v_response_create_date`) VALUES
48	(1, 1, 'success', 'SuKses', 'MMC #[trxid] R#[refnum] [kode_produk].[tujuan] *', '', '2019-07-31 11:35:45');
49/*!40000 ALTER TABLE `_vendor_response` ENABLE KEYS */;
50
51/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
52/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
53/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;