class ModifyParticipants extends edu.northwestern.bioinformatics.bering.Migration {
    void up() {
	if (databaseMatches('oracle')) {
          execute('ALTER TABLE participants RENAME COLUMN social_security_number TO person_id ')
      } else if (databaseMatches('postgresql') {
          execute('ALTER TABLE participants RENAME COLUMN social_security_number TO person_id ')
    	} else {
	    execute('ALTER TABLE participants ALTER COLUMN social_security_number RENAME TO person_id')
	}
    }

    void down() {
        execute('ALTER TABLE participants DROP COLUMN person_id')
    }
}
class ModifyParticipants extends edu.northwestern.bioinformatics.bering.Migration {
    void up() {
        if (databaseMatches('hsqldb')) {
            execute('ALTER TABLE participants ALTER COLUMN social_security_number RENAME TO person_id')
        } else {
            execute('ALTER TABLE participants RENAME COLUMN social_security_number TO person_id')
        }
    }

    void down() {
        if (databaseMatches('hsqldb')) {
            execute('ALTER TABLE participants ALTER COLUMN person_id RENAME TO social_security_number')
        } else {
            execute('ALTER TABLE participants RENAME COLUMN person_id TO social_security_number')
        }
    }
}
Add special cases for HSQLDB
Add special cases for HSQLDB

git-svn-id: 4b387fe5ada7764508e2ca96c335714e4c1692c6@270 0d517254-b314-0410-acde-c619094fa49f
