16 lines
597 B
SQL
16 lines
597 B
SQL
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
|
SQL SECURITY DEFINER
|
|
VIEW `vn2008`.`edi_bucket`
|
|
AS SELECT cast(
|
|
`edi`.`bucket`.`bucket_id` AS char CHARSET utf8mb3
|
|
) COLLATE utf8mb3_general_ci AS `bucket_id`,
|
|
`edi`.`bucket`.`bucket_type_id` AS `bucket_type_id`,
|
|
`edi`.`bucket`.`description` AS `description`,
|
|
`edi`.`bucket`.`x_size` AS `x_size`,
|
|
`edi`.`bucket`.`y_size` AS `y_size`,
|
|
`edi`.`bucket`.`z_size` AS `z_size`,
|
|
`edi`.`bucket`.`entry_date` AS `entry_date`,
|
|
`edi`.`bucket`.`expiry_date` AS `expiry_date`,
|
|
`edi`.`bucket`.`change_date_time` AS `change_date_time`
|
|
FROM `edi`.`bucket`
|