Re: [aur-dev] [PATCH 1/4] Add sqlite3 schema for testing databases

On Wed, 01 Mar 2017 at 07:46:18, Mark Weiman wrote:

The existing aur-schema.sql file is specific to MySQL, this patch adds a second schema file for use to create sqlite3 testing databases.

Signed-off-by: Mark Weiman --- schema/aur-schema-sqlite.sql | 368 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 368 insertions(+) create mode 100644 schema/aur-schema-sqlite.sql [...]

This makes it a bit more cumbersome to update the schema since having two independent schema files means that every database layout amendment must be done twice. I suggest creating this automatically instead, like we already do in the test suite; see the patches which I will send to the list in a minute.