[issue2551245] Add index creation to schema definition

New submission from Ralf Schlatterbeck:

Currently roundup decides to produce indexes automatically. In some cases it makes sense that the user can specify indexes for some tables.

Proposed is the following parameter to the property definition that requests an index (proposed by John P. Rouillard):

 propname = String(addindex=True)

e.g.
msg = FileClass(db, "msg", ..., messageid=String(addindex=True), ...)

The implementation could check if all indexes exist and create missing ones if needed. Note that we do not want to remove unexpected indexes: The user might have added additional indexes by hand.

----------
components: API, Database
messages: 7687
nosy: rouilj, schlatterbeck
priority: normal
severity: normal
status: new
title: Add index creation to schema definition
type: resource usage
versions: devel

_________________________________________________
Roundup tracker <[email protected]>
<https://issues.roundup-tracker.org/issue2551245>
_________________________________________________