test/example-3/0002-add-todos.sql @ 99142dcb072d
Add simple test suite
author |
Steve Losh <steve@stevelosh.com> |
date |
Tue, 09 Apr 2024 14:01:57 -0400 |
parents |
6b27e5b734d8 |
children |
(none) |
CREATE TABLE todos (
id INTEGER PRIMARY KEY,
user_id INTEGER NOT NULL,
done BOOLEAN NOT NULL,
content TEXT,
FOREIGN KEY (user_id) REFERENCES users(id)
);
INSERT INTO todos (id, user_id, content, done) VALUES (0, 0, 'Write DBvolve skeleton.', TRUE);
INSERT INTO todos (id, user_id, content, done) VALUES (1, 0, 'Write DBvolve test suite.', FALSE);