20 lines
493 B
SQL
20 lines
493 B
SQL
-- +up
|
|
CREATE TABLE IF NOT EXISTS "posts" (
|
|
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
"userId" INTEGER NOT NULL REFERENCES "users"("id"),
|
|
"title" TEXT NOT NULL,
|
|
"body" TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS "users" (
|
|
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
"email" TEXT NOT NULL UNIQUE,
|
|
"name" TEXT NOT NULL,
|
|
"active" INTEGER NOT NULL DEFAULT 1,
|
|
"createdAt" TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
-- +down
|
|
DROP TABLE IF EXISTS "users";
|
|
DROP TABLE IF EXISTS "posts";
|