<commit_before>DROP VIEW IF EXISTS run_data_description_view;
DROP VIEW IF EXISTS software_input;

DROP TABLE IF EXISTS simulation_group_definition;
DROP TABLE IF EXISTS run_data;
DROP TABLE IF EXISTS run;
DROP TABLE IF EXISTS software_identification;
DROP TABLE IF EXISTS run_data_content;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS roles;
DROP TABLE IF EXISTS run_data_description;
DROP TABLE IF EXISTS run_data_description_axis_value;
DROP TABLE IF EXISTS run_data_description_axis;
DROP TABLE IF EXISTS simulated_population;
DROP TABLE IF EXISTS population_axis;
DROP TABLE IF EXISTS simulated_population_axis_value;
DROP TABLE IF EXISTS time_series;
DROP TABLE IF EXISTS visualizer_output;
DROP TABLE IF EXISTS apollo_service_simulator_run_cache;
DROP TABLE IF EXISTS apollo_service_visualizer_cache_results;
DROP TABLE IF EXISTS apollo_service_visualizer_cache;
DROP TABLE IF EXISTS simulation_groups;
DROP TABLE IF EXISTS user_roles;

CREATE TABLE users (
  id INT NOT NULL AUTO_INCREMENT,
  requester_id VARCHAR(255) NOT NULL,
  requester_password VARCHAR(255) NOT NULL,
  requester_email VARCHAR(255) NOT NULL,
  PRIMARY KEY(id)
);

INSERT INTO users (requester_id, requester_password, requester_email) VALUES ('test_user', '<PASSWORD>_password', '<PASSWORD>');

CREATE TABLE software_identification (
  id INT NOT NULL AUTO_INCREMENT,
  developer VARCHAR(255) NOT NULL,
  name VARCHAR(255) NOT NULL,
  version VARCHAR(255) NOT NULL,
  service_type VARCHAR(255) NOT NULL,
  wsdl_url TEXT NOT NULL,
  admin_id INT NOT NULL REFERENCES users(id),
  PRIMARY KEY (id)
);

INSERT INTO `software_identification` VALUES (1,'UPitt','Translator','1.0','translator','http://localhost:8080/translatorservice201/services/translatorservice?wsdl',1),
											 (2,'UPitt','SEIR','1.0','simulator','http://localhost:8080/seirsimulatorservice2.0.1/services/seirsimulatorservice?wsdl',1),
											 (3,'UPitt,PSC,CMU','FRED','2.0.1_i','simulator','http://warhol-fred.psc.edu:8094/fred?wsdl',1),
											 (4,'UPitt','Time Series Visualizer','1.0','visualizer','http://localhost:8080/visualizerservice2.0.1/services/visualizerservice?wsdl',1),
											 (5,'PSC','GAIA','1.0','visualizer','http://warhol-fred.psc.edu:8094/fred?wsdl',1),<commit_msg>Updated the SEIR WSDL location<commit_after>DROP VIEW IF EXISTS run_data_description_view;
DROP VIEW IF EXISTS software_input;

DROP TABLE IF EXISTS simulation_group_definition;
DROP TABLE IF EXISTS run_data;
DROP TABLE IF EXISTS run;
DROP TABLE IF EXISTS software_identification;
DROP TABLE IF EXISTS run_data_content;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS roles;
DROP TABLE IF EXISTS run_data_description;
DROP TABLE IF EXISTS run_data_description_axis_value;
DROP TABLE IF EXISTS run_data_description_axis;
DROP TABLE IF EXISTS simulated_population;
DROP TABLE IF EXISTS population_axis;
DROP TABLE IF EXISTS simulated_population_axis_value;
DROP TABLE IF EXISTS time_series;
DROP TABLE IF EXISTS visualizer_output;
DROP TABLE IF EXISTS apollo_service_simulator_run_cache;
DROP TABLE IF EXISTS apollo_service_visualizer_cache_results;
DROP TABLE IF EXISTS apollo_service_visualizer_cache;
DROP TABLE IF EXISTS simulation_groups;
DROP TABLE IF EXISTS user_roles;

CREATE TABLE users (
  id INT NOT NULL AUTO_INCREMENT,
  requester_id VARCHAR(255) NOT NULL,
  requester_password VARCHAR(255) NOT NULL,
  requester_email VARCHAR(255) NOT NULL,
  PRIMARY KEY(id)
);

INSERT INTO users (requester_id, requester_password, requester_email) VALUES ('test_user', 'test_password', 'test_email');

CREATE TABLE software_identification (
  id INT NOT NULL AUTO_INCREMENT,
  developer VARCHAR(255) NOT NULL,
  name VARCHAR(255) NOT NULL,
  version VARCHAR(255) NOT NULL,
  service_type VARCHAR(255) NOT NULL,
  wsdl_url TEXT NOT NULL,
  admin_id INT NOT NULL REFERENCES users(id),
  PRIMARY KEY (id)
);

INSERT INTO `software_identification` VALUES (1,'UPitt','Translator','1.0','translator','http://localhost:8080/translatorservice201/services/translatorservice?wsdl',1),
											 (2,'UPitt','SEIR','1.0','simulator','http://betaweb.rods.pitt.edu/seirsimulatorservice2.0.1/services/seirsimulatorservice?wsdl',1),
											 (3,'UPitt,PSC,CMU','FRED','2.0.1_i','simulator','http://warhol-fred.psc.edu:8094/fred?wsdl',1),
											 (4,'UPitt','Time Series Visualizer','1.0','visualizer','http://localhost:8080/visualizerservice2.0.1/services/visualizerservice?wsdl',1),
											 (5,'PSC','GAIA','1.0','visualizer','http://warhol-fred.psc.edu:8094/fred?wsdl',1),
{'fraction_non_alphanumeric': 0.1021671826625387, 'fraction_numerical': 0.03051747014595312, 'mean_word_length': 6.225239616613418, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, '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': '7318679', 'n_tokens_mistral': 1730, 'n_tokens_neox': 1479, 'n_words': 383}