Datenbank name : db_376260_21
MySQL-Server/Host (lokal): 	localhost
MySQL-Server/Host (extern): 	cityschnegge.lima-db.de
Port:	3306
Benutzername:	USER376260_mutch
Passwort:	Mutchatcho1608+

------------------------------------------------------------------------
Charts abstimmen 

Das in SQL Datenbank auf lima

CREATE TABLE songs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);


CREATE TABLE votes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    song_id INT NOT NULL,
    FOREIGN KEY (song_id) REFERENCES songs(id) ON DELETE CASCADE
);
CREATE INDEX ip_vote_index ON votes (ip_address, vote_time);
ALTER TABLE votes ADD COLUMN ip_address VARCHAR(45);
ALTER TABLE votes ADD COLUMN vote_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP;