<commit_before>CREATE TABLE cpa
(
	id							INT							GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
	cpa_id					VARCHAR(128)		NOT NULL UNIQUE,
	cpa							CLOB						NOT NULL
);

CREATE TABLE ebms_message
(
	id								INT							GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
	time_stamp				TIMESTAMP				NOT NULL,
	cpa_id						VARCHAR(256)		NOT NULL,
	conversation_id		VARCHAR(256)		NOT NULL,
	sequence_nr				INT							NOT NULL,
	message_id				VARCHAR(256)		NOT NULL UNIQUE,
	message_type			INT							NOT NULL,
	message_original	BLOB						NULL,
	message_header		CLOB 						NOT NULL,
	message_ack_req		CLOB 						NULL,
	message_manifest	CLOB 						NULL,
	ack_type					INT							NULL,
	ack_header				CLOB 						NULL,
	ack_content				CLOB 						NULL,
	status						INT							NOT NULL,
	status_date				TIMESTAMP				NOT NULL,
	nr_retries				INT							DEFAULT 0 NOT NULL,
	processing_status	INT							NULL,
	next_retry_time		TIMESTAMP				NULL
);

CREATE TABLE ebms_attachment
(
	id								INT							GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
	ebms_message_id		INT							NOT NULL FOREIGN KEY REFERENCES ebms_message(id),
	name							VARCHAR(128)		NOT NULL,
	content_type			VARCHAR(64)			NOT NULL,
	content						BLOB						NOT NULL
);<commit_msg>changed table definition<commit_after>CREATE TABLE cpa
(
	id							INT							GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
	cpa_id					VARCHAR(128)		NOT NULL UNIQUE,
	cpa							CLOB						NOT NULL
);

CREATE TABLE ebms_message
(
	id								INT							GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
	time_stamp				TIMESTAMP				NOT NULL,
	cpa_id						VARCHAR(256)		NOT NULL,
	conversation_id		VARCHAR(256)		NOT NULL,
	sequence_nr				INT							NOT NULL,
	message_id				VARCHAR(256)		NOT NULL UNIQUE,
	message_type			INT							NOT NULL,
	message_original	BLOB						NULL,
	message_header		CLOB 						NOT NULL,
	message_ack_req		CLOB 						NULL,
	message_manifest	CLOB 						NULL,
	ack_type					INT							NULL,
	ack_header				CLOB 						NULL,
	ack_content				CLOB 						NULL,
	status						INT							NOT NULL,
	status_date				TIMESTAMP				NOT NULL,
	nr_retries				INT							DEFAULT 0 NOT NULL,
	next_retry_time		TIMESTAMP				NULL,
	processing_status	INT							NULL
);

CREATE TABLE ebms_attachment
(
	id								INT							GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
	ebms_message_id		INT							NOT NULL FOREIGN KEY REFERENCES ebms_message(id),
	name							VARCHAR(128)		NOT NULL,
	content_type			VARCHAR(64)			NOT NULL,
	content						BLOB						NOT NULL
);
{'fraction_non_alphanumeric': 0.043562816024893036, 'fraction_numerical': 0.01633605600933489, 'mean_word_length': 2.362091503267974, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '5212260', 'n_tokens_mistral': 1307, 'n_tokens_neox': 974, 'n_words': 284}