diff options
Diffstat (limited to 'src/schema.c')
| -rw-r--r-- | src/schema.c | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/src/schema.c b/src/schema.c index 182f992..fd1d573 100644 --- a/src/schema.c +++ b/src/schema.c @@ -398,6 +398,42 @@ static int og_dbi_schema_v9(struct og_dbi *dbi) return 0; } +static int og_dbi_schema_v10(struct og_dbi *dbi) +{ + const char *msglog; + dbi_result result; + + syslog(LOG_DEBUG, "Creating table boot_entries\n"); + result = dbi_conn_query(dbi->conn, "CREATE TABLE `boot_entries` (" + "`id` BIGINT NOT NULL AUTO_INCREMENT," + "`client_id` INT NOT NULL," + "`name` VARCHAR(255)," + "`active` BOOLEAN," + "`description` TEXT," + "`entry_order` INT," + "PRIMARY KEY (`id`)," + "FOREIGN KEY (`client_id`) REFERENCES `ordenadores` (`idordenador`) ON DELETE CASCADE" + ")"); + if (!result) { + dbi_conn_error(dbi->conn, &msglog); + syslog(LOG_INFO, "Error when creating boot_entries (%s:%d) %s\n", + __func__, __LINE__, msglog); + return -1; + } + dbi_result_free(result); + + result = dbi_conn_query(dbi->conn, "UPDATE version SET version = 10"); + if (!result) { + dbi_conn_error(dbi->conn, &msglog); + syslog(LOG_INFO, "Could not update version row (%s:%d) %s\n", + __func__, __LINE__, msglog); + return -1; + } + dbi_result_free(result); + + return 0; +} + static struct og_schema_version { int version; int (*update)(struct og_dbi *dbi); @@ -411,6 +447,7 @@ static struct og_schema_version { { .version = 7, .update = og_dbi_schema_v7, }, { .version = 8, .update = og_dbi_schema_v8, }, { .version = 9, .update = og_dbi_schema_v9, }, + { .version = 10, .update = og_dbi_schema_v10,}, { 0, NULL }, }; |