"""
FreeFlow DB 스키마 생성 스크립트
MySQL 서버에 freeflow 스키마를 생성합니다.
"""
import mysql.connector

DB_CONFIG = {
    'host': 'officialsite.kr',
    'port': 23306,
    'user': 'admin',
    'password': 'dlgks~123',
}

def main():
    conn = mysql.connector.connect(**DB_CONFIG)
    cursor = conn.cursor()

    cursor.execute("CREATE DATABASE IF NOT EXISTS freeflow CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci")
    print("✅ Database 'freeflow' created (or already exists)")

    cursor.execute("SHOW DATABASES LIKE 'freeflow'")
    result = cursor.fetchone()
    if result:
        print(f"✅ Verified: {result[0]}")

    cursor.close()
    conn.close()

if __name__ == '__main__':
    main()