2024-08-20 08:06:10 +00:00
|
|
|
CREATE OR REPLACE DEFINER=`vn`@`localhost`
|
2024-01-15 11:31:03 +00:00
|
|
|
SQL SECURITY DEFINER
|
|
|
|
|
VIEW `vn`.`firstTicketShipped`
|
|
|
|
|
AS SELECT min(`vn`.`ticket`.`shipped`) AS `shipped`,
|
|
|
|
|
`vn`.`ticket`.`clientFk` AS `clientFk`
|
|
|
|
|
FROM `vn`.`ticket`
|
|
|
|
|
WHERE `vn`.`ticket`.`shipped` > '2001-01-01'
|
|
|
|
|
GROUP BY `vn`.`ticket`.`clientFk`
|
