-- phpMyAdmin SQL Dump -- version 4.7.6 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost -- Tiempo de generación: 05-12-2017 a las 15:06:26 -- Versión del servidor: 5.6.37 -- Versión de PHP: 7.1.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!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 utf8mb4 */; -- -- Base de datos: `qxh332` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `CLIENTE` -- CREATE TABLE `CLIENTE` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `TIPO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CATEGORIA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `DTORRES` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `NOMBRE` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `DESCUENTO` int(3) NOT NULL, `PAIS` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `DNI` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `CONTACTO` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `FALTA` date NOT NULL, `FBAJA` date NOT NULL, `DIRECC1` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `CODPOSTAL` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `CPAIS347` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `LOCALI1` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `PROVIN1` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `TELEFONO` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `TELEFONO2` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `TELEFONO3` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `MOVIL` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `FAX` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `EMAIL` varchar(59) COLLATE latin1_spanish_ci NOT NULL, `SECTORACTI` varchar(59) COLLATE latin1_spanish_ci NOT NULL, `CODCNAE` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `PROPIEDAD` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `NNOMINA` int(4) NOT NULL, `DIRRESP` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `GESCOBROS` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `RESFIS` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `RESJUR` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `RESLAB` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `RESFIN` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `RESMER` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `RESALQ` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `FORPAGO` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `DIA1` int(2) NOT NULL, `DIA2` int(3) NOT NULL, `DIA3` int(2) NOT NULL, `RECARGO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FORPAGO2` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `DIA2_1` int(2) NOT NULL, `DIA2_2` int(3) NOT NULL, `BANCO` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `OFICINA` varchar(8) COLLATE latin1_spanish_ci NOT NULL, `DC` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `CUENTA` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `CCCOK` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `IBAN` varchar(34) COLLATE latin1_spanish_ci NOT NULL, `BIC` varchar(11) COLLATE latin1_spanish_ci NOT NULL, `TELEFBANCO` varchar(12) COLLATE latin1_spanish_ci NOT NULL, `OBSERVACIO` text COLLATE latin1_spanish_ci NOT NULL, `MANDATOB2B` varchar(35) COLLATE latin1_spanish_ci NOT NULL, `FEMANDATO` date NOT NULL, `SECSEPA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `EXENTOIVA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CODMATRIZ` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `AGRUPACION` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CABGRUPO` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `CARACTERIS` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `DAC` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `GENERAR` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ZONA` varchar(6) COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `CLIENTE` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `EXTRAS1` -- CREATE TABLE `EXTRAS1` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `CATEGORIA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `NOMBRE` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `PROVISION` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `PRESUPUEST` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `VERIFIDG` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `DESCUENTOT` int(2) NOT NULL, `DESCUENTO2` int(2) NOT NULL, `CTAANUALES` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CTAANUOBS` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `LIBROS` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `LIBROSOBS` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `AVIINTERNO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `AVITELEFO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `AVIFAX` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ENVIOEMAIL` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ENVIOCORRE` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `OBSERVACIO` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `COMISIONIS` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `COMINTERNO` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `COMPROVEED` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `CODECOMIS` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `PORCABONO` decimal(6,2) NOT NULL, `LIMIABONO` date NOT NULL, `OBSEABONO` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `PORCEXPDTE` decimal(6,2) NOT NULL, `LIMIEXPDTE` date NOT NULL, `OBSEEXPDTE` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `NUMCASO` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `HONOABONO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `MOTIVO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `OTROCODE` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `AVISO01` varchar(35) COLLATE latin1_spanish_ci NOT NULL, `USUAR01` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `FECHA01` date NOT NULL, `AVISO02` varchar(35) COLLATE latin1_spanish_ci NOT NULL, `USUAR02` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `FECHA02` date NOT NULL, `AVISO03` varchar(35) COLLATE latin1_spanish_ci NOT NULL, `USUAR03` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `FECHA03` date NOT NULL, `FECHA04` date NOT NULL, `AVISOS` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CAPTACION` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CAPTADESC` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `MOTIVOBAJA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `DESCRIBAJA` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `EXTRAS1` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMACCIO` -- CREATE TABLE `JMACCIO` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMSOCIO` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `NUMDOCUM` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `ACCIONES` int(10) NOT NULL, `ACCIONESA` int(10) NOT NULL, `ACCIONESB` int(10) NOT NULL, `TOTACCIO` int(15) NOT NULL, `TOTACCIOA` int(15) NOT NULL, `TOTACCIOB` int(15) NOT NULL, `OBSERVA` text COLLATE latin1_spanish_ci NOT NULL, `ULT` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CLASE` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMACCIO` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMASUNT` -- CREATE TABLE `JMASUNT` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMORDEN` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `SEGCONTROL` text COLLATE latin1_spanish_ci NOT NULL, `ESTADO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FREALIZA` date NOT NULL, `FREGISTRO` date NOT NULL, `FALTA` date NOT NULL, `FLIMITE` date NOT NULL, `PUEDEIMP` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ASUNTO` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `AMPASUNTO` text COLLATE latin1_spanish_ci NOT NULL, `NEWESTADO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMASUNT` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMCAPSO` -- CREATE TABLE `JMCAPSO` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMORDEN` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `FECHAORDEN` date NOT NULL, `CAPISOC` decimal(16,2) NOT NULL, `NACCPAR` int(8) NOT NULL, `VALORNO` decimal(16,2) NOT NULL, `CAPISOCA` decimal(16,2) NOT NULL, `NACCPARA` int(8) NOT NULL, `VALORNOA` decimal(16,2) NOT NULL, `CAPISOCB` decimal(16,2) NOT NULL, `NACCPARB` int(8) NOT NULL, `VALORNOB` decimal(16,2) NOT NULL, `CAPISOCT` decimal(16,2) NOT NULL, `MONEDA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `TIPOACC` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `PDTEDES` decimal(16,2) NOT NULL, `FTOPEDE` date NOT NULL, `OBSERVA` text COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMCAPSO` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMCTOUN` -- CREATE TABLE `JMCTOUN` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMCONTRA` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `ESTADO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FECONTRATO` date NOT NULL, `FEVIGENCIA` date NOT NULL, `NATURALEZA` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `CONDICIONE` text COLLATE latin1_spanish_ci NOT NULL, `OBSERVACIO` text COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMCTOUN` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMDATVI` -- CREATE TABLE `JMDATVI` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMORDEN` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `DENOSOCIAL` varchar(250) COLLATE latin1_spanish_ci NOT NULL, `OBJSOCIAL` text COLLATE latin1_spanish_ci NOT NULL, `DOCCAMBIO` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `CONJUNTAS` varchar(50) COLLATE latin1_spanish_ci NOT NULL, `DIACIERRE` int(2) NOT NULL, `MESCIERRE` int(2) NOT NULL, `AUDITORIA1` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `AUDITORIA2` varchar(50) COLLATE latin1_spanish_ci NOT NULL, `AUDITORES` varchar(55) COLLATE latin1_spanish_ci NOT NULL, `DURACION` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `ESTEMPRESA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FESTEMPRE` date NOT NULL, `ANUNCIOS1` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ANUNCIOS2` varchar(50) COLLATE latin1_spanish_ci NOT NULL, `UNIPERSO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `LIBROSJUN` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `LIBROSCON` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `OBSERCLTE` varchar(120) COLLATE latin1_spanish_ci NOT NULL, `OBSERCLTE2` varchar(120) COLLATE latin1_spanish_ci NOT NULL, `ASUNPTES` varchar(120) COLLATE latin1_spanish_ci NOT NULL, `ASUNPTES2` varchar(120) COLLATE latin1_spanish_ci NOT NULL, `TOMO` varchar(6) COLLATE latin1_spanish_ci NOT NULL, `LIBRO` varchar(6) COLLATE latin1_spanish_ci NOT NULL, `FOLIO` varchar(6) COLLATE latin1_spanish_ci NOT NULL, `SECCION` varchar(6) COLLATE latin1_spanish_ci NOT NULL, `HOJA` varchar(7) COLLATE latin1_spanish_ci NOT NULL, `INSCRIP` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `OBSERVA` text COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMDATVI` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMDOCPU` -- CREATE TABLE `JMDOCPU` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMORDEN` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `ESTADO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FECHA` date NOT NULL, `TIPO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FEDATARIO` varchar(60) COLLATE latin1_spanish_ci NOT NULL, `NPROTOCOL` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `CONTENIDO` varchar(65) COLLATE latin1_spanish_ci NOT NULL, `AMPLIACION` text COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMDOCPU` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMDOMSO` -- CREATE TABLE `JMDOMSO` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMORDEN` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `DS_TVIA` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `DS_VIA` varchar(45) COLLATE latin1_spanish_ci NOT NULL, `DS_NUME` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `DS_ESCA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `DS_PISO` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `DS_PRTA` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `DS_CP` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `DS_LOCA` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `DS_PROV` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `OBSERVA` varchar(65) COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMDOMSO` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMGESAC` -- CREATE TABLE `JMGESAC` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMORDEN` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `FECHA` date NOT NULL, `TIPO1` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CONVOCA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ESTADO` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `CONTENIDO` varchar(65) COLLATE latin1_spanish_ci NOT NULL, `AMPLIACION` text COLLATE latin1_spanish_ci NOT NULL, `EJERCICIO` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `TOTACTIVO` decimal(12,2) NOT NULL, `NETONEGOCI` decimal(12,2) NOT NULL, `PERDGANANC` decimal(12,2) NOT NULL, `REMANENTES` decimal(12,2) NOT NULL, `RESERVOLUN` decimal(12,2) NOT NULL, `RESERVAS` decimal(12,2) NOT NULL, `TOTALREPAR` decimal(12,2) NOT NULL, `RRESERLEGA` decimal(12,2) NOT NULL, `RRESERVOLU` decimal(12,2) NOT NULL, `RRESERVAS` decimal(12,2) NOT NULL, `RDIVIDENDO` decimal(12,2) NOT NULL, `RCOMPANTES` decimal(12,2) NOT NULL, `RCOMPFUTUR` decimal(12,2) NOT NULL, `AOTRAS` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `ROTRAS` decimal(12,2) NOT NULL, `TOTALRESUL` decimal(12,2) NOT NULL, `TIPOCUENTA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `REPDIVIDED` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `AUDITORIA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `RAZONAUDIT` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ESANYO3` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `MASDE3ANYO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `DESEQPATRI` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `ENVIOCARTA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `MOTIVO` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `ABREEXPDTE` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FECCIERRE` date NOT NULL, `FECCTAANU` date NOT NULL, `NUMPAGINAS` int(3) NOT NULL, `ACCPROPIAS` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `UNIPERSONA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CTOTRANSCR` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `HUELLA` varchar(44) COLLATE latin1_spanish_ci NOT NULL, `USERCTA` varchar(18) COLLATE latin1_spanish_ci NOT NULL, `USERCON` varchar(18) COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMGESAC` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMORADM` -- CREATE TABLE `JMORADM` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `SOCIO` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `NUMDOCUM` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `ORGADM` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `ESTADO1` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `FNOMBRA` date NOT NULL, `FVENCIMI` date NOT NULL, `FREVOCESE` date NOT NULL, `MOTIVOCAN` varchar(60) COLLATE latin1_spanish_ci NOT NULL, `FPRIMERO` date NOT NULL, `FMAXIMA` date NOT NULL, `TIPODER` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `AMPLIACION` text COLLATE latin1_spanish_ci NOT NULL, `OBSERVA` text COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMORADM` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMPARTI` -- CREATE TABLE `JMPARTI` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMSOCIO` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `NUMPARTE` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `ESTADO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `SOCIEDAD` varchar(35) COLLATE latin1_spanish_ci NOT NULL, `OBJETO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CARGO` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `PARTICIPAC` decimal(6,2) NOT NULL, `DESCRIPCIO` varchar(60) COLLATE latin1_spanish_ci NOT NULL, `OBJETOACTI` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `PORCUENTA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMPARTI` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMPATRI` -- CREATE TABLE `JMPATRI` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `FBALANCE` date NOT NULL, `VALORNETO` decimal(16,2) NOT NULL, `MONEDA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `VALORTE` decimal(16,2) NOT NULL, `VALORTEA` decimal(16,2) NOT NULL, `VALORTEB` decimal(16,2) NOT NULL, `OBSERVA` text COLLATE latin1_spanish_ci NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMPATRI` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `JMSOCIO` -- CREATE TABLE `JMSOCIO` ( `CODCLI` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `NUMSOCIO` varchar(4) COLLATE latin1_spanish_ci NOT NULL, `ESTADO` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `NUMORDEN` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `NOMBRE` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `APELLIDOS` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `APELLIDOS2` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `TVIA` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `VIA` varchar(45) COLLATE latin1_spanish_ci NOT NULL, `NUME` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `ESCA` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `PISO` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `PRTA` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `FNACIMI` date NOT NULL, `NACIONAL` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `CP` varchar(5) COLLATE latin1_spanish_ci NOT NULL, `LOCA` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `PROV` varchar(30) COLLATE latin1_spanish_ci NOT NULL, `REPRESENTA` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `NOMREPRESE` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `ECIVIL` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `NIF` varchar(14) COLLATE latin1_spanish_ci NOT NULL, `REGIMEN` varchar(1) COLLATE latin1_spanish_ci NOT NULL, `CARGO` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `CARGOCERTI` varchar(2) COLLATE latin1_spanish_ci NOT NULL, `CYGNOMBRE` varchar(20) COLLATE latin1_spanish_ci NOT NULL, `CYGAPELLI1` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `CYGAPELLI2` varchar(40) COLLATE latin1_spanish_ci NOT NULL, `CYGNIF` varchar(14) COLLATE latin1_spanish_ci NOT NULL, `OBSERVA` text COLLATE latin1_spanish_ci NOT NULL, `TOTACCIO` int(10) NOT NULL, `TOTACCIOA` int(10) NOT NULL, `TOTACCIOB` int(10) NOT NULL, `TOTACCIOT` int(10) NOT NULL, `DOCULTIMO` varchar(3) COLLATE latin1_spanish_ci NOT NULL, `VNOMINAL` decimal(12,2) NOT NULL, `VNOMINALA` decimal(12,2) NOT NULL, `VNOMINALB` decimal(12,2) NOT NULL, `VTEORICO` decimal(12,2) NOT NULL, `VTEORICOA` decimal(12,2) NOT NULL, `VTEORICOB` decimal(12,2) NOT NULL, `FBALANCE` date NOT NULL, `PORCENPART` decimal(6,2) NOT NULL, `RegistroActivo` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `JMSOCIO` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `OFICINA` -- CREATE TABLE `OFICINA` ( `Id` int(10) NOT NULL, `Nombre` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `Valor` varchar(10) COLLATE latin1_spanish_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `OFICINA` -- INSERT INTO `OFICINA` (`Id`, `Nombre`, `Valor`) VALUES (1, 'Dias', '5'), (2, 'Cambios', '5'), (3, 'ULTIMO', '00000'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `PERSONALIZAR` -- CREATE TABLE `PERSONALIZAR` ( `ID` int(10) NOT NULL, `Nombre` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `Valor` text COLLATE latin1_spanish_ci NOT NULL, `Usuario` int(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `PERSONALIZAR` -- -- -- Estructura de tabla para la tabla `USUARIO` -- CREATE TABLE `USUARIO` ( `IdUsuario` int(10) NOT NULL, `Siglas` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `Rol` varchar(10) COLLATE latin1_spanish_ci NOT NULL, `Correo` varchar(100) COLLATE latin1_spanish_ci NOT NULL, `Nombre` varchar(100) COLLATE latin1_spanish_ci NOT NULL, `Apellidos` varchar(100) COLLATE latin1_spanish_ci NOT NULL, `DNI` varchar(9) COLLATE latin1_spanish_ci NOT NULL, `Password` varchar(50) COLLATE latin1_spanish_ci NOT NULL, `Acceso` int(2) NOT NULL, `Activo` int(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci; -- -- Volcado de datos para la tabla `USUARIO` -- INSERT INTO `USUARIO` (`IdUsuario`, `Siglas`, `Rol`, `Correo`, `Nombre`, `Apellidos`, `DNI`, `Password`, `Acceso`, `Activo`) VALUES (1, 'ADMIN', 'A', 'admin@correo.es', 'ADMIN', 'ADMIN', '12345678Z', '7c4a8d09ca3762af61e59520943dc26494f8941b', 1, 1); -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `CLIENTE` -- ALTER TABLE `CLIENTE` ADD PRIMARY KEY (`CODCLI`); ALTER TABLE `CLIENTE` ADD FULLTEXT KEY `CODCLI` (`CODCLI`,`NOMBRE`,`DNI`,`CONTACTO`,`DIRECC1`,`CODPOSTAL`,`LOCALI1`,`PROVIN1`,`RESMER`); -- -- Indices de la tabla `EXTRAS1` -- ALTER TABLE `EXTRAS1` ADD PRIMARY KEY (`CODCLI`); -- -- Indices de la tabla `JMACCIO` -- ALTER TABLE `JMACCIO` ADD PRIMARY KEY (`CODCLI`,`NUMSOCIO`,`NUMDOCUM`); -- -- Indices de la tabla `JMASUNT` -- ALTER TABLE `JMASUNT` ADD PRIMARY KEY (`CODCLI`,`NUMORDEN`); -- -- Indices de la tabla `JMCAPSO` -- ALTER TABLE `JMCAPSO` ADD PRIMARY KEY (`CODCLI`,`NUMORDEN`); -- -- Indices de la tabla `JMCTOUN` -- ALTER TABLE `JMCTOUN` ADD PRIMARY KEY (`CODCLI`,`NUMCONTRA`); -- -- Indices de la tabla `JMDATVI` -- ALTER TABLE `JMDATVI` ADD PRIMARY KEY (`CODCLI`); -- -- Indices de la tabla `JMDOCPU` -- ALTER TABLE `JMDOCPU` ADD PRIMARY KEY (`CODCLI`,`NUMORDEN`); -- -- Indices de la tabla `JMDOMSO` -- ALTER TABLE `JMDOMSO` ADD PRIMARY KEY (`CODCLI`,`NUMORDEN`); -- -- Indices de la tabla `JMGESAC` -- ALTER TABLE `JMGESAC` ADD PRIMARY KEY (`CODCLI`,`NUMORDEN`); -- -- Indices de la tabla `JMORADM` -- ALTER TABLE `JMORADM` ADD PRIMARY KEY (`CODCLI`,`SOCIO`,`NUMDOCUM`); -- -- Indices de la tabla `JMPARTI` -- ALTER TABLE `JMPARTI` ADD PRIMARY KEY (`CODCLI`,`NUMSOCIO`,`NUMPARTE`); -- -- Indices de la tabla `JMPATRI` -- ALTER TABLE `JMPATRI` ADD PRIMARY KEY (`CODCLI`,`FBALANCE`); -- -- Indices de la tabla `JMSOCIO` -- ALTER TABLE `JMSOCIO` ADD PRIMARY KEY (`CODCLI`,`NUMSOCIO`); -- -- Indices de la tabla `OFICINA` -- ALTER TABLE `OFICINA` ADD PRIMARY KEY (`Id`); -- -- Indices de la tabla `PERSONALIZAR` -- ALTER TABLE `PERSONALIZAR` ADD PRIMARY KEY (`ID`); -- -- Indices de la tabla `USUARIO` -- ALTER TABLE `USUARIO` ADD PRIMARY KEY (`IdUsuario`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `OFICINA` -- ALTER TABLE `OFICINA` MODIFY `Id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `PERSONALIZAR` -- ALTER TABLE `PERSONALIZAR` MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT de la tabla `USUARIO` -- ALTER TABLE `USUARIO` MODIFY `IdUsuario` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; COMMIT; /*!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 */;