view_shop_item_generator_rule

create view view_shop_item_generator_rule as
  select shop_item_generator_rule.identifier,
         shop_category.caption as shop_category,
         shop_item.description as shop_item,
         currency.alpha_code as currency,
         shop_item_generator_rule.price,
         shop_item_generator_rule.comment,
         shop_item_generator_rule.date_of_creation,
         shop_item_generator_rule.date_of_last_edit,
         shop_item_generator_rule.users
    from shop_item_generator_rule, shop_category, shop_item, currency
   where shop_item_generator_rule.shop_item = shop_item.identifier
     and shop_item.category = shop_category.identifier
     and shop_item_generator_rule.currency = currency.identifier
   order by shop_item_generator_rule.date_of_creation;

• currency
• shop_category
• shop_item
• shop_item_generator_rule

Version 2.26

Version 2.34

= Version 2.26 =

create view view_shop_item_generator_rule as
  select shop_item_generator_rule.identifier,
         shop_category.caption as shop_category,
         shop_item.description as shop_item,
         currency.alpha_code as currency,
         shop_item_generator_rule.price,
         shop_item_generator_rule.comment,
         shop_item_generator_rule.date_of_creation,
         shop_item_generator_rule.date_of_last_edit,
         shop_item_generator_rule.users
    from shop_item_generator_rule, shop_category, shop_item, currency
   where shop_item_generator_rule.shop_item = shop_item.identifier
     and shop_item.category = shop_category.identifier
     and shop_item_generator_rule.currency = currency.identifier
   order by shop_item_generator_rule.date_of_creation;

= Version 2.34 =

DROP VIEW view_shop_item_generator_rule;