salix/db/routines/vn2008/views/reinos.sql

13 lines
339 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`reinos`
AS SELECT `r`.`id` AS `id`,
`r`.`name` AS `reino`,
`r`.`display` AS `display`,
`r`.`color` AS `color`,
`r`.`icon` AS `icon`,
`r`.`merchandise` AS `mercancia`,
`r`.`order` AS `orden`,
`r`.`shortLife` AS `efimero`
FROM `vn`.`itemCategory` `r`