CoolFace
Apppublic

starinfolab/codecraft-conductor-wizard

sourceHugging Faceupdated 11mo agoView on Hugging Face
0likes
setup.sql28 linesDownload Raw Back to root
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```