-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 31, 2023 at 09:42 PM
-- Server version: 8.0.31
-- PHP Version: 8.0.26

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: `cclub_agents_club`
--

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

--
-- Table structure for table `tb_regumedia`
--

DROP TABLE IF EXISTS `tb_regumedia`;
CREATE TABLE IF NOT EXISTS `tb_regumedia` (
  `rGmID` bigint NOT NULL AUTO_INCREMENT,
  `rGmkey` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `rGmode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `rGmkind` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `rGmstatus` int NOT NULL DEFAULT '0',
  `rGmemberID` bigint NOT NULL,
  `rGmPARentID` bigint NOT NULL,
  `rGmtitle` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `rGmDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rGmID`),
  KEY `rGmkey` (`rGmkey`),
  KEY `rGmode` (`rGmode`),
  KEY `rGmkind` (`rGmkind`),
  KEY `rGmstatus` (`rGmstatus`),
  KEY `rGmemberID` (`rGmemberID`),
  KEY `rGmPARentID` (`rGmPARentID`),
  KEY `rGmtitle` (`rGmtitle`),
  KEY `rGmDate` (`rGmDate`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_regumedia`
--

INSERT INTO `tb_regumedia` (`rGmID`, `rGmkey`, `rGmode`, `rGmkind`, `rGmstatus`, `rGmemberID`, `rGmPARentID`, `rGmtitle`, `rGmDate`) VALUES
(1, 'rGmlist', 'member', 'reGtv', 1, 1, 1, 'bright lab edited', '2023-12-13 22:44:44'),
(2, 'rGmlist', 'member', 'reGmaz', 1, 1, 1, 'bright lab edited', '2023-12-13 22:44:44'),
(3, 'rGmlist', 'member', 'reGmaz', 1, 480, 486, 'DANUBE APPRAISER', '2023-12-14 23:41:09'),
(4, 'rGmlist', 'member', 'reGmaz', 1, 478, 484, 'DANUBE AGENCY', '2023-12-14 23:41:38'),
(5, 'rGmlist', 'member', 'reGtv', 1, 476, 482, 'DAN UBE', '2023-12-14 23:41:43'),
(6, 'rGmlist', 'member', 'reGtv', 1, 477, 483, 'ALARKAN KAN', '2023-12-14 23:41:46'),
(7, 'rGmlist', 'member', 'reGtv', 1, 465, 464, 'AGENCY2 THIRD', '2023-12-14 23:41:49'),
(8, 'rGmlist', 'member', 'reGtv', 1, 480, 486, 'DANUBE APPRAISER', '2023-12-15 21:33:44'),
(9, 'rGmlist', 'member', 'reGmaz', 1, 471, 477, 'OXFAM APPRAISER', '2024-01-01 00:34:56');
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 */;
