<commit_before>CREATE TABLE IF NOT EXISTS reservation (
  id                              SERIAL,
  reservationTitle                VARCHAR(255) NOT NULL,
  addressLineOne                  VARCHAR(500),
  addressLineTwo                  VARCHAR(500),
  addressCity                     VARCHAR(255),
  addressState                    VARCHAR(20),
  addressZipCode                  VARCHAR(20),
  rsvpCode                        VARCHAR(6) NOT NULL,
  emailAddress                    VARCHAR(255),
  reservationNotes                VARCHAR(2048),
  dietaryRestrictions             VARCHAR(2048),
  notesForBrideGroom              VARCHAR(2048),
  isInvitedToRehearsalDinner      BOOLEAN,
  isAttendingBigDay               BOOLEAN,
  isAttendingRehearsalDinner      BOOLEAN,
  create_date                     TIMESTAMP NOT NULL,
  modified_date                   TIMESTAMP NOT NULL
);

CREATE TABLE IF NOT EXISTS contact (
  id                          SERIAL,
  firstName                   VARCHAR(255) NOT NULL,
  middleName                  VARCHAR(255),
  lastName                    VARCHAR(255) NOT NULL,
  isChild                     BOOLEAN,
  isAttendingBigDay           BOOLEAN,
  isAttendingRehearsalDinner  BOOLEAN
);<commit_msg>Change Reservation and Contact schema.<commit_after>CREATE TABLE IF NOT EXISTS reservation (
  id                              SERIAL,
  reservation_title                VARCHAR(255) NOT NULL,
  address_line_one                  VARCHAR(500),
  address_line_two                  VARCHAR(500),
  address_city                     VARCHAR(255),
  address_state                    VARCHAR(20),
  address_zip_code                  VARCHAR(20),
  rsvp_code                        VARCHAR(6) NOT NULL,
  rsvp_code_source                  VARCHAR(500) NOT NULL,
  email_address                    VARCHAR(255),
  reservation_notes                VARCHAR(2048),
  dietary_restrictions             VARCHAR(2048),
  notes_for_bride_groom              VARCHAR(2048),
  is_invited_to_rehearsal_dinner      BOOLEAN,
  is_attending_big_day               BOOLEAN,
  is_attending_rehearsal_dinner      BOOLEAN,
  create_date                     TIMESTAMP NOT NULL,
  modified_date                   TIMESTAMP NOT NULL
);

CREATE TABLE IF NOT EXISTS contact (
  id                          SERIAL,
  reservation_id              INT,
  first_name                   VARCHAR(255) NOT NULL,
  middle_name                  VARCHAR(255),
  last_name                    VARCHAR(255) NOT NULL,
  is_child                     BOOLEAN,
  is_attending_big_day           BOOLEAN,
  is_attending_rehearsal_dinner  BOOLEAN
);
{'fraction_non_alphanumeric': 0.046750285062713795, 'fraction_numerical': 0.032307107563664006, 'mean_word_length': 1.4598130841121495, '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': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3793948', 'n_tokens_mistral': 796, 'n_tokens_neox': 717, 'n_words': 154}