Da

✏️ Editing: godexint_stock.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: godexint_stock
-- ------------------------------------------------------
-- 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: `godexint_stock`
--

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

USE `godexint_stock`;

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS `employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee` (
  `emp_id` int(4) NOT NULL AUTO_INCREMENT,
  `emp_fname` varchar(100) NOT NULL,
  `emp_lname` varchar(100) NOT NULL,
  `emp_tel` varchar(10) NOT NULL,
  `emp_position` varchar(100) NOT NULL,
  `emp_username` varchar(100) NOT NULL,
  `emp_password` varchar(100) NOT NULL,
  `emp_date` date NOT NULL,
  `emp_status` varchar(100) NOT NULL,
  PRIMARY KEY (`emp_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee`
--

LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES (1,'Administrator','','','ผู้ดูแลระบบ','admin','admin','2016-02-03','ใช้งาน'),(13,'test','','','ผู้ใช้ทั่วไป','test','test','2017-04-29','ใช้งาน');
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inventory`
--

DROP TABLE IF EXISTS `inventory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory` (
  `inv_receipt` varchar(30) NOT NULL,
  `inv_total` double NOT NULL,
  `inv_from` varchar(100) NOT NULL,
  `inv_date` date NOT NULL,
  `emp_id` varchar(4) NOT NULL,
  `inv_note` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inventory`
--

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

--
-- Table structure for table `inventory_list`
--

DROP TABLE IF EXISTS `inventory_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory_list` (
  `inv_receipt` varchar(30) NOT NULL,
  `prd_id` varchar(30) NOT NULL,
  `prdin_amount` int(7) NOT NULL,
  `prdin_price_amount` double NOT NULL,
  `prdin_price` double NOT NULL,
  PRIMARY KEY (`prd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inventory_list`
--

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

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product` (
  `prd_id` varchar(30) NOT NULL,
  `prd_name` varchar(100) NOT NULL,
  `prd_fund_price` double NOT NULL,
  `prd_sell_price` double NOT NULL,
  `prd_image` varchar(100) NOT NULL,
  `prd_amount` int(7) NOT NULL,
  `prd_status` varchar(100) NOT NULL,
  `prd_min_stock` int(7) NOT NULL,
  PRIMARY KEY (`prd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES ('10000','HUAVEI Y5C',2000,2890,'',15,'ขายปกติ',0),('10001','HUAVEI Ascend',7000,7990,'',20,'ขายปกติ',0),('10002','OPPO Joy 3',3000,3999,'',30,'ขายปกติ',0),('10003','i-mobile i-STYLE 219',1000,1790,'',28,'ขายปกติ',0),('10004','IPHONE5 64GB',10000,11490,'',30,'ขายปกติ',0),('10005','TRUE SMART 3.5',1100,1490,'',24,'ขายปกติ',0),('10006','DTAC Joey Jet 4.0',1200,1890,'',30,'ขายปกติ',0),('10007','Asus K455',10000,13490,'',18,'ขายปกติ',0),('10008','Dell N3558',12500,14490,'',30,'ขายปกติ',0),('10009','Acer E5473',10000,13490,'',18,'ขายปกติ',0),('10010','MSI CX61',20500,21900,'',12,'ขายปกติ',0),('10011','Lanovo U4170',10900,12900,'',10,'ขายปกติ',0),('10012','ACER TC705',10990,12990,'',10,'ขายปกติ',0),('10013','ACER VM4630',1500,16490,'',30,'ขายปกติ',0),('10014','ASUS PC K31AN',7900,8590,'',18,'ขายปกติ',0),('10015','ASUS PC M32AD',21000,21490,'',32,'ขายปกติ',0),('10016','ASUS PC M32BF',11000,12590,'',10,'ขายปกติ',0),('10017','DELL Vostro 3900',12000,14590,'',20,'ขายปกติ',0),('10018','DELL Optiplex 3020',14000,15490,'',32,'ขายปกติ',0),('10019','DELL Inspiron 384',13000,13590,'',26,'ขายปกติ',0),('10020','HP Pavilion 251',11000,12590,'',40,'ขายปกติ',0),('10021','HP Pavilion 021L',12000,13990,'',18,'ขายปกติ',0),('10022','HP Pavilion 550L',12000,12990,'',12,'ขายปกติ',0),('10023','HP Pavilion Q38A',15000,17790,'',17,'ขายปกติ',0),('10024','LENOVO IdeaCentre ',7500,8990,'',16,'ขายปกติ',0),('10025','LENOVO H5050',11000,13490,'',21,'ขายปกติ',0),('10026','LENOVO ThinkCentre',10000,10490,'',11,'ขายปกติ',0),('10027','LENOVO Think 43',14000,15990,'',10,'ขายปกติ',0),('10028','SVOA Warrior C2D',12000,13450,'',14,'ขายปกติ',0),('10029','SVOA V PDC2600',16000,17300,'',14,'ขายปกติ',0),('10030','NEC PM MT 500',25500,26500,'',10,'ขายปกติ',0),('10031','Lemel LMI16',11000,12000,'',20,'ขายปกติ',0),('10032','HP M939d',54500,57900,'',10,'ขายปกติ',0),('10033','Toshiba DX730',48000,49900,'',11,'ขายปกติ',0),('10034','Lenovo MIIX 300',7900,8700,'',12,'ขายปกติ',0),('10035','Lenovo TAB A8',6500,6990,'',15,'ขายปกติ',0),('10036','Acer One 10',9500,9790,'',20,'ขายปกติ',0),('10037','TWZ Tab-PLAY',4500,5390,'',10,'ขายปกติ',0),('10038','Samsung Tab S2',15000,17789,'',10,'ขายปกติ',0),('10039','Apple mini 3',14500,15450,'',10,'ขายปกติ',0);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `selling`
--

DROP TABLE IF EXISTS `selling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `selling` (
  `sell_id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `emp_id` varchar(4) NOT NULL,
  `sell_total` double NOT NULL,
  `sell_date` date NOT NULL,
  PRIMARY KEY (`sell_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `selling`
--

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

--
-- Table structure for table `selling_list`
--

DROP TABLE IF EXISTS `selling_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `selling_list` (
  `sell_id` int(10) unsigned zerofill NOT NULL,
  `prd_id` varchar(30) NOT NULL,
  `sell_amount` double NOT NULL,
  `sell_price` double NOT NULL,
  PRIMARY KEY (`sell_id`,`prd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `selling_list`
--

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

--
-- Table structure for table `sys_stock`
--

DROP TABLE IF EXISTS `sys_stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_stock` (
  `f_productid` varchar(50) NOT NULL,
  `f_productname` varchar(255) NOT NULL,
  `f_serial` varchar(50) NOT NULL,
  `f_image` varchar(255) NOT NULL,
  `f_location` text NOT NULL,
  `f_status` varchar(100) NOT NULL,
  PRIMARY KEY (`f_serial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_stock`
--

LOCK TABLES `sys_stock` WRITE;
/*!40000 ALTER TABLE `sys_stock` DISABLE KEYS */;
INSERT INTO `sys_stock` VALUES ('003','Motor Module','021-110004-000','','NIPPO','มีของ'),('001','Ribbon Supply & Gear Module','021-110005-000','','NIPPO','มีของ'),('002','Mainboard Assembly Module','021-11P001-001','','NIPPO','มีของ'),('008','Feed Switch Assembly Module','021-120007-000','','NIPPO','มีของ'),('004','Ribbon Sensor Assembly Module','021-120008-000','','NIPPO','มีของ'),('005','Label Sensor Assembly Module','021-120009-000','','NIPPO','มีของ'),('006','Platen Module (Feed Module)','021-120013-000','','NIPPO','มีของ'),('007','Adapter PCB Assembly Module','021-12P002-000','','NIPPO','มีของ');
/*!40000 ALTER TABLE `sys_stock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trans_stock`
--

DROP TABLE IF EXISTS `trans_stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trans_stock` (
  `f_id` varchar(14) NOT NULL,
  `f_serial` varchar(50) NOT NULL,
  `f_emp` varchar(200) NOT NULL,
  `f_detail` text NOT NULL,
  `f_datebor` date NOT NULL,
  `f_datefin` date NOT NULL,
  `f_status` varchar(100) NOT NULL,
  `f_approve` varchar(50) NOT NULL,
  `f_stock_bor` varchar(50) NOT NULL,
  `f_sale_bor` varchar(50) NOT NULL,
  `f_stock_fin` varchar(50) NOT NULL,
  `f_sale_fin` varchar(50) NOT NULL,
  `f_sale_datefin` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trans_stock`
--

LOCK TABLES `trans_stock` WRITE;
/*!40000 ALTER TABLE `trans_stock` DISABLE KEYS */;
/*!40000 ALTER TABLE `trans_stock` 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:50:50

📁 Sid Gifari File Manager