From 7d74d42c79fb2747e42b4d9e2743abbc86a5354c Mon Sep 17 00:00:00 2001 From: "Jose M. Guisado" Date: Mon, 19 Apr 2021 09:26:31 +0000 Subject: #1042 Update database schema automatically This patch adds database schema management capabilities to ogServer: - ogServer now tracks the version of its database schema, if no version is detected, creates a 'version' table with a single row starting at 0. - ogServer can upgrade its database schema to a newer version if detected. (ogServer ships required SQL commands to do so) If ogServer is unable to upgrade the schema at startup (if needed be) it *will not* start. Defines schema update v1 which upgrades database engine tables of ogServer database (usually named 'ogAdmBD') from myISAM to innoDB. --- src/dbi.h | 2 ++ 1 file changed, 2 insertions(+) (limited to 'src/dbi.h') diff --git a/src/dbi.h b/src/dbi.h index 1daaeb8..798fecd 100644 --- a/src/dbi.h +++ b/src/dbi.h @@ -93,4 +93,6 @@ int og_dbi_get_computer_info(struct og_dbi *dbi, struct og_computer *computer, struct in_addr addr); int og_dbi_add_image(struct og_dbi *dbi, const struct og_image *image); +int og_dbi_schema_update(void); + #endif -- cgit v1.2.3-18-g5258