<commit_before><databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">	
			
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ATTR_DEFN_T">
		<loadData tableName="KRIM_ATTR_DEFN_T" file="bootstrap/krim_attr_defn_t.csv" />
		<rollback>
			<delete tableName="KRIM_ATTR_DEFN_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_TYP_T">
		<loadData tableName="KRIM_TYP_T" file="bootstrap/krim_typ_t.csv" />
		<rollback>
			<delete tableName="KRIM_TYP_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_TYP_ATTR_T">
		<loadData tableName="KRIM_TYP_ATTR_T" file="bootstrap/krim_typ_attr_t.csv" />
		<rollback>
			<delete tableName="KRIM_TYP_ATTR_T">
				<where>KIM_TYP_ID IN (SELECT KIM_TYP_ID FROM KRIM_TYP_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_T">
		<loadData tableName="KRIM_ROLE_T" file="bootstrap/krim_role_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_MBR_T">
		<loadData tableName="KRIM_ROLE_MBR_T" file="bootstrap/krim_role_mbr_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_MBR_T">
				<where>ROLE_ID IN (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_MBR_ATTR_DATA_T">
		<loadData tableName="KRIM_ROLE_MBR_ATTR_DATA_T" file="bootstrap/krim_role_mbr_attr_data_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_MBR_ATTR_DATA_T">
				<where>ROLE_MBR_ID IN (SELECT DISTINCT ROLE_MBR_ID FROM KRIM_ROLE_MBR_T WHERE ROLE_ID IN (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD LIKE 'KC%'))</where>
			</delete>
		</rollback>		
    </changeSet>

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_PERM_TMPL_T">
		<loadData tableName="KRIM_PERM_TMPL_T" file="bootstrap/krim_perm_tmpl_t.csv" />
		<rollback>
			<delete tableName="KRIM_PERM_TMPL_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_PERM_T">
		<loadData tableName="KRIM_PERM_T" file="bootstrap/krim_perm_t.csv" />
		<rollback>
			<delete tableName="KRIM_PERM_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_PERM_ATTR_DATA_T">
		<loadData tableName="KRIM_PERM_ATTR_DATA_T" file="bootstrap/krim_perm_attr_data_t.csv" />
		<rollback>
			<delete tableName="KRIM_PERM_ATTR_DATA_T">
				<where>PERM_ID IN (SELECT PERM_ID FROM KRIM_PERM_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_RSP_T">
		<loadData tableName="KRIM_RSP_T" file="bootstrap/krim_rsp_t.csv" />
		<rollback>
			<delete tableName="KRIM_RSP_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_RSP_ATTR_DATA_T">
		<loadData tableName="KRIM_RSP_ATTR_DATA_T" file="bootstrap/krim_rsp_attr_data_t.csv" />
		<rollback>
			<delete tableName="KRIM_RSP_ATTR_DATA_T">
				<where>RSP_ID IN (SELECT RSP_ID FROM KRIM_RSP_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_PERM_T">
		<loadData tableName="KRIM_ROLE_PERM_T" file="bootstrap/krim_role_perm_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_PERM_T"><commit_msg>KCINFR-121: Adding KC Group data to Rice Overlay Scripts<commit_after><databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">	
			
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ATTR_DEFN_T">
		<loadData tableName="KRIM_ATTR_DEFN_T" file="bootstrap/krim_attr_defn_t.csv" />
		<rollback>
			<delete tableName="KRIM_ATTR_DEFN_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_TYP_T">
		<loadData tableName="KRIM_TYP_T" file="bootstrap/krim_typ_t.csv" />
		<rollback>
			<delete tableName="KRIM_TYP_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_TYP_ATTR_T">
		<loadData tableName="KRIM_TYP_ATTR_T" file="bootstrap/krim_typ_attr_t.csv" />
		<rollback>
			<delete tableName="KRIM_TYP_ATTR_T">
				<where>KIM_TYP_ID IN (SELECT KIM_TYP_ID FROM KRIM_TYP_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_T">
		<loadData tableName="KRIM_ROLE_T" file="bootstrap/krim_role_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_MBR_T">
		<loadData tableName="KRIM_ROLE_MBR_T" file="bootstrap/krim_role_mbr_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_MBR_T">
				<where>ROLE_ID IN (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_MBR_ATTR_DATA_T">
		<loadData tableName="KRIM_ROLE_MBR_ATTR_DATA_T" file="bootstrap/krim_role_mbr_attr_data_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_MBR_ATTR_DATA_T">
				<where>ROLE_MBR_ID IN (SELECT DISTINCT ROLE_MBR_ID FROM KRIM_ROLE_MBR_T WHERE ROLE_ID IN (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD LIKE 'KC%'))</where>
			</delete>
		</rollback>		
    </changeSet>

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_PERM_TMPL_T">
		<loadData tableName="KRIM_PERM_TMPL_T" file="bootstrap/krim_perm_tmpl_t.csv" />
		<rollback>
			<delete tableName="KRIM_PERM_TMPL_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_PERM_T">
		<loadData tableName="KRIM_PERM_T" file="bootstrap/krim_perm_t.csv" />
		<rollback>
			<delete tableName="KRIM_PERM_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_PERM_ATTR_DATA_T">
		<loadData tableName="KRIM_PERM_ATTR_DATA_T" file="bootstrap/krim_perm_attr_data_t.csv" />
		<rollback>
			<delete tableName="KRIM_PERM_ATTR_DATA_T">
				<where>PERM_ID IN (SELECT PERM_ID FROM KRIM_PERM_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_RSP_T">
		<loadData tableName="KRIM_RSP_T" file="bootstrap/krim_rsp_t.csv" />
		<rollback>
			<delete tableName="KRIM_RSP_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_RSP_ATTR_DATA_T">
		<loadData tableName="KRIM_RSP_ATTR_DATA_T" file="bootstrap/krim_rsp_attr_data_t.csv" />
		<rollback>
			<delete tableName="KRIM_RSP_ATTR_DATA_T">
				<where>RSP_ID IN (SELECT RSP_ID FROM KRIM_RSP_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>
    
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_GRP_T">
		<loadData tableName="KRIM_GRP_T" file="bootstrap/krim_grp_t.csv" />
		<rollback>
			<delete tableName="KRIM_GRP_T">
				<where>NMSPC_CD LIKE 'KC%'</where>
			</delete>
		</rollback>		
    </changeSet>
	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_GRP_MBR_T">
		<loadData tableName="KRIM_GRP_MBR_T" file="bootstrap/krim_grp_mbr_t.csv" />
		<rollback>
			<delete tableName="KRIM_GRP_MBR_T">
				<where>GRP_ID IN (SELECT GRP_ID FROM KRIM_GRP_T WHERE NMSPC_CD LIKE 'KC%')</where>
			</delete>
		</rollback>		
    </changeSet>        

	<changeSet context="bootstrap,demo" author="kc" id="KC_LOAD_KRIM_ROLE_PERM_T">
		<loadData tableName="KRIM_ROLE_PERM_T" file="bootstrap/krim_role_perm_t.csv" />
		<rollback>
			<delete tableName="KRIM_ROLE_PERM_T">
{'fraction_non_alphanumeric': 0.14808166928427194, 'fraction_numerical': 0.0019071124074489566, 'mean_word_length': 5.488355167394468, 'pattern_counts': {'":': 0, '<': 229, '<?xml version=': 0, '>': 229, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 10}, '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': '3019835', 'n_tokens_mistral': 4188, 'n_tokens_neox': 3693, 'n_words': 514}