declarer_tables_auxiliaires

This pipeline declares the "auxiliary" tables, which are mainly used to create joins between principal tables.

It accepts the same arguments as the pipeline declarer_tables_principales.

Example

The plugin "SPIP Bisous" enables an author to send a poke to another author. It declares a table spip_bisous linking 2 members with the poke’s date using code as shown below. Note that the primary key is composed of 2 separate fields.

function bisous_declarer_tables_auxiliaires($auxiliary_tables){
 
	$spip_bisous = array(
		'id_donneur' => 'bigint(21) DEFAULT "0" NOT NULL',
		'id_receveur' => 'bigint(21) DEFAULT "0" NOT NULL',
		'date' => 'datetime DEFAULT "0000-00-00 00:00:00" NOT NULL'
	);
 
	$spip_bisous_key = array(
		'PRIMARY KEY' => 'id_donneur, id_receveur'
	);
 
	$auxiliary_tables['spip_bisous'] = array(
		'field' => &$spip_bisous,
		'key' => &$spip_bisous_key
	);
 
	return $auxiliary_tables;
}

Author Gilles Vincent Published : Updated : 30/05/10

Translations : English, Español, français