trx_gg

CREATE TABLE `trx_gg`.`tbl_user` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `name` VARCHAR(100) NOT NULL , `email` VARCHAR(100) NOT NULL , `hp` VARCHAR(20) NOT NULL , `password` VARCHAR(150) NOT NULL , `saldo` INT NOT NULL , `is_fa` INT NOT NULL , `secret_fa` TEXT NOT NULL , `is_blocked` INT NOT NULL , `note` TEXT NOT NULL , `device_id` VARCHAR(150) NOT NULL, `created` DATE NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_addons` (`id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(100) NOT NULL , `image` TEXT NOT NULL , `kode_addon` VARCHAR(100) NOT NULL , `deskripsi` TEXT NOT NULL , `helper_html` TEXT NOT NULL , `price` INT NOT NULL, `config_form` TEXT NOT NULL, `status` INT NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
ALTER TABLE `tbl_addons` ADD `kategori` VARCHAR(100) NOT NULL AFTER `config_form`, ADD `is_bulanan` INT NOT NULL AFTER `kategori`;
ALTER TABLE `tbl_addons` ADD `kuota_transaksi_mp` INT NOT NULL COMMENT 'kuota transaksi mp per bulan' AFTER `is_bulanan`;
CREATE TABLE `trx_gg`.`tbl_addons_users` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `kode_addon` VARCHAR(100) NOT NULL , `config` TEXT NOT NULL , `status` INT NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_produk_users` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `name` VARCHAR(100) NOT NULL , `kode_produk` VARCHAR(100) NOT NULL , `kode_vendor` VARCHAR(100) NOT NULL , `kode_addon` VARCHAR(100) NOT NULL , `status` INT NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_produk_users_marketplace` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` INT NOT NULL , `kode_produk` VARCHAR(100) NOT NULL , `id_produk_mp` VARCHAR(200) NOT NULL COMMENT 'id produk dari marketplace' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_transaksi` (`id` INT NOT NULL AUTO_INCREMENT , `trx_id` VARCHAR(200) NOT NULL , `ref_id` VARCHAR(200) NOT NULL , `user_code` VARCHAR(100) NOT NULL , `kode_addon` VARCHAR(100) NOT NULL , `json_grab` TEXT NOT NULL , `additional_data` TEXT NOT NULL , `status` VARCHAR(200) NOT NULL , `created` DATE NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_transaksi_sub` (`id` INT NOT NULL AUTO_INCREMENT , `trx_id` VARCHAR(200) NOT NULL , `ref_id` VARCHAR(200) NOT NULL , `user_code` VARCHAR(100) NOT NULL , `id_produk_mp` VARCHAR(200) NOT NULL , `name_produk_mp` VARCHAR(200) NOT NULL , `kode_produk` VARCHAR(100) NOT NULL , `nama_produk` VARCHAR(200) NOT NULL , `sn` TEXT NOT NULL , `status` VARCHAR(200) NOT NULL , `created` DATE NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_log_mp` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `kode_addon` VARCHAR(100) NOT NULL , `event` VARCHAR(100) NOT NULL , `data` TEXT NOT NULL , `created_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_log_transaksi` (`id` INT NOT NULL AUTO_INCREMENT , `trx_id` VARCHAR(200) NOT NULL , `user_code` VARCHAR(100) NOT NULL , `event` VARCHAR(100) NOT NULL , `data` TEXT NOT NULL , `created_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_log_transaksi_sub` (`id` INT NOT NULL AUTO_INCREMENT , `ref_id_sub` VARCHAR(200) NOT NULL , `user_code` VARCHAR(100) NOT NULL , `event` VARCHAR(100) NOT NULL , `data` TEXT NOT NULL , `created_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_mutasi_saldo` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `kategori` VARCHAR(100) NOT NULL , `nominal` INT NOT NULL , `saldo_before` INT NOT NULL , `saldo_after` INT NOT NULL , `note` TEXT NOT NULL , `created_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_biaya_bulanan` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `kode_addon` VARCHAR(100) NOT NULL , `nama_addon` VARCHAR(100) NOT NULL , `price` INT NOT NULL , `kuota_transaksi_mp` INT NOT NULL COMMENT 'maksimal kuota yang dapat digunakan dalam sebulan' , `expired` DATE NOT NULL , `created` DATE NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

ALTER TABLE `tbl_biaya_bulanan` ADD `kategori` VARCHAR(100) NOT NULL AFTER `nama_addon`;
CREATE TABLE `trx_gg`.`tbl_invoice` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `name` VARCHAR(100) NOT NULL , `bulanan_id` INT NOT NULL , `bulanan_name` VARCHAR(100) NOT NULL , `status` INT NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_deposit` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `metode_id` INT NOT NULL , `metode_name` VARCHAR(100) NOT NULL , `nominal` INT NOT NULL , `biaya_admin` INT NOT NULL , `total_bayar` INT NOT NULL , `status` VARCHAR(100) NOT NULL , `created` DATE NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_users_team` (`id` INT NOT NULL AUTO_INCREMENT , `user_code` VARCHAR(100) NOT NULL , `name` VARCHAR(100) NOT NULL , `email` VARCHAR(100) NOT NULL , `password` VARCHAR(100) NOT NULL , `is_fa` INT NOT NULL , `secret_fa` TEXT NOT NULL , `status` INT NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_menu` (`id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(100) NOT NULL , `icon` VARCHAR(100) NOT NULL , `link` VARCHAR(100) NOT NULL , `status` INT NOT NULL , `created_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_menu_action` (`id` INT NOT NULL AUTO_INCREMENT , `menu_id` INT NOT NULL , `kategori` VARCHAR(50) NOT NULL COMMENT 'child || action' , `name` VARCHAR(100) NOT NULL , `link` VARCHAR(100) NOT NULL , `created_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_menu_team` (`id` INT NOT NULL AUTO_INCREMENT , `team_id` INT NOT NULL , `menu_id` INT NOT NULL , `action_id` INT NOT NULL , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `trx_gg`.`tbl_log_activity_team` (`id` INT NOT NULL AUTO_INCREMENT , `team_id` INT NOT NULL , `menu_id` INT NOT NULL , `action_id` INT NOT NULL , `note` VARCHAR(100) NOT NULL , `created` DATE NOT NULL , `created_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;