Add primary key to creation table (mysql)

[AlvaroVega]

percona/mysql does not allow create a table without primary key

2023-09-14T08:05:05.589933Z 48 [ERROR] [MY-000000] [WSREP] Percona-XtraDB-Cluster prohibits use of DML command on a table (cb004011.sub401_FLOW0_AZUL) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER

[AlvaroVega]

iotqatools/iotqatools/mysql_utils.py

Lines 188 to 197 in 026ec1a

	def create_table(self, name, database_name, fields):
	"""
	create a new table per column type
	:param name:
	:param database_name:
	:param fields:
	"""
	self.table = name
	cur = self.__query("%s `%s`.`%s` %s;" % (MYSQL_CREATE_TABLE, database_name, self.table, fields))
	cur.close()

[fgalan]

De momento hemos dejado el MySQL de DEVEL en una configuración con PERMISSIVE que evita el problema.

Pero entiendo que si algún día queremos quitar ese PERMISIVE, resolver este issue se volverá necesario.