Na}{

File Content: 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 */;

--
-- Database: `gnusocial1209`
--

-- --------------------------------------------------------

--
-- Table structure for table `attention`
--

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;

-- --------------------------------------------------------

--
-- Table structure for table `avatar`
--

CREATE TABLE `avatar` (
  `profile_id` int(11) NOT NULL COMMENT 'foreign key to profile table',
  `original` tinyint(4) DEFAULT '0' COMMENT 'uploaded by user or generated?',
  `width` int(11) NOT NULL COMMENT 'image width',
  `height` int(11) NOT NULL COMMENT 'image height',
  `mediatype` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'file type',
  `filename` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'local filename, if local',
  `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`,`width`,`height`),
  KEY `avatar_profile_id_idx` (`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `bookmark`
--

CREATE TABLE `bookmark` (
  `id` char(36) COLLATE utf8mb4_bin NOT NULL,
  `profile_id` int(11) NOT NULL,
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
  `description` text COLLATE utf8mb4_bin,
  `created` datetime NOT NULL,
  PRIMARY KEY (`uri`),
  UNIQUE KEY `bookmark_id_key` (`id`),
  KEY `bookmark_created_idx` (`created`),
  KEY `bookmark_url_idx` (`url`),
  KEY `bookmark_profile_id_idx` (`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `section` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'configuration section',
  `setting` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'configuration setting',
  `value` text COLLATE utf8mb4_bin COMMENT 'configuration value',
  PRIMARY KEY (`section`,`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `confirm_address`
--

CREATE TABLE `confirm_address` (
  `code` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'good random code',
  `user_id` int(11) DEFAULT '0' COMMENT 'user who requested confirmation',
  `address` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'address (email, xmpp, SMS, etc.)',
  `address_extra` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'carrier ID, for SMS',
  `address_type` varchar(8) COLLATE utf8mb4_bin NOT NULL COMMENT 'address type ("email", "xmpp", "sms")',
  `claimed` datetime DEFAULT NULL COMMENT 'date this was claimed for queueing',
  `sent` datetime DEFAULT NULL COMMENT 'date this was sent for queueing',
  `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;

--
-- Dumping data for table `confirm_address`
--

INSERT INTO `confirm_address` VALUES
('[[confirm_address]]', 1, '[[admin_email]]', NULL, 'email', NULL, NULL, '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `consumer`
--

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;

-- --------------------------------------------------------

--
-- Table structure for table `conversation`
--

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;

-- --------------------------------------------------------

--
-- Table structure for table `fave`
--

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;

-- --------------------------------------------------------

--
-- Table structure for table `feedsub`
--

CREATE TABLE `feedsub` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'FeedSub local unique id',
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'FeedSub uri',
  `huburi` text COLLATE utf8mb4_bin COMMENT 'FeedSub hub-uri',
  `secret` text COLLATE utf8mb4_bin COMMENT 'FeedSub stored secret',
  `sub_state` enum('subscribe','active','unsubscribe','inactive','nohub') COLLATE utf8mb4_bin NOT NULL COMMENT 'subscription state',
  `sub_start` datetime DEFAULT NULL COMMENT 'subscription start',
  `sub_end` datetime DEFAULT NULL COMMENT 'subscription end',
  `last_update` datetime DEFAULT NULL COMMENT 'when this record was last updated',
  `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 `feedsub_uri_key` (`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `file`
--

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 ;

-- --------------------------------------------------------

--
-- Table structure for table `file_oembed`
--

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_redirection`
--

CREATE TABLE `file_redirection` (
  `urlhash` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'sha256 hash of the URL',
  `url` text COLLATE utf8mb4_bin COMMENT 'short URL (or any other kind of redirect) for file (id)',
  `file_id` int(11) DEFAULT NULL COMMENT 'short URL for what URL/file',
  `redirections` int(11) DEFAULT NULL COMMENT 'redirect count',
  `httpcode` int(11) DEFAULT NULL COMMENT 'HTTP status code (20x, 30x, etc.)',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified',
  PRIMARY KEY (`urlhash`)
) 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;

-- --------------------------------------------------------

--
-- Table structure for table `file_to_post`
--

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;

-- --------------------------------------------------------

--
-- Table structure for table `foreign_link`
--

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;

--
-- Dumping data for table `foreign_service`
--

INSERT INTO `foreign_service` VALUES
(1, 'Twitter', 'Twitter Micro-blogging service', '[[regtime]]', '[[regtime]]'),
(2, 'Facebook', 'Facebook', '[[regtime]]', '[[regtime]]'),
(3, 'FacebookConnect', 'Facebook Connect', '[[regtime]]', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `foreign_subscription`
--

CREATE TABLE `foreign_subscription` (
  `service` int(11) NOT NULL COMMENT 'service where relationship happens',
  `subscriber` bigint(20) NOT NULL COMMENT 'subscriber on foreign service',
  `subscribed` bigint(20) NOT NULL COMMENT 'subscribed user',
  `created` datetime NOT NULL COMMENT 'date this record was created',
  PRIMARY KEY (`service`,`subscriber`,`subscribed`),
  KEY `foreign_subscription_subscriber_idx` (`service`,`subscriber`),
  KEY `foreign_subscription_subscribed_idx` (`service`,`subscribed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `foreign_user`
--

CREATE TABLE `foreign_user` (
  `id` bigint(20) NOT NULL COMMENT 'unique numeric key on foreign service',
  `service` int(11) NOT NULL COMMENT 'foreign key to service',
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'identifying URI',
  `nickname` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'nickname on foreign service',
  `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`,`service`),
  UNIQUE KEY `foreign_user_uri_key` (`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `group_alias`
--

CREATE TABLE `group_alias` (
  `alias` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'additional nickname for the group',
  `group_id` int(11) NOT NULL COMMENT 'group profile is blocked from',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date alias was created',
  PRIMARY KEY (`alias`),
  KEY `group_alias_group_id_idx` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `group_block`
--

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_inbox`
--

CREATE TABLE `group_inbox` (
  `group_id` int(11) NOT NULL COMMENT 'group receiving the message',
  `notice_id` int(11) NOT NULL COMMENT 'notice received',
  `created` datetime NOT NULL COMMENT 'date the notice was created',
  PRIMARY KEY (`group_id`,`notice_id`),
  KEY `group_inbox_created_idx` (`created`),
  KEY `group_inbox_notice_id_idx` (`notice_id`),
  KEY `group_inbox_group_id_created_notice_id_idx` (`group_id`,`created`,`notice_id`)
) 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 `group_member`
--

CREATE TABLE `group_member` (
  `group_id` int(11) NOT NULL COMMENT 'foreign key to user_group',
  `profile_id` int(11) NOT NULL COMMENT 'foreign key to profile table',
  `is_admin` tinyint(4) DEFAULT '0' COMMENT 'is this user an admin?',
  `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universal identifier',
  `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 (`group_id`,`profile_id`),
  UNIQUE KEY `group_member_uri_key` (`uri`),
  KEY `group_member_profile_id_idx` (`profile_id`),
  KEY `group_member_created_idx` (`created`),
  KEY `group_member_profile_id_created_idx` (`profile_id`,`created`),
  KEY `group_member_group_id_created_idx` (`group_id`,`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `happening`
--

CREATE TABLE `happening` (
  `id` char(36) COLLATE utf8mb4_bin NOT NULL COMMENT 'UUID',
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `profile_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `location` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
  `description` text COLLATE utf8mb4_bin,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `happening_uri_key` (`uri`),
  KEY `happening_created_idx` (`created`),
  KEY `happening_start_end_idx` (`start_time`,`end_time`)
) 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;

-- --------------------------------------------------------

--
-- Table structure for table `hubsub`
--

CREATE TABLE `hubsub` (
  `hashkey` char(40) COLLATE utf8mb4_bin NOT NULL COMMENT 'HubSub hashkey',
  `topic` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'HubSub topic',
  `callback` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'HubSub callback',
  `secret` text COLLATE utf8mb4_bin COMMENT 'HubSub stored secret',
  `sub_start` datetime DEFAULT NULL COMMENT 'subscription start',
  `sub_end` datetime DEFAULT NULL COMMENT 'subscription end',
  `errors` int(11) DEFAULT '0' COMMENT 'Queue handling error count, is reset on success.',
  `error_start` datetime DEFAULT NULL COMMENT 'time of first error since latest success, should be null if no errors have been counted',
  `last_error` datetime DEFAULT NULL COMMENT 'time of last failure, if ever',
  `last_error_msg` text COLLATE utf8mb4_bin COMMENT 'Last error _message_',
  `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 (`hashkey`),
  KEY `hubsub_callback_idx` (`callback`),
  KEY `hubsub_topic_idx` (`topic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `invitation`
--

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 `local_group`
--

CREATE TABLE `local_group` (
  `group_id` int(11) NOT NULL COMMENT 'group represented',
  `nickname` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'group represented',
  `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 (`group_id`),
  UNIQUE KEY `local_group_nickname_key` (`nickname`)
) 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;

-- --------------------------------------------------------

--
-- Table structure for table `login_token`
--

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 `magicsig`
--

CREATE TABLE `magicsig` (
  `user_id` int(11) NOT NULL COMMENT 'user id',
  `keypair` text COLLATE utf8mb4_bin COMMENT 'keypair text representation',
  `alg` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'algorithm',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
  `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universally unique identifier',
  `from_profile` int(11) NOT NULL COMMENT 'who the message is from',
  `to_profile` int(11) NOT NULL COMMENT 'who the message is to',
  `content` text COLLATE utf8mb4_bin COMMENT 'message content',
  `rendered` text COLLATE utf8mb4_bin COMMENT 'HTML version of the content',
  `url` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'URL of any attachment (image, video, bookmark, whatever)',
  `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',
  `source` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'source of comment, like "web", "im", or "clientname"',
  PRIMARY KEY (`id`),
  UNIQUE KEY `message_uri_key` (`uri`),
  KEY `message_from_idx` (`from_profile`),
  KEY `message_to_idx` (`to_profile`),
  KEY `message_created_idx` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 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;

-- --------------------------------------------------------

--
-- Table structure for table `nonce`
--

CREATE TABLE `nonce` (
  `consumer_key` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'unique identifier, root URL',
  `tok` char(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'buggy old value, ignored',
  `nonce` char(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'nonce',
  `ts` datetime NOT NULL COMMENT 'timestamp sent',
  `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`,`ts`,`nonce`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `notice`
--

CREATE TABLE `notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
  `profile_id` int(11) NOT NULL COMMENT 'who made the update',
  `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universally unique identifier, usually a tag URI',
  `content` text CHARACTER SET utf8mb4 COMMENT 'update content',
  `rendered` text COLLATE utf8mb4_bin COMMENT 'HTML version of the content',
  `url` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'URL of any attachment (image, video, bookmark, whatever)',
  `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',
  `reply_to` int(11) DEFAULT NULL COMMENT 'notice replied to (usually a guess)',
  `is_local` tinyint(4) DEFAULT '0' COMMENT 'notice was generated by a user',
  `source` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'source of comment, like "web", "im", or "clientname"',
  `conversation` int(11) DEFAULT NULL COMMENT 'the local numerical conversation id',
  `repeat_of` int(11) DEFAULT NULL COMMENT 'notice this is a repeat of',
  `object_type` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'URI representing activity streams object type',
  `verb` varchar(191) COLLATE utf8mb4_bin DEFAULT 'http://activitystrea.ms/schema/1.0/post' COMMENT 'URI representing activity streams verb',
  `scope` int(11) DEFAULT NULL COMMENT 'bit map for distribution scope; 0 = everywhere; 1 = this server only; 2 = addressees; 4 = followers; null = default',
  PRIMARY KEY (`id`),
  UNIQUE KEY `notice_uri_key` (`uri`),
  KEY `notice_created_id_is_local_idx` (`created`,`id`,`is_local`),
  KEY `notice_profile_id_idx` (`profile_id`,`created`,`id`),
  KEY `notice_repeat_of_created_id_idx` (`repeat_of`,`created`,`id`),
  KEY `notice_conversation_created_id_idx` (`conversation`,`created`,`id`),
  KEY `notice_object_type_idx` (`object_type`),
  KEY `notice_verb_idx` (`verb`),
  KEY `notice_profile_id_verb_idx` (`profile_id`,`verb`),
  KEY `notice_url_idx` (`url`),
  KEY `notice_replyto_idx` (`reply_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `notice_location`
--

CREATE TABLE `notice_location` (
  `notice_id` int(11) NOT NULL COMMENT 'notice that is the reply',
  `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',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified',
  PRIMARY KEY (`notice_id`),
  KEY `notice_location_location_id_idx` (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `notice_prefs`
--

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;

--
-- Dumping data for table `notice_source`
--

INSERT INTO `notice_source` VALUES
('Afficheur', 'Afficheur', 'http://afficheur.sourceforge.jp/', 0, '[[regtime]]', '[[regtime]]'),
('AgentSolo.com', 'AgentSolo.com', 'http://www.agentsolo.com/', 0, '[[regtime]]', '[[regtime]]'),
('DarterosStatus', 'Darteros Status', 'http://www.darteros.com/doc/Darteros_Status', 0, '[[regtime]]', '[[regtime]]'),
('Do', 'Gnome Do', 'http://do.davebsd.com/wiki/index.php?title=Microblog_Plugin', 0, '[[regtime]]', '[[regtime]]'),
('Facebook', 'Facebook', 'http://apps.facebook.com/identica/', 0, '[[regtime]]', '[[regtime]]'),
('Gwibber', 'Gwibber', 'http://launchpad.net/gwibber', 0, '[[regtime]]', '[[regtime]]'),
('HelloTxt', 'HelloTxt', 'http://hellotxt.com/', 0, '[[regtime]]', '[[regtime]]'),
('IdentiCurse', 'IdentiCurse', 'http://identicurse.net/', 0, '[[regtime]]', '[[regtime]]'),
('IdentiFox', 'IdentiFox', 'http://www.bitbucket.org/uncryptic/identifox/', 0, '[[regtime]]', '[[regtime]]'),
('Jiminy', 'Jiminy', '', 0, '[[regtime]]', '[[regtime]]'),
('LaTwit', 'LaTwit', 'http://latwit.mac65.com/', 0, '[[regtime]]', '[[regtime]]'),
('LiveTweeter', 'LiveTweeter', 'http://addons.songbirdnest.com/addon/1204', 0, '[[regtime]]', '[[regtime]]'),
('Mobidentica', 'Mobidentica', 'http://www.substanceofcode.com/software/mobidentica/', 0, '[[regtime]]', '[[regtime]]'),
('Pikchur', 'Pikchur', 'http://www.pikchur.com/', 0, '[[regtime]]', '[[regtime]]'),
('Ping.fm', 'Ping.fm', 'http://ping.fm/', 0, '[[regtime]]', '[[regtime]]'),
('StatusNet Android', 'Android', 'http://status.net/android', 0, '[[regtime]]', '[[regtime]]'),
('StatusNet Blackberry', 'Blackberry', 'http://status.net/blackberry', 0, '[[regtime]]', '[[regtime]]'),
('StatusNet Desktop', 'StatusNet Desktop', 'http://status.net/desktop', 0, '[[regtime]]', '[[regtime]]'),
('StatusNet Mobile', 'StatusNet Mobile', 'http://status.net/mobile', 0, '[[regtime]]', '[[regtime]]'),
('StatusNet iPhone', 'iPhone', 'http://status.net/iphone', 0, '[[regtime]]', '[[regtime]]'),
('TweetDeck', 'TweetDeck', 'http://www.tweetdeck.com/', 0, '[[regtime]]', '[[regtime]]'),
('Twidge', 'Twidge', 'http://software.complete.org/twidge', 0, '[[regtime]]', '[[regtime]]'),
('Updating.Me', 'Updating.Me', 'http://updating.me/', 0, '[[regtime]]', '[[regtime]]'),
('adium', 'Adium', 'http://www.adiumx.com/', 0, '[[regtime]]', '[[regtime]]'),
('anyio', 'Any.IO', 'http://any.io/', 0, '[[regtime]]', '[[regtime]]'),
('betwittered', 'BeTwittered', 'http://www.32hours.com/betwitteredinfo/', 0, '[[regtime]]', '[[regtime]]'),
('bti', 'bti', 'http://gregkh.github.com/bti/', 0, '[[regtime]]', '[[regtime]]'),
('choqok', 'Choqok', 'http://choqok.gnufolks.org/', 0, '[[regtime]]', '[[regtime]]'),
('cliqset', 'Cliqset', 'http://www.cliqset.com/', 0, '[[regtime]]', '[[regtime]]'),
('deskbar', 'Deskbar-Applet', 'http://www.gnome.org/projects/deskbar-applet/', 0, '[[regtime]]', '[[regtime]]'),
('drupal', 'Drupal', 'http://drupal.org/', 0, '[[regtime]]', '[[regtime]]'),
('eventbox', 'EventBox', 'http://thecosmicmachine.com/eventbox/', 0, '[[regtime]]', '[[regtime]]'),
('feed2omb', 'feed2omb', 'http://projects.ciarang.com/p/feed2omb/', 0, '[[regtime]]', '[[regtime]]'),
('gNewBook', 'gNewBook', 'http://www.gnewbook.org/', 0, '[[regtime]]', '[[regtime]]'),
('get2gnow', 'get2gnow', 'http://uberchicgeekchick.com/?projects=get2gnow', 0, '[[regtime]]', '[[regtime]]'),
('gravity', 'Gravity', 'http://mobileways.de/gravity', 0, '[[regtime]]', '[[regtime]]'),
('identica-mode', 'Emacs Identica-mode', 'http://nongnu.org/identica-mode/', 0, '[[regtime]]', '[[regtime]]'),
('identicatools', 'Laconica Tools', 'http://bitbucketlabs.net/laconica-tools/', 0, '[[regtime]]', '[[regtime]]'),
('identichat', 'identichat', 'http://identichat.prosody.im/', 0, '[[regtime]]', '[[regtime]]'),
('identitwitch', 'IdentiTwitch', 'http://richfish.org/identitwitch/', 0, '[[regtime]]', '[[regtime]]'),
('livetweeter', 'livetweeter', 'http://addons.songbirdnest.com/addon/1204', 0, '[[regtime]]', '[[regtime]]'),
('maisha', 'Maisha', 'http://maisha.grango.org/', 0, '[[regtime]]', '[[regtime]]'),
('mbpidgin', 'mbpidgin', '', 0, '[[regtime]]', '[[regtime]]'),
('moconica', 'Moconica', 'http://moconica.com/', 0, '[[regtime]]', '[[regtime]]'),
('mustard', 'mustard', 'http://mustard.macno.org', 0, '[[regtime]]', '[[regtime]]'),
('nambu', 'Nambu', 'http://www.nambu.com/', 0, '[[regtime]]', '[[regtime]]'),
('peoplebrowsr', 'PeopleBrowsr', 'http://www.peoplebrowsr.com/', 0, '[[regtime]]', '[[regtime]]'),
('pingvine', 'PingVine', 'http://pingvine.com/', 0, '[[regtime]]', '[[regtime]]'),
('pocketwit', 'PockeTwit', '', 0, '[[regtime]]', '[[regtime]]'),
('posty', 'Posty', 'http://spreadingfunkyness.com/posty/', 0, '[[regtime]]', '[[regtime]]'),
('qtwitter', 'qTwitter', 'http://qtwitter.ayoy.net/', 0, '[[regtime]]', '[[regtime]]'),
('qwit', 'Qwit', '', 0, '[[regtime]]', '[[regtime]]'),
('royalewithcheese', 'Royale With Cheese', 'http://p.hellyeah.org/', 0, '[[regtime]]', '[[regtime]]'),
('rss.me', 'rss.me', 'http://rss.me/', 0, '[[regtime]]', '[[regtime]]'),
('rssdent', 'rssdent', 'http://github.com/zcopley/rssdent/tree/master', 0, '[[regtime]]', '[[regtime]]'),
('rygh.no', 'rygh.no', 'http://rygh.no/', 0, '[[regtime]]', '[[regtime]]'),
('ryghsms', 'ryghsms', 'http://sms.rygh.no/', 0, '[[regtime]]', '[[regtime]]'),
('smob', 'SMOB', 'http://smob.sioc-project.org/', 0, '[[regtime]]', '[[regtime]]'),
('socialoomphBfD4pMqz31', 'SocialOomph', 'http://www.socialoomph.com/', 0, '[[regtime]]', '[[regtime]]'),
('spaz', 'Spaz', 'http://funkatron.com/spaz', 0, '[[regtime]]', '[[regtime]]'),
('tarpipe', 'tarpipe', 'http://tarpipe.com/', 0, '[[regtime]]', '[[regtime]]'),
('tjunar', 'Tjunar', 'http://nederflash.nl/boek/titels/tjunar-air', 0, '[[regtime]]', '[[regtime]]'),
('tr.im', 'tr.im', 'http://tr.im/', 0, '[[regtime]]', '[[regtime]]'),
('triklepost', 'Tricklepost', 'http://github.com/zcopley/tricklepost/tree/master', 0, '[[regtime]]', '[[regtime]]'),
('tweenky', 'Tweenky', 'http://beta.tweenky.com/', 0, '[[regtime]]', '[[regtime]]'),
('twhirl', 'Twhirl', 'http://www.twhirl.org/', 0, '[[regtime]]', '[[regtime]]'),
('twibble', 'twibble', 'http://www.twibble.de/', 0, '[[regtime]]', '[[regtime]]'),
('twidge', 'Twidge', 'http://software.complete.org/twidge', 0, '[[regtime]]', '[[regtime]]'),
('twidroid', 'twidroid', 'http://www.twidroid.com/', 0, '[[regtime]]', '[[regtime]]'),
('twittelator', 'Twittelator', 'http://www.stone.com/iPhone/Twittelator/', 0, '[[regtime]]', '[[regtime]]'),
('twitter', 'Twitter', 'http://twitter.com/', 0, '[[regtime]]', '[[regtime]]'),
('twitterfeed', 'twitterfeed', 'http://twitterfeed.com/', 0, '[[regtime]]', '[[regtime]]'),
('twitterphoto', 'TwitterPhoto', 'http://richfish.org/twitterphoto/', 0, '[[regtime]]', '[[regtime]]'),
('twitterpm', 'Net::Twitter', 'http://search.cpan.org/dist/Net-Twitter/', 0, '[[regtime]]', '[[regtime]]'),
('twittertools', 'Twitter Tools', 'http://wordpress.org/extend/plugins/twitter-tools/', 0, '[[regtime]]', '[[regtime]]'),
('twitux', 'Twitux', 'http://live.gnome.org/DanielMorales/Twitux', 0, '[[regtime]]', '[[regtime]]'),
('twitvim', 'TwitVim', 'http://vim.sourceforge.net/scripts/script.php?script_id=2204', 0, '[[regtime]]', '[[regtime]]'),
('urfastr', 'urfastr', 'http://urfastr.net/', 0, '[[regtime]]', '[[regtime]]'),
('yatca', 'Yatca', 'http://www.yatca.com/', 0, '[[regtime]]', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `notice_tag`
--

CREATE TABLE `notice_tag` (
  `tag` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT 'hash tag associated with this notice',
  `notice_id` int(11) NOT NULL COMMENT 'notice tagged',
  `created` datetime NOT NULL COMMENT 'date this record was created',
  PRIMARY KEY (`tag`,`notice_id`),
  KEY `notice_tag_created_idx` (`created`),
  KEY `notice_tag_notice_id_idx` (`notice_id`),
  KEY `notice_tag_tag_created_notice_id_idx` (`tag`,`created`,`notice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_application`
--

CREATE TABLE `oauth_application` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
  `owner` int(11) NOT NULL COMMENT 'owner of the application',
  `consumer_key` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'application consumer key',
  `name` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'name of the application',
  `description` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'description of the application',
  `icon` varchar(191) COLLATE utf8mb4_bin DEFAULT '/theme/base/default-avatar-stream.png' COMMENT 'application icon',
  `source_url` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'application homepage - used for source link',
  `organization` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'name of the organization running the application',
  `homepage` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'homepage for the organization',
  `callback_url` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'url to redirect to after authentication',
  `type` tinyint(4) DEFAULT '0' COMMENT 'type of app, 1 = browser, 2 = desktop',
  `access_type` tinyint(4) DEFAULT '0' COMMENT 'default access type, bit 1 = read, bit 2 = write',
  `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 `oauth_application_name_key` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 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 `oid_associations`
--

CREATE TABLE `oid_associations` (
  `server_url` blob NOT NULL,
  `handle` varchar(191) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `secret` blob,
  `issued` int(11) DEFAULT NULL,
  `lifetime` int(11) DEFAULT NULL,
  `assoc_type` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`server_url`(191),`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `oid_nonces`
--

CREATE TABLE `oid_nonces` (
  `server_url` varchar(2047) COLLATE utf8mb4_bin DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  `salt` char(40) COLLATE utf8mb4_bin DEFAULT NULL,
  UNIQUE KEY `oid_nonces_server_url_timestamp_salt_key` (`server_url`(191),`timestamp`,`salt`)
) 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;

-- --------------------------------------------------------

--
-- Table structure for table `ostatus_profile`
--

CREATE TABLE `ostatus_profile` (
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `profile_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `peopletag_id` int(11) DEFAULT NULL,
  `feeduri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
  `salmonuri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
  `avatar` text COLLATE utf8mb4_bin,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`uri`),
  UNIQUE KEY `ostatus_profile_profile_id_key` (`profile_id`),
  UNIQUE KEY `ostatus_profile_group_id_key` (`group_id`),
  UNIQUE KEY `ostatus_profile_peopletag_id_key` (`peopletag_id`),
  UNIQUE KEY `ostatus_profile_feeduri_key` (`feeduri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `poll`
--

CREATE TABLE `poll` (
  `id` char(36) COLLATE utf8mb4_bin NOT NULL COMMENT 'UUID',
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `profile_id` int(11) DEFAULT NULL,
  `question` text COLLATE utf8mb4_bin,
  `options` text COLLATE utf8mb4_bin,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `poll_uri_key` (`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `poll_response`
--

CREATE TABLE `poll_response` (
  `id` char(36) COLLATE utf8mb4_bin NOT NULL COMMENT 'UUID of the response',
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'UUID to the response notice',
  `poll_id` char(36) COLLATE utf8mb4_bin NOT NULL COMMENT 'UUID of poll being responded to',
  `profile_id` int(11) DEFAULT NULL,
  `selection` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `poll_uri_key` (`uri`),
  UNIQUE KEY `poll_response_poll_id_profile_id_key` (`poll_id`,`profile_id`),
  KEY `poll_response_profile_id_poll_id_index` (`profile_id`,`poll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `profile`
--

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 ;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` VALUES
(1, '[[admin_username]]', '[[admin_username]]', '[[softurl]]/index.php/[[admin_username]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[[regtime]]', '[[regtime]]');

-- --------------------------------------------------------

--
-- 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;

-- --------------------------------------------------------

--
-- Table structure for table `profile_list`
--

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;

-- --------------------------------------------------------

--
-- Table structure for table `profile_role`
--

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;

--
-- Dumping data for table `profile_role`
--

INSERT INTO `profile_role` VALUES
(1, 'administrator', '[[regtime]]'),
(1, 'moderator', '[[regtime]]'),
(1, 'owner', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `profile_tag`
--

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 `queue_item`
--

CREATE TABLE `queue_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
  `frame` blob NOT NULL COMMENT 'data: object reference or opaque string',
  `transport` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'queue for what? "email", "xmpp", "sms", "irc", ...',
  `created` datetime NOT NULL COMMENT 'date this record was created',
  `claimed` datetime DEFAULT NULL COMMENT 'date this item was claimed',
  PRIMARY KEY (`id`),
  KEY `queue_item_created_idx` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 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;

-- --------------------------------------------------------

--
-- Table structure for table `remember_me`
--

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 `reply`
--

CREATE TABLE `reply` (
  `notice_id` int(11) NOT NULL COMMENT 'notice that is the reply',
  `profile_id` int(11) NOT NULL COMMENT 'profile replied to',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified',
  `replied_id` int(11) DEFAULT NULL COMMENT 'notice replied to (not used, see notice.reply_to)',
  PRIMARY KEY (`notice_id`,`profile_id`),
  KEY `reply_notice_id_idx` (`notice_id`),
  KEY `reply_profile_id_idx` (`profile_id`),
  KEY `reply_replied_id_idx` (`replied_id`),
  KEY `reply_profile_id_modified_notice_id_idx` (`profile_id`,`modified`,`notice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `rsvp`
--

CREATE TABLE `rsvp` (
  `id` char(36) COLLATE utf8mb4_bin NOT NULL COMMENT 'UUID',
  `uri` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `profile_id` int(11) DEFAULT NULL,
  `event_uri` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'Event URI',
  `response` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Y, N, or ? for three-state yes, no, maybe',
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rsvp_uri_key` (`uri`),
  UNIQUE KEY `rsvp_profile_event_key` (`profile_id`,`event_uri`),
  KEY `rsvp_created_idx` (`created`)
) 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;

-- --------------------------------------------------------

--
-- Table structure for table `session`
--

CREATE TABLE `session` (
  `id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'session ID',
  `session_data` text COLLATE utf8mb4_bin COMMENT 'session 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 (`id`),
  KEY `session_modified_idx` (`modified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `sms_carrier`
--

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;

--
-- Dumping data for table `sms_carrier`
--

INSERT INTO `sms_carrier` VALUES
(100056, '3 River Wireless', '%s@sms.3rivers.net', '[[regtime]]', '[[regtime]]'),
(100057, '7-11 Speakout', '%s@cingularme.com', '[[regtime]]', '[[regtime]]'),
(100058, 'Airtel (Karnataka, India)', '%s@airtelkk.com', '[[regtime]]', '[[regtime]]'),
(100059, 'Alaska Communications Systems', '%s@msg.acsalaska.com', '[[regtime]]', '[[regtime]]'),
(100060, 'Alltel Wireless', '%s@message.alltel.com', '[[regtime]]', '[[regtime]]'),
(100061, 'AT&T Wireless', '%s@txt.att.net', '[[regtime]]', '[[regtime]]'),
(100062, 'Bell Mobility (Canada)', '%s@txt.bell.ca', '[[regtime]]', '[[regtime]]'),
(100063, 'Boost Mobile', '%s@myboostmobile.com', '[[regtime]]', '[[regtime]]'),
(100064, 'Cellular One (Dobson)', '%s@mobile.celloneusa.com', '[[regtime]]', '[[regtime]]'),
(100065, 'Cingular (Postpaid)', '%s@cingularme.com', '[[regtime]]', '[[regtime]]'),
(100066, 'Centennial Wireless', '%s@cwemail.com', '[[regtime]]', '[[regtime]]'),
(100067, 'Cingular (GoPhone prepaid)', '%s@cingularme.com', '[[regtime]]', '[[regtime]]'),
(100068, 'Claro (Nicaragua)', '%s@ideasclaro-ca.com', '[[regtime]]', '[[regtime]]'),
(100069, 'Comcel', '%s@comcel.com.co', '[[regtime]]', '[[regtime]]'),
(100070, 'Cricket', '%s@sms.mycricket.com', '[[regtime]]', '[[regtime]]'),
(100071, 'CTI', '%s@sms.ctimovil.com.ar', '[[regtime]]', '[[regtime]]'),
(100072, 'Emtel (Mauritius)', '%s@emtelworld.net', '[[regtime]]', '[[regtime]]'),
(100073, 'Fido (Canada)', '%s@fido.ca', '[[regtime]]', '[[regtime]]'),
(100074, 'General Communications Inc.', '%s@msg.gci.net', '[[regtime]]', '[[regtime]]'),
(100075, 'Globalstar', '%s@msg.globalstarusa.com', '[[regtime]]', '[[regtime]]'),
(100076, 'Helio', '%s@myhelio.com', '[[regtime]]', '[[regtime]]'),
(100077, 'Illinois Valley Cellular', '%s@ivctext.com', '[[regtime]]', '[[regtime]]'),
(100078, 'i wireless', '%s.iws@iwspcs.net', '[[regtime]]', '[[regtime]]'),
(100079, 'Meteor (Ireland)', '%s@sms.mymeteor.ie', '[[regtime]]', '[[regtime]]'),
(100080, 'Mero Mobile (Nepal)', '%s@sms.spicenepal.com', '[[regtime]]', '[[regtime]]'),
(100081, 'MetroPCS', '%s@mymetropcs.com', '[[regtime]]', '[[regtime]]'),
(100082, 'Movicom', '%s@movimensaje.com.ar', '[[regtime]]', '[[regtime]]'),
(100083, 'Mobitel (Sri Lanka)', '%s@sms.mobitel.lk', '[[regtime]]', '[[regtime]]'),
(100084, 'Movistar (Colombia)', '%s@movistar.com.co', '[[regtime]]', '[[regtime]]'),
(100085, 'MTN (South Africa)', '%s@sms.co.za', '[[regtime]]', '[[regtime]]'),
(100086, 'MTS (Canada)', '%s@text.mtsmobility.com', '[[regtime]]', '[[regtime]]'),
(100087, 'Nextel (Argentina)', '%s@nextel.net.ar', '[[regtime]]', '[[regtime]]'),
(100088, 'Orange (Poland)', '%s@orange.pl', '[[regtime]]', '[[regtime]]'),
(100089, 'Personal (Argentina)', '%s@personal-net.com.ar', '[[regtime]]', '[[regtime]]'),
(100090, 'Plus GSM (Poland)', '%s@text.plusgsm.pl', '[[regtime]]', '[[regtime]]'),
(100091, 'President''s Choice (Canada)', '%s@txt.bell.ca', '[[regtime]]', '[[regtime]]'),
(100092, 'Qwest', '%s@qwestmp.com', '[[regtime]]', '[[regtime]]'),
(100093, 'Rogers (Canada)', '%s@pcs.rogers.com', '[[regtime]]', '[[regtime]]'),
(100094, 'Sasktel (Canada)', '%s@sms.sasktel.com', '[[regtime]]', '[[regtime]]'),
(100095, 'Setar Mobile email (Aruba)', '%s@mas.aw', '[[regtime]]', '[[regtime]]'),
(100096, 'Solo Mobile', '%s@txt.bell.ca', '[[regtime]]', '[[regtime]]'),
(100097, 'Sprint (PCS)', '%s@messaging.sprintpcs.com', '[[regtime]]', '[[regtime]]'),
(100098, 'Sprint (Nextel)', '%s@page.nextel.com', '[[regtime]]', '[[regtime]]'),
(100099, 'Suncom', '%s@tms.suncom.com', '[[regtime]]', '[[regtime]]'),
(100100, 'T-Mobile', '%s@tmomail.net', '[[regtime]]', '[[regtime]]'),
(100101, 'T-Mobile (Austria)', '%s@sms.t-mobile.at', '[[regtime]]', '[[regtime]]'),
(100102, 'Telus Mobility (Canada)', '%s@msg.telus.com', '[[regtime]]', '[[regtime]]'),
(100103, 'Thumb Cellular', '%s@sms.thumbcellular.com', '[[regtime]]', '[[regtime]]'),
(100104, 'Tigo (Formerly Ola)', '%s@sms.tigo.com.co', '[[regtime]]', '[[regtime]]'),
(100105, 'Unicel', '%s@utext.com', '[[regtime]]', '[[regtime]]'),
(100106, 'US Cellular', '%s@email.uscc.net', '[[regtime]]', '[[regtime]]'),
(100107, 'Verizon', '%s@vtext.com', '[[regtime]]', '[[regtime]]'),
(100108, 'Virgin Mobile (Canada)', '%s@vmobile.ca', '[[regtime]]', '[[regtime]]'),
(100109, 'Virgin Mobile (USA)', '%s@vmobl.com', '[[regtime]]', '[[regtime]]'),
(100110, 'YCC', '%s@sms.ycc.ru', '[[regtime]]', '[[regtime]]'),
(100111, 'Orange (UK)', '%s@orange.net', '[[regtime]]', '[[regtime]]'),
(100112, 'Cincinnati Bell Wireless', '%s@gocbw.com', '[[regtime]]', '[[regtime]]'),
(100113, 'T-Mobile Germany', '%s@t-mobile-sms.de', '[[regtime]]', '[[regtime]]'),
(100114, 'Vodafone Germany', '%s@vodafone-sms.de', '[[regtime]]', '[[regtime]]'),
(100115, 'E-Plus', '%s@smsmail.eplus.de', '[[regtime]]', '[[regtime]]'),
(100116, 'Cellular South', '%s@csouth1.com', '[[regtime]]', '[[regtime]]'),
(100117, 'ChinaMobile (139)', '%s@139.com', '[[regtime]]', '[[regtime]]'),
(100118, 'Dialog Axiata', '%s@dialog.lk', '[[regtime]]', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `subscriber` int(11) NOT NULL COMMENT 'profile listening',
  `subscribed` int(11) NOT NULL COMMENT 'profile being listened to',
  `jabber` tinyint(4) DEFAULT '1' COMMENT 'deliver jabber messages',
  `sms` tinyint(4) DEFAULT '1' COMMENT 'deliver sms messages',
  `token` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'authorization token',
  `secret` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'token secret',
  `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universally unique identifier',
  `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 (`subscriber`,`subscribed`),
  UNIQUE KEY `subscription_uri_key` (`uri`),
  KEY `subscription_subscriber_idx` (`subscriber`,`created`),
  KEY `subscription_subscribed_idx` (`subscribed`,`created`),
  KEY `subscription_token_idx` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `subscription`
--

INSERT INTO `subscription` VALUES
(1, 1, 1, 1, NULL, NULL, NULL, '[[regtime]]', '[[regtime]]');

-- --------------------------------------------------------

--
-- 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;

-- --------------------------------------------------------

--
-- Table structure for table `tagsub`
--

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 `token`
--

CREATE TABLE `token` (
  `consumer_key` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'unique identifier, root URL',
  `tok` char(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'identifying value',
  `secret` char(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'secret value',
  `type` tinyint(4) DEFAULT '0' COMMENT 'request or access',
  `state` tinyint(4) DEFAULT '0' COMMENT 'for requests, 0 = initial, 1 = authorized, 2 = used',
  `verifier` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'verifier string for OAuth 1.0a',
  `verified_callback` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'verified callback URL for OAuth 1.0a',
  `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`,`tok`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Table structure for table `usage_stats`
--

CREATE TABLE `usage_stats` (
  `type` varchar(191) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'Type of countable entity',
  `count` int(11) DEFAULT '0' COMMENT 'Number of entities of this type',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date this record was modified',
  PRIMARY KEY (`type`),
  UNIQUE KEY `usage_stats_key` (`type`),
  KEY `user_stats_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `usage_stats`
--

INSERT INTO `usage_stats` VALUES
('comments', 0, '[[regtime]]'),
('posts', 0, '[[regtime]]'),
('users', 0, '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL COMMENT 'foreign key to profile table',
  `nickname` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'nickname or username, duped in profile',
  `password` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'salted password, can be null for OpenID users',
  `email` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'email address for password recovery etc.',
  `incomingemail` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'email address for post-by-email',
  `emailnotifysub` tinyint(4) DEFAULT '1' COMMENT 'Notify by email of subscriptions',
  `emailnotifyfav` tinyint(4) DEFAULT NULL COMMENT 'Notify by email of favorites',
  `emailnotifynudge` tinyint(4) DEFAULT '1' COMMENT 'Notify by email of nudges',
  `emailnotifymsg` tinyint(4) DEFAULT '1' COMMENT 'Notify by email of direct messages',
  `emailnotifyattn` tinyint(4) DEFAULT '1' COMMENT 'Notify by email of @-replies',
  `language` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'preferred language',
  `timezone` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'timezone',
  `emailpost` tinyint(4) DEFAULT '1' COMMENT 'Post by email',
  `sms` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'sms phone number',
  `carrier` int(11) DEFAULT NULL COMMENT 'foreign key to sms_carrier',
  `smsnotify` tinyint(4) DEFAULT '0' COMMENT 'whether to send notices to SMS',
  `smsreplies` tinyint(4) DEFAULT '0' COMMENT 'whether to send notices to SMS on replies',
  `smsemail` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'built from sms and carrier',
  `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universally unique identifier, usually a tag URI',
  `autosubscribe` tinyint(4) DEFAULT '0' COMMENT 'automatically subscribe to users who subscribe to us',
  `subscribe_policy` tinyint(4) DEFAULT '0' COMMENT '0 = anybody can subscribe; 1 = require approval',
  `urlshorteningservice` varchar(50) COLLATE utf8mb4_bin DEFAULT 'internal' COMMENT 'service to use for auto-shortening URLs',
  `private_stream` tinyint(4) DEFAULT '0' COMMENT 'whether to limit all notices to followers only',
  `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 `user_nickname_key` (`nickname`),
  UNIQUE KEY `user_email_key` (`email`),
  UNIQUE KEY `user_incomingemail_key` (`incomingemail`),
  UNIQUE KEY `user_sms_key` (`sms`),
  UNIQUE KEY `user_uri_key` (`uri`),
  KEY `user_smsemail_idx` (`smsemail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', NULL, NULL, 1, NULL, 1, 1, 1, NULL, NULL, 1, NULL, NULL, 0, 0, NULL, '[[softurl]]/index.php/user/1', 0, 0, 'internal', 0, '[[regtime]]', '[[regtime]]');

-- --------------------------------------------------------

--
-- Table structure for table `user_group`
--

CREATE TABLE `user_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
  `profile_id` int(11) NOT NULL COMMENT 'foreign key to profile table',
  `nickname` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'nickname for addressing',
  `fullname` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'display name',
  `homepage` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'URL, cached so we dont regenerate',
  `description` text COLLATE utf8mb4_bin COMMENT 'group description',
  `location` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'related physical location, if any',
  `original_logo` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'original size logo',
  `homepage_logo` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'homepage (profile) size logo',
  `stream_logo` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'stream-sized logo',
  `mini_logo` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'mini logo',
  `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',
  `uri` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'universal identifier',
  `mainpage` varchar(191) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'page for group info to link to',
  `join_policy` tinyint(4) DEFAULT NULL COMMENT '0=open; 1=requires admin approval',
  `force_scope` tinyint(4) DEFAULT NULL COMMENT '0=never,1=sometimes,-1=always',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_group_uri_key` (`uri`),
  KEY `user_group_nickname_idx` (`nickname`),
  KEY `user_group_profile_id_idx` (`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 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`
--

CREATE TABLE `user_openid` (
  `canonical` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'OpenID canonical string',
  `display` varchar(191) COLLATE utf8mb4_bin NOT NULL COMMENT 'OpenID display string',
  `user_id` int(11) NOT NULL COMMENT 'User ID for OpenID 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 (`canonical`),
  UNIQUE KEY `user_openid_display_key` (`display`),
  KEY `user_openid_user_id_idx` (`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 */;

Name	Size	Permission
images	---	0755
php53	---	0755
php56	---	0755
php71	---	0755
php81	---	0755
php82	---	0755
config.php	588 bytes	0644
edit.php	4291 bytes	0644
edit.xml	433 bytes	0644
fileindex.php	271 bytes	0644
gnu.sql	80972 bytes	0644
gnu.zip	22620434 bytes	0644
import.php	3346 bytes	0644
info.xml	2750 bytes	0644
install.js	924 bytes	0644
install.php	5936 bytes	0644
install.xml	1093 bytes	0644
md5	1230 bytes	0644
notes.txt	83 bytes	0644