aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
Commit message (Collapse)AuthorAgeFilesLines
* 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)
* iconfig - add sharing variableredmatrix2016-02-181-0/+2
|
* schema updates for iconfigredmatrix2016-02-171-0/+11
|
* remove deprecated tableredmatrix2015-12-151-9/+0
|
* move the instance stuff to abook where it belongsredmatrix2015-12-051-0/+1
|
* small fixes, removed old unused database row, and log more prominently a ↵redmatrix2015-11-121-1/+0
| | | | missing directory server URL
* updates to Postgres schemaWaitman Gobble2015-11-111-7/+7
|
* Merge https://github.com/redmatrix/redmatrix into pending_mergeredmatrix2015-10-191-0/+2
|\ | | | | | | | | | | | | | | | | Conflicts: include/zot.php install/schema_mysql.sql install/schema_postgres.sql install/update.php mod/zfinger.php
| * add the project name to site info packetredmatrix2015-10-191-0/+2
| |
* | mail sync/migrate continued; also abstract delivery loop to make it ↵redmatrix2015-10-151-0/+2
| | | | | | | | re-usable, change refresh_all to use delivery loop.
* | schema support for additional site typesredmatrix2015-09-281-0/+2
| |
* | add vdata field for caldavredmatrix2015-09-231-0/+1
| |
* | heavy lifting for delivery reportsredmatrix2015-09-221-0/+2
| |
* | DB table for delivery reportsredmatrix2015-09-181-0/+22
| |
* | add timestamps for syncing appsredmatrix2015-09-021-0/+4
| |
* | separate objs/things from taxonomyredmatrix2015-09-011-0/+10
| |
* | Merge https://github.com/redmatrix/redmatrix into pending_mergeredmatrix2015-08-311-0/+2
|\| | | | | | | | | | | | | | | Conflicts: include/identity.php install/update.php util/messages.po view/nl/messages.po
| * change the likes db structure to make it more easily importable/exportableredmatrix2015-08-311-0/+2
| |
* | Merge https://github.com/redmatrix/redmatrix into pending_mergeredmatrix2015-08-201-0/+2
|\|
| * missed this one - it's requiredredmatrix2015-08-201-0/+2
| |
* | Merge https://github.com/redmatrix/redmatrix into pending_mergeredmatrix2015-08-181-0/+2
|\|
| * add event_sequence for vtodo'sredmatrix2015-08-181-0/+2
| |
* | Merge https://github.com/redmatrix/redmatrix into pending_mergeredmatrix2015-08-161-0/+5
|\|
| * add DB support for tasks, todo items and repeating eventsredmatrix2015-08-161-0/+5
| |
* | fix the postgres schema with all the changes to dateredmatrix2015-06-291-3/+115
| |
* | Merge branch 'master' of https://github.com/redmatrix/redmatrixredmatrix2015-06-281-0/+2
|\| | | | | | | | | | | | | Conflicts: include/zot.php mod/connedit.php util/messages.po
| * no this isn't it. well ok, it's part of it, but not the important part. it's ↵redmatrix2015-06-281-0/+2
| | | | | | | | still pretty cool.
* | Merge branch 'master' of https://github.com/redmatrix/redmatrixredmatrix2015-06-091-0/+2
|\| | | | | | | | | | | | | | | | | Conflicts: install/schema_mysql.sql mod/home.php mod/page.php view/nl/messages.po view/nl/strings.php
| * add site_dead flag to prevent delivery to dead sites. Allow sys channel ↵redmatrix2015-06-081-0/+2
| | | | | | | | webpages to be viewed even if site is configured "block public".
* | Merge branch 'master' of https://github.com/redmatrix/redmatrixredmatrix2015-05-281-0/+4
|\| | | | | | | | | | | | | | | Conflicts: install/schema_mysql.sql mod/impel.php view/pt-br/messages.po view/pt-br/strings.php
| * add menu_created, menu_edited fields to DBredmatrix2015-05-281-0/+4
| |
* | convert ITEM_WALL from bitfield to standaloneredmatrix2015-05-061-0/+3
|/
* add channel_lastpost timestamp to help optimise some outrageously expensive ↵friendica2015-03-261-0/+2
| | | | queries.
* sql optimisation for affinity searches. A new index was added which wasn't ↵friendica2015-03-101-0/+1
| | | | added retro-actively to existing DBs as an update. It isn't clear if this helps sites any more than just restricting the abook table to certain channel_id's is (and this field is already indexed).
* add queue priorityfriendica2015-03-041-0/+2
|
* fix issues in schema_postgres.sqlDaniel Frank2015-02-261-2/+2
| | | | - change PRIMARY_KEY to PRIMARY KEY - replace smallint(1) with smallint
* require access token to view, query, or join directories in private realms, ↵friendica2015-02-241-0/+2
| | | | if the realm is so configured.
* provide relief to sites that are severely impacted by the slow ITEM_UNSEEN ↵friendica2015-02-121-0/+2
| | | | searches. This does not incorporate any other flag optimisations as that will require a major DB update and possibly involve significant downtime. This is just to bite off a little chunk now and provide some much needed relief.