🤩 File Manager - Mr.X
PHP:
8.3.33
Server:
Apache
OS:
Linux 5.14.0-611.49.1.el9_7.x86_64
User:
websparkit
Navigate
Upload:
Upload
New File
New Folder
Editing:schema.sql
-- Admin Table CREATE TABLE IF NOT EXISTS admin ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, email VARCHAR(100) NOT NULL UNIQUE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Employers Table CREATE TABLE IF NOT EXISTS employers ( id INT AUTO_INCREMENT PRIMARY KEY, company_name VARCHAR(255) NOT NULL, email VARCHAR(100) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, contact_no VARCHAR(20), website VARCHAR(255), logo VARCHAR(255), address TEXT, description TEXT, status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Categories Table CREATE TABLE IF NOT EXISTS categories ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL UNIQUE, icon VARCHAR(50), -- Bootstrap icon class slug VARCHAR(100) NOT NULL UNIQUE ); -- Jobs Table CREATE TABLE IF NOT EXISTS jobs ( id INT AUTO_INCREMENT PRIMARY KEY, employer_id INT NOT NULL, category_id INT NULL, title VARCHAR(255) NOT NULL, description TEXT NOT NULL, job_image VARCHAR(255) DEFAULT NULL, location VARCHAR(255) NOT NULL, job_type ENUM('Full-time', 'Part-time', 'Contract', 'Freelance') NOT NULL, salary_range VARCHAR(100), experience_required VARCHAR(100), closing_date DATE, is_featured BOOLEAN DEFAULT FALSE, status ENUM('pending', 'active', 'expired', 'rejected') DEFAULT 'pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (employer_id) REFERENCES employers(id) ON DELETE CASCADE, FOREIGN KEY (category_id) REFERENCES categories(id) ON DELETE SET NULL ); -- Job Applications Table CREATE TABLE IF NOT EXISTS job_applications ( id INT AUTO_INCREMENT PRIMARY KEY, job_id INT NOT NULL, candidate_name VARCHAR(255) NOT NULL, candidate_email VARCHAR(100) NOT NULL, candidate_phone VARCHAR(20), cv_path VARCHAR(255), details TEXT, status ENUM('pending', 'reviewed', 'shortlisted', 'rejected') DEFAULT 'pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (job_id) REFERENCES jobs(id) ON DELETE CASCADE ); -- Candidates Table CREATE TABLE IF NOT EXISTS candidates ( id INT AUTO_INCREMENT PRIMARY KEY, full_name VARCHAR(255) NOT NULL, email VARCHAR(100) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, contact_no VARCHAR(20), cv_path VARCHAR(255), cv_status ENUM('none', 'pending', 'approved', 'rejected') DEFAULT 'none', status ENUM('active', 'inactive') DEFAULT 'active', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Website Settings CREATE TABLE IF NOT EXISTS website_settings ( id INT PRIMARY KEY, site_name VARCHAR(100), site_logo VARCHAR(255), contact_email VARCHAR(100), contact_phone VARCHAR(20), address TEXT, facebook_url VARCHAR(255), twitter_url VARCHAR(255), linkedin_url VARCHAR(255) ); -- Insert Sample Data INSERT INTO admin (username, password, email) VALUES ('admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin@jobly.lk.com'); -- password is 'password' INSERT INTO categories (name, icon, slug) VALUES ('Information Technology', 'bi-laptop', 'it'), ('Accounting / Finance', 'bi-calculator', 'accounting'), ('Engineering', 'bi-gear', 'engineering'), ('Marketing / Sales', 'bi-megaphone', 'marketing'), ('Human Resources', 'bi-people', 'hr'); INSERT INTO website_settings (id, site_name, site_logo, contact_email) VALUES (1, 'jobly.lk', 'logo.png', 'info@jobly.lk.com');
Save Changes
Cancel
Create New File
Create New Folder