10 lines
486 B
SQL
10 lines
486 B
SQL
CREATE TABLE IF NOT EXISTS `site_content` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`section_key` VARCHAR(100) NOT NULL UNIQUE,
|
|
`section_value` TEXT,
|
|
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- Seed the about section with some default text
|
|
INSERT INTO `site_content` (section_key, section_value) VALUES ('about_me', 'This is the default about me text. You can edit this in the admin panel.') ON DUPLICATE KEY UPDATE section_key=section_key;
|