summaryrefslogtreecommitdiffstats
path: root/src/schema.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/schema.c')
-rw-r--r--src/schema.c37
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 },
};