Files
XBid/scripts/import-clients.sql
2026-08-18 12:11:20 +02:00

32 lines
8.6 KiB
SQL

INSERT INTO clients ("id", "companyName", "contactPerson", "email", "phone", "vatNumber", "companyRegNumber", "billingAddress", "createdAt", "updatedAt")
VALUES
(gen_random_uuid()::text, 'Beyond Sound (PTY) LTD', 'Dries Scholtz', 'dries@beyondsound.co.za', '0722216628', '4020265312', NULL, '64A Mount Street, Bryanston, 2021', NOW(), NOW()),
(gen_random_uuid()::text, 'The Mediabox Productions (PTY) LTD', 'Emile Wanneburg', 'emile@mediabox.co.za', '0825223999', '4060261635', '2015/301430/07', 'P.O. Box 2479, Faerie Glen, 0043', NOW(), NOW()),
(gen_random_uuid()::text, 'Red Letter Day Pictures (PTY) LTD', 'Tascha van der Westhuizen', 'production@tascha.co', '0722410928', '4810283889', '2012/209819/07', '3 Nared Road, Jamestown, Cape Town, 7600', NOW(), NOW()),
(gen_random_uuid()::text, 'Flight Centre Travel Group (Pty) Ltd', 'Tracy Porter', 'tracy.porter@flightcentre.co.za', '+27 82 891 4353', '4370159909', '1994/000253/07', 'Block 8 Pendoring Office Park, 299 Pendoring Road, Blackheath, Johannesburg 2195', NOW(), NOW()),
(gen_random_uuid()::text, 'The Irresistible Spice of Meena Rani (PTY) LTD', 'Rani Sitaram', NULL, '0721251629', '4120305984', NULL, '9 Stirling Place, Westville, KZN, 3629', NOW(), NOW()),
(gen_random_uuid()::text, 'Second Circle Films (PTY) LTD', NULL, NULL, NULL, '4370103105', '2020/147485/07', '25 Woodlands Avenue, Irene Woods Estate, Pretoria, 0062', NOW(), NOW()),
(gen_random_uuid()::text, 'Defijn (PTY) LTD', 'Eckardt Kasselman', 'eckardt@defijn.io', '0845478800', '4880291192', '2019/179296/07', '29 Campbell Drive, Knysna, Western Cape, 6571', NOW(), NOW()),
(gen_random_uuid()::text, 'The Schultz Creative (Pty) Ltd', 'Carl Schultz', 'carl@theschultzcreative.com', '071 681 1464', '4680295351', '2016/361413/07', '32 Willow Farm Estate, Willow Farm Rd, Pretoria, 0184', NOW(), NOW()),
(gen_random_uuid()::text, 'Fuge Design', 'Anri Shaw', 'anri@fuge.co.za', NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'SA Filament', 'Anton van der Heever', 'info@safilament.co.za', '0761965684', NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'FORGE IGNITE MEDIA AND ENTERTAINMENT PTY LTD', 'Thandeka Nodada', 'thandeka@forge-me.com', NULL, '4690301785', '2021/943427/07', 'Mesh Club, 21 Keyes Avenue, Rosebank, JHB 2196', NOW(), NOW()),
(gen_random_uuid()::text, 'Festo (PTY) LTD', 'Kershia Beharie', 'kershia.beharie@festo.com', NULL, '4350101004', '1973/003776/07', 'P.O. Box 255, Isando, 1600', NOW(), NOW()),
(gen_random_uuid()::text, 'My Stories (PTY) LTD', 'Cene de Wit', 'Cene07@gmail.com', NULL, NULL, NULL, '15 van Schouuwenburg St, Ermelo, 2350', NOW(), NOW()),
(gen_random_uuid()::text, 'Nthabiseng', 'Nthabiseng', 'postmama01@gmail.com', NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'Content Box Media', 'Stephan Callitz', 'stephan@contentbox.co.za', NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'Toon53', NULL, NULL, NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'The Final Chapter (Pty) Ltd', NULL, NULL, NULL, '4430299539', '2016/182348/07', '35 KwaMakhutha, Amanzimtoti, 4162', NOW(), NOW()),
(gen_random_uuid()::text, 'Mrs Plum', 'Bridget Pickering', 'bridget@bumpfilms.co.za', NULL, NULL, '2021/606637/07', '4 Strandfontein Road, Summerstrand, Gqeberha 6001', NOW(), NOW()),
(gen_random_uuid()::text, 'Ochre', 'Travis Cleevely', 'travis@ochre.co.za', NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'FERTILE GROUND STUDIO', 'ATT: Accounts Dept.', NULL, NULL, NULL, NULL, 'Featherdale Estate, 42 Louis Botha Road, Bonaero Park, Kempton Park, 1622', NOW(), NOW()),
(gen_random_uuid()::text, 'Sulize', 'Sulize', NULL, '0797956163', NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'Happy Co.', 'Jean', 'jean@happyco.tv', NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'Trickery', 'Werner Burger', 'werner@trickery.co.za', NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'Gatehouse', 'Ananda Law', 'ananda@gatehouse.co.za', NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'Oman In Focus LLC', 'Maisa Al Hooti', NULL, NULL, NULL, NULL, 'Office 110, Muscat Residence Building, Muscat, Sultanate of Oman', NOW(), NOW()),
(gen_random_uuid()::text, 'UNGOVERNABLE CARTEL (PTY) LTD', NULL, NULL, NULL, NULL, NULL, '348 Stallion Road Ruimsig, Roodepoort, Gauteng, 1724', NOW(), NOW()),
(gen_random_uuid()::text, 'Dries', NULL, NULL, NULL, NULL, NULL, NULL, NOW(), NOW()),
(gen_random_uuid()::text, 'EbonyLife Group', 'Heidi Uys', 'heidi@ebonylifemedia.com', NULL, NULL, NULL, '10 Engineering Close, Off Idowu Taylor Street, Victoria Island, Lagos, Nigeria', NOW(), NOW())
;