Subversion Repositories computer_asset_manager_v2

Rev

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

Rev 63 Rev 64
Line 357... Line 357...
357 
select owner.name owner, location.name location from owner join owner_location using (owner_id) join location using (location_id);
 357 
select owner.name owner, location.name location from owner join owner_location using (owner_id) join location using (location_id);
358 
select * from view_device_location_owner_type limit 10;
 358 
select * from view_device_location_owner_type limit 10;
359 
 
 359 
 
360 
*/
 360 
*/
361 
 
 361 
 
362 
/* Set a UUID for everything that doesn't have one */
 - 
 
363 
update owner set uuid = uuid() where uuid is null;
 - 
 
364 
update location set uuid = uuid() where uuid is null;
 - 
 
365 
update device set uuid = uuid() where uuid is null;
 -