Da

✏️ Editing: ccpacth_fertilizer.sql

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

/*!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: `ccpacth_fertilizer`
--

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

USE `ccpacth_fertilizer`;

--
-- Table structure for table `calculate_fertilizer`
--

DROP TABLE IF EXISTS `calculate_fertilizer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calculate_fertilizer` (
  `calculate_fertilizerID` int(11) NOT NULL AUTO_INCREMENT,
  `sahakornID` int(11) DEFAULT NULL,
  `year` int(4) DEFAULT NULL,
  `name_pui_C` char(10) DEFAULT NULL,
  `remaining` decimal(50,2) DEFAULT NULL,
  `buy` decimal(50,2) DEFAULT NULL,
  `sell` decimal(50,2) DEFAULT NULL,
  `pick_up` decimal(50,2) DEFAULT NULL,
  `year_balance` decimal(50,2) DEFAULT NULL,
  `countable_F` decimal(50,2) DEFAULT NULL,
  `tooshort_F` decimal(50,2) DEFAULT NULL,
  `sack_C` decimal(50,2) DEFAULT NULL,
  PRIMARY KEY (`calculate_fertilizerID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calculate_fertilizer`
--

LOCK TABLES `calculate_fertilizer` WRITE;
/*!40000 ALTER TABLE `calculate_fertilizer` DISABLE KEYS */;
INSERT INTO `calculate_fertilizer` VALUES (8,4,2567,'46-0-0',32.50,151700.00,11350.00,137149.00,3233.50,3233.50,0.00,0.00),(9,0,2567,'46-0-0',1000.00,1500.00,1150.00,0.00,1350.00,1800.00,450.00,9.00),(10,4,2567,'18-46-0',1703.82,52700.00,1150.00,48361.50,4892.32,3862.32,-1030.00,-20.60),(11,4,2567,'0-0-60',2678.68,131500.00,11250.00,115789.50,7139.18,6369.18,-770.00,-15.40);
/*!40000 ALTER TABLE `calculate_fertilizer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calculate_remaining`
--

DROP TABLE IF EXISTS `calculate_remaining`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calculate_remaining` (
  `calculate_remainingID` int(11) NOT NULL AUTO_INCREMENT,
  `sahakornID` int(11) DEFAULT NULL,
  `year` int(4) DEFAULT NULL,
  `formulaID` int(11) DEFAULT NULL,
  `remaining_pui` decimal(50,2) DEFAULT NULL,
  `from_production` decimal(50,2) DEFAULT NULL,
  `sell_pui` decimal(50,2) DEFAULT NULL,
  `use` decimal(50,2) DEFAULT NULL,
  `pui_year_balance` decimal(50,2) DEFAULT NULL,
  `sack_R` decimal(50,2) DEFAULT NULL,
  `countable_R` decimal(50,2) DEFAULT NULL,
  `tooshort_R` decimal(50,2) DEFAULT NULL,
  PRIMARY KEY (`calculate_remainingID`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calculate_remaining`
--

LOCK TABLES `calculate_remaining` WRITE;
/*!40000 ALTER TABLE `calculate_remaining` DISABLE KEYS */;
INSERT INTO `calculate_remaining` VALUES (24,4,2567,31,50.00,102750.00,100750.00,50.00,2000.00,40.00,40.00,0.00),(25,4,2567,33,3950.00,136300.00,138350.00,0.00,1900.00,38.00,40.00,2.00),(26,4,2567,34,2300.00,39800.00,40150.00,550.00,1400.00,28.00,27.00,-1.00),(27,4,2567,32,0.00,2500.00,2450.00,50.00,0.00,0.00,0.00,0.00),(28,4,2567,35,200.00,6250.00,5450.00,350.00,650.00,13.00,13.00,0.00),(29,4,2567,36,350.00,2050.00,2300.00,0.00,100.00,2.00,2.00,0.00),(30,4,2567,37,0.00,10150.00,10150.00,0.00,0.00,0.00,0.00,0.00),(31,4,2567,38,400.00,1500.00,1750.00,0.00,150.00,3.00,3.00,0.00),(32,0,2567,32,0.00,0.00,2450.00,50.00,-2500.00,-50.00,0.00,50.00);
/*!40000 ALTER TABLE `calculate_remaining` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `formula`
--

DROP TABLE IF EXISTS `formula`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `formula` (
  `formulaID` int(11) NOT NULL AUTO_INCREMENT,
  `name_formula` varchar(300) NOT NULL,
  `46-0-0` decimal(60,2) NOT NULL,
  `18-46-0` decimal(60,2) NOT NULL,
  `0-0-60` decimal(60,2) NOT NULL,
  PRIMARY KEY (`formulaID`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `formula`
--

LOCK TABLES `formula` WRITE;
/*!40000 ALTER TABLE `formula` DISABLE KEYS */;
INSERT INTO `formula` VALUES (31,'20-8-20',20.00,10.00,20.00),(32,'19-19-19',13.00,21.00,16.00),(33,'30-5-18',30.00,5.00,15.00),(34,'13-9-36',10.00,10.00,30.00),(35,'15-15-15',14.00,20.00,16.00),(36,'13-13-21',11.50,17.50,21.00),(37,'14-7-35',12.50,8.00,29.50),(38,'25-7-7',30.00,11.00,9.00);
/*!40000 ALTER TABLE `formula` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mother_pui`
--

DROP TABLE IF EXISTS `mother_pui`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mother_pui` (
  `mother_puiID` int(11) NOT NULL AUTO_INCREMENT,
  `sahakornID` int(11) DEFAULT NULL,
  `year` int(4) DEFAULT NULL,
  `m_sack` decimal(50,2) DEFAULT NULL,
  `name_pui` char(10) DEFAULT NULL,
  `m_sum` decimal(50,2) DEFAULT NULL,
  PRIMARY KEY (`mother_puiID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mother_pui`
--

LOCK TABLES `mother_pui` WRITE;
/*!40000 ALTER TABLE `mother_pui` DISABLE KEYS */;
INSERT INTO `mother_pui` VALUES (7,4,2567,6026.00,'46-0-0',137149.00),(8,4,2567,6026.00,'18-46-0',48361.50),(9,4,2567,6026.00,'0-0-60',115789.50);
/*!40000 ALTER TABLE `mother_pui` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sahakorn`
--

DROP TABLE IF EXISTS `sahakorn`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sahakorn` (
  `sahakornID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`sahakornID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sahakorn`
--

LOCK TABLES `sahakorn` WRITE;
/*!40000 ALTER TABLE `sahakorn` DISABLE KEYS */;
INSERT INTO `sahakorn` VALUES (4,'สหกรณ์การเกษตรทดสอบจำกัด');
/*!40000 ALTER TABLE `sahakorn` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sahakorn_process`
--

DROP TABLE IF EXISTS `sahakorn_process`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sahakorn_process` (
  `sahakorn_processID` int(11) NOT NULL AUTO_INCREMENT,
  `sahakornID` int(11) DEFAULT NULL,
  `year` int(4) DEFAULT NULL,
  `formulaID` int(11) DEFAULT NULL,
  `sack` decimal(50,2) DEFAULT NULL,
  `S_mother_pui` char(10) DEFAULT NULL,
  `sum` decimal(50,2) DEFAULT NULL,
  PRIMARY KEY (`sahakorn_processID`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sahakorn_process`
--

LOCK TABLES `sahakorn_process` WRITE;
/*!40000 ALTER TABLE `sahakorn_process` DISABLE KEYS */;
INSERT INTO `sahakorn_process` VALUES (61,0,0,0,0.00,'46-0-0',0.00),(62,0,0,0,0.00,'18-46-0',0.00),(63,0,0,0,0.00,'0-0-60',0.00),(64,4,2567,31,2055.00,'46-0-0',41100.00),(65,4,2567,31,2055.00,'18-46-0',20550.00),(66,4,2567,31,2055.00,'0-0-60',41100.00),(67,4,2567,32,50.00,'46-0-0',650.00),(68,4,2567,32,50.00,'18-46-0',1050.00),(69,4,2567,32,50.00,'0-0-60',800.00),(70,4,2567,33,2726.00,'46-0-0',81780.00),(71,4,2567,33,2726.00,'18-46-0',13630.00),(72,4,2567,33,2726.00,'0-0-60',40890.00),(73,4,2567,34,796.00,'46-0-0',7960.00),(74,4,2567,34,796.00,'18-46-0',7960.00),(75,4,2567,34,796.00,'0-0-60',23880.00),(76,4,2567,35,125.00,'46-0-0',1750.00),(77,4,2567,35,125.00,'18-46-0',2500.00),(78,4,2567,35,125.00,'0-0-60',2000.00),(79,4,2567,36,41.00,'46-0-0',471.50),(80,4,2567,36,41.00,'18-46-0',717.50),(81,4,2567,36,41.00,'0-0-60',861.00),(82,4,2567,37,203.00,'46-0-0',2537.50),(83,4,2567,37,203.00,'18-46-0',1624.00),(84,4,2567,37,203.00,'0-0-60',5988.50),(85,4,2567,38,30.00,'46-0-0',900.00),(86,4,2567,38,30.00,'18-46-0',330.00),(87,4,2567,38,30.00,'0-0-60',270.00);
/*!40000 ALTER TABLE `sahakorn_process` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `last_name` varchar(200) NOT NULL,
  `username` varchar(150) NOT NULL,
  `password` varchar(150) NOT NULL,
  `login_status` enum('0','100','','') NOT NULL DEFAULT '0',
  `admin_status` enum('0','1','','') NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'นายทวีศักดิ์','โต๊ะหลี','admin','8663b8e43187204222bacec2c256fe24e8ea362ddd97c628c6bd8ad4be4fd2c5','100','1'),(11,'สุกัญญา','สุขเรือง','sukanya','6b8dcfb2d78974464e57ec901b875797935e3f840490a8ac9ca1123e538e5356','0','0'),(13,'อังสนา','วัฒนโยธิน','uangsana','63bd00ce84bb5169f95ce0b367894d5292f38d601ad5dee9f6bc3f224a589cdc','0','0'),(14,'วีณัส','คุ้มสุข','tear','6b8dcfb2d78974464e57ec901b875797935e3f840490a8ac9ca1123e538e5356','0','0'),(15,'กฤตภคิน ','พิมพ์สวัสดิ์','kritpakin','3a1f9412f7694a25369d7fc6125a2edfcad089f3c5cbb29df146b3ac6ec7ce13','0','0'),(16,'สุมณฑา','มุลกุล','yayha001','089a7fa89badb491ce9b0f1604fd470e04d4f62bc2bc23280544bc22c6cbf131','0','0'),(21,'คุณกิตติมา','สุขจันทรา','kittima','6b8dcfb2d78974464e57ec901b875797935e3f840490a8ac9ca1123e538e5356','100','0'),(24,'นางสาวกุจชวัล','ดวงคงทอง','gift','6b8dcfb2d78974464e57ec901b875797935e3f840490a8ac9ca1123e538e5356','0','0');
/*!40000 ALTER TABLE `user` 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-31 13:19:17

📁 Sid Gifari File Manager