salix/db/routines/hedera/views/order_component.sql

8 lines
241 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `hedera`.`order_component`
AS SELECT `t`.`rowFk` AS `order_row_id`,
`t`.`componentFk` AS `component_id`,
`t`.`price` AS `price`
FROM `hedera`.`orderRowComponent` `t`