Structure de la base de données - Historique des versions

Jcheng : /* Table flight */

2017-06-08T12:14:01Z

‎Table flight

Jcheng : /* Champs cachés */

2017-06-08T12:12:57Z

‎Champs cachés

Jcheng : /* Table flight */

2017-06-08T12:11:01Z

‎Table flight

Jcheng : /* Table booking */

2017-06-08T12:01:43Z

‎Table booking

Jcheng : /* Description */

2017-06-08T11:52:00Z

‎Description

Jcheng : /* Structure */

2017-06-08T11:37:43Z

‎Structure

Jcheng : Page créée avec « =Structure= -- -- Table structure for table `account` -- CREATE TABLE `account` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `creation_date` date DEFAULT NU... »

2017-06-08T11:19:39Z

Page créée avec « =Structure= <sql>-- -- Table structure for table `account` -- CREATE TABLE `account` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `creation_date` date DEFAULT NU... »

Voir les modifications

@@ Ligne 1 602 : / Ligne 1 602 : @@
 *airborne :
 **0: Pas en l'air ou fermeture de vol : Le pilote a terminé le vol.
-**1: En l'air ou ouverture de vol : Le pilot remplit le vol avant de voler.
+**1: En l'air ou ouverture de vol : Le pilote remplit le vol avant de voler.
 ==Champs cachés==

@@ Ligne 1 606 : / Ligne 1 606 : @@
 ==Champs cachés==
-Following fields can not be exported and should not be in included in SELECT statement. Moreover, SELECT with wild-card * is not possible when there is one table including hidden fields:
+Les champs suivants ne peuvent être exportés and ne doivent pas être inclus dans une requête SELECT. De plus, un "SELECT *" n'est possivle quand une des tables  contient un champ caché :
 *Table club:
 **name
@@ Ligne 1 638 : / Ligne 1 638 : @@
 **welcome_cell
-*Table journal: all fields
+*Table journal: Tous les champs
-*Table log: all fields
+*Table log: Tous les champs
-*Table parameter: all fields
+*Table parameter: Tous les champs
 *Table person:
@@ Ligne 1 646 : / Ligne 1 646 : @@
-Example of unallowed queries :
+Exemple de requêtes non autorisées :
 <sql>SELECT * FROM club;

@@ Ligne 1 599 : / Ligne 1 599 : @@
 ==Table flight==
 *airborne :
-**0: not airborne or flight closed: the pilot has finished is flight.
+**0: Pas en l'air ou fermeture de vol : Le pilote a terminé le vol.
-**1: airborne or flight opened: the pilot fills the flight before going flying.
+**1: En l'air ou ouverture de vol : Le pilot remplit le vol avant de voler.
 ==Champs cachés==

@@ Ligne 1 596 : / Ligne 1 596 : @@
 ==Table booking==
-The content of ''aircraft_id'' field in ''booking'' table might be null. In this case, it's an old booking made onto a non-existing aircraft or an aircraft which no longer exists; also called orphan booking.
+Le contenu du champ ''aircraft_id'' de la table ''booking'' peut être nul. Dans ce cas, c'est une ancienne réservation effectuée sur une ressource non-existante ou qui n'existe plus; aussi nommé réservation orpheline.
 ==Table flight==

@@ Ligne 1 594 : / Ligne 1 594 : @@
 =Description=
-==booking table==
+==Table booking==
 The content of ''aircraft_id'' field in ''booking'' table might be null. In this case, it's an old booking made onto a non-existing aircraft or an aircraft which no longer exists; also called orphan booking.
-==flight table==
+==Table flight==
 *airborne :
 **0: not airborne or flight closed: the pilot has finished is flight.
 **1: airborne or flight opened: the pilot fills the flight before going flying.
-==Hidden fields==
+==Champs cachés==
 Following fields can not be exported and should not be in included in SELECT statement. Moreover, SELECT with wild-card * is not possible when there is one table including hidden fields:
 *Table club:

← Version précédente		Version du 8 juin 2017 à 11:37
Ligne 1 591 :		Ligne 1 591 :
	PRIMARY KEY (`id`)		PRIMARY KEY (`id`)
	) ENGINE=InnoDB DEFAULT CHARSET=latin1;</sql>		) ENGINE=InnoDB DEFAULT CHARSET=latin1;</sql>
		+
		+	=Description=
		+
		+	==booking table==
		+	The content of ''aircraft_id'' field in ''booking'' table might be null. In this case, it's an old booking made onto a non-existing aircraft or an aircraft which no longer exists; also called orphan booking.
		+
		+	==flight table==
		+	*airborne :
		+	**0: not airborne or flight closed: the pilot has finished is flight.
		+	**1: airborne or flight opened: the pilot fills the flight before going flying.
		+
		+	==Hidden fields==
		+	Following fields can not be exported and should not be in included in SELECT statement. Moreover, SELECT with wild-card * is not possible when there is one table including hidden fields:
		+	*Table club:
		+	**name
		+	**info_cell
		+	**logo
		+	**logo_name
		+	**logo_ext
		+	**logo_size
		+	**first_hour_displayed
		+	**last_hour_displayed
		+	**usual_profiles
		+	**default_slot_range
		+	**min_slot_range
		+	**twilight_range
		+	**mailing_list_name
		+	**mailing_list_type
		+	**default_timezone
		+	**lang
		+	**admin_num
		+	**mail_from_address
		+	**default_view_type
		+	**address
		+	**zipcode
		+	**city
		+	**state
		+	**country
		+	**phone
		+	**fax
		+	**email
		+	**default_notification
		+	**welcome_cell
		+
		+	*Table journal: all fields
		+	*Table log: all fields
		+	*Table parameter: all fields
		+
		+	*Table person:
		+	**hash_password
		+
		+
		+	Example of unallowed queries :
		+	<sql>SELECT * FROM club;
		+
		+	SELECT hash_password FROM person;
		+
		+	SELECT person.id, validity.*
		+	FROM person
		+	LEFT JOIN validity ON (person.id=validity.person_id);</sql>