Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/wwwroot/china-democracyparty.com/2/sql/

View File Name : schema.sql

-- sql/schema.sql
-- Create database (run manually if needed)
-- CREATE DATABASE cfd_site CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS admins(
  id INT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(190) UNIQUE NOT NULL,
  password_hash VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS posts(
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  slug VARCHAR(200) UNIQUE NOT NULL,
  excerpt TEXT,
  content MEDIUMTEXT,
  is_published TINYINT(1) DEFAULT 0,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS pages(
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  slug VARCHAR(200) UNIQUE NOT NULL,
  content MEDIUMTEXT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS settings(
  id INT AUTO_INCREMENT PRIMARY KEY,
  site_name VARCHAR(255) NOT NULL,
  hero_text TEXT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Seed an admin (email: admin@example.com / password: admin123) - change immediately after login
INSERT INTO admins(email, password_hash)
VALUES ('admin@example.com', '$2y$10$7eD45n7rB6VRk4R9bI6/..8JcHn8nH0uJYQe8yH1r1hXq8m9Kx5H2')
ON DUPLICATE KEY UPDATE email=email;

-- Seed basic pages
INSERT INTO pages(title, slug, content) VALUES
('关于我们','about','<p>我们倡导自由、民主、法治与人权，致力于推动公民社会建设。</p>')
ON DUPLICATE KEY UPDATE slug=slug;

INSERT INTO pages(title, slug, content) VALUES
('组织章程','charter','<p>此处为组织章程内容示例，您可以在后台修改。</p>')
ON DUPLICATE KEY UPDATE slug=slug;

INSERT INTO pages(title, slug, content) VALUES
('加入我们','join','<p>欢迎志同道合的朋友共同推进自由与民主事业，请通过邮箱联系我们。</p>')
ON DUPLICATE KEY UPDATE slug=slug;

INSERT INTO pages(title, slug, content) VALUES
('联系我们','contact','<p>联系邮箱：contact@example.com</p>')
ON DUPLICATE KEY UPDATE slug=slug;

INSERT INTO pages(title, slug, content) VALUES
('隐私政策','privacy','<p>站点基础隐私说明示例，您可在后台进行编辑完善。</p>')
ON DUPLICATE KEY UPDATE slug=slug;

INSERT INTO settings(site_name, hero_text) VALUES
('中国自由民主','推动自由、民主、法治与人权。')
ON DUPLICATE KEY UPDATE site_name=site_name;