2 -- @description: Add columns itime and mtime and transaction_description for table shops
6 ALTER TABLE shops ADD COLUMN transaction_description TEXT;
7 ALTER TABLE shops ADD COLUMN itime timestamp DEFAULT now();
8 ALTER TABLE shops ADD COLUMN mtime timestamp DEFAULT now();
10 CREATE TRIGGER mtime_shops
11 BEFORE UPDATE ON shops
13 EXECUTE PROCEDURE set_mtime();