From 0cceafe1831487c61eaac1d3a71a8d3039a9a5b8 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Sat, 13 May 2017 18:37:40 -0400
Subject: 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'.
---
 schema.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'schema.sql')

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)
 );
-- 
cgit v1.2.3

