X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=54950f0fd1ad7ee49d4bfb816683311974f8f4a0;hb=3da2b249516b415392a11ec62a4bb598080941d1;hp=dee066dfce8b943cd60df5dd7f2ea2b93cfecca1;hpb=d6dbcf8581ef4f93db386eb5c52b060831ee4762;p=friendica.git diff --git a/database.sql b/database.sql index dee066dfce..54950f0fd1 100644 --- a/database.sql +++ b/database.sql @@ -32,6 +32,17 @@ CREATE TABLE IF NOT EXISTS `challenge` ( -- -------------------------------------------------------- +CREATE TABLE IF NOT EXISTS `config` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `cat` char(255) NOT NULL, + `k` char(255) NOT NULL, + `v` text NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MYISAM DEFAULT CHARSET=utf8; + + + + -- -- Table structure for table `contact` -- @@ -40,15 +51,20 @@ CREATE TABLE IF NOT EXISTS `contact` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT 'owner uid', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `self` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'boolean 1 == info for local UID, primarily name and photo to use in item displays.', + `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, - `photo` text NOT NULL COMMENT 'remote photo URL initially until approved', + `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, @@ -57,16 +73,30 @@ 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', `pending` tinyint(1) NOT NULL DEFAULT '1', - `rating` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-5 reputation, 0 unknown, 1 call police, 5 inscrutable', - `reason` text NOT NULL COMMENT 'why a rating was given - will help friends decide to make friends or not', - `profile-id` int(11) NOT NULL DEFAULT '0' COMMENT 'which profile to display - 0 is public default', - PRIMARY KEY (`id`) + `rating` tinyint(1) NOT NULL DEFAULT '0', + `reason` text NOT NULL, + `info` mediumtext NOT NULL, + `profile-id` int(11) NOT NULL DEFAULT '0', + `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag', + 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; -- -------------------------------------------------------- @@ -78,6 +108,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( CREATE TABLE IF NOT EXISTS `group` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, + `deleted` tinyint(1) NOT NULL DEFAULT '0', `name` char(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -107,6 +138,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, @@ -123,14 +155,18 @@ CREATE TABLE IF NOT EXISTS `intro` ( CREATE TABLE IF NOT EXISTS `item` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `uri` char(255) CHARACTER SET ascii NOT NULL, + `uri` char(255) NOT NULL, `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, + `parent-uri` char(255) NOT NULL, + `thr-parent` char(255) NOT NULL, `created` datetime NOT NULL, `edited` datetime NOT NULL, + `changed` datetime NOT NULL, `owner-name` char(255) NOT NULL, `owner-link` char(255) NOT NULL, `owner-avatar` char(255) NOT NULL, @@ -138,12 +174,22 @@ 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, + `tag` mediumtext NOT NULL, + `inform` mediumtext NOT NULL, + `location` char(255) NOT NULL, + `coord` char(255) NOT NULL, `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, + `private` tinyint(1) NOT NULL DEFAULT '0', `visible` tinyint(1) NOT NULL DEFAULT '0', `unseen` tinyint(1) NOT NULL DEFAULT '1', `deleted` tinyint(1) NOT NULL DEFAULT '0', @@ -153,6 +199,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`), @@ -161,7 +208,6 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `deleted` (`deleted`), KEY `last-child` (`last-child`), KEY `unseen` (`unseen`), - KEY `unseen_2` (`unseen`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `body` (`body`), FULLTEXT KEY `allow_cid` (`allow_cid`), @@ -177,7 +223,7 @@ CREATE TABLE IF NOT EXISTS `item` ( -- CREATE TABLE IF NOT EXISTS `mail` ( - `id` int(10) unsigned NOT NULL, + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, `from-name` char(255) NOT NULL, `from-photo` char(255) NOT NULL, @@ -185,7 +231,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, @@ -203,20 +248,22 @@ CREATE TABLE IF NOT EXISTS `mail` ( CREATE TABLE IF NOT EXISTS `photo` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, + `contact-id` int(10) unsigned NOT NULL, `resource-id` char(255) NOT NULL, `created` datetime NOT NULL, `edited` datetime NOT NULL, `title` char(255) NOT NULL, `desc` text NOT NULL, + `album` char(255) NOT NULL, `filename` char(255) NOT NULL, `height` smallint(6) NOT NULL, `width` smallint(6) NOT NULL, `data` mediumblob NOT NULL, `scale` tinyint(3) NOT NULL, `profile` tinyint(1) NOT NULL DEFAULT '0', - `allow_uid` mediumtext NOT NULL, + `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, - `deny_uid` mediumtext NOT NULL, + `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -234,17 +281,21 @@ CREATE TABLE IF NOT EXISTS `profile` ( `is-default` tinyint(1) NOT NULL DEFAULT '0', `hide-friends` tinyint(1) NOT NULL DEFAULT '0', `name` char(255) NOT NULL, + `pdesc` char(255) NOT NULL, `dob` char(32) NOT NULL DEFAULT '0000-00-00', `address` char(255) NOT NULL, `locality` char(255) NOT NULL, `region` char(255) NOT NULL, `postal-code` char(32) NOT NULL, `country-name` char(255) NOT NULL, - `gender` char(8) NOT NULL, + `gender` char(32) NOT NULL, `marital` char(255) NOT NULL, + `showwith` tinyint(1) NOT NULL DEFAULT '0', + `with` text NOT NULL, `sexual` char(255) NOT NULL, `politic` char(255) NOT NULL, `religion` char(255) NOT NULL, + `keywords` text NOT NULL, `about` text NOT NULL, `summary` char(255) NOT NULL, `music` text NOT NULL, @@ -260,6 +311,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( `photo` char(255) NOT NULL, `thumb` char(255) NOT NULL, `publish` tinyint(1) NOT NULL DEFAULT '0', + `net-publish` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -272,7 +324,9 @@ CREATE TABLE IF NOT EXISTS `profile` ( CREATE TABLE IF NOT EXISTS `profile_check` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, + `cid` int(10) unsigned NOT NULL, `dfrn_id` char(255) NOT NULL, + `sec` char(255) NOT NULL, `expire` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -305,12 +359,116 @@ 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, + `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `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, - PRIMARY KEY (`uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + `maxreq` int(11) NOT NULL DEFAULT '10', + `allow_cid` mediumtext NOT NULL, + `allow_gid` mediumtext NOT NULL, + `deny_cid` mediumtext NOT NULL, + `deny_gid` mediumtext NOT NULL, + `openidserver` text NOT NULL, + PRIMARY KEY (`uid`), + KEY `nickname` (`nickname`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `register` ( + `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `hash` CHAR( 255 ) NOT NULL , + `created` DATETIME NOT NULL , + `uid` INT(11) UNSIGNED NOT NULL, + `password` CHAR(255) NOT NULL, + PRIMARY KEY (`id`) +) 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; + +CREATE TABLE IF NOT EXISTS `pconfig` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`uid` INT NOT NULL DEFAULT '0', +`cat` CHAR( 255 ) NOT NULL , +`k` CHAR( 255 ) NOT NULL , +`v` MEDIUMTEXT NOT NULL +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `hook` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`hook` CHAR( 255 ) NOT NULL , +`file` CHAR( 255 ) NOT NULL , +`function` CHAR( 255 ) NOT NULL +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `addon` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`name` CHAR( 255 ) NOT NULL , +`version` CHAR( 255 ) NOT NULL , +`installed` TINYINT( 1 ) NOT NULL DEFAULT '0' +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `event` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`uid` INT NOT NULL , +`cid` INT NOT NULL , +`created` DATETIME NOT NULL , +`edited` DATETIME NOT NULL , +`start` DATETIME NOT NULL , +`finish` DATETIME NOT NULL , +`desc` TEXT NOT NULL , +`location` TEXT NOT NULL , +`type` CHAR( 255 ) NOT NULL , +`adjust` TINYINT( 1 ) NOT NULL DEFAULT '1', +`allow_cid` MEDIUMTEXT NOT NULL , +`allow_gid` MEDIUMTEXT NOT NULL , +`deny_cid` MEDIUMTEXT NOT NULL , +`deny_gid` MEDIUMTEXT NOT NULL +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + +