<commit_before>-- 
-- BUILD2. See https://github.com/ppKrauss/socKer-complete
--

CREATE TABLE socker.ruletype ( 
	-- 
	-- A standard agent-agent rule type.
	--
	id serial NOT NULL PRIMARY KEY,
	def_url text CHECK(char_length(def_url)<250), -- cool URLs, like SchemaOrg or Wikidata, are short
	valid_pairs int[] NOT NULL,  -- agtype-agtype pair, by oneDigit-concatenation. (ex. 11,12,21,22)
	iscommutative boolean NOT NULL DEFAULT true,
	info JSONb NOT NULL CHECK (info->>'constraints' IS NOT NULL),
	UNIQUE(def_url)
);
  
CREATE TABLE socker.agents_relation ( 
	-- <commit_msg>Update build2.sql<commit_after>-- 
-- BUILD2. See https://github.com/ppKrauss/socKer-complete
--

CREATE TABLE socker.ruletype ( 
	-- 
	-- A standard agent-agent rule type.
	--
	id serial NOT NULL PRIMARY KEY,
	def_url text CHECK(char_length(def_url)<250), -- cool URLs, like SchemaOrg or Wikidata, are short
	valid_pairs int[] NOT NULL,  -- agtype-agtype pair, by oneDigit-concatenation. (ex. 11,12,21,22)
	iscommutative boolean NOT NULL DEFAULT true,
	accept_contactpoint boolean NOT NULL DEFAULT false, -- for check before to add a RelatContactPoint.
	info JSONb NOT NULL CHECK (info->>'constraints' IS NOT NULL),
	UNIQUE(def_url)
);
  
CREATE TABLE socker.agents_relation ( 
	-- 
{'fraction_non_alphanumeric': 0.11498810467882632, 'fraction_numerical': 0.019825535289452814, 'mean_word_length': 3.762264150943396, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 7, 'https://': 2, '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': '56015', 'n_tokens_mistral': 466, 'n_tokens_neox': 427, 'n_words': 130}