9 lines
235 B
SQL
9 lines
235 B
SQL
|
CREATE TABLE lead_notes (
|
||
|
|
id TEXT PRIMARY KEY,
|
||
|
|
owner TEXT NOT NULL REFERENCES users(login),
|
||
|
|
text TEXT NOT NULL,
|
||
|
|
created_at TEXT NOT NULL,
|
||
|
|
updated_at TEXT NOT NULL
|
||
|
|
);
|
||
|
|
CREATE INDEX lead_notes_owner ON lead_notes(owner, created_at);
|