-- MySQL dump 10.13  Distrib 5.7.17, for Linux (x86_64)
--
-- Host: localhost    Database: imercury
-- ------------------------------------------------------
-- Server version	5.7.17-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 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 `bns`
--

DROP TABLE IF EXISTS `bns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bns` (
  `idx` int(11) NOT NULL,
  `model` int(10) NOT NULL,
  `company` int(10) NOT NULL,
  `car` int(10) NOT NULL,
  `type` int(10) NOT NULL,
  `bns_name` varchar(100) DEFAULT NULL,
  `comment` varchar(100) DEFAULT NULL,
  `image_idx` int(10) DEFAULT NULL,
  `manual_idx` int(10) DEFAULT NULL,
  `program_idx` int(10) DEFAULT NULL,
  PRIMARY KEY (`model`,`company`,`car`,`type`),
  UNIQUE KEY `idx` (`idx`),
  UNIQUE KEY `idx_2` (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bns`
--

LOCK TABLES `bns` WRITE;
/*!40000 ALTER TABLE `bns` DISABLE KEYS */;
INSERT INTO `bns` VALUES (1,10,2,3,5,'2015년식~(AVN)','파일경로 : SD Card / IFB',3,17,1),(2,1,2,4,6,'2016년식~(AVN)','파일경로 : SD Card / IFB',4,18,2),(3,7,2,8,9,'2016년~(8INCH)','파일경로 : SD Card / IFB',6,15,5),(4,11,12,13,21,'2016년식~(7INCH)','파일경로 : SD Card / IFB',8,19,7),(5,11,12,13,14,'2016년식~(7INCH)(전방센서X)','파일경로 : SD Card / IFB',8,19,9),(6,15,16,17,18,'BNS-BMW_4P','파일경로 : SD Card / IFB',12,28,10),(7,15,16,17,19,'BNS-BMW_6P','파일경로 : SD Card / IFB',13,29,11),(8,7,2,8,21,'2016년~(7INCH)','파일경로 : SD Card / IFB',6,16,14),(9,22,23,24,25,'BNS-BENZ_14','파일경로 : SD Card / IFB',22,30,20),(10,22,23,24,26,'BNS-BENZ_16','파일경로 : SD Card / IFB',23,31,21),(11,27,28,29,30,'BNS-AUDI_14','파일경로 : SD Card / IFB',26,32,24),(12,27,28,29,31,'BNS-AUDI_16','파일경로 : SD Card / IFB',27,33,25),(13,32,2,33,9,'2016년~(8INCH)','파일경로 : SD Card / IFB',38,15,34),(14,34,2,35,6,'2016년식~(AVN)','파일경로 : SD Card / IFB',37,36,35),(15,36,2,37,21,'2016년~(7INCH)','파일경로 : SD Card / IFB',41,40,39),(16,11,12,13,38,'2016년식~(8_7INCH)','파일경로 : SD Card / IFB',8,0,42),(17,11,12,13,39,'2016년식~(8_7INCH)(전방센서X)','파일경로 : SD Card / IFB',8,0,43),(18,22,23,24,41,'BNS-BENZ_17','파일경로 : SD Card / IFB',23,48,44),(19,43,42,44,45,'2017년식~(AVN)','파일경로 : SD Card / IFB',47,46,45),(20,46,47,48,45,'2017년식~(AVN)','파일경로 : SD Card / IFB',51,49,50),(21,51,49,50,45,'2017년식~(AVN)','파일경로 : SD Card / IFB',52,54,53),(22,52,42,53,54,'2018년식~(AVN)','파일경로 : SD Card / IFB',56,57,55),(23,55,49,56,54,'2018년식~(AVN)','파일경로 : SD Card / IFB',60,58,59),(24,58,2,57,59,'2018년~(8INCH)','파일경로 : SD Card / IFB',61,62,63);
/*!40000 ALTER TABLE `bns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bns_code`
--

DROP TABLE IF EXISTS `bns_code`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bns_code` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `category` char(1) NOT NULL,
  `mname` varchar(255) NOT NULL DEFAULT '',
  `tmp_no` int(11) DEFAULT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bns_code`
--

LOCK TABLES `bns_code` WRITE;
/*!40000 ALTER TABLE `bns_code` DISABLE KEYS */;
INSERT INTO `bns_code` VALUES (1,'M','캡티바',NULL),(2,'P','쉐보레',NULL),(3,'C','스파크',NULL),(4,'C','캡티바',NULL),(5,'T','2015년~AVN',NULL),(6,'T','2016년~AVN',NULL),(7,'M','말리부',NULL),(8,'C','말리부',NULL),(9,'T','2016년~8INCH',NULL),(10,'M','스파크',NULL),(11,'M','SM6/QM6',NULL),(12,'P','삼성',NULL),(13,'C','SM6/QM6',NULL),(14,'T','2016년~7INCH(전방센서X)',NULL),(15,'M','BMW',NULL),(16,'P','BMW',NULL),(17,'C','BMW',NULL),(18,'T','BNS-BMW_4P',NULL),(19,'T','BNS-BMW_6P',NULL),(21,'T','2016년~7INCH',NULL),(22,'M','BENZ',NULL),(23,'P','BENZ',NULL),(24,'C','BENZ',NULL),(25,'T','BNS-BENZ_14',NULL),(26,'T','BNS-BENZ_16',NULL),(27,'M','AUDI',NULL),(28,'P','ADUI',NULL),(29,'C','AUDI',NULL),(30,'T','BNS-AUDI_14',NULL),(31,'T','BNS-AUDI_16',NULL),(32,'M','카마로',NULL),(33,'C','카마로',NULL),(34,'M','트랙스',NULL),(35,'C','트랙스',NULL),(36,'M','크루즈',NULL),(37,'C','크루즈',NULL),(38,'T','2016년~8_7INCH',NULL),(39,'T','2016년~8_7INCH(전방센서X)',NULL),(41,'T','BNS-BENZ_17',NULL),(42,'P','현대',NULL),(43,'M','쏘나타뉴라이즈',NULL),(44,'C','쏘나타뉴라이즈',NULL),(45,'T','2017년~AVN',NULL),(46,'M','렉스턴',NULL),(47,'P','쌍용',NULL),(48,'C','렉스턴',NULL),(49,'P','기아',NULL),(50,'C','올뉴쏘렌토',NULL),(51,'M','올뉴쏘렌토',NULL),(52,'M','코나',NULL),(53,'C','코나',NULL),(54,'T','2018년~AVN',NULL),(55,'M','더뉴카니발',NULL),(56,'C','더뉴카니발',NULL),(57,'C','이쿼녹스',NULL),(58,'M','이쿼녹스',NULL),(59,'T','2018년~8INCH',NULL);
/*!40000 ALTER TABLE `bns_code` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bns_file`
--

DROP TABLE IF EXISTS `bns_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bns_file` (
  `file_idx` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(100) DEFAULT NULL,
  `rfile_name` varchar(100) DEFAULT NULL,
  `file_type` char(3) DEFAULT NULL,
  `reg_date` datetime DEFAULT NULL,
  `mdf_date` datetime DEFAULT NULL,
  PRIMARY KEY (`file_idx`),
  UNIQUE KEY `idx` (`file_idx`),
  UNIQUE KEY `file_idx` (`file_idx`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bns_file`
--

LOCK TABLES `bns_file` WRITE;
/*!40000 ALTER TABLE `bns_file` DISABLE KEYS */;
INSERT INTO `bns_file` VALUES (1,'a2a7f4ed80cf0d8ba015f71acbfa7a48.zip','(AVN)인터페이스_-_스파크(2015~).zip','zip','2016-06-07 09:33:43','2017-03-17 09:06:01'),(2,'8da624fe5ecb8deb19efacb6df6cb07f.zip','(AVN)인터페이스_-_캡티바(2016~).zip','zip','2016-06-07 09:33:51','2017-03-17 09:06:14'),(3,'291c74b7ebf0b40c94ce7ceabd71ecbb.jpg','쉐보레_-_스파크.jpg','jpg','2016-06-07 09:52:11','2016-06-07 10:03:23'),(4,'668b09a479894f82b4b795e270bd7825.jpg','쉐보레_-_캡티바.jpg','jpg','2016-06-07 09:52:17','2016-06-07 10:03:17'),(5,'ae2557004c79c8518d74bd79b79588d1.zip','(8inch)인터페이스_-_말리부(2016~).zip','zip','2016-08-30 19:26:23','2017-01-04 18:48:48'),(6,'a669b07b24a3d5de07e2b44ebd9c54f0.jpg','쉐보레_-_말리부.jpg','jpg','2016-08-30 19:33:08','2016-08-30 19:38:32'),(7,'5bd6a3c3e5101dd2f4a50c69e7c8c1df.zip','(AVN)인터페이스_-_SM6(2016~).zip','zip','2016-09-29 11:15:01','2017-08-07 19:13:37'),(8,'9083a644564ef56cee984fbefe8d50f0.jpg','삼성_-_SM6.jpg','jpg','2016-09-29 11:19:12','2016-09-29 11:19:12'),(9,'bff1eab759c319602b71fa0bb52c9a03.zip','(AVN)인터페이스_-_SM6(2016~)(센서X).zip','zip','2016-10-05 10:02:28','2017-08-07 19:13:30'),(10,'e4c9b30d09a716713013d6e3e08de86a.zip','(AVN)인터페이스_-_BMW(4P).zip','zip','2016-10-07 11:12:40','2018-02-06 08:59:24'),(11,'162653add735b3dace1980e6ff0e0db8.zip','(AVN)인터페이스_-_BMW(6P).zip','zip','2016-10-07 11:12:47','2018-02-20 09:18:36'),(12,'fedd115c1b1f93883d64177833360f85.jpg','BMW_-_4P.jpg','jpg','2016-10-07 11:17:08','2016-10-07 11:17:08'),(13,'3464632cbb5c4ac7c8fa237779078097.jpg','BMW_-_6P.jpg','jpg','2016-10-07 11:17:17','2016-10-07 11:17:17'),(14,'b33dacb2a9211aaa223933ae636c5665.zip','(7inch)인터페이스_-_말리부(2016~).zip','zip','2016-10-24 14:34:14','2017-04-04 16:33:03'),(15,'0bee4d78ba717dc75c3f10e14064ca94.pdf','(8inch)매뉴얼_-_말리부(2016~).pdf','pdf','2016-10-26 16:40:30','2016-10-26 16:43:16'),(16,'d6df5646a7fd62a1bb74b2089d63becf.pdf','(7inch)매뉴얼_-_말리부(2016~).pdf','pdf','2016-10-26 16:56:49','2016-10-26 16:57:20'),(17,'26acfefcc63ec58ed646210ccfbf5933.pdf','(AVN)매뉴얼_-_스파크(2015~).pdf','pdf','2016-10-26 16:58:17','2016-11-02 09:02:37'),(18,'0114ca74cc3e15c119b402e2d37360d5.pdf','(AVN)매뉴얼_-_캡티바(2015~).pdf','pdf','2016-10-26 16:58:25','2016-11-02 09:03:01'),(19,'0191ec0302e7e3cbc9020d8703c56fbf.pdf','(AVN)매뉴얼_-_SM6(2016~).pdf','pdf','2016-10-26 16:58:52','2017-01-24 09:17:41'),(20,'767af000d245b8cc34d4c7cd3141506d.zip','(AVN)인터페이스_-_BENZ(14).zip','zip','2016-11-08 10:42:12','2017-11-08 16:46:49'),(21,'da2fa6e9599ab30b16edc6916b9ce8c5.zip','(AVN)인터페이스_-_BENZ(16).zip','zip','2016-11-08 10:42:19','2018-05-08 16:01:47'),(22,'412e7b463cdfc5886c879474a3358f7d.jpg','BENZ_-_14.jpg','jpg','2016-11-08 10:48:44','2016-11-08 10:48:44'),(23,'68085f5bdd5c408589f0f493c9a8d1bb.jpg','BENZ_-_16.jpg','jpg','2016-11-08 10:48:53','2016-11-08 10:48:53'),(24,'94bbd86f0f2c204e9083576c209baec6.zip','(AVN)인터페이스_-_AUDI(14).zip','zip','2016-11-15 09:23:47','2018-05-23 15:35:03'),(25,'d9ec64af66cb0d40c639c82595d653aa.zip','(AVN)인터페이스_-_AUDI(16).zip','zip','2016-11-15 09:23:52','2017-08-04 15:48:22'),(26,'ecd5d4a9d6660024a076cdbcf95a7a72.jpg','AUDI_-_14.jpg','jpg','2016-11-15 09:24:01','2016-11-15 09:24:01'),(27,'fb016aa2318035012a78bf71bf325ccc.jpg','AUDI_-_16.jpg','jpg','2016-11-15 09:24:07','2016-11-15 09:24:07'),(28,'0fc437e4751798ec5cfe1369697b6615.pdf','(AVN)매뉴얼_-_BMW(4P).pdf','pdf','2016-11-23 18:10:06','2017-08-24 14:42:18'),(29,'720cf4cb5a83fc4f85c4dd803efe09ad.pdf','(AVN)매뉴얼_-_BMW(6P).pdf','pdf','2016-11-23 18:10:12','2017-08-28 16:24:41'),(30,'70eea3e11c45ea3d5c89b0b38bfbbda6.pdf','(AVN)매뉴얼_-_BENZ(14).pdf','pdf','2016-11-23 18:10:21','2017-09-13 14:42:24'),(31,'1f9d8659608b0f3f57ef3773c0ac62e0.pdf','(AVN)매뉴얼_-_BENZ(16).pdf','pdf','2016-11-23 18:10:27','2017-08-24 14:41:37'),(32,'822a5e272d20d2c7503028223c4e84b3.pdf','(AVN)매뉴얼_-_AUDI(14).pdf','pdf','2016-11-23 18:10:32','2017-12-12 18:30:52'),(33,'73e8f58c7608ae35478950005c41ef1a.pdf','(AVN)매뉴얼_-_AUDI(16).pdf','pdf','2016-11-23 18:10:37','2017-08-24 14:41:10'),(34,'670c423f997942d11ce65955cfdd0717.zip','(8inch)인터페이스_-_카마로(2016~).zip','zip','2016-12-06 17:45:42','2016-12-06 17:45:42'),(39,'0437f61451f88609ff27efe390da4614.zip','(7inch)인터페이스_-_크루즈(2016~).zip','zip','2017-04-04 16:41:47','2017-04-04 16:41:47'),(35,'bec8ca3258e3f4aa0225365328259b28.zip','(7inch)인터페이스_-_트랙스(2016~).zip','zip','2017-02-20 10:28:39','2017-04-04 16:33:12'),(36,'be736986e1783432b008ec0377ee9b6c.pdf','(7inch)매뉴얼_-_트랙스(2016~).pdf','pdf','2017-02-20 10:31:36','2017-02-20 10:31:36'),(37,'5b2a6060e304df1a88103c05820a342d.jpg','쉐보레_-_트랙스.jpg','jpg','2017-02-20 10:36:23','2017-02-20 10:36:23'),(38,'112dc39f1e09d95178c6227d9e2e7f5e.jpg','쉐보레_-_카마로.jpg','jpg','2017-02-20 10:36:28','2017-02-20 10:36:28'),(40,'aaa5b710b3525f55d41f66783df4eed6.pdf','(7inch)매뉴얼_-_크루즈(2016~).pdf','pdf','2017-04-04 16:41:56','2017-04-28 09:27:37'),(41,'0c0becd70bd798843f0dc22e3de117e7.jpg','쉐보레_-_크루즈.jpg','jpg','2017-04-04 16:42:02','2017-04-04 16:42:02'),(42,'ee19d5eae69d4a0d0540c74cfc61c00e.zip','(AVN)인터페이스_-_SM6(8_7).zip','zip','2017-04-11 17:27:06','2017-08-07 19:13:23'),(43,'f88d05f58de18011ceca8117d5017e60.zip','(AVN)인터페이스_-_SM6(8_7)(센서X).zip','zip','2017-04-11 17:27:13','2017-08-07 19:13:18'),(44,'b90f627ce8a69f925fe5c6c414010213.zip','(AVN)인터페이스_-_BENZ(17).zip','zip','2017-06-23 13:54:42','2018-04-13 11:11:37'),(45,'18590a3820653d2acdff3e67c79a236c.zip','(AVN)인터페이스_-_쏘나타뉴라이즈(2017~).zip','zip','2017-07-31 11:00:41','2018-06-20 18:55:00'),(46,'4718726202a355e6eb75182ccd11f152.pdf','(AVN)매뉴얼_-_쏘나타뉴라이즈(2017~).pdf','pdf','2017-07-31 11:01:15','2018-06-26 10:15:14'),(47,'65e0cf47f360e22ec58c6af1a4e7d462.jpg','현대_-_쏘나타뉴라이즈.jpg','jpg','2017-07-31 11:07:37','2017-07-31 11:07:37'),(48,'bb7967799cc72a5bef970372d1d4d989.pdf','(AVN)매뉴얼_-_BENZ(17).pdf','pdf','2017-08-24 14:40:48','2017-08-24 14:40:48'),(49,'3a271a6e420fab329dc0728c088006b0.pdf','(AVN)매뉴얼_-_렉스턴(2017~).pdf','pdf','2017-09-07 18:11:48','2017-09-07 18:11:48'),(50,'7f3b47828170111357ed79c4fe0b2fdc.zip','(AVN)인터페이스_-_렉스턴(2017~).zip','zip','2017-09-07 18:12:06','2017-09-07 18:12:06'),(51,'54ef57279a7ac8afce8b14fd4e5a9eb0.jpg','쌍용_-_렉스턴.jpg','jpg','2017-09-07 18:16:35','2017-09-07 18:16:35'),(52,'5c68b6ed28c9a7d3628c6579b74c59f2.jpg','기아_-_올뉴쏘렌토.jpg','jpg','2017-09-27 11:15:45','2017-09-27 11:15:45'),(53,'4c483e2e88ce3487926901830c508e44.zip','(AVN)인터페이스_-_올뉴쏘렌토(2017~).zip','zip','2017-09-27 11:16:21','2018-06-20 18:54:48'),(54,'1e10fa356ae369c8daa7e850eaf631cf.pdf','(AVN)매뉴얼_-_올뉴쏘렌토(2017~).pdf','pdf','2017-10-10 18:11:18','2018-05-11 18:53:24'),(55,'6ac19a3a96463a5f0040650f4018bf6f.zip','(AVN)인터페이스_-_코나(2018~).zip','zip','2017-10-27 08:59:51','2018-06-20 18:54:35'),(56,'89823b9496788f73d6de180501875aae.jpg','현대_-_코나.jpg','jpg','2017-10-27 09:03:49','2017-10-27 09:03:49'),(57,'e2fe95853af74772610ce8a991edd571.pdf','(AVN)매뉴얼_-_코나(2018~).pdf','pdf','2017-10-31 09:49:25','2018-05-25 15:57:06'),(58,'3587cf4e803f7d8fd11994e270a14277.pdf','(AVN)매뉴얼_-_더뉴카니발(2018~).pdf','pdf','2018-05-24 19:03:45','2018-05-25 15:57:12'),(59,'e42552645575eea948614181f611b891.zip','(AVN)인터페이스_-_더뉴카니발(2018~).zip','zip','2018-05-25 09:17:52','2018-06-20 18:54:24'),(60,'e38e2efdd457efa291379bb88e446594.jpg','기아_-_더뉴카니발.jpg','jpg','2018-05-25 09:21:17','2018-05-25 09:21:17'),(61,'137ef7a324b6f157d351c3c8d0385c3c.jpg','쉐보레_-_이쿼녹스.jpg','jpg','2018-06-22 16:33:19','2018-06-22 16:33:19'),(62,'d9c7918c8f87337824e82a22097cbf8a.pdf','(8inch)매뉴얼_-_이쿼녹스(2018~).pdf','pdf','2018-06-22 16:33:30','2018-06-26 10:15:00'),(63,'9a0df96a6082f94ff1cddd5747ce5e3f.zip','(8inch)인터페이스_-_이쿼녹스(2018~).zip','zip','2018-06-22 16:33:37','2018-06-22 16:33:37');
/*!40000 ALTER TABLE `bns_file` 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 2026-04-15 18:34:12
