# video-maker-admin

**Repository Path**: wucheng/video-maker-admin

## Basic Information

- **Project Name**: video-maker-admin
- **Description**: ai剪辑工具
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-07-21
- **Last Updated**: 2025-10-17

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

安装mysql
docker run -d --name some-mysql --restart=always -v /data/mysql:/var/lib/mysql -v /data/mysql.cnf:/etc/mysql/conf.d/mysql.cnf -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root mysql:5.7
安装redis
docker run -d --name my-redis --restart=always -p 6379:6379 redis:latest

```bash
# 创建数据库
# root root
docker exec -it mysql bash
mysql -u root -p
CREATE DATABASE `video-maker`;
```

```sql
-- 创建数据表
CREATE TABLE IF NOT EXISTS `music` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `name` varchar(255) NOT NULL COMMENT '音乐名称',
    `url` varchar(512) NOT NULL COMMENT '音乐文件地址',
    `package_id` INT NULL COMMENT '所属音乐包ID',
    `update_time` datetime NOT NULL COMMENT '更新时间',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`),
    INDEX idx_package_id (package_id),
    FOREIGN KEY (package_id) REFERENCES music_package(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='音乐表';

CREATE TABLE IF NOT EXISTS `template` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `name` varchar(255) NOT NULL COMMENT '模板名称',
    `detail` text NOT NULL COMMENT '模板配置',
    `package_id` INT NULL COMMENT '所属音乐包ID',
    `update_time` datetime NOT NULL COMMENT '更新时间',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`),
    INDEX idx_package_id (package_id),
    FOREIGN KEY (package_id) REFERENCES music_package(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='模板表';

CREATE TABLE IF NOT EXISTS `user` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `name` varchar(255) NOT NULL COMMENT '用户名',
    `pass` varchar(255) NOT NULL COMMENT '密码',
    `times` int(11) NOT NULL COMMENT '剩余次数',
    `update_time` datetime NOT NULL COMMENT '更新时间',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';


-- v2.0 更新
CREATE TABLE music_package (
   `id` INT PRIMARY KEY AUTO_INCREMENT COMMENT '音乐包ID',
   `name` VARCHAR(255) NOT NULL COMMENT '音乐包名称',
   `description` TEXT COMMENT '音乐包描述',
   `cover_image` VARCHAR(500) COMMENT '封面图片URL',
   `is_deleted` TINYINT DEFAULT 0 COMMENT '是否删除：0-否，1-是',
   `update_time` datetime NOT NULL COMMENT '更新时间',
   `create_time` datetime NOT NULL COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='音乐包表';

-- 模板表追加package_id字段
ALTER TABLE `template`
ADD COLUMN `package_id` INT(11) NULL COMMENT '所属音乐包ID' AFTER `detail`,
ADD INDEX `idx_package_id` (`package_id`),
ADD CONSTRAINT `fk_template_package_id` 
FOREIGN KEY (`package_id`) REFERENCES `music_package` (`id`) 
ON DELETE SET NULL;


ALTER TABLE `music`
ADD COLUMN `package_id` INT(11) NULL COMMENT '所属音乐包ID',
ADD INDEX `idx_package_id` (`package_id`),
ADD CONSTRAINT `fk_music_package_id` 
FOREIGN KEY (`package_id`) REFERENCES `music_package` (`id`) 
ON DELETE SET NULL;
          
          
-- 音色表
CREATE TABLE IF NOT EXISTS `voice` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `name` varchar(255) NOT NULL COMMENT '音色名称',
    `workflow_id` varchar(255) NOT NULL COMMENT '音色workflowId',
    `update_time` datetime NOT NULL COMMENT '更新时间',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='音色表';

```

启动服务（线上）
NODE_ENV=online node index.js