A few bug fixes in updating the database from version 20.

[gnucomo.git] / src / gcm_daemon / classes / gnucomo_db_version.php

diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index fdf2ad4..ccd3703 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -185,11 +185,11 @@
       $dbms->query($local_sql);
 
   case 20:
-      $local_sql = "CREATE TABLE 'parameter_notification' ('notificationid' bigint, 'paramid' bigint,  primary key (notificationid, paramid))";
+      $local_sql = "CREATE TABLE parameter_notification (notificationid bigint, paramid bigint,  primary key (notificationid, paramid))";
       $dbms->query($local_sql);
   
-      $local_sql = "CREATE TABLE 'parameter_class' ('name' text, 'property_name' text, 'description' text, 'property_type' text, ";
-      $local_sql .= "'min' float, 'max' float, 'notify' boolean, primary key (name, property_name));";
+      $local_sql = "CREATE TABLE parameter_class (name text, property_name text, description text, property_type text, ";
+      $local_sql .= "min float, max float, notify boolean, primary key (name, property_name));";
       $dbms->query($local_sql);
 
       $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";