[Bug]: Incorrect foreign key mismatch error #4155

CREATE TABLE IF NOT EXISTS single_drives(
        drive_sequential_number     INTEGER PRIMARY KEY,
        drive_serial_number         TEXT NOT NULL, 
        drive_model                 TEXT, 
        base_board                  INTEGER NOT NULL, 
        cpu_board                   INTEGER, 
        transistor_board            INTEGER, 
        filter_board                INTEGER, 
        fpga_firmware               TEXT,
        dsp_firmware                TEXT, 
        boot_version                TEXT, 
        notes                       TEXT, 
        service_notes               TEXT, 
        previous_sequential_number  INTEGER,
        UNIQUE(drive_sequential_number),
        UNIQUE(drive_serial_number),
        FOREIGN KEY(base_board)                 REFERENCES drive_base_boards(base_board_id)
            ON UPDATE CASCADE
            ON DELETE SET NULL,
        FOREIGN KEY(cpu_board)                  REFERENCES drive_cpu_boards(cpu_board_id)
            ON UPDATE CASCADE
            ON DELETE SET NULL,
        FOREIGN KEY(transistor_board)           REFERENCES drive_transistor_boards(transistor_board_id)
            ON UPDATE CASCADE
            ON DELETE SET NULL,
        FOREIGN KEY(filter_board)               REFERENCES drive_cpu_boards(filter_board_id)
            ON UPDATE CASCADE
            ON DELETE SET NULL
        FOREIGN KEY(previous_sequential_number) REFERENCES single_drives(drive_sequential_number)
            ON UPDATE CASCADE
            ON DELETE SET NULL

CREATE TABLE IF NOT EXISTS drive_cpu_boards(
        cpu_board_id               INTEGER PRIMARY KEY,
        cpu_board_serial_number    TEXT NOT NULL,
        UNIQUE(cpu_board_id)
        UNIQUE(cpu_board_serial_number)
        )