aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorManuel Tancoigne <m.tancoigne@gmail.com>2017-06-06 19:42:10 +0200
committerMario Vavti <mario@mariovavti.com>2017-06-07 10:20:02 +0200
commita17acfb04f9a97e575839eefbd5f46f020c3a589 (patch)
tree61748b57e4a6f7de01e21add3528a31d77cf6442
parent79e618415af23d21c7f66c57fae143b5b4875c2c (diff)
downloadvolse-hubzilla-a17acfb04f9a97e575839eefbd5f46f020c3a589.tar.gz
volse-hubzilla-a17acfb04f9a97e575839eefbd5f46f020c3a589.tar.bz2
volse-hubzilla-a17acfb04f9a97e575839eefbd5f46f020c3a589.zip
Fixed TEXT fields with default values (fixes #803) in mysql creation script.
-rw-r--r--install/schema_mysql.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 4f5b180ad..f46d344de 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(64) 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`),
@@ -116,7 +116,7 @@ CREATE TABLE IF NOT EXISTS `app` (
`app_sig` char(255) NOT NULL DEFAULT '',
`app_author` char(255) NOT NULL DEFAULT '',
`app_name` char(255) NOT NULL DEFAULT '',
- `app_desc` text NOT NULL DEFAULT '',
+ `app_desc` text NOT NULL,
`app_url` char(255) NOT NULL DEFAULT '',
`app_photo` char(255) NOT NULL DEFAULT '',
`app_version` char(255) NOT NULL DEFAULT '',
@@ -1067,7 +1067,7 @@ CREATE TABLE IF NOT EXISTS `profile` (
`photo` char(255) NOT NULL DEFAULT '',
`thumb` char(255) 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`),
@@ -1163,7 +1163,7 @@ CREATE TABLE IF NOT EXISTS `site` (
`site_type` smallint NOT NULL DEFAULT 0 ,
`site_project` char(255) 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`),