<commit_before># --- !Ups
DROP TABLE mission_user;
DROP TABLE mission;

CREATE TABLE mission_type
(
  mission_type_id SERIAL NOT NULL,
  mission_type TEXT NOT NULL,
  PRIMARY KEY (mission_type_id)
);

INSERT INTO "mission_type" ( "mission_type") VALUES ( 'auditOnboarding' );
INSERT INTO "mission_type" ( "mission_type") VALUES ( 'audit' );
INSERT INTO "mission_type" ( "mission_type") VALUES ( 'validationOnboarding' );
INSERT INTO "mission_type" ( "mission_type") VALUES ( 'validation' );

CREATE TABLE mission
(
  mission_id SERIAL NOT NULL,
  mission_type_id INT NOT NULL,
  user_id TEXT NOT NULL,
  mission_start TIMESTAMP NOT NULL,
  mission_end TIMESTAMP NOT NULL,
  completed BOOLEAN NOT NULL,
  pay REAL NOT NULL DEFAULT 0.0,
  paid BOOLEAN NOT NULL,
  distance_meters DOUBLE PRECISION,
  distance_progress DOUBLE PRECISION,
  region_id INT,
  labels_validated INT,
  labels_progress INT,
  PRIMARY KEY (mission_id),
  FOREIGN KEY (mission_type_id) REFERENCES mission_type(mission_type_id),
  FOREIGN KEY (user_id) REFERENCES sidewalk.user(user_id),
  FOREIGN KEY (region_id) REFERENCES region(region_id)
);

TRUNCATE TABLE audit_task_comment;
TRUNCATE TABLE audit_task_interaction;
TRUNCATE TABLE audit_task_environment;
TRUNCATE TABLE audit_task_incomplete;

TRUNCATE TABLE user_attribute_label, label_tag, label;

ALTER TABLE audit_task_comment
  ADD COLUMN audit_task_id INT NOT NULL,<commit_msg>added skipped column to mission table in evolution<commit_after># --- !Ups
DROP TABLE mission_user;
DROP TABLE mission;

CREATE TABLE mission_type
(
  mission_type_id SERIAL NOT NULL,
  mission_type TEXT NOT NULL,
  PRIMARY KEY (mission_type_id)
);

INSERT INTO "mission_type" ( "mission_type") VALUES ( 'auditOnboarding' );
INSERT INTO "mission_type" ( "mission_type") VALUES ( 'audit' );
INSERT INTO "mission_type" ( "mission_type") VALUES ( 'validationOnboarding' );
INSERT INTO "mission_type" ( "mission_type") VALUES ( 'validation' );

CREATE TABLE mission
(
  mission_id SERIAL NOT NULL,
  mission_type_id INT NOT NULL,
  user_id TEXT NOT NULL,
  mission_start TIMESTAMP NOT NULL,
  mission_end TIMESTAMP NOT NULL,
  completed BOOLEAN NOT NULL,
  pay REAL NOT NULL DEFAULT 0.0,
  paid BOOLEAN NOT NULL,
  distance_meters DOUBLE PRECISION,
  distance_progress DOUBLE PRECISION,
  region_id INT,
  labels_validated INT,
  labels_progress INT,
  skipped BOOLEAN NOT NULL,
  PRIMARY KEY (mission_id),
  FOREIGN KEY (mission_type_id) REFERENCES mission_type(mission_type_id),
  FOREIGN KEY (user_id) REFERENCES sidewalk.user(user_id),
  FOREIGN KEY (region_id) REFERENCES region(region_id)
);

TRUNCATE TABLE audit_task_comment;
TRUNCATE TABLE audit_task_interaction;
TRUNCATE TABLE audit_task_environment;
TRUNCATE TABLE audit_task_incomplete;

TRUNCATE TABLE user_attribute_label, label_tag, label;

ALTER TABLE audit_task_comment
  ADD COLUMN audit_task_id INT NOT NULL,
{'fraction_non_alphanumeric': 0.07249392993409642, 'fraction_numerical': 0.001387443635102324, 'mean_word_length': 5.706976744186046, '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': '2988554', 'n_tokens_mistral': 987, 'n_tokens_neox': 944, 'n_words': 288}