We now fetch the number of registered users

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 197a5423217b25c491a5bc1553f5916518623cac..a8c12f272b41805c1cae49008618ac1538fc4f1a 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
--- Friendica 3.5.3-dev (Asparagus)
--- DB_UPDATE_VERSION 1234
+-- Friendica 3.6-dev (Asparagus)
+-- DB_UPDATE_VERSION 1238
 -- ------------------------------------------
 
 
@@ -184,8 +184,8 @@ CREATE TABLE IF NOT EXISTS `contact` (
         INDEX `addr_uid` (`addr`(32),`uid`),
         INDEX `nurl_uid` (`nurl`(32),`uid`),
         INDEX `nick_uid` (`nick`(32),`uid`),
-        INDEX `dfrn-id` (`dfrn-id`),
-        INDEX `issued-id` (`issued-id`)
+        INDEX `dfrn-id` (`dfrn-id`(64)),
+        INDEX `issued-id` (`issued-id`(64))
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
 --
@@ -216,7 +216,8 @@ CREATE TABLE IF NOT EXISTS `conversation` (
        `source` mediumtext,
        `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
         PRIMARY KEY(`item-uri`),
-        INDEX `conversation-uri` (`conversation-uri`)
+        INDEX `conversation-uri` (`conversation-uri`),
+        INDEX `received` (`received`)
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
 --
@@ -273,29 +274,6 @@ CREATE TABLE IF NOT EXISTS `fcontact` (
         UNIQUE INDEX `url` (`url`(190))
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
---
--- TABLE ffinder
---
-CREATE TABLE IF NOT EXISTS `ffinder` (
-       `id` int(10) unsigned NOT NULL auto_increment,
-       `uid` int(10) unsigned NOT NULL DEFAULT 0,
-       `cid` int(10) unsigned NOT NULL DEFAULT 0,
-       `fid` int(10) unsigned NOT NULL DEFAULT 0,
-        PRIMARY KEY(`id`)
-) DEFAULT COLLATE utf8mb4_general_ci;
-
---
--- TABLE fserver
---
-CREATE TABLE IF NOT EXISTS `fserver` (
-       `id` int(11) NOT NULL auto_increment,
-       `server` varchar(255) NOT NULL DEFAULT '',
-       `posturl` varchar(255) NOT NULL DEFAULT '',
-       `key` text,
-        PRIMARY KEY(`id`),
-        INDEX `server` (`server`(32))
-) DEFAULT COLLATE utf8mb4_general_ci;
-
 --
 -- TABLE fsuggest
 --
@@ -396,13 +374,11 @@ CREATE TABLE IF NOT EXISTS `group` (
 --
 CREATE TABLE IF NOT EXISTS `group_member` (
        `id` int(10) unsigned NOT NULL auto_increment,
-       `uid` int(10) unsigned NOT NULL DEFAULT 0,
        `gid` int(10) unsigned NOT NULL DEFAULT 0,
        `contact-id` int(10) unsigned NOT NULL DEFAULT 0,
         PRIMARY KEY(`id`),
         INDEX `contactid` (`contact-id`),
-        INDEX `gid_contactid` (`gid`,`contact-id`),
-        UNIQUE INDEX `uid_gid_contactid` (`uid`,`gid`,`contact-id`)
+        UNIQUE INDEX `gid_contactid` (`gid`,`contact-id`)
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
 --
@@ -416,6 +392,7 @@ CREATE TABLE IF NOT EXISTS `gserver` (
        `site_name` varchar(255) NOT NULL DEFAULT '',
        `info` text,
        `register_policy` tinyint(1) NOT NULL DEFAULT 0,
+       `registered-users` int(10) NOT NULL DEFAULT 0,
        `poco` varchar(255) NOT NULL DEFAULT '',
        `noscrape` varchar(255) NOT NULL DEFAULT '',
        `network` varchar(32) NOT NULL DEFAULT '',
@@ -529,11 +506,11 @@ CREATE TABLE IF NOT EXISTS `item` (
        `rendered-html` mediumtext,
        `global` tinyint(1) NOT NULL DEFAULT 0,
         PRIMARY KEY(`id`),
-        INDEX `guid` (`guid`),
-        INDEX `uri` (`uri`),
+        INDEX `guid` (`guid`(191)),
+        INDEX `uri` (`uri`(191)),
         INDEX `parent` (`parent`),
-        INDEX `parent-uri` (`parent-uri`),
-        INDEX `extid` (`extid`),
+        INDEX `parent-uri` (`parent-uri`(191)),
+        INDEX `extid` (`extid`(191)),
         INDEX `uid_id` (`uid`,`id`),
         INDEX `uid_contactid_id` (`uid`,`contact-id`,`id`),
         INDEX `uid_created` (`uid`,`created`),
@@ -546,7 +523,7 @@ CREATE TABLE IF NOT EXISTS `item` (
         INDEX `authorid_created` (`author-id`,`created`),
         INDEX `ownerid` (`owner-id`),
         INDEX `uid_uri` (`uid`,`uri`(190)),
-        INDEX `resource-id` (`resource-id`),
+        INDEX `resource-id` (`resource-id`(191)),
         INDEX `contactid_allowcid_allowpid_denycid_denygid` (`contact-id`,`allow_cid`(10),`allow_gid`(10),`deny_cid`(10),`deny_gid`(10)),
         INDEX `uid_type_changed` (`uid`,`type`(190),`changed`),
         INDEX `contactid_verb` (`contact-id`,`verb`(190)),
@@ -557,22 +534,6 @@ CREATE TABLE IF NOT EXISTS `item` (
         INDEX `uid_ownerlink` (`uid`,`owner-link`(190))
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
---
--- TABLE item_id
---
-CREATE TABLE IF NOT EXISTS `item_id` (
-       `id` int(11) NOT NULL auto_increment,
-       `iid` int(11) NOT NULL DEFAULT 0,
-       `uid` int(11) NOT NULL DEFAULT 0,
-       `sid` varchar(255) NOT NULL DEFAULT '',
-       `service` varchar(255) NOT NULL DEFAULT '',
-        PRIMARY KEY(`id`),
-        INDEX `uid` (`uid`),
-        INDEX `sid` (`sid`),
-        INDEX `service` (`service`(32)),
-        INDEX `iid` (`iid`)
-) DEFAULT COLLATE utf8mb4_general_ci;
-
 --
 -- TABLE locks
 --
@@ -610,7 +571,7 @@ CREATE TABLE IF NOT EXISTS `mail` (
         INDEX `convid` (`convid`),
         INDEX `uri` (`uri`(64)),
         INDEX `parent-uri` (`parent-uri`(64)),
-        INDEX `contactid` (`contact-id`)
+        INDEX `contactid` (`contact-id`(32))
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
 --
@@ -947,23 +908,6 @@ CREATE TABLE IF NOT EXISTS `sign` (
         UNIQUE INDEX `iid` (`iid`)
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
---
--- TABLE spam
---
-CREATE TABLE IF NOT EXISTS `spam` (
-       `id` int(11) NOT NULL auto_increment,
-       `uid` int(11) NOT NULL DEFAULT 0,
-       `spam` int(11) NOT NULL DEFAULT 0,
-       `ham` int(11) NOT NULL DEFAULT 0,
-       `term` varchar(255) NOT NULL DEFAULT '',
-       `date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-        PRIMARY KEY(`id`),
-        INDEX `uid` (`uid`),
-        INDEX `spam` (`spam`),
-        INDEX `ham` (`ham`),
-        INDEX `term` (`term`)
-) DEFAULT COLLATE utf8mb4_general_ci;
-
 --
 -- TABLE term
 --
@@ -1084,7 +1028,6 @@ CREATE TABLE IF NOT EXISTS `user` (
        `account_expired` tinyint(1) NOT NULL DEFAULT 0,
        `account_expires_on` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
        `expire_notification_sent` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-       `service_class` varchar(32) NOT NULL DEFAULT '',
        `def_gid` int(11) NOT NULL DEFAULT 0,
        `allow_cid` mediumtext,
        `allow_gid` mediumtext,