15 lines
441 B
SQL
15 lines
441 B
SQL
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
|
SQL SECURITY DEFINER
|
|
VIEW `vn2008`.`cl_main`
|
|
AS SELECT `c`.`id` AS `id`,
|
|
`c`.`ticketCreated` AS `Fecha`,
|
|
`c`.`claimStateFk` AS `cl_est_id`,
|
|
`c`.`observation` AS `notas`,
|
|
`c`.`clientFk` AS `Id_Cliente`,
|
|
`c`.`workerFk` AS `Id_Trabajador`,
|
|
`c`.`responsibility` AS `sensib`,
|
|
`c`.`isChargedToMana` AS `mana`,
|
|
`c`.`ticketFk` AS `ticketFk`,
|
|
`c`.`created` AS `odbc_date`
|
|
FROM `vn`.`claim` `c`
|