Skip to content

Instantly share code, notes, and snippets.

@robert76ers
Created June 9, 2013 22:14
Show Gist options
  • Save robert76ers/5745469 to your computer and use it in GitHub Desktop.
Save robert76ers/5745469 to your computer and use it in GitHub Desktop.
--
-- Estructura de tabla para la tabla `credito_datocredicitioitemeconomico`
--
CREATE TABLE `credito_datocredicitioitemeconomico` (
`secuencial` int(6) NOT NULL auto_increment,
`secuencialDatoCrediticio` int(6) NOT NULL,
`codigoItemEconomico` varchar(200) NOT NULL,
`monto` decimal(12,2) NOT NULL default '0.00',
`estaActivo` int(6) NOT NULL default '1',
PRIMARY KEY (`secuencial`),
KEY `secuencialDatoCrediticio` (`secuencialDatoCrediticio`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `credito_datocredicitioitemeconomico`
--
--
-- Filtros para las tablas descargadas (dump)
--
--
-- Filtros para la tabla `credito_datocredicitioitemeconomico`
--
ALTER TABLE `credito_datocredicitioitemeconomico`
ADD CONSTRAINT `credito_datocredicitioitemeconomico_ibfk_1` FOREIGN KEY (`secuencialDatoCrediticio`) REFERENCES `credito_datocrediticio` (`secuencial`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment