-- MySQL dump 10.13  Distrib 5.5.20, for Win32 (x86)
--
-- Host: localhost    Database: bodegas
-- ------------------------------------------------------
-- Server version	5.5.20-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 `bodega`
--

DROP TABLE IF EXISTS `bodega`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bodega` (
  `Id_Bodega` int(11) DEFAULT NULL,
  `NIT_BODEGA` varchar(100) DEFAULT NULL,
  `Nombre_Bodega` varchar(100) DEFAULT NULL,
  `Direccion_Bodega` varchar(100) DEFAULT NULL,
  `Axiliar_Asignado` varchar(100) DEFAULT NULL,
  `Fecha_Hora` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `estado` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bodega`
--

LOCK TABLES `bodega` WRITE;
/*!40000 ALTER TABLE `bodega` DISABLE KEYS */;
INSERT INTO `bodega` VALUES (1,'1','bodega1','direccion 1','auxiliar','2017-11-09 10:28:11',1);
/*!40000 ALTER TABLE `bodega` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `celdas`
--

DROP TABLE IF EXISTS `celdas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `celdas` (
  `ID_Celda` int(11) DEFAULT NULL,
  `ID_Modulo` int(11) DEFAULT NULL,
  `Alto` int(11) DEFAULT NULL,
  `Ancho` int(11) DEFAULT NULL,
  `Peso_Limite` int(11) DEFAULT NULL,
  `Estado` int(11) DEFAULT NULL,
  `xactual` int(11) DEFAULT NULL,
  `yactual` int(11) DEFAULT NULL,
  `zactual` int(11) DEFAULT NULL,
  `pesoactual` int(11) DEFAULT NULL,
  `producto` int(11) DEFAULT NULL,
  `cantidad` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `celdas`
--

LOCK TABLES `celdas` WRITE;
/*!40000 ALTER TABLE `celdas` DISABLE KEYS */;
INSERT INTO `celdas` VALUES (1,1,12,10,100,1,9,9,10,52,1,72),(2,1,12,10,100,1,9,9,10,12,1,72),(3,1,12,10,100,1,9,9,10,50,1,72),(4,2,12,10,100,1,3,9,10,100,1,70),(5,2,12,10,100,1,6,0,0,4,1,2);
/*!40000 ALTER TABLE `celdas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `modulo`
--

DROP TABLE IF EXISTS `modulo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modulo` (
  `ID_Modulo` int(11) DEFAULT NULL,
  `ID_Bodega` int(11) DEFAULT NULL,
  `Alto` int(11) DEFAULT NULL,
  `Ancho` int(11) DEFAULT NULL,
  `Profundidad` int(11) DEFAULT NULL,
  `Peso_Limite` int(11) DEFAULT NULL,
  `Ubicacion_Producto` int(11) DEFAULT NULL,
  `Fecha_Hora` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Estado` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `modulo`
--

LOCK TABLES `modulo` WRITE;
/*!40000 ALTER TABLE `modulo` DISABLE KEYS */;
INSERT INTO `modulo` VALUES (1,1,100,100,12,100,1,'2017-11-09 16:16:57',1),(2,1,100,100,12,100,1,'2017-11-09 16:16:57',1),(3,1,100,100,12,100,1,'2017-11-09 16:16:57',1);
/*!40000 ALTER TABLE `modulo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `productos`
--

DROP TABLE IF EXISTS `productos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `productos` (
  `ID_Producto` int(11) DEFAULT NULL,
  `ID_Categoria` int(11) DEFAULT NULL,
  `ID_Celda` int(11) DEFAULT NULL,
  `ID_Temporada` int(11) DEFAULT NULL,
  `Nombre` varchar(100) DEFAULT NULL,
  `Url` varchar(100) DEFAULT NULL,
  `Referencia` varchar(100) DEFAULT NULL,
  `Descripcion` varchar(100) DEFAULT NULL,
  `Cantidad` int(11) DEFAULT NULL,
  `Precio` int(11) DEFAULT NULL,
  `Precio_anterior` int(11) DEFAULT NULL,
  `Id_Proveedor` int(11) DEFAULT NULL,
  `Peso` int(11) DEFAULT NULL,
  `Alto` int(11) DEFAULT NULL,
  `Ancho` int(11) DEFAULT NULL,
  `Profundidad` int(11) DEFAULT NULL,
  `Estado` int(11) DEFAULT NULL,
  `order_minima` int(11) DEFAULT NULL,
  `ID_Talla` int(11) DEFAULT NULL,
  `meses_garantia` int(11) DEFAULT NULL,
  `id_material` int(11) DEFAULT NULL,
  `id_genero` int(11) DEFAULT NULL,
  `id_marca` int(11) DEFAULT NULL,
  `id_origen` int(11) DEFAULT NULL,
  `jerarquia` int(11) DEFAULT NULL,
  `proveedor_dorado` int(11) DEFAULT NULL,
  `garantia_comercial` int(11) DEFAULT NULL,
  `Vistas` int(11) DEFAULT NULL,
  `Compras` int(11) DEFAULT NULL,
  `Activo` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `productos`
--

LOCK TABLES `productos` WRITE;
/*!40000 ALTER TABLE `productos` DISABLE KEYS */;
INSERT INTO `productos` VALUES (1,1,1,1,'prod1','laurl1','ref1','desc1',1,1,1,1,2,2,3,3,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
/*!40000 ALTER TABLE `productos` 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 2017-11-09 16:47:45
