github.com/DapperCollectives/CAST/backend@v0.0.0-20230921221157-1350c8be7c96/migrations/000037_update_community_catergory.up.sql (about) 1 DELETE FROM community_types WHERE key='service'; 2 3 BEGIN; 4 ALTER TYPE community_type ADD VALUE IF NOT EXISTS 'nft'; 5 ALTER TYPE community_type RENAME VALUE 'service' TO 'collector'; 6 END TRANSACTION; 7 COMMIT; 8 9 INSERT INTO community_types (key, name, description) VALUES ('nft', 'NFT', 'NFT Community'); 10 INSERT INTO community_types (key, name, description) VALUES ('collector', 'Collector', 'Collector Community');