<commit_before>CREATE TABLE nodes (node TEXT NOT NULL PRIMARY KEY);
ALTER TABLE nodes OWNER TO "buddycloud-server";

CREATE TABLE node_config (node TEXT NOT NULL REFERENCES nodes (node),
       	     		  "key" TEXT,
			  "value" TEXT,
			  updated TIMESTAMP,
			  PRIMARY KEY (node, "key"));
ALTER TABLE node_config OWNER TO "buddycloud-server";

CREATE TABLE items (node TEXT REFERENCES nodes (node),
       	     	    id TEXT NOT NULL,
		    author TEXT,
		    updated TIMESTAMP,
		    xml TEXT,
		    PRIMARY KEY (node, id));
ALTER TABLE items OWNER TO "buddycloud-server";
CREATE INDEX items_updated ON items (updated);

CREATE TABLE subscriptions (node TEXT REFERENCES nodes (node),
       	     		    "user" TEXT,
			    listener TEXT,
			    subscription TEXT,
 			    updated TIMESTAMP,
			    PRIMARY KEY (node, "user"));
ALTER TABLE subscriptions OWNER TO "buddycloud-server";
CREATE INDEX subscriptions_updated ON subscriptions (updated);

CREATE TABLE affiliations (node TEXT REFERENCES nodes (node),
       	     		   "user" TEXT,
			   affiliation TEXT,
 			   updated TIMESTAMP,
			   PRIMARY KEY (node, "user"));
ALTER TABLE affiliations OWNER TO "buddycloud-server";
CREATE INDEX affiliations_updated ON affiliations (updated);
<commit_msg>Revert "Made the ownership of tables really clear. Should help avoid the problem that DD had the other day."<commit_after>CREATE TABLE nodes (node TEXT NOT NULL PRIMARY KEY);
CREATE TABLE node_config (node TEXT NOT NULL REFERENCES nodes (node),
       	     		  "key" TEXT,
			  "value" TEXT,
			  updated TIMESTAMP,
			  PRIMARY KEY (node, "key"));
CREATE TABLE items (node TEXT REFERENCES nodes (node),
       	     	    id TEXT NOT NULL,
		    author TEXT,
		    updated TIMESTAMP,
		    xml TEXT,
		    PRIMARY KEY (node, id));
CREATE INDEX items_updated ON items (updated);
CREATE TABLE subscriptions (node TEXT REFERENCES nodes (node),
       	     		    "user" TEXT,
			    listener TEXT,
			    subscription TEXT,
 			    updated TIMESTAMP,
			    PRIMARY KEY (node, "user"));
CREATE INDEX subscriptions_updated ON subscriptions (updated);
CREATE TABLE affiliations (node TEXT REFERENCES nodes (node),
       	     		   "user" TEXT,
			   affiliation TEXT,
 			   updated TIMESTAMP,
			   PRIMARY KEY (node, "user"));
CREATE INDEX affiliations_updated ON affiliations (updated);

{'fraction_non_alphanumeric': 0.07764505119453925, 'fraction_numerical': 0.0, 'mean_word_length': 2.9611486486486487, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '1619913', 'n_tokens_mistral': 760, 'n_tokens_neox': 655, 'n_words': 262}