-- 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

START TRANSACTION;



--
-- 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;

--
-- 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`);

--
-- 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;
COMMIT;

