19 lines
682 B
SQL
19 lines
682 B
SQL
-- Create posts table for Blog
|
|
CREATE TABLE IF NOT EXISTS `posts` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`title` VARCHAR(255) NOT NULL,
|
|
`slug` VARCHAR(255) NOT NULL UNIQUE,
|
|
`content` TEXT NOT NULL,
|
|
`image_path` VARCHAR(255) DEFAULT NULL,
|
|
`status` ENUM('published', 'draft') DEFAULT 'published',
|
|
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- Add Social Media Settings
|
|
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES
|
|
('facebook_url', ''),
|
|
('twitter_url', ''),
|
|
('instagram_url', ''),
|
|
('github_url', '');
|