Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
to get an idea, this is how my database looks like:
[syntax="sql"]CREATE TABLE `esqueleto_eda` (
`ID` int(11) NOT NULL auto_increment,
`NUMERO_REVISTA` int(10) default NULL,
`MES_PUBLICACION` varchar(100) default NULL,
`ANIO_PUBLICACION` int(4) default NULL,
`ATICO1_SECCION` varchar(255) default NULL,
`ATICO1_SUBSECCION` varchar(255) default NULL,
`ATICO1_ARTICULO` blob,
`ATICO1_AUTOR` blob,
`ATICO1_V601_FECHAASIGNACION` date default NULL,
`ATICO1_601_FECHA1ERENTREGA` date default NULL,
`ATICO1_601_FECHARETRO` date default NULL,
`ATICO1_601_FECHAFINAL` date default NULL,
`ATICO1_604_NUMEROPANTALLAS` int(4) default NULL,
`ATICO1_604_PORAVANCE2` int(3) default NULL,
`ATICO1_604_PORAVANCE3` int(3) default NULL,
`ATICO1_604_FINALED` varchar(100) default NULL,
`ATICO1_604_PORAVANCE1` int(3) default NULL,
`ATICO1_604_FECHAVANCE1` int(3) default NULL,
`ATICO1_604_DEADLINE` date default NULL,
`ATICO1_604_FECHAFINAL` date default NULL,
`ATICO1_605_PORAVANCE1` int(3) default NULL,
`ATICO1_605_FECHAAVANCE1` date default NULL,
`ATICO1_605_FINALDISENO` date default NULL,
`ATICO1_605_FECHAFINAL` date default NULL,
`ATICO1_605_PORAVANCE1AN` int(3) default NULL,
`ATICO1_605_FECHAAVANCE1AN` date default NULL,
`ATICO1_605_DEADLINE` date default NULL,
`ATICO1_605_FECHAFINALAN` date default NULL,
`ATICO2_SECCION` varchar(255) default NULL,
`ATICO2_SUBSECCION` varchar(255) default NULL,
`ATICO2_ARTICULO` blob,
`ATICO2_AUTOR` blob,
`ATICO2_601_FECHAASIGNACION` date default NULL,
`ATICO2_601_FECHA1ERENTREGA` date default NULL,
`ATICO2_601_FECHARETRO` date default NULL,
`ATICO2_601_FECHAFINAL` date default NULL,
`ATICO2_604_NUMEROPANTALLAS` int(4) default NULL,
`ATICO2_604_PORAVANCE2` int(3) default NULL,
`ATICO2_604_PORAVANCE3` int(3) default NULL,
`ATICO2_604_FINALED` varchar(100) default NULL,
`ATICO2_604_PORAVANCE1` int(3) default NULL,
`ATICO2_604_FECHAVANCE1` int(3) default NULL,
`ATICO2_604_DEADLINE` date default NULL,
`ATICO2_604_FECHAFINAL` date default NULL,
`ATICO2_605_PORAVANCE1` int(3) default NULL,
`ATICO2_605_FECHAAVANCE1` date default NULL,
`ATICO2_605_FINALDISENO` date default NULL,
`ATICO2_605_FECHAFINAL` date default NULL,
`ATICO2_605_PORAVANCE1AN` int(3) default NULL,
`ATICO2_605_FECHAAVANCE1AN` date default NULL,
`ATICO2_605_DEADLINE` date default NULL,
`ATICO2_605_FECHAFINALAN` date default NULL,
`ATICO3_SECCION` varchar(255) default NULL,
`ATICO3_SUBSECCION` varchar(255) default NULL,
`ATICO3_ARTICULO` blob,
`ATICO3_AUTOR` blob,
`ATICO3_601_FECHAASIGNACION` date default NULL,
`ATICO3_601_FECHA1ERENTREGA` date default NULL,
`ATICO3_601_FECHARETRO` date default NULL,
`ATICO3_601_FECHAFINAL` date default NULL,
`ATICO3_604_NUMEROPANTALLAS` int(4) default NULL,
`ATICO3_604_PORAVANCE2` int(3) default NULL,
`ATICO3_604_PORAVANCE3` int(3) default NULL,
`ATICO3_604_FINALED` varchar(100) default NULL,
`ATICO3_604_PORAVANCE1` int(3) default NULL,
`ATICO3_604_FECHAVANCE1` int(3) default NULL,
`ATICO3_604_DEADLINE` date default NULL,
`ATICO3_604_FECHAFINAL` date default NULL,
`ATICO3_605_PORAVANCE1` int(3) default NULL,
`ATICO3_605_FECHAAVANCE1` date default NULL,
`ATICO3_605_FINALDISENO` date default NULL,
`ATICO3_605_FECHAFINAL` date default NULL,
`ATICO3_605_PORAVANCE1AN` int(3) default NULL,
`ATICO3_605_FECHAAVANCE1AN` date default NULL,
`ATICO3_605_DEADLINE` date default NULL,
`ATICO3_605_FECHAFINALAN` date default NULL,
`AGORA1_SECCION` varchar(255) default NULL,
`AGORA1_SUBSECCION` varchar(255) default NULL,
`AGORA1_ARTICULO` blob,
`AGORA1_AUTOR` blob,
`AGORA1_601_FECHAASIGNACION` date default NULL,
`AGORA1_601_FECHA1ERENTREGA` date default NULL,
`AGORA1_601_FECHARETRO` date default NULL,
`AGORA1_601_FECHAFINAL` date default NULL,
`AGORA1_604_NUMEROPANTALLAS` int(4) default NULL,
`AGORA1_604_PORAVANCE2` int(3) default NULL,
`AGORA1_604_PORAVANCE3` int(3) default NULL,
`AGORA1_604_FINALED` varchar(100) default NULL,
`AGORA1_604_PORAVANCE1` int(3) default NULL,
`AGORA1_604_FECHAVANCE1` int(3) default NULL,
`AGORA1_604_DEADLINE` date default NULL,
`AGORA1_604_FECHAFINAL` date default NULL,
`AGORA1_605_PORAVANCE1` int(3) default NULL,
`AGORA1_605_FECHAAVANCE1` date default NULL,
`AGORA1_605_FINALDISENO` date default NULL,
`AGORA1_605_FECHAFINAL` date default NULL,
`AGORA1_605_PORAVANCE1AN` int(3) default NULL,
`AGORA1_605_FECHAAVANCE1AN` date default NULL,
`AGORA1_605_DEADLINE` date default NULL,
`AGORA1_605_FECHAFINALAN` date default NULL,
`AGORA2_SECCION` varchar(255) default NULL,
`AGORA2_SUBSECCION` varchar(255) default NULL,
`AGORA2_ARTICULO` blob,
`AGORA2_AUTOR` blob,
`AGORA2_601_FECHAASIGNACION` date default NULL,
`AGORA2_601_FECHA1ERENTREGA` date default NULL,
`AGORA2_601_FECHARETRO` date default NULL,
`AGORA2_601_FECHAFINAL` date default NULL,
`AGORA2_604_NUMEROPANTALLAS` int(4) default NULL,
`AGORA2_604_PORAVANCE2` int(3) default NULL,
`AGORA2_604_PORAVANCE3` int(3) default NULL,
`AGORA2_604_FINALED` varchar(100) default NULL,
`AGORA2_604_PORAVANCE1` int(3) default NULL,
`AGORA2_604_FECHAVANCE1` int(3) default NULL,
`AGORA2_604_DEADLINE` date default NULL,
`AGORA2_604_FECHAFINAL` date default NULL,
`AGORA2_605_PORAVANCE1` int(3) default NULL,
`AGORA2_605_FECHAAVANCE1` date default NULL,
`AGORA2_605_FINALDISENO` date default NULL,
`AGORA2_605_FECHAFINAL` date default NULL,
`AGORA2_605_PORAVANCE1AN` int(3) default NULL,
`AGORA2_605_FECHAAVANCE1AN` date default NULL,
`AGORA2_605_DEADLINE` date default NULL,
`AGORA2_605_FECHAFINALAN` date default NULL,
`AGORA3_SECCION` varchar(255) default NULL,
`AGORA3_SUBSECCION` varchar(255) default NULL,
`AGORA3_ARTICULO` blob,
`AGORA3_AUTOR` blob,
`AGORA3_601_FECHAASIGNACION` date default NULL,
`AGORA3_601_FECHA1ERENTREGA` date default NULL,
`AGORA3_601_FECHARETRO` date default NULL,
`AGORA3_601_FECHAFINAL` date default NULL,
`AGORA3_604_NUMEROPANTALLAS` int(4) default NULL,
`AGORA3_604_PORAVANCE2` int(3) default NULL,
`AGORA3_604_PORAVANCE3` int(3) default NULL,
`AGORA3_604_FINALED` varchar(100) default NULL,
`AGORA3_604_PORAVANCE1` int(3) default NULL,
`AGORA3_604_FECHAVANCE1` int(3) default NULL,
`AGORA3_604_DEADLINE` date default NULL,
`AGORA3_604_FECHAFINAL` date default NULL,
`AGORA3_605_PORAVANCE1` int(3) default NULL,
`AGORA3_605_FECHAAVANCE1` date default NULL,
`AGORA3_605_FINALDISENO` date default NULL,
`AGORA3_605_FECHAFINAL` date default NULL,
`AGORA3_605_PORAVANCE1AN` int(3) default NULL,
`AGORA3_605_FECHAAVANCE1AN` date default NULL,
`AGORA3_605_DEADLINE` date default NULL,
`AGORA3_605_FECHAFINALAN` date default NULL,
`AGORA4_SECCION` varchar(255) default NULL,
`AGORA4_SUBSECCION` varchar(255) default NULL,
`AGORA4_ARTICULO` blob,
`AGORA4_AUTOR` blob,
`AGORA4_601_FECHAASIGNACION` date default NULL,
`AGORA4_601_FECHA1ERENTREGA` date default NULL,
`AGORA4_601_FECHARETRO` date default NULL,
`AGORA4_601_FECHAFINAL` date default NULL,
`AGORA4_604_NUMEROPANTALLAS` int(4) default NULL,
`AGORA4_604_PORAVANCE2` int(3) default NULL,
`AGORA4_604_PORAVANCE3` int(3) default NULL,
`AGORA4_604_FINALED` varchar(100) default NULL,
`AGORA4_604_PORAVANCE1` int(3) default NULL,
`AGORA4_604_FECHAVANCE1` int(3) default NULL,
`AGORA4_604_DEADLINE` date default NULL,
`AGORA4_604_FECHAFINAL` date default NULL,
`AGORA4_605_PORAVANCE1` int(3) default NULL,
`AGORA4_605_FECHAAVANCE1` date default NULL,
`AGORA4_605_FINALDISENO` date default NULL,
`AGORA4_605_FECHAFINAL` date default NULL,
`AGORA4_605_PORAVANCE1AN` int(3) default NULL,
`AGORA4_605_FECHAAVANCE1AN` date default NULL,
`AGORA4_605_DEADLINE` date default NULL,
`AGORA4_605_FECHAFINALAN` date default NULL,
`VISION1_SECCION` varchar(255) default NULL,
`VISION1_SUBSECCION` varchar(255) default NULL,
`VISION1_ARTICULO` blob,
`VISION1_AUTOR` blob,
`VISION1_601_FECHAASIGNACION` date default NULL,
`VISION1_601_FECHA1ERENTREGA` date default NULL,
`VISION1_601_FECHARETRO` date default NULL,
`VISION1_601_FECHAFINAL` date default NULL,
`VISION1_604_NUMEROPANTALLAS` int(4) default NULL,
`VISION1_604_PORAVANCE2` int(3) default NULL,
`VISION1_604_PORAVANCE3` int(3) default NULL,
`VISION1_604_FINALED` varchar(100) default NULL,
`VISION1_604_PORAVANCE1` int(3) default NULL,
`VISION1_604_FECHAVANCE1` int(3) default NULL,
`VISION1_604_DEADLINE` date default NULL,
`VISION1_604_FECHAFINAL` date default NULL,
`VISION1_605_PORAVANCE1` int(3) default NULL,
`VISION1_605_FECHAAVANCE1` date default NULL,
`VISION1_605_FINALDISENO` date default NULL,
`VISION1_605_FECHAFINAL` date default NULL,
`VISION1_605_PORAVANCE1AN` int(3) default NULL,
`VISION1_605_FECHAAVANCE1AN` date default NULL,
`VISION1_605_DEADLINE` date default NULL,
`VISION1_605_FECHAFINALAN` date default NULL,
`VISION2_SECCION` varchar(255) default NULL,
`VISION2_SUBSECCION` varchar(255) default NULL,
`VISION2_ARTICULO` blob,
`VISION2_AUTOR` blob,
`VISION2_601_FECHAASIGNACION` date default NULL,
`VISION2_601_FECHA1ERENTREGA` date default NULL,
`VISION2_601_FECHARETRO` date default NULL,
`VISION2_601_FECHAFINAL` date default NULL,
`VISION2_604_NUMEROPANTALLAS` int(4) default NULL,
`VISION2_604_PORAVANCE2` int(3) default NULL,
`VISION2_604_PORAVANCE3` int(3) default NULL,
`VISION2_604_FINALED` varchar(100) default NULL,
`VISION2_604_PORAVANCE1` int(3) default NULL,
`VISION2_604_FECHAVANCE1` int(3) default NULL,
`VISION2_604_DEADLINE` date default NULL,
`VISION2_604_FECHAFINAL` date default NULL,
`VISION2_605_PORAVANCE1` int(3) default NULL,
`VISION2_605_FECHAAVANCE1` date default NULL,
`VISION2_605_FINALDISENO` date default NULL,
`VISION2_605_FECHAFINAL` date default NULL,
`VISION2_605_PORAVANCE1AN` int(3) default NULL,
`VISION2_605_FECHAAVANCE1AN` date default NULL,
`VISION2_605_DEADLINE` date default NULL,
`VISION2_605_FECHAFINALAN` date default NULL,
`VISION3_SECCION` varchar(255) default NULL,
`VISION3_SUBSECCION` varchar(255) default NULL,
`VISION3_ARTICULO` blob,
`VISION3_AUTOR` blob,
`VISION3_601_FECHAASIGNACION` date default NULL,
`VISION3_601_FECHA1ERENTREGA` date default NULL,
`VISION3_601_FECHARETRO` date default NULL,
`VISION3_601_FECHAFINAL` date default NULL,
`VISION3_604_NUMEROPANTALLAS` int(4) default NULL,
`VISION3_604_PORAVANCE2` int(3) default NULL,
`VISION3_604_PORAVANCE3` int(3) default NULL,
`VISION3_604_FINALED` varchar(100) default NULL,
`VISION3_604_PORAVANCE1` int(3) default NULL,
`VISION3_604_FECHAVANCE1` int(3) default NULL,
`VISION3_604_DEADLINE` date default NULL,
`VISION3_604_FECHAFINAL` date default NULL,
`VISION3_605_PORAVANCE1` int(3) default NULL,
`VISION3_605_FECHAAVANCE1` date default NULL,
`VISION3_605_FINALDISENO` date default NULL,
`VISION3_605_FECHAFINAL` date default NULL,
`VISION3_605_PORAVANCE1AN` int(3) default NULL,
`VISION3_605_FECHAAVANCE1AN` date default NULL,
`VISION3_605_DEADLINE` date default NULL,
`VISION3_605_FECHAFINALAN` date default NULL,
`VISION4_SECCION` varchar(255) default NULL,
`VISION4_SUBSECCION` varchar(255) default NULL,
`VISION4_ARTICULO` blob,
`VISION4_AUTOR` blob,
`VISION4_601_FECHAASIGNACION` date default NULL,
`VISION4_601_FECHA1ERENTREGA` date default NULL,
`VISION4_601_FECHARETRO` date default NULL,
`VISION4_601_FECHAFINAL` date default NULL,
`VISION4_604_NUMEROPANTALLAS` int(4) default NULL,
`VISION4_604_PORAVANCE2` int(3) default NULL,
`VISION4_604_PORAVANCE3` int(3) default NULL,
`VISION4_604_FINALED` varchar(100) default NULL,
`VISION4_604_PORAVANCE1` int(3) default NULL,
`VISION4_604_FECHAVANCE1` int(3) default NULL,
`VISION4_604_DEADLINE` date default NULL,
`VISION4_604_FECHAFINAL` date default NULL,
`VISION4_605_PORAVANCE1` int(3) default NULL,
`VISION4_605_FECHAAVANCE1` date default NULL,
`VISION4_605_FINALDISENO` date default NULL,
`VISION4_605_FECHAFINAL` date default NULL,
`VISION4_605_PORAVANCE1AN` int(3) default NULL,
`VISION4_605_FECHAAVANCE1AN` date default NULL,
`VISION4_605_DEADLINE` date default NULL,
`VISION4_605_FECHAFINALAN` date default NULL,
`ANDROM1_SECCION` varchar(255) default NULL,
`ANDROM1_SUBSECCION` varchar(255) default NULL,
`ANDROM1_ARTICULO` blob,
`ANDROM1_AUTOR` blob,
`ANDROM1_601_FECHAASIGNACION` date default NULL,
`ANDROM1_601_FECHA1ERENTREGA` date default NULL,
`ANDROM1_601_FECHARETRO` date default NULL,
`ANDROM1_601_FECHAFINAL` date default NULL,
`ANDROM1_604_NUMEROPANTALLAS` int(4) default NULL,
`ANDROM1_604_PORAVANCE2` int(3) default NULL,
`ANDROM1_604_PORAVANCE3` int(3) default NULL,
`ANDROM1_604_FINALED` varchar(100) default NULL,
`ANDROM1_604_PORAVANCE1` int(3) default NULL,
`ANDROM1_604_FECHAVANCE1` int(3) default NULL,
`ANDROM1_604_DEADLINE` date default NULL,
`ANDROM1_604_FECHAFINAL` date default NULL,
`ANDROM1_605_PORAVANCE1` int(3) default NULL,
`ANDROM1_605_FECHAAVANCE1` date default NULL,
`ANDROM1_605_FINALDISENO` date default NULL,
`ANDROM1_605_FECHAFINAL` date default NULL,
`ANDROM1_605_PORAVANCE1AN` int(3) default NULL,
`ANDROM1_605_FECHAAVANCE1AN` date default NULL,
`ANDROM1_605_DEADLINE` date default NULL,
`ANDROM1_605_FECHAFINALAN` date default NULL,
`ANDROM2_SECCION` varchar(255) default NULL,
`ANDROM2_SUBSECCION` varchar(255) default NULL,
`ANDROM2_ARTICULO` blob,
`ANDROM2_AUTOR` blob,
`ANDROM2_601_FECHAASIGNACION` date default NULL,
`ANDROM2_601_FECHA1ERENTREGA` date default NULL,
`ANDROM2_601_FECHARETRO` date default NULL,
`ANDROM2_601_FECHAFINAL` date default NULL,
`ANDROM2_604_NUMEROPANTALLAS` int(4) default NULL,
`ANDROM2_604_PORAVANCE2` int(3) default NULL,
`ANDROM2_604_PORAVANCE3` int(3) default NULL,
`ANDROM2_604_FINALED` varchar(100) default NULL,
`ANDROM2_604_PORAVANCE1` int(3) default NULL,
`ANDROM2_604_FECHAVANCE1` int(3) default NULL,
`ANDROM2_604_DEADLINE` date default NULL,
`ANDROM2_604_FECHAFINAL` date default NULL,
`ANDROM2_605_PORAVANCE1` int(3) default NULL,
`ANDROM2_605_FECHAAVANCE1` date default NULL,
`ANDROM2_605_FINALDISENO` date default NULL,
`ANDROM2_605_FECHAFINAL` date default NULL,
`ANDROM2_605_PORAVANCE1AN` int(3) default NULL,
`ANDROM2_605_FECHAAVANCE1AN` date default NULL,
`ANDROM2_605_DEADLINE` date default NULL,
`ANDROM2_605_FECHAFINALAN` date default NULL,
`ANDROM3_SECCION` varchar(255) default NULL,
`ANDROM3_SUBSECCION` varchar(255) default NULL,
`ANDROM3_ARTICULO` blob,
`ANDROM3_AUTOR` blob,
`ANDROM3_601_FECHAASIGNACION` date default NULL,
`ANDROM3_601_FECHA1ERENTREGA` date default NULL,
`ANDROM3_601_FECHARETRO` date default NULL,
`ANDROM3_601_FECHAFINAL` date default NULL,
`ANDROM3_604_NUMEROPANTALLAS` int(4) default NULL,
`ANDROM3_604_PORAVANCE2` int(3) default NULL,
`ANDROM3_604_PORAVANCE3` int(3) default NULL,
`ANDROM3_604_FINALED` varchar(100) default NULL,
`ANDROM3_604_PORAVANCE1` int(3) default NULL,
`ANDROM3_604_FECHAVANCE1` int(3) default NULL,
`ANDROM3_604_DEADLINE` date default NULL,
`ANDROM3_604_FECHAFINAL` date default NULL,
`ANDROM3_605_PORAVANCE1` int(3) default NULL,
`ANDROM3_605_FECHAAVANCE1` date default NULL,
`ANDROM3_605_FINALDISENO` date default NULL,
`ANDROM3_605_FECHAFINAL` date default NULL,
`ANDROM3_605_PORAVANCE1AN` int(3) default NULL,
`ANDROM3_605_FECHAAVANCE1AN` date default NULL,
`ANDROM3_605_DEADLINE` date default NULL,
`ANDROM3_605_FECHAFINALAN` date default NULL,
`ANDROM4_SECCION` varchar(255) default NULL,
`ANDROM4_SUBSECCION` varchar(255) default NULL,
`ANDROM4_ARTICULO` blob,
`ANDROM4_AUTOR` blob,
`ANDROM4_601_FECHAASIGNACION` date default NULL,
`ANDROM4_601_FECHA1ERENTREGA` date default NULL,
`ANDROM4_601_FECHARETRO` date default NULL,
`ANDROM4_601_FECHAFINAL` date default NULL,
`ANDROM4_604_NUMEROPANTALLAS` int(4) default NULL,
`ANDROM4_604_PORAVANCE2` int(3) default NULL,
`ANDROM4_604_PORAVANCE3` int(3) default NULL,
`ANDROM4_604_FINALED` varchar(100) default NULL,
`ANDROM4_604_PORAVANCE1` int(3) default NULL,
`ANDROM4_604_FECHAVANCE1` int(3) default NULL,
`ANDROM4_604_DEADLINE` date default NULL,
`ANDROM4_604_FECHAFINAL` date default NULL,
`ANDROM4_605_PORAVANCE1` int(3) default NULL,
`ANDROM4_605_FECHAAVANCE1` date default NULL,
`ANDROM4_605_FINALDISENO` date default NULL,
`ANDROM4_605_FECHAFINAL` date default NULL,
`ANDROM4_605_PORAVANCE1AN` int(3) default NULL,
`ANDROM4_605_FECHAAVANCE1AN` date default NULL,
`ANDROM4_605_DEADLINE` date default NULL,
`ANDROM4_605_FECHAFINALAN` date default NULL,
`EQUIL1_SECCION` varchar(255) default NULL,
`EQUIL1_SUBSECCION` varchar(255) default NULL,
`EQUIL1_ARTICULO` blob,
`EQUIL1_AUTOR` blob,
`EQUIL1_601_FECHAASIGNACION` date default NULL,
`EQUIL1_601_FECHA1ERENTREGA` date default NULL,
`EQUIL1_601_FECHARETRO` date default NULL,
`EQUIL1_601_FECHAFINAL` date default NULL,
`EQUIL1_604_NUMEROPANTALLAS` int(4) default NULL,
`EQUIL1_604_PORAVANCE2` int(3) default NULL,
`EQUIL1_604_PORAVANCE3` int(3) default NULL,
`EQUIL1_604_FINALED` varchar(100) default NULL,
`EQUIL1_604_PORAVANCE1` int(3) default NULL,
`EQUIL1_604_FECHAVANCE1` int(3) default NULL,
`EQUIL1_604_DEADLINE` date default NULL,
`EQUIL1_604_FECHAFINAL` date default NULL,
`EQUIL1_605_PORAVANCE1` int(3) default NULL,
`EQUIL1_605_FECHAAVANCE1` date default NULL,
`EQUIL1_605_FINALDISENO` date default NULL,
`EQUIL1_605_FECHAFINAL` date default NULL,
`EQUIL1_605_PORAVANCE1AN` int(3) default NULL,
`EQUIL1_605_FECHAAVANCE1AN` date default NULL,
`EQUIL1_605_DEADLINE` date default NULL,
`EQUIL1_605_FECHAFINALAN` date default NULL,
`EQUIL2_SECCION` varchar(255) default NULL,
`EQUIL2_SUBSECCION` varchar(255) default NULL,
`EQUIL2_ARTICULO` blob,
`EQUIL2_AUTOR` blob,
`EQUIL2_601_FECHAASIGNACION` date default NULL,
`EQUIL2_601_FECHA1ERENTREGA` date default NULL,
`EQUIL2_601_FECHARETRO` date default NULL,
`EQUIL2_601_FECHAFINAL` date default NULL,
`EQUIL2_604_NUMEROPANTALLAS` int(4) default NULL,
`EQUIL2_604_PORAVANCE2` int(3) default NULL,
`EQUIL2_604_PORAVANCE3` int(3) default NULL,
`EQUIL2_604_FINALED` varchar(100) default NULL,
`EQUIL2_604_PORAVANCE1` int(3) default NULL,
`EQUIL2_604_FECHAVANCE1` int(3) default NULL,
`EQUIL2_604_DEADLINE` date default NULL,
`EQUIL2_604_FECHAFINAL` date default NULL,
`EQUIL2_605_PORAVANCE1` int(3) default NULL,
`EQUIL2_605_FECHAAVANCE1` date default NULL,
`EQUIL2_605_FINALDISENO` date default NULL,
`EQUIL2_605_FECHAFINAL` date default NULL,
`EQUIL2_605_PORAVANCE1AN` int(3) default NULL,
`EQUIL2_605_FECHAAVANCE1AN` date default NULL,
`EQUIL2_605_DEADLINE` date default NULL,
`EQUIL2_605_FECHAFINALAN` date default NULL,
`EQUIL3_SECCION` varchar(255) default NULL,
`EQUIL3_SUBSECCION` varchar(255) default NULL,
`EQUIL3_ARTICULO` blob,
`EQUIL3_AUTOR` blob,
`EQUIL3_601_FECHAASIGNACION` date default NULL,
`EQUIL3_601_FECHA1ERENTREGA` date default NULL,
`EQUIL3_601_FECHARETRO` date default NULL,
`EQUIL3_601_FECHAFINAL` date default NULL,
`EQUIL3_604_NUMEROPANTALLAS` int(4) default NULL,
`EQUIL3_604_PORAVANCE2` int(3) default NULL,
`EQUIL3_604_PORAVANCE3` int(3) default NULL,
`EQUIL3_604_FINALED` varchar(100) default NULL,
`EQUIL3_604_PORAVANCE1` int(3) default NULL,
`EQUIL3_604_FECHAVANCE1` int(3) default NULL,
`EQUIL3_604_DEADLINE` date default NULL,
`EQUIL3_604_FECHAFINAL` date default NULL,
`EQUIL3_605_PORAVANCE1` int(3) default NULL,
`EQUIL3_605_FECHAAVANCE1` date default NULL,
`EQUIL3_605_FINALDISENO` date default NULL,
`EQUIL3_605_FECHAFINAL` date default NULL,
`EQUIL3_605_PORAVANCE1AN` int(3) default NULL,
`EQUIL3_605_FECHAAVANCE1AN` date default NULL,
`EQUIL3_605_DEADLINE` date default NULL,
`EQUIL3_605_FECHAFINALAN` date default NULL,
`EQUIL4_SECCION` varchar(255) default NULL,
`EQUIL4_SUBSECCION` varchar(255) default NULL,
`EQUIL4_ARTICULO` blob,
`EQUIL4_AUTOR` blob,
`EQUIL4_601_FECHAASIGNACION` date default NULL,
`EQUIL4_601_FECHA1ERENTREGA` date default NULL,
`EQUIL4_601_FECHARETRO` date default NULL,
`EQUIL4_601_FECHAFINAL` date default NULL,
`EQUIL4_604_NUMEROPANTALLAS` int(4) default NULL,
`EQUIL4_604_PORAVANCE2` int(3) default NULL,
`EQUIL4_604_PORAVANCE3` int(3) default NULL,
`EQUIL4_604_FINALED` varchar(100) default NULL,
`EQUIL4_604_PORAVANCE1` int(3) default NULL,
`EQUIL4_604_FECHAVANCE1` int(3) default NULL,
`EQUIL4_604_DEADLINE` date default NULL,
`EQUIL4_604_FECHAFINAL` date default NULL,
`EQUIL4_605_PORAVANCE1` int(3) default NULL,
`EQUIL4_605_FECHAAVANCE1` date default NULL,
`EQUIL4_605_FINALDISENO` date default NULL,
`EQUIL4_605_FECHAFINAL` date default NULL,
`EQUIL4_605_PORAVANCE1AN` int(3) default NULL,
`EQUIL4_605_FECHAAVANCE1AN` date default NULL,
`EQUIL4_605_DEADLINE` date default NULL,
`EQUIL4_605_FECHAFINALAN` date default NULL,
`POSTRE1_SECCION` varchar(255) default NULL,
`POSTRE1_SUBSECCION` varchar(255) default NULL,
`POSTRE1_ARTICULO` blob,
`POSTRE1_AUTOR` blob,
`POSTRE1_601_FECHAASIGNACION` date default NULL,
`POSTRE1_601_FECHA1ERENTREGA` date default NULL,
`POSTRE1_601_FECHARETRO` date default NULL,
`POSTRE1_601_FECHAFINAL` date default NULL,
`POSTRE1_604_NUMEROPANTALLAS` int(4) default NULL,
`POSTRE1_604_PORAVANCE2` int(3) default NULL,
`POSTRE1_604_PORAVANCE3` int(3) default NULL,
`POSTRE1_604_FINALED` varchar(100) default NULL,
`POSTRE1_604_PORAVANCE1` int(3) default NULL,
`POSTRE1_604_FECHAVANCE1` int(3) default NULL,
`POSTRE1_604_DEADLINE` date default NULL,
`POSTRE1_604_FECHAFINAL` date default NULL,
`POSTRE1_POSTRE1_605_PORAVANCE1` int(3) default NULL,
`POSTRE1_605_FECHAAVANCE1` date default NULL,
`POSTRE1_605_FINALDISENO` date default NULL,
`POSTRE1_605_FECHAFINAL` date default NULL,
`POSTRE1_605_PORAVANCE1AN` int(3) default NULL,
`POSTRE1_605_FECHAAVANCE1AN` date default NULL,
`POSTRE1_605_DEADLINE` date default NULL,
`POSTRE1_605_FECHAFINALAN` date default NULL,
`POSTRE2_SECCION` varchar(255) default NULL,
`POSTRE2_SUBSECCION` varchar(255) default NULL,
`POSTRE2_ARTICULO` blob,
`POSTRE2_AUTOR` blob,
`POSTRE2_601_FECHAASIGNACION` date default NULL,
`POSTRE2_601_FECHA1ERENTREGA` date default NULL,
`POSTRE2_601_FECHARETRO` date default NULL,
`POSTRE2_601_FECHAFINAL` date default NULL,
`POSTRE2_604_NUMEROPANTALLAS` int(4) default NULL,
`POSTRE2_604_PORAVANCE2` int(3) default NULL,
`POSTRE2_604_PORAVANCE3` int(3) default NULL,
`POSTRE2_604_FINALED` varchar(100) default NULL,
`POSTRE2_604_PORAVANCE1` int(3) default NULL,
`POSTRE2_604_FECHAVANCE1` int(3) default NULL,
`POSTRE2_604_DEADLINE` date default NULL,
`POSTRE2_604_FECHAFINAL` date default NULL,
`POSTRE2_POSTRE1_605_PORAVANCE1` int(3) default NULL,
`POSTRE2_605_FECHAAVANCE1` date default NULL,
`POSTRE2_605_FINALDISENO` date default NULL,
`POSTRE2_605_FECHAFINAL` date default NULL,
`POSTRE2_605_PORAVANCE1AN` int(3) default NULL,
`POSTRE2_605_FECHAAVANCE1AN` date default NULL,
`POSTRE2_605_DEADLINE` date default NULL,
`POSTRE2_605_FECHAFINALAN` date default NULL,
`POSTRE3_SECCION` varchar(255) default NULL,
`POSTRE3_SUBSECCION` varchar(255) default NULL,
`POSTRE3_ARTICULO` blob,
`POSTRE3_AUTOR` blob,
`POSTRE3_601_FECHAASIGNACION` date default NULL,
`POSTRE3_601_FECHA1ERENTREGA` date default NULL,
`POSTRE3_601_FECHARETRO` date default NULL,
`POSTRE3_601_FECHAFINAL` date default NULL,
`POSTRE3_604_NUMEROPANTALLAS` int(4) default NULL,
`POSTRE3_604_PORAVANCE2` int(3) default NULL,
`POSTRE3_604_PORAVANCE3` int(3) default NULL,
`POSTRE3_604_FINALED` varchar(100) default NULL,
`POSTRE3_604_PORAVANCE1` int(3) default NULL,
`POSTRE3_604_FECHAVANCE1` int(3) default NULL,
`POSTRE3_604_DEADLINE` date default NULL,
`POSTRE3_604_FECHAFINAL` date default NULL,
`POSTRE3_POSTRE1_605_PORAVANCE1` int(3) default NULL,
`POSTRE3_605_FECHAAVANCE1` date default NULL,
`POSTRE3_605_FINALDISENO` date default NULL,
`POSTRE3_605_FECHAFINAL` date default NULL,
`POSTRE3_605_PORAVANCE1AN` int(3) default NULL,
`POSTRE3_605_FECHAAVANCE1AN` date default NULL,
`POSTRE3_605_DEADLINE` date default NULL,
`POSTRE3_605_FECHAFINALAN` date default NULL,
`POSTRE4_SECCION` varchar(255) default NULL,
`POSTRE4_SUBSECCION` varchar(255) default NULL,
`POSTRE4_ARTICULO` blob,
`POSTRE4_AUTOR` blob,
`POSTRE4_601_FECHAASIGNACION` date default NULL,
`POSTRE4_601_FECHA1ERENTREGA` date default NULL,
`POSTRE4_601_FECHARETRO` date default NULL,
`POSTRE4_601_FECHAFINAL` date default NULL,
`POSTRE4_604_NUMEROPANTALLAS` int(4) default NULL,
`POSTRE4_604_PORAVANCE2` int(3) default NULL,
`POSTRE4_604_PORAVANCE3` int(3) default NULL,
`POSTRE4_604_FINALED` varchar(100) default NULL,
`POSTRE4_604_PORAVANCE1` int(3) default NULL,
`POSTRE4_604_FECHAVANCE1` int(3) default NULL,
`POSTRE4_604_DEADLINE` date default NULL,
`POSTRE4_604_FECHAFINAL` date default NULL,
`POSTRE4_POSTRE1_605_PORAVANCE1` int(3) default NULL,
`POSTRE4_605_FECHAAVANCE1` date default NULL,
`POSTRE4_605_FINALDISENO` date default NULL,
`POSTRE4_605_FECHAFINAL` date default NULL,
`POSTRE4_605_PORAVANCE1AN` int(3) default NULL,
`POSTRE4_605_FECHAAVANCE1AN` date default NULL,
`POSTRE4_605_DEADLINE` date default NULL,
`POSTRE4_605_FECHAFINALAN` date default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
maybe that would help so someone can help me, please, im kind of desperate