Subversion Repositories computer_asset_manager_v2

Rev

Rev 66 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 66 Rev 67
Line 370... Line 370...
370 
      view_device.parent_id,
 370 
      view_device.parent_id,
371 
      view_device.parent,
 371 
      view_device.parent,
372 
      view_device.device_types
 372 
      view_device.device_types
373 
   from
 373 
   from
374 
      view_owner_device
 374 
      view_owner_device
375 
      join view_location_device using (device_id)
 375 
      left outer join view_location_device using (device_id)
376 
      join view_device using (device_id)
 376 
      left outer join view_device using (device_id)
377 
      join view_owner_location using (location_id);
 377 
      left outer join view_owner_location using (location_id);
378 
 
 378 
 
379 
 
 379 
 
380 
insert into _system ( key_value, group_name, key_name ) values ( '0.1','database','version' )
380 
insert into _system ( key_value, group_name, key_name ) values ( '0.1','database','version' )
381 
   on duplicate key update key_value = '0.1';
 381 
   on duplicate key update key_value = '0.1';
382 
insert into _system ( key_value, group_name, key_name ) values ( '', 'program', 'motd' );
 382 
insert into _system ( key_value, group_name, key_name ) values ( '', 'program', 'motd' );