https://doc-en-mirror.openflyers.com/index.php?action=history&feed=atom&title=Database-description 2026-04-29T09:02:21Z Revision history for this page on the wiki MediaWiki 1.39.6 https://doc-en-mirror.openflyers.com/index.php?title=Database-description&diff=291&oldid=prev 2024-08-12T18:53:05Z

<p>Text replacement - &quot;&lt;sql&gt;&quot; to &quot;&lt;syntaxhighlight lang=&quot;sql&quot;&gt;&quot;</p> <p><b>New page</b></p><div>=[[Database-OF21|Dump of OF 2.1 structure]]=<br /> =[[Database-OF35|Dump of OF 3.5 structure]]=<br /> ==booking table==<br /> 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.<br /> <br /> ==flight table==<br /> *airborne :<br /> **0: not airborne or flight closed: the pilot has finished his flight.<br /> **1: airborne or flight opened: the pilot fills the flight before going flying.<br /> <br /> ==Hidden fields==<br /> 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:<br /> *Table club:<br /> **name<br /> **info_cell<br /> **logo<br /> **logo_name<br /> **logo_ext<br /> **logo_size<br /> **first_hour_displayed<br /> **last_hour_displayed<br /> **usual_profiles<br /> **default_slot_range<br /> **min_slot_range<br /> **twilight_range<br /> **mailing_list_name<br /> **mailing_list_type<br /> **default_timezone<br /> **lang<br /> **admin_num<br /> **mail_from_address<br /> **default_view_type<br /> **address<br /> **zipcode<br /> **city<br /> **state<br /> **country<br /> **phone<br /> **fax<br /> **email<br /> **default_notification<br /> **welcome_cell<br /> <br /> *Table journal: all fields<br /> *Table log: all fields<br /> *Table parameter: all fields<br /> <br /> *Table person:<br /> **hash_password<br /> <br /> <br /> Example of unallowed queries :<br /> &lt;syntaxhighlight lang=&quot;sql&quot;&gt;SELECT * FROM club;<br /> <br /> SELECT hash_password FROM person;<br /> <br /> SELECT person.id, validity.*<br /> FROM person<br /> LEFT JOIN validity ON (person.id=validity.person_id);&lt;/sql&gt;<br /> <br /> =[[OF_doc4-fr:Structure-de-la-base-de-données|Dump of OF 4 structure]]=</div>

imported>Claratte