summaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
authorMalf Furious <m@lfurio.us>2017-05-13 18:37:40 -0400
committerMalf Furious <m@lfurio.us>2017-05-13 18:37:40 -0400
commit0cceafe1831487c61eaac1d3a71a8d3039a9a5b8 (patch)
treea70c3bc525df54327ffec9af148f64d956c3bfce /schema.sql
parentd7442e00b8ee277938adaca3b83f814e0d67b432 (diff)
downloadscrott-0cceafe1831487c61eaac1d3a71a8d3039a9a5b8.tar.gz
scrott-0cceafe1831487c61eaac1d3a71a8d3039a9a5b8.zip
Remove mime-type field from message database schema
Since the df.php script can detect the mime-type of files on disk, I am removing this state from the database. With 'attachName' being the only remaining field pertaining to attachments, I have simply renamed it 'attachment'.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/schema.sql b/schema.sql
index 9b50f7a..ef11886 100644
--- a/schema.sql
+++ b/schema.sql
@@ -196,8 +196,7 @@ CREATE TABLE mesgs (
guid varchar(8) NOT NULL,
author varchar(8) NOT NULL,
mesg text NOT NULL DEFAULT '',
- attachName varchar(64) NOT NULL DEFAULT '',
- attachMime varchar(64) NOT NULL DEFAULT '',
+ attachment varchar(64) NOT NULL,
PRIMARY KEY (guid)
);