INSERT INTO units(code,name) VALUES ('M','Meter'),('SQM','SqM'),('EA','Each'),('HR','Hour'),('DAY','Day'),('KM','Km') ON CONFLICT(code) DO NOTHING;
INSERT INTO vendor_categories(name,description) VALUES ('General Contractor','General procurement and contracting vendors'),('Civil Works','Civil works and construction vendors'),('Electrical','Electrical supply and installation vendors'),('Telecom','Telecom and network vendors') ON CONFLICT(name) DO NOTHING;