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 | |
| 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'.
| -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)  ); | 
