-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 18, 2026 at 05:06 PM
-- Server version: 10.11.16-MariaDB-cll-lve-log
-- PHP Version: 8.4.22

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `letsgobi_gpsta`
--

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

--
-- Table structure for table `device_data`
--

CREATE TABLE `device_data` (
  `id` bigint(20) NOT NULL,
  `seller_id` int(11) NOT NULL DEFAULT 1,
  `people_id` int(11) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `model` varchar(150) NOT NULL,
  `imei` varchar(120) NOT NULL,
  `vehicle_id` varchar(100) NOT NULL,
  `gsm_number` varchar(100) NOT NULL,
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `end_time` date NOT NULL DEFAULT current_timestamp(),
  `data_end_time` date DEFAULT NULL,
  `icon` varchar(255) NOT NULL DEFAULT 'car',
  `img` varchar(500) NOT NULL DEFAULT '',
  `status` varchar(5) NOT NULL DEFAULT '1',
  `day_log` tinyint(3) NOT NULL DEFAULT 7,
  `notif_power` varchar(20) NOT NULL DEFAULT 'yes',
  `notif_speed` varchar(20) NOT NULL DEFAULT 'yes',
  `notif_acc` varchar(20) NOT NULL DEFAULT 'no',
  `notif_city` varchar(20) NOT NULL DEFAULT 'yes',
  `deskripsi` varchar(500) NOT NULL DEFAULT '',
  `note` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `device_data_notification`
--

CREATE TABLE `device_data_notification` (
  `id` bigint(20) NOT NULL,
  `imei` varchar(120) DEFAULT NULL,
  `title` varchar(500) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `latitude` varchar(100) DEFAULT NULL,
  `longitude` varchar(100) DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `code` varchar(100) DEFAULT NULL,
  `color` varchar(100) NOT NULL DEFAULT 'medium',
  `id_data` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `device_data_uknown`
--

CREATE TABLE `device_data_uknown` (
  `id` int(11) NOT NULL,
  `imei` varchar(100) DEFAULT NULL,
  `device_type` varchar(150) NOT NULL,
  `latitude` varchar(100) NOT NULL DEFAULT '0',
  `longitude` varchar(100) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `geolocation`
--

CREATE TABLE `geolocation` (
  `id` bigint(20) NOT NULL,
  `latitude` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `longitude` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `gps_data`
--

CREATE TABLE `gps_data` (
  `id` bigint(20) NOT NULL,
  `imei` varchar(64) NOT NULL,
  `protocol_id` varchar(100) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `speed` decimal(10,0) NOT NULL DEFAULT 0,
  `speed_unit` varchar(100) DEFAULT NULL,
  `course` decimal(5,1) DEFAULT 0.0,
  `gps_status` varchar(50) DEFAULT NULL,
  `acc_status` varchar(50) DEFAULT NULL,
  `power_status` varchar(50) DEFAULT NULL,
  `battery_value` int(11) NOT NULL DEFAULT 0,
  `alarm` varchar(150) DEFAULT NULL,
  `cut_off` varchar(100) DEFAULT NULL,
  `gsm_signal_strength` int(11) DEFAULT 0,
  `error_check` varchar(150) DEFAULT NULL,
  `event` varchar(150) DEFAULT NULL,
  `lbs` varchar(100) DEFAULT NULL,
  `device_type` varchar(100) DEFAULT NULL,
  `device_time` datetime NOT NULL DEFAULT current_timestamp(),
  `server_time` datetime NOT NULL DEFAULT current_timestamp(),
  `distance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `city` varchar(50) NOT NULL DEFAULT '',
  `status_koneksi` varchar(50) NOT NULL DEFAULT 'online'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `gps_data_backup`
--

CREATE TABLE `gps_data_backup` (
  `id` bigint(20) NOT NULL,
  `imei` varchar(64) NOT NULL,
  `protocol_id` varchar(100) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `speed` decimal(10,0) NOT NULL DEFAULT 0,
  `speed_unit` varchar(100) DEFAULT NULL,
  `course` decimal(5,1) DEFAULT 0.0,
  `gps_status` varchar(50) DEFAULT NULL,
  `acc_status` varchar(50) DEFAULT NULL,
  `power_status` varchar(50) DEFAULT NULL,
  `battery_value` int(11) NOT NULL DEFAULT 0,
  `alarm` varchar(150) DEFAULT NULL,
  `cut_off` varchar(100) DEFAULT NULL,
  `gsm_signal_strength` int(11) DEFAULT 0,
  `error_check` varchar(150) DEFAULT NULL,
  `event` varchar(150) DEFAULT NULL,
  `lbs` varchar(100) DEFAULT NULL,
  `device_type` varchar(100) DEFAULT NULL,
  `device_time` datetime NOT NULL DEFAULT current_timestamp(),
  `server_time` datetime NOT NULL DEFAULT current_timestamp(),
  `distance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `address` varchar(500) DEFAULT NULL,
  `city` varchar(50) NOT NULL DEFAULT '',
  `status_koneksi` varchar(50) NOT NULL DEFAULT 'online'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `gps_data_last`
--

CREATE TABLE `gps_data_last` (
  `imei` varchar(64) NOT NULL,
  `protocol_id` varchar(100) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `speed` decimal(10,0) NOT NULL DEFAULT 0,
  `speed_unit` varchar(100) DEFAULT NULL,
  `course` decimal(5,1) DEFAULT 0.0,
  `gps_status` varchar(50) DEFAULT NULL,
  `acc_status` varchar(50) DEFAULT NULL,
  `power_status` varchar(50) DEFAULT NULL,
  `battery_value` int(11) NOT NULL DEFAULT 0,
  `alarm` varchar(150) DEFAULT NULL,
  `cut_off` varchar(100) DEFAULT NULL,
  `gsm_signal_strength` int(11) DEFAULT 0,
  `error_check` varchar(150) DEFAULT NULL,
  `event` varchar(150) DEFAULT NULL,
  `lbs` varchar(100) DEFAULT NULL,
  `device_type` varchar(100) DEFAULT NULL,
  `device_time` datetime NOT NULL DEFAULT current_timestamp(),
  `server_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `distance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `address` varchar(500) DEFAULT NULL,
  `city` varchar(50) NOT NULL DEFAULT '''''',
  `status_koneksi` varchar(50) NOT NULL DEFAULT '''online''',
  `port_tcp` varchar(6) NOT NULL DEFAULT '8090',
  `port_web` varchar(6) NOT NULL DEFAULT '3000',
  `ip_client` varchar(120) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `html_menu`
--

CREATE TABLE `html_menu` (
  `id` int(5) UNSIGNED ZEROFILL NOT NULL,
  `parent` int(5) UNSIGNED ZEROFILL NOT NULL,
  `url` varchar(255) NOT NULL,
  `target` varchar(100) NOT NULL DEFAULT '',
  `label` varchar(255) NOT NULL,
  `description` varchar(500) NOT NULL DEFAULT '',
  `icon` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `is_menu` tinyint(4) NOT NULL DEFAULT 1,
  `is_mobile` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `item`
--

CREATE TABLE `item` (
  `id` int(11) NOT NULL,
  `item_group` varchar(100) NOT NULL DEFAULT 'article_admin',
  `title` varchar(255) NOT NULL DEFAULT '',
  `subtitle` varchar(500) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `people`
--

CREATE TABLE `people` (
  `id` int(11) NOT NULL,
  `code` varchar(100) DEFAULT NULL,
  `nik` varchar(50) DEFAULT NULL,
  `pgroup` varchar(120) NOT NULL DEFAULT 'customers',
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `spv_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `address` varchar(500) NOT NULL DEFAULT '',
  `address_latitude` double DEFAULT NULL,
  `address_longitude` double DEFAULT NULL,
  `email` varchar(300) NOT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `pin` varchar(255) DEFAULT '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92',
  `auth_id` int(11) NOT NULL DEFAULT 100,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1=aktif, 0=tidak aktif, -1=suspend',
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `avatar` varchar(500) NOT NULL DEFAULT '',
  `tanggal_lahir` date NOT NULL DEFAULT current_timestamp(),
  `att_methode` varchar(100) NOT NULL DEFAULT '',
  `gender` varchar(50) NOT NULL DEFAULT '',
  `region` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `people_auth`
--

CREATE TABLE `people_auth` (
  `id` int(11) NOT NULL,
  `title` varchar(225) NOT NULL,
  `description` varchar(550) NOT NULL,
  `auth` varchar(1000) NOT NULL,
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `public` varchar(5) NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `people_device_link`
--

CREATE TABLE `people_device_link` (
  `id` int(11) NOT NULL,
  `people_id` int(11) DEFAULT NULL,
  `imei` varchar(120) NOT NULL,
  `end_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `people_session`
--

CREATE TABLE `people_session` (
  `id` int(11) NOT NULL,
  `people_id` int(11) NOT NULL DEFAULT 0,
  `headers_token` varchar(64) DEFAULT NULL,
  `login_token` varchar(64) DEFAULT NULL,
  `push_token` varchar(500) DEFAULT NULL,
  `headers` varchar(750) DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `ppob_item`
--

CREATE TABLE `ppob_item` (
  `id` int(11) NOT NULL,
  `code` varchar(20) DEFAULT NULL,
  `provider_` varchar(255) NOT NULL DEFAULT '',
  `provider_sub` varchar(255) NOT NULL DEFAULT '',
  `operator_` varchar(255) NOT NULL DEFAULT '',
  `operator_sub` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(500) NOT NULL DEFAULT '',
  `expired_day` int(5) NOT NULL DEFAULT 0,
  `price_` decimal(20,0) NOT NULL,
  `price_sale` decimal(20,0) NOT NULL,
  `status` varchar(100) NOT NULL DEFAULT '',
  `status_description` varchar(500) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `tag` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `row_data`
--

CREATE TABLE `row_data` (
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `imei` varchar(20) NOT NULL,
  `device_type` varchar(20) NOT NULL DEFAULT '',
  `protocol` varchar(120) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `_journal`
--

CREATE TABLE `_journal` (
  `id` bigint(20) NOT NULL,
  `id_sesi` bigint(20) DEFAULT 0,
  `id_transaksi` bigint(20) DEFAULT NULL,
  `people_id` int(11) NOT NULL,
  `kode_akun` enum('aset','utang','ekuitas','pendapatan','beban') NOT NULL DEFAULT 'aset',
  `debit` decimal(16,2) NOT NULL DEFAULT 0.00,
  `kredit` decimal(16,2) NOT NULL DEFAULT 0.00,
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` tinyint(3) NOT NULL DEFAULT 1,
  `tag` varchar(500) NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `_log`
--

CREATE TABLE `_log` (
  `id` int(11) NOT NULL,
  `people_id` int(11) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `description` varchar(500) NOT NULL,
  `command_type` varchar(24) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp(),
  `data` text DEFAULT NULL,
  `token` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `_mutasi_bank`
--

CREATE TABLE `_mutasi_bank` (
  `id` bigint(20) NOT NULL,
  `bank` varchar(120) NOT NULL DEFAULT '''''',
  `nama` varchar(120) NOT NULL DEFAULT '',
  `rekening` varchar(50) NOT NULL DEFAULT '',
  `mutasi` varchar(10) DEFAULT NULL,
  `nominal` decimal(16,2) NOT NULL DEFAULT 0.00,
  `saldo_akhir` decimal(16,2) NOT NULL DEFAULT 0.00,
  `bank_time` datetime NOT NULL,
  `create_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `nama_pengirim` varchar(120) NOT NULL DEFAULT '',
  `keterangan` varchar(350) NOT NULL,
  `row` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `_order`
--

CREATE TABLE `_order` (
  `id` bigint(20) NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `ogroup` enum('penjualan','pembelian','deposit','') NOT NULL,
  `id_produk` bigint(20) NOT NULL DEFAULT 0,
  `id_pelanggan` varchar(100) DEFAULT NULL,
  `id_akun_pembayaran` int(11) DEFAULT NULL,
  `id_mutasi_pembayaran` bigint(20) DEFAULT NULL,
  `modal` decimal(16,2) NOT NULL DEFAULT 0.00,
  `jual` decimal(16,2) NOT NULL DEFAULT 0.00,
  `kode_unik` decimal(5,0) NOT NULL DEFAULT 0,
  `keterangan` varchar(500) NOT NULL,
  `create_time` datetime NOT NULL DEFAULT current_timestamp(),
  `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` enum('berhasil','menunggu','refund','gagal','belum diproses','status tidak valid','menunggu pembayaran') NOT NULL DEFAULT 'gagal',
  `payment_code` text NOT NULL DEFAULT '',
  `expire_time` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `_tes`
--

CREATE TABLE `_tes` (
  `id` int(11) NOT NULL,
  `content` text NOT NULL,
  `create_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `device_data`
--
ALTER TABLE `device_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Imei / Serial` (`imei`),
  ADD KEY `people_id` (`people_id`),
  ADD KEY `status` (`status`),
  ADD KEY `create_time` (`create_time`),
  ADD KEY `end_time` (`end_time`);

--
-- Indexes for table `device_data_notification`
--
ALTER TABLE `device_data_notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `device_data_uknown`
--
ALTER TABLE `device_data_uknown`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `imei` (`imei`);

--
-- Indexes for table `geolocation`
--
ALTER TABLE `geolocation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `update_time` (`update_time`),
  ADD KEY `longitude_index` (`longitude`) USING BTREE,
  ADD KEY `latitude_index` (`latitude`) USING BTREE;

--
-- Indexes for table `gps_data`
--
ALTER TABLE `gps_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `imei` (`imei`,`server_time`),
  ADD KEY `distance` (`distance`),
  ADD KEY `server_time` (`server_time`);

--
-- Indexes for table `gps_data_backup`
--
ALTER TABLE `gps_data_backup`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `imei` (`imei`,`server_time`),
  ADD KEY `distance` (`distance`),
  ADD KEY `server_time` (`server_time`);

--
-- Indexes for table `gps_data_last`
--
ALTER TABLE `gps_data_last`
  ADD PRIMARY KEY (`imei`),
  ADD KEY `latitude` (`latitude`),
  ADD KEY `longitude` (`longitude`),
  ADD KEY `device_time` (`device_time`),
  ADD KEY `server_time` (`server_time`),
  ADD KEY `speed` (`speed`);

--
-- Indexes for table `html_menu`
--
ALTER TABLE `html_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `item`
--
ALTER TABLE `item`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `people`
--
ALTER TABLE `people`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Alamat Email` (`email`),
  ADD UNIQUE KEY `phone` (`phone`),
  ADD UNIQUE KEY `nik` (`nik`);

--
-- Indexes for table `people_auth`
--
ALTER TABLE `people_auth`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `people_device_link`
--
ALTER TABLE `people_device_link`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Imei` (`people_id`,`imei`) USING BTREE;

--
-- Indexes for table `people_session`
--
ALTER TABLE `people_session`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `token` (`login_token`),
  ADD UNIQUE KEY `people_id` (`people_id`,`headers_token`) USING BTREE,
  ADD UNIQUE KEY `push_token` (`push_token`);

--
-- Indexes for table `ppob_item`
--
ALTER TABLE `ppob_item`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `provider_` (`provider_`),
  ADD KEY `title` (`title`),
  ADD KEY `operator_` (`operator_`);

--
-- Indexes for table `row_data`
--
ALTER TABLE `row_data`
  ADD PRIMARY KEY (`imei`);

--
-- Indexes for table `_journal`
--
ALTER TABLE `_journal`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_transaksi` (`id_transaksi`);

--
-- Indexes for table `_log`
--
ALTER TABLE `_log`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `command_type` (`command_type`,`token`);

--
-- Indexes for table `_mutasi_bank`
--
ALTER TABLE `_mutasi_bank`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nominal` (`nominal`,`keterangan`);

--
-- Indexes for table `_order`
--
ALTER TABLE `_order`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_mutasi_pembayaran` (`id_mutasi_pembayaran`),
  ADD KEY `_order_ibfk_1` (`id_akun_pembayaran`);

--
-- Indexes for table `_tes`
--
ALTER TABLE `_tes`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `device_data`
--
ALTER TABLE `device_data`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `device_data_notification`
--
ALTER TABLE `device_data_notification`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `device_data_uknown`
--
ALTER TABLE `device_data_uknown`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geolocation`
--
ALTER TABLE `geolocation`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gps_data`
--
ALTER TABLE `gps_data`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gps_data_backup`
--
ALTER TABLE `gps_data_backup`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `html_menu`
--
ALTER TABLE `html_menu`
  MODIFY `id` int(5) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `item`
--
ALTER TABLE `item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `people`
--
ALTER TABLE `people`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `people_auth`
--
ALTER TABLE `people_auth`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `people_device_link`
--
ALTER TABLE `people_device_link`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `people_session`
--
ALTER TABLE `people_session`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ppob_item`
--
ALTER TABLE `ppob_item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `_journal`
--
ALTER TABLE `_journal`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `_log`
--
ALTER TABLE `_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `_mutasi_bank`
--
ALTER TABLE `_mutasi_bank`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `_order`
--
ALTER TABLE `_order`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `_tes`
--
ALTER TABLE `_tes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `device_data`
--
ALTER TABLE `device_data`
  ADD CONSTRAINT `people_id` FOREIGN KEY (`people_id`) REFERENCES `people` (`id`);

--
-- Constraints for table `people_device_link`
--
ALTER TABLE `people_device_link`
  ADD CONSTRAINT `people_device_link_ibfk_1` FOREIGN KEY (`people_id`) REFERENCES `people` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `_order`
--
ALTER TABLE `_order`
  ADD CONSTRAINT `_order_ibfk_1` FOREIGN KEY (`id_akun_pembayaran`) REFERENCES `people` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;