CREATE DATABASE service_panel;

USE service_panel;

CREATE TABLE admins(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(100),
password VARCHAR(255)
);

INSERT INTO admins(username,password)
VALUES('admin','123456');

CREATE TABLE users(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
phone VARCHAR(20),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE services(
id INT AUTO_INCREMENT PRIMARY KEY,
service_name VARCHAR(100),
price VARCHAR(50),
status VARCHAR(50)
);

CREATE TABLE orders(
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
service_id INT,
status VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);