diff options
| author | Christian Vogeley <christian.vogeley@hotmail.de> | 2013-08-03 00:04:26 +0200 |
|---|---|---|
| committer | Christian Vogeley <christian.vogeley@hotmail.de> | 2013-08-03 00:04:26 +0200 |
| commit | c0cd147a3a9a86b270ea32026089ced16fb2f50c (patch) | |
| tree | 77232d70031622a162f4e00aec128961ecc7a764 /install/database.sql | |
| parent | d2d1e54bfe928fe4cdfdcfc7e9acf658cda76898 (diff) | |
| parent | 1d816ba90ad3408822dc64f294597273fd19bc57 (diff) | |
| download | volse-hubzilla-c0cd147a3a9a86b270ea32026089ced16fb2f50c.tar.gz volse-hubzilla-c0cd147a3a9a86b270ea32026089ced16fb2f50c.tar.bz2 volse-hubzilla-c0cd147a3a9a86b270ea32026089ced16fb2f50c.zip | |
merge
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`) |