IP : 18.188.140.10Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
./
./
var/
softaculous/
monsta/
../
myweb/
../
typo7/
../
gnu/
gnu.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!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 `attention` ( `notice_id` int(11) NOT NULL COMMENT 'notice_id to give attention', `profile_id` int(11) NOT NULL COMMENT 'profile_id for feed receiver', `reason` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Optional reason why this was brought to the attention of profile_id', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`notice_id`,`profile_id`), KEY `attention_notice_id_idx` (`notice_id`), KEY `attention_profile_id_idx` (`profile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `consumer` ( `consumer_key` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'unique identifier, root URL', `consumer_secret` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'secret value', `seed` char(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'seed for new tokens by this consumer', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`consumer_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `conversation` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier, (again) unrelated to notice id since 2016-01-06', `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'URI of the conversation', `url` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Resolvable URL, preferrably remote (local can be generated on the fly)', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`id`), UNIQUE KEY `conversation_uri_key` (`uri`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;
-- -- Table structure for table `deleted_notice` --
CREATE TABLE `deleted_notice` ( `id` int(11) NOT NULL COMMENT 'notice ID', `profile_id` int(11) NOT NULL COMMENT 'profile that deleted the notice', `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'URI of the deleted notice', `act_created` datetime NOT NULL COMMENT 'date the notice record was created', `created` datetime NOT NULL COMMENT 'date the notice record was deleted', PRIMARY KEY (`id`), UNIQUE KEY `deleted_notice_uri_key` (`uri`), KEY `deleted_notice_profile_id_idx` (`profile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `fave` ( `notice_id` int(11) NOT NULL COMMENT 'notice that is the favorite', `user_id` int(11) NOT NULL COMMENT 'user who likes this notice', `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universally unique identifier, usually a tag URI', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`notice_id`,`user_id`), UNIQUE KEY `fave_uri_key` (`uri`), KEY `fave_notice_id_idx` (`notice_id`), KEY `fave_user_id_idx` (`user_id`,`modified`), KEY `fave_modified_idx` (`modified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `urlhash` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'sha256 of destination URL (url field)', `url` text COLLATE utf8mb4_bin COMMENT 'destination URL after following possible redirections', `filehash` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'sha256 of the file contents, only for locally stored files of course', `mimetype` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'mime type of resource', `size` int(11) DEFAULT NULL COMMENT 'size of resource when available', `title` text COLLATE utf8mb4_bin COMMENT 'title of resource when available', `date` int(11) DEFAULT NULL COMMENT 'date of resource according to http query', `protected` int(11) DEFAULT NULL COMMENT 'true when URL is private (needs login)', `filename` text COLLATE utf8mb4_bin COMMENT 'if file is stored locally (too) this is the filename', `width` int(11) DEFAULT NULL COMMENT 'width in pixels, if it can be described as such and data is available', `height` int(11) DEFAULT NULL COMMENT 'height in pixels, if it can be described as such and data is available', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`id`), UNIQUE KEY `file_urlhash_key` (`urlhash`), KEY `file_filehash_idx` (`filehash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;
CREATE TABLE `file_oembed` ( `file_id` int(11) NOT NULL COMMENT 'oEmbed for that URL/file', `version` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'oEmbed spec. version', `type` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'oEmbed type: photo, video, link, rich', `mimetype` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'mime type of resource', `provider` text COLLATE utf8mb4_bin COMMENT 'name of this oEmbed provider', `provider_url` text COLLATE utf8mb4_bin COMMENT 'URL of this oEmbed provider', `width` int(11) DEFAULT NULL COMMENT 'width of oEmbed resource when available', `height` int(11) DEFAULT NULL COMMENT 'height of oEmbed resource when available', `html` text COLLATE utf8mb4_bin COMMENT 'html representation of this oEmbed resource when applicable', `title` text COLLATE utf8mb4_bin COMMENT 'title of oEmbed resource when available', `author_name` text COLLATE utf8mb4_bin COMMENT 'author name for this oEmbed resource', `author_url` text COLLATE utf8mb4_bin COMMENT 'author URL for this oEmbed resource', `url` text COLLATE utf8mb4_bin COMMENT 'URL for this oEmbed resource when applicable (photo, link)', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`file_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `file_thumbnail` --
CREATE TABLE `file_thumbnail` ( `file_id` int(11) NOT NULL COMMENT 'thumbnail for what URL/file', `urlhash` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'sha256 of url field if non-empty', `url` text COLLATE utf8mb4_bin COMMENT 'URL of thumbnail', `filename` text COLLATE utf8mb4_bin COMMENT 'if stored locally, filename is put here', `width` int(11) NOT NULL DEFAULT '0' COMMENT 'width of thumbnail', `height` int(11) NOT NULL DEFAULT '0' COMMENT 'height of thumbnail', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`file_id`,`width`,`height`), KEY `file_thumbnail_file_id_idx` (`file_id`), KEY `file_thumbnail_urlhash_idx` (`urlhash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `file_to_post` ( `file_id` int(11) NOT NULL COMMENT 'id of URL/file', `post_id` int(11) NOT NULL COMMENT 'id of the notice it belongs to', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`file_id`,`post_id`), KEY `file_id_idx` (`file_id`), KEY `post_id_idx` (`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `foreign_link` ( `user_id` int(11) NOT NULL COMMENT 'link to user on this system, if exists', `foreign_id` bigint(20) NOT NULL COMMENT 'link to user on foreign service, if exists', `service` int(11) NOT NULL COMMENT 'foreign key to service', `credentials` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'authc credentials, typically a password', `noticesync` tinyint(4) DEFAULT '1' COMMENT 'notice synchronization, bit 1 = sync outgoing, bit 2 = sync incoming, bit 3 = filter local replies', `friendsync` tinyint(4) DEFAULT '2' COMMENT 'friend synchronization, bit 1 = sync outgoing, bit 2 = sync incoming', `profilesync` tinyint(4) DEFAULT '1' COMMENT 'profile synchronization, bit 1 = sync outgoing, bit 2 = sync incoming', `last_noticesync` datetime DEFAULT NULL COMMENT 'last time notices were imported', `last_friendsync` datetime DEFAULT NULL COMMENT 'last time friends were imported', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`,`foreign_id`,`service`), KEY `foreign_user_user_id_idx` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `foreign_service` --
CREATE TABLE `foreign_service` ( `id` int(11) NOT NULL COMMENT 'numeric key for service', `name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'name of the service', `description` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'description', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`id`), UNIQUE KEY `foreign_service_name_key` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `group_block` ( `group_id` int(11) NOT NULL COMMENT 'group profile is blocked from', `blocked` int(11) NOT NULL COMMENT 'profile that is blocked', `blocker` int(11) NOT NULL COMMENT 'user making the block', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date of blocking', PRIMARY KEY (`group_id`,`blocked`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `group_join_queue` --
CREATE TABLE `group_join_queue` ( `profile_id` int(11) NOT NULL COMMENT 'remote or local profile making the request', `group_id` int(11) NOT NULL DEFAULT '0' COMMENT 'remote or local group to join, if any', `created` datetime NOT NULL COMMENT 'date this record was created', PRIMARY KEY (`profile_id`,`group_id`), KEY `group_join_queue_profile_id_created_idx` (`profile_id`,`created`), KEY `group_join_queue_group_id_created_idx` (`group_id`,`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `homepage_blacklist` --
CREATE TABLE `homepage_blacklist` ( `pattern` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'blacklist pattern', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`pattern`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `invitation` ( `code` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'random code for an invitation', `user_id` int(11) NOT NULL COMMENT 'who sent the invitation', `address` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'invitation sent to', `address_type` varchar(8) COLLATE utf8mb4_bin NOT NULL COMMENT 'address type ("email", "xmpp", "sms")', `created` datetime NOT NULL COMMENT 'date this record was created', `registered_user_id` int(11) DEFAULT NULL COMMENT 'if the invitation is converted, who the new user is', PRIMARY KEY (`code`), KEY `invitation_address_idx` (`address`,`address_type`), KEY `invitation_user_id_idx` (`user_id`), KEY `invitation_registered_user_id_idx` (`registered_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `location_namespace` --
CREATE TABLE `location_namespace` ( `id` int(11) NOT NULL COMMENT 'identity for this namespace', `description` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'description of the namespace', `created` datetime NOT NULL COMMENT 'date the record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `login_token` ( `user_id` int(11) NOT NULL COMMENT 'user owning this token', `token` char(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'token useable for logging in', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `nickname_blacklist` --
CREATE TABLE `nickname_blacklist` ( `pattern` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'blacklist pattern', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`pattern`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `notice_prefs` ( `notice_id` int(11) NOT NULL COMMENT 'user', `namespace` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'namespace, like pluginname or category', `topic` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'preference key, i.e. description, age...', `data` blob COMMENT 'topic data, may be anything', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`notice_id`,`namespace`,`topic`), KEY `notice_prefs_notice_id_idx` (`notice_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `notice_source` --
CREATE TABLE `notice_source` ( `code` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'source code', `name` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'name of the source', `url` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'url to link to', `notice_id` int(11) NOT NULL COMMENT 'date this record was created', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `oauth_application_user` --
CREATE TABLE `oauth_application_user` ( `profile_id` int(11) NOT NULL COMMENT 'user of the application', `application_id` int(11) NOT NULL COMMENT 'id of the application', `access_type` tinyint(4) DEFAULT '0' COMMENT 'access type, bit 1 = read, bit 2 = write', `token` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'request or access token', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`profile_id`,`application_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `oauth_token_association` --
CREATE TABLE `oauth_token_association` ( `profile_id` int(11) NOT NULL COMMENT 'associated user', `application_id` int(11) NOT NULL COMMENT 'the application', `token` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'token used for this association', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`profile_id`,`application_id`,`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `old_school_prefs` --
CREATE TABLE `old_school_prefs` ( `user_id` int(11) NOT NULL COMMENT 'user who has the preference', `stream_mode_only` tinyint(4) DEFAULT '1' COMMENT 'No conversation streams', `conversation_tree` tinyint(4) DEFAULT '1' COMMENT 'Hierarchical tree view for conversations', `stream_nicknames` tinyint(4) DEFAULT '1' COMMENT 'Show nicknames for authors and addressees in streams', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `profile` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', `nickname` varchar(64) CHARACTER SET utf8mb4 NOT NULL COMMENT 'nickname or username', `fullname` text CHARACTER SET utf8mb4 COMMENT 'display name', `profileurl` text COLLATE utf8mb4_bin COMMENT 'URL, cached so we dont regenerate', `homepage` text CHARACTER SET utf8mb4 COMMENT 'identifying URL', `bio` text CHARACTER SET utf8mb4 COMMENT 'descriptive biography', `location` text CHARACTER SET utf8mb4 COMMENT 'physical location', `lat` decimal(10,7) DEFAULT NULL COMMENT 'latitude', `lon` decimal(10,7) DEFAULT NULL COMMENT 'longitude', `location_id` int(11) DEFAULT NULL COMMENT 'location id if possible', `location_ns` int(11) DEFAULT NULL COMMENT 'namespace for location', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`id`), KEY `profile_nickname_idx` (`nickname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=2 ;
-- -- Table structure for table `profile_block` --
CREATE TABLE `profile_block` ( `blocker` int(11) NOT NULL COMMENT 'user making the block', `blocked` int(11) NOT NULL COMMENT 'profile that is blocked', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date of blocking', PRIMARY KEY (`blocker`,`blocked`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `profile_list` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier', `tagger` int(11) NOT NULL COMMENT 'user making the tag', `tag` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'people tag', `description` text COLLATE utf8mb4_bin COMMENT 'description of the people tag', `private` tinyint(4) DEFAULT '0' COMMENT 'is this tag private', `created` datetime NOT NULL COMMENT 'date the tag was added', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date the tag was modified', `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universal identifier', `mainpage` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'page to link to', `tagged_count` int(11) DEFAULT '0' COMMENT 'number of people tagged with this tag by this user', `subscriber_count` int(11) DEFAULT '0' COMMENT 'number of subscribers to this tag', PRIMARY KEY (`tagger`,`tag`), UNIQUE KEY `profile_list_id_key` (`id`), KEY `profile_list_modified_idx` (`modified`), KEY `profile_list_tag_idx` (`tag`), KEY `profile_list_tagger_tag_idx` (`tagger`,`tag`), KEY `profile_list_tagged_count_idx` (`tagged_count`), KEY `profile_list_subscriber_count_idx` (`subscriber_count`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;
-- -- Table structure for table `profile_prefs` --
CREATE TABLE `profile_prefs` ( `profile_id` int(11) NOT NULL COMMENT 'user', `namespace` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'namespace, like pluginname or category', `topic` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'preference key, i.e. description, age...', `data` blob COMMENT 'topic data, may be anything', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`profile_id`,`namespace`,`topic`), KEY `profile_prefs_profile_id_idx` (`profile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `profile_role` ( `profile_id` int(11) NOT NULL COMMENT 'account having the role', `role` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'string representing the role', `created` datetime NOT NULL COMMENT 'date the role was granted', PRIMARY KEY (`profile_id`,`role`), KEY `profile_role_role_created_profile_id_idx` (`role`,`created`,`profile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `profile_tag` ( `tagger` int(11) NOT NULL COMMENT 'user making the tag', `tagged` int(11) NOT NULL COMMENT 'profile tagged', `tag` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'hash tag associated with this notice', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date the tag was added', PRIMARY KEY (`tagger`,`tagged`,`tag`), KEY `profile_tag_modified_idx` (`modified`), KEY `profile_tag_tagger_tag_idx` (`tagger`,`tag`), KEY `profile_tag_tagged_idx` (`tagged`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `profile_tag_subscription` --
CREATE TABLE `profile_tag_subscription` ( `profile_tag_id` int(11) NOT NULL COMMENT 'foreign key to profile_tag', `profile_id` int(11) NOT NULL COMMENT 'foreign key to profile table', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`profile_tag_id`,`profile_id`), KEY `profile_tag_subscription_profile_id_idx` (`profile_id`), KEY `profile_tag_subscription_created_idx` (`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `related_group` --
CREATE TABLE `related_group` ( `group_id` int(11) NOT NULL COMMENT 'foreign key to user_group', `related_group_id` int(11) NOT NULL COMMENT 'foreign key to user_group', `created` datetime NOT NULL COMMENT 'date this record was created', PRIMARY KEY (`group_id`,`related_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `remember_me` ( `code` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'good random code', `user_id` int(11) NOT NULL COMMENT 'user who is logged in', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `schema_version` --
CREATE TABLE `schema_version` ( `table_name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'Table name', `checksum` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'Checksum of schema array; a mismatch indicates we should check the table more thoroughly.', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`table_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `sms_carrier` ( `id` int(11) NOT NULL COMMENT 'primary key for SMS carrier', `name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'name of the carrier', `email_pattern` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'sprintf pattern for making an email address from a phone number', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`id`), UNIQUE KEY `sms_carrier_name_key` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `subscription_queue` --
CREATE TABLE `subscription_queue` ( `subscriber` int(11) NOT NULL COMMENT 'remote or local profile making the request', `subscribed` int(11) NOT NULL COMMENT 'remote or local profile being subscribed to', `created` datetime NOT NULL COMMENT 'date this record was created', PRIMARY KEY (`subscriber`,`subscribed`), KEY `subscription_queue_subscriber_created_idx` (`subscriber`,`created`), KEY `subscription_queue_subscribed_created_idx` (`subscribed`,`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `tagsub` ( `tag` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'hash tag associated with this subscription', `profile_id` int(11) NOT NULL COMMENT 'profile ID of subscribing user', `created` datetime NOT NULL COMMENT 'date this record was created', PRIMARY KEY (`tag`,`profile_id`), KEY `tagsub_created_idx` (`created`), KEY `tagsub_profile_id_tag_idx` (`profile_id`,`tag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `user_im_prefs` --
CREATE TABLE `user_im_prefs` ( `user_id` int(11) NOT NULL COMMENT 'user', `screenname` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'screenname on this service', `transport` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'transport (ex xmpp, aim)', `notify` tinyint(4) DEFAULT '0' COMMENT 'Notify when a new notice is sent', `replies` tinyint(4) DEFAULT '0' COMMENT 'Send replies from people not subscribed to', `updatefrompresence` tinyint(4) DEFAULT '0' COMMENT 'Send replies from people not subscribed to.', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`,`transport`), UNIQUE KEY `transport_screenname_key` (`transport`,`screenname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `user_location_prefs` --
CREATE TABLE `user_location_prefs` ( `user_id` int(11) NOT NULL COMMENT 'user who has the preference', `share_location` tinyint(4) DEFAULT '1' COMMENT 'Whether to share location data', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `user_openid_prefs` --
CREATE TABLE `user_openid_prefs` ( `user_id` int(11) NOT NULL COMMENT 'User whose prefs we are saving', `hide_profile_link` int(11) DEFAULT '0' COMMENT 'Whether to hide profile links from profile block', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `user_openid_trustroot` --
CREATE TABLE `user_openid_trustroot` ( `trustroot` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'OpenID trustroot string', `user_id` int(11) NOT NULL COMMENT 'User ID for OpenID trustroot owner', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`trustroot`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `user_poll_prefs` --
CREATE TABLE `user_poll_prefs` ( `user_id` int(11) NOT NULL COMMENT 'user id', `hide_responses` tinyint(4) DEFAULT '0' COMMENT 'Hide all poll responses', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `user_urlshortener_prefs` --
CREATE TABLE `user_urlshortener_prefs` ( `user_id` int(11) NOT NULL COMMENT 'user', `urlshorteningservice` varchar(50) COLLATE utf8mb4_bin DEFAULT 'internal' COMMENT 'service to use for auto-shortening URLs', `maxurllength` int(11) NOT NULL COMMENT 'urls greater than this length will be shortened, 0 = always, null = never', `maxnoticelength` int(11) NOT NULL COMMENT 'notices with content greater than this value will have all urls shortened, 0 = always, -1 = only if notice text is longer than max allowed', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- -- Table structure for table `user_username` --
CREATE TABLE `user_username` ( `provider_name` varchar(191) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'provider name', `username` varchar(191) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'username', `user_id` int(11) NOT NULL COMMENT 'notice id this title relates to', `created` datetime NOT NULL COMMENT 'date this record was created', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified', PRIMARY KEY (`provider_name`,`username`), KEY `user_id_idx` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;