<commit_before>class StudySubjectVersionChanges extends edu.northwestern.bioinformatics.bering.Migration {
    void up() {
        createTable('study_subject_versions') { t ->
        	t.addColumn('retired_indicator', 'string', nullable:true)
       		t.addColumn('grid_id' , 'string' , nullable:true)
       		t.addVersionColumn()
            t.addColumn('spa_id', 'integer',nullable:false)
            t.addColumn('study_site_ver_id', 'integer',nullable:false)
        }
        
        createTable('study_subject_consents') { t ->
        	t.addColumn('retired_indicator', 'string', nullable:true)
       		t.addColumn('grid_id' , 'string' , nullable:true)
       		t.addVersionColumn()
            t.addColumn('informed_consent_signed_date', 'date')
            t.addColumn('study_subject_ver_id', 'integer',nullable:false)
            t.addColumn('consent_version_id', 'integer',nullable:false)
        }
		
	    if (databaseMatches('oracle')) {
		   	execute('rename SEQ_study_subject_versions_ID to study_subject_versions_ID_SEQ');
		   	execute('rename SEQ_study_subject_consents_ID to study_subject_consents_ID_SEQ');
	 	}
    }

	void down() {
		dropTable('stu_sub_stu_versions');
	    dropTable('stu_sub_cosnt_vers')
	}
}<commit_msg>dropped consent_history<commit_after>class StudySubjectVersionChanges extends edu.northwestern.bioinformatics.bering.Migration {
    void up() {
        createTable('study_subject_versions') { t ->
        	t.addColumn('retired_indicator', 'string', nullable:true)
       		t.addColumn('grid_id' , 'string' , nullable:true)
       		t.addVersionColumn()
            t.addColumn('spa_id', 'integer',nullable:false)
            t.addColumn('study_site_ver_id', 'integer',nullable:false)
        }
        
        createTable('study_subject_consents') { t ->
        	t.addColumn('retired_indicator', 'string', nullable:true)
       		t.addColumn('grid_id' , 'string' , nullable:true)
       		t.addVersionColumn()
            t.addColumn('informed_consent_signed_date', 'date')
            t.addColumn('study_subject_ver_id', 'integer',nullable:false)
            t.addColumn('consent_version_id', 'integer',nullable:false)
        }
		
	    if (databaseMatches('oracle')) {
		   	execute('rename SEQ_study_subject_versions_ID to study_subject_versions_ID_SEQ');
		   	execute('rename SEQ_study_subject_consents_ID to study_subject_consents_ID_SEQ');
	 	}
	 	
	 	dropTable('consent_history')
    }

	void down() {
		dropTable('stu_sub_stu_versions');
	    dropTable('stu_sub_cosnt_vers')
	}
}
{'fraction_non_alphanumeric': 0.12302839116719243, 'fraction_numerical': 0.0, 'mean_word_length': 3.4823321554770317, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5400513', 'n_tokens_mistral': 869, 'n_tokens_neox': 825, 'n_words': 98}