TABLE tracks ( id UUID PRIMARY KEY, mixtape_id UUID REFERENCES mixtapes(id), title VARCHAR NOT NULL, duration INT, -- seconds order_index INT, mp3_url VARCHAR, preview_url VARCHAR, checksum_sha256 VARCHAR, created_at TIMESTAMP );
TABLE ratings ( id UUID PRIMARY KEY, user_id UUID, mixtape_id UUID, rating SMALLINT CHECK (rating BETWEEN 1 AND 5), created_at TIMESTAMP ); | Method | Endpoint | Description | Auth | |--------|----------|-------------|------| | GET | /api/v1/mixtapes?artist=pericoma-okoye&search=... | List mixtapes with pagination & filters. | Public | | GET | /api/v1/mixtapes/id | Mixtape details + track list. | Public | | GET | /api/v1/tracks/id/preview | Return signed preview URL (30 s). | Public | | GET | /api/v1/tracks/id/download | Return signed MP3 URL (expires 24 h). | Bearer | | GET | /api/v1/mixtapes/id/download | Return signed ZIP URL for full mixtape. | Bearer | | POST | /api/v1/ratings | Submit rating. | Bearer | | POST | /api/v1/comments | Post comment. | Bearer | | POST | /admin/api/v1/mixtapes | Create new mixtape (multipart form). | Admin JWT | | GET | /admin/api/v1/analytics/downloads | CSV of download logs. | Admin JWT | Download Pericoma Okoye Mixtapes amp- DJ Mix Mp3 Songs
TABLE mixtapes ( id UUID PRIMARY KEY, artist_id UUID REFERENCES artists(id), title VARCHAR NOT NULL, cover_url VARCHAR, release_year INT, genre VARCHAR, total_duration INT, -- seconds description TEXT, status ENUM('draft','published','archived') DEFAULT 'draft', created_at TIMESTAMP, updated_at TIMESTAMP ); TABLE tracks ( id UUID PRIMARY KEY, mixtape_id
TABLE tracks ( id UUID PRIMARY KEY, mixtape_id UUID REFERENCES mixtapes(id), title VARCHAR NOT NULL, duration INT, -- seconds order_index INT, mp3_url VARCHAR, preview_url VARCHAR, checksum_sha256 VARCHAR, created_at TIMESTAMP );
TABLE ratings ( id UUID PRIMARY KEY, user_id UUID, mixtape_id UUID, rating SMALLINT CHECK (rating BETWEEN 1 AND 5), created_at TIMESTAMP ); | Method | Endpoint | Description | Auth | |--------|----------|-------------|------| | GET | /api/v1/mixtapes?artist=pericoma-okoye&search=... | List mixtapes with pagination & filters. | Public | | GET | /api/v1/mixtapes/id | Mixtape details + track list. | Public | | GET | /api/v1/tracks/id/preview | Return signed preview URL (30 s). | Public | | GET | /api/v1/tracks/id/download | Return signed MP3 URL (expires 24 h). | Bearer | | GET | /api/v1/mixtapes/id/download | Return signed ZIP URL for full mixtape. | Bearer | | POST | /api/v1/ratings | Submit rating. | Bearer | | POST | /api/v1/comments | Post comment. | Bearer | | POST | /admin/api/v1/mixtapes | Create new mixtape (multipart form). | Admin JWT | | GET | /admin/api/v1/analytics/downloads | CSV of download logs. | Admin JWT |
TABLE mixtapes ( id UUID PRIMARY KEY, artist_id UUID REFERENCES artists(id), title VARCHAR NOT NULL, cover_url VARCHAR, release_year INT, genre VARCHAR, total_duration INT, -- seconds description TEXT, status ENUM('draft','published','archived') DEFAULT 'draft', created_at TIMESTAMP, updated_at TIMESTAMP );
鸣谢：感谢各模拟器作者为广大经典游戏爱好者所付出的汗水和贡献；小鸡工作室尊重各模拟器作者劳动成果，所有模拟器版权归原作者所有，小鸡工作室将在以后的新版本中注明所引用模拟器! 特别感谢以下软件及作者为小鸡模拟器提供的帮助及技术支持！
