编辑代码

CREATE DATABASE IF NOT EXISTS otc_merchant;
USE otc_merchant;

CREATE TABLE `merchants` (
  `id` INT PRIMARY KEY AUTO_INCREMENT,
  `name` VARCHAR(50) NOT NULL,
  `bio` VARCHAR(255) DEFAULT '专业数字资产交易商',
  `price` DECIMAL(10,2) NOT NULL,
  `avatar` VARCHAR(255) DEFAULT 'default_avatar.png',
  `link` VARCHAR(255) DEFAULT '#',
  `status` TINYINT DEFAULT 1,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 插入测试数据
INSERT INTO `merchants` (name, price, avatar) VALUES
('认证商户01', 7.04, 'avatar1.jpg'),
('认证商户02', 7.05, 'avatar2.jpg'),
...
('认证商户08', 7.12, 'avatar8.jpg');

-- 管理员表
CREATE TABLE `admin` (
  `id` INT PRIMARY KEY AUTO_INCREMENT,
  `username` VARCHAR(50) NOT NULL,
  `password` VARCHAR(255) NOT NULL
);

-- 设置管理员账号[6](@ref)
INSERT INTO `admin` (username, password) 
VALUES ('admin', SHA2('admin', 256));