diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 25 |
1 files changed, 22 insertions, 3 deletions
diff --git a/database.sql b/database.sql index 7578469ee..f67d083af 100644 --- a/database.sql +++ b/database.sql @@ -13,6 +13,7 @@ CREATE TABLE IF NOT EXISTS `account` ( `account_email` char(255) NOT NULL, `account_language` char(16) NOT NULL DEFAULT 'en', `account_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `account_lastlog` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `account_flags` int(10) unsigned NOT NULL, `account_roles` int(10) unsigned NOT NULL, `account_reset` char(255) NOT NULL, @@ -25,7 +26,9 @@ CREATE TABLE IF NOT EXISTS `account` ( KEY `account_service_class` (`account_service_class`), KEY `account_parent` (`account_parent`), KEY `account_flags` (`account_flags`), - KEY `account_roles` (`account_roles`) + KEY `account_roles` (`account_roles`), + KEY `account_lastlog` (`account_lastlog`), + KEY `account_expires` (`account_expires`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `addon` ( @@ -130,7 +133,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `prvkey` text NOT NULL, `batch` char(255) NOT NULL, `request` text NOT NULL, - `notify` text NOT NULL, + `notify` char(255) NOT NULL, `poll` text NOT NULL, `confirm` text NOT NULL, `poco` text NOT NULL, @@ -179,7 +182,8 @@ CREATE TABLE IF NOT EXISTS `contact` ( KEY `pending` (`pending`), KEY `hidden` (`hidden`), KEY `archive` (`archive`), - KEY `forum` (`forum`) + KEY `forum` (`forum`), + KEY `notify` (`notify`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `conv` ( @@ -222,6 +226,7 @@ CREATE TABLE IF NOT EXISTS `entity` ( `entity_pageflags` int(10) unsigned NOT NULL, `entity_max_anon_mail` int(11) NOT NULL DEFAULT '10', `entity_max_friend_req` int(11) NOT NULL DEFAULT '10', + `entity_passwd_reset` char(255) NOT NULL, `entity_default_gid` int(11) NOT NULL, `entity_allow_cid` mediumtext NOT NULL, `entity_allow_gid` mediumtext NOT NULL, @@ -402,10 +407,21 @@ CREATE TABLE IF NOT EXISTS `hook` ( `hook` char(255) NOT NULL, `file` char(255) NOT NULL, `function` char(255) NOT NULL, + `priority` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `hook` (`hook`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE IF NOT EXISTS `hubloc` ( + `hubloc_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `hubloc_zuid` char(255) NOT NULL, + `hubloc_url` char(255) NOT NULL, + `hubloc_key` text NOT NULL, + PRIMARY KEY (`hubloc_id`), + KEY `hubloc_zuid` (`hubloc_zuid`), + KEY `hubloc_url` (`hubloc_url`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + CREATE TABLE IF NOT EXISTS `intro` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, @@ -504,6 +520,9 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `moderated` (`moderated`), KEY `spam` (`spam`), KEY `author-name` (`author-name`), + KEY `uid_commented` (`uid`,`commented`), + KEY `uid_created` (`uid`,`created`), + KEY `uid_unseen` (`uid`,`unseen`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `body` (`body`), FULLTEXT KEY `allow_cid` (`allow_cid`), |