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');