202405302121_store_decrypted_request.go raw

   1  package migrations
   2  
   3  import (
   4  	_ "embed"
   5  
   6  	"github.com/go-gormigrate/gormigrate/v2"
   7  	"gorm.io/gorm"
   8  )
   9  
  10  var _202405302121_store_decrypted_request = &gormigrate.Migration{
  11  	ID: "_202405302121_store_decrypted_request",
  12  	Migrate: func(tx *gorm.DB) error {
  13  
  14  		err := tx.Exec(`ALTER TABLE request_events ADD COLUMN method TEXT;`).Error
  15  		if err != nil {
  16  			return err
  17  		}
  18  
  19  		err = tx.Exec(`CREATE INDEX "idx_request_events_method" ON "request_events"("method");`).Error
  20  		if err != nil {
  21  			return err
  22  		}
  23  
  24  		err = tx.Exec(`ALTER TABLE request_events ADD COLUMN content_data TEXT`).Error
  25  		return err
  26  	},
  27  	Rollback: func(tx *gorm.DB) error {
  28  		return nil
  29  	},
  30  }
  31