|
1
|
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`scrumtools.silogic.fr` SQL SECURITY DEFINER VIEW `cnes-fuse`.`VIEW_HEADERS_BIS` AS select `cnes-fuse`.`HEADERS`.`DATASET` AS `DATASET`,`cnes-fuse`.`HEADERS`.`TARGNAME` AS `TARGNAME`,`cnes-fuse`.`HEADERS`.`RA_TARG` AS `RA_TARG`,`cnes-fuse`.`HEADERS`.`DEC_TARG` AS `DEC_TARG`,`cnes-fuse`.`HEADERS`.`DATEOBS` AS `DATEOBS`,`cnes-fuse`.`HEADERS`.`EXPTIME` AS `EXPTIME`,`cnes-fuse`.`HEADERS`.`APERTURE` AS `APERTURE`,`cnes-fuse`.`HEADERS`.`MODE` AS `MODE`,`cnes-fuse`.`HEADERS`.`EXPOS_NBR` AS `EXPOS_NBR`,`cnes-fuse`.`HEADERS`.`VMAG` AS `VMAG`,`cnes-fuse`.`HEADERS`.`SP_TYPE` AS `SP_TYPE`,`cnes-fuse`.`HEADERS`.`EBV` AS `EBV`,`cnes-fuse`.`HEADERS`.`OBJCLASS` AS `OBJCLASS`,`cnes-fuse`.`HEADERS`.`SRC_TYPE` AS `SRC_TYPE`,`cnes-fuse`.`HEADERS`.`DATEARCHIV` AS `DATEARCHIV`,`cnes-fuse`.`HEADERS`.`DATEPUBLIC` AS `DATEPUBLIC`,`cnes-fuse`.`HEADERS`.`REF` AS `REF`,`cnes-fuse`.`HEADERS`.`Z` AS `Z`,`cnes-fuse`.`HEADERS`.`STARTTIME` AS `STARTTIME`,`cnes-fuse`.`HEADERS`.`ENDTIME` AS `ENDTIME`,`cnes-fuse`.`HEADERS`.`ELAT` AS `ELAT`,`cnes-fuse`.`HEADERS`.`ELONG` AS `ELONG`,`cnes-fuse`.`HEADERS`.`GLAT` AS `GLAT`,`cnes-fuse`.`HEADERS`.`GLONG` AS `GLONG`,`cnes-fuse`.`HEADERS`.`APER_PA` AS `APER_PA`,`cnes-fuse`.`HEADERS`.`HIGH_PROPER_MOTION` AS `HIGH_PROPER_MOTION`,`cnes-fuse`.`HEADERS`.`MOVING_TARGET` AS `MOVING_TARGET`,`cnes-fuse`.`HEADERS`.`PR_INV_L` AS `PR_INV_L`,`cnes-fuse`.`HEADERS`.`PR_INV_F` AS `PR_INV_F`,`cnes-fuse`.`HEADERS`.`LOADEDatIAP` AS `LOADEDatIAP`,`cnes-fuse`.`HEADERS`.`HEALPIXID` AS `HEALPIXID`,`cnes-fuse`.`HEADERS`.`X_POS` AS `X_POS`,`cnes-fuse`.`HEADERS`.`Y_POS` AS `Y_POS`,`cnes-fuse`.`HEADERS`.`Z_POS` AS `Z_POS` from `cnes-fuse`.`HEADERS` where (`cnes-fuse`.`HEADERS`.`DATASET` like 'A%');
|