diff options
| author | Manuel Tancoigne <m.tancoigne@gmail.com> | 2017-06-06 19:42:10 +0200 |
|---|---|---|
| committer | Manuel Tancoigne <m.tancoigne@gmail.com> | 2017-06-06 19:42:10 +0200 |
| commit | abce12ccd9a2976af312b53c3e7c9bb05827e236 (patch) | |
| tree | 57610a9f1e34a9800750ccb4615b9cf43ccbdd83 /install | |
| parent | 867d8510ca2b2312a07be2a83c3432ae13a9172f (diff) | |
| download | volse-hubzilla-abce12ccd9a2976af312b53c3e7c9bb05827e236.tar.gz volse-hubzilla-abce12ccd9a2976af312b53c3e7c9bb05827e236.tar.bz2 volse-hubzilla-abce12ccd9a2976af312b53c3e7c9bb05827e236.zip | |
Fixed TEXT fields with default values (fixes #803) in mysql creation script.
Diffstat (limited to 'install')
| -rw-r--r-- | install/schema_mysql.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index ceb63fce9..faaf167a2 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`), |