487 Commits

Author SHA1 Message Date
Max Kostikov fc658a25d7 Update schema_mysql.sql 2019-11-01 19:37:46 +01:00
Max Kostikov 308619a726 Drop llink index 2019-11-01 17:47:16 +01:00
Max Kostikov e87d8d9856 Change llink column type and drop index 2019-11-01 17:46:28 +01:00
Max Kostikov 0be82602ce Update schema_mysql.sql 2019-09-23 14:23:47 +02:00
Max Kostikov b42c42692e Update plink type for MySQL 2019-09-23 14:14:02 +02:00
zotlabs 39c0a7525b emoji reactions from hubzilla becoming top level posts on zap because of missing object 2019-07-11 20:47:38 -07:00
Mario Vavti e53650d6c6 another DB update to fix uid_mid index in item table and add xchan_photo_m index to xchan table 2019-05-08 20:12:54 +02:00
Mario 24f3bc9f0c Channel update 2019-05-08 19:55:21 +02:00
Max Kostikov 257ba570ee Update INSTALL.txt 2019-04-15 15:18:35 +02:00
Max Kostikov 775285cdf8 Update comment htconfig.sample.php 2019-04-10 14:14:14 +02:00
Mario Vavti fad26a49be mysql: remove some unused indices and add thr_parent index. pgsql: sync indices with mysql indices after testing on hub.disroot.org and add thr_parent 2019-03-19 10:52:10 +01:00
Mario Vavti e262de9b2d update nginx and lighttpd sample server configs to explicit dissalow access to util 2019-01-27 18:05:46 +01:00
Max Kostikov bb91064416 Add expires for photo 2018-11-29 10:35:56 +01:00
Max Kostikov 72d2fe2fd4 Add expires for photo 2018-11-29 10:35:11 +01:00
Mario Vavti 0525eb2d29 update sql schemas to include update column in pconfig table
(cherry picked from commit ae97649948)
2018-11-19 10:45:33 +01:00
zotlabs 770fdb2b7d dreport updates 2018-11-12 16:08:22 -08:00
zotlabs 3fe2491b73 didn't need xchan_portable_id 2018-11-08 15:53:48 -08:00
zotlabs 4e6758e31d item db updates 2018-11-08 15:51:52 -08:00
zotlabs fabcf841c9 z6 work 2018-11-05 19:34:10 -08:00
Mario Vavti dd3ec468f6 fix issue #1281 - hubloc default values 2018-10-06 23:05:45 +02:00
Max Kostikov 11945ce7bc Update schema_mysql.sql 2018-09-27 23:48:25 +02:00
Max Kostikov bb3d908bcf Update schema_postgres.sql 2018-09-27 23:46:58 +02:00
zotlabs be3b630474 important hyperdrive component 2018-09-09 20:53:20 -07:00
zotlabs 7ecb337405 redirect stdout/stderr on cron command 2018-08-28 22:43:37 -07:00
zotlabs f15c1c4e54 hubloc DB changes needed for z6 2018-08-13 21:18:20 -07:00
Mario Vavti 5c5a808290 Merge remote-tracking branch 'mike/master' into dev 2018-08-09 11:07:38 +02:00
Mario Vavti 5c30b2f271 update install.txt 2018-08-08 09:10:03 +02:00
Max Kostikov 0d48cb959f Add XMLreader in PHP requirements 2018-08-03 19:32:51 +02:00
zotlabs d908f53607 add app_options field 2018-08-02 22:49:30 -07:00
Mario Vavti 9ffb10c0e6 update install instructions 2018-06-06 22:11:55 +02:00
Mario 469809183d update oauth related tables to use bigint/int(10) for user_id column. this is to be more consistent with the rest of the tables and fixes issue #1180 2018-05-20 22:42:47 +02:00
Mario Vavti 55e1026c98 improve abconfig queries 2018-05-20 20:48:52 +02:00
Mario Vavti 192b69b11a update nginx conf to address issue #1155 2018-05-05 08:38:20 +02:00
zotlabs 43e55eb9a6 Active channels information is a bit imprecise. Provide a higher accuracy method. This will require a transition period 2018-04-16 21:40:43 -07:00
zotlabs 4915a4efbb OAuth2 integration 2018-04-03 21:08:40 -07:00
Mario Vavti ade11568f9 update mysql schema 2018-03-11 13:53:53 +01:00
Mario Vavti 9c02c66ed3 remove redundant comma 2018-03-09 09:17:57 +01:00
zotlabs a454aad124 federated polls: GNU-Social requires us to preserve the original order of the poll answers for use in making a vote, unlike diaspora (which selects by guid) and activitypub (which selects by non-localisable text). 2018-03-07 15:39:14 -08:00
zotlabs f0f58dade8 federated polls: add poll_author which will be necessary for Diaspora federation 2018-03-06 15:31:45 -08:00
Mario Vavti 6593dff9f5 missed one index in the last update 2018-02-28 10:21:22 +01:00
Mario Vavti 51c0e5a988 another DB upgrade to address some long running maintenance queries 2018-02-26 09:58:42 +01:00
zotlabs 277da43631 provide DB compatibility for poll and voting implementations across several platforms 2018-02-22 20:52:39 -08:00
Mario Vavti 6ef0116f09 more index finetuning to fix the expire query 2018-02-20 10:26:32 +01:00
zotlabs 4e6072fb29 Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge 2018-02-16 16:42:45 -08:00
zotlabs f492f808f4 refactor of the DB update system. Updates are now stored individually in Zotlabs/Update/_nnnn.php and are objects; so only the pending updates need to be loaded and executed rather than all historical updates. There is one single number (DB_UPDATE_VERSION) representing the current version and it is EQUAL TO the last known update. A dummy update _1201 was created to address the difference in counting behaviour; it will be executed on the next change of DB_UPDATE_VERSION as well as the next update. The database config values are also loaded from disk on every update immediately before setting the update lock in order to reduce timing conflicts and race conditions. 2018-02-16 12:42:02 -08:00
Mario Vavti 9e251a1abc some more DB tuning. 2018-02-15 19:24:15 +01:00
Mario Vavti 661c20e452 more db and queries finetuning 2018-02-08 09:47:49 +01:00
Mario Vavti 9d55a254dc this will fix the cards query and keep the rest intact 2018-02-04 22:37:30 +01:00
Mario Vavti f9aecf5d4c superfluous , 2018-02-04 21:17:41 +01:00
Mario Vavti c57b2d25b2 remove indices from mysql schema file 2018-02-04 21:13:24 +01:00