Update tests/sqlite/setup.sql to match current tests.
-- https://github.com/prisma/database-schema-examples/tree/master/postgres/basic-twitter#basic-twitter
-CREATE TABLE tweet
-(
+CREATE TABLE tweet (
id BIGINT NOT NULL PRIMARY KEY,
text TEXT NOT NULL,
is_sent BOOLEAN NOT NULL DEFAULT TRUE,
owner_id BIGINT
);
-
-insert into tweet(id, text, owner_id) values (1, '#sqlx is pretty cool!', 1);
+INSERT INTO tweet(id, text, owner_id)
+VALUES (1, '#sqlx is pretty cool!', 1);
+--
+CREATE TABLE accounts (
+ id INTEGER NOT NULL PRIMARY KEY,
+ name TEXT NOT NULL,
+ is_active BOOLEAN
+);
+INSERT INTO accounts(id, name, is_active)
+VALUES (1, 'Herp Derpinson', 1);
+CREATE VIEW accounts_view as
+SELECT *
+FROM accounts;
