rendered paste body<?xml version="1.0" encoding="utf-8"?><!--Autogenerated by CreoleToXMLSchema!--><database name="propel"> <table name="ABESOINDETYPECONTRAT"> <vendor type="mysql"> <parameter name="Name" value="ABESOINDETYPECONTRAT"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="16384"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value=""/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NUMEROTYPECONTRAT`) REFER `carentr/TYPECONTRATASSURANCE"/> </vendor> <column name="NUMEROCLASSE" type="INTEGER" required="true" primaryKey="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROCLASSE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROTYPECONTRAT" type="INTEGER" required="true" primaryKey="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROTYPECONTRAT"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="TYPECONTRATASSURANCE" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROTYPECONTRAT" foreign="NUMEROTYPECONTRAT"/> </foreign-key> <foreign-key foreignTable="CLASSETARIFICATION" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROCLASSE" foreign="NUMEROCLASSE"/> </foreign-key> <index name="FK_ABESOINDETYPECONTRAT2"> <index-column name="NUMEROTYPECONTRAT"/> <vendor type="mysql"> <parameter name="Table" value="ABESOINDETYPECONTRAT"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_ABESOINDETYPECONTRAT2"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROTYPECONTRAT"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="ACOMMEOPTION"> <vendor type="mysql"> <parameter name="Name" value="ACOMMEOPTION"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="16384"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value=""/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`MARQUE` `TYPEMODELE` `PUISSANCE`) REFER `carentr/MODELE"/> </vendor> <column name="CODEOPTION" type="INTEGER" required="true" primaryKey="true" > <vendor type="mysql"> <parameter name="Field" value="CODEOPTION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="MARQUE" type="VARCHAR" size="255" required="true" primaryKey="true" default=""> <vendor type="mysql"> <parameter name="Field" value="MARQUE"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="TYPEMODELE" type="VARCHAR" size="255" required="true" primaryKey="true" default=""> <vendor type="mysql"> <parameter name="Field" value="TYPEMODELE"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="PUISSANCE" type="INTEGER" required="true" primaryKey="true" > <vendor type="mysql"> <parameter name="Field" value="PUISSANCE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="OPTIONMODELE" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="CODEOPTION" foreign="CODEOPTION"/> </foreign-key> <index name="FK_ACOMMEOPTION2"> <index-column name="MARQUE"/> <index-column name="TYPEMODELE"/> <index-column name="PUISSANCE"/> <vendor type="mysql"> <parameter name="Table" value="ACOMMEOPTION"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_ACOMMEOPTION2"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="MARQUE"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="ASSUREUR"> <vendor type="mysql"> <parameter name="Name" value="ASSUREUR"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="0"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value=""/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB"/> </vendor> <column name="NOMASSUREUR" type="VARCHAR" size="255" required="true" primaryKey="true" default=""> <vendor type="mysql"> <parameter name="Field" value="NOMASSUREUR"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="ADRESSEASSUREUR" type="VARCHAR" size="255" required="true" primaryKey="true" default=""> <vendor type="mysql"> <parameter name="Field" value="ADRESSEASSUREUR"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> </table> <table name="CLASSETARIFICATION" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="CLASSETARIFICATION"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="0"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB"/> </vendor> <column name="PRIXKM" type="INTEGER"> <vendor type="mysql"> <parameter name="Field" value="PRIXKM"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROCLASSE" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROCLASSE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="AMENDEJOURNALIERE" type="FLOAT" size="8" scale="2"> <vendor type="mysql"> <parameter name="Field" value="AMENDEJOURNALIERE"/> <parameter name="Type" value="float(8,2)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> </table> <table name="CLIENT" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="CLIENT"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="0"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB"/> </vendor> <column name="NUMEROCLIENT" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROCLIENT"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="NOMCLIENT" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="NOMCLIENT"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="PRENOMCLIENT" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="PRENOMCLIENT"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="ADRESSECLIENT" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="ADRESSECLIENT"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> </table> <table name="CONTRATASSURANCE" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="CONTRATASSURANCE"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="32768"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NUMEROTYPECONTRAT`) REFER `carentr/TYPECONTRATASSURANCE"/> </vendor> <column name="NUMEROCONTRATASSURANCE" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROCONTRATASSURANCE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="NUMEROTYPECONTRAT" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROTYPECONTRAT"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROVEHICULE" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROVEHICULE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="TYPECONTRATASSURANCE" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROTYPECONTRAT" foreign="NUMEROTYPECONTRAT"/> </foreign-key> <foreign-key foreignTable="VEHICULE" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROVEHICULE" foreign="NUMEROVEHICULE"/> </foreign-key> <index name="FK_ASSUREVEHICULE"> <index-column name="NUMEROVEHICULE"/> <vendor type="mysql"> <parameter name="Table" value="CONTRATASSURANCE"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_ASSUREVEHICULE"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROVEHICULE"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> <index name="FK_ESTTYPECONTRAT"> <index-column name="NUMEROTYPECONTRAT"/> <vendor type="mysql"> <parameter name="Table" value="CONTRATASSURANCE"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_ESTTYPECONTRAT"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROTYPECONTRAT"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="FACTURE" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="FACTURE"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="16384"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NUMEROLOCATION`) REFER `carentr/LOCATION`(`NUMEROLOCATI"/> </vendor> <column name="PAYEE" type="TINYINT"> <vendor type="mysql"> <parameter name="Field" value="PAYEE"/> <parameter name="Type" value="tinyint(1)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROFACTURE" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROFACTURE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="NUMEROLOCATION" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROLOCATION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="LOCATION" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROLOCATION" foreign="NUMEROLOCATION"/> </foreign-key> <index name="FK_FACTURELOCATION"> <index-column name="NUMEROLOCATION"/> <vendor type="mysql"> <parameter name="Table" value="FACTURE"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_FACTURELOCATION"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROLOCATION"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="INDISPONIBILITE" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="INDISPONIBILITE"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="0"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB"/> </vendor> <column name="NUMEROINDISPONOBILITE" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROINDISPONOBILITE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="DATEINDISPONIBILITE" type="DATE"> <vendor type="mysql"> <parameter name="Field" value="DATEINDISPONIBILITE"/> <parameter name="Type" value="date"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DATERETOURINDISPONIBILITE" type="DATE"> <vendor type="mysql"> <parameter name="Field" value="DATERETOURINDISPONIBILITE"/> <parameter name="Type" value="date"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="TYPEINDISPONIBILITE" type="INTEGER"> <vendor type="mysql"> <parameter name="Field" value="TYPEINDISPONIBILITE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> </table> <table name="LOCATION" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="LOCATION"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="16384"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:03"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NUMERORESERVATION`) REFER `carentr/RESERVATION`(`NUMERO"/> </vendor> <column name="CAUTION" type="FLOAT" size="8" scale="2"> <vendor type="mysql"> <parameter name="Field" value="CAUTION"/> <parameter name="Type" value="float(8,2)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROPERMIS" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="NUMEROPERMIS"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="KMFINAL" type="INTEGER"> <vendor type="mysql"> <parameter name="Field" value="KMFINAL"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="KMINITIAL" type="INTEGER"> <vendor type="mysql"> <parameter name="Field" value="KMINITIAL"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DATERETOUR" type="DATE"> <vendor type="mysql"> <parameter name="Field" value="DATERETOUR"/> <parameter name="Type" value="date"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROLOCATION" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROLOCATION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="NUMERORESERVATION" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="NUMERORESERVATION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="RESERVATION" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMERORESERVATION" foreign="NUMERORESERVATION"/> </foreign-key> <index name="FK_RESERVELOCATION"> <index-column name="NUMERORESERVATION"/> <vendor type="mysql"> <parameter name="Table" value="LOCATION"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_RESERVELOCATION"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMERORESERVATION"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="MODELE"> <vendor type="mysql"> <parameter name="Name" value="MODELE"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="16384"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value=""/> <parameter name="Create_time" value="2006-03-21 19:30:03"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NUMEROCLASSE`) REFER `carentr/CLASSETARIFICATION`(`NUME"/> </vendor> <column name="MARQUE" type="VARCHAR" size="255" required="true" primaryKey="true" default=""> <vendor type="mysql"> <parameter name="Field" value="MARQUE"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="TYPEMODELE" type="VARCHAR" size="255" required="true" primaryKey="true" default=""> <vendor type="mysql"> <parameter name="Field" value="TYPEMODELE"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="PUISSANCE" type="INTEGER" required="true" primaryKey="true" > <vendor type="mysql"> <parameter name="Field" value="PUISSANCE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROCLASSE" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROCLASSE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="CLASSETARIFICATION" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROCLASSE" foreign="NUMEROCLASSE"/> </foreign-key> <index name="FK_GROUPEDANS"> <index-column name="NUMEROCLASSE"/> <vendor type="mysql"> <parameter name="Table" value="MODELE"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_GROUPEDANS"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROCLASSE"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="MODELOCATION"> <vendor type="mysql"> <parameter name="Name" value="MODELOCATION"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="0"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value=""/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB"/> </vendor> <column name="KMFORFAITAIRE" type="INTEGER" required="true" primaryKey="true" > <vendor type="mysql"> <parameter name="Field" value="KMFORFAITAIRE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DESCRIPTIONMODELOCATION" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="DESCRIPTIONMODELOCATION"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DUREELOCATION" type="INTEGER" required="true" primaryKey="true" > <vendor type="mysql"> <parameter name="Field" value="DUREELOCATION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> </table> <table name="OPTIONMODELE" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="OPTIONMODELE"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="0"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:02"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB"/> </vendor> <column name="CODEOPTION" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="CODEOPTION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="LIBELLE" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="LIBELLE"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> </table> <table name="RESERVATION" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="RESERVATION"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="65536"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:03"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NUMEROVEHICULE`) REFER `carentr/VEHICULE`(`NUMEROVEHICU"/> </vendor> <column name="DATERETRAIT" type="DATE"> <vendor type="mysql"> <parameter name="Field" value="DATERETRAIT"/> <parameter name="Type" value="date"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="ETATRESERVATION" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="ETATRESERVATION"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMERORESERVATION" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMERORESERVATION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="KMFORFAITAIRE" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="KMFORFAITAIRE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DUREELOCATION" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="DUREELOCATION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROCLIENT" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROCLIENT"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="RES_NUMERORESERVATION" type="INTEGER"> <vendor type="mysql"> <parameter name="Field" value="RES_NUMERORESERVATION"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROVEHICULE" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="NUMEROVEHICULE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DATERETOURPREVUE" type="DATE"> <vendor type="mysql"> <parameter name="Field" value="DATERETOURPREVUE"/> <parameter name="Type" value="date"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="VEHICULE" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROVEHICULE" foreign="NUMEROVEHICULE"/> </foreign-key> <foreign-key foreignTable="RESERVATION" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="RES_NUMERORESERVATION" foreign="NUMERORESERVATION"/> </foreign-key> <foreign-key foreignTable="CLIENT" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROCLIENT" foreign="NUMEROCLIENT"/> </foreign-key> <index name="FK_ANCIENNERESERVATION"> <index-column name="RES_NUMERORESERVATION"/> <vendor type="mysql"> <parameter name="Table" value="RESERVATION"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_ANCIENNERESERVATION"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="RES_NUMERORESERVATION"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value="YES"/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> <index name="FK_MODELOCATIONRESERVATION"> <index-column name="KMFORFAITAIRE"/> <index-column name="DUREELOCATION"/> <vendor type="mysql"> <parameter name="Table" value="RESERVATION"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_MODELOCATIONRESERVATION"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="KMFORFAITAIRE"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> <index name="FK_RESERVATIONCLIENT"> <index-column name="NUMEROCLIENT"/> <vendor type="mysql"> <parameter name="Table" value="RESERVATION"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_RESERVATIONCLIENT"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROCLIENT"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> <index name="FK_RESERVEVEHICULE"> <index-column name="NUMEROVEHICULE"/> <vendor type="mysql"> <parameter name="Table" value="RESERVATION"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_RESERVEVEHICULE"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROVEHICULE"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="TYPECONTRATASSURANCE" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="TYPECONTRATASSURANCE"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="16384"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:03"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NOMASSUREUR` `ADRESSEASSUREUR`) REFER `carentr/ASSUREUR"/> </vendor> <column name="NUMEROTYPECONTRAT" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROTYPECONTRAT"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="NOMASSUREUR" type="VARCHAR" size="255" required="true" default=""> <vendor type="mysql"> <parameter name="Field" value="NOMASSUREUR"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="ADRESSEASSUREUR" type="VARCHAR" size="255" required="true" default=""> <vendor type="mysql"> <parameter name="Field" value="ADRESSEASSUREUR"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DESCRIPTIONCONTRAT" type="VARCHAR" size="255"> <vendor type="mysql"> <parameter name="Field" value="DESCRIPTIONCONTRAT"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <index name="FK_ASSUREPAR"> <index-column name="NOMASSUREUR"/> <index-column name="ADRESSEASSUREUR"/> <vendor type="mysql"> <parameter name="Table" value="TYPECONTRATASSURANCE"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_ASSUREPAR"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NOMASSUREUR"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table> <table name="VEHICULE" idMethod="native"> <vendor type="mysql"> <parameter name="Name" value="VEHICULE"/> <parameter name="Engine" value="InnoDB"/> <parameter name="Version" value="10"/> <parameter name="Row_format" value="Compact"/> <parameter name="Rows" value="0"/> <parameter name="Avg_row_length" value="0"/> <parameter name="Data_length" value="16384"/> <parameter name="Max_data_length" value="0"/> <parameter name="Index_length" value="32768"/> <parameter name="Data_free" value="0"/> <parameter name="Auto_increment" value="1"/> <parameter name="Create_time" value="2006-03-21 19:30:03"/> <parameter name="Update_time" value=""/> <parameter name="Check_time" value=""/> <parameter name="Collation" value="latin1_swedish_ci"/> <parameter name="Checksum" value=""/> <parameter name="Create_options" value=""/> <parameter name="Comment" value="InnoDB free: 11264 kB; (`NUMEROINDISPONOBILITE`) REFER `carentr/INDISPONIBILITE`"/> </vendor> <column name="NUMEROVEHICULE" type="INTEGER" required="true" autoIncrement="true" primaryKey="true"> <vendor type="mysql"> <parameter name="Field" value="NUMEROVEHICULE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="PRI"/> <parameter name="Default" value=""/> <parameter name="Extra" value="auto_increment"/> </vendor> </column> <column name="MARQUE" type="VARCHAR" size="255" required="true" default=""> <vendor type="mysql"> <parameter name="Field" value="MARQUE"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="TYPEMODELE" type="VARCHAR" size="255" required="true" default=""> <vendor type="mysql"> <parameter name="Field" value="TYPEMODELE"/> <parameter name="Type" value="varchar(255)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="PUISSANCE" type="INTEGER" required="true" > <vendor type="mysql"> <parameter name="Field" value="PUISSANCE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="NUMEROINDISPONOBILITE" type="INTEGER"> <vendor type="mysql"> <parameter name="Field" value="NUMEROINDISPONOBILITE"/> <parameter name="Type" value="int(11)"/> <parameter name="Null" value="YES"/> <parameter name="Key" value="MUL"/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="DATEACHAT" type="DATE" required="true" > <vendor type="mysql"> <parameter name="Field" value="DATEACHAT"/> <parameter name="Type" value="date"/> <parameter name="Null" value="NO"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <column name="PRIXACHAT" type="FLOAT" size="8" scale="2" required="true" default=""> <vendor type="mysql"> <parameter name="Field" value="PRIXACHAT"/> <parameter name="Type" value="float(8,2)"/> <parameter name="Null" value="NO"/> <parameter name="Key" value=""/> <parameter name="Default" value=""/> <parameter name="Extra" value=""/> </vendor> </column> <foreign-key foreignTable="INDISPONIBILITE" onDelete="RESTRICT" onUpdate="RESTRICT"> <reference local="NUMEROINDISPONOBILITE" foreign="NUMEROINDISPONOBILITE"/> </foreign-key> <index name="FK_ESTMODELE"> <index-column name="MARQUE"/> <index-column name="TYPEMODELE"/> <index-column name="PUISSANCE"/> <vendor type="mysql"> <parameter name="Table" value="VEHICULE"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_ESTMODELE"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="MARQUE"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value=""/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> <index name="FK_INDISPONIBLE"> <index-column name="NUMEROINDISPONOBILITE"/> <vendor type="mysql"> <parameter name="Table" value="VEHICULE"/> <parameter name="Non_unique" value="1"/> <parameter name="Key_name" value="FK_INDISPONIBLE"/> <parameter name="Seq_in_index" value="1"/> <parameter name="Column_name" value="NUMEROINDISPONOBILITE"/> <parameter name="Collation" value="A"/> <parameter name="Cardinality" value="0"/> <parameter name="Sub_part" value=""/> <parameter name="Packed" value=""/> <parameter name="Null" value="YES"/> <parameter name="Index_type" value="BTREE"/> <parameter name="Comment" value=""/> </vendor> </index> </table></database>