mirror of
https://github.com/l0ng-ai/openidea.git
synced 2026-11-06 08:07:49 +00:00
17 lines
463 B
SQL
17 lines
463 B
SQL
CREATE TABLE users (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
email TEXT NOT NULL UNIQUE,
|
|
name TEXT NOT NULL,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|
|
|
|
CREATE TABLE notes (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
user_id BIGINT NOT NULL REFERENCES users (id) ON DELETE CASCADE,
|
|
title TEXT NOT NULL,
|
|
body TEXT NOT NULL DEFAULT ''
|
|
);
|
|
|
|
-- TODO: full-text index on notes.body
|
|
CREATE INDEX notes_user_id_idx ON notes (user_id);
|