KWEBAPP-SQLDIFF(1) General Commands Manual KWEBAPP-SQLDIFF(1)

NAME

kwebapp-sqldiffgenerate SQL web application schema differences

SYNOPSIS

kwebapp-sqldiff oldconfig [config]

DESCRIPTION

The kwebapp-sqldiff utility accepts a configuration file config (defaulting to standard input) and produces an SQL schema describing the configuration.
It outputs a series of CREATE TABLE and ALTER TABLE SQL commands to update the configuration oldconfig to the new configuration config.
The configuration files are considered incompatible if they contain destructive differences: dropped objects (structures or fields) or different fields (types, references, attributes).
The SQL generated is designed for sqlite3(1).

EXIT STATUS

The kwebapp-sqldiff utility exits 0 on success, and >0 if an error occurs.

SEE ALSO

kwebapp-sql(1), sqlite3(1), kwebapp(5)
December 12, 2017 OpenBSD 6.2