Subversion Repositories computer_asset_manager_v2

Rev

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

Rev 73 Rev 76
Line 67... Line 67...
67 
      attribute_value.removed
 67 
      attribute_value.removed
68 
   from
 68 
   from
69 
      attribute_value
 69 
      attribute_value
70 
      join attribute using (attribute_id)
 70 
      join attribute using (attribute_id)
71 
      join attribute_category using (attribute_category_id)
 71 
      join attribute_category using (attribute_category_id)
72 
      join owner on ( attribute_value._base_class_id = owner.owner_id)
 72 
      join owner on (  attribute_value.entity_id = owner.owner_id)
73 
   where
 73 
   where
74 
      attribute_value._base_class_id in (select _base_class_id from _base_class where class_name = 'Owner');
 74 
      attribute_value._base_class_id in (select _base_class_id from _base_class where class_name = 'Owner');
75 
 
 75 
 
76 
drop view if exists view_attribute_location;
 76 
drop view if exists view_attribute_location;
77 
create view view_attribute_location as
 77 
create view view_attribute_location as
Line 84... Line 84...
84 
      attribute_value.removed
 84 
      attribute_value.removed
85 
   from
 85 
   from
86 
      attribute_value
 86 
      attribute_value
87 
      join attribute using (attribute_id)
 87 
      join attribute using (attribute_id)
88 
      join attribute_category using (attribute_category_id)
 88 
      join attribute_category using (attribute_category_id)
89 
      join location on ( attribute_value._base_class_id = location.location_id)
 89 
      join location on (  attribute_value.entity_id = location.location_id)
90 
   where
 90 
   where
91 
      attribute_value._base_class_id in (select _base_class_id from _base_class where class_name = 'Location');
 91 
      attribute_value._base_class_id in (select _base_class_id from _base_class where class_name = 'Location');
92 
 
 92 
 
93 
drop view if exists view_attribute_device;
 93 
drop view if exists view_attribute_device;
94 
create view view_attribute_device as
 94 
create view view_attribute_device as
Line 101... Line 101...
101 
      attribute_value.removed
 101 
      attribute_value.removed
102 
   from
 102 
   from
103 
      attribute_value
 103 
      attribute_value
104 
      join attribute using (attribute_id)
 104 
      join attribute using (attribute_id)
105 
      join attribute_category using (attribute_category_id)
 105 
      join attribute_category using (attribute_category_id)
106 
      join device on ( attribute_value._base_class_id = device.device_id)
 106 
      join device on ( attribute_value.entity_id = device.device_id)
107 
   where
 107 
   where
108 
      attribute_value._base_class_id in (select _base_class_id from _base_class where class_name = 'Device');
 108 
      attribute_value._base_class_id in (select _base_class_id from _base_class where class_name = 'Device');
109 
 
 109 
 
110 
 
 110