view_filter
CREATE VIEW view_filter AS SELECT FILTER.identifier, manufacturer.name, model, variation, users, date_of_purchase, purchased_new, manufacturer.url, (access_type.value) AS access_rights, serial_number FROM filter_type, FILTER, manufacturer, access_type WHERE filter_type.manufacturer = manufacturer.identifier AND filter_type.identifier = FILTER.type AND FILTER.access_rights = access_type.identifier ORDER BY manufacturer.name, model, variation;
Version 2.5
Still in use
= Version 2.5 =
CREATE VIEW view_filter AS SELECT FILTER.identifier, manufacturer.name, model, variation, users, date_of_purchase, purchased_new, manufacturer.url, (access_type.value) AS access_rights FROM filter_type, FILTER, manufacturer, access_type WHERE filter_type.manufacturer = manufacturer.identifier AND filter_type.identifier = FILTER.type AND FILTER.access_rights = access_type.identifier ORDER BY manufacturer.name, model, variation;
= Version 2.33 =
DROP VIEW view_filter; CREATE VIEW view_filter AS SELECT FILTER.identifier, manufacturer.name, model, variation, users, date_of_purchase, purchased_new, manufacturer.url, (access_type.value) AS access_rights, serial_number FROM filter_type, FILTER, manufacturer, access_type WHERE filter_type.manufacturer = manufacturer.identifier AND filter_type.identifier = FILTER.type AND FILTER.access_rights = access_type.identifier ORDER BY manufacturer.name, model, variation;