22 lines
No EOL
1.1 KiB
SQL
22 lines
No EOL
1.1 KiB
SQL
-- Foundation Database Schema
|
|
|
|
CREATE DATABASE IF NOT EXISTS foundation;
|
|
USE foundation;
|
|
|
|
-- Activities table for the WelcomeScreen module
|
|
CREATE TABLE activities (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
title VARCHAR(255) NOT NULL,
|
|
description TEXT NOT NULL,
|
|
is_read BOOLEAN DEFAULT FALSE,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- Sample data
|
|
INSERT INTO activities (title, description, is_read, created_at) VALUES
|
|
('Welcome to Foundation', 'This is your first activity in the Foundation framework!', false, '2024-01-15 10:00:00'),
|
|
('Framework Architecture', 'The framework follows Domain-Driven Design principles with clean architecture.', false, '2024-01-15 11:30:00'),
|
|
('Module System', 'Each module is self-contained with Application, Domain, and Infrastructure layers.', true, '2024-01-15 12:15:00'),
|
|
('API Endpoints', 'RESTful API endpoints are available for all major operations.', false, '2024-01-15 14:20:00'),
|
|
('Database Integration', 'The framework uses PDO with prepared statements for secure database operations.', true, '2024-01-15 15:45:00'); |