Project.Fengling.QoderVersion/Backend/scripts/mysql-init/01-init.sql
sam e24925e1ed chore(build): 添加基础构建配置和版本管理
- 新增 .dockerignore 文件,忽略多种临时及中间文件
- 新增 .gitattributes 文件,配置文本文件换行及合并行为
- 新增详细的 .gitignore 文件,排除多种开发及生成文件
- 新增 VS Code C# 代码片段,提升开发效率
- 添加 Directory.Build.props,统一 MSBuild 配置和代码分析规则
- 添加空的 Directory.Build.targets,预留构建任务扩展位置
- 添加 Directory.Packages.props,实现依赖包版本集中管理和声明
2026-02-11 12:58:54 +08:00

18 lines
772 B
SQL

-- MySQL Initialization Script for NetCorePal Template
-- This script creates the necessary database and user for development
-- Create development database if it doesn't exist
CREATE DATABASE IF NOT EXISTS `abctemplate` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- Create a development user (optional - you can use root for development)
-- CREATE USER IF NOT EXISTS 'devuser'@'%' IDENTIFIED BY 'devpass123';
-- GRANT ALL PRIVILEGES ON `abctemplate`.* TO 'devuser'@'%';
-- Ensure root can connect from any host (for development only)
-- ALTER USER 'root'@'%' IDENTIFIED BY '123456';
-- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
-- Display completion message
SELECT 'MySQL initialization completed successfully' AS message;