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	niro	9463	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			}