<commit_before><commit_msg>adding snapshots liquibase file<commit_after><?xml version="1.0" encoding="UTF-8"?>

<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-3.1.xsd">

	<changeSet id="snapshots" author="tom">

		<!-- Add host table for storing more sample properties -->
		<createTable tableName="project_snapshot">
			<column name="snapshotId" type="bigint(20)" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" />
			</column>
			<column name="id" type="bigint(20)" />
			<column name="name" type="varchar(255)">
				<constraints nullable="false"></constraints>
			</column>
			<column name="organism" type="varchar(255)" />
			<column name="projectDescription" type="longtext" />
			<column name="remoteURL" type="varchar(255)" />
		</createTable>

		<createTable tableName="sample_snapshot">
			<column name="snapshotId" type="bigint(20)" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" />
			</column>
			<column name="description" type="longtext" />
			<column name="sampleName" type="varchar(255)">
				<constraints nullable="false"></constraints>
			</column>
			<column name="sequencerSampleId" type="varchar(255)">
				<constraints nullable="false"></constraints>
			</column>
			<column name="collectedBy" type="varchar(255)" />
			<column name="collectionDate" type="datetime" />
			<column name="cultureCollection" type="varchar(255)" />
			<column name="genotype" type="longtext" />
			<column name="geographicLocationName" type="varchar(255)" />
			<column name="isolate" type="varchar(255)" />
			<column name="isolationSource" type="longtext" />
			<column name="latitude" type="varchar(255)" />
			<column name="longitude" type="varchar(255)" />
			<column name="organism" type="varchar(255)" />
			<column name="passageHistory" type="longtext" />
			<column name="pathotype" type="varchar(255)" />
			<column name="serotype" type="varchar(255)" />
			<column name="serovar" type="varchar(255)" />
			<column name="subgroup" type="varchar(255)" />
			<column name="subtype" type="varchar(255)" />
			<column name="host_id" type="bigint(20)" />
			<column name="specimenVoucher" type="varchar(255)" />
			<column name="strain" type="varchar(255)" />
		</createTable>

	</changeSet>
</databaseChangeLog>
{'fraction_non_alphanumeric': 0.18911290322580646, 'fraction_numerical': 0.03024193548387097, 'mean_word_length': 5.361538461538461, 'pattern_counts': {'":': 0, '<': 55, '<?xml version=': 1, '>': 55, 'https://': 0, 'lorem ipsum': 0, 'www.': 4, 'xml': 6}, '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': '1094469', 'n_tokens_mistral': 958, 'n_tokens_neox': 828, 'n_words': 136}