diff options
| -rw-r--r-- | sql/dawn.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index fc01d1bd..343f0267 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -148,6 +148,7 @@ CREATE TABLE bonds(id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY, current_face float, allocated boolean NOT NULL DEFAULT false, stale bool NOT NULL DEFAULT true, + emailed bool NULL DEFAULT false, CONSTRAINT bonds_check CHECK (cusip IS NOT NULL OR isin IS NOT NULL)); |