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 |
|
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 |
|
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 |
|
zotlabs
|
be3b630474
|
important hyperdrive component
|
2018-09-09 20:53:20 -07:00 |
|
zotlabs
|
f15c1c4e54
|
hubloc DB changes needed for z6
|
2018-08-13 21:18:20 -07:00 |
|
zotlabs
|
d908f53607
|
add app_options field
|
2018-08-02 22:49:30 -07: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 |
|
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 |
|
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 |
|
zotlabs
|
7386fa57c8
|
remove column item.diaspora_meta, action items 2 and 3 of hubzilla issue #828
|
2017-11-16 17:13:48 -08:00 |
|
zotlabs
|
9d51318c53
|
table structure for pseudo or proxy channels (pchan)
|
2017-10-19 17:24:11 -07:00 |
|
Mario Vavti
|
d5ffa5508d
|
db update to add index to item.resource_id we query this in wikis a lot
|
2017-09-16 10:11:59 +02:00 |
|
Waitman Gobble
|
fee65f0c69
|
fix bogus semicolon
Line 655 should have comma instead of semicolon
|
2017-09-06 16:12:57 -05:00 |
|
Mario Vavti
|
e935473c5c
|
add combined index for item.uid and item.item_unseen. this speeds up notifications by a magnitude.
|
2017-09-01 21:27:59 +02:00 |
|
git-marijus
|
79a806f328
|
db update to add index for item.obj_type
|
2017-07-31 16:49:56 +02:00 |
|
Mario Vavti
|
f5735fb67b
|
missing abook_{my,their}_perms in pg schema and missing keys in mysql schema
|
2017-07-05 10:36:32 +02:00 |
|
zotlabs
|
02b7bc0803
|
cdav migration to core
|
2017-06-22 20:16:54 -07:00 |
|
zotlabs
|
425e13843e
|
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
|
2017-06-11 16:28:40 -07:00 |
|
Mario Vavti
|
fbb83d831b
|
some more innodb mysql scheme adjustments
|
2017-06-10 10:00:37 +02:00 |
|
git-marijus
|
7e4c880e1e
|
convert schema_mysql engine to InnoDB and charset utf8mb4
|
2017-06-09 12:56:36 +02:00 |
|
zotlabs
|
9dbd997141
|
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
|
2017-06-07 17:11:35 -07:00 |
|
Manuel Tancoigne
|
a17acfb04f
|
Fixed TEXT fields with default values (fixes #803) in mysql creation script.
|
2017-06-07 10:20:02 +02:00 |
|
zotlabs
|
f49ce500a1
|
fix a merge mixup on install/schema_msyql.php
|
2017-06-06 18:12:44 -07:00 |
|
zotlabs
|
98c18f416a
|
remove default for text/mediumtext sql fields
|
2017-05-31 16:00:33 -07:00 |
|
zotlabs
|
583a047e83
|
looks like a commit was lost someplace, but I'll re-do it later (convert sql schema files to default integers to int values); in any event change all the mysql strings that were 255 maxlength to 191 maxlength in case they get used as indexes down the line
|
2017-05-25 22:50:16 -07:00 |
|
zotlabs
|
57edfa7ae8
|
put back obsolete permission fields in abook and channel schema files so we can restore the old data without choking when upgrading the table type
|
2017-05-25 22:10:01 -07:00 |
|
zotlabs
|
bf580fcc06
|
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
|
2017-05-23 16:14:41 -07:00 |
|
zotlabs
|
3a9e5f0f98
|
schema fixes
|
2017-05-23 21:48:58 +02:00 |
|