DB::statement('CREATE OR REPLACE VIEW navbar_view AS SELECT `system_categories`.`name` AS `category`, `system_types`.`name` AS `sys_name`, `system_types`.`sys_id`, `system_types`.`parent_id`
17
FROM `system_categories`
18
LEFT JOIN `system_types` ON `system_categories`.`cat_id` = `system_types`.`cat_id` ORDER BY `system_categories`.`cat_id`, `system_types`.`parent_id`, `system_types`.`name`');
19
}
20
21
/**
22
* Reverse the migrations.
23
*
24
* @return void
25
*/
26
public function down()
27
{
28
DB::statement('DROP VIEW IF EXISTS `navbar_view`');
butcherman /
Tech_Bench
