10 lines
319 B
SQL
10 lines
319 B
SQL
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
|
SQL SECURITY DEFINER
|
|
VIEW `vn2008`.`payroll_conceptos`
|
|
AS SELECT `pc`.`id` AS `conceptoid`,
|
|
`pc`.`name` AS `concepto`,
|
|
`pc`.`isSalaryAgreed` AS `isSalaryAgreed`,
|
|
`pc`.`isVariable` AS `isVariable`,
|
|
`pc`.`isException` AS `isException`
|
|
FROM `vn`.`payrollComponent` `pc`
|