X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=4a8350f84fdf8bf6e30d495e9bcab61b4d5386a0;hb=0b4a6f8eaca0d1396e7e944cd4735a573bd1d111;hp=08902d8930e4400340dd067620ba644fef6dddd4;hpb=8cfa93b730f87edf98c52e9a38cfa015ce1f5d47;p=friendica.git diff --git a/database.sql b/database.sql index 08902d8930..4a8350f84f 100644 --- a/database.sql +++ b/database.sql @@ -87,6 +87,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `pending` tinyint(1) NOT NULL DEFAULT '1', `rating` tinyint(1) NOT NULL DEFAULT '0', `reason` text NOT NULL, + `info` MEDIUMTEXT NOT NULL AFTER `reason`, `profile-id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -377,6 +378,7 @@ CREATE TABLE IF NOT EXISTS `user` ( `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; @@ -441,3 +443,13 @@ CREATE TABLE IF NOT EXISTS `hook` ( ) 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; + + + +