From 8a953ee675016cce21a36f04bad0312f3d0b3834 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Sun, 4 Jun 2017 00:55:30 -0400
Subject: schema.sql: Rename objtype for messages

Renamed from 'message' to 'mesg', for consistency with other naming
conventions.
---
 schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index ef11886..286634c 100644
--- a/schema.sql
+++ b/schema.sql
@@ -114,7 +114,7 @@ CREATE TABLE objects (
                     'pad',
                     'stage',
                     'issue',
-                    'message',
+                    'mesg',
                     'log'
                 )                   NOT NULL,
 
-- 
cgit v1.2.3


From 5b4b55138cce42146ffe9cd355f1584248589d26 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Sun, 4 Jun 2017 00:58:46 -0400
Subject: schema.sql: Set default value for mesg attachments

Defaulting this field to the empty string since, by default, messages do
not have attachments.
---
 schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema.sql')

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

