CREATE TRIGGER au_items 
    AFTER UPDATE ON items
    FOR EACH ROW 
INSERT INTO items_audit
(item_id, item_class, item_group, item_category, item_sub_category, tax_group_id,
item_packaging_uom, pack_size, indv_item_qty_uom, indv_item_qty, manufacture_id, 
item_name, item_code, item_description, indv_dimension_type, indv_dimension_uom,
indv_item_length, indv_item_width, indv_item_height, is_active, item_photo, created_at)
Value( old.id, old.item_class, old.item_group, old.item_category, old.item_sub_category, old.tax_group_id,
old.item_packaging_uom, old.pack_size, old.indv_item_qty_uom, old.indv_item_qty, old.manufacture_id, 
old.item_name, old.item_code, old.item_description, old.indv_dimension_type, old.indv_dimension_uom,
old.indv_item_length, old.indv_item_width, old.indv_item_height, old.is_active, old.item_photo, CURRENT_TIMESTAMP);
