diff options
author | Malf Furious <m@lfurio.us> | 2017-05-13 18:37:40 -0400 |
---|---|---|
committer | Malf Furious <m@lfurio.us> | 2017-05-13 18:37:40 -0400 |
commit | 0cceafe1831487c61eaac1d3a71a8d3039a9a5b8 (patch) | |
tree | a70c3bc525df54327ffec9af148f64d956c3bfce /schema.sql | |
parent | d7442e00b8ee277938adaca3b83f814e0d67b432 (diff) | |
download | scrott-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 '')
-rw-r--r-- | schema.sql | 3 |
1 files changed, 1 insertions, 2 deletions
@@ -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) ); |