init-databases.sql

-- Database Initialization Script for Cherry FastFood System
-- This script creates all required databases for the microservices

-- Create databases if they don't exist
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'Cherry_Auth')
BEGIN
    CREATE DATABASE Cherry_Auth;
    PRINT 'Database Cherry_Auth created successfully.';
END
ELSE
BEGIN
    PRINT 'Database Cherry_Auth already exists.';
END

IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'Cherry_Product')
BEGIN
    CREATE DATABASE Cherry_Product;
    PRINT 'Database Cherry_Product created successfully.';
END
ELSE
BEGIN
    PRINT 'Database Cherry_Product already exists.';
END

IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'Cherry_Coupon')
BEGIN
    CREATE DATABASE Cherry_Coupon;
    PRINT 'Database Cherry_Coupon created successfully.';
END
ELSE
BEGIN
    PRINT 'Database Cherry_Coupon already exists.';
END

IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'Cherry_ShoppingCart')
BEGIN
    CREATE DATABASE Cherry_ShoppingCart;
    PRINT 'Database Cherry_ShoppingCart created successfully.';
END
ELSE
BEGIN
    PRINT 'Database Cherry_ShoppingCart already exists.';
END

IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'Cherry_Order')
BEGIN
    CREATE DATABASE Cherry_Order;
    PRINT 'Database Cherry_Order created successfully.';
END
ELSE
BEGIN
    PRINT 'Database Cherry_Order already exists.';
END

IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'Cherry_Email')
BEGIN
    CREATE DATABASE Cherry_Email;
    PRINT 'Database Cherry_Email created successfully.';
END
ELSE
BEGIN
    PRINT 'Database Cherry_Email already exists.';
END

IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'Cherry_Reward')
BEGIN
    CREATE DATABASE Cherry_Reward;
    PRINT 'Database Cherry_Reward created successfully.';
END
ELSE
BEGIN
    PRINT 'Database Cherry_Reward already exists.';
END

PRINT 'All databases initialization completed!';