Is it common practice to create an additional database in PHP to track which groups have been transferred to a Teamspeak server?

To track which groups have been transferred to a Teamspeak server, it is common practice to create an additional database table in PHP that stores the group information along with the Teamspeak server details. This table can be used to keep track of which groups have been transferred and manage the synchronization between the PHP application and the Teamspeak server.

// Create a new table in the database to store group transfer information
CREATE TABLE group_transfers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    group_id INT NOT NULL,
    teamspeak_server_id INT NOT NULL,
    transferred_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

// Insert a new record into the table when a group is transferred to a Teamspeak server
INSERT INTO group_transfers (group_id, teamspeak_server_id) VALUES (1, 1);

// Query the table to check which groups have been transferred to a specific Teamspeak server
SELECT * FROM group_transfers WHERE teamspeak_server_id = 1;