diff options
| author | Christian Vogeley <christian.vogeley@hotmail.de> | 2013-08-03 00:18:14 +0200 |
|---|---|---|
| committer | Christian Vogeley <christian.vogeley@hotmail.de> | 2013-08-03 00:18:14 +0200 |
| commit | f09ac4e5972a77dfe73338ee207e40ec463355e9 (patch) | |
| tree | 77232d70031622a162f4e00aec128961ecc7a764 /install/database.sql | |
| parent | 9294f72adb3c076932558b6f29a4c570e7962764 (diff) | |
| download | volse-hubzilla-f09ac4e5972a77dfe73338ee207e40ec463355e9.tar.gz volse-hubzilla-f09ac4e5972a77dfe73338ee207e40ec463355e9.tar.bz2 volse-hubzilla-f09ac4e5972a77dfe73338ee207e40ec463355e9.zip | |
Revert "Revert "merge""
This reverts commit 9294f72adb3c076932558b6f29a4c570e7962764.
Diffstat (limited to 'install/database.sql')
| -rw-r--r-- | install/database.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/install/database.sql b/install/database.sql index e8b01d066..0c4b868d2 100644 --- a/install/database.sql +++ b/install/database.sql @@ -443,7 +443,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `owner_xchan` char(255) NOT NULL DEFAULT '', `author_xchan` char(255) NOT NULL DEFAULT '', `mimetype` char(255) NOT NULL DEFAULT '', - `title` char(255) NOT NULL DEFAULT '', + `title` text NOT NULL DEFAULT '', `body` mediumtext NOT NULL, `app` char(255) NOT NULL DEFAULT '', `lang` char(64) NOT NULL DEFAULT '', @@ -524,7 +524,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( `to_xchan` char(255) NOT NULL DEFAULT '', `account_id` int(10) unsigned NOT NULL DEFAULT '0', `channel_id` int(10) unsigned NOT NULL, - `title` char(255) NOT NULL, + `title` text NOT NULL, `body` mediumtext NOT NULL, `mid` char(255) NOT NULL, `parent_mid` char(255) NOT NULL, @@ -910,6 +910,7 @@ CREATE TABLE IF NOT EXISTS `xchan` ( `xchan_connurl` char(255) NOT NULL DEFAULT '', `xchan_name` char(255) NOT NULL DEFAULT '', `xchan_network` char(255) NOT NULL DEFAULT '', + `xchan_instance_url` char(255) NOT NULL DEFAULT '', `xchan_flags` int(10) unsigned NOT NULL DEFAULT '0', `xchan_photo_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `xchan_name_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', @@ -918,6 +919,7 @@ CREATE TABLE IF NOT EXISTS `xchan` ( KEY `xchan_addr` (`xchan_addr`), KEY `xchan_name` (`xchan_name`), KEY `xchan_network` (`xchan_network`), + KEY `xchan_instance_url` (`xchan_instance_url`), KEY `xchan_url` (`xchan_url`), KEY `xchan_flags` (`xchan_flags`), KEY `xchan_connurl` (`xchan_connurl`) |