--- alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh 2020/07/15 07:16:36 14424 +++ alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh 2020/07/15 07:23:38 14425 @@ -257,9 +257,9 @@ TABLE_DEFINITION=( "client_serials" "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "location varchar(255) NOT NULL" + "location varchar(255) DEFAULT NULL" "mtime int(11) DEFAULT NULL" - "mac varchar(17) NOT NULL" + "mac varchar(17) DEFAULT NULL" "hwdetected tinyint(1) NOT NULL DEFAULT '0'" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) @@ -268,8 +268,8 @@ TABLE_DEFINITION=( "client_version" "serial int(11) NOT NULL PRIMARY KEY" - "os varchar(50) NOT NULL" - "utils varchar(50) NOT NULL" + "os varchar(50) DEFAULT NULL" + "utils varchar(50) DEFAULT NULL" "arch varchar(50) NOT NULL" ) sql_create_table