Open History to see the last commit
1-- Schema for a simple to-do list
2CREATE TABLE IF NOT EXISTS todos (
3 id SERIAL PRIMARY KEY,
4 title VARCHAR(255) NOT NULL,
5 description TEXT,
6 is_completed BOOLEAN DEFAULT FALSE,
7 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
8);
9
10-- Initial data for the to-do list
11INSERT INTO todos (title, description, is_completed) VALUES
12('Buy groceries', 'Milk, Bread, Eggs, and Butter', FALSE),
13('Read a book', 'Finish reading "The Great Gatsby"', FALSE),
14('Workout', 'Go for a 30-minute run', FALSE);