# ************************************************************
# Sequel Pro SQL dump
# Versión 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.5.5-10.1.21-MariaDB)
# Base de datos: litaniweb
# Tiempo de Generación: 2017-05-26 18:31:05 +0000
# ************************************************************


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


# Volcado de tabla presupuestolinea
# ------------------------------------------------------------

CREATE TABLE `presupuestolinea` (
  `codpresupuesto` int(11) NOT NULL DEFAULT '0',
  `numlinea` tinyint(4) NOT NULL AUTO_INCREMENT,
  `codigo` text CHARACTER SET latin1 NOT NULL,
  `cantidad` float NOT NULL DEFAULT '0',
  `precio` float NOT NULL DEFAULT '0',
  `importe` float NOT NULL DEFAULT '0',
  `dcto` tinyint(4) NOT NULL DEFAULT '0',
  `descripcion` tinytext CHARACTER SET latin1 NOT NULL,
  `dias` int(11) NOT NULL DEFAULT '0',
  `iva` float NOT NULL DEFAULT '0',
  `importeiva` float NOT NULL DEFAULT '0',
  `deposito` varchar(2) COLLATE utf8_spanish_ci DEFAULT ' ',
  `idempresa` varchar(6) COLLATE utf8_spanish_ci DEFAULT NULL,
  KEY `codpresupuesto` (`codpresupuesto`,`numlinea`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;



# Volcado de tabla presupuestos
# ------------------------------------------------------------

CREATE TABLE `presupuestos` (
  `codpresupuesto` int(11) NOT NULL AUTO_INCREMENT,
  `quien` int(11) NOT NULL DEFAULT '0',
  `fecha` date NOT NULL DEFAULT '0000-00-00',
  `iva` float NOT NULL DEFAULT '0',
  `codcliente` varchar(15) COLLATE utf8_spanish_ci NOT NULL DEFAULT '0',
  `anyo` int(11) NOT NULL DEFAULT '0',
  `observaciones` text COLLATE utf8_spanish_ci NOT NULL,
  `nombr` text COLLATE utf8_spanish_ci NOT NULL,
  `codcosa` int(6) unsigned zerofill NOT NULL DEFAULT '000000',
  `anulado` tinyint(1) NOT NULL DEFAULT '0',
  `notanul` text COLLATE utf8_spanish_ci,
  `cosa` tinytext COLLATE utf8_spanish_ci NOT NULL,
  `idempresa` varchar(6) COLLATE utf8_spanish_ci DEFAULT NULL,
  `vendedor` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
  `gps_x` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
  `gps_y` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`codpresupuesto`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;
