Da

✏️ Editing: dappserv_ultra.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: dappserv_ultra
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `dappserv_ultra`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `dappserv_ultra` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `dappserv_ultra`;

--
-- Table structure for table `commissions`
--

DROP TABLE IF EXISTS `commissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `commissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dep_id` int(11) NOT NULL,
  `uid` varchar(30) NOT NULL,
  `frm` varchar(30) NOT NULL,
  `amount` varchar(30) DEFAULT NULL,
  `com` varchar(30) DEFAULT NULL,
  `status` int(10) DEFAULT 1,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=656 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `commissions`
--

LOCK TABLES `commissions` WRITE;
/*!40000 ALTER TABLE `commissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `commissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deposits`
--

DROP TABLE IF EXISTS `deposits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `deposits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(34) DEFAULT NULL,
  `uid` varchar(30) DEFAULT NULL,
  `package` int(11) NOT NULL DEFAULT 1,
  `percent` varchar(10) DEFAULT NULL,
  `amount` varchar(30) NOT NULL,
  `status` int(10) DEFAULT 1,
  `txid` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `dna` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=917 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deposits`
--

LOCK TABLES `deposits` WRITE;
/*!40000 ALTER TABLE `deposits` DISABLE KEYS */;
INSERT INTO `deposits` VALUES (916,'dGZAoV3yVqo1qkfRjrlK1KRLUb8SpsiPJE','uw0001',1,'5','10000',2,NULL,'upload/deposit/1649252918.jpeg','[]','2022-04-06 13:48:38','2022-04-07 01:43:54');
/*!40000 ALTER TABLE `deposits` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `packages`
--

DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `price` int(11) NOT NULL,
  `percent` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `packages`
--

LOCK TABLES `packages` WRITE;
/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
INSERT INTO `packages` VALUES (1,5000,'5',NULL,NULL),(2,10000,'5',NULL,NULL),(3,30000,'5',NULL,NULL),(4,50000,'5',NULL,NULL),(5,100000,'5',NULL,NULL),(6,300000,'5',NULL,NULL),(7,500000,'6',NULL,NULL),(8,800000,'6',NULL,NULL),(11,1000000,'7.5',NULL,NULL),(12,3000000,'7.5',NULL,NULL),(13,5000000,'7.5',NULL,NULL);
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ports`
--

DROP TABLE IF EXISTS `ports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ports` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pid` varchar(34) DEFAULT NULL,
  `uid` varchar(30) DEFAULT NULL,
  `percent` varchar(20) DEFAULT NULL,
  `amount` varchar(30) DEFAULT NULL,
  `status` int(10) DEFAULT 1,
  `dna` text DEFAULT NULL,
  `payout` varchar(30) DEFAULT NULL,
  `com` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=361 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ports`
--

LOCK TABLES `ports` WRITE;
/*!40000 ALTER TABLE `ports` DISABLE KEYS */;
INSERT INTO `ports` VALUES (301,'916','uw0001','5','500',2,'[]','22-04-2022',2,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(302,'916','uw0001','5','500',2,'[]','07-05-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(303,'916','uw0001','5','500',1,'[]','22-05-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(304,'916','uw0001','5','500',1,'[]','06-06-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(305,'916','uw0001','5','500',1,'[]','21-06-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(306,'916','uw0001','5','500',1,'[]','06-07-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(307,'916','uw0001','5','500',1,'[]','21-07-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(308,'916','uw0001','5','500',1,'[]','05-08-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(309,'916','uw0001','5','500',1,'[]','20-08-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(310,'916','uw0001','5','500',1,'[]','04-09-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(311,'916','uw0001','5','500',1,'[]','19-09-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(312,'916','uw0001','5','500',1,'[]','04-10-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(313,'916','uw0001','5','500',1,'[]','19-10-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(314,'916','uw0001','5','500',1,'[]','03-11-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(315,'916','uw0001','5','500',1,'[]','18-11-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(316,'916','uw0001','5','500',1,'[]','03-12-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(317,'916','uw0001','5','500',1,'[]','18-12-2022',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(318,'916','uw0001','5','500',1,'[]','02-01-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(319,'916','uw0001','5','500',1,'[]','17-01-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(320,'916','uw0001','5','500',1,'[]','01-02-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(321,'916','uw0001','5','500',1,'[]','16-02-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(322,'916','uw0001','5','500',1,'[]','03-03-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(323,'916','uw0001','5','500',1,'[]','18-03-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(324,'916','uw0001','5','500',1,'[]','02-04-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(325,'916','uw0001','5','500',1,'[]','17-04-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(326,'916','uw0001','5','500',1,'[]','02-05-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(327,'916','uw0001','5','500',1,'[]','17-05-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(328,'916','uw0001','5','500',1,'[]','01-06-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(329,'916','uw0001','5','500',1,'[]','16-06-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(330,'916','uw0001','5','500',1,'[]','01-07-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(331,'916','uw0001','5','500',1,'[]','16-07-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(332,'916','uw0001','5','500',1,'[]','31-07-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(333,'916','uw0001','5','500',1,'[]','15-08-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(334,'916','uw0001','5','500',1,'[]','30-08-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(335,'916','uw0001','5','500',1,'[]','14-09-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(336,'916','uw0001','5','500',1,'[]','29-09-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(337,'916','uw0001','5','500',1,'[]','14-10-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(338,'916','uw0001','5','500',1,'[]','29-10-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(339,'916','uw0001','5','500',1,'[]','13-11-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(340,'916','uw0001','5','500',1,'[]','28-11-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(341,'916','uw0001','5','500',1,'[]','13-12-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(342,'916','uw0001','5','500',1,'[]','28-12-2023',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(343,'916','uw0001','5','500',1,'[]','12-01-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(344,'916','uw0001','5','500',1,'[]','27-01-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(345,'916','uw0001','5','500',1,'[]','11-02-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(346,'916','uw0001','5','500',1,'[]','26-02-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(347,'916','uw0001','5','500',1,'[]','12-03-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(348,'916','uw0001','5','500',1,'[]','27-03-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(349,'916','uw0001','5','500',1,'[]','11-04-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(350,'916','uw0001','5','500',1,'[]','26-04-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(351,'916','uw0001','5','500',1,'[]','11-05-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(352,'916','uw0001','5','500',1,'[]','26-05-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(353,'916','uw0001','5','500',1,'[]','10-06-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(354,'916','uw0001','5','500',1,'[]','25-06-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(355,'916','uw0001','5','500',1,'[]','10-07-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(356,'916','uw0001','5','500',1,'[]','25-07-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(357,'916','uw0001','5','500',1,'[]','09-08-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(358,'916','uw0001','5','500',1,'[]','24-08-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(359,'916','uw0001','5','500',1,'[]','08-09-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54'),(360,'916','uw0001','5','500',1,'[]','23-09-2024',1,'2022-04-07 01:43:54','2022-04-07 01:43:54');
/*!40000 ALTER TABLE `ports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `statuses`
--

DROP TABLE IF EXISTS `statuses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `statuses`
--

LOCK TABLES `statuses` WRITE;
/*!40000 ALTER TABLE `statuses` DISABLE KEYS */;
INSERT INTO `statuses` VALUES (1,'รออนุมัติ',NULL,NULL),(2,'อนุมัติ',NULL,NULL);
/*!40000 ALTER TABLE `statuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `is_user` int(11) NOT NULL DEFAULT 4,
  `username` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `referral` varchar(30) DEFAULT NULL,
  `dna` text DEFAULT NULL,
  `pwd` varchar(30) DEFAULT NULL,
  `bank_acc` varchar(60) DEFAULT NULL,
  `bank_name` varchar(30) DEFAULT NULL,
  `bank_number` varchar(30) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,1,'uw0001','0625729111',NULL,'$2y$10$y/2sxvYRV8pszZQD2wkU5uo32lZUVFzoDTdSVWjOLSEjuE7mcdnjC',NULL,'[]','123456','itti','กสิกร','0342922236',NULL,'2022-03-14 05:08:44','2022-03-16 05:39:15'),(3,4,'uw0003','083774888',NULL,'$2y$10$lJIFuhoyMi/ObF6557SBLOLRZUxCJUuiMWe.aw2K1LCFYVAAARvHu',NULL,'[]','1234',NULL,NULL,NULL,NULL,'2022-04-08 04:23:28','2022-04-08 04:34:25');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `withdraws`
--

DROP TABLE IF EXISTS `withdraws`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `withdraws` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `txid` varchar(60) DEFAULT NULL,
  `uid` varchar(30) NOT NULL,
  `amount` varchar(30) DEFAULT NULL,
  `bank_acc` varchar(60) DEFAULT NULL,
  `bank_name` varchar(30) DEFAULT NULL,
  `bank_number` varchar(30) DEFAULT NULL,
  `status` int(10) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=432 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `withdraws`
--

LOCK TABLES `withdraws` WRITE;
/*!40000 ALTER TABLE `withdraws` DISABLE KEYS */;
INSERT INTO `withdraws` VALUES (429,'xz1c5klnkgvds5tm63dvishuwto4dqr4o5','uw0001','100','itti','กสิกร','0342922236',1,'2022-04-08 02:45:24','2022-04-08 02:45:24'),(430,'msg6zxffmp1rnonirordfvi6ydswo0c8o5','uw0001','200','itti','กสิกร','0342922236',1,'2022-04-08 04:00:33','2022-04-08 04:00:33'),(431,'b8ha1cng8thpgtkdqmixbxlkbslzetzdnr','uw0001','500','itti','กสิกร','0342922236',1,'2022-04-08 04:00:49','2022-04-08 04:00:49');
/*!40000 ALTER TABLE `withdraws` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-22 16:49:21

📁 Sid Gifari File Manager