-- MariaDB dump 10.19  Distrib 10.6.12-7-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: Z214517
-- ------------------------------------------------------
-- Server version	10.6.12-7-MariaDB-enterprise-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 */;

--
-- Table structure for table `spider_test`
--
CREATE SCHEMA IF NOT EXISTS Z214517;
use Z214517;

DROP TABLE IF EXISTS `spider_test`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `spider_test` (
  `col1` tinyint(3) NOT NULL,
  `col2` smallint(5) NOT NULL,
  `col3` mediumint(7) NOT NULL,
  `col4` tinyint(3) NOT NULL,
  `col5` smallint(5) NOT NULL,
  `col6` smallint(5) NOT NULL,
  `col7` tinyint(3) NOT NULL,
  `val` double NOT NULL,
  `upper` double DEFAULT NULL,
  `lower` double DEFAULT NULL,
  PRIMARY KEY (`col1`,`col2`,`col3`,`col4`,`col5`,`col6`,`col7`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `spider_test`
--

LOCK TABLES `spider_test` WRITE;
/*!40000 ALTER TABLE `spider_test` DISABLE KEYS */;
INSERT INTO `spider_test` VALUES (2,1990,1,1,1,294,1,572622506.910878,583649070.9233432,563608336.6842766),(2,1990,1,1,1,294,2,1,1,1),(2,1990,1,1,1,294,3,1.8091016819754224,1.8439382021271968,1.7806229716178228),(2,1990,1,1,1,295,1,493036590.93356884,507608873.6118604,476894775.4914541),(2,1990,1,1,1,295,2,0.861011951122422,0.879621702925777,0.839545285319347),(2,1990,1,1,1,295,3,1.557663757830899,1.6037023622960584,1.5066664863055377),(2,1990,1,1,1,297,1,6778518.680186944,10493676.704750165,4086462.339753185),(2,1990,1,1,1,297,2,0.011840500759600069,0.01837176355470447,0.007072297930936869),(2,1990,1,1,1,297,3,0.02141555631786687,0.03315295495296431,0.012910470341200393),(2,1990,1,1,1,298,1,3661458.616577382,4732406.0170697775,2919476.4689751915);
/*!40000 ALTER TABLE `spider_test` 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-04-15 21:00:29
