dtl1_feed.frm 1.5 KB

12345678910111213141516
  1. TYPE=VIEW
  2. query=select `tmrwatch`.`lpplandtl1`.`ID` AS `ID`,`tmrwatch`.`lpplandtl1`.`PID` AS `PID`,`tmrwatch`.`lpplandtl1`.`FPointID` AS `FPointID`,`tmrwatch`.`lpplandtl1`.`FID` AS `FID`,`tmrwatch`.`lpplandtl1`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl1`.`SORT` AS `SORT`,concat(\'已加:\',`tmrwatch`.`feed`.`FNAME`) AS `Feedname2`,`tmrwatch`.`feed`.`FNAME` AS `FNAME` from (`tmrwatch`.`lpplandtl1` join `tmrwatch`.`feed` on(`tmrwatch`.`lpplandtl1`.`FID` = `tmrwatch`.`feed`.`ID`))
  3. md5=3aef937f21e455c9a641ac89e3e62544
  4. updatable=1
  5. algorithm=0
  6. definer_user=root
  7. definer_host=localhost
  8. suid=1
  9. with_check_option=0
  10. timestamp=2021-12-05 04:06:49
  11. create-version=2
  12. source=select `lpplandtl1`.`ID` AS `ID`,`lpplandtl1`.`PID` AS `PID`,`lpplandtl1`.`FPointID` AS `FPointID`,`lpplandtl1`.`FID` AS `FID`,`lpplandtl1`.`LWEIGHT` AS `LWEIGHT`,`lpplandtl1`.`SORT` AS `SORT`,concat(\'已加:\',`feed`.`FNAME`) AS `Feedname2`,`feed`.`FNAME` AS `FNAME` from (`lpplandtl1` join `feed` on((`lpplandtl1`.`FID` = `feed`.`ID`)))
  13. client_cs_name=utf8
  14. connection_cl_name=utf8_general_ci
  15. view_body_utf8=select `tmrwatch`.`lpplandtl1`.`ID` AS `ID`,`tmrwatch`.`lpplandtl1`.`PID` AS `PID`,`tmrwatch`.`lpplandtl1`.`FPointID` AS `FPointID`,`tmrwatch`.`lpplandtl1`.`FID` AS `FID`,`tmrwatch`.`lpplandtl1`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl1`.`SORT` AS `SORT`,concat(\'已加:\',`tmrwatch`.`feed`.`FNAME`) AS `Feedname2`,`tmrwatch`.`feed`.`FNAME` AS `FNAME` from (`tmrwatch`.`lpplandtl1` join `tmrwatch`.`feed` on(`tmrwatch`.`lpplandtl1`.`FID` = `tmrwatch`.`feed`.`ID`))
  16. mariadb-version=100511