-- MySQL dump 10.13  Distrib 8.0.16, for linux-glibc2.12 (x86_64)
--
-- Host: localhost    Database: db12004db
-- ------------------------------------------------------
-- Server version	8.0.16

/*!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 */;
 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 `Sales`
--

DROP TABLE IF EXISTS `Sales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `Sales` (
  `SaleDT` datetime DEFAULT NULL,
  `ProductType` varchar(10) DEFAULT NULL,
  `Prize` bigint(19) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Sales`
--

LOCK TABLES `Sales` WRITE;
/*!40000 ALTER TABLE `Sales` DISABLE KEYS */;
INSERT INTO `Sales` VALUES ('2000-11-08 11:17:04','IT',3500),('2001-08-07 18:11:35','it',2500),('2004-07-27 04:38:27','IT',3500),('2002-10-08 11:36:23','it',3500),(NULL,'it',3500),(NULL,'it',2500),('2002-07-16 17:26:05','IT',2500),(NULL,'it',2500),('2002-09-16 12:26:55','it',2500),('2000-01-16 20:10:57','IT',2500),('2004-12-01 20:49:07','IT',NULL),('2003-02-16 20:42:44','IT',3500),('2002-04-16 14:30:29','IT',NULL),('2003-11-16 09:10:45','it',NULL),(NULL,'IT',NULL),(NULL,'it',2500),('2001-10-07 07:42:02','it',3500),('2003-11-05 16:40:59','IT',NULL),('2004-12-10 10:09:03','IT',NULL),(NULL,'it',NULL),('2004-08-11 19:28:18','IT',3500),('2000-06-14 15:37:36','it',3500),('2001-12-27 10:21:28','IT',2500),('2000-07-15 23:49:57','IT',NULL),('2001-11-21 22:22:41','it',NULL),('2002-01-19 01:29:04','IT',2500),('2002-07-02 03:31:45','IT',2500),(NULL,'IT',NULL),('2001-12-03 23:03:13','IT',3500),('2004-06-04 05:57:40','IT',2500),(NULL,'it',3500),('2004-03-18 19:29:03','it',2500),('2001-05-18 12:26:48','IT',3500);
/*!40000 ALTER TABLE `Sales` 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 2020-03-13 21:33:34