From fad26a49beb9d067ad101798f4c0b2b15dcb035c Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Tue, 19 Mar 2019 10:52:10 +0100 Subject: mysql: remove some unused indices and add thr_parent index. pgsql: sync indices with mysql indices after testing on hub.disroot.org and add thr_parent --- install/schema_mysql.sql | 7 ++----- install/schema_postgres.sql | 32 +++++++++++++------------------- 2 files changed, 15 insertions(+), 24 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 49a2c476a..cb4a3fa74 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -691,19 +691,16 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `changed` (`changed`), KEY `item_origin` (`item_origin`), KEY `item_wall` (`item_wall`), - KEY `item_unseen` (`item_unseen`), KEY `item_uplink` (`item_uplink`), - KEY `item_notshown` (`item_notshown`), KEY `item_nsfw` (`item_nsfw`), - KEY `item_relay` (`item_relay`), KEY `item_mentionsme` (`item_mentionsme`), KEY `item_nocomment` (`item_nocomment`), KEY `item_obscured` (`item_obscured`), - KEY `item_verified` (`item_verified`), KEY `item_rss` (`item_rss`), KEY `item_consensus` (`item_consensus`), KEY `item_deleted_pending_remove_changed` (`item_deleted`, `item_pending_remove`, `changed`), - KEY `item_pending_remove_changed` (`item_pending_remove`, `changed`) + KEY `item_pending_remove_changed` (`item_pending_remove`, `changed`), + KEY `thr_parent` (`thr_parent`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS `item_id` ( diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 1b6cab51b..e56e054b0 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -627,7 +627,6 @@ CREATE TABLE "item" ( "item_search_vector" tsvector, PRIMARY KEY ("id") ); -create index "item_uid" on item ("uid"); create index "item_uuid" on item ("uuid"); create index "item_parent" on item ("parent"); create index "item_created" on item ("created"); @@ -638,17 +637,13 @@ create index "item_uid_created" on item ("uid","created"); create index "item_uid_unseen" on item ("uid","item_unseen"); create index "item_changed" on item ("changed"); create index "item_comments_closed" on item ("comments_closed"); -create index "item_aid" on item ("aid"); create index "item_owner_xchan" on item ("owner_xchan"); create index "item_author_xchan" on item ("author_xchan"); create index "item_resource_id" on item ("resource_id"); create index "item_resource_type" on item ("resource_type"); -create index "item_restrict" on item ("item_restrict"); -create index "item_flags" on item ("item_flags"); create index "item_commented" on item ("commented"); create index "item_verb" on item ("verb"); create index "item_obj_type" on item ("obj_type"); -create index "item_private" on item ("item_private"); create index "item_llink" on item ("llink"); create index "item_expires" on item ("expires"); create index "item_revision" on item ("revision"); @@ -659,30 +654,29 @@ create index "item_uid_mid" on item ("mid","uid"); create index "item_public_policy" on item ("public_policy"); create index "item_comment_policy" on item ("comment_policy"); create index "item_layout_mid" on item ("layout_mid"); -create index "item_unseen" on item ("item_unseen"); create index "item_wall" on item ("item_wall"); create index "item_origin" on item ("item_origin"); -create index "item_starred" on item ("item_starred"); create index "item_uplink" on item ("item_uplink"); create index "item_consensus" on item ("item_consensus"); -create index "item_thread_top" on item ("item_thread_top"); -create index "item_notshown" on item ("item_notshown"); create index "item_nsfw" on item ("item_nsfw"); -create index "item_relay" on item ("item_relay"); create index "item_mentionsme" on item ("item_mentionsme"); create index "item_nocomment" on item ("item_nocomment"); create index "item_obscured" on item ("item_obscured"); -create index "item_verified" on item ("item_verified"); -create index "item_retained" on item ("item_retained"); create index "item_rss" on item ("item_rss"); -create index "item_deleted" on item ("item_deleted"); -create index "item_type" on item ("item_type"); -create index "item_hidden" on item ("item_hidden"); -create index "item_unpublished" on item ("item_unpublished"); -create index "item_delayed" on item ("item_delayed"); -create index "item_pending_remove" on item ("item_pending_remove"); -create index "item_blocked" on item ("item_blocked"); +create index "item_thr_parent" on item ("thr_parent"); + +create index "item_uid_item_type" on item ("uid", "item_type"); +create index "item_uid_item_thread_top" on item ("uid", "item_thread_top"); +create index "item_uid_item_blocked" on item ("uid", "item_blocked"); +create index "item_uid_item_wall" on item ("uid", "item_wall"); +create index "item_uid_item_starred" on item ("uid", "item_starred"); +create index "item_uid_item_retained" on item ("uid", "item_retained"); +create index "item_uid_item_private" on item ("uid", "item_private"); +create index "item_uid_resource_type" on item ("uid", "resource_type"); +create index "item_item_deleted_item_pending_remove_changed" on item ("item_deleted", "item_pending_remove", "changed"); +create index "item_item_pending_remove_changed" on item ("item_pending_remove", "changed"); + -- fulltext indexes create index "item_search_idx" on item USING gist("item_search_vector"); create index "item_allow_cid" on item ("allow_cid"); -- cgit v1.2.3 From 775285cdf8faebb77e1725e7c88de82129acd3c4 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Wed, 10 Apr 2019 14:14:14 +0200 Subject: Update comment htconfig.sample.php --- install/htconfig.sample.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/htconfig.sample.php b/install/htconfig.sample.php index 07725e3f4..509942530 100755 --- a/install/htconfig.sample.php +++ b/install/htconfig.sample.php @@ -12,7 +12,7 @@ // Then set the following for your MySQL installation -$db_host = 'your.mysqlhost.com'; // Use 'localhost' if you aren't using a remote server +$db_host = 'your.mysqlhost.com'; // Use 'localhost' or ':/path/to/socket.file' if you aren't using a remote server $db_port = 0; // leave 0 for default or set your port $db_user = 'mysqlusername'; $db_pass = 'mysqlpassword'; -- cgit v1.2.3 From 257ba570ee6639dc7079f5b7b410a2ef6f7d6046 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Mon, 15 Apr 2019 15:18:35 +0200 Subject: Update INSTALL.txt --- install/INSTALL.txt | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/INSTALL.txt b/install/INSTALL.txt index fe2484d7a..0503ae2cc 100644 --- a/install/INSTALL.txt +++ b/install/INSTALL.txt @@ -175,7 +175,7 @@ encounter a database configuration which cannot be expressed on the setup form (for instance using MySQL with an unusual socket location); you can supply the PDO connection string as the database hostname. For instance - mysql:unix_socket=/my/special/socket_path + :/path/to/socket.file You should still fill in all other applicable form values as needed. -- cgit v1.2.3 From 24f3bc9f0c282f9a0610ee828b4341ee43cecb40 Mon Sep 17 00:00:00 2001 From: Mario Date: Wed, 8 May 2019 19:55:21 +0200 Subject: Channel update --- install/database-w-defaults-v1131.diff | 1914 -------------------------------- install/schema_mysql.sql | 18 - 2 files changed, 1932 deletions(-) delete mode 100644 install/database-w-defaults-v1131.diff (limited to 'install') diff --git a/install/database-w-defaults-v1131.diff b/install/database-w-defaults-v1131.diff deleted file mode 100644 index c8870f9c4..000000000 --- a/install/database-w-defaults-v1131.diff +++ /dev/null @@ -1,1914 +0,0 @@ -*** database.sql Mon Sep 8 20:28:00 2014 ---- database-w-defaults.sql Sun Nov 9 19:20:32 2014 -*************** -*** 1,15 **** -! SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -! -! /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -! /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -! /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -! /*!40101 SET NAMES utf8 */; - - - CREATE TABLE IF NOT EXISTS `abook` ( - `abook_id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `abook_account` int(10) unsigned NOT NULL, -! `abook_channel` int(10) unsigned NOT NULL, - `abook_xchan` char(255) NOT NULL DEFAULT '', - `abook_my_perms` int(11) NOT NULL DEFAULT '0', - `abook_their_perms` int(11) NOT NULL DEFAULT '0', ---- 1,13 ---- -! -- -------------------------------------------------------- - -+ -- -+ -- Table structure for table `abook` -+ -- - - CREATE TABLE IF NOT EXISTS `abook` ( - `abook_id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `abook_account` int(10) unsigned NOT NULL DEFAULT '0', -! `abook_channel` int(10) unsigned NOT NULL DEFAULT '0', - `abook_xchan` char(255) NOT NULL DEFAULT '', - `abook_my_perms` int(11) NOT NULL DEFAULT '0', - `abook_their_perms` int(11) NOT NULL DEFAULT '0', -*************** -*** 37,42 **** ---- 35,46 ---- - KEY `abook_rating` (`abook_rating`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `account` -+ -- -+ - CREATE TABLE IF NOT EXISTS `account` ( - `account_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `account_parent` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 70,79 **** - KEY `account_password_changed` (`account_password_changed`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `addon` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `name` char(255) NOT NULL, -! `version` char(255) NOT NULL, - `installed` tinyint(1) NOT NULL DEFAULT '0', - `hidden` tinyint(1) NOT NULL DEFAULT '0', - `timestamp` bigint(20) NOT NULL DEFAULT '0', ---- 74,89 ---- - KEY `account_password_changed` (`account_password_changed`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `addon` -+ -- -+ - CREATE TABLE IF NOT EXISTS `addon` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `name` char(255) NOT NULL DEFAULT '', -! `version` char(255) NOT NULL DEFAULT '', - `installed` tinyint(1) NOT NULL DEFAULT '0', - `hidden` tinyint(1) NOT NULL DEFAULT '0', - `timestamp` bigint(20) NOT NULL DEFAULT '0', -*************** -*** 84,89 **** ---- 94,104 ---- - KEY `installed` (`installed`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `app` -+ -- - - CREATE TABLE IF NOT EXISTS `app` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -*************** -*** 108,115 **** - KEY `app_version` (`app_version`), - KEY `app_channel` (`app_channel`), - KEY `app_price` (`app_price`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - - CREATE TABLE IF NOT EXISTS `attach` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, ---- 123,135 ---- - KEY `app_version` (`app_version`), - KEY `app_channel` (`app_channel`), - KEY `app_price` (`app_price`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- - -+ -- -+ -- Table structure for table `attach` -+ -- - - CREATE TABLE IF NOT EXISTS `attach` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -*************** -*** 145,166 **** - KEY `creator` (`creator`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `auth_codes` ( -! `id` varchar(40) NOT NULL, -! `client_id` varchar(20) NOT NULL, -! `redirect_uri` varchar(200) NOT NULL, -! `expires` int(11) NOT NULL, -! `scope` varchar(250) NOT NULL, - PRIMARY KEY (`id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `cache` ( -! `k` char(255) NOT NULL, - `v` text NOT NULL, -! `updated` datetime NOT NULL, - PRIMARY KEY (`k`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `channel` ( - `channel_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `channel_account_id` int(10) unsigned NOT NULL DEFAULT '0', ---- 165,204 ---- - KEY `creator` (`creator`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `auth_codes` -+ -- -+ - CREATE TABLE IF NOT EXISTS `auth_codes` ( -! `id` varchar(40) NOT NULL DEFAULT '', -! `client_id` varchar(20) NOT NULL DEFAULT '', -! `redirect_uri` varchar(200) NOT NULL DEFAULT '', -! `expires` int(11) NOT NULL DEFAULT '0', -! `scope` varchar(250) NOT NULL DEFAULT '', - PRIMARY KEY (`id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `cache` -+ -- -+ - CREATE TABLE IF NOT EXISTS `cache` ( -! `k` char(255) NOT NULL DEFAULT '', - `v` text NOT NULL, -! `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - PRIMARY KEY (`k`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `channel` -+ -- -+ - CREATE TABLE IF NOT EXISTS `channel` ( - `channel_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `channel_account_id` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 189,212 **** - `channel_allow_gid` mediumtext NOT NULL, - `channel_deny_cid` mediumtext NOT NULL, - `channel_deny_gid` mediumtext NOT NULL, -! `channel_r_stream` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_r_profile` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_r_photos` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_r_abook` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_stream` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_wall` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_comment` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_mail` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_photos` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_chat` int(10) unsigned NOT NULL DEFAULT '128', - `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_r_storage` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_storage` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_r_pages` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_pages` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_a_republish` int(10) unsigned NOT NULL DEFAULT '128', -! `channel_w_like` int(10) unsigned NOT NULL DEFAULT '128', - PRIMARY KEY (`channel_id`), - UNIQUE KEY `channel_address_unique` (`channel_address`), - KEY `channel_account_id` (`channel_account_id`), ---- 227,250 ---- - `channel_allow_gid` mediumtext NOT NULL, - `channel_deny_cid` mediumtext NOT NULL, - `channel_deny_gid` mediumtext NOT NULL, -! `channel_r_stream` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_r_profile` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_r_photos` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_r_abook` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_stream` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_wall` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_comment` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_mail` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_photos` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_chat` int(10) unsigned NOT NULL DEFAULT '0', - `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_r_storage` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_storage` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_r_pages` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_pages` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_a_republish` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_w_like` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`channel_id`), - UNIQUE KEY `channel_address_unique` (`channel_address`), - KEY `channel_account_id` (`channel_account_id`), -*************** -*** 241,250 **** - KEY `channel_w_pages` (`channel_w_pages`), - KEY `channel_deleted` (`channel_deleted`), - KEY `channel_a_republish` (`channel_a_republish`), -! KEY `channel_w_like` (`channel_w_like`), -! KEY `channel_dirdate` (`channel_dirdate`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `chat` ( - `chat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `chat_room` int(10) unsigned NOT NULL DEFAULT '0', ---- 279,294 ---- - KEY `channel_w_pages` (`channel_w_pages`), - KEY `channel_deleted` (`channel_deleted`), - KEY `channel_a_republish` (`channel_a_republish`), -! KEY `channel_dirdate` (`channel_dirdate`), -! KEY `channel_w_like` (`channel_w_like`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `chat` -+ -- -+ - CREATE TABLE IF NOT EXISTS `chat` ( - `chat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `chat_room` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 255,275 **** - KEY `chat_room` (`chat_room`), - KEY `chat_xchan` (`chat_xchan`), - KEY `created` (`created`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `chatpresence` ( - `cp_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `cp_room` int(10) unsigned NOT NULL DEFAULT '0', - `cp_xchan` char(255) NOT NULL DEFAULT '', - `cp_last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `cp_status` char(255) NOT NULL, - `cp_client` char(128) NOT NULL DEFAULT '', - PRIMARY KEY (`cp_id`), - KEY `cp_room` (`cp_room`), - KEY `cp_xchan` (`cp_xchan`), - KEY `cp_last` (`cp_last`), - KEY `cp_status` (`cp_status`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `chatroom` ( - `cr_id` int(10) unsigned NOT NULL AUTO_INCREMENT, ---- 299,331 ---- - KEY `chat_room` (`chat_room`), - KEY `chat_xchan` (`chat_xchan`), - KEY `created` (`created`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `chatpresence` -! -- - - CREATE TABLE IF NOT EXISTS `chatpresence` ( - `cp_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `cp_room` int(10) unsigned NOT NULL DEFAULT '0', - `cp_xchan` char(255) NOT NULL DEFAULT '', - `cp_last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `cp_status` char(255) NOT NULL DEFAULT '', - `cp_client` char(128) NOT NULL DEFAULT '', - PRIMARY KEY (`cp_id`), - KEY `cp_room` (`cp_room`), - KEY `cp_xchan` (`cp_xchan`), - KEY `cp_last` (`cp_last`), - KEY `cp_status` (`cp_status`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `chatroom` -! -- - - CREATE TABLE IF NOT EXISTS `chatroom` ( - `cr_id` int(10) unsigned NOT NULL AUTO_INCREMENT, -*************** -*** 290,322 **** - KEY `cr_created` (`cr_created`), - KEY `cr_edited` (`cr_edited`), - KEY `cr_expire` (`cr_expire`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `clients` ( -! `client_id` varchar(20) NOT NULL, -! `pw` varchar(20) NOT NULL, -! `redirect_uri` varchar(200) NOT NULL, - `name` text, - `icon` text, - `uid` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`client_id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `config` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `cat` char(255) CHARACTER SET ascii NOT NULL, -! `k` char(255) CHARACTER SET ascii NOT NULL, - `v` text NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `access` (`cat`,`k`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `conv` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `guid` char(255) NOT NULL, - `recips` mediumtext NOT NULL, -! `uid` int(11) NOT NULL, -! `creator` char(255) NOT NULL, - `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `subject` mediumtext NOT NULL, ---- 346,396 ---- - KEY `cr_created` (`cr_created`), - KEY `cr_edited` (`cr_edited`), - KEY `cr_expire` (`cr_expire`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `clients` -! -- - - CREATE TABLE IF NOT EXISTS `clients` ( -! `client_id` varchar(20) NOT NULL DEFAULT '', -! `pw` varchar(20) NOT NULL DEFAULT '', -! `redirect_uri` varchar(200) NOT NULL DEFAULT '', - `name` text, - `icon` text, - `uid` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`client_id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `config` -+ -- -+ - CREATE TABLE IF NOT EXISTS `config` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `cat` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', -! `k` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', - `v` text NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `access` (`cat`,`k`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `conv` -+ -- -+ - CREATE TABLE IF NOT EXISTS `conv` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `guid` char(255) NOT NULL DEFAULT '', - `recips` mediumtext NOT NULL, -! `uid` int(11) NOT NULL DEFAULT '0', -! `creator` char(255) NOT NULL DEFAULT '', - `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `subject` mediumtext NOT NULL, -*************** -*** 325,344 **** - KEY `updated` (`updated`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `event` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', -! `uid` int(11) NOT NULL, - `event_xchan` char(255) NOT NULL DEFAULT '', - `event_hash` char(255) NOT NULL DEFAULT '', -! `created` datetime NOT NULL, -! `edited` datetime NOT NULL, -! `start` datetime NOT NULL, -! `finish` datetime NOT NULL, - `summary` text NOT NULL, - `description` text NOT NULL, - `location` text NOT NULL, -! `type` char(255) NOT NULL, - `nofinish` tinyint(1) NOT NULL DEFAULT '0', - `adjust` tinyint(1) NOT NULL DEFAULT '1', - `ignore` tinyint(1) NOT NULL DEFAULT '0', ---- 399,424 ---- - KEY `updated` (`updated`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `event` -+ -- -+ - CREATE TABLE IF NOT EXISTS `event` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', -! `uid` int(11) NOT NULL DEFAULT '0', - `event_xchan` char(255) NOT NULL DEFAULT '', - `event_hash` char(255) NOT NULL DEFAULT '', -! `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `finish` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `summary` text NOT NULL, - `description` text NOT NULL, - `location` text NOT NULL, -! `type` char(255) NOT NULL DEFAULT '', - `nofinish` tinyint(1) NOT NULL DEFAULT '0', - `adjust` tinyint(1) NOT NULL DEFAULT '1', - `ignore` tinyint(1) NOT NULL DEFAULT '0', -*************** -*** 357,363 **** - KEY `aid` (`aid`), - KEY `event_hash` (`event_hash`), - KEY `event_xchan` (`event_xchan`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `fcontact` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, ---- 437,449 ---- - KEY `aid` (`aid`), - KEY `event_hash` (`event_hash`), - KEY `event_xchan` (`event_xchan`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `fcontact` -! -- - - CREATE TABLE IF NOT EXISTS `fcontact` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -*************** -*** 381,386 **** ---- 467,478 ---- - KEY `network` (`network`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `ffinder` -+ -- -+ - CREATE TABLE IF NOT EXISTS `ffinder` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `uid` int(10) unsigned NOT NULL, -*************** -*** 392,427 **** - KEY `fid` (`fid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `fserver` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `server` char(255) NOT NULL, -! `posturl` char(255) NOT NULL, - `key` text NOT NULL, - PRIMARY KEY (`id`), - KEY `server` (`server`), - KEY `posturl` (`posturl`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `fsuggest` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `uid` int(11) NOT NULL, -! `cid` int(11) NOT NULL, -! `name` char(255) NOT NULL, -! `url` char(255) NOT NULL, -! `request` char(255) NOT NULL, -! `photo` char(255) NOT NULL, - `note` text NOT NULL, -! `created` datetime NOT NULL, - PRIMARY KEY (`id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `groups` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `hash` char(255) NOT NULL DEFAULT '', -! `uid` int(10) unsigned NOT NULL, - `visible` tinyint(1) NOT NULL DEFAULT '0', - `deleted` tinyint(1) NOT NULL DEFAULT '0', -! `name` char(255) NOT NULL, - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `visible` (`visible`), ---- 484,537 ---- - KEY `fid` (`fid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `fserver` -+ -- -+ - CREATE TABLE IF NOT EXISTS `fserver` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `server` char(255) NOT NULL DEFAULT '', -! `posturl` char(255) NOT NULL DEFAULT '', - `key` text NOT NULL, - PRIMARY KEY (`id`), - KEY `server` (`server`), - KEY `posturl` (`posturl`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `fsuggest` -+ -- -+ - CREATE TABLE IF NOT EXISTS `fsuggest` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `uid` int(11) NOT NULL DEFAULT '0', -! `cid` int(11) NOT NULL DEFAULT '0', -! `name` char(255) NOT NULL DEFAULT '', -! `url` char(255) NOT NULL DEFAULT '', -! `request` char(255) NOT NULL DEFAULT '', -! `photo` char(255) NOT NULL DEFAULT '', - `note` text NOT NULL, -! `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - PRIMARY KEY (`id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `groups` -+ -- -+ - CREATE TABLE IF NOT EXISTS `groups` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `hash` char(255) NOT NULL DEFAULT '', -! `uid` int(10) unsigned NOT NULL DEFAULT '0', - `visible` tinyint(1) NOT NULL DEFAULT '0', - `deleted` tinyint(1) NOT NULL DEFAULT '0', -! `name` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `visible` (`visible`), -*************** -*** 429,438 **** - KEY `hash` (`hash`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `group_member` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `uid` int(10) unsigned NOT NULL, -! `gid` int(10) unsigned NOT NULL, - `xchan` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), ---- 539,554 ---- - KEY `hash` (`hash`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `group_member` -+ -- -+ - CREATE TABLE IF NOT EXISTS `group_member` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `uid` int(10) unsigned NOT NULL DEFAULT '0', -! `gid` int(10) unsigned NOT NULL DEFAULT '0', - `xchan` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), -*************** -*** 440,460 **** - KEY `xchan` (`xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `hook` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `hook` char(255) NOT NULL, -! `file` char(255) NOT NULL, -! `function` char(255) NOT NULL, - `priority` int(11) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - KEY `hook` (`hook`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `hubloc` ( - `hubloc_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `hubloc_guid` char(255) NOT NULL DEFAULT '', - `hubloc_guid_sig` text NOT NULL, -! `hubloc_hash` char(255) NOT NULL, - `hubloc_addr` char(255) NOT NULL DEFAULT '', - `hubloc_network` char(32) NOT NULL DEFAULT '', - `hubloc_flags` int(10) unsigned NOT NULL DEFAULT '0', ---- 556,588 ---- - KEY `xchan` (`xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `hook` -+ -- -+ - CREATE TABLE IF NOT EXISTS `hook` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `hook` char(255) NOT NULL DEFAULT '', -! `file` char(255) NOT NULL DEFAULT '', -! `function` char(255) NOT NULL DEFAULT '', - `priority` int(11) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - KEY `hook` (`hook`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `hubloc` -+ -- -+ - CREATE TABLE IF NOT EXISTS `hubloc` ( - `hubloc_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `hubloc_guid` char(255) NOT NULL DEFAULT '', - `hubloc_guid_sig` text NOT NULL, -! `hubloc_hash` char(255) NOT NULL DEFAULT '', - `hubloc_addr` char(255) NOT NULL DEFAULT '', - `hubloc_network` char(32) NOT NULL DEFAULT '', - `hubloc_flags` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 474,493 **** - KEY `hubloc_connect` (`hubloc_connect`), - KEY `hubloc_host` (`hubloc_host`), - KEY `hubloc_addr` (`hubloc_addr`), -- KEY `hubloc_network` (`hubloc_network`), - KEY `hubloc_updated` (`hubloc_updated`), - KEY `hubloc_connected` (`hubloc_connected`), -! KEY `hubloc_status` (`hubloc_status`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `issue` ( - `issue_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `issue_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `issue_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `issue_assigned` char(255) NOT NULL, -! `issue_priority` int(11) NOT NULL, -! `issue_status` int(11) NOT NULL, -! `issue_component` char(255) NOT NULL, - PRIMARY KEY (`issue_id`), - KEY `issue_created` (`issue_created`), - KEY `issue_updated` (`issue_updated`), ---- 602,627 ---- - KEY `hubloc_connect` (`hubloc_connect`), - KEY `hubloc_host` (`hubloc_host`), - KEY `hubloc_addr` (`hubloc_addr`), - KEY `hubloc_updated` (`hubloc_updated`), - KEY `hubloc_connected` (`hubloc_connected`), -! KEY `hubloc_status` (`hubloc_status`), -! KEY `hubloc_network` (`hubloc_network`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `issue` -+ -- -+ - CREATE TABLE IF NOT EXISTS `issue` ( - `issue_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `issue_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `issue_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `issue_assigned` char(255) NOT NULL DEFAULT '', -! `issue_priority` int(11) NOT NULL DEFAULT '0', -! `issue_status` int(11) NOT NULL DEFAULT '0', -! `issue_component` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`issue_id`), - KEY `issue_created` (`issue_created`), - KEY `issue_updated` (`issue_updated`), -*************** -*** 497,502 **** ---- 631,642 ---- - KEY `issue_component` (`issue_component`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `item` -+ -- -+ - CREATE TABLE IF NOT EXISTS `item` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `mid` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', -*************** -*** 516,549 **** - `author_xchan` char(255) NOT NULL DEFAULT '', - `source_xchan` char(255) NOT NULL DEFAULT '', - `mimetype` char(255) NOT NULL DEFAULT '', -! `title` text NOT NULL DEFAULT '', -! `body` mediumtext NOT NULL DEFAULT '', - `app` char(255) NOT NULL DEFAULT '', - `lang` char(64) NOT NULL DEFAULT '', - `revision` int(10) unsigned NOT NULL DEFAULT '0', - `verb` char(255) NOT NULL DEFAULT '', - `obj_type` char(255) NOT NULL DEFAULT '', -! `object` text NOT NULL DEFAULT '', - `tgt_type` char(255) NOT NULL DEFAULT '', -! `target` text NOT NULL DEFAULT '', - `layout_mid` char(255) NOT NULL DEFAULT '', -! `postopts` text NOT NULL DEFAULT '', -! `route` text NOT NULL DEFAULT '', - `llink` char(255) NOT NULL DEFAULT '', - `plink` char(255) NOT NULL DEFAULT '', - `resource_id` char(255) NOT NULL DEFAULT '', - `resource_type` char(16) NOT NULL DEFAULT '', -! `attach` mediumtext NOT NULL DEFAULT '', -! `sig` text NOT NULL DEFAULT '', -! `diaspora_meta` mediumtext NOT NULL DEFAULT '', - `location` char(255) NOT NULL DEFAULT '', - `coord` char(255) NOT NULL DEFAULT '', - `public_policy` char(255) NOT NULL DEFAULT '', - `comment_policy` char(255) NOT NULL DEFAULT '', -! `allow_cid` mediumtext NOT NULL DEFAULT '', -! `allow_gid` mediumtext NOT NULL DEFAULT '', -! `deny_cid` mediumtext NOT NULL DEFAULT '', -! `deny_gid` mediumtext NOT NULL DEFAULT '', - `item_restrict` int(11) NOT NULL DEFAULT '0', - `item_flags` int(11) NOT NULL DEFAULT '0', - `item_private` tinyint(4) NOT NULL DEFAULT '0', ---- 656,689 ---- - `author_xchan` char(255) NOT NULL DEFAULT '', - `source_xchan` char(255) NOT NULL DEFAULT '', - `mimetype` char(255) NOT NULL DEFAULT '', -! `title` text NOT NULL, -! `body` mediumtext NOT NULL, - `app` char(255) NOT NULL DEFAULT '', - `lang` char(64) NOT NULL DEFAULT '', - `revision` int(10) unsigned NOT NULL DEFAULT '0', - `verb` char(255) NOT NULL DEFAULT '', - `obj_type` char(255) NOT NULL DEFAULT '', -! `object` text NOT NULL, - `tgt_type` char(255) NOT NULL DEFAULT '', -! `target` text NOT NULL, - `layout_mid` char(255) NOT NULL DEFAULT '', -! `postopts` text NOT NULL, -! `route` text NOT NULL, - `llink` char(255) NOT NULL DEFAULT '', - `plink` char(255) NOT NULL DEFAULT '', - `resource_id` char(255) NOT NULL DEFAULT '', - `resource_type` char(16) NOT NULL DEFAULT '', -! `attach` mediumtext NOT NULL, -! `sig` text NOT NULL, -! `diaspora_meta` mediumtext NOT NULL, - `location` char(255) NOT NULL DEFAULT '', - `coord` char(255) NOT NULL DEFAULT '', - `public_policy` char(255) NOT NULL DEFAULT '', - `comment_policy` char(255) NOT NULL DEFAULT '', -! `allow_cid` mediumtext NOT NULL, -! `allow_gid` mediumtext NOT NULL, -! `deny_cid` mediumtext NOT NULL, -! `deny_gid` mediumtext NOT NULL, - `item_restrict` int(11) NOT NULL DEFAULT '0', - `item_flags` int(11) NOT NULL DEFAULT '0', - `item_private` tinyint(4) NOT NULL DEFAULT '0', -*************** -*** 555,562 **** - KEY `received` (`received`), - KEY `uid_commented` (`uid`,`commented`), - KEY `uid_created` (`uid`,`created`), -- KEY `changed` (`changed`), -- KEY `comments_closed` (`comments_closed`), - KEY `aid` (`aid`), - KEY `owner_xchan` (`owner_xchan`), - KEY `author_xchan` (`author_xchan`), ---- 695,700 ---- -*************** -*** 573,581 **** - KEY `mid` (`mid`), - KEY `parent_mid` (`parent_mid`), - KEY `uid_mid` (`mid`,`uid`), -- KEY `public_policy` (`public_policy`), - KEY `comment_policy` (`comment_policy`), - KEY `layout_mid` (`layout_mid`), - FULLTEXT KEY `title` (`title`), - FULLTEXT KEY `body` (`body`), - FULLTEXT KEY `allow_cid` (`allow_cid`), ---- 711,721 ---- - KEY `mid` (`mid`), - KEY `parent_mid` (`parent_mid`), - KEY `uid_mid` (`mid`,`uid`), - KEY `comment_policy` (`comment_policy`), - KEY `layout_mid` (`layout_mid`), -+ KEY `public_policy` (`public_policy`), -+ KEY `comments_closed` (`comments_closed`), -+ KEY `changed` (`changed`), - FULLTEXT KEY `title` (`title`), - FULLTEXT KEY `body` (`body`), - FULLTEXT KEY `allow_cid` (`allow_cid`), -*************** -*** 584,595 **** - FULLTEXT KEY `deny_gid` (`deny_gid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `item_id` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `iid` int(11) NOT NULL, -! `uid` int(11) NOT NULL, -! `sid` char(255) NOT NULL, -! `service` char(255) NOT NULL, - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `sid` (`sid`), ---- 724,741 ---- - FULLTEXT KEY `deny_gid` (`deny_gid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `item_id` -+ -- -+ - CREATE TABLE IF NOT EXISTS `item_id` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `iid` int(11) NOT NULL DEFAULT '0', -! `uid` int(11) NOT NULL DEFAULT '0', -! `sid` char(255) NOT NULL DEFAULT '', -! `service` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `sid` (`sid`), -*************** -*** 597,621 **** - KEY `iid` (`iid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `likes` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `channel_id` int(11) unsigned NOT NULL DEFAULT '0', - `liker` char(128) NOT NULL DEFAULT '', - `likee` char(128) NOT NULL DEFAULT '', -! `iid` int(10) unsigned NOT NULL DEFAULT '0', - `verb` char(255) NOT NULL DEFAULT '', - `target_type` char(255) NOT NULL DEFAULT '', - `target_id` char(128) NOT NULL DEFAULT '', - `target` mediumtext NOT NULL, - PRIMARY KEY (`id`), -- KEY `channel_id` (`channel_id`), - KEY `liker` (`liker`), - KEY `likee` (`likee`), - KEY `iid` (`iid`), - KEY `verb` (`verb`), - KEY `target_type` (`target_type`), - KEY `target_id` (`target_id`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `mail` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, ---- 743,779 ---- - KEY `iid` (`iid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `likes` -+ -- -+ - CREATE TABLE IF NOT EXISTS `likes` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `channel_id` int(10) unsigned NOT NULL DEFAULT '0', - `liker` char(128) NOT NULL DEFAULT '', - `likee` char(128) NOT NULL DEFAULT '', -! `iid` int(11) unsigned NOT NULL DEFAULT '0', - `verb` char(255) NOT NULL DEFAULT '', - `target_type` char(255) NOT NULL DEFAULT '', - `target_id` char(128) NOT NULL DEFAULT '', - `target` mediumtext NOT NULL, - PRIMARY KEY (`id`), - KEY `liker` (`liker`), - KEY `likee` (`likee`), - KEY `iid` (`iid`), - KEY `verb` (`verb`), - KEY `target_type` (`target_type`), -+ KEY `channel_id` (`channel_id`), - KEY `target_id` (`target_id`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `mail` -! -- - - CREATE TABLE IF NOT EXISTS `mail` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -*************** -*** 624,639 **** - `from_xchan` char(255) NOT NULL DEFAULT '', - `to_xchan` char(255) NOT NULL DEFAULT '', - `account_id` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_id` int(10) unsigned NOT NULL, - `title` text NOT NULL, - `body` mediumtext NOT NULL, - `attach` mediumtext NOT NULL, -! `mid` char(255) NOT NULL, -! `parent_mid` char(255) NOT NULL, - `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - PRIMARY KEY (`id`), -- KEY `convid` (`convid`), - KEY `created` (`created`), - KEY `mail_flags` (`mail_flags`), - KEY `account_id` (`account_id`), ---- 782,796 ---- - `from_xchan` char(255) NOT NULL DEFAULT '', - `to_xchan` char(255) NOT NULL DEFAULT '', - `account_id` int(10) unsigned NOT NULL DEFAULT '0', -! `channel_id` int(10) unsigned NOT NULL DEFAULT '0', - `title` text NOT NULL, - `body` mediumtext NOT NULL, - `attach` mediumtext NOT NULL, -! `mid` char(255) NOT NULL DEFAULT '', -! `parent_mid` char(255) NOT NULL DEFAULT '', - `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - PRIMARY KEY (`id`), - KEY `created` (`created`), - KEY `mail_flags` (`mail_flags`), - KEY `account_id` (`account_id`), -*************** -*** 642,659 **** - KEY `to_xchan` (`to_xchan`), - KEY `mid` (`mid`), - KEY `parent_mid` (`parent_mid`), -! KEY `expires` (`expires`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `manage` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `uid` int(11) NOT NULL, - `xchan` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `xchan` (`xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `menu` ( - `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `menu_channel_id` int(10) unsigned NOT NULL DEFAULT '0', ---- 799,829 ---- - KEY `to_xchan` (`to_xchan`), - KEY `mid` (`mid`), - KEY `parent_mid` (`parent_mid`), -! KEY `expires` (`expires`), -! KEY `convid` (`convid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `manage` -+ -- -+ - CREATE TABLE IF NOT EXISTS `manage` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `uid` int(11) NOT NULL DEFAULT '0', - `xchan` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `xchan` (`xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `menu` -+ -- -+ - CREATE TABLE IF NOT EXISTS `menu` ( - `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `menu_channel_id` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 666,671 **** ---- 836,847 ---- - KEY `menu_flags` (`menu_flags`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `menu_item` -+ -- -+ - CREATE TABLE IF NOT EXISTS `menu_item` ( - `mitem_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `mitem_link` char(255) NOT NULL DEFAULT '', -*************** -*** 675,681 **** - `allow_gid` mediumtext NOT NULL, - `deny_cid` mediumtext NOT NULL, - `deny_gid` mediumtext NOT NULL, -! `mitem_channel_id` int(10) unsigned NOT NULL, - `mitem_menu_id` int(10) unsigned NOT NULL DEFAULT '0', - `mitem_order` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`mitem_id`), ---- 851,857 ---- - `allow_gid` mediumtext NOT NULL, - `deny_cid` mediumtext NOT NULL, - `deny_gid` mediumtext NOT NULL, -! `mitem_channel_id` int(10) unsigned NOT NULL DEFAULT '0', - `mitem_menu_id` int(10) unsigned NOT NULL DEFAULT '0', - `mitem_order` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`mitem_id`), -*************** -*** 684,705 **** - KEY `mitem_flags` (`mitem_flags`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `notify` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `hash` char(64) NOT NULL, -! `name` char(255) NOT NULL, -! `url` char(255) NOT NULL, -! `photo` char(255) NOT NULL, -! `date` datetime NOT NULL, - `msg` mediumtext NOT NULL, -! `aid` int(11) NOT NULL, -! `uid` int(11) NOT NULL, -! `link` char(255) NOT NULL, - `parent` char(255) NOT NULL DEFAULT '', - `seen` tinyint(1) NOT NULL DEFAULT '0', -! `type` int(11) NOT NULL, -! `verb` char(255) NOT NULL, -! `otype` char(16) NOT NULL, - PRIMARY KEY (`id`), - KEY `type` (`type`), - KEY `seen` (`seen`), ---- 860,887 ---- - KEY `mitem_flags` (`mitem_flags`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `notify` -+ -- -+ - CREATE TABLE IF NOT EXISTS `notify` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `hash` char(64) NOT NULL DEFAULT '', -! `name` char(255) NOT NULL DEFAULT '', -! `url` char(255) NOT NULL DEFAULT '', -! `photo` char(255) NOT NULL DEFAULT '', -! `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `msg` mediumtext NOT NULL, -! `aid` int(11) NOT NULL DEFAULT '0', -! `uid` int(11) NOT NULL DEFAULT '0', -! `link` char(255) NOT NULL DEFAULT '', - `parent` char(255) NOT NULL DEFAULT '', - `seen` tinyint(1) NOT NULL DEFAULT '0', -! `type` int(11) NOT NULL DEFAULT '0', -! `verb` char(255) NOT NULL DEFAULT '', -! `otype` char(16) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `type` (`type`), - KEY `seen` (`seen`), -*************** -*** 712,717 **** ---- 894,905 ---- - KEY `aid` (`aid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `obj` -+ -- -+ - CREATE TABLE IF NOT EXISTS `obj` ( - `obj_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `obj_page` char(64) NOT NULL DEFAULT '', -*************** -*** 731,736 **** ---- 919,930 ---- - KEY `obj_obj` (`obj_obj`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `outq` -+ -- -+ - CREATE TABLE IF NOT EXISTS `outq` ( - `outq_hash` char(255) NOT NULL, - `outq_account` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 753,786 **** - KEY `outq_delivered` (`outq_delivered`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `pconfig` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `uid` int(11) NOT NULL DEFAULT '0', -! `cat` char(255) CHARACTER SET ascii NOT NULL, -! `k` char(255) CHARACTER SET ascii NOT NULL, - `v` mediumtext NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `access` (`uid`,`cat`,`k`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `photo` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', -! `uid` int(10) unsigned NOT NULL, - `xchan` char(255) NOT NULL DEFAULT '', -! `resource_id` char(255) NOT NULL, -! `created` datetime NOT NULL, -! `edited` datetime NOT NULL, -! `title` char(255) NOT NULL, - `description` text NOT NULL, -! `album` char(255) NOT NULL, -! `filename` char(255) NOT NULL, - `type` char(128) NOT NULL DEFAULT 'image/jpeg', -! `height` smallint(6) NOT NULL, -! `width` smallint(6) NOT NULL, - `size` int(10) unsigned NOT NULL DEFAULT '0', - `data` mediumblob NOT NULL, -! `scale` tinyint(3) NOT NULL, - `profile` tinyint(1) NOT NULL DEFAULT '0', - `photo_flags` int(10) unsigned NOT NULL DEFAULT '0', - `allow_cid` mediumtext NOT NULL, ---- 947,992 ---- - KEY `outq_delivered` (`outq_delivered`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `pconfig` -+ -- -+ - CREATE TABLE IF NOT EXISTS `pconfig` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `uid` int(11) NOT NULL DEFAULT '0', -! `cat` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', -! `k` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', - `v` mediumtext NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `access` (`uid`,`cat`,`k`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `photo` -+ -- -+ - CREATE TABLE IF NOT EXISTS `photo` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', -! `uid` int(10) unsigned NOT NULL DEFAULT '0', - `xchan` char(255) NOT NULL DEFAULT '', -! `resource_id` char(255) NOT NULL DEFAULT '', -! `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `title` char(255) NOT NULL DEFAULT '', - `description` text NOT NULL, -! `album` char(255) NOT NULL DEFAULT '', -! `filename` char(255) NOT NULL DEFAULT '', - `type` char(128) NOT NULL DEFAULT 'image/jpeg', -! `height` smallint(6) NOT NULL DEFAULT '0', -! `width` smallint(6) NOT NULL DEFAULT '0', - `size` int(10) unsigned NOT NULL DEFAULT '0', - `data` mediumblob NOT NULL, -! `scale` tinyint(3) NOT NULL DEFAULT '0', - `profile` tinyint(1) NOT NULL DEFAULT '0', - `photo_flags` int(10) unsigned NOT NULL DEFAULT '0', - `allow_cid` mediumtext NOT NULL, -*************** -*** 800,805 **** ---- 1006,1017 ---- - KEY `resource_id` (`resource_id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `poll` -+ -- -+ - CREATE TABLE IF NOT EXISTS `poll` ( - `poll_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `poll_channel` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 812,817 **** ---- 1024,1035 ---- - KEY `poll_votes` (`poll_votes`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `poll_elm` -+ -- -+ - CREATE TABLE IF NOT EXISTS `poll_elm` ( - `pelm_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `pelm_poll` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 823,838 **** - KEY `pelm_result` (`pelm_result`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `profdef` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `field_name` char(255) NOT NULL DEFAULT '', - `field_type` char(16) NOT NULL DEFAULT '', - `field_desc` char(255) NOT NULL DEFAULT '', - `field_help` char(255) NOT NULL DEFAULT '', -! `field_inputs` mediumtext NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `field_name` (`field_name`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `profext` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, ---- 1041,1068 ---- - KEY `pelm_result` (`pelm_result`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `profdef` -+ -- -+ - CREATE TABLE IF NOT EXISTS `profdef` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `field_name` char(255) NOT NULL DEFAULT '', - `field_type` char(16) NOT NULL DEFAULT '', - `field_desc` char(255) NOT NULL DEFAULT '', - `field_help` char(255) NOT NULL DEFAULT '', -! `field_inputs` mediumtext NOT NULL, - PRIMARY KEY (`id`), - KEY `field_name` (`field_name`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `profext` -! -- - - CREATE TABLE IF NOT EXISTS `profext` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -*************** -*** 844,882 **** - KEY `channel_id` (`channel_id`), - KEY `hash` (`hash`), - KEY `k` (`k`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `profile` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `profile_guid` char(64) NOT NULL DEFAULT '', - `aid` int(10) unsigned NOT NULL DEFAULT '0', -! `uid` int(11) NOT NULL, -! `profile_name` char(255) NOT NULL, - `is_default` tinyint(1) NOT NULL DEFAULT '0', - `hide_friends` tinyint(1) NOT NULL DEFAULT '0', -! `name` char(255) NOT NULL, -! `pdesc` char(255) NOT NULL, - `chandesc` text NOT NULL, - `dob` char(32) NOT NULL DEFAULT '0000-00-00', - `dob_tz` char(255) NOT NULL DEFAULT 'UTC', -! `address` char(255) NOT NULL, -! `locality` char(255) NOT NULL, -! `region` char(255) NOT NULL, -! `postal_code` char(32) NOT NULL, -! `country_name` char(255) NOT NULL, -! `hometown` char(255) NOT NULL, -! `gender` char(32) NOT NULL, -! `marital` char(255) NOT NULL, - `with` text NOT NULL, - `howlong` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `sexual` char(255) NOT NULL, -! `politic` char(255) NOT NULL, -! `religion` char(255) NOT NULL, - `keywords` text NOT NULL, - `likes` text NOT NULL, - `dislikes` text NOT NULL, - `about` text NOT NULL, -! `summary` char(255) NOT NULL, - `music` text NOT NULL, - `book` text NOT NULL, - `tv` text NOT NULL, ---- 1074,1118 ---- - KEY `channel_id` (`channel_id`), - KEY `hash` (`hash`), - KEY `k` (`k`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `profile` -! -- - - CREATE TABLE IF NOT EXISTS `profile` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `profile_guid` char(64) NOT NULL DEFAULT '', - `aid` int(10) unsigned NOT NULL DEFAULT '0', -! `uid` int(11) NOT NULL DEFAULT '0', -! `profile_name` char(255) NOT NULL DEFAULT '', - `is_default` tinyint(1) NOT NULL DEFAULT '0', - `hide_friends` tinyint(1) NOT NULL DEFAULT '0', -! `name` char(255) NOT NULL DEFAULT '', -! `pdesc` char(255) NOT NULL DEFAULT '', - `chandesc` text NOT NULL, - `dob` char(32) NOT NULL DEFAULT '0000-00-00', - `dob_tz` char(255) NOT NULL DEFAULT 'UTC', -! `address` char(255) NOT NULL DEFAULT '', -! `locality` char(255) NOT NULL DEFAULT '', -! `region` char(255) NOT NULL DEFAULT '', -! `postal_code` char(32) NOT NULL DEFAULT '', -! `country_name` char(255) NOT NULL DEFAULT '', -! `hometown` char(255) NOT NULL DEFAULT '', -! `gender` char(32) NOT NULL DEFAULT '', -! `marital` char(255) NOT NULL DEFAULT '', - `with` text NOT NULL, - `howlong` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `sexual` char(255) NOT NULL DEFAULT '', -! `politic` char(255) NOT NULL DEFAULT '', -! `religion` char(255) NOT NULL DEFAULT '', - `keywords` text NOT NULL, - `likes` text NOT NULL, - `dislikes` text NOT NULL, - `about` text NOT NULL, -! `summary` char(255) NOT NULL DEFAULT '', - `music` text NOT NULL, - `book` text NOT NULL, - `tv` text NOT NULL, -*************** -*** 887,895 **** - `education` text NOT NULL, - `contact` text NOT NULL, - `channels` text NOT NULL, -! `homepage` char(255) NOT NULL, -! `photo` char(255) NOT NULL, -! `thumb` char(255) NOT NULL, - `publish` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `guid` (`profile_guid`,`uid`), ---- 1123,1131 ---- - `education` text NOT NULL, - `contact` text NOT NULL, - `channels` text NOT NULL, -! `homepage` char(255) NOT NULL DEFAULT '', -! `photo` char(255) NOT NULL DEFAULT '', -! `thumb` char(255) NOT NULL DEFAULT '', - `publish` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `guid` (`profile_guid`,`uid`), -*************** -*** 908,920 **** - KEY `profile_guid` (`profile_guid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `profile_check` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `uid` int(10) unsigned NOT NULL, - `cid` int(10) unsigned NOT NULL DEFAULT '0', -! `dfrn_id` char(255) NOT NULL, -! `sec` char(255) NOT NULL, -! `expire` int(11) NOT NULL, - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `cid` (`cid`), ---- 1144,1162 ---- - KEY `profile_guid` (`profile_guid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `profile_check` -+ -- -+ - CREATE TABLE IF NOT EXISTS `profile_check` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `uid` int(10) unsigned NOT NULL DEFAULT '0', - `cid` int(10) unsigned NOT NULL DEFAULT '0', -! `dfrn_id` char(255) NOT NULL DEFAULT '', -! `sec` char(255) NOT NULL DEFAULT '', -! `expire` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), - KEY `cid` (`cid`), -*************** -*** 923,951 **** - KEY `expire` (`expire`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `register` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `hash` char(255) NOT NULL, -! `created` datetime NOT NULL, -! `uid` int(10) unsigned NOT NULL, -! `password` char(255) NOT NULL, -! `language` char(16) NOT NULL, - PRIMARY KEY (`id`), - KEY `hash` (`hash`), - KEY `created` (`created`), - KEY `uid` (`uid`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `session` ( - `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, -! `sid` char(255) NOT NULL, - `data` text NOT NULL, -! `expire` bigint(20) unsigned NOT NULL, - PRIMARY KEY (`id`), - KEY `sid` (`sid`), - KEY `expire` (`expire`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `shares` ( - `share_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `share_type` int(11) NOT NULL DEFAULT '0', ---- 1165,1211 ---- - KEY `expire` (`expire`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `register` -+ -- -+ - CREATE TABLE IF NOT EXISTS `register` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `hash` char(255) NOT NULL DEFAULT '', -! `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -! `uid` int(10) unsigned NOT NULL DEFAULT '0', -! `password` char(255) NOT NULL DEFAULT '', -! `language` char(16) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `hash` (`hash`), - KEY `created` (`created`), - KEY `uid` (`uid`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `session` -! -- - - CREATE TABLE IF NOT EXISTS `session` ( - `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, -! `sid` char(255) NOT NULL DEFAULT '', - `data` text NOT NULL, -! `expire` bigint(20) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - KEY `sid` (`sid`), - KEY `expire` (`expire`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `shares` -+ -- -+ - CREATE TABLE IF NOT EXISTS `shares` ( - `share_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `share_type` int(11) NOT NULL DEFAULT '0', -*************** -*** 957,974 **** - KEY `share_xchan` (`share_xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `sign` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `iid` int(10) unsigned NOT NULL DEFAULT '0', - `retract_iid` int(10) unsigned NOT NULL DEFAULT '0', - `signed_text` mediumtext NOT NULL, - `signature` text NOT NULL, -! `signer` char(255) NOT NULL, - PRIMARY KEY (`id`), - KEY `iid` (`iid`), - KEY `retract_iid` (`retract_iid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `site` ( - `site_url` char(255) NOT NULL, - `site_access` int(11) NOT NULL DEFAULT '0', ---- 1217,1246 ---- - KEY `share_xchan` (`share_xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `sign` -+ -- -+ - CREATE TABLE IF NOT EXISTS `sign` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `iid` int(10) unsigned NOT NULL DEFAULT '0', - `retract_iid` int(10) unsigned NOT NULL DEFAULT '0', - `signed_text` mediumtext NOT NULL, - `signature` text NOT NULL, -! `signer` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`id`), - KEY `iid` (`iid`), - KEY `retract_iid` (`retract_iid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `site` -+ -- -+ - CREATE TABLE IF NOT EXISTS `site` ( - `site_url` char(255) NOT NULL, - `site_access` int(11) NOT NULL DEFAULT '0', -*************** -*** 988,996 **** ---- 1260,1275 ---- - KEY `site_register` (`site_register`), - KEY `site_access` (`site_access`), - KEY `site_sellpage` (`site_sellpage`), -+ KEY `site_pull` (`site_pull`), - KEY `site_realm` (`site_realm`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `source` -+ -- -+ - CREATE TABLE IF NOT EXISTS `source` ( - `src_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `src_channel_id` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 1003,1014 **** - KEY `src_xchan` (`src_xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `spam` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `uid` int(11) NOT NULL, - `spam` int(11) NOT NULL DEFAULT '0', - `ham` int(11) NOT NULL DEFAULT '0', -! `term` char(255) NOT NULL, - `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), ---- 1282,1299 ---- - KEY `src_xchan` (`src_xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `spam` -+ -- -+ - CREATE TABLE IF NOT EXISTS `spam` ( - `id` int(11) NOT NULL AUTO_INCREMENT, -! `uid` int(11) NOT NULL DEFAULT '0', - `spam` int(11) NOT NULL DEFAULT '0', - `ham` int(11) NOT NULL DEFAULT '0', -! `term` char(255) NOT NULL DEFAULT '', - `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - PRIMARY KEY (`id`), - KEY `uid` (`uid`), -*************** -*** 1017,1041 **** - KEY `term` (`term`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `sys_perms` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `cat` char(255) NOT NULL, -! `k` char(255) NOT NULL, - `v` mediumtext NOT NULL, -! `public_perm` tinyint(1) unsigned NOT NULL, - PRIMARY KEY (`id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `term` ( - `tid` int(10) unsigned NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(10) unsigned NOT NULL DEFAULT '0', -! `oid` int(10) unsigned NOT NULL, -! `otype` tinyint(3) unsigned NOT NULL, -! `type` tinyint(3) unsigned NOT NULL, -! `term` char(255) NOT NULL, -! `url` char(255) NOT NULL, -! `imgurl` char(255) NOT NULL, - `term_hash` char(255) NOT NULL DEFAULT '', - `parent_hash` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`tid`), ---- 1302,1338 ---- - KEY `term` (`term`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `sys_perms` -+ -- -+ - CREATE TABLE IF NOT EXISTS `sys_perms` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `cat` char(255) NOT NULL DEFAULT '', -! `k` char(255) NOT NULL DEFAULT '', - `v` mediumtext NOT NULL, -! `public_perm` tinyint(1) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`id`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `term` -+ -- -+ - CREATE TABLE IF NOT EXISTS `term` ( - `tid` int(10) unsigned NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(10) unsigned NOT NULL DEFAULT '0', -! `oid` int(10) unsigned NOT NULL DEFAULT '0', -! `otype` tinyint(3) unsigned NOT NULL DEFAULT '0', -! `type` tinyint(3) unsigned NOT NULL DEFAULT '0', -! `term` char(255) NOT NULL DEFAULT '', -! `url` char(255) NOT NULL DEFAULT '', -! `imgurl` char(255) NOT NULL DEFAULT '', - `term_hash` char(255) NOT NULL DEFAULT '', - `parent_hash` char(255) NOT NULL DEFAULT '', - PRIMARY KEY (`tid`), -*************** -*** 1050,1071 **** - KEY `parent_hash` (`parent_hash`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `tokens` ( -! `id` varchar(40) NOT NULL, - `secret` text NOT NULL, -! `client_id` varchar(20) NOT NULL, -! `expires` bigint(20) unsigned NOT NULL, -! `scope` varchar(200) NOT NULL, -! `uid` int(11) NOT NULL, - PRIMARY KEY (`id`), - KEY `client_id` (`client_id`), - KEY `expires` (`expires`), - KEY `uid` (`uid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `updates` ( - `ud_id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `ud_hash` char(128) NOT NULL, - `ud_guid` char(255) NOT NULL DEFAULT '', - `ud_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `ud_last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', ---- 1347,1380 ---- - KEY `parent_hash` (`parent_hash`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `tokens` -+ -- -+ - CREATE TABLE IF NOT EXISTS `tokens` ( -! `id` varchar(40) NOT NULL DEFAULT '', - `secret` text NOT NULL, -! `client_id` varchar(20) NOT NULL DEFAULT '', -! `expires` bigint(20) unsigned NOT NULL DEFAULT '0', -! `scope` varchar(200) NOT NULL DEFAULT '', -! `uid` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - KEY `client_id` (`client_id`), - KEY `expires` (`expires`), - KEY `uid` (`uid`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `updates` -+ -- -+ - CREATE TABLE IF NOT EXISTS `updates` ( - `ud_id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `ud_hash` char(128) NOT NULL DEFAULT '', - `ud_guid` char(255) NOT NULL DEFAULT '', - `ud_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `ud_last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -*************** -*** 1080,1085 **** ---- 1389,1400 ---- - KEY `ud_last` (`ud_last`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `verify` -+ -- -+ - CREATE TABLE IF NOT EXISTS `verify` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `channel` int(10) unsigned NOT NULL DEFAULT '0', -*************** -*** 1095,1100 **** ---- 1410,1421 ---- - KEY `created` (`created`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `vote` -+ -- -+ - CREATE TABLE IF NOT EXISTS `vote` ( - `vote_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `vote_poll` int(11) NOT NULL DEFAULT '0', -*************** -*** 1107,1112 **** ---- 1428,1439 ---- - KEY `vote_element` (`vote_element`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `xchan` -+ -- -+ - CREATE TABLE IF NOT EXISTS `xchan` ( - `xchan_hash` char(255) NOT NULL, - `xchan_guid` char(255) NOT NULL DEFAULT '', -*************** -*** 1139,1144 **** ---- 1466,1477 ---- - KEY `xchan_follow` (`xchan_follow`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `xchat` -+ -- -+ - CREATE TABLE IF NOT EXISTS `xchat` ( - `xchat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `xchat_url` char(255) NOT NULL DEFAULT '', -*************** -*** 1150,1162 **** - KEY `xchat_desc` (`xchat_desc`), - KEY `xchat_xchan` (`xchat_xchan`), - KEY `xchat_edited` (`xchat_edited`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `xconfig` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `xchan` char(255) NOT NULL, -! `cat` char(255) NOT NULL, -! `k` char(255) NOT NULL, - `v` mediumtext NOT NULL, - PRIMARY KEY (`id`), - KEY `xchan` (`xchan`), ---- 1483,1501 ---- - KEY `xchat_desc` (`xchat_desc`), - KEY `xchat_xchan` (`xchat_xchan`), - KEY `xchat_edited` (`xchat_edited`) -! ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -! -! -- -------------------------------------------------------- -! -! -- -! -- Table structure for table `xconfig` -! -- - - CREATE TABLE IF NOT EXISTS `xconfig` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `xchan` char(255) NOT NULL DEFAULT '', -! `cat` char(255) NOT NULL DEFAULT '', -! `k` char(255) NOT NULL DEFAULT '', - `v` mediumtext NOT NULL, - PRIMARY KEY (`id`), - KEY `xchan` (`xchan`), -*************** -*** 1164,1169 **** ---- 1503,1514 ---- - KEY `k` (`k`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `xign` -+ -- -+ - CREATE TABLE IF NOT EXISTS `xign` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `uid` int(11) NOT NULL DEFAULT '0', -*************** -*** 1173,1178 **** ---- 1518,1529 ---- - KEY `xchan` (`xchan`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `xlink` -+ -- -+ - CREATE TABLE IF NOT EXISTS `xlink` ( - `xlink_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `xlink_xchan` char(255) NOT NULL DEFAULT '', -*************** -*** 1186,1191 **** ---- 1537,1548 ---- - KEY `xlink_rating` (`xlink_rating`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `xprof` -+ -- -+ - CREATE TABLE IF NOT EXISTS `xprof` ( - `xprof_hash` char(255) NOT NULL, - `xprof_age` tinyint(3) unsigned NOT NULL DEFAULT '0', -*************** -*** 1216,1224 **** - KEY `xprof_hometown` (`xprof_hometown`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - CREATE TABLE IF NOT EXISTS `xtag` ( - `xtag_id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `xtag_hash` char(255) NOT NULL, - `xtag_term` char(255) NOT NULL DEFAULT '', - `xtag_flags` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`xtag_id`), ---- 1573,1587 ---- - KEY `xprof_hometown` (`xprof_hometown`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -+ -- -------------------------------------------------------- -+ -+ -- -+ -- Table structure for table `xtag` -+ -- -+ - CREATE TABLE IF NOT EXISTS `xtag` ( - `xtag_id` int(10) unsigned NOT NULL AUTO_INCREMENT, -! `xtag_hash` char(255) NOT NULL DEFAULT '', - `xtag_term` char(255) NOT NULL DEFAULT '', - `xtag_flags` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`xtag_id`), diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index cb4a3fa74..61cee0693 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -269,24 +269,6 @@ CREATE TABLE IF NOT EXISTS `channel` ( `channel_allow_gid` mediumtext NOT NULL, `channel_deny_cid` mediumtext NOT NULL, `channel_deny_gid` mediumtext NOT NULL, - `channel_r_stream` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_r_profile` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_r_photos` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_r_abook` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_stream` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_wall` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_comment` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_mail` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_photos` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_chat` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_r_storage` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_storage` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_r_pages` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_pages` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_a_republish` int(10) unsigned NOT NULL DEFAULT 0 , - `channel_w_like` int(10) unsigned NOT NULL DEFAULT 0 , `channel_removed` tinyint(1) NOT NULL DEFAULT 0 , `channel_system` tinyint(1) NOT NULL DEFAULT 0 , `channel_moved` char(191) NOT NULL DEFAULT '', -- cgit v1.2.3 From e53650d6c66a9338259dc7cd7f067b8e80d6ce19 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Wed, 8 May 2019 20:12:54 +0200 Subject: another DB update to fix uid_mid index in item table and add xchan_photo_m index to xchan table --- install/schema_mysql.sql | 5 +++-- install/schema_postgres.sql | 3 ++- 2 files changed, 5 insertions(+), 3 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 61cee0693..e7550455f 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -665,7 +665,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `mimetype` (`mimetype`), KEY `mid` (`mid`), KEY `parent_mid` (`parent_mid`), - KEY `uid_mid` (`mid`,`uid`), + KEY `uid_mid` (`uid`,`mid`), KEY `comment_policy` (`comment_policy`), KEY `layout_mid` (`layout_mid`), KEY `public_policy` (`public_policy`), @@ -1324,7 +1324,8 @@ CREATE TABLE IF NOT EXISTS `xchan` ( KEY `xchan_selfcensored` (`xchan_selfcensored`), KEY `xchan_system` (`xchan_system`), KEY `xchan_pubforum` (`xchan_pubforum`), - KEY `xchan_deleted` (`xchan_deleted`) + KEY `xchan_deleted` (`xchan_deleted`), + KEY `xchan_photo_m` (`xchan_photo_m`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS `xchat` ( diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index e56e054b0..c1c222b37 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -650,7 +650,7 @@ create index "item_revision" on item ("revision"); create index "item_mimetype" on item ("mimetype"); create index "item_mid" on item ("mid"); create index "item_parent_mid" on item ("parent_mid"); -create index "item_uid_mid" on item ("mid","uid"); +create index "item_uid_mid" on item ("uid","mid"); create index "item_public_policy" on item ("public_policy"); create index "item_comment_policy" on item ("comment_policy"); create index "item_layout_mid" on item ("layout_mid"); @@ -1312,6 +1312,7 @@ create index "xchan_selfcensored" on xchan ("xchan_selfcensored"); create index "xchan_system" on xchan ("xchan_system"); create index "xchan_pubforum" on xchan ("xchan_pubforum"); create index "xchan_deleted" on xchan ("xchan_deleted"); +create index "xchan_photo_m" on xchan ("xchan_photo_m"); CREATE TABLE "xchat" ( "xchat_id" serial NOT NULL, -- cgit v1.2.3