From 98c18f416a4c809059f4cdf27a833bb9b1134280 Mon Sep 17 00:00:00 2001
From: zotlabs <mike@macgirvin.com>
Date: Wed, 31 May 2017 16:00:33 -0700
Subject: remove default for text/mediumtext sql fields

---
 install/schema_mysql.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 27ee4dda3..4de9c0917 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -36,9 +36,9 @@ CREATE TABLE IF NOT EXISTS `abook` (
   `abook_feed` tinyint(4) NOT NULL DEFAULT '0',
   `abook_not_here` tinyint(4) NOT NULL DEFAULT '0',
   `abook_profile` char(191) NOT NULL DEFAULT '',
-  `abook_incl` TEXT NOT NULL DEFAULT '',
-  `abook_excl` TEXT NOT NULL DEFAULT '',
-  `abook_instance` TEXT NOT NULL DEFAULT '',
+  `abook_incl` TEXT NOT NULL,
+  `abook_excl` TEXT NOT NULL,
+  `abook_instance` TEXT NOT NULL,
   PRIMARY KEY (`abook_id`),
   KEY `abook_account` (`abook_account`),
   KEY `abook_channel` (`abook_channel`),
@@ -114,7 +114,7 @@ CREATE TABLE IF NOT EXISTS `app` (
   `app_sig` char(191) NOT NULL DEFAULT '',
   `app_author` char(191) NOT NULL DEFAULT '',
   `app_name` char(191) NOT NULL DEFAULT '',
-  `app_desc` text NOT NULL DEFAULT '',
+  `app_desc` text NOT NULL,
   `app_url` char(191) NOT NULL DEFAULT '',
   `app_photo` char(191) NOT NULL DEFAULT '',
   `app_version` char(191) NOT NULL DEFAULT '',
@@ -1041,7 +1041,7 @@ CREATE TABLE IF NOT EXISTS `profile` (
   `photo` char(191) NOT NULL DEFAULT '',
   `thumb` char(191) NOT NULL DEFAULT '',
   `publish` tinyint(1) NOT NULL DEFAULT '0',
-  `profile_vcard` text NOT NULL DEFAULT '',
+  `profile_vcard` text NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `guid` (`profile_guid`,`uid`),
   KEY `uid` (`uid`),
@@ -1137,7 +1137,7 @@ CREATE TABLE IF NOT EXISTS `site` (
   `site_type` smallint NOT NULL DEFAULT '0',
   `site_project` char(191) NOT NULL DEFAULT '',
   `site_version` varchar(32) NOT NULL DEFAULT '',
-  `site_crypto` text NOT NULL DEFAULT '',
+  `site_crypto` text NOT NULL,
   PRIMARY KEY (`site_url`),
   KEY `site_flags` (`site_flags`),
   KEY `site_update` (`site_update`),
-- 
cgit v1.2.3

