sql-schema/include/update_to_database_schema_version_9.sh

update_to_database_schema_version_9()
{
	TABLE_DEFINITION=(
		"client_boot"
			"serial int(255) NOT NULL PRIMARY KEY"
			"cmdline varchar(255) DEFAULT NULL"
	)
	sql_create_table

	# now add an empty cmdline for all existing serials if nothing was already set
	local serials i
	serials=$(mysqldo "select serial from client_serials")
	for i in ${serials}
	do
		if [[ -z $(mysqldo "select serial from client_boot where serial='${i}'") ]]
		then
			# insert an empty cmdline
			mysqldo "insert into client_boot (serial, cmdline) values('${i}', '')"
		fi
	done
}
1	update_to_database_schema_version_9()
2	{
3	TABLE_DEFINITION=(
4	"client_boot"
5	"serial int(255) NOT NULL PRIMARY KEY"
6	"cmdline varchar(255) DEFAULT NULL"
7	)
8	sql_create_table
9
10	# now add an empty cmdline for all existing serials if nothing was already set
11	local serials i
12	serials=$(mysqldo "select serial from client_serials")
13	for i in ${serials}
14	do
15	if [[ -z $(mysqldo "select serial from client_boot where serial='${i}'") ]]
16	then
17	# insert an empty cmdline
18	mysqldo "insert into client_boot (serial, cmdline) values('${i}', '')"
19	fi
20	done
21	}