<commit_before># 05/01/2010

set session old_alter_table=1;##|##
 ##    Use old_alter_table.;

ALTER TABLE server_updater DROP PRIMARY KEY;##|##
 ##    Drop server_updater primary key.;

ALTER IGNORE TABLE server_updater ADD PRIMARY KEY (server_ip);##|##
 ##    Add server_updater primary key.;

ALTER TABLE server_performance DROP PRIMARY KEY;##|##
 ##    Drop server_performance primary key.;

ALTER IGNORE TABLE server_performance ADD PRIMARY KEY (server_ip,start_time);##|##
 ##    Add server_performance primary key.;

ALTER TABLE web_client_sessions DROP PRIMARY KEY;##|##
 ##    Drop web_client_sessions primary key.;

ALTER IGNORE TABLE web_client_sessions ADD PRIMARY KEY (session_name);##|##
 ##    Add web_client_sessions primary key.;

ALTER TABLE osdial_campaign_server_stats DROP PRIMARY KEY;##|##
 ##    Drop osdial_campaign_server_stats primary key.;

ALTER IGNORE TABLE osdial_campaign_server_stats ADD PRIMARY KEY (campaign_id,server_ip);##|##
 ##    Add osdial_campaign_server_stats primary key.;

ALTER TABLE osdial_campaign_stats DROP PRIMARY KEY;##|##
 ##    Drop osdial_campaign_stats primary key.;

ALTER IGNORE TABLE osdial_campaign_stats ADD PRIMARY KEY (campaign_id);##|##
 ##    Add osdial_campaign_stats primary key.;

ALTER TABLE osdial_campaign_agent_stats DROP PRIMARY KEY;##|##
 ##    Drop osdial_campaign_agent_stats primary key.;

ALTER IGNORE TABLE osdial_campaign_agent_stats ADD PRIMARY KEY (campaign_id,user);##|##<commit_msg>Lock tables before re-keying them.<commit_after># 05/01/2010

LOCK TABLES server_updater WRITE, server_performance WRITE, web_client_sessions WRITE, osdial_campaign_stats WRITE, osdial_campaign_server_stats WRITE, osdial_campaign_agent_stats WRITE;##|##
 ##    Lock tables.;

ALTER TABLE server_updater DROP PRIMARY KEY;##|##
 ##    Drop server_updater primary key.;
ALTER TABLE server_performance DROP PRIMARY KEY;##|##
 ##    Drop server_performance primary key.;
ALTER TABLE web_client_sessions DROP PRIMARY KEY;##|##
 ##    Drop web_client_sessions primary key.;
ALTER TABLE osdial_campaign_stats DROP PRIMARY KEY;##|##
 ##    Drop osdial_campaign_stats primary key.;
ALTER TABLE osdial_campaign_server_stats DROP PRIMARY KEY;##|##
 ##    Drop osdial_campaign_server_stats primary key.;
ALTER TABLE osdial_campaign_agent_stats DROP PRIMARY KEY;##|##
 ##    Drop osdial_campaign_agent_stats primary key.;

DELETE FROM server_updater;##|##
 ##    Clear records in server_updater.;
DELETE FROM server_performance;##|##
 ##    Clear records in server_performance.;
DELETE FROM web_client_sessions;##|##
 ##    Clear records in web_client_sessions.;
DELETE FROM osdial_campaign_stats;##|##
 ##    Clear records in osdial_campaign_stats.;
DELETE FROM osdial_campaign_server_stats;##|##
 ##    Clear records in osdial_campaign_server_stats.;
DELETE FROM osdial_campaign_agent_stats;##|##
 ##    Clear records in osdial_campaign_agent_stats.;

ALTER TABLE server_updater ADD PRIMARY KEY (server_ip);##|##
 ##    Add server_updater primary key.;
ALTER TABLE server_performance ADD PRIMARY KEY (server_ip,start_time);##|##
 ##    Add server_performance primary key.;
ALTER TABLE web_client_sessions ADD PRIMARY KEY (session_name);##|##
 ##    Add web_client_sessions primary key.;
ALTER TABLE osdial_campaign_stats ADD PRIMARY KEY (campaign_id);##|##
 ##    Add osdial_campaign_stats primary key.;
ALTER TABLE osdial_campaign_server_stats ADD PRIMARY KEY (campaign_id,server_ip);##|##
 ##    Add osdial_campaign_server_stats primary key.;
ALTER TABLE osdial_campaign_agent_stats ADD PRIMARY KEY (campaign_id,user);##|##
 ##    Add osdial_campaign_agent_stats primary key.;

UNLOCK TABLES;##|##
{'fraction_non_alphanumeric': 0.10186199342825848, 'fraction_numerical': 0.004654983570646221, 'mean_word_length': 5.815298507462686, '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': '7620298', 'n_tokens_mistral': 1249, 'n_tokens_neox': 1136, 'n_words': 326}