X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=8cf72417906f931592514ffe2cbe2cc3c882bb7e;hb=f9f018ef083acb554003def1fc186bfc3102acc0;hp=2541de76a3ed6f02e6ab6a1e1d7f9ed1a3bbe03b;hpb=b02e30f1cfb3e92c65a5b8783256260a2e72ecc2;p=friendica.git diff --git a/database.sql b/database.sql index 2541de76a3..8cf7241790 100644 --- a/database.sql +++ b/database.sql @@ -53,15 +53,18 @@ CREATE TABLE IF NOT EXISTS `contact` ( `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `self` tinyint(1) NOT NULL DEFAULT '0', `rel` tinyint(1) NOT NULL DEFAULT '0', + `duplex` tinyint(1) NOT NULL DEFAULT '0', `network` char(255) NOT NULL, `name` char(255) NOT NULL, + `nick` char(255) NOT NULL, `photo` text NOT NULL, `thumb` text NOT NULL, + `micro` text NOT NULL, `site-pubkey` text NOT NULL, `issued-id` char(255) NOT NULL, `dfrn-id` char(255) NOT NULL, `url` char(255) NOT NULL, - `issued-pubkey` char(255) NOT NULL, + `lrdd` char(255) NOT NULL, `pubkey` text NOT NULL, `prvkey` text NOT NULL, `request` text NOT NULL, @@ -70,12 +73,14 @@ CREATE TABLE IF NOT EXISTS `contact` ( `confirm` text NOT NULL, `aes_allow` tinyint(1) NOT NULL DEFAULT '0', `ret-aes` tinyint(1) NOT NULL DEFAULT '0', - `ret-id` char(255) NOT NULL, - `ret-pubkey` text NOT NULL, + `usehub` tinyint(1) NOT NULL DEFAULT '0', + `subhub` tinyint(1) NOT NULL DEFAULT '0', + `hub-verify` char(255) NOT NULL, `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `term-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `priority` tinyint(3) NOT NULL, `blocked` tinyint(1) NOT NULL DEFAULT '1', `readonly` tinyint(1) NOT NULL DEFAULT '0', @@ -83,7 +88,13 @@ CREATE TABLE IF NOT EXISTS `contact` ( `rating` tinyint(1) NOT NULL DEFAULT '0', `reason` text NOT NULL, `profile-id` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `uid` (`uid`), + KEY `self` (`self`), + KEY `issued-id` (`issued-id`), + KEY `dfrn-id` (`dfrn-id`), + KEY `blocked` (`blocked`), + KEY `readonly` (`readonly`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -125,6 +136,7 @@ CREATE TABLE IF NOT EXISTS `intro` ( `uid` int(10) unsigned NOT NULL, `contact-id` int(11) NOT NULL, `knowyou` tinyint(1) NOT NULL, + `duplex` tinyint(1) NOT NULL DEFAULT '0', `note` text NOT NULL, `hash` char(255) NOT NULL, `datetime` datetime NOT NULL, @@ -145,6 +157,8 @@ CREATE TABLE IF NOT EXISTS `item` ( `uid` int(10) unsigned NOT NULL DEFAULT '0', `contact-id` int(10) unsigned NOT NULL DEFAULT '0', `type` char(255) NOT NULL, + `wall` tinyint(1) NOT NULL DEFAULT '0', + `gravity` tinyint(1) NOT NULL DEFAULT '0', `parent` int(10) unsigned NOT NULL DEFAULT '0', `parent-uri` char(255) CHARACTER SET ascii NOT NULL, `created` datetime NOT NULL, @@ -157,11 +171,15 @@ CREATE TABLE IF NOT EXISTS `item` ( `author-link` char(255) NOT NULL, `author-avatar` char(255) NOT NULL, `title` char(255) NOT NULL, - `body` text NOT NULL, + `body` mediumtext NOT NULL, + `verb` char(255) NOT NULL, + `object-type` char(255) NOT NULL, + `object` text NOT NULL, + `target-type` char(255) NOT NULL, + `target` text NOT NULL, `resource-id` char(255) NOT NULL, - `like` mediumtext NOT NULL, - `dislike` mediumtext NOT NULL, `tag` mediumtext NOT NULL, + `inform` mediumtext NOT NULL, `location` char(255) NOT NULL, `coord` char(255) NOT NULL, `allow_cid` mediumtext NOT NULL, @@ -177,6 +195,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `uid` (`uid`), KEY `contact-id` (`contact-id`), KEY `type` (`type`), + KEY `wall` (`wall`), KEY `parent` (`parent`), KEY `parent-uri` (`parent-uri`), KEY `created` (`created`), @@ -208,7 +227,6 @@ CREATE TABLE IF NOT EXISTS `mail` ( `contact-id` char(255) NOT NULL, `title` char(255) NOT NULL, `body` text NOT NULL, - `delivered` tinyint(1) NOT NULL, `seen` tinyint(1) NOT NULL, `replied` tinyint(1) NOT NULL, `uri` char(255) NOT NULL, @@ -267,6 +285,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( `country-name` char(255) NOT NULL, `gender` char(32) NOT NULL, `marital` char(255) NOT NULL, + `with` text NOT NULL, `sexual` char(255) NOT NULL, `politic` char(255) NOT NULL, `religion` char(255) NOT NULL, @@ -331,21 +350,27 @@ CREATE TABLE IF NOT EXISTS `user` ( `password` char(255) NOT NULL, `nickname` char(255) NOT NULL, `email` char(255) NOT NULL, + `openid` char(255) NOT NULL, `timezone` char(128) NOT NULL, `default-location` char(255) NOT NULL, + `allow_location` tinyint(1) NOT NULL DEFAULT '0', `theme` char(255) NOT NULL, `pubkey` text NOT NULL, `prvkey` text NOT NULL, - `verified` tinyint(1) unsigned NOT NULL DEFAULT '0', - `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0', - `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535', + `spubkey` text NOT NULL, + `sprvkey` text NOT NULL, + `verified` tinyint(1) unsigned NOT NULL DEFAULT '0', + `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0', + `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535', + `page-flags` int(11) unsigned NOT NULL DEFAULT '0', `pwdreset` char(255) NOT NULL, - `allow_cid` mediumtext NOT NULL, + `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, - `deny_cid` mediumtext NOT NULL, + `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, - PRIMARY KEY (`uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + PRIMARY KEY (`uid`), + KEY `nickname` (`nickname`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `register` ( @@ -355,4 +380,37 @@ CREATE TABLE IF NOT EXISTS `register` ( `uid` INT(11) UNSIGNED NOT NULL, `password` CHAR(255) NOT NULL, PRIMARY KEY (`id`) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; \ No newline at end of file +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `clients` ( +`client_id` VARCHAR( 20 ) NOT NULL , +`pw` VARCHAR( 20 ) NOT NULL , +`redirect_uri` VARCHAR( 200 ) NOT NULL , +PRIMARY KEY ( `client_id` ) +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `tokens` ( +`id` VARCHAR( 40 ) NOT NULL , +`client_id` VARCHAR( 20 ) NOT NULL , +`expires` INT NOT NULL , +`scope` VARCHAR( 200 ) NOT NULL , +PRIMARY KEY ( `id` ) +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `auth_codes` ( +`id` VARCHAR( 40 ) NOT NULL , +`client_id` VARCHAR( 20 ) NOT NULL , +`redirect_uri` VARCHAR( 200 ) NOT NULL , +`expires` INT NOT NULL , +`scope` VARCHAR( 250 ) NOT NULL , +PRIMARY KEY ( `id` ) +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `queue` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`cid` INT NOT NULL , +`created` DATETIME NOT NULL , +`last` DATETIME NOT NULL , +`content` MEDIUMTEXT NOT NULL +) ENGINE = MYISAM DEFAULT CHARSET=utf8;