| wuchimedes | 079c163 | 2025-04-02 22:01:20 +0800 | [diff] [blame] | 1 | CREATE TABLE IF NOT EXISTS `users` ( |
| 2 | user_id INT AUTO_INCREMENT PRIMARY KEY, |
| 3 | user_name VARCHAR(255) NOT NULL, |
| 4 | password VARCHAR(255) NOT NULL, |
| 5 | email VARCHAR(255) NOT NULL UNIQUE |
| 6 | ); |
| 7 | |
| 8 | CREATE TABLE IF NOT EXISTS `torrents` ( |
| 9 | torrent_id INT AUTO_INCREMENT PRIMARY KEY, |
| 10 | user_id INT NOT NULL, |
| 11 | torrent_name VARCHAR(255) NOT NULL, |
| 12 | info_hash VARCHAR(255) NOT NULL, |
| 13 | file_size FLOAT NOT NULL, |
| 14 | created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, |
| 15 | FOREIGN KEY (user_id) REFERENCES users(user_id) |
| 16 | ); |
| 17 | |
| 18 | CREATE TABLE IF NOT EXISTS `peers` ( |
| 19 | user_id INT NOT NULL, |
| 20 | torrent_id INT NOT NULL, |
| 21 | peer_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 22 | ip_address VARCHAR(128) NOT NULL, |
| 23 | port INT NOT NULL, |
| 24 | uploaded FLOAT NOT NULL, |
| 25 | downloaded FLOAT NOT NULL, |
| 26 | FOREIGN KEY (user_id) REFERENCES users(user_id), |
| 27 | FOREIGN KEY (torrent_id) REFERENCES torrents(torrent_id) |
| 28 | ); |