11 lines
317 B
MySQL
11 lines
317 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `bi`.`defaulters`
|
||
|
|
AS SELECT `d`.`clientFk` AS `client`,
|
||
|
|
`d`.`created` AS `date`,
|
||
|
|
`d`.`amount` AS `amount`,
|
||
|
|
`d`.`defaulterSinced` AS `defaulterSince`,
|
||
|
|
`d`.`hasChanged` AS `hasChanged`,
|
||
|
|
`d`.`frozened` AS `frozened`
|
||
|
|
FROM `bs`.`defaulter` `d`
|