<commit_before><?xml version="1.0" encoding="UTF-8"?>
<database name="blog" defaultIdMethod="native">
	<table name="article" phpName="Article">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
		<column name="title" type="varchar" size="255" required="true" primaryString="true" />
		<column name="bodyHTML" type="longvarchar"/>
		<column name="body" type="longvarchar" required="true"/>
		<column name="tags" type="varchar" size="255" required="false"/>
		<column name="positive_votes" type="integer" required="false" defaultValue="0" />
		<column name="negative_votes" type="integer" required="false" defaultValue="0" />
		<column name="theme_id" type="integer" required="true" defaultValue="0" />
		<column name="tag_id" type="integer" required="false" />
		<column name="image" type="varchar" size="255" required="false" default="default/post_img.png" />
		<column name="draft" type="boolean" required="false" defaultValue="false" />
		<behavior name="timestampable"/>
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<foreign-key foreignTable="theme" phpName="Theme" onDelete="CASCADE" refPhpName="Article">
			<reference local="theme_id" foreign="id"/>
		</foreign-key>
				<foreign-key foreignTable="tag" phpName="Tag" onDelete="CASCADE" refPhpName="Article">
			<reference local="tag_id" foreign="id"/>
		</foreign-key>
		<behavior name="sluggable" />
	</table>
	<table name="theme" phpName="Theme">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<column name="name" type="varchar" size="60" required="true" primaryString="true" />
		<column name="root" type="varchar" size="128" required="true" />
		<column name="colour" type="varchar" size="10" required="false" defaultValue="blue" />
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<behavior name="sluggable" />
	</table>
	<table name="tag" phpName="Tag">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<column name="name" type="varchar" size="60" required="true" primaryString="true" />
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<behavior name="sluggable" />
	</table>
	<table name="view" phpName="View">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<column name="ip_address" type="varchar" size="30" required="true" />
		<column name="time" type="timestamp" defaultExpr="CURRENT_TIMESTAMP" required="true"/>
		<column name="article_id" type="integer" required="true" defaultValue="0" />
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<foreign-key foreignTable="article" phpName="Article" onDelete="CASCADE" refPhpName="View"><commit_msg>Database schema for tagging<commit_after><?xml version="1.0" encoding="UTF-8"?>
<database name="blog" defaultIdMethod="native">
	<table name="article" phpName="Article">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
		<column name="title" type="varchar" size="255" required="true" primaryString="true" />
		<column name="bodyHTML" type="longvarchar"/>
		<column name="body" type="longvarchar" required="true"/>
		<column name="tags" type="varchar" size="255" required="false"/>
		<column name="positive_votes" type="integer" required="false" defaultValue="0" />
		<column name="negative_votes" type="integer" required="false" defaultValue="0" />
		<column name="theme_id" type="integer" required="true" defaultValue="0" />
		<column name="tag_id" type="integer" required="false" />
		<column name="image" type="varchar" size="255" required="false" default="default/post_img.png" />
		<column name="draft" type="boolean" required="false" defaultValue="false" />
		<behavior name="timestampable"/>
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<foreign-key foreignTable="theme" phpName="Theme" onDelete="CASCADE" refPhpName="Article">
			<reference local="theme_id" foreign="id"/>
		</foreign-key>
				<foreign-key foreignTable="tag" phpName="Tag" onDelete="CASCADE" refPhpName="Article">
			<reference local="tag_id" foreign="id"/>
		</foreign-key>
		<behavior name="sluggable" />
	</table>
	<table name="tag" phpName="Tag">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<column name="name" type="varchar" size="60" required="true" primaryString="true" />
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<behavior name="sluggable" />
	</table>
	<table name="article_tag" phpName="ArticleTag" isCrossRef="true">
		<column name="article_id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<column name="tag_id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<foreign-key foreignTable="article">
			<reference local="article_id" foreign="id"/>
		</foreign-key>
		<foreign-key foreignTable="tag">
			<reference local="tag_id" foreign="id"/>
		</foreign-key>
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
	</table>
	<table name="theme" phpName="Theme">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<column name="name" type="varchar" size="60" required="true" primaryString="true" />
		<column name="root" type="varchar" size="128" required="true" />
		<column name="colour" type="varchar" size="10" required="false" defaultValue="blue" />
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<behavior name="sluggable" />
	</table>
	<table name="view" phpName="View">
		<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
		<column name="ip_address" type="varchar" size="30" required="true" />
		<column name="time" type="timestamp" defaultExpr="CURRENT_TIMESTAMP" required="true"/>
		<column name="article_id" type="integer" required="true" defaultValue="0" />
		<behavior name="query_cache">
			<parameter name="backend" value="custom" />
		</behavior>
		<foreign-key foreignTable="article" phpName="Article" onDelete="CASCADE" refPhpName="View">
{'fraction_non_alphanumeric': 0.1925984251968504, 'fraction_numerical': 0.008503937007874015, 'mean_word_length': 6.918952618453865, 'pattern_counts': {'":': 0, '<': 122, '<?xml version=': 2, '>': 122, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, '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': '4168743', 'n_tokens_mistral': 2205, 'n_tokens_neox': 2007, 'n_words': 409}