62 lines
1.7 KiB
PHP
62 lines
1.7 KiB
PHP
<?php
|
|
define('DB_SERVER', 'localhost');
|
|
define('DB_USERNAME', 'root');
|
|
define('DB_PASSWORD', '');
|
|
define('DB_NAME', 'shubraveil_db');
|
|
|
|
$conn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD);
|
|
|
|
if (!$conn) {
|
|
die("Connection failed: " . mysqli_connect_error());
|
|
}
|
|
|
|
// Create database if not exists
|
|
$sql = "CREATE DATABASE IF NOT EXISTS " . DB_NAME;
|
|
if (mysqli_query($conn, $sql)) {
|
|
mysqli_select_db($conn, DB_NAME);
|
|
} else {
|
|
die("Error creating database: " . mysqli_error($conn));
|
|
}
|
|
|
|
// Create tables
|
|
$sql = "CREATE TABLE IF NOT EXISTS users (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
username VARCHAR(50) NOT NULL UNIQUE,
|
|
password VARCHAR(255) NOT NULL,
|
|
email VARCHAR(100) NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
)";
|
|
mysqli_query($conn, $sql);
|
|
|
|
$sql = "CREATE TABLE IF NOT EXISTS products (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
name VARCHAR(100) NOT NULL,
|
|
description TEXT,
|
|
price DECIMAL(10,2),
|
|
image VARCHAR(255),
|
|
category VARCHAR(50),
|
|
product_type ENUM('essential_oils', 'fixed_oils', 'hydrosols', 'natural_cosmetics') NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
)";
|
|
mysqli_query($conn, $sql);
|
|
|
|
$sql = "CREATE TABLE IF NOT EXISTS orders (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
customer_name VARCHAR(100),
|
|
customer_email VARCHAR(100),
|
|
customer_phone VARCHAR(20),
|
|
order_details TEXT,
|
|
status VARCHAR(20),
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
)";
|
|
mysqli_query($conn, $sql);
|
|
|
|
$sql = "CREATE TABLE IF NOT EXISTS settings (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
setting_name VARCHAR(50) NOT NULL UNIQUE,
|
|
setting_value TEXT,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
)";
|
|
mysqli_query($conn, $sql);
|
|
?>
|