ischema.1

NAME

ischema - indimail database schema updater

SYNOPSYS

ischema [-u]

DESCRIPTION

ischema(1) updates indimail schema definitions from /etc/indimail/indimail.schema. Without the -u option it displays the current schema ID.

The file /etc/indimail/indimail.schema has 5 fields separated by the colon character.

field1 - ID
field2 - sql statement (sql) or command (cmd)
field3 - Ignore or Not Ignore errors when executing the sql statement or
         command. This has to be either YES or NO.
field4 - Comment
field4 - Sql statement or shell command to be executed

IndiMail database has a schema ID which is the value of the ID column of the row having the largest id in the MySQL(1) table ischema. Lines in the file /etc/indimail/indimail.schema, which have an ID greater than the schema ID gets updated. ischema(1) is run on every indimail upgrade. If there are updates, the database schema gets updated along with the ischema table.

RETURN VALUE

0 on success. 100 for incorrect usage and 111 for temporary errors

SEE ALSO

IndiMail(7)