-- MySQL dump 10.16  Distrib 10.2.10-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: loader
-- ------------------------------------------------------
-- Server version	10.2.10-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 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 `auct_auctions_xml_tmp`
--

DROP TABLE IF EXISTS `auct_auctions_xml_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auct_auctions_xml_tmp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `auto_translation` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `day_of_week` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `country` varchar(20) NOT NULL DEFAULT '',
  `auction_system` varchar(14) NOT NULL DEFAULT '',
  `num_lots` int(10) unsigned NOT NULL DEFAULT 0,
  `is_oneprice` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `currency` char(3) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `is_oneprice` (`is_oneprice`)
) ENGINE=MyISAM AUTO_INCREMENT=261 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auct_auctions_xml_tmp`
--

LOCK TABLES `auct_auctions_xml_tmp` WRITE;
/*!40000 ALTER TABLE `auct_auctions_xml_tmp` DISABLE KEYS */;
INSERT INTO `auct_auctions_xml_tmp` VALUES (1,'USS Sapporo',0,3,'Japan','USS',2649,0,'JPY'),(2,'USS Tohoku',0,3,'Japan','USS',1268,0,'JPY'),(3,'USS Gunma',0,6,'Japan','USS',1084,0,'JPY'),(5,'USS Tokyo',0,4,'Japan','USS',14055,0,'JPY'),(7,'USS Saitama',0,5,'Japan','USS',884,0,'JPY'),(8,'USS Yokohama',0,2,'Japan','USS',4689,0,'JPY'),(9,'USS Shizuoka',0,6,'Japan','USS',1599,0,'JPY'),(10,'USS Nagoya',0,5,'Japan','USS',10272,0,'JPY'),(11,'USS R Nagoya',0,2,'Japan','USS',3265,0,'JPY'),(12,'USS Osaka',0,5,'Japan','USS',3611,0,'JPY'),(13,'USS Kobe',0,3,'Japan','USS',1535,0,'JPY'),(14,'USS Okayama',0,6,'Japan','USS',1630,0,'JPY'),(15,'USS Fukuoka',0,3,'Japan','USS',713,0,'JPY'),(16,'USS Kyushu',0,6,'Japan','USS',3971,0,'JPY'),(17,'AUCNET',1,1,'Japan','IAUC',1121,0,'JPY'),(18,'Honda Kyushu',1,1,'Japan','IAUC',352,0,'JPY'),(19,'Honda Kansai',1,1,'Japan','IAUC',656,0,'JPY'),(20,'Honda Nagoya',1,1,'Japan','IAUC',479,0,'JPY'),(21,'Honda Tokyo',1,1,'Japan','IAUC',1125,0,'JPY'),(22,'Honda Hokkaido',1,1,'Japan','IAUC',231,0,'JPY'),(23,'JU Tokyo',1,1,'Japan','IAUC',1366,0,'JPY'),(25,'CAA Tokyo',0,2,'Japan','IAUC',1963,0,'JPY'),(26,'CAA Gifu',0,2,'Japan','IAUC',1273,0,'JPY'),(27,'TAA Kinki',1,2,'Japan','IAUC',2214,0,'JPY'),(28,'TAA Kyushu',1,2,'Japan','IAUC',1880,0,'JPY'),(29,'SAA Sapporo',0,2,'Japan','IAUC',321,0,'JPY'),(30,'JU Saitama',0,2,'Japan','IAUC',1944,0,'JPY'),(31,'JU Shizuoka',0,2,'Japan','IAUC',588,0,'JPY'),(32,'JU Nagano',0,2,'Japan','IAUC',353,0,'JPY'),(33,'JU Mie',0,2,'Japan','IAUC',402,0,'JPY'),(34,'JU Yamaguchi',0,2,'Japan','IAUC',184,0,'JPY'),(35,'ARAI Sendai',0,5,'Japan','IAUC',280,0,'JPY'),(36,'ZIP Tokyo',1,6,'Japan','IAUC',0,0,'JPY'),(37,'CAA Chubu',1,3,'Japan','IAUC',3235,0,'JPY'),(38,'JAA',0,3,'Japan','IAUC',2341,0,'JPY'),(39,'BAYAUC',0,3,'Japan','IAUC',1577,0,'JPY'),(41,'LAA Shikoku',0,3,'Japan','IAUC',800,0,'JPY'),(42,'KCAA M Kyushu',0,3,'Japan','IAUC',986,0,'JPY'),(43,'HERO',1,3,'Japan','IAUC',884,0,'JPY'),(44,'JU Ibaraki',0,3,'Japan','IAUC',632,0,'JPY'),(45,'JU Ishikawa',1,3,'Japan','IAUC',198,0,'JPY'),(46,'TAA Kantou',1,4,'Japan','IAUC',485,0,'JPY'),(47,'TAA Chubu',1,4,'Japan','IAUC',450,0,'JPY'),(48,'TAA Touhoku',1,4,'Japan','IAUC',439,0,'JPY'),(50,'LAA Kansai',0,4,'Japan','IAUC',446,0,'JPY'),(51,'KCAA Fukuoka',1,4,'Japan','IAUC',0,0,'JPY'),(52,'NAA Osaka',1,4,'Japan','IAUC',0,0,'JPY'),(53,'NAA Nagoya',1,4,'Japan','IAUC',0,0,'JPY'),(54,'SAA Hamamatsu',1,4,'Japan','IAUC',0,0,'JPY'),(55,'JU Aichi',0,4,'Japan','IAUC',100,0,'JPY'),(56,'JU Hiroshima',0,4,'Japan','IAUC',0,0,'JPY'),(57,'JU Hokkaido',0,5,'Japan','IAUC',0,0,'JPY'),(58,'JU Gunma',1,4,'Japan','IAUC',0,0,'JPY'),(59,'JU Fukushima',1,4,'Japan','IAUC',0,0,'JPY'),(60,'JU Kanagawa',1,4,'Japan','IAUC',0,0,'JPY'),(61,'ARAI Oyama',1,4,'Japan','IAUC',0,0,'JPY'),(64,'JU Fukuoka',1,5,'Japan','IAUC',0,0,'JPY'),(65,'LAA Okayama',1,5,'Japan','IAUC',0,0,'JPY'),(66,'JU Miyagi',1,5,'Japan','IAUC',0,0,'JPY'),(67,'JU Niigata',1,5,'Japan','IAUC',0,0,'JPY'),(68,'JU Chiba',1,5,'Japan','IAUC',0,0,'JPY'),(69,'ARAI Bayside',1,5,'Japan','IAUC',0,0,'JPY'),(70,'JAA Tsukuba',1,5,'Japan','IAUC',0,0,'JPY'),(71,'NAA Tokyo',1,5,'Japan','IAUC',0,0,'JPY'),(72,'KCAA Yamaguchi',1,5,'Japan','IAUC',0,0,'JPY'),(73,'JU Tochigi',1,5,'Japan','IAUC',0,0,'JPY'),(75,'HAA Kobe',1,6,'Japan','IAUC',5079,0,'JPY'),(79,'JU Gifu',1,6,'Japan','IAUC',4743,0,'JPY'),(80,'JU Nara',1,6,'Japan','IAUC',288,0,'JPY'),(81,'TAA Yokohama',1,6,'Japan','IAUC',3053,0,'JPY'),(82,'NAA Tokyo Nyuusatsu',1,6,'Japan','IAUC',0,0,'JPY'),(84,'TAA Minamikyu',1,2,'Japan','IAUC',400,0,'JPY'),(86,'ARAI Oyama VT',1,6,'Japan','IAUC',4864,0,'JPY'),(87,'NAA Nagoya Nyu',1,6,'Japan','IAUC',113,0,'JPY'),(88,'AS Oneprice',0,8,'Japan','ASNET',5214,1,'JPY'),(99,'Honda Sendai',1,1,'Japan','IAUC',187,0,'JPY'),(100,'AS Members',1,8,'Japan','ASNET',12280,1,'JPY'),(101,'CAA Touhoku',0,2,'Japan','IAUC',461,0,'JPY'),(102,'NAA Osaka',1,6,'Japan','IAUC',70,0,'JPY'),(103,'TAA Hiroshima',1,2,'Japan','IAUC',1224,0,'JPY'),(108,'USS Hokuriku',1,6,'Japan','USS',302,0,'JPY'),(109,'GAO Stock',1,8,'Japan','GAO_STOCK',4012,1,'JPY'),(122,'USS Niigata',0,3,'Japan','USS',928,0,'JPY'),(127,'JU Toyama',1,4,'Japan','IAUC',0,0,'JPY'),(128,'JU Okinawa',1,5,'Japan','IAUC',0,0,'JPY'),(129,'Korea Oneprice One',1,8,'Korea','WPKOREA',471,1,'KRW'),(131,'ORIX Kobe',0,2,'Japan','IAUC',415,0,'JPY'),(132,'ORIX Sendai',0,2,'Japan','IAUC',145,0,'JPY'),(133,'ORIX Atsugi',1,3,'Japan','IAUC',320,0,'JPY'),(134,'GNN',1,3,'Japan','IAUC',0,0,'JPY'),(135,'ORIX Nagoya',1,4,'Japan','IAUC',153,0,'JPY'),(141,'TAA Hokkaido',1,4,'Japan','IAUC',278,0,'JPY'),(142,'ZIP Osaka',0,4,'Japan','IAUC',0,0,'JPY'),(144,'USS Stock',0,8,'Japan','USS_STOCK',0,1,'JPY'),(146,'Syoudan Stock',1,8,'Japan','IAUC_STOCK',218,1,'JPY'),(147,'Kyouyuu Stock',1,8,'Japan','IAUC_STOCK',1200,1,'JPY'),(148,'JU Kyouyuu',1,8,'Japan','IAUC_STOCK',300,1,'JPY'),(149,'Ippatsu Stock',0,8,'Japan','IAUC_STOCK',18466,1,'JPY'),(150,'Isuzu Kobe',1,5,'Japan','IAUC',0,0,'JPY'),(151,'Isuzu Kyushu',1,4,'Japan','IAUC',0,0,'JPY'),(152,'ORIX Fukuoka',1,2,'Japan','IAUC',212,0,'JPY'),(153,'NPS Tokyo',0,2,'Japan','IAUC',0,0,'JPY'),(154,'NPS Osaka',1,2,'Japan','IAUC',0,0,'JPY'),(156,'TAA Shikoku',1,2,'Japan','IAUC',828,0,'JPY'),(157,'LP Tokyo',1,2,'Japan','IAUC',0,0,'JPY'),(158,'LP Fukuoka',1,3,'Japan','IAUC',0,0,'JPY'),(159,'LP Kobe',1,4,'Japan','IAUC',0,0,'JPY'),(160,'IAA Osaka',0,3,'Japan','IAUC',925,0,'JPY'),(161,'Simulcast',1,8,'USA','USA',0,0,'USD'),(162,'NPS Sendai',1,2,'Japan','IAUC',0,0,'JPY'),(163,'NPS Fukuoka',1,2,'Japan','IAUC',0,0,'JPY'),(164,'ORIX IP Stock',1,8,'Japan','IAUC_STOCK',25,1,'JPY'),(165,'OVE.com',1,8,'USA','USA',0,0,'USD'),(166,'Shisuroke NCS Kobe',1,4,'Japan','IAUC',0,0,'JPY'),(167,'Shisuroke Kobe',1,4,'Japan','IAUC',0,0,'JPY'),(168,'Shisuroke Nagoya',1,4,'Japan','IAUC',0,0,'JPY'),(170,'Shisuroke Tokyo',1,2,'Japan','IAUC',0,0,'JPY'),(171,'Shisuroke Kyusyu',1,2,'Japan','IAUC',0,0,'JPY'),(177,'Korea Oneprice Two',0,8,'Korea','ENCAR',0,1,'USD'),(172,'LUM Tokyo',1,3,'Japan','IAUC',386,0,'JPY'),(173,'LUM Sapporo',1,4,'Japan','IAUC',0,0,'JPY'),(174,'LUM Fukuoka',1,2,'Japan','IAUC',135,0,'JPY'),(175,'LUM Kobe',1,4,'Japan','IAUC',0,0,'JPY'),(176,'LUM Nagoya',1,2,'Japan','IAUC',150,0,'JPY'),(178,'Quick Stock',1,8,'Japan','IAUC_STOCK',18600,1,'JPY'),(179,'JU Yamanashi',1,6,'Japan','IAUC',41,0,'JPY'),(180,'Isuzu Kyouyuu',1,8,'Japan','IAUC_STOCK',3303,1,'JPY'),(181,'NAA Fukuoka',1,2,'Japan','IAUC',472,0,'JPY'),(182,'NPS Tochigi',1,2,'Japan','IAUC',0,0,'JPY'),(183,'IAA Kyouyuu',1,8,'Japan','IAUC_STOCK',144,1,'JPY'),(184,'Sakura',1,2,'Japan','IAUC',0,0,'JPY'),(185,'CAA Kyouyuu',1,8,'Japan','IAUC_STOCK',8323,1,'JPY'),(186,'In Lane',1,8,'USA','USA',0,0,'USD'),(187,'SimEv',1,8,'USA','USA',0,0,'USD'),(188,'BCA Europe',1,8,'Europe','BCA_EUROPE',0,0,'EUR'),(189,'NPS Gifu',1,2,'Japan','IAUC',0,0,'JPY'),(190,'AEP Gifu',1,2,'Japan','IAUC',0,0,'JPY'),(191,'LAA Challenge',1,1,'Japan','IAUC',585,0,'JPY'),(192,'NPS Tomakomai',1,2,'Japan','IAUC',0,0,'JPY'),(193,'JU Kumamoto',1,3,'Japan','IAUC',158,0,'JPY'),(195,'JU Akita',1,3,'Japan','IAUC',202,0,'JPY'),(200,'Hino Hansha',1,5,'Japan','IAUC',0,0,'JPY'),(201,'JU Yamagata',1,6,'Japan','IAUC',0,0,'JPY'),(204,'JU Miyazaki',1,4,'Japan','IAUC',0,0,'JPY'),(199,'Hino Kobe',1,5,'Japan','IAUC',0,0,'JPY'),(198,'Hino Hidaka',1,5,'Japan','IAUC',0,0,'JPY'),(205,'JCRA',1,5,'Japan','IAUC',0,0,'JPY'),(208,'Auct Kyouyuu',1,8,'Japan','IAUC_STOCK',200,1,'JPY'),(209,'BCN Kyouyuu',1,8,'Japan','IAUC_STOCK',2016,1,'JPY'),(217,'JU Oita',1,3,'Japan','IAUC',286,0,'JPY'),(220,'Nissan Osaka',1,1,'Japan','IAUC',315,0,'JPY'),(218,'Yanase',1,6,'Japan','IAUC',150,0,'JPY'),(225,'ZERO Syonan',1,4,'Japan','IAUC',0,0,'JPY'),(229,'ZERO Sendai',1,5,'Japan','IAUC',0,0,'JPY'),(230,'ZERO Chiba',1,5,'Japan','IAUC',0,0,'JPY'),(226,'ZERO Chubu',1,4,'Japan','IAUC',0,0,'JPY'),(221,'JU Aomori',1,2,'Japan','IAUC',0,0,'JPY'),(228,'ZERO Hokkaido',1,5,'Japan','IAUC',0,0,'JPY'),(223,'IPA Fukuoka',1,3,'Japan','IAUC',0,0,'JPY'),(224,'IPA Kobe',1,4,'Japan','IAUC',0,0,'JPY'),(227,'ZERO Osaka',1,4,'Japan','IAUC',0,0,'JPY'),(222,'IPA Tokyo',1,2,'Japan','IAUC',0,0,'JPY'),(231,'ZERO Hakata',1,5,'Japan','IAUC',0,0,'JPY'),(233,'AUCNET Hyakuretsu',1,3,'Japan','IAUC',0,0,'JPY'),(232,'JU Fukui',1,2,'Japan','IAUC',0,0,'JPY'),(234,'ARAI Kenki',1,2,'Japan','IAUC',656,0,'JPY'),(237,'USS HAA Kobe',1,6,'Japan','USS',5463,0,'JPY'),(238,'USS JAA',0,3,'Japan','USS',1212,0,'JPY'),(239,'KCAA Kyoto',1,3,'Japan','IAUC',0,0,'JPY'),(240,'Isuzu Tokyo',0,3,'Japan','IAUC',613,0,'JPY'),(242,'MIRIVE Saitama',1,3,'Japan','IAUC',2270,0,'JPY'),(243,'MIRIVE Osaka',1,4,'Japan','IAUC',297,0,'JPY'),(245,'TAA Hyogo',1,6,'Japan','IAUC',0,0,'JPY'),(246,'MIRIVE Aichi',1,5,'Japan','IAUC',0,0,'JPY'),(247,'JU Shimane',1,5,'Japan','IAUC',0,0,'JPY'),(249,'Guliver Oneprice',1,8,'Japan','IAUC_STOCK',0,1,'JPY'),(251,'JU Nagasaki',1,3,'Japan','IAUC',0,0,'JPY'),(253,'Carseru Stock',1,8,'Japan','IAUC_STOCK',0,1,'JPY'),(254,'SOGO Narita1',1,4,'Japan','IAUC',0,0,'JPY'),(255,'SOGO Tomakomai',1,5,'Japan','IAUC',0,0,'JPY'),(256,'SOGO Hakata',1,5,'Japan','IAUC',0,0,'JPY'),(257,'SOGO Narita2',1,5,'Japan','IAUC',0,0,'JPY'),(258,'SOGO Narita3',1,6,'Japan','IAUC',0,0,'JPY'),(259,'SOGO Internet',1,2,'Japan','IAUC',0,0,'JPY'),(260,'LAP Kyoyuzaiko',1,8,'Japan','IAUC_STOCK',0,1,'JPY'),(77,'SOGO Hakata',1,5,'Japan','IAUC',0,0,'JPY'),(89,'SOGO Narita2',1,5,'Japan','IAUC',0,0,'JPY'),(92,'SOGO Narita3',1,6,'Japan','IAUC',0,0,'JPY'),(94,'SOGO Internet',1,2,'Japan','IAUC',0,0,'JPY'),(95,'LAP Kyoyuzaiko',1,8,'Japan','IAUC_STOCK',0,1,'JPY'),(114,'KCAA M Kyushu-2',1,6,'Japan','IAUC',0,0,'JPY'),(126,'MOTA B',1,5,'Japan','IAUC',0,0,'JPY'),(120,'MOTA A',1,1,'Japan','IAUC',0,0,'JPY');
/*!40000 ALTER TABLE `auct_auctions_xml_tmp` 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-03-20  2:46:52
DROP TABLE IF EXISTS `auct_auctions_xml`; RENAME TABLE `auct_auctions_xml_tmp` TO `auct_auctions_xml`;