starinfolab/codecraft-conductor-wizard
0
1```sql2-- Create database3CREATE DATABASE IF NOT EXISTS portfolio_db;4 5-- Use database6USE portfolio_db;7 8-- Admin users table9CREATE TABLE IF NOT EXISTS admin_users (10 id INT AUTO_INCREMENT PRIMARY KEY,11 username VARCHAR(50) NOT NULL UNIQUE,12 password VARCHAR(255) NOT NULL,13 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP14);15 16-- Contact submissions table17CREATE TABLE IF NOT EXISTS contact_submissions (18 id INT AUTO_INCREMENT PRIMARY KEY,19 name VARCHAR(100) NOT NULL,20 email VARCHAR(100) NOT NULL,21 message TEXT NOT NULL,22 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP23);24 25-- Insert default admin user (password: admin123)26INSERT INTO admin_users (username, password) 27VALUES ('admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi');28```