XBrFmsTz

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Servidor: localhost
6-- Versión del servidor: 5.5.58-0+deb8u1
7-- Versión de PHP: 5.6.30-0+deb8u1
8
9SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
10SET time_zone = "+00:00";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Base de datos: `Mikrowisp5`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Estructura de tabla para la tabla `afip`
26--
27
28CREATE TABLE IF NOT EXISTS `afip` (
29`id` int(11) NOT NULL,
30  `cliente` int(6) unsigned zerofill NOT NULL,
31  `pdf` text NOT NULL,
32  `invoice_num` varchar(50) NOT NULL,
33  `cae` varchar(150) NOT NULL,
34  `vto` date NOT NULL,
35  `barcode` varchar(150) NOT NULL,
36  `idfactura` int(8) unsigned zerofill NOT NULL,
37  `total` decimal(10,2) NOT NULL,
38  `emitido` date NOT NULL,
39  `idcredito` int(11) NOT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- --------------------------------------------------------
43
44--
45-- Estructura de tabla para la tabla `afiptmp`
46--
47
48CREATE TABLE IF NOT EXISTS `afiptmp` (
49`id` int(11) NOT NULL,
50  `factura` int(8) unsigned zerofill NOT NULL,
51  `nombre` varchar(350) NOT NULL
52) ENGINE=InnoDB DEFAULT CHARSET=latin1;
53
54-- --------------------------------------------------------
55
56--
57-- Estructura de tabla para la tabla `almacen`
58--
59
60CREATE TABLE IF NOT EXISTS `almacen` (
61`id` int(11) NOT NULL,
62  `userid` int(6) unsigned zerofill NOT NULL,
63  `productoid` int(11) NOT NULL,
64  `serial_producto` varchar(30) NOT NULL,
65  `mac_producto` varchar(25) NOT NULL,
66  `fecha_ingreso` date NOT NULL,
67  `fecha_salida` date NOT NULL,
68  `estado` varchar(14) NOT NULL DEFAULT 'disponible',
69  `cantidad` int(11) NOT NULL DEFAULT '1',
70  `catid` varchar(20) NOT NULL DEFAULT 'producto',
71  `costo` decimal(10,2) NOT NULL
72) ENGINE=InnoDB AUTO_INCREMENT=5741 DEFAULT CHARSET=latin1;
73
74--
75-- Volcado de datos para la tabla `almacen`
76--
77
78
79Complete database download from
80https://ufile.io/ehjh7c
81https://es.files.fm/u/cnejvc92
82https://anonfile.com/w8a23erfbd/Mikrowisp5_sql
83https://gofile.io/?c=ClmBvV 
84https://filebin.net/h7o2ly7hb8g66e2u/Mikrowisp5.sql?t=o2t4t86b