-- MySQL dump 10.13  Distrib 5.6.24, for Win64 (x86_64)
--
-- Host: localhost    Database: circle_k
-- ------------------------------------------------------
-- Server version	5.7.10-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 `logpreciosarticulos`
--

DROP TABLE IF EXISTS `logpreciosarticulos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logpreciosarticulos` (
  `LogPreciosArticulosID` varchar(50) NOT NULL,
  `PV_ArticulosID` varchar(50) DEFAULT NULL,
  `UsuariosID` varchar(50) DEFAULT NULL,
  `Fecha` datetime DEFAULT NULL,
  `LogArtitculos_TipoNivelID` varchar(50) DEFAULT NULL,
  `Configuracion` varchar(50) DEFAULT NULL,
  `PrecioAnterior` decimal(24,6) DEFAULT '0.000000',
  `PrecioActual` decimal(24,6) DEFAULT '0.000000',
  `Costo` decimal(24,6) DEFAULT '0.000000',
  `UtilidadAnterior` double DEFAULT '0',
  `UtilidadActual` double DEFAULT '0',
  `Gas` tinyint(4) DEFAULT '0',
  `InternalVersion` int(11) DEFAULT '0',
  `PrecioConIVAAnterior` decimal(24,6) DEFAULT '0.000000',
  `PrecioConIVAActual` decimal(24,6) DEFAULT '0.000000',
  PRIMARY KEY (`LogPreciosArticulosID`),
  KEY `WDIDX_LogPreciosArticulos_PV_ArticulosID` (`PV_ArticulosID`),
  KEY `WDIDX_LogPreciosArticulos_UsuariosID` (`UsuariosID`),
  KEY `WDIDX_LogPreciosArticulos_Fecha` (`Fecha`),
  KEY `WDIDX_LogPreciosArticulos_LogArtitculos_TipoNivelID` (`LogArtitculos_TipoNivelID`),
  KEY `WDIDX_LogPreciosArticulos_Configuracion` (`Configuracion`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logpreciosarticulos`
--

LOCK TABLES `logpreciosarticulos` WRITE;
/*!40000 ALTER TABLE `logpreciosarticulos` DISABLE KEYS */;
INSERT INTO `logpreciosarticulos` VALUES ('0-1','1-193','104-9','2011-09-03 15:13:32','TIENDA','SIMON MORUA',152.252300,179.279300,134.767500,0.12974,0.330286,0,1,0.000000,0.000000),('30-1','1-5618','116-77','2011-09-02 08:27:05','GENERAL','GENERAL',16.000000,11.900000,6.684500,1.3936,0.780238,0,1,0.000000,0.000000),('30-2','1-5770','116-77','2011-09-02 08:29:35','GENERAL','GENERAL',16.000000,11.900000,6.684500,1.3936,0.780238,0,1,0.000000,0.000000),('30-3','1-5770','116-77','2011-09-02 08:31:32','GENERAL','GENERAL',11.900000,11.900000,6.684500,0.780238,0.780238,0,1,0.000000,0.000000),('30-4','1-4434','116-77','2011-09-02 08:33:12','GENERAL','GENERAL',29.729700,20.270300,19.026900,0.562509,0.06535,0,1,0.000000,0.000000),('30-5','1-4434','116-77','2011-09-02 08:33:34','GENERAL','GENERAL',20.270300,22.500033,19.026900,0.06535,0.182538,0,1,0.000000,0.000000),('30-6','1-4434','116-77','2011-09-02 08:33:56','GENERAL','GENERAL',20.270300,22.500033,19.026900,0.06535,0.182538,0,1,0.000000,0.000000),('30-7','1-4434','116-77','2011-09-02 08:34:02','GENERAL','GENERAL',20.270300,22.500033,19.026900,0.06535,0.182538,0,1,0.000000,0.000000),('30-8','1-5852','116-77','2011-09-02 08:34:52','GENERAL','GENERAL',16.666700,13.423400,10.708800,0.556356,0.253492,0,1,0.000000,0.000000),('30-9','1-4448','116-77','2011-09-02 08:49:12','GENERAL','GENERAL',18.000000,18.000000,11.780000,0.528014,0.528014,0,1,0.000000,0.000000);
/*!40000 ALTER TABLE `logpreciosarticulos` 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 2019-12-04  6:37:29