aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
Commit message (Collapse)AuthorAgeFilesLines
* provide DB compatibility for poll and voting implementations across several ↵zotlabs2018-02-221-0/+6
| | | | platforms
* table structure for pseudo or proxy channels (pchan)zotlabs2017-10-191-0/+13
|
* db update to add index to item.resource_id we query this in wikis a lotMario Vavti2017-09-161-0/+1
|
* add combined index for item.uid and item.item_unseen. this speeds up ↵Mario Vavti2017-09-011-0/+1
| | | | notifications by a magnitude.
* db update to add index for item.obj_typegit-marijus2017-07-311-0/+1
|
* missing abook_{my,their}_perms in pg schema and missing keys in mysql schemaMario Vavti2017-07-051-0/+4
|
* add the cdav pgsql schemasMario Vavti2017-07-041-0/+222
|
* danger - do not use 'char(n)' with postgres it creates a thing called a ↵zotlabs2017-05-151-22/+22
| | | | bpchar which is different than a normal text field in subtle ways.
* Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-05-071-1/+1
|\
| * :construction_worker::white_check_mark::bug: Import table structure in TravisCI.Klaus Weidenbach2017-05-061-1/+1
| | | | | | | | | | Fix a syntax error in schema_postres.sql which was discovered while working on this.
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-05-051-0/+2
|\|
| * abook_not_here flag created to indicate singleton connections which are ↵zotlabs2017-05-031-0/+2
| | | | | | | | connected to this channel but not on this hub. abook_instance enumerates which hubs the connections is valid, but we ultimately need something more efficiently searchable to decide what operations are supported w/r/t this connection in the context of this hub. This flag is ignored during sync to clones although the code to set it correctly during channel creation, import, and sync has not yet been implemented.
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-04-261-0/+2
|\|
| * database support for client side e2ee for private mailzotlabs2017-04-251-0/+2
| |
| * typozotlabs2017-04-191-1/+1
| |
| * backend infrastructure for 'channel protection password'; which will be used ↵zotlabs2017-04-191-1/+1
| | | | | | | | to optionally encrypt export files and resolve channel/identity ownership/hijacking disputes
| * typozotlabs2017-04-121-1/+1
| |
| * backend infrastructure for 'channel protection password'; which will be used ↵zotlabs2017-04-121-1/+3
| | | | | | | | to optionally encrypt export files and resolve channel/identity ownership/hijacking disputes
* | typozotlabs2017-04-121-1/+1
| |
* | backend infrastructure for 'channel protection password'; which will be used ↵zotlabs2017-04-121-1/+3
| | | | | | | | to optionally encrypt export files and resolve channel/identity ownership/hijacking disputes
* | db issueszotlabs2017-03-121-41/+0
|/
* Alter the queue so that each queue item stores the scheduled time of the ↵zotlabs2017-01-291-0/+2
| | | | | | | | next delivery. This keeps the query for queued items simple. We no longer group by posturl; as the queue update function will only keep one item per destination scheduled for shorter term processing. Others (multiple queued items for a single destination) will be scheduled for delivery far into the future and only delivered if the hub responds to the "active" or short term queue item.
* more vcard workzotlabs2016-12-211-0/+1
|
* issue #446 apps usability - disable app if attached to a plugin that is ↵zotlabs2016-12-141-1/+3
| | | | uninstalled, allow system apps to be soft deleted and undeleted from the edit pane.
* db update required for Zot2zotlabs2016-11-221-0/+1
|
* allow hooks to have negative priorityzotlabs2016-10-121-1/+3
|
* issue #523redmatrix2016-09-221-1/+1
|
* issue #511, postgres schema issuesredmatrix2016-09-091-2/+2
|
* provide version info in /pubsitesredmatrix2016-09-071-0/+1
|
* Merge branch 'dev' into permsredmatrix2016-07-171-0/+15
|\
| * schema updates for zot access tokensredmatrix2016-07-141-0/+15
| |
* | Merge branch 'dev' into permsredmatrix2016-07-121-1/+1
|\|
| * the abconfig defaults weren't changed in the schema files when they were ↵redmatrix2016-07-121-1/+1
| | | | | | | | changed in the code
* | revise how we store perm_limitsredmatrix2016-07-071-10/+0
| |
* | some perms fixes to stuff that was already written before I move onredmatrix2016-07-041-0/+11
|/
* typosHabeas Codice2016-06-271-3/+3
|
* db update for abconfig transitionredmatrix2016-06-231-1/+1
|
* schema changes needed for the caldav client bitredmatrix2016-06-181-4/+22
|
* the rest of the schema updates - WARNING: some third party plugins may fail; ↵redmatrix2016-06-011-23/+23
| | | | e.g. embedphotos and chess. $item['object'] is now $item['obj'] and $photo['type'] is $photo['mimetype'], $photo['scale'] is $photo['imgscale'] and $photo['data'] is now $photo['content']. There are a number of other changes, but these are the ones noted to cause issues with third-party plugins. The project plugins have been updated. Please note any new issues as this effort touched a lot of code in a lot of files.
* more db column renamesredmatrix2016-05-311-6/+6
|
* more removal of reserved words from DB schemasredmatrix2016-05-311-7/+7
|
* remove unused tablesredmatrix2016-05-301-69/+0
|
* start removing reserved words from database column names (this run: addon ↵redmatrix2016-05-301-4/+4
| | | | and hook)
* allow objs to represent inventoryredmatrix2016-05-271-0/+2
|
* some preliminary structural work for app organisationredmatrix2016-05-031-0/+4
|
* db schema change to add tags to content sourcesredmatrix2016-05-011-1/+2
|
* new hook interface (the old one still works but requires handlers to have ↵redmatrix2016-04-211-0/+2
| | | | two calling arguments; the first of which is no longer used). The new interface is called from Zotlabs\Extend\Hook::register() and allows you to specify which hook version to use. The default will be the new interface with one function argument. We also implement the hook priority field which was always there but needed to be set manually in the DB. This provides a way for two hook handlers that implement the same hook interface to determine which order to be called in the event of conflicts.
* fix typo in postgres schemaPeter Hormanns2016-03-011-1/+1
|
* abconfigredmatrix2016-02-291-0/+13
|
* schema change to support channel move (a completely different operation than ↵redmatrix2016-02-241-0/+2
| | | | channel clone)