8 lines
238 B
MySQL
8 lines
238 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Tickets_state`
|
||
|
|
AS SELECT `t`.`ticketFk` AS `Id_Ticket`,
|
||
|
|
`t`.`ticketTrackingFk` AS `inter_id`,
|
||
|
|
`t`.`name` AS `state_name`
|
||
|
|
FROM `vn`.`ticketLastState` `t`
|