SWAMPy

✎ CARVE FLESH

EDITING: schema.sql

CREATE TABLE site_settings (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, setting_key VARCHAR(100) NOT NULL UNIQUE, setting_value TEXT NULL, is_public TINYINT(1) NOT NULL DEFAULT 1, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE services (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, slug VARCHAR(160) NOT NULL UNIQUE, name VARCHAR(180) NOT NULL, category VARCHAR(80) NOT NULL, short_description TEXT NULL, description MEDIUMTEXT NULL, sort_order INT NOT NULL DEFAULT 0, status ENUM('draft','published','archived') NOT NULL DEFAULT 'draft', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE projects (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, slug VARCHAR(180) NOT NULL UNIQUE, title VARCHAR(220) NOT NULL, category VARCHAR(80) NOT NULL, summary TEXT NULL, description MEDIUMTEXT NULL, location VARCHAR(180) NULL, cover_media_id BIGINT UNSIGNED NULL, featured TINYINT(1) NOT NULL DEFAULT 0, sort_order INT NOT NULL DEFAULT 0, status ENUM('draft','published','archived') NOT NULL DEFAULT 'draft', deleted_at DATETIME NULL, published_at DATETIME NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX(status,deleted_at));
CREATE TABLE media (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, storage_key VARCHAR(255) NOT NULL UNIQUE, public_url VARCHAR(500) NULL, original_filename VARCHAR(255) NOT NULL, mime_type VARCHAR(100) NOT NULL, file_size BIGINT UNSIGNED NOT NULL, width INT NULL, height INT NULL, checksum_sha256 CHAR(64) NOT NULL, alt_text VARCHAR(500) NULL, caption TEXT NULL, status ENUM('private','public','deleted') NOT NULL DEFAULT 'private', uploaded_by BIGINT UNSIGNED NULL, created_at DATETIME NOT NULL, INDEX(checksum_sha256));
CREATE TABLE project_media (project_id BIGINT UNSIGNED NOT NULL, media_id BIGINT UNSIGNED NOT NULL, sort_order INT NOT NULL DEFAULT 0, is_cover TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY(project_id,media_id));
CREATE TABLE enquiries (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, reference_code VARCHAR(40) NOT NULL UNIQUE, full_name VARCHAR(180) NOT NULL, phone VARCHAR(50) NOT NULL, email VARCHAR(190) NULL, location VARCHAR(180) NOT NULL, service_needed VARCHAR(180) NOT NULL, message TEXT NOT NULL, preferred_contact_method VARCHAR(30) NULL, source_page VARCHAR(255) NULL, status ENUM('new','contacted','in_progress','quoted','won','closed','spam') NOT NULL DEFAULT 'new', assigned_to BIGINT UNSIGNED NULL, consent_at DATETIME NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, closed_at DATETIME NULL, INDEX(status,created_at));
CREATE TABLE admin_users (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, email VARCHAR(190) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, role ENUM('administrator','editor','viewer') NOT NULL DEFAULT 'viewer', status ENUM('active','disabled') NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL);
CREATE TABLE audit_logs (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, admin_user_id BIGINT UNSIGNED NULL, action VARCHAR(120) NOT NULL, entity_type VARCHAR(80) NOT NULL, entity_id VARCHAR(80) NULL, metadata_json JSON NULL, created_at DATETIME NOT NULL, INDEX(created_at));
INSERT INTO site_settings (setting_key,setting_value,is_public) VALUES ('business_name','JILMEK Roofing & Construction Ltd',1),('office_location','Techiman, Bono East Region, Ghana',1),('service_area','Ghana and beyond',1),('primary_phone','0545788758',1);

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📄 001_foundation.sql	SQL	2.1 KB	2026-11-06 10:12	EDIT
📄 002_media_seed.sql	SQL	63.1 KB	2026-11-06 11:41	EDIT
📄 media-manifest.json	JSON	41.7 KB	2026-11-06 11:41	EDIT
📄 schema.sql	SQL	3.5 KB	2026-11-06 10:05	EDIT