Dashboard

Lokasi: /home / u109751622 / domains / tallypointgorakhpur.com / public_html /

Ubah: schema.sql

-- schema.sql
CREATE DATABASE IF NOT EXISTS website_management CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE website_management;

CREATE TABLE IF NOT EXISTS admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS pages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    page_name VARCHAR(50) UNIQUE,
    content MEDIUMTEXT,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS courses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(150) NOT NULL,
    description MEDIUMTEXT,
    duration VARCHAR(50),
    fee DECIMAL(10,2) DEFAULT 0
);

CREATE TABLE IF NOT EXISTS notices (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(200) NOT NULL,
    content MEDIUMTEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(120) NOT NULL,
    roll_no VARCHAR(60) UNIQUE NOT NULL,
    course VARCHAR(120),
    verified TINYINT(1) DEFAULT 0
);

CREATE TABLE IF NOT EXISTS gallery (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image_path VARCHAR(255) NOT NULL,
    caption VARCHAR(200),
    uploaded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Seed default pages
INSERT IGNORE INTO pages(page_name, content) VALUES
('home', '<div class="p-5 bg-light rounded-3"><h1>Welcome to My Institute</h1><p class="lead">Edit this home page from the admin panel.</p></div>'),
('about', '<h2>About Us</h2><p>Write about your institute here.</p>'),
('contact', '<h2>Contact Us</h2><p>Email: info@example.com<br>Phone: +91-00000-00000</p>');

Batal