Changeset c13a488

Timestamp:

07/21/21 20:15:50 (6 months ago)

Author:

Philipp Spitzer <philipp@…>

Branches:

master

Children:

0b4a1d0

Parents:

a5dc5eb

git-author:

Philipp Spitzer <philipp@…> (07/21/21 19:54:38)

git-committer:

Philipp Spitzer <philipp@…> (07/21/21 20:15:50)

Message:

Add utc_offset and display_time_shift columns to conference database.

Location:

src

Files:

• db.qrc (modified) (1 diff)
• dbschema001to002.sql (added)
• dbschema002.sql (added)
• sql/sqlengine.cpp (modified) (2 diffs)
• sql/sqlengine.h (modified) (1 diff)

src/db.qrc

@@ -1 +1 @@
 <!DOCTYPE RCC><RCC version="1.0">
 <qresource>
-    <file>dbschema001.sql</file>
     <file>dbschema000to001.sql</file>
+    <file>dbschema001to002.sql</file>
+    <file>dbschema002.sql</file>
 </qresource>
 </RCC>
-

src/sql/sqlengine.cpp

@@ -92 +92 @@
 
 
+bool SqlEngine::updateDbSchemaVersion001To002() {
+    return applySqlFile(":/dbschema001to002.sql");
+}
+
+
 bool SqlEngine::createCurrentDbSchema() {
-    return applySqlFile(":/dbschema001.sql");
+    return applySqlFile(":/dbschema002.sql");
 }
 
@@ -110 +115 @@
         return updateDbSchemaVersion000To001();
     case 1:
+        // db schema version 1
+        return updateDbSchemaVersion001To002();
+    case 2:
         // current schema
         return true;

src/sql/sqlengine.h

@@ -51 +51 @@
         /// called by createOrUpdateDbSchema. Do not use directly. true for success.
         bool updateDbSchemaVersion000To001();
+        bool updateDbSchemaVersion001To002();
         /// called by createOrUpdateDbSchma. Do not use directly. true for success.
         bool createCurrentDbSchema();