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