--
-- Base de datos: `plscongr`
--
CREATE DATABASE IF NOT EXISTS `plscongr` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `plscongr`;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `Clientes`
--
DROP TABLE IF EXISTS `Clientes`;
CREATE TABLE IF NOT EXISTS `Clientes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Pref` varchar(10) NOT NULL,
`Nom` varchar(50) NOT NULL,
`SNom` varchar(50) NOT NULL,
`PriApe` varchar(50) NOT NULL,
`SecAPe` varchar(50) NOT NULL,
`e-mail` varchar(50) NOT NULL,
`ORG` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_1DEBC`
--
DROP TABLE IF EXISTS `PL_1DEBC`;
CREATE TABLE IF NOT EXISTS `PL_1DEBC` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGAPubC` varchar(50) NOT NULL,
`NGAPubC` varchar(50) NOT NULL,
`FGp1Ca` varchar(50) NOT NULL,
`NGp1Ca` varchar(50) NOT NULL,
`FGp1Cb` varchar(50) NOT NULL,
`NGp1Cb` varchar(50) NOT NULL,
`FGp1Cc` varchar(50) NOT NULL,
`NGp1Cc` varchar(50) NOT NULL,
`FGCAnu1` varchar(50) NOT NULL,
`NGCAnu1` varchar(50) NOT NULL,
`FGd1Ca` varchar(50) NOT NULL,
`NGd1Ca` varchar(50) NOT NULL,
`FGd1Cb` varchar(50) NOT NULL,
`NGd1Cb` varchar(50) NOT NULL,
`FGd1Cc` varchar(50) NOT NULL,
`NGd1Cc` varchar(50) NOT NULL,
`FGTA1C` varchar(50) NOT NULL,
`NGTA1C` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_1DEBS`
--
DROP TABLE IF EXISTS `PL_1DEBS`;
CREATE TABLE IF NOT EXISTS `PL_1DEBS` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGAPubS` varchar(50) NOT NULL,
`NGAPubS` varchar(50) NOT NULL,
`FGp1Sa` varchar(50) NOT NULL,
`NGp1Sa` varchar(50) NOT NULL,
`FGp1Sb` varchar(50) NOT NULL,
`NGp1Sb` varchar(50) NOT NULL,
`FGp1Sc` varchar(50) NOT NULL,
`NGp1Sc` varchar(50) NOT NULL,
`FGSAnu1` varchar(50) NOT NULL,
`NGSAnu1` varchar(50) NOT NULL,
`FGd1Sa` varchar(50) NOT NULL,
`NGd1Sa` varchar(50) NOT NULL,
`FGd1Sb` varchar(50) NOT NULL,
`NGd1Sb` varchar(50) NOT NULL,
`FGd1Sc` varchar(50) NOT NULL,
`NGd1Sc` varchar(50) NOT NULL,
`FGTA1S` varchar(50) NOT NULL,
`NGTA1S` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_2DEBC`
--
DROP TABLE IF EXISTS `PL_2DEBC`;
CREATE TABLE IF NOT EXISTS `PL_2DEBC` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGp2Sa` varchar(50) NOT NULL,
`NGp2Sa` varchar(50) NOT NULL,
`FGp2Sb` varchar(50) NOT NULL,
`NGp2Sb` varchar(50) NOT NULL,
`FGp2Sc` varchar(50) NOT NULL,
`NGp2Sc` varchar(50) NOT NULL,
`FGSAnu2` varchar(50) NOT NULL,
`NGSAnu2` varchar(50) NOT NULL,
`FGd2Sa` varchar(50) NOT NULL,
`NGd2Sa` varchar(50) NOT NULL,
`FGd2Sb` varchar(50) NOT NULL,
`NGd2Sb` varchar(50) NOT NULL,
`FGd2Sc` varchar(50) NOT NULL,
`NGd2Sc` varchar(50) NOT NULL,
`FGTA2S` varchar(50) NOT NULL,
`NGTA2S` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_2DEBS`
--
DROP TABLE IF EXISTS `PL_2DEBS`;
CREATE TABLE IF NOT EXISTS `PL_2DEBS` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGp2Ca` varchar(50) NOT NULL,
`NGp2Ca` varchar(50) NOT NULL,
`FGp2Cb` varchar(50) NOT NULL,
`NGp2Cb` varchar(50) NOT NULL,
`FGp2Cc` varchar(50) NOT NULL,
`NGp2Cc` varchar(50) NOT NULL,
`FGCAnu2` varchar(50) NOT NULL,
`NGCAnu2` varchar(50) NOT NULL,
`FGd2Ca` varchar(50) NOT NULL,
`NGd2Ca` varchar(50) NOT NULL,
`FGd2Cb` varchar(50) NOT NULL,
`NGd2Cb` varchar(50) NOT NULL,
`FGd2Cc` varchar(50) NOT NULL,
`NGd2Cc` varchar(50) NOT NULL,
`FGTA2C` varchar(50) NOT NULL,
`NGTA2C` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_ComJur`
--
DROP TABLE IF EXISTS `PL_ComJur`;
CREATE TABLE IF NOT EXISTS `PL_ComJur` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`NGComJur` varchar(500) NOT NULL,
`AutorComJur` varchar(500) NOT NULL,
`FComJur` date NOT NULL,
`ResumComJur` text NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_CONC`
--
DROP TABLE IF EXISTS `PL_CONC`;
CREATE TABLE IF NOT EXISTS `PL_CONC` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGicC` varchar(50) NOT NULL,
`NGicC` varchar(50) NOT NULL,
`FGacC` varchar(50) NOT NULL,
`NGacC` varchar(50) NOT NULL,
`FGdcC` varchar(50) NOT NULL,
`NGdcC` varchar(50) NOT NULL,
`NGFerrC` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_CONS`
--
DROP TABLE IF EXISTS `PL_CONS`;
CREATE TABLE IF NOT EXISTS `PL_CONS` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGicS` varchar(50) NOT NULL,
`NGicS` varchar(50) NOT NULL,
`FGacS` varchar(50) NOT NULL,
`NGacS` varchar(50) NOT NULL,
`FGdcS` varchar(50) NOT NULL,
`NGdcS` varchar(50) NOT NULL,
`NGFerrS` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_id`
--
DROP TABLE IF EXISTS `PL_id`;
CREATE TABLE IF NOT EXISTS `PL_id` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Legis` int(5) NOT NULL,
`Norm` varchar(25) NOT NULL,
`No` int(11) NOT NULL,
`Yr_Orig` year(4) NOT NULL,
`Orig` varchar(20) NOT NULL,
`No_Tra` int(11) NOT NULL,
`Yr_Tra` year(4) NOT NULL,
`Tran` varchar(20) NOT NULL,
`Titulo` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_IMPACTO`
--
DROP TABLE IF EXISTS `PL_IMPACTO`;
CREATE TABLE IF NOT EXISTS `PL_IMPACTO` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`id_CLIENTE` int(11) NOT NULL,
`COn_IMPACTO` text NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`,`id_CLIENTE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_IN_CONT`
--
DROP TABLE IF EXISTS `PL_IN_CONT`;
CREATE TABLE IF NOT EXISTS `PL_IN_CONT` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`Objeto` text NOT NULL,
`RESUMEN 1DEB` text NOT NULL,
`RESUMEN 2DEB` text NOT NULL,
`RESUMEN 3DEB` text NOT NULL,
`RESUMEN 4DEB` text NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_OBJC`
--
DROP TABLE IF EXISTS `PL_OBJC`;
CREATE TABLE IF NOT EXISTS `PL_OBJC` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGobjC` varchar(50) NOT NULL,
`NGobjC` varchar(50) NOT NULL,
`FInfObjC` varchar(50) NOT NULL,
`GInfObjC` varchar(50) NOT NULL,
`FGAobjC` varchar(50) NOT NULL,
`NGAobjC` varchar(50) NOT NULL,
`FGDobjC` varchar(50) NOT NULL,
`NGDobjC` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_OBJS`
--
DROP TABLE IF EXISTS `PL_OBJS`;
CREATE TABLE IF NOT EXISTS `PL_OBJS` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`FGobjS` varchar(50) NOT NULL,
`NGobjS` varchar(50) NOT NULL,
`FInfObjS` varchar(50) NOT NULL,
`GInfObjS` varchar(50) NOT NULL,
`FGAobjS` varchar(50) NOT NULL,
`NGAobjS` varchar(50) NOT NULL,
`FGDobjS` varchar(50) NOT NULL,
`NGDobjS` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_Ponen`
--
DROP TABLE IF EXISTS `PL_Ponen`;
CREATE TABLE IF NOT EXISTS `PL_Ponen` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`P1S` varchar(500) NOT NULL,
`F_P1S` date NOT NULL,
`P2DS` varchar(500) NOT NULL,
`F_P2S` date NOT NULL,
`CCS` varchar(500) NOT NULL,
`F_CCS` date NOT NULL,
`COBJS` varchar(500) NOT NULL,
`F_COBJS` date NOT NULL,
`P1C` varchar(500) NOT NULL,
`F_P1C` date NOT NULL,
`P2C` varchar(500) NOT NULL,
`F_P2C` date NOT NULL,
`CCC` varchar(500) NOT NULL,
`F_CCC` date NOT NULL,
`COBJC` varchar(500) NOT NULL,
`F_COBJC` date NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_Ref`
--
DROP TABLE IF EXISTS `PL_Ref`;
CREATE TABLE IF NOT EXISTS `PL_Ref` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`Autor` varchar(500) NOT NULL,
`F_Radic` date NOT NULL,
`F_Recep` date NOT NULL,
`Comi` varchar(11) NOT NULL,
`F_Remis` date NOT NULL,
`F_Recib` date NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_TOGC`
--
DROP TABLE IF EXISTS `PL_TOGC`;
CREATE TABLE IF NOT EXISTS `PL_TOGC` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`NGPOC1` varchar(500) NOT NULL,
`NGPOC2` varchar(500) NOT NULL,
`NGPOC3` varchar(500) NOT NULL,
`NGPOC4` varchar(500) NOT NULL,
`NGPOC5` varchar(500) NOT NULL,
`NGPOC6` varchar(500) NOT NULL,
`NGPOC7` varchar(500) NOT NULL,
`NGPOC8` varchar(500) NOT NULL,
`NGPOC9` varchar(500) NOT NULL,
`NGPOC10` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `PL_TOGS`
--
DROP TABLE IF EXISTS `PL_TOGS`;
CREATE TABLE IF NOT EXISTS `PL_TOGS` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_PL` int(11) NOT NULL,
`NGPOS1` varchar(500) NOT NULL,
`NGPOS2` varchar(500) NOT NULL,
`NGPOS3` varchar(500) NOT NULL,
`NGPOS4` varchar(500) NOT NULL,
`NGPOS5` varchar(500) NOT NULL,
`NGPOS6` varchar(500) NOT NULL,
`NGPOS7` varchar(500) NOT NULL,
`NGPOS8` varchar(500) NOT NULL,
`NGPOS9` varchar(500) NOT NULL,
`NGPOS10` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_PL` (`id_PL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
/*!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 */;