summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMalf Furious <m@lfurio.us>2017-06-04 00:58:46 -0400
committerMalf Furious <m@lfurio.us>2017-06-04 00:58:46 -0400
commit5b4b55138cce42146ffe9cd355f1584248589d26 (patch)
tree1792a6793e4577772c824660dc0a8beebc67dc5d
parent8a953ee675016cce21a36f04bad0312f3d0b3834 (diff)
downloadscrott-5b4b55138cce42146ffe9cd355f1584248589d26.tar.gz
scrott-5b4b55138cce42146ffe9cd355f1584248589d26.zip
schema.sql: Set default value for mesg attachments
Defaulting this field to the empty string since, by default, messages do not have attachments.
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/schema.sql b/schema.sql
index 286634c..7587578 100644
--- a/schema.sql
+++ b/schema.sql
@@ -196,7 +196,7 @@ CREATE TABLE mesgs (
guid varchar(8) NOT NULL,
author varchar(8) NOT NULL,
mesg text NOT NULL DEFAULT '',
- attachment varchar(64) NOT NULL,
+ attachment varchar(64) NOT NULL DEFAULT '',
PRIMARY KEY (guid)
);