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);