Structure de la base de données - Revision history

Mbouzar: /* Structure */

2026-07-07T12:11:11Z

Structure

@@ Line 597: / Line 597: @@
 create index idx_account_entry_id
      on flight_account_entry (account_entry_id);
 create table flight_hours_pricing
@@ Line 1,336: / Line 1,300: @@
      color            int unsigned                  null
 );
 create table resource_exceptional_availability

Mbouzar: /* Structure */

2026-07-02T14:21:30Z

Structure

@@ Line 597: / Line 597: @@
 create index idx_account_entry_id
      on flight_account_entry (account_entry_id);
 create table flight_hours_pricing

Mbouzar: /* Structure */

2026-06-08T11:46:06Z

Structure

← Older revision		Revision as of 11:46, 8 June 2026
Line 544:		Line 544:
	create table file		create table file
	(		(
	id int unsigned auto_increment		id int unsigned auto_increment
	primary key,		primary key,
	name varchar(255) null,		name varchar(255) null,
Line 555:		Line 555:
	parent_id int unsigned null,		parent_id int unsigned null,
	person_id int unsigned null,		person_id int unsigned null,
	~~created_at~~ datetime not null		creation_date datetime not null
	);		);

Mbouzar: /* Structure */

2026-06-08T08:17:55Z

Structure

← Older revision		Revision as of 08:17, 8 June 2026
Line 219:		Line 219:
	id int unsigned auto_increment		id int unsigned auto_increment
	primary key,		primary key,
	booking_group_id int unsigned null,		booking_group_id int unsigned null,
	start_date datetime null,		start_date datetime null,
	end_date datetime null		end_date datetime null,
			is_pinned tinyint unsigned default 0 null
	)		)
	comment 'records all the slots of all aircrafts of all airclubs';		comment 'records all the slots of all aircrafts of all airclubs';
Line 545:		Line 546:
	id int unsigned auto_increment		id int unsigned auto_increment
	primary key,		primary key,
	name varchar(255) null,		name varchar(255) null,
	content longblob null,		content longblob null,
	file_type varchar(255) null,		file_type varchar(255) null,
	category tinyint unsigned null,		category tinyint unsigned null,
	owner_id int null,		owner_id int null,
	file_group_id int null		file_group_id int null,
			is_current tinyint unsigned default 1 not null,
			parent_id int unsigned null,
			person_id int unsigned null,
			created_at datetime not null
	);		);

Mbouzar: /* Structure */

2026-05-06T14:29:17Z

Structure

@@ Line 141: / Line 141: @@
+)
      comment 'all aircrafts of all airclubs';
 create table aircraft_type
@@ Line 1,316: / Line 1,304: @@
      end_date    datetime            null,
      presence    tinyint unsigned    null
 );

Lelhidam: /* Structure */

2026-04-28T15:34:38Z

Structure

← Older revision		Revision as of 15:34, 28 April 2026
Line 1,593:		Line 1,593:
	rule text null,		rule text null,
	sender_email varchar(255) null,		sender_email varchar(255) null,
	subject varchar(255) null		subject varchar(255) null,
			supplier_name varchar(255) default null,
			search_keyword varchar(255) default null
	);		);

Mbouzar: /* Structure */

2026-04-27T13:59:21Z

Structure

Show changes

Mbouzar: /* Structure */

2026-04-15T13:33:40Z

Structure

← Older revision		Revision as of 13:33, 15 April 2026
Line 130:		Line 130:
	day_alert2 smallint(3) default 0 null,		day_alert2 smallint(3) default 0 null,
	day_alert3 smallint(3) default -8 null		day_alert3 smallint(3) default -8 null
			);

			create table aircraft_maintenance_alert
			(
			id int(10) unsigned auto_increment
			primary key,
			aircraft_id int(10) unsigned not null,
			alert_category tinyint(1) unsigned not null,
			alert_level tinyint(1) unsigned not null,
			is_enabled tinyint(1) unsigned default 0 not null,
			is_sent tinyint(1) unsigned default 0 not null
	);		);

Line 1,050:		Line 1,061:
	cell_phone varchar(255) null,		cell_phone varchar(255) null,
	lang varchar(255) null,		lang varchar(255) null,
	notification ~~smallint~~ unsigned null,		notification bigint(20) unsigned null,
	activated tinyint(1) unsigned default 1 null,		activated tinyint(1) unsigned default 1 null,
	birthdate datetime default '0000-00-00 00:00:00' null,		birthdate datetime default '0000-00-00 00:00:00' null,

Mbouzar: Undo revision 14398 by Mbouzar (talk)

2026-04-08T16:42:52Z

Undo revision 14398 by Mbouzar (talk)

← Older revision		Revision as of 16:42, 8 April 2026
Line 115:		Line 115:
	create table aircraft		create table aircraft
	(		(
	id int unsigned default 0 not null		id int unsigned default 0 not null
	primary key,		primary key,
	ref_date datetime null,		ref_date datetime null,
	ref_hours int null,		ref_hours int null,
	inspection_date datetime null,		inspection_date datetime null,
	inspection_time int null,		inspection_time int null,
	tolerance_time int(11) unsigned default 6000 null,		tolerance_time int(11) unsigned default 6000 null,
	last_counter int null,		last_counter int null,
	interval_visit int(11) unsigned default 30000 null,		interval_visit int(11) unsigned default 30000 null,
	time_alert1 int default 6000 null,		time_alert1 int default 6000 null,
	time_alert2 int default 0 null,		time_alert2 int default 0 null,
	time_alert3 int default -3000 null,		time_alert3 int default -3000 null,
	day_alert1 smallint(3) default 15 null,		day_alert1 smallint(3) default 15 null,
	day_alert2 smallint(3) default 0 null,		day_alert2 smallint(3) default 0 null,
	day_alert3 smallint(3) default -8 ~~null,~~		day_alert3 smallint(3) default -8 null
	~~day_alert1_send_email tinyint(1) default 0 null,~~
	~~day_alert2_send_email tinyint(1) default 0 null,~~
	~~day_alert3_send_email tinyint(1) default 0 null,~~
	~~time_alert1_send_email tinyint(1) default 0 null,~~
	~~time_alert2_send_email tinyint(1) default 0 null,~~
	~~time_alert3_send_email tinyint(1) default 0 null,~~
	~~engine_time_alert1_send_email tinyint(1) default 0 null,~~
	~~engine_time_alert2_send_email tinyint(1) default 0 null,~~
	~~engine_time_alert3_send_email tinyint(1) default 0 null,~~
	~~day_alert1_email_sent tinyint(1) default 0 null,~~
	~~day_alert2_email_sent tinyint(1) default 0 null,~~
	~~day_alert3_email_sent tinyint(1) default 0 null,~~
	~~time_alert1_email_sent tinyint(1) default 0 null,~~
	~~time_alert2_email_sent tinyint(1) default 0 null,~~
	~~time_alert3_email_sent tinyint(1) default 0 null,~~
	~~engine_time_alert1_email_sent tinyint(1) default 0 null,~~
	~~engine_time_alert2_email_sent tinyint(1) default 0 null,~~
	~~engine_time_alert3_email_sent tinyint(1) default 0~~ null
	);		);

Mbouzar: /* Structure */

2026-04-08T12:09:58Z

Structure

← Older revision		Revision as of 12:09, 8 April 2026
Line 1,068:		Line 1,068:
	cell_phone varchar(255) null,		cell_phone varchar(255) null,
	lang varchar(255) null,		lang varchar(255) null,
	notification ~~tinyint~~ unsigned null,		notification smallint unsigned null,
	activated tinyint(1) unsigned default 1 null,		activated tinyint(1) unsigned default 1 null,
	birthdate datetime default '0000-00-00 00:00:00' null,		birthdate datetime default '0000-00-00 00:00:00' null,