MySQL数据库对接说明
此网站已设计完善的MySQL数据库接口，可直接对接使用：
-- 软件分类表
CREATE TABLE categories (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
platform ENUM('android', 'windows', 'ios') NOT NULL,
description TEXT,
icon VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- 软件信息表
CREATE TABLE software (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(200) NOT NULL,
description TEXT,
version VARCHAR(50),
file_size VARCHAR(20),
download_count INT DEFAULT 0,
platform ENUM('android', 'windows', 'ios') NOT NULL,
category_id INT,
download_url VARCHAR(500),
icon_url VARCHAR(500),
rating DECIMAL(3,2) DEFAULT 0.0,
is_featured BOOLEAN DEFAULT FALSE,
is_verified BOOLEAN DEFAULT TRUE,
release_date DATE,
FOREIGN KEY (category_id) REFERENCES categories(id) ON DELETE SET NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- 用户下载记录表
CREATE TABLE downloads (
id INT PRIMARY KEY AUTO_INCREMENT,
software_id INT,
user_ip VARCHAR(45),
user_agent TEXT,
download_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (software_id) REFERENCES software(id) ON DELETE CASCADE
);
API接口示例：
// 获取软件列表API
GET /api/software?platform=android&category=productivity&page=1&limit=10
// 搜索软件API
GET /api/search?q=视频编辑&platform=all
// 下载统计API
POST /api/download/{software_id}