-- MySQL dump 10.14  Distrib 5.5.68-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: dmserv
-- ------------------------------------------------------
-- Server version	5.5.68-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 utf8 */;
/*!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 */;

--
-- Table structure for table `dm_bins`
--

DROP TABLE IF EXISTS `dm_bins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dm_bins` (
  `REC_NO` mediumint(9) NOT NULL AUTO_INCREMENT,
  `LOC_NAME` char(20) DEFAULT NULL,
  `BIN` int(9) NOT NULL,
  `BIN_PATH` varchar(80) DEFAULT NULL,
  `DIR_MAX` int(10) DEFAULT NULL,
  `FIRST_REC` int(10) DEFAULT NULL,
  `LAST_REC` int(10) DEFAULT NULL,
  `VOL_LABEL` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`REC_NO`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dm_bins`
--

LOCK TABLES `dm_bins` WRITE;
/*!40000 ALTER TABLE `dm_bins` DISABLE KEYS */;
INSERT INTO `dm_bins` VALUES (1,'IITCSOLUTION',1,'SAMPLE',200,1,14,'');
/*!40000 ALTER TABLE `dm_bins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tab_locs`
--

DROP TABLE IF EXISTS `tab_locs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tab_locs` (
  `REC_NO` mediumint(9) NOT NULL AUTO_INCREMENT,
  `TABLE_NO` int(9) NOT NULL,
  `TAB_REC_NO` int(9) NOT NULL,
  `LOC_NAME` char(20) DEFAULT NULL,
  `FILE_ID` int(10) DEFAULT NULL,
  `DOC_TYPE` varchar(8) DEFAULT NULL,
  `DIGEST` varchar(41) DEFAULT NULL,
  `FILESIZE` int(10) DEFAULT NULL,
  `FILEDATE` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`REC_NO`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tab_locs`
--

LOCK TABLES `tab_locs` WRITE;
/*!40000 ALTER TABLE `tab_locs` DISABLE KEYS */;
INSERT INTO `tab_locs` VALUES (1,1,1,'IITCSOLUTION',1,'pdf','',977646,'2025/6/21'),(2,1,2,'IITCSOLUTION',2,'dwg','',1373188,'2025/6/21'),(3,1,3,'IITCSOLUTION',3,'dwg','',41914,'2025/06/21'),(4,1,4,'IITCSOLUTION',4,'dwg','',41914,'2025/06/21'),(5,1,5,'IITCSOLUTION',5,'pdf','',116765,'2025/06/21'),(6,1,6,'IITCSOLUTION',6,'jpg','',16765,'2025/06/21'),(7,1,7,'IITCSOLUTION',7,'tif','',116765,'2025/06/21'),(8,1,8,'IITCSOLUTION',8,'tif','',116765,'2025/06/21'),(9,1,9,'IITCSOLUTION',9,'tif','',116765,'2025/06/21'),(10,1,10,'IITCSOLUTION',10,'pdf','',116765,'2025/06/21'),(11,1,11,'IITCSOLUTION',11,'pdf','',25948792,'2025/06/26'),(12,1,12,'IITCSOLUTION',12,'pdf','',10984,'2025/06/28'),(13,1,13,'IITCSOLUTION',13,'pdf','',10984,'2025/06/28'),(14,1,14,'IITCSOLUTION',14,'pdf','',10984,'2025/06/28');
/*!40000 ALTER TABLE `tab_locs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dm_locs`
--

DROP TABLE IF EXISTS `dm_locs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dm_locs` (
  `REC_NO` mediumint(9) NOT NULL AUTO_INCREMENT,
  `LOC_NAME` varchar(20) NOT NULL,
  `LOC_SERIAL_NO` int(10) DEFAULT NULL,
  PRIMARY KEY (`REC_NO`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dm_locs`
--

LOCK TABLES `dm_locs` WRITE;
/*!40000 ALTER TABLE `dm_locs` DISABLE KEYS */;
INSERT INTO `dm_locs` VALUES (1,'IITCSOLUTION',1),(2,'IITCSOLUTION',2),(3,'IITCSOLUTION',3),(4,'IITCSOLUTION',4),(5,'IITCSOLUTION',5),(6,'IITCSOLUTION',6),(7,'IITCSOLUTION',7),(8,'IITCSOLUTION',8),(9,'IITCSOLUTION',9),(10,'IITCSOLUTION',10),(11,'IITCSOLUTION',11),(12,'IITCSOLUTION',12),(13,'IITCSOLUTION',13),(14,'IITCSOLUTION',14);
/*!40000 ALTER TABLE `dm_locs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `doc_link`
--

DROP TABLE IF EXISTS `doc_link`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_link` (
  `REC_NO` mediumint(9) NOT NULL AUTO_INCREMENT,
  `TABLE_NO` int(20) NOT NULL,
  `TABLE_NAME` varchar(20) DEFAULT NULL,
  `LINK_REC_NO` int(10) NOT NULL,
  `MAIN_REC_DESC` varchar(100) DEFAULT NULL,
  `DOC_TYPE` varchar(50) DEFAULT NULL,
  `COMMAND` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`REC_NO`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `doc_link`
--

LOCK TABLES `doc_link` WRITE;
/*!40000 ALTER TABLE `doc_link` DISABLE KEYS */;
INSERT INTO `doc_link` VALUES (1,1,'IITCSOLUTION',10,'연관이미지','pdf','AAAAAAAAAAAAAAA');
/*!40000 ALTER TABLE `doc_link` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lnch_id`
--

DROP TABLE IF EXISTS `lnch_id`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lnch_id` (
  `REC_NO` mediumint(9) NOT NULL AUTO_INCREMENT,
  `TABLE_NO` int(9) NOT NULL,
  `TAB_RECNO` int(9) NOT NULL,
  `DOC_PATH` varchar(2000) DEFAULT NULL,
  `DOC_NAME` varchar(2000) DEFAULT NULL,
  `APPLID` varchar(8) DEFAULT NULL,
  `MAIN_NAME` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`REC_NO`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lnch_id`
--

LOCK TABLES `lnch_id` WRITE;
/*!40000 ALTER TABLE `lnch_id` DISABLE KEYS */;
INSERT INTO `lnch_id` VALUES (1,1,1,'Data','3552250815.pdf','IMASTER',NULL),(2,1,2,'Data','holiday.dwg','IMASTER',NULL),(3,1,3,'Data','holiday001.dwg','cimage','DEMO'),(4,1,4,'Data','holiday004.dwg','cimage','DEMO'),(5,1,5,'Data','holiday555.pdf','acrobat','DEMO'),(6,1,6,'Data','6666.jpg','Image','DEMO'),(7,1,7,'Data','6666.tif','Image','DEMO'),(8,1,8,'Data','8888.tif','Image','DEMO'),(9,1,9,'Data','9999.tif','Image','DEMO'),(10,1,10,'Data','jeong.pdf','Image','DEMO'),(11,1,11,'Data','sample.pdf','IMASTER',NULL),(14,1,12,'Data','1.pdf','IMASTER',NULL),(15,1,13,'Data','1.pdf','IMASTER',NULL),(16,1,14,'Data','1.pdf','IMASTER',NULL);
/*!40000 ALTER TABLE `lnch_id` 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-07-01 23:00:41
