Welcome to the only README file for the HardSurface website. Though the project is still in development, the website still meets the basic CRUD requirements.
Resources used:
- Bootstrap (Locally installed)
- Bootstrap Admin template
- Fontawesome icons (locally installed)
SQL code that you will need:
Admin table:
CREATE TABLE admins (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO admins (name, password)
VALUES ('Admin', 'IAmAdmin');
Login/Signup table:
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
status TINYINT DEFAULT 1,
last_active DATETIME DEFAULT NULL
);
Uploads table:
CREATE TABLE uploads (
id INT AUTO_INCREMENT PRIMARY KEY,
image_path VARCHAR(255) NOT NULL,
title VARCHAR(255) NOT NULL,
description TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
uploaded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Comments/Messages table: CREATE TABLE contact_messages ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, subject VARCHAR(255) NOT NULL, message TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
If there are any issues found during the creation of the database or want to contact me, here is my contact information. Email: [email protected] Whatsapp Number: +234 809 111 2033