10 lines
282 B
SQL
10 lines
282 B
SQL
DROP TABLE IF EXISTS bug_notes;
|
|
CREATE TABLE bug_notes (
|
|
id INTEGER PRIMARY KEY,
|
|
bug_id INTEGER NOT NULL DEFAULT 0,
|
|
note TEXT,
|
|
author TEXT NOT NULL DEFAULT '',
|
|
note_date INTEGER NOT NULL DEFAULT 0
|
|
);
|
|
CREATE INDEX idx_bug_notes_bug_id ON bug_notes(bug_id);
|