29 lines
1.0 KiB
SQL
29 lines
1.0 KiB
SQL
-- ==============================================================================
|
|
-- AGHATIS STUDIO - ADMIN USERS SCHEMA & SEED DATA
|
|
-- Database: aghatis_studio_db
|
|
-- ==============================================================================
|
|
|
|
CREATE TABLE IF NOT EXISTS admin_users (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
username VARCHAR(50) UNIQUE NOT NULL,
|
|
password_hash VARCHAR(255) NOT NULL,
|
|
full_name VARCHAR(100) DEFAULT 'Aghatis Admin',
|
|
role VARCHAR(50) DEFAULT 'admin',
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- Seed Initial Admin User:
|
|
-- Username: Aghatis
|
|
-- Password: @Arya654321 (stored as secure bcrypt hash)
|
|
INSERT INTO admin_users (username, password_hash, full_name, role)
|
|
VALUES (
|
|
'Aghatis',
|
|
'$2b$10$O6c/yR.Nx5sNpvBUAHsIOOR8QWsUXFxj7vlspfFaEw3Zii2iUaRMm',
|
|
'Aghatis Commander',
|
|
'superadmin'
|
|
)
|
|
ON DUPLICATE KEY UPDATE
|
|
password_hash = VALUES(password_hash),
|
|
updated_at = CURRENT_TIMESTAMP;
|