<commit_before>DROP TABLE citations;
CREATE TABLE citations (
    id integer DEFAULT 0 NOT NULL,
    citation_number text NULL,
    citation_date date NULL,
    first_name text NULL,
    last_name text NULL,
    date_of_birth date NULL,
    defendant_address text NULL,
    defendant_city text NULL,
    defendant_state text NULL,
    drivers_license_number text,
    court_date date NULL,
    court_location text NULL,
    court_address text NULL,
    court_id integer NULL
);

DROP TABLE courts;
CREATE TABLE courts (
    id integer NOT NULL,
    latitude double precision,
    longitude double precision,
    municipality text,
    address text,
    city text,
    state text,
    zip_code text
);

DROP TABLE opportunities;
CREATE TABLE opportunities (
    id integer NOT NULL,
    sponsor_id integer NOT NULL,
    name text NOT NULL,
    short_description text NOT NULL,
    full_description text,
    court_id integer NOT NULL
);

DROP TABLE opportunity_need_pairings;
CREATE TABLE opportunity_need_pairings (
    opportunity_need_id integer,
    violation_id integer,
    status text,
    id integer
);

DROP TABLE opportunity_needs;
CREATE TABLE opportunity_needs (
    id integer NOT NULL,
    opportunity_id integer,
    start_time DATETIME,
    end_time DATETIME,
    violation_fine_limit numeric,
    desired_count integer,
    description text
);

DROP TABLE sponsor_login;
CREATE TABLE sponsor_login (
    id integer NOT NULL,
    userid text,
    pwd text
);

DROP TABLE sponsors;
CREATE TABLE sponsors (
    id integer NOT NULL,
    name text,
    short_description text,
    contact_email text,
    contact_phonenumber text
);

DROP TABLE violations;
CREATE TABLE violations (
    id integer DEFAULT 0 NOT NULL,
    citation_number text,
    violation_number text,
    violation_description text,
    warrant_status TINYINT(1) DEFAULT 0,
    warrant_number text,
    status text,
    status_date TIMESTAMP,<commit_msg>Updated the table setup script to properly handle when the are no tables yet.<commit_after>DROP TABLE IF EXISTS citations;
CREATE TABLE citations (
    id integer DEFAULT 0 NOT NULL,
    citation_number text NULL,
    citation_date date NULL,
    first_name text NULL,
    last_name text NULL,
    date_of_birth date NULL,
    defendant_address text NULL,
    defendant_city text NULL,
    defendant_state text NULL,
    drivers_license_number text,
    court_date date NULL,
    court_location text NULL,
    court_address text NULL,
    court_id integer NULL
);

DROP TABLE IF EXISTS courts;
CREATE TABLE courts (
    id integer NOT NULL,
    latitude double precision,
    longitude double precision,
    municipality text,
    address text,
    city text,
    state text,
    zip_code text
);

DROP TABLE IF EXISTS opportunities;
CREATE TABLE opportunities (
    id integer NOT NULL,
    sponsor_id integer NOT NULL,
    name text NOT NULL,
    short_description text NOT NULL,
    full_description text,
    court_id integer NOT NULL
);

DROP TABLE IF EXISTS opportunity_need_pairings;
CREATE TABLE opportunity_need_pairings (
    opportunity_need_id integer,
    violation_id integer,
    status text,
    id integer
);

DROP TABLE IF EXISTS opportunity_needs;
CREATE TABLE opportunity_needs (
    id integer NOT NULL,
    opportunity_id integer,
    start_time DATETIME,
    end_time DATETIME,
    violation_fine_limit numeric,
    desired_count integer,
    description text
);

DROP TABLE IF EXISTS sponsor_login;
CREATE TABLE sponsor_login (
    id integer NOT NULL,
    userid text,
    pwd text
);

DROP TABLE IF EXISTS sponsors;
CREATE TABLE sponsors (
    id integer NOT NULL,
    name text,
    short_description text,
    contact_email text,
    contact_phonenumber text
);

DROP TABLE IF EXISTS violations;
CREATE TABLE violations (
    id integer DEFAULT 0 NOT NULL,
    citation_number text,
    violation_number text,
    violation_description text,
    warrant_status TINYINT(1) DEFAULT 0,
    warrant_number text,
    status text,
    status_date TIMESTAMP,
{'fraction_non_alphanumeric': 0.04160438465371201, 'fraction_numerical': 0.001993024414549078, 'mean_word_length': 3.397590361445783, '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': '3285533', 'n_tokens_mistral': 1174, 'n_tokens_neox': 1139, 'n_words': 428}