Structure de la base de données : Différence entre versions

Aller à : navigation, rechercher
(Structure)
(Une révision intermédiaire par le même utilisateur non affichée)
Ligne 10 : Ligne 10 :
 
   `name` text,
 
   `name` text,
 
   `export_account` varchar(255) DEFAULT NULL,
 
   `export_account` varchar(255) DEFAULT NULL,
   `activated` tinyint(1) unsigned NOT NULL DEFAULT '1',
+
   `activated` tinyint(1) NOT NULL DEFAULT '1',
 
   `category` tinyint(1) unsigned DEFAULT '0',
 
   `category` tinyint(1) unsigned DEFAULT '0',
 
   `account_type` tinyint(1) unsigned DEFAULT '0',
 
   `account_type` tinyint(1) unsigned DEFAULT '0',
Ligne 19 : Ligne 19 :
 
   `accounting_id` int(10) unsigned DEFAULT NULL,
 
   `accounting_id` int(10) unsigned DEFAULT NULL,
 
   `deactivated_date` datetime DEFAULT NULL,
 
   `deactivated_date` datetime DEFAULT NULL,
 +
  `group_sales` tinyint(1) NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`id`),
 
   PRIMARY KEY (`id`),
 
   KEY `idx_owner_id` (`owner_id`)
 
   KEY `idx_owner_id` (`owner_id`)
Ligne 71 : Ligne 72 :
 
   `name` varchar(255) DEFAULT NULL,
 
   `name` varchar(255) DEFAULT NULL,
 
   `category` tinyint(1) unsigned DEFAULT '0',
 
   `category` tinyint(1) unsigned DEFAULT '0',
   `activated` tinyint(1) DEFAULT '1',
+
   `activated` tinyint(1) unsigned DEFAULT '1',
 
   `order_num` int(11) DEFAULT NULL,
 
   `order_num` int(11) DEFAULT NULL,
 
   `accounting_id` int(10) unsigned DEFAULT NULL,
 
   `accounting_id` int(10) unsigned DEFAULT NULL,
 
   `export_account_pattern` varchar(255) DEFAULT NULL,
 
   `export_account_pattern` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of account type';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 86 : Ligne 87 :
 
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`account_type_id`,`profile_id`)
 
   PRIMARY KEY (`account_type_id`,`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Linked account type and profile';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Linked account type\r\nfield and profile';
  
 
--
 
--
Ligne 97 : Ligne 98 :
 
   `unit_name` varchar(255) DEFAULT NULL,
 
   `unit_name` varchar(255) DEFAULT NULL,
 
   `symbol` varchar(255) DEFAULT NULL,
 
   `symbol` varchar(255) DEFAULT NULL,
   `format` tinyint(1) DEFAULT NULL,
+
   `format` tinyint(1) unsigned DEFAULT NULL,
 
   `decimal_precision` int(10) unsigned DEFAULT '2',
 
   `decimal_precision` int(10) unsigned DEFAULT '2',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
Ligne 110 : Ligne 111 :
 
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`accounting_id`,`profile_id`)
 
   PRIMARY KEY (`accounting_id`,`profile_id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 +
--
 +
-- Table structure for table `activity_training`
 +
--
 +
 +
CREATE TABLE `activity_training` (
 +
  `activity_id` int(10) unsigned NOT NULL DEFAULT '0',
 +
  `theme_id` int(10) unsigned NOT NULL DEFAULT '0',
 +
  `student_id` int(10) DEFAULT NULL,
 +
  `level_reached` int(10) unsigned DEFAULT NULL,
 +
  `comment` varchar(255) DEFAULT NULL,
 +
  `validated` tinyint(1) NOT NULL DEFAULT '0',
 +
  `checker_person_id` int(10) DEFAULT NULL,
 +
  `checking_date` datetime DEFAULT NULL,
 +
  `checking_sentence` varchar(255) DEFAULT NULL,
 +
  PRIMARY KEY (`activity_id`,`theme_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
Ligne 122 : Ligne 140 :
 
   `activated` tinyint(1) NOT NULL DEFAULT '1',
 
   `activated` tinyint(1) NOT NULL DEFAULT '1',
 
   `color` int(10) unsigned DEFAULT NULL,
 
   `color` int(10) unsigned DEFAULT NULL,
 +
  `training` tinyint(1) NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of flight type';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of flight type';
Ligne 135 : Ligne 154 :
 
   `inspection_date` datetime DEFAULT NULL,
 
   `inspection_date` datetime DEFAULT NULL,
 
   `inspection_time` int(11) DEFAULT NULL,
 
   `inspection_time` int(11) DEFAULT NULL,
 +
  `tolerance_time` int(11) unsigned DEFAULT '6000',
 +
  `last_counter` int(11) DEFAULT NULL,
 
   `interval_visit` int(11) unsigned DEFAULT '30000',
 
   `interval_visit` int(11) unsigned DEFAULT '30000',
 
   `time_alert1` int(11) DEFAULT '6000',
 
   `time_alert1` int(11) DEFAULT '6000',
 
   `time_alert2` int(11) DEFAULT '0',
 
   `time_alert2` int(11) DEFAULT '0',
   `time_alert3` int(11) DEFAULT '-3000',
+
   `time_alert3` int(11) DEFAULT '0',
 
   `day_alert1` smallint(3) DEFAULT '15',
 
   `day_alert1` smallint(3) DEFAULT '15',
 
   `day_alert2` smallint(3) DEFAULT '0',
 
   `day_alert2` smallint(3) DEFAULT '0',
   `day_alert3` smallint(3) DEFAULT '-8',
+
   `day_alert3` smallint(3) DEFAULT '8',
  `last_counter` int(11) DEFAULT NULL,
+
  `tolerance_time` int(10) unsigned DEFAULT '6000',
+
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Aircraft data linked to resource';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='ALL AIRCRAFTS OF ALL AIRCLUBS';
  
 
--
 
--
Ligne 152 : Ligne 171 :
  
 
CREATE TABLE `aircraft_type` (
 
CREATE TABLE `aircraft_type` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+
   `id` int(10) unsigned NOT NULL,
   `flight_time_formula` varchar(255) DEFAULT '%DURATION',
+
   `flight_time_formula` varchar(255) DEFAULT NULL,
 
   `counter_state` tinyint(2) NOT NULL DEFAULT '-1',
 
   `counter_state` tinyint(2) NOT NULL DEFAULT '-1',
 
   `tolerance` int(11) DEFAULT '0',
 
   `tolerance` int(11) DEFAULT '0',
 
   `autonomy` int(11) DEFAULT '5990',
 
   `autonomy` int(11) DEFAULT '5990',
 +
  `digit_counter_number` tinyint(1) unsigned NOT NULL DEFAULT '4',
 
   `true_air_speed` int(10) unsigned NOT NULL DEFAULT '0',
 
   `true_air_speed` int(10) unsigned NOT NULL DEFAULT '0',
  `digit_counter_number` tinyint(1) unsigned NOT NULL DEFAULT '4',
 
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Types of aircraft';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Types of aircraft';
Ligne 169 : Ligne 188 :
 
   `aircraft_type_id` int(10) unsigned DEFAULT NULL,
 
   `aircraft_type_id` int(10) unsigned DEFAULT NULL,
 
   `place_num` int(10) unsigned DEFAULT NULL,
 
   `place_num` int(10) unsigned DEFAULT NULL,
   `status_id` int(10) unsigned DEFAULT NULL
+
   `status_id` int(10) DEFAULT NULL
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of allowed functions for each aircraft type';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of allowed functions for each aircraft type';
  
Ligne 196 : Ligne 215 :
 
CREATE TABLE `aircraft_type_validity_type` (
 
CREATE TABLE `aircraft_type_validity_type` (
 
   `aircraft_type_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `aircraft_type_id` int(10) unsigned NOT NULL DEFAULT '0',
   `validity_type_id` int(10) unsigned NOT NULL DEFAULT '0',
+
   `validity_type_id` int(10) unsigned NOT NULL,
 
   `check_num` int(10) unsigned NOT NULL DEFAULT '0',
 
   `check_num` int(10) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`aircraft_type_id`,`validity_type_id`,`check_num`)
 
   PRIMARY KEY (`aircraft_type_id`,`validity_type_id`,`check_num`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Types of qualif required for each aircraft type';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Types of qualif required for each aircraft type';
 +
 +
--
 +
-- Table structure for table `allocation_rule`
 +
--
 +
 +
CREATE TABLE `allocation_rule` (
 +
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 +
  `title` varchar(255) NOT NULL,
 +
  `account_id` int(10) NOT NULL,
 +
  `keyword` varchar(255) DEFAULT NULL,
 +
  `order_num` int(10) NOT NULL,
 +
  `amount` tinyint(1) NOT NULL,
 +
  `mandatory` tinyint(1) NOT NULL DEFAULT '0',
 +
  PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 207 : Ligne 241 :
 
CREATE TABLE `balance` (
 
CREATE TABLE `balance` (
 
   `account_id` int(10) unsigned NOT NULL,
 
   `account_id` int(10) unsigned NOT NULL,
   `balance_date_id` int(10) unsigned NOT NULL,
+
   `balance_date_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `debit` decimal(15,5) DEFAULT '0.00000',
 
   `debit` decimal(15,5) DEFAULT '0.00000',
 
   `credit` decimal(15,5) DEFAULT '0.00000',
 
   `credit` decimal(15,5) DEFAULT '0.00000',
 
   PRIMARY KEY (`account_id`,`balance_date_id`)
 
   PRIMARY KEY (`account_id`,`balance_date_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of balance';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 221 : Ligne 255 :
 
   `balance_date` datetime DEFAULT NULL,
 
   `balance_date` datetime DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of balance date';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 233 : Ligne 267 :
 
   `end_date` datetime DEFAULT NULL,
 
   `end_date` datetime DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of booking';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='RECORDS ALL THE SLOTS OF ALL AIRCRAFTS OF ALL AIRCLUBS';
  
 
--
 
--
Ligne 298 : Ligne 332 :
 
   `group_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `group_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `name` varchar(255) DEFAULT NULL,
 
   `name` varchar(255) DEFAULT NULL,
   `order_num` int(11) DEFAULT NULL,
+
   `order_num` int(11) NOT NULL,
 
   `export_code` varchar(255) DEFAULT NULL,
 
   `export_code` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of budget';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 310 : Ligne 344 :
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `name` varchar(255) DEFAULT NULL,
 
   `name` varchar(255) DEFAULT NULL,
   `order_num` int(11) DEFAULT NULL,
+
   `order_num` int(11) NOT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of budget group';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 321 : Ligne 355 :
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `variable` varchar(255) DEFAULT NULL,
 
   `variable` varchar(255) DEFAULT NULL,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
   `value_type` varchar(40) NOT NULL,
+
   `value_type` varchar(40) DEFAULT NULL,
   `category` varchar(255) NOT NULL,
+
   `category` varchar(255) DEFAULT NULL,
   `order_num` int(11) NOT NULL,
+
   `order_num` int(11) DEFAULT NULL,
   `dsn` varchar(20) DEFAULT 'customer',
+
   `dsn` varchar(20) DEFAULT NULL,
 
   `compulsory_fill` tinyint(1) DEFAULT '0',
 
   `compulsory_fill` tinyint(1) DEFAULT '0',
 
   `linked_category` varchar(255) DEFAULT NULL,
 
   `linked_category` varchar(255) DEFAULT NULL,
Ligne 334 : Ligne 368 :
 
   `default_value` text,
 
   `default_value` text,
 
   `placeholder` text,
 
   `placeholder` text,
 +
  `access_level_required` tinyint(4) NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`id`),
 
   PRIMARY KEY (`id`),
 
   UNIQUE KEY `variable` (`variable`)
 
   UNIQUE KEY `variable` (`variable`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of business form field';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of extra form field';
  
 
--
 
--
Ligne 361 : Ligne 396 :
 
   `placeholder` text,
 
   `placeholder` text,
 
   PRIMARY KEY (`category_id`,`business_field_id`,`person_id`)
 
   PRIMARY KEY (`category_id`,`business_field_id`,`person_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Content of business form field';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Content of extra form field';
  
 
--
 
--
Ligne 380 : Ligne 415 :
 
CREATE TABLE `criteria` (
 
CREATE TABLE `criteria` (
 
   `id` int(11) NOT NULL AUTO_INCREMENT,
 
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
   `predicate` text NOT NULL,
+
   `predicate` text,
 
   `order_num` int(11) DEFAULT NULL,
 
   `order_num` int(11) DEFAULT NULL,
   `dsn` varchar(20) DEFAULT 'customer',
+
   `dsn` varchar(20) NOT NULL DEFAULT 'customer',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of criteria';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 418 : Ligne 453 :
 
   KEY `idx_account_entry_id` (`account_entry_id`),
 
   KEY `idx_account_entry_id` (`account_entry_id`),
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of customer bill lines';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 429 : Ligne 464 :
 
   `content` longblob,
 
   `content` longblob,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of customer bill stored file';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 447 : Ligne 482 :
 
   `credit` decimal(15,5) DEFAULT '0.00000',
 
   `credit` decimal(15,5) DEFAULT '0.00000',
 
   `receipt_date` datetime DEFAULT NULL,
 
   `receipt_date` datetime DEFAULT NULL,
 +
  `owner_email` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`id`),
 
   PRIMARY KEY (`id`),
 
   KEY `idx_account_entry_id` (`account_entry_id`),
 
   KEY `idx_account_entry_id` (`account_entry_id`),
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of customer receipt lines';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 461 : Ligne 497 :
 
   `content` longblob,
 
   `content` longblob,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of customer receipt stored file';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 
 
--
 
--
 
-- Table structure for table `default_display`
 
-- Table structure for table `default_display`
Ligne 467 : Ligne 504 :
  
 
CREATE TABLE `default_display` (
 
CREATE TABLE `default_display` (
   `person_id` int(10) unsigned NOT NULL,
+
   `person_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `display_key` varchar(255) NOT NULL DEFAULT '',
 
   `display_key` varchar(255) NOT NULL DEFAULT '',
 
   `display_value` text,
 
   `display_value` text,
 
   PRIMARY KEY (`person_id`,`display_key`)
 
   PRIMARY KEY (`person_id`,`display_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of default display parameters';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 479 : Ligne 516 :
 
CREATE TABLE `default_multi_display` (
 
CREATE TABLE `default_multi_display` (
 
   `resource_type` char(30) NOT NULL,
 
   `resource_type` char(30) NOT NULL,
   `person_id` int(10) unsigned NOT NULL,
+
   `person_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `resource_id` varchar(100) NOT NULL,
 
   `resource_id` varchar(100) NOT NULL,
 
   `display_value` text,
 
   `display_value` text,
 
   PRIMARY KEY (`resource_type`,`person_id`,`resource_id`)
 
   PRIMARY KEY (`resource_type`,`person_id`,`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of default multi display parameters';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 538 : Ligne 575 :
 
   `booking_popup_display_4_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   `booking_popup_display_4_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`business_field_id`,`booking_popup_display_4_profile_id`)
 
   PRIMARY KEY (`business_field_id`,`booking_popup_display_4_profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Linked business field and profile';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 553 : Ligne 590 :
 
   `description` text,
 
   `description` text,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of user picture';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 560 : Ligne 597 :
  
 
CREATE TABLE `favorite_icao` (
 
CREATE TABLE `favorite_icao` (
   `icao` varchar(6) NOT NULL,
+
   `icao` varchar(6) NOT NULL DEFAULT '',
 
   PRIMARY KEY (`icao`)
 
   PRIMARY KEY (`icao`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='favorite airfield list';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='favorite airfield list';
Ligne 571 : Ligne 608 :
 
   `report_id` int(10) unsigned NOT NULL,
 
   `report_id` int(10) unsigned NOT NULL,
 
   PRIMARY KEY (`report_id`)
 
   PRIMARY KEY (`report_id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 +
--
 +
-- Table structure for table `favorite_report_business_field`
 +
--
 +
 +
CREATE TABLE `favorite_report_business_field` (
 +
  `report_id` int(10) unsigned NOT NULL,
 +
  `business_field_id` int(10) unsigned NOT NULL,
 +
  `default_value` text,
 +
  PRIMARY KEY (`report_id`,`business_field_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
Ligne 622 : Ligne 670 :
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `name` varchar(255) DEFAULT NULL,
 
   `name` varchar(255) DEFAULT NULL,
   `content` mediumblob,
+
   `content` longblob,
 
   `file_type` varchar(255) DEFAULT NULL,
 
   `file_type` varchar(255) DEFAULT NULL,
 
   `category` tinyint(1) unsigned DEFAULT NULL,
 
   `category` tinyint(1) unsigned DEFAULT NULL,
 +
  `owner_id` int(10) DEFAULT NULL,
 +
  `file_group_id` int(10) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of stored file';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 
 +
--
 +
-- Table structure for table `file_group`
 +
--
 +
 
 +
CREATE TABLE `file_group` (
 +
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 +
  `label` varchar(255) DEFAULT NULL,
 +
  PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 678 : Ligne 738 :
 
   `order_num` int(11) DEFAULT NULL,
 
   `order_num` int(11) DEFAULT NULL,
 
   `product_id` int(10) unsigned DEFAULT NULL,
 
   `product_id` int(10) unsigned DEFAULT NULL,
   `sale_trigger_id` int(10) unsigned DEFAULT '0',
+
   `sale_trigger_id` int(10) unsigned DEFAULT NULL,
 
   `query` text,
 
   `query` text,
   `variable_formula` text,
+
   `variable_formula` varchar(255) DEFAULT NULL,
 
   `business_field_id` int(10) unsigned DEFAULT NULL,
 
   `business_field_id` int(10) unsigned DEFAULT NULL,
 
   `debit_bill_num` int(10) unsigned DEFAULT NULL,
 
   `debit_bill_num` int(10) unsigned DEFAULT NULL,
Ligne 696 : Ligne 756 :
 
   `flight_id` int(10) unsigned NOT NULL,
 
   `flight_id` int(10) unsigned NOT NULL,
 
   `pilot_id` int(10) unsigned NOT NULL,
 
   `pilot_id` int(10) unsigned NOT NULL,
   `status_id` int(10) unsigned DEFAULT NULL,
+
   `status_id` int(10) DEFAULT NULL,
 
   `num` int(10) unsigned NOT NULL DEFAULT '0',
 
   `num` int(10) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`flight_id`,`pilot_id`,`num`)
 
   PRIMARY KEY (`flight_id`,`pilot_id`,`num`)
Ligne 709 : Ligne 769 :
 
   `flight_id` int(10) unsigned NOT NULL,
 
   `flight_id` int(10) unsigned NOT NULL,
 
   `tank_id` int(10) unsigned NOT NULL,
 
   `tank_id` int(10) unsigned NOT NULL,
   `quantity` varchar(255) NOT NULL DEFAULT '0.00',
+
   `quantity` varchar(255) DEFAULT NULL,
 
   `after_flight` tinyint(1) NOT NULL DEFAULT '0',
 
   `after_flight` tinyint(1) NOT NULL DEFAULT '0',
 
   `account_id` int(10) unsigned DEFAULT NULL,
 
   `account_id` int(10) unsigned DEFAULT NULL,
 
   `pay_type` tinyint(1) unsigned DEFAULT NULL,
 
   `pay_type` tinyint(1) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of flight tank quantities';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 721 : Ligne 781 :
  
 
CREATE TABLE `flight_track` (
 
CREATE TABLE `flight_track` (
   `flight_id` int(10) unsigned NOT NULL,
+
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `track_id` int(10) unsigned NOT NULL,
+
   `flight_id` int(10) NOT NULL,
   PRIMARY KEY (`track_id`,`flight_id`)
+
  `track` mediumblob NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Link between flight and track';
+
   PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 732 : Ligne 793 :
 
CREATE TABLE `flight_type_mandatory_validity_type` (
 
CREATE TABLE `flight_type_mandatory_validity_type` (
 
   `activity_type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   `activity_type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
   `validity_type_id` int(10) unsigned NOT NULL DEFAULT '0',
+
   `validity_type_id` int(10) unsigned NOT NULL,
 
   PRIMARY KEY (`activity_type_id`,`validity_type_id`)
 
   PRIMARY KEY (`activity_type_id`,`validity_type_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of mandatory qualification for each flight type';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of mandatory qualification for each flight type';
Ligne 753 : Ligne 814 :
 
   `sync_task_name` varchar(255) DEFAULT NULL,
 
   `sync_task_name` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of import';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 761 : Ligne 822 :
 
CREATE TABLE `ip_stopped` (
 
CREATE TABLE `ip_stopped` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `ip` varchar(255) NOT NULL,
+
   `ip` varchar(255) DEFAULT NULL,
 
   `counter` tinyint(1) unsigned NOT NULL,
 
   `counter` tinyint(1) unsigned NOT NULL,
 
   `expire_date` datetime NOT NULL,
 
   `expire_date` datetime NOT NULL,
Ligne 804 : Ligne 865 :
 
   `aircraft_id` int(10) unsigned DEFAULT '0',
 
   `aircraft_id` int(10) unsigned DEFAULT '0',
 
   `key_state` tinyint(1) unsigned DEFAULT '0',
 
   `key_state` tinyint(1) unsigned DEFAULT '0',
   `key_word` bigint(20) unsigned DEFAULT '0',
+
   `key_word` bigint(20) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`key_id`)
 
   PRIMARY KEY (`key_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='key assignment description';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='key assignment description';
Ligne 814 : Ligne 875 :
 
CREATE TABLE `key_host` (
 
CREATE TABLE `key_host` (
 
   `id` tinyint(2) NOT NULL AUTO_INCREMENT,
 
   `id` tinyint(2) NOT NULL AUTO_INCREMENT,
   `timeout` tinyint(2) NOT NULL DEFAULT '10',
+
   `timeout` tinyint(2) unsigned NOT NULL DEFAULT '10',
   `num_key` tinyint(2) unsigned NOT NULL DEFAULT '10',
+
   `num_key` tinyint(2) unsigned NOT NULL DEFAULT '8',
   `ipkey` varchar(50) NOT NULL DEFAULT '127.0.0.1',
+
   `ipkey` varchar(50) DEFAULT NULL,
   `httpport` int(11) NOT NULL DEFAULT '4080',
+
   `httpport` int(11) DEFAULT '4080',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='key host configuration';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='key host configuration';
Ligne 885 : Ligne 946 :
 
CREATE TABLE `login_stopped` (
 
CREATE TABLE `login_stopped` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `login` varchar(255) NOT NULL,
+
   `login` varchar(255) DEFAULT NULL,
 
   `counter` tinyint(3) unsigned NOT NULL,
 
   `counter` tinyint(3) unsigned NOT NULL,
 
   `expire_date` datetime NOT NULL,
 
   `expire_date` datetime NOT NULL,
Ligne 967 : Ligne 1 028 :
 
   `m_component_type_id` int(10) unsigned NOT NULL,
 
   `m_component_type_id` int(10) unsigned NOT NULL,
 
   `order_num` int(11) NOT NULL,
 
   `order_num` int(11) NOT NULL,
 +
  PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 +
--
 +
-- Table structure for table `maintenance_history`
 +
--
 +
 +
CREATE TABLE `maintenance_history` (
 +
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 +
  `resource_id` int(10) unsigned DEFAULT NULL,
 +
  `maintenance_program_id` int(10) unsigned DEFAULT NULL,
 +
  `frame_hours_at_work_start` int(10) DEFAULT NULL,
 +
  `date_work_end` date DEFAULT NULL,
 +
  `min_overhaul_counter` int(10) DEFAULT NULL,
 +
  `max_overhaul_counter` int(10) DEFAULT NULL,
 +
  `min_overhaul_date` date DEFAULT NULL,
 +
  `max_overhaul_date` date DEFAULT NULL,
 +
  `min_next_overhaul_counter` int(10) DEFAULT NULL,
 +
  `max_next_overhaul_counter` int(10) DEFAULT NULL,
 +
  `min_next_overhaul_date` date DEFAULT NULL,
 +
  `max_next_overhaul_date` date DEFAULT NULL,
 +
  `first_reference_visit` tinyint(1) unsigned NOT NULL DEFAULT '0',
 +
  `is_visit` tinyint(1) unsigned NOT NULL DEFAULT '0',
 +
  `action_type` tinyint(1) unsigned DEFAULT NULL,
 +
  `previous_line_linked_time_action` int(10) DEFAULT NULL,
 +
  `previous_line_linked_calendar_action` int(10) DEFAULT NULL,
 +
  `next_line_linked_time_action` int(10) DEFAULT NULL,
 +
  `next_line_linked_calendar_action` int(10) DEFAULT NULL,
 +
  `time_tolerance` int(10) DEFAULT NULL,
 +
  `calendar_tolerance` int(10) DEFAULT NULL,
 +
  `time_periodicity_component` int(10) DEFAULT NULL,
 +
  `calendar_periodicity_component` int(10) DEFAULT NULL,
 +
  `time_periodicity` int(10) DEFAULT NULL,
 +
  `calendar_periodicity` int(10) DEFAULT NULL,
 +
  `reference_overhaul_counter` int(10) DEFAULT NULL,
 +
  `reference_overhaul_date` date DEFAULT NULL,
 +
  PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 +
--
 +
-- Table structure for table `maintenance_program`
 +
--
 +
 +
CREATE TABLE `maintenance_program` (
 +
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 +
  `resource_id` int(10) unsigned DEFAULT NULL,
 +
  `component_type_id` int(10) unsigned DEFAULT NULL,
 +
  `description` varchar(255) DEFAULT NULL,
 +
  `time_periodicity` int(10) DEFAULT NULL,
 +
  `calendar_periodicity` int(10) DEFAULT NULL,
 +
  `time_first_reference` int(10) DEFAULT NULL,
 +
  `calendar_first_reference` date DEFAULT NULL,
 +
  `time_tolerance` int(10) DEFAULT NULL,
 +
  `calendar_tolerance` int(10) DEFAULT NULL,
 +
  `frame_hours_at_work_start` int(10) DEFAULT NULL,
 +
  `date_work_end` date DEFAULT NULL,
 +
  `time_elapsed` int(10) DEFAULT NULL,
 +
  `calendar_elapsed` int(10) DEFAULT NULL,
 +
  `time_remaining` int(10) DEFAULT NULL,
 +
  `calendar_remaining` int(10) DEFAULT NULL,
 +
  `min_next_overhaul_counter` int(10) DEFAULT NULL,
 +
  `max_next_overhaul_counter` int(10) DEFAULT NULL,
 +
  `min_next_overhaul_date` date DEFAULT NULL,
 +
  `max_next_overhaul_date` date DEFAULT NULL,
 +
  `effective_hours_at_work_start` int(10) DEFAULT NULL,
 +
  `theoretical_overhaul_counter` int(10) DEFAULT NULL,
 +
  `intelligent_overhaul_counter` int(10) DEFAULT NULL,
 +
  `intelligent_min_next_overhaul_counter` int(10) DEFAULT NULL,
 +
  `intelligent_max_next_overhaul_counter` int(10) DEFAULT NULL,
 +
  `effective_date_at_work_end` date DEFAULT NULL,
 +
  `theoretical_overhaul_date` date DEFAULT NULL,
 +
  `intelligent_overhaul_date` date DEFAULT NULL,
 +
  `intelligent_min_next_overhaul_date` date DEFAULT NULL,
 +
  `intelligent_max_next_overhaul_date` date DEFAULT NULL,
 +
  `overlapping_group_id` int(10) unsigned DEFAULT NULL,
 +
  `is_visit_rg` tinyint(1) unsigned NOT NULL DEFAULT '0',
 +
  PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 +
--
 +
-- Table structure for table `maintenance_view`
 +
--
 +
 +
CREATE TABLE `maintenance_view` (
 +
  `id` int(10) unsigned NOT NULL DEFAULT '0',
 +
  `frame_total_time` int(10) DEFAULT NULL,
 +
  `frame_time_since_rg` int(10) DEFAULT NULL,
 +
  `engine_time_since_rg` int(10) DEFAULT NULL,
 +
  `propeller_time_since_rg` int(10) DEFAULT NULL,
 +
  `potential_remaining_next_time_action` int(10) DEFAULT NULL,
 +
  `potential_remaining_next_time_visit` int(10) DEFAULT NULL,
 +
  `potential_remaining_next_priority_time_action` int(10) DEFAULT NULL,
 +
  `potential_remaining_next_calendar_action` int(10) DEFAULT NULL,
 +
  `potential_remaining_next_calendar_visit` int(10) DEFAULT NULL,
 +
  `potential_remaining_next_priority_calendar_action` int(10) DEFAULT NULL,
 +
  `next_time_action_id` int(10) unsigned DEFAULT NULL,
 +
  `next_time_visit_id` int(10) unsigned DEFAULT NULL,
 +
  `next_priority_time_action_id` int(10) unsigned DEFAULT NULL,
 +
  `next_calendar_action_id` int(10) unsigned DEFAULT NULL,
 +
  `next_calendar_visit_id` int(10) unsigned DEFAULT NULL,
 +
  `next_priority_calendar_action_id` int(10) unsigned DEFAULT NULL,
 +
  `overhaul_counter_action` int(10) DEFAULT NULL,
 +
  `overhaul_counter_visit` int(10) DEFAULT NULL,
 +
  `overhaul_date_action` date DEFAULT NULL,
 +
  `overhaul_date_visit` date DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Ligne 978 : Ligne 1 144 :
 
   `count_data` int(10) unsigned NOT NULL,
 
   `count_data` int(10) unsigned NOT NULL,
 
   PRIMARY KEY (`record_id`)
 
   PRIMARY KEY (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Link between flight and track';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='link between flight and track';
  
 
--
 
--
Ligne 1 003 : Ligne 1 169 :
  
 
CREATE TABLE `nationality` (
 
CREATE TABLE `nationality` (
   `code` char(2) NOT NULL,
+
   `code` char(2) NOT NULL DEFAULT '',
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`code`)
 
   PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of nationalities';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 013 : Ligne 1 179 :
  
 
CREATE TABLE `parameter` (
 
CREATE TABLE `parameter` (
   `code` varchar(255) NOT NULL,
+
   `code` varchar(255) NOT NULL DEFAULT '',
 
   `key_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `key_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `enabled` tinyint(1) unsigned DEFAULT '0',
 
   `enabled` tinyint(1) unsigned DEFAULT '0',
Ligne 1 069 : Ligne 1 235 :
 
CREATE TABLE `person` (
 
CREATE TABLE `person` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `name` varchar(255) NOT NULL,
+
   `name` varchar(255) DEFAULT NULL,
 
   `hash_password` varchar(255) NOT NULL,
 
   `hash_password` varchar(255) NOT NULL,
 
   `first_name` varchar(255) DEFAULT NULL,
 
   `first_name` varchar(255) DEFAULT NULL,
 
   `last_name` varchar(255) DEFAULT NULL,
 
   `last_name` varchar(255) DEFAULT NULL,
   `profile` bigint(20) unsigned NOT NULL DEFAULT '0',
+
   `profile` bigint(20) unsigned DEFAULT NULL,
 
   `view_type` int(10) unsigned DEFAULT NULL,
 
   `view_type` int(10) unsigned DEFAULT NULL,
 
   `view_width` tinyint(3) unsigned NOT NULL DEFAULT '12',
 
   `view_width` tinyint(3) unsigned NOT NULL DEFAULT '12',
Ligne 1 096 : Ligne 1 262 :
 
   `date_total_flight_time` datetime DEFAULT NULL,
 
   `date_total_flight_time` datetime DEFAULT NULL,
 
   `guid` varchar(255) DEFAULT NULL,
 
   `guid` varchar(255) DEFAULT NULL,
 +
  `activity_notification` bigint(20) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`),
 
   PRIMARY KEY (`id`),
 
   UNIQUE KEY `idx_name` (`name`)
 
   UNIQUE KEY `idx_name` (`name`)
Ligne 1 106 : Ligne 1 273 :
 
CREATE TABLE `person_awaiting_activation` (
 
CREATE TABLE `person_awaiting_activation` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `login` varchar(255) NOT NULL,
+
   `login` varchar(255) DEFAULT NULL,
   `ip` varchar(255) NOT NULL,
+
   `ip` varchar(255) DEFAULT NULL,
   `code` varchar(255) NOT NULL,
+
   `code` varchar(255) DEFAULT NULL,
   `category` varchar(255) NOT NULL,
+
   `category` varchar(255) DEFAULT NULL,
 
   `expiration_date` datetime DEFAULT NULL,
 
   `expiration_date` datetime DEFAULT NULL,
 
   `used` tinyint(1) unsigned DEFAULT NULL,
 
   `used` tinyint(1) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='member_awaiting_activation';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 121 : Ligne 1 288 :
 
CREATE TABLE `product` (
 
CREATE TABLE `product` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
   `unit` varchar(255) NOT NULL,
+
   `unit` varchar(255) DEFAULT NULL,
 
   `free_sale` tinyint(1) NOT NULL DEFAULT '0',
 
   `free_sale` tinyint(1) NOT NULL DEFAULT '0',
 
   `locked` tinyint(1) unsigned DEFAULT '0',
 
   `locked` tinyint(1) unsigned DEFAULT '0',
Ligne 1 128 : Ligne 1 295 :
 
   `sale_type` tinyint(1) unsigned DEFAULT NULL,
 
   `sale_type` tinyint(1) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of sale type';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 160 : Ligne 1 327 :
  
 
CREATE TABLE `profile_extra_field_join` (
 
CREATE TABLE `profile_extra_field_join` (
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
+
   `profile_id` bigint(20) unsigned NOT NULL,
 
   `business_field_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   `business_field_id` int(10) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`profile_id`,`business_field_id`)
 
   PRIMARY KEY (`profile_id`,`business_field_id`)
Ligne 1 170 : Ligne 1 337 :
  
 
CREATE TABLE `profile_profile_view` (
 
CREATE TABLE `profile_profile_view` (
   `profile_id` bigint(20) unsigned NOT NULL,
+
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
   `viewable_profile_id` bigint(20) unsigned NOT NULL,
+
   `viewable_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`profile_id`,`viewable_profile_id`)
 
   PRIMARY KEY (`profile_id`,`viewable_profile_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Ligne 1 180 : Ligne 1 347 :
  
 
CREATE TABLE `profile_required_account_type` (
 
CREATE TABLE `profile_required_account_type` (
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
+
   `profile_id` bigint(20) unsigned NOT NULL,
   `account_type_id` int(10) unsigned NOT NULL DEFAULT '0',
+
   `account_type_id` int(10) unsigned NOT NULL,
 
   PRIMARY KEY (`profile_id`,`account_type_id`)
 
   PRIMARY KEY (`profile_id`,`account_type_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Ligne 1 190 : Ligne 1 357 :
  
 
CREATE TABLE `profile_resource_type_place` (
 
CREATE TABLE `profile_resource_type_place` (
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
+
   `profile_id` bigint(20) unsigned NOT NULL,
   `resource_type_id` int(10) unsigned NOT NULL DEFAULT '0',
+
   `resource_type_id` int(10) unsigned NOT NULL,
 
   `place_num` int(10) unsigned NOT NULL,
 
   `place_num` int(10) unsigned NOT NULL,
 
   PRIMARY KEY (`profile_id`,`resource_type_id`,`place_num`)
 
   PRIMARY KEY (`profile_id`,`resource_type_id`,`place_num`)
Ligne 1 201 : Ligne 1 368 :
  
 
CREATE TABLE `profile_resource_type_view` (
 
CREATE TABLE `profile_resource_type_view` (
   `profile_id` bigint(20) unsigned NOT NULL,
+
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
   `viewable_resource_type_id` int(10) unsigned NOT NULL,
 
   `viewable_resource_type_id` int(10) unsigned NOT NULL,
 
   PRIMARY KEY (`profile_id`,`viewable_resource_type_id`)
 
   PRIMARY KEY (`profile_id`,`viewable_resource_type_id`)
Ligne 1 211 : Ligne 1 378 :
  
 
CREATE TABLE `profile_validity_type_join` (
 
CREATE TABLE `profile_validity_type_join` (
   `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
+
   `profile_id` bigint(20) unsigned NOT NULL,
   `validity_type_id` int(10) unsigned NOT NULL DEFAULT '0',
+
  `validity_type_id` int(10) unsigned NOT NULL,
 +
  `manage4oneself` int(1) NOT NULL DEFAULT '0',
 +
   `certify` int(1) NOT NULL DEFAULT '0',
 +
  `optional_contract` tinyint(1) NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`profile_id`,`validity_type_id`)
 
   PRIMARY KEY (`profile_id`,`validity_type_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Ligne 1 253 : Ligne 1 423 :
 
   `token` text,
 
   `token` text,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of waiting cash transactions';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 294 : Ligne 1 464 :
 
   `color` int(10) unsigned DEFAULT NULL,
 
   `color` int(10) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of resource';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 330 : Ligne 1 500 :
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `name` varchar(255) DEFAULT NULL,
 
   `name` varchar(255) DEFAULT NULL,
   `category` int(10) unsigned DEFAULT NULL,
+
   `category` int(10) unsigned NOT NULL,
 
   `seats_available` int(11) DEFAULT '-1',
 
   `seats_available` int(11) DEFAULT '-1',
 
   `comments` varchar(255) DEFAULT NULL,
 
   `comments` varchar(255) DEFAULT NULL,
 
   `order_num` int(11) DEFAULT NULL,
 
   `order_num` int(11) DEFAULT NULL,
   `activated` tinyint(1) unsigned NOT NULL DEFAULT '1',
+
   `activated` tinyint(1) NOT NULL DEFAULT '1',
 
   `max_booking_duration` int(10) DEFAULT '-1',
 
   `max_booking_duration` int(10) DEFAULT '-1',
 
   `pictogram` int(10) unsigned DEFAULT NULL,
 
   `pictogram` int(10) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of resource type';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 345 : Ligne 1 515 :
  
 
CREATE TABLE `resource_type_place_tag` (
 
CREATE TABLE `resource_type_place_tag` (
   `resource_type_id` int(10) unsigned NOT NULL DEFAULT '0',
+
   `resource_type_id` int(10) unsigned NOT NULL,
 
   `place_num` tinyint(1) unsigned NOT NULL,
 
   `place_num` tinyint(1) unsigned NOT NULL,
 
   `place_tag` varchar(255) DEFAULT NULL,
 
   `place_tag` varchar(255) DEFAULT NULL,
Ligne 1 362 : Ligne 1 532 :
 
   `stock_variation_qty_per_sale` float NOT NULL DEFAULT '0',
 
   `stock_variation_qty_per_sale` float NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of stock put into sale';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 376 : Ligne 1 546 :
 
   PRIMARY KEY (`id`),
 
   PRIMARY KEY (`id`),
 
   UNIQUE KEY `validity_type_id` (`validity_type_id`),
 
   UNIQUE KEY `validity_type_id` (`validity_type_id`),
   KEY `idx_product` (`product_id`)
+
   KEY `idx_product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of validity type into sale';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 385 : Ligne 1 555 :
 
CREATE TABLE `sale_pricing` (
 
CREATE TABLE `sale_pricing` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 +
  `label` varchar(255) DEFAULT NULL,
 
   `price_formula` text,
 
   `price_formula` text,
   `debit_account_id` int(10) unsigned DEFAULT NULL,
+
   `debit_account_id` int(10) unsigned NOT NULL,
   `credit_account_id` int(10) unsigned DEFAULT NULL,
+
   `credit_account_id` int(10) unsigned NOT NULL,
   `debit_account_type` tinyint(1) unsigned DEFAULT '0',
+
   `debit_account_type` int(10) unsigned NOT NULL,
   `credit_account_type` tinyint(1) unsigned DEFAULT '0',
+
   `credit_account_type` int(10) unsigned NOT NULL,
  `credit_budget_id` int(10) unsigned DEFAULT NULL,
+
 
   `debit_budget_id` int(10) unsigned DEFAULT NULL,
 
   `debit_budget_id` int(10) unsigned DEFAULT NULL,
   `order_num` int(11) DEFAULT NULL,
+
   `credit_budget_id` int(10) unsigned DEFAULT NULL,
   `label` varchar(255) DEFAULT NULL,
+
   `order_num` int(10) DEFAULT NULL,
 
   `variable_formula` varchar(255) DEFAULT NULL,
 
   `variable_formula` varchar(255) DEFAULT NULL,
 
   `debit_bill_num` int(10) unsigned DEFAULT NULL,
 
   `debit_bill_num` int(10) unsigned DEFAULT NULL,
Ligne 1 401 : Ligne 1 571 :
 
   `added_product_id` int(10) unsigned DEFAULT NULL,
 
   `added_product_id` int(10) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of sale pricing formula';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 431 : Ligne 1 601 :
 
   `name` varchar(255) DEFAULT NULL,
 
   `name` varchar(255) DEFAULT NULL,
 
   `event` varchar(255) DEFAULT NULL,
 
   `event` varchar(255) DEFAULT NULL,
   `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
+
   `locked` tinyint(1) unsigned DEFAULT '0',
 
   `query` text,
 
   `query` text,
 
   `validate_entry` tinyint(1) DEFAULT '0',
 
   `validate_entry` tinyint(1) DEFAULT '0',
 +
  `group_sales` tinyint(1) DEFAULT '0',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of sale trigger';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 458 : Ligne 1 629 :
 
   `name` varchar(255) NOT NULL,
 
   `name` varchar(255) NOT NULL,
 
   `of_version` tinyint(3) NOT NULL DEFAULT '0',
 
   `of_version` tinyint(3) NOT NULL DEFAULT '0',
   `value` decimal(15,2) NOT NULL DEFAULT '0.00',
+
   `value` decimal(15,2) DEFAULT '0.00',
 
   PRIMARY KEY (`name`,`of_version`)
 
   PRIMARY KEY (`name`,`of_version`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Ligne 1 480 : Ligne 1 651 :
 
CREATE TABLE `stock` (
 
CREATE TABLE `stock` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
 
   `stock_type_id` int(10) unsigned NOT NULL,
 
   `stock_type_id` int(10) unsigned NOT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of stock';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 495 : Ligne 1 666 :
 
   `stock_date` datetime DEFAULT NULL,
 
   `stock_date` datetime DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of stock level';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 503 : Ligne 1 674 :
 
CREATE TABLE `stock_type` (
 
CREATE TABLE `stock_type` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
   `unit` varchar(255) NOT NULL,
+
   `unit` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of stock type';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 519 : Ligne 1 690 :
 
   `validated` tinyint(1) unsigned DEFAULT '0',
 
   `validated` tinyint(1) unsigned DEFAULT '0',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of stock variation';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 529 : Ligne 1 700 :
 
   `stock_variation_id` int(10) unsigned NOT NULL,
 
   `stock_variation_id` int(10) unsigned NOT NULL,
 
   `account_entry_flow_id` int(10) unsigned NOT NULL,
 
   `account_entry_flow_id` int(10) unsigned NOT NULL,
   `person_id` int(10) unsigned NOT NULL,
+
   `person_id` int(10) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`product_id`,`stock_variation_id`,`account_entry_flow_id`),
 
   PRIMARY KEY (`product_id`,`stock_variation_id`,`account_entry_flow_id`),
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of stock variation account entry';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 548 : Ligne 1 719 :
 
   `first_hour_displayed` time DEFAULT NULL,
 
   `first_hour_displayed` time DEFAULT NULL,
 
   `last_hour_displayed` time DEFAULT NULL,
 
   `last_hour_displayed` time DEFAULT NULL,
   `usual_profiles` bigint(20) unsigned NOT NULL DEFAULT '0',
+
   `usual_profiles` bigint(20) unsigned DEFAULT NULL,
 
   `icao` varchar(6) DEFAULT NULL,
 
   `icao` varchar(6) DEFAULT NULL,
 
   `default_slot_range` int(10) unsigned DEFAULT NULL,
 
   `default_slot_range` int(10) unsigned DEFAULT NULL,
Ligne 1 556 : Ligne 1 727 :
 
   `mailing_list_type` varchar(255) DEFAULT NULL,
 
   `mailing_list_type` varchar(255) DEFAULT NULL,
 
   `structure_site_url` varchar(255) DEFAULT NULL,
 
   `structure_site_url` varchar(255) DEFAULT NULL,
   `default_timezone` varchar(255) NOT NULL,
+
   `default_timezone` varchar(255) DEFAULT NULL,
   `lang` varchar(255) NOT NULL,
+
   `lang` varchar(255) DEFAULT NULL,
 
   `admin_num` int(10) unsigned NOT NULL,
 
   `admin_num` int(10) unsigned NOT NULL,
 
   `default_view_type` int(10) unsigned DEFAULT NULL,
 
   `default_view_type` int(10) unsigned DEFAULT NULL,
Ligne 1 571 : Ligne 1 742 :
 
   `welcome_cell` text,
 
   `welcome_cell` text,
 
   `business` text,
 
   `business` text,
 +
  `default_activity_notification` bigint(20) unsigned DEFAULT NULL,
 +
  `siren` int(10) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='DESCRIPTION OF ALL STRUCTURES';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='DESCRIPTION OF ALL AIRCLUBS';
  
 
--
 
--
Ligne 1 585 : Ligne 1 758 :
 
   `ordinal` int(10) unsigned NOT NULL,
 
   `ordinal` int(10) unsigned NOT NULL,
 
   `validated` tinyint(1) DEFAULT '0',
 
   `validated` tinyint(1) DEFAULT '0',
   `supplier_bill_file_id` int(10) NOT NULL,
+
   `supplier_bill_file_id` int(10) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of supplier bill';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 598 : Ligne 1 771 :
 
   PRIMARY KEY (`supplier_bill_id`,`account_entry_flow_id`),
 
   PRIMARY KEY (`supplier_bill_id`,`account_entry_flow_id`),
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
 
   KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of account entry for each supplier bill';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 
 +
--
 +
-- Table structure for table `supplier_bill_email_parsed`
 +
--
 +
 
 +
CREATE TABLE `supplier_bill_email_parsed` (
 +
  `id` int(10) NOT NULL AUTO_INCREMENT,
 +
  `uid` int(10) DEFAULT NULL,
 +
  `email_address` varchar(255) DEFAULT NULL,
 +
  `supplier_bill_file_id` int(10) DEFAULT NULL,
 +
  PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 608 : Ligne 1 793 :
 
   `file_type` varchar(255) DEFAULT NULL,
 
   `file_type` varchar(255) DEFAULT NULL,
 
   `content` longblob,
 
   `content` longblob,
 +
  `name` varchar(255) NOT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of supplier bill file';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 624 : Ligne 1 810 :
 
   `account_budget_id` int(10) unsigned DEFAULT NULL,
 
   `account_budget_id` int(10) unsigned DEFAULT NULL,
 
   `vat_budget_id` int(10) unsigned DEFAULT NULL,
 
   `vat_budget_id` int(10) unsigned DEFAULT NULL,
 +
  `rule` text,
 +
  `sender_email` varchar(255) DEFAULT NULL,
 +
  `subject` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of supplier bill type';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 647 : Ligne 1 836 :
 
   `tank_type_id` int(10) unsigned NOT NULL,
 
   `tank_type_id` int(10) unsigned NOT NULL,
 
   `unit_id` int(10) unsigned NOT NULL,
 
   `unit_id` int(10) unsigned NOT NULL,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
   `max_quantity` decimal(15,2) NOT NULL DEFAULT '-1.00',
+
   `max_quantity` decimal(15,2) DEFAULT '-1.00',
 
   `unlimited_quantity` int(10) unsigned DEFAULT '1',
 
   `unlimited_quantity` int(10) unsigned DEFAULT '1',
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of tanks';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 667 : Ligne 1 856 :
 
   `additional_information` int(10) unsigned DEFAULT NULL,
 
   `additional_information` int(10) unsigned DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of flight record';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 691 : Ligne 1 880 :
 
   PRIMARY KEY (`id`),
 
   PRIMARY KEY (`id`),
 
   KEY `idx_record_id` (`record_id`)
 
   KEY `idx_record_id` (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of flight record data';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 717 : Ligne 1 906 :
  
 
CREATE TABLE `validity` (
 
CREATE TABLE `validity` (
 +
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `person_id` int(10) unsigned NOT NULL,
 
   `person_id` int(10) unsigned NOT NULL,
 
   `validity_type_id` int(10) unsigned NOT NULL,
 
   `validity_type_id` int(10) unsigned NOT NULL,
 +
  `registration_date` datetime NOT NULL,
 
   `expire_date` date DEFAULT NULL,
 
   `expire_date` date DEFAULT NULL,
   `no_alert` tinyint(1) unsigned NOT NULL DEFAULT '0',
+
   `no_alert` tinyint(1) NOT NULL DEFAULT '0',
 
   `ident_value` varchar(255) DEFAULT NULL,
 
   `ident_value` varchar(255) DEFAULT NULL,
 
   `grant_date` date DEFAULT NULL,
 
   `grant_date` date DEFAULT NULL,
   PRIMARY KEY (`person_id`,`validity_type_id`)
+
  `checker_person_id` int(10) unsigned NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS OF EACH MEMBER';
+
  `checking_date` date NOT NULL,
 +
  `checking_sentence` varchar(255) NOT NULL,
 +
  `is_current_validity` tinyint(1) NOT NULL DEFAULT '0',
 +
   PRIMARY KEY (`id`),
 +
  UNIQUE KEY `validity_person_id_validity_type_id_registration_date_uindex` (`person_id`,`validity_type_id`,`registration_date`),
 +
  KEY `validity_validity_type_id_fk` (`validity_type_id`),
 +
  CONSTRAINT `validity_person_id_fk` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
 +
  CONSTRAINT `validity_validity_type_id_fk` FOREIGN KEY (`validity_type_id`) REFERENCES `validity_type` (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 
 +
--
 +
-- Table structure for table `validity_2_validity_page`
 +
--
 +
 
 +
CREATE TABLE `validity_2_validity_page` (
 +
  `validity_id` int(10) unsigned NOT NULL,
 +
  `validity_page_id` int(10) unsigned NOT NULL,
 +
  PRIMARY KEY (`validity_id`,`validity_page_id`),
 +
  KEY `validity_2_validity_page_validity_page_id_fk` (`validity_page_id`),
 +
  CONSTRAINT `validity_2_validity_page_validity_id_fk` FOREIGN KEY (`validity_id`) REFERENCES `validity` (`id`),
 +
  CONSTRAINT `validity_2_validity_page_validity_page_id_fk` FOREIGN KEY (`validity_page_id`) REFERENCES `validity_page` (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 +
 
 +
--
 +
-- Table structure for table `validity_page`
 +
--
 +
 
 +
CREATE TABLE `validity_page` (
 +
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 +
  `validity_type_page_id` int(10) unsigned NOT NULL,
 +
  `filename` varchar(255) NOT NULL,
 +
  `file` mediumblob NOT NULL,
 +
  `file_extension` varchar(4) NOT NULL,
 +
  PRIMARY KEY (`id`),
 +
  KEY `validity_page_validity_type_page_id_fk` (`validity_type_page_id`),
 +
  CONSTRAINT `validity_page_validity_type_page_id_fk` FOREIGN KEY (`validity_type_page_id`) REFERENCES `validity_type_page` (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 743 : Ligne 1 970 :
 
   `reminder_frequency_alert` int(10) unsigned DEFAULT '0',
 
   `reminder_frequency_alert` int(10) unsigned DEFAULT '0',
 
   `associate_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
   `associate_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mandatory_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
 
   `certification_process` tinyint(1) NOT NULL DEFAULT '0',
 
   `certification_process` tinyint(1) NOT NULL DEFAULT '0',
 
   `is_contract` tinyint(1) NOT NULL DEFAULT '0',
 
   `is_contract` tinyint(1) NOT NULL DEFAULT '0',
Ligne 1 753 : Ligne 1 979 :
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS LIST';
 
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS LIST';
 +
 +
--
 +
-- Table structure for table `validity_type_page`
 +
--
 +
 +
CREATE TABLE `validity_type_page` (
 +
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 +
  `validity_type_id` int(10) unsigned NOT NULL,
 +
  `page_index` int(10) unsigned NOT NULL,
 +
  `label` varchar(40) NOT NULL,
 +
  `is_mandatory` tinyint(1) unsigned NOT NULL,
 +
  PRIMARY KEY (`id`),
 +
  UNIQUE KEY `validity_type_page_validity_type_id_page_index_uindex` (`validity_type_id`,`page_index`),
 +
  CONSTRAINT `validity_type_page_validity_type_id_fk` FOREIGN KEY (`validity_type_id`) REFERENCES `validity_type` (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 759 : Ligne 2 000 :
  
 
CREATE TABLE `variable` (
 
CREATE TABLE `variable` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `variable` varchar(255) NOT NULL,
+
   `variable` varchar(255) DEFAULT NULL,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
   `category` tinyint(1) DEFAULT NULL,
+
   `category` tinyint(1) unsigned NOT NULL,
 
   `value_type` varchar(255) DEFAULT NULL,
 
   `value_type` varchar(255) DEFAULT NULL,
   `order_num` int(11) NOT NULL,
+
   `order_num` int(11) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='pricing_variable';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 775 : Ligne 2 016 :
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `variable_id` int(11) NOT NULL,
 
   `variable_id` int(11) NOT NULL,
   `assign_value` decimal(15,2) NOT NULL,
+
   `assign_value` decimal(15,2) DEFAULT '0.00',
 
   `start_date` datetime NOT NULL,
 
   `start_date` datetime NOT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='pricing_value';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 791 : Ligne 2 032 :
 
   `content` text,
 
   `content` text,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of web feed';
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 
--
 
--
Ligne 1 799 : Ligne 2 040 :
 
CREATE TABLE `web_feed_channel` (
 
CREATE TABLE `web_feed_channel` (
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `label` varchar(255) NOT NULL,
+
   `label` varchar(255) DEFAULT NULL,
 
   PRIMARY KEY (`id`)
 
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of web feed channel';</sql>
+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;</sql>
  
 
=Description=
 
=Description=

Version du 11 juin 2020 à 13:41

Structure

--
-- Table structure for table `account`
--
 
CREATE TABLE `account` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `creation_date` date DEFAULT NULL,
  `name` text,
  `export_account` varchar(255) DEFAULT NULL,
  `activated` tinyint(1) NOT NULL DEFAULT '1',
  `category` tinyint(1) unsigned DEFAULT '0',
  `account_type` tinyint(1) unsigned DEFAULT '0',
  `owner_id` int(10) unsigned NOT NULL DEFAULT '0',
  `payment_allowed` tinyint(1) DEFAULT '0',
  `budget_id` int(10) unsigned DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  `accounting_id` int(10) unsigned DEFAULT NULL,
  `deactivated_date` datetime DEFAULT NULL,
  `group_sales` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_owner_id` (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of account';
 
--
-- Table structure for table `account_entry`
--
 
CREATE TABLE `account_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `flow_id` int(11) DEFAULT NULL,
  `account_date` datetime DEFAULT NULL,
  `registration_date` datetime DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `credit` decimal(15,5) DEFAULT '0.00000',
  `debit` decimal(15,5) DEFAULT '0.00000',
  `payment_type` int(10) unsigned DEFAULT NULL,
  `payment_description` text,
  `person_delivery_id` int(10) unsigned DEFAULT NULL,
  `comments` text,
  `validated` int(1) DEFAULT '0',
  `exported` int(1) DEFAULT '0',
  `budget_id` int(10) unsigned DEFAULT NULL,
  `product_id` int(10) unsigned DEFAULT NULL,
  `signature` varchar(56) DEFAULT NULL,
  `signature_date` bigint(13) unsigned DEFAULT NULL,
  `lettering` int(11) DEFAULT NULL,
  `lettering_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_account_date` (`account_date`),
  KEY `idx_flow_id` (`flow_id`),
  KEY `idx_signature_date` (`signature_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of account entries';
 
--
-- Table structure for table `account_link`
--
 
CREATE TABLE `account_link` (
  `account_id` int(10) unsigned NOT NULL DEFAULT '0',
  `linked_account_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`,`linked_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `account_type`
--
 
CREATE TABLE `account_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `category` tinyint(1) unsigned DEFAULT '0',
  `activated` tinyint(1) unsigned DEFAULT '1',
  `order_num` int(11) DEFAULT NULL,
  `accounting_id` int(10) unsigned DEFAULT NULL,
  `export_account_pattern` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `account_type_profile`
--
 
CREATE TABLE `account_type_profile` (
  `account_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_type_id`,`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Linked account type\r\nfield and profile';
 
--
-- Table structure for table `accounting`
--
 
CREATE TABLE `accounting` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `unit_name` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `format` tinyint(1) unsigned DEFAULT NULL,
  `decimal_precision` int(10) unsigned DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `accounting_profile`
--
 
CREATE TABLE `accounting_profile` (
  `accounting_id` int(10) unsigned NOT NULL DEFAULT '0',
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`accounting_id`,`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `activity_training`
--
 
CREATE TABLE `activity_training` (
  `activity_id` int(10) unsigned NOT NULL DEFAULT '0',
  `theme_id` int(10) unsigned NOT NULL DEFAULT '0',
  `student_id` int(10) DEFAULT NULL,
  `level_reached` int(10) unsigned DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `validated` tinyint(1) NOT NULL DEFAULT '0',
  `checker_person_id` int(10) DEFAULT NULL,
  `checking_date` datetime DEFAULT NULL,
  `checking_sentence` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`activity_id`,`theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `activity_type`
--
 
CREATE TABLE `activity_type` (
  `id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  `activated` tinyint(1) NOT NULL DEFAULT '1',
  `color` int(10) unsigned DEFAULT NULL,
  `training` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of flight type';
 
--
-- Table structure for table `aircraft`
--
 
CREATE TABLE `aircraft` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `ref_date` datetime DEFAULT NULL,
  `ref_hours` int(11) DEFAULT NULL,
  `inspection_date` datetime DEFAULT NULL,
  `inspection_time` int(11) DEFAULT NULL,
  `tolerance_time` int(11) unsigned DEFAULT '6000',
  `last_counter` int(11) DEFAULT NULL,
  `interval_visit` int(11) unsigned DEFAULT '30000',
  `time_alert1` int(11) DEFAULT '6000',
  `time_alert2` int(11) DEFAULT '0',
  `time_alert3` int(11) DEFAULT '0',
  `day_alert1` smallint(3) DEFAULT '15',
  `day_alert2` smallint(3) DEFAULT '0',
  `day_alert3` smallint(3) DEFAULT '8',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='ALL AIRCRAFTS OF ALL AIRCLUBS';
 
--
-- Table structure for table `aircraft_type`
--
 
CREATE TABLE `aircraft_type` (
  `id` int(10) unsigned NOT NULL,
  `flight_time_formula` varchar(255) DEFAULT NULL,
  `counter_state` tinyint(2) NOT NULL DEFAULT '-1',
  `tolerance` int(11) DEFAULT '0',
  `autonomy` int(11) DEFAULT '5990',
  `digit_counter_number` tinyint(1) unsigned NOT NULL DEFAULT '4',
  `true_air_speed` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Types of aircraft';
 
--
-- Table structure for table `aircraft_type_allowed_status`
--
 
CREATE TABLE `aircraft_type_allowed_status` (
  `aircraft_type_id` int(10) unsigned DEFAULT NULL,
  `place_num` int(10) unsigned DEFAULT NULL,
  `status_id` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of allowed functions for each aircraft type';
 
--
-- Table structure for table `aircraft_type_mandatory_flight_type`
--
 
CREATE TABLE `aircraft_type_mandatory_flight_type` (
  `aircraft_type_id` int(10) unsigned DEFAULT NULL,
  `activity_type_id` bigint(20) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of compulsory flight type for each aircraft type';
 
--
-- Table structure for table `aircraft_type_uncomp_flight_type`
--
 
CREATE TABLE `aircraft_type_uncomp_flight_type` (
  `aircraft_type_id` int(10) unsigned DEFAULT NULL,
  `activity_type_id` bigint(20) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of uncompatible flight type for each aircraft type';
 
--
-- Table structure for table `aircraft_type_validity_type`
--
 
CREATE TABLE `aircraft_type_validity_type` (
  `aircraft_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  `validity_type_id` int(10) unsigned NOT NULL,
  `check_num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aircraft_type_id`,`validity_type_id`,`check_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Types of qualif required for each aircraft type';
 
--
-- Table structure for table `allocation_rule`
--
 
CREATE TABLE `allocation_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `account_id` int(10) NOT NULL,
  `keyword` varchar(255) DEFAULT NULL,
  `order_num` int(10) NOT NULL,
  `amount` tinyint(1) NOT NULL,
  `mandatory` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `balance`
--
 
CREATE TABLE `balance` (
  `account_id` int(10) unsigned NOT NULL,
  `balance_date_id` int(10) unsigned NOT NULL DEFAULT '0',
  `debit` decimal(15,5) DEFAULT '0.00000',
  `credit` decimal(15,5) DEFAULT '0.00000',
  PRIMARY KEY (`account_id`,`balance_date_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `balance_date`
--
 
CREATE TABLE `balance_date` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `balance_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `booking`
--
 
CREATE TABLE `booking` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `booking_group_id` int(10) unsigned DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='RECORDS ALL THE SLOTS OF ALL AIRCRAFTS OF ALL AIRCLUBS';
 
--
-- Table structure for table `booking_account_entry`
--
 
CREATE TABLE `booking_account_entry` (
  `booking_id` int(10) unsigned NOT NULL DEFAULT '0',
  `account_entry_flow_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`booking_id`,`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `booking_activity_type`
--
 
CREATE TABLE `booking_activity_type` (
  `booking_id` int(10) unsigned NOT NULL DEFAULT '0',
  `activity_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`booking_id`,`activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `booking_changelog`
--
 
CREATE TABLE `booking_changelog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` int(10) unsigned NOT NULL,
  `person_id` int(10) unsigned NOT NULL,
  `changelog_date` datetime NOT NULL,
  `booking_state` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `booking_person`
--
 
CREATE TABLE `booking_person` (
  `booking_id` int(10) unsigned NOT NULL DEFAULT '0',
  `person_id` int(10) unsigned NOT NULL DEFAULT '0',
  `place_num` int(10) unsigned DEFAULT NULL,
  `status_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`booking_id`,`person_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `booking_resource`
--
 
CREATE TABLE `booking_resource` (
  `booking_id` int(10) unsigned NOT NULL DEFAULT '0',
  `resource_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`booking_id`,`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `budget`
--
 
CREATE TABLE `budget` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `order_num` int(11) NOT NULL,
  `export_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `budget_group`
--
 
CREATE TABLE `budget_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `order_num` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `business_field`
--
 
CREATE TABLE `business_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `variable` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `value_type` varchar(40) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  `dsn` varchar(20) DEFAULT NULL,
  `compulsory_fill` tinyint(1) DEFAULT '0',
  `linked_category` varchar(255) DEFAULT NULL,
  `linked_business_field_id` int(10) unsigned DEFAULT NULL,
  `linked_field_name` varchar(255) DEFAULT NULL,
  `max_display` int(10) DEFAULT '-1',
  `formula` text,
  `default_value` text,
  `placeholder` text,
  `access_level_required` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `variable` (`variable`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of extra form field';
 
--
-- Table structure for table `business_field_activity_type`
--
 
CREATE TABLE `business_field_activity_type` (
  `business_field_id` int(10) unsigned NOT NULL DEFAULT '0',
  `activity_type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `business_field_group_id` int(10) unsigned NOT NULL DEFAULT '0',
  `visibility_type` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`business_field_id`,`activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `business_field_content`
--
 
CREATE TABLE `business_field_content` (
  `category_id` int(10) unsigned NOT NULL,
  `business_field_id` int(10) unsigned NOT NULL DEFAULT '0',
  `person_id` int(10) unsigned NOT NULL DEFAULT '0',
  `content` text,
  `placeholder` text,
  PRIMARY KEY (`category_id`,`business_field_id`,`person_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Content of extra form field';
 
--
-- Table structure for table `business_field_group`
--
 
CREATE TABLE `business_field_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `criteria`
--
 
CREATE TABLE `criteria` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `predicate` text,
  `order_num` int(11) DEFAULT NULL,
  `dsn` varchar(20) NOT NULL DEFAULT 'customer',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `criteria_profile`
--
 
CREATE TABLE `criteria_profile` (
  `criteria_id` int(10) unsigned NOT NULL,
  `profile_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`criteria_id`,`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `customer_bill_entry`
--
 
CREATE TABLE `customer_bill_entry` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `flow_id` int(10) unsigned DEFAULT NULL,
  `account_entry_id` int(10) unsigned DEFAULT NULL,
  `account_entry_flow_id` int(10) unsigned DEFAULT NULL,
  `owner_category` int(10) unsigned DEFAULT NULL,
  `owner_id` int(10) unsigned DEFAULT NULL,
  `customer_bill_id` int(10) unsigned DEFAULT NULL,
  `product_id` int(10) unsigned DEFAULT NULL,
  `qty` decimal(15,2) DEFAULT '0.00',
  `unit_price` decimal(15,5) DEFAULT '0.00000',
  `debit` decimal(15,5) DEFAULT '0.00000',
  `credit` decimal(15,5) DEFAULT '0.00000',
  `bill_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_account_entry_id` (`account_entry_id`),
  KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `customer_bill_file`
--
 
CREATE TABLE `customer_bill_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file_type` varchar(255) DEFAULT NULL,
  `content` longblob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `customer_receipt_entry`
--
 
CREATE TABLE `customer_receipt_entry` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `flow_id` int(10) unsigned DEFAULT NULL,
  `account_entry_id` int(10) unsigned DEFAULT NULL,
  `account_entry_flow_id` int(10) unsigned DEFAULT NULL,
  `owner_category` int(10) unsigned DEFAULT NULL,
  `owner_id` int(10) unsigned DEFAULT NULL,
  `payment_type_id` int(10) unsigned DEFAULT NULL,
  `customer_receipt_id` int(10) unsigned DEFAULT NULL,
  `debit` decimal(15,5) DEFAULT '0.00000',
  `credit` decimal(15,5) DEFAULT '0.00000',
  `receipt_date` datetime DEFAULT NULL,
  `owner_email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_account_entry_id` (`account_entry_id`),
  KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `customer_receipt_file`
--
 
CREATE TABLE `customer_receipt_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file_type` varchar(255) DEFAULT NULL,
  `content` longblob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `default_display`
--
 
CREATE TABLE `default_display` (
  `person_id` int(10) unsigned NOT NULL DEFAULT '0',
  `display_key` varchar(255) NOT NULL DEFAULT '',
  `display_value` text,
  PRIMARY KEY (`person_id`,`display_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `default_multi_display`
--
 
CREATE TABLE `default_multi_display` (
  `resource_type` char(30) NOT NULL,
  `person_id` int(10) unsigned NOT NULL DEFAULT '0',
  `resource_id` varchar(100) NOT NULL,
  `display_value` text,
  PRIMARY KEY (`resource_type`,`person_id`,`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `email_sent`
--
 
CREATE TABLE `email_sent` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message_id` varchar(150) NOT NULL,
  `sender` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category` tinyint(3) unsigned NOT NULL,
  `category_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `message_id_UNIQUE` (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `email_sent_recipient`
--
 
CREATE TABLE `email_sent_recipient` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email_sent_id` bigint(20) unsigned NOT NULL,
  `person_id` int(10) unsigned NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `recipient_type` tinyint(3) unsigned DEFAULT NULL,
  `smtp_status_category` varchar(30) DEFAULT NULL,
  `email_status` tinyint(3) unsigned DEFAULT NULL,
  `update_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `email_sent_id_idx` (`email_sent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `exceptionnal_inst_date`
--
 
CREATE TABLE `exceptionnal_inst_date` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `presence` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `extra_field_profile`
--
 
CREATE TABLE `extra_field_profile` (
  `business_field_id` int(10) unsigned NOT NULL DEFAULT '0',
  `booking_popup_display_4_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`business_field_id`,`booking_popup_display_4_profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `facebook`
--
 
CREATE TABLE `facebook` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category` int(10) unsigned NOT NULL,
  `owner_id` int(10) unsigned NOT NULL,
  `small` blob,
  `original` mediumblob NOT NULL,
  `label` text,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `favorite_icao`
--
 
CREATE TABLE `favorite_icao` (
  `icao` varchar(6) NOT NULL DEFAULT '',
  PRIMARY KEY (`icao`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='favorite airfield list';
 
--
-- Table structure for table `favorite_report`
--
 
CREATE TABLE `favorite_report` (
  `report_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `favorite_report_business_field`
--
 
CREATE TABLE `favorite_report_business_field` (
  `report_id` int(10) unsigned NOT NULL,
  `business_field_id` int(10) unsigned NOT NULL,
  `default_value` text,
  PRIMARY KEY (`report_id`,`business_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `favorite_report_profile`
--
 
CREATE TABLE `favorite_report_profile` (
  `report_id` int(10) unsigned NOT NULL,
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`report_id`,`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `fhp_aircraft_type`
--
 
CREATE TABLE `fhp_aircraft_type` (
  `fhp_id` int(10) NOT NULL DEFAULT '0',
  `aircraft_type_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fhp_id`,`aircraft_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='flight hour pricing aircraft type list';
 
--
-- Table structure for table `fhp_flight_type`
--
 
CREATE TABLE `fhp_flight_type` (
  `fhp_id` int(10) NOT NULL DEFAULT '0',
  `activity_type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `excluded` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`fhp_id`,`activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='flight hour pricing flight type list';
 
--
-- Table structure for table `fhp_profile`
--
 
CREATE TABLE `fhp_profile` (
  `fhp_id` int(10) unsigned NOT NULL,
  `profile_id` bigint(20) unsigned NOT NULL,
  `place_num` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fhp_id`,`profile_id`,`place_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `file`
--
 
CREATE TABLE `file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `content` longblob,
  `file_type` varchar(255) DEFAULT NULL,
  `category` tinyint(1) unsigned DEFAULT NULL,
  `owner_id` int(10) DEFAULT NULL,
  `file_group_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `file_group`
--
 
CREATE TABLE `file_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `flight`
--
 
CREATE TABLE `flight` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aircraft_id` int(10) unsigned DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `activity_type_id` bigint(20) unsigned DEFAULT NULL,
  `people_onboard` int(10) unsigned DEFAULT NULL,
  `departure_location_id` int(10) unsigned DEFAULT NULL,
  `arrival_location_id` int(10) unsigned DEFAULT NULL,
  `counter_departure` int(10) unsigned DEFAULT NULL,
  `counter_arrival` int(10) unsigned DEFAULT NULL,
  `landing_number` int(10) DEFAULT NULL,
  `airborne` tinyint(1) unsigned DEFAULT NULL,
  `validated` tinyint(3) unsigned DEFAULT '0',
  `departure_icao_id` varchar(6) DEFAULT NULL,
  `arrival_icao_id` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of flight';
 
--
-- Table structure for table `flight_account_entry`
--
 
CREATE TABLE `flight_account_entry` (
  `flight_id` int(10) unsigned NOT NULL DEFAULT '0',
  `account_entry_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`flight_id`,`account_entry_id`),
  KEY `idx_account_entry_id` (`account_entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='flight account entry join';
 
--
-- Table structure for table `flight_hours_pricing`
--
 
CREATE TABLE `flight_hours_pricing` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text,
  `price_formula` text,
  `left_account_id` int(10) unsigned DEFAULT NULL,
  `right_account_id` int(10) unsigned DEFAULT NULL,
  `left_account_type` tinyint(1) unsigned DEFAULT '0',
  `right_account_type` tinyint(1) unsigned DEFAULT '0',
  `credit_budget_id` int(10) unsigned DEFAULT NULL,
  `debit_budget_id` int(10) unsigned DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  `product_id` int(10) unsigned DEFAULT NULL,
  `sale_trigger_id` int(10) unsigned DEFAULT NULL,
  `query` text,
  `variable_formula` varchar(255) DEFAULT NULL,
  `business_field_id` int(10) unsigned DEFAULT NULL,
  `debit_bill_num` int(10) unsigned DEFAULT NULL,
  `credit_bill_num` int(10) unsigned DEFAULT NULL,
  `qty_formula` text,
  `unit_price_formula` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of flight hours pricing formula';
 
--
-- Table structure for table `flight_pilot`
--
 
CREATE TABLE `flight_pilot` (
  `flight_id` int(10) unsigned NOT NULL,
  `pilot_id` int(10) unsigned NOT NULL,
  `status_id` int(10) DEFAULT NULL,
  `num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`flight_id`,`pilot_id`,`num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of crew for each flight';
 
--
-- Table structure for table `flight_tank_qty`
--
 
CREATE TABLE `flight_tank_qty` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `flight_id` int(10) unsigned NOT NULL,
  `tank_id` int(10) unsigned NOT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `after_flight` tinyint(1) NOT NULL DEFAULT '0',
  `account_id` int(10) unsigned DEFAULT NULL,
  `pay_type` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `flight_track`
--
 
CREATE TABLE `flight_track` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `flight_id` int(10) NOT NULL,
  `track` mediumblob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `flight_type_mandatory_validity_type`
--
 
CREATE TABLE `flight_type_mandatory_validity_type` (
  `activity_type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `validity_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`activity_type_id`,`validity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of mandatory qualification for each flight type';
 
--
-- Table structure for table `import`
--
 
CREATE TABLE `import` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL,
  `order_num` int(11) DEFAULT NULL,
  `import_file_type` varchar(255) NOT NULL DEFAULT 'csv-comma-CRLF',
  `match_query` text,
  `uptodate_test_query` text,
  `update_query` text,
  `update_activated` tinyint(1) NOT NULL DEFAULT '0',
  `login` varchar(255) DEFAULT NULL,
  `hash_password` varchar(255) DEFAULT NULL,
  `sync_task_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `ip_stopped`
--
 
CREATE TABLE `ip_stopped` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) DEFAULT NULL,
  `counter` tinyint(1) unsigned NOT NULL,
  `expire_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='BLACKLISTED IP';
 
--
-- Table structure for table `journal`
--
 
CREATE TABLE `journal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(255) DEFAULT NULL,
  `date_log` datetime DEFAULT NULL,
  `rights` text,
  `rights2` text,
  `action` varchar(255) DEFAULT NULL,
  `person_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_date_log` (`date_log`),
  KEY `idx_action` (`action`(8))
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of logs';
 
--
-- Table structure for table `key_alert`
--
 
CREATE TABLE `key_alert` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `alert_date` datetime DEFAULT NULL,
  `status` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Key alerts';
 
--
-- Table structure for table `key_assignment`
--
 
CREATE TABLE `key_assignment` (
  `key_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `key_name` tinytext,
  `aircraft_id` int(10) unsigned DEFAULT '0',
  `key_state` tinyint(1) unsigned DEFAULT '0',
  `key_word` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`key_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='key assignment description';
 
--
-- Table structure for table `key_host`
--
 
CREATE TABLE `key_host` (
  `id` tinyint(2) NOT NULL AUTO_INCREMENT,
  `timeout` tinyint(2) unsigned NOT NULL DEFAULT '10',
  `num_key` tinyint(2) unsigned NOT NULL DEFAULT '8',
  `ipkey` varchar(50) DEFAULT NULL,
  `httpport` int(11) DEFAULT '4080',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='key host configuration';
 
--
-- Table structure for table `key_log`
--
 
CREATE TABLE `key_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `log_date` datetime DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `key_id` int(10) unsigned DEFAULT NULL,
  `person_id` int(10) unsigned DEFAULT NULL,
  `xmlrpc` int(10) unsigned NOT NULL,
  `error` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Key logs';
 
--
-- Table structure for table `location`
--
 
CREATE TABLE `location` (
  `icao_name` varchar(6) NOT NULL,
  `name` varchar(64) NOT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `altitude` int(7) DEFAULT NULL,
  `weather_station` int(1) unsigned DEFAULT NULL,
  `asked_counter` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`icao_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='airfields coord';
 
--
-- Table structure for table `log`
--
 
CREATE TABLE `log` (
  `journal_id` int(10) unsigned NOT NULL,
  `action` varchar(255) DEFAULT NULL,
  `table_name` varchar(255) DEFAULT NULL,
  `field_name` varchar(255) DEFAULT NULL,
  `field_value` varchar(255) DEFAULT NULL,
  KEY `idx_journal_id` (`journal_id`),
  KEY `idx_field_value` (`field_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='part of logs';
 
--
-- Table structure for table `logger`
--
 
CREATE TABLE `logger` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serial_number` int(10) unsigned DEFAULT NULL,
  `color` varchar(20) NOT NULL DEFAULT 'red',
  `activated` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `order_num` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Logger parameters';
 
--
-- Table structure for table `login_stopped`
--
 
CREATE TABLE `login_stopped` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(255) DEFAULT NULL,
  `counter` tinyint(3) unsigned NOT NULL,
  `expire_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='BLACKLISTED LOGIN';
 
--
-- Table structure for table `m_component`
--
 
CREATE TABLE `m_component` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `m_component_type_id` int(10) unsigned DEFAULT NULL,
  `resource_id` int(10) unsigned DEFAULT NULL,
  `order_num` int(11) NOT NULL,
  `serial_number` varchar(255) DEFAULT NULL,
  `brandnew_date` datetime DEFAULT NULL,
  `activated` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `m_component_type`
--
 
CREATE TABLE `m_component_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `resource_type_id` int(11) DEFAULT NULL,
  `m_classification_id` int(11) DEFAULT NULL,
  `is_maintenance_check` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `order_num` int(11) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `manufacturer_reference` varchar(255) DEFAULT NULL,
  `part_number` varchar(255) DEFAULT NULL,
  `periodicity` int(10) unsigned DEFAULT NULL,
  `tolerance` int(10) unsigned NOT NULL DEFAULT '0',
  `calendar_periodicity` int(10) unsigned DEFAULT NULL,
  `calendar_tolerance` int(10) unsigned NOT NULL DEFAULT '0',
  `activated` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `m_component_type_parentality`
--
 
CREATE TABLE `m_component_type_parentality` (
  `m_component_type_id` int(10) unsigned NOT NULL,
  `m_component_type_parent_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`m_component_type_id`,`m_component_type_parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `m_history`
--
 
CREATE TABLE `m_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `m_component_id` int(10) unsigned NOT NULL,
  `install_date` datetime DEFAULT NULL,
  `remove_date` datetime DEFAULT NULL,
  `total_hours_on_install` int(10) unsigned NOT NULL DEFAULT '0',
  `threshold_hours` int(10) unsigned NOT NULL DEFAULT '0',
  `threshold_date` datetime DEFAULT NULL,
  `threshold_date_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `threshold_hours_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `m_operation`
--
 
CREATE TABLE `m_operation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` text,
  `m_component_type_id` int(10) unsigned NOT NULL,
  `order_num` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `maintenance_history`
--
 
CREATE TABLE `maintenance_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resource_id` int(10) unsigned DEFAULT NULL,
  `maintenance_program_id` int(10) unsigned DEFAULT NULL,
  `frame_hours_at_work_start` int(10) DEFAULT NULL,
  `date_work_end` date DEFAULT NULL,
  `min_overhaul_counter` int(10) DEFAULT NULL,
  `max_overhaul_counter` int(10) DEFAULT NULL,
  `min_overhaul_date` date DEFAULT NULL,
  `max_overhaul_date` date DEFAULT NULL,
  `min_next_overhaul_counter` int(10) DEFAULT NULL,
  `max_next_overhaul_counter` int(10) DEFAULT NULL,
  `min_next_overhaul_date` date DEFAULT NULL,
  `max_next_overhaul_date` date DEFAULT NULL,
  `first_reference_visit` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_visit` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `action_type` tinyint(1) unsigned DEFAULT NULL,
  `previous_line_linked_time_action` int(10) DEFAULT NULL,
  `previous_line_linked_calendar_action` int(10) DEFAULT NULL,
  `next_line_linked_time_action` int(10) DEFAULT NULL,
  `next_line_linked_calendar_action` int(10) DEFAULT NULL,
  `time_tolerance` int(10) DEFAULT NULL,
  `calendar_tolerance` int(10) DEFAULT NULL,
  `time_periodicity_component` int(10) DEFAULT NULL,
  `calendar_periodicity_component` int(10) DEFAULT NULL,
  `time_periodicity` int(10) DEFAULT NULL,
  `calendar_periodicity` int(10) DEFAULT NULL,
  `reference_overhaul_counter` int(10) DEFAULT NULL,
  `reference_overhaul_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `maintenance_program`
--
 
CREATE TABLE `maintenance_program` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resource_id` int(10) unsigned DEFAULT NULL,
  `component_type_id` int(10) unsigned DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `time_periodicity` int(10) DEFAULT NULL,
  `calendar_periodicity` int(10) DEFAULT NULL,
  `time_first_reference` int(10) DEFAULT NULL,
  `calendar_first_reference` date DEFAULT NULL,
  `time_tolerance` int(10) DEFAULT NULL,
  `calendar_tolerance` int(10) DEFAULT NULL,
  `frame_hours_at_work_start` int(10) DEFAULT NULL,
  `date_work_end` date DEFAULT NULL,
  `time_elapsed` int(10) DEFAULT NULL,
  `calendar_elapsed` int(10) DEFAULT NULL,
  `time_remaining` int(10) DEFAULT NULL,
  `calendar_remaining` int(10) DEFAULT NULL,
  `min_next_overhaul_counter` int(10) DEFAULT NULL,
  `max_next_overhaul_counter` int(10) DEFAULT NULL,
  `min_next_overhaul_date` date DEFAULT NULL,
  `max_next_overhaul_date` date DEFAULT NULL,
  `effective_hours_at_work_start` int(10) DEFAULT NULL,
  `theoretical_overhaul_counter` int(10) DEFAULT NULL,
  `intelligent_overhaul_counter` int(10) DEFAULT NULL,
  `intelligent_min_next_overhaul_counter` int(10) DEFAULT NULL,
  `intelligent_max_next_overhaul_counter` int(10) DEFAULT NULL,
  `effective_date_at_work_end` date DEFAULT NULL,
  `theoretical_overhaul_date` date DEFAULT NULL,
  `intelligent_overhaul_date` date DEFAULT NULL,
  `intelligent_min_next_overhaul_date` date DEFAULT NULL,
  `intelligent_max_next_overhaul_date` date DEFAULT NULL,
  `overlapping_group_id` int(10) unsigned DEFAULT NULL,
  `is_visit_rg` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `maintenance_view`
--
 
CREATE TABLE `maintenance_view` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `frame_total_time` int(10) DEFAULT NULL,
  `frame_time_since_rg` int(10) DEFAULT NULL,
  `engine_time_since_rg` int(10) DEFAULT NULL,
  `propeller_time_since_rg` int(10) DEFAULT NULL,
  `potential_remaining_next_time_action` int(10) DEFAULT NULL,
  `potential_remaining_next_time_visit` int(10) DEFAULT NULL,
  `potential_remaining_next_priority_time_action` int(10) DEFAULT NULL,
  `potential_remaining_next_calendar_action` int(10) DEFAULT NULL,
  `potential_remaining_next_calendar_visit` int(10) DEFAULT NULL,
  `potential_remaining_next_priority_calendar_action` int(10) DEFAULT NULL,
  `next_time_action_id` int(10) unsigned DEFAULT NULL,
  `next_time_visit_id` int(10) unsigned DEFAULT NULL,
  `next_priority_time_action_id` int(10) unsigned DEFAULT NULL,
  `next_calendar_action_id` int(10) unsigned DEFAULT NULL,
  `next_calendar_visit_id` int(10) unsigned DEFAULT NULL,
  `next_priority_calendar_action_id` int(10) unsigned DEFAULT NULL,
  `overhaul_counter_action` int(10) DEFAULT NULL,
  `overhaul_counter_visit` int(10) DEFAULT NULL,
  `overhaul_date_action` date DEFAULT NULL,
  `overhaul_date_visit` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `map_logger_monitoring`
--
 
CREATE TABLE `map_logger_monitoring` (
  `record_id` int(10) unsigned NOT NULL,
  `count_data` int(10) unsigned NOT NULL,
  PRIMARY KEY (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='link between flight and track';
 
--
-- Table structure for table `map_track`
--
 
CREATE TABLE `map_track` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `record_id` int(10) unsigned DEFAULT NULL,
  `start_data` int(10) unsigned DEFAULT NULL,
  `number` int(10) unsigned DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `latitude_max` double DEFAULT NULL,
  `longitude_max` double DEFAULT NULL,
  `latitude_min` double DEFAULT NULL,
  `longitude_min` double DEFAULT NULL,
  `visible` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Tracks split from GDR';
 
--
-- Table structure for table `nationality`
--
 
CREATE TABLE `nationality` (
  `code` char(2) NOT NULL DEFAULT '',
  `label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `parameter`
--
 
CREATE TABLE `parameter` (
  `code` varchar(255) NOT NULL DEFAULT '',
  `key_id` int(10) unsigned NOT NULL DEFAULT '0',
  `enabled` tinyint(1) unsigned DEFAULT '0',
  `int_value` int(10) unsigned DEFAULT '0',
  `char_value` text,
  PRIMARY KEY (`code`,`key_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='APPLICATION PARAMETERS';
 
--
-- Table structure for table `payment_distribution`
--
 
CREATE TABLE `payment_distribution` (
  `payment_id` int(10) unsigned NOT NULL DEFAULT '0',
  `account_club_id` int(10) unsigned DEFAULT NULL,
  `person_delivery` tinyint(1) unsigned DEFAULT '0',
  `member_budget_id` int(10) unsigned DEFAULT NULL,
  `treasury_budget_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='payment distribution description';
 
--
-- Table structure for table `payment_summary_file`
--
 
CREATE TABLE `payment_summary_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file_type` varchar(255) DEFAULT NULL,
  `content` longblob,
  `record_date` datetime DEFAULT NULL,
  `total_entry` int(10) unsigned DEFAULT NULL,
  `total_amount` decimal(15,5) unsigned DEFAULT NULL,
  `payment_type_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `payment_type`
--
 
CREATE TABLE `payment_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text,
  `text_field_label` text,
  `only_admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `order_num` int(11) DEFAULT NULL,
  `pos_key_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='type of payment description';
 
--
-- Table structure for table `person`
--
 
CREATE TABLE `person` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `hash_password` varchar(255) NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `profile` bigint(20) unsigned DEFAULT NULL,
  `view_type` int(10) unsigned DEFAULT NULL,
  `view_width` tinyint(3) unsigned NOT NULL DEFAULT '12',
  `view_height` tinyint(4) unsigned NOT NULL DEFAULT '30',
  `email` varchar(255) DEFAULT NULL,
  `timezone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `home_phone` varchar(255) DEFAULT NULL,
  `work_phone` varchar(255) DEFAULT NULL,
  `cell_phone` varchar(255) DEFAULT NULL,
  `lang` varchar(255) DEFAULT NULL,
  `notification` tinyint(3) unsigned DEFAULT NULL,
  `activated` tinyint(1) unsigned DEFAULT '1',
  `birthdate` datetime DEFAULT '0000-00-00 00:00:00',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `nationality` char(2) DEFAULT NULL,
  `total_flight_time` int(10) unsigned DEFAULT '0',
  `date_total_flight_time` datetime DEFAULT NULL,
  `guid` varchar(255) DEFAULT NULL,
  `activity_notification` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='used for authentication';
 
--
-- Table structure for table `person_awaiting_activation`
--
 
CREATE TABLE `person_awaiting_activation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `used` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `product`
--
 
CREATE TABLE `product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `free_sale` tinyint(1) NOT NULL DEFAULT '0',
  `locked` tinyint(1) unsigned DEFAULT '0',
  `variable_id` int(10) unsigned DEFAULT NULL,
  `sale_type` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile`
--
 
CREATE TABLE `profile` (
  `id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `permits` int(10) unsigned DEFAULT NULL,
  `permits2` int(10) unsigned NOT NULL DEFAULT '0',
  `permits3` int(10) unsigned NOT NULL DEFAULT '0',
  `pictogram` int(10) unsigned DEFAULT NULL,
  `default_status_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_accounting_notification`
--
 
CREATE TABLE `profile_accounting_notification` (
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `accounting_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`profile_id`,`accounting_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_extra_field_join`
--
 
CREATE TABLE `profile_extra_field_join` (
  `profile_id` bigint(20) unsigned NOT NULL,
  `business_field_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`profile_id`,`business_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_profile_view`
--
 
CREATE TABLE `profile_profile_view` (
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `viewable_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`profile_id`,`viewable_profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_required_account_type`
--
 
CREATE TABLE `profile_required_account_type` (
  `profile_id` bigint(20) unsigned NOT NULL,
  `account_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`profile_id`,`account_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_resource_type_place`
--
 
CREATE TABLE `profile_resource_type_place` (
  `profile_id` bigint(20) unsigned NOT NULL,
  `resource_type_id` int(10) unsigned NOT NULL,
  `place_num` int(10) unsigned NOT NULL,
  PRIMARY KEY (`profile_id`,`resource_type_id`,`place_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_resource_type_view`
--
 
CREATE TABLE `profile_resource_type_view` (
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `viewable_resource_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`profile_id`,`viewable_resource_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_validity_type_join`
--
 
CREATE TABLE `profile_validity_type_join` (
  `profile_id` bigint(20) unsigned NOT NULL,
  `validity_type_id` int(10) unsigned NOT NULL,
  `manage4oneself` int(1) NOT NULL DEFAULT '0',
  `certify` int(1) NOT NULL DEFAULT '0',
  `optional_contract` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`profile_id`,`validity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `profile_validity_type_notification`
--
 
CREATE TABLE `profile_validity_type_notification` (
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `validity_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`profile_id`,`validity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `psp_return`
--
 
CREATE TABLE `psp_return` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `psp_transaction_id` int(10) unsigned DEFAULT NULL,
  `bank_answer` text,
  `bank_misc` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `psp_transaction`
--
 
CREATE TABLE `psp_transaction` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `credit_account_id` int(10) unsigned NOT NULL,
  `debit_account_id` int(10) unsigned NOT NULL,
  `transaction_date` datetime NOT NULL,
  `amount` float NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `payment_type_id` int(10) unsigned NOT NULL,
  `state` int(10) unsigned NOT NULL DEFAULT '0',
  `token` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `psp_transaction_account_entry`
--
 
CREATE TABLE `psp_transaction_account_entry` (
  `psp_transaction_id` int(10) unsigned NOT NULL DEFAULT '0',
  `account_entry_flow_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`psp_transaction_id`,`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `regular_presence_inst_date`
--
 
CREATE TABLE `regular_presence_inst_date` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned DEFAULT NULL,
  `start_day` tinyint(3) unsigned DEFAULT NULL,
  `end_day` tinyint(3) unsigned DEFAULT NULL,
  `start_hour` time DEFAULT NULL,
  `end_hour` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `resource`
--
 
CREATE TABLE `resource` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `resource_type_id` int(10) unsigned DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  `activated` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `bookable` int(10) unsigned DEFAULT '1',
  `physical` int(10) unsigned DEFAULT '1',
  `color` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `resource_exceptional_availability`
--
 
CREATE TABLE `resource_exceptional_availability` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resource_id` int(10) unsigned DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `presence` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `resource_regular_availability`
--
 
CREATE TABLE `resource_regular_availability` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resource_id` int(10) unsigned DEFAULT NULL,
  `start_day` tinyint(1) unsigned DEFAULT NULL,
  `end_day` tinyint(1) unsigned DEFAULT NULL,
  `start_hour` time DEFAULT NULL,
  `end_hour` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `resource_type`
--
 
CREATE TABLE `resource_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `category` int(10) unsigned NOT NULL,
  `seats_available` int(11) DEFAULT '-1',
  `comments` varchar(255) DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  `activated` tinyint(1) NOT NULL DEFAULT '1',
  `max_booking_duration` int(10) DEFAULT '-1',
  `pictogram` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `resource_type_place_tag`
--
 
CREATE TABLE `resource_type_place_tag` (
  `resource_type_id` int(10) unsigned NOT NULL,
  `place_num` tinyint(1) unsigned NOT NULL,
  `place_tag` varchar(255) DEFAULT NULL,
  `place_quantity` int(10) DEFAULT '-1',
  PRIMARY KEY (`resource_type_id`,`place_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `sale_2_stock`
--
 
CREATE TABLE `sale_2_stock` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(10) unsigned DEFAULT NULL,
  `stock_id` int(10) unsigned NOT NULL,
  `stock_variation_qty_per_sale` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `sale_2_validity_type`
--
 
CREATE TABLE `sale_2_validity_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `validity_type_id` int(10) unsigned NOT NULL,
  `new_formula` varchar(255) DEFAULT NULL,
  `update_formula` varchar(255) DEFAULT NULL,
  `product_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `validity_type_id` (`validity_type_id`),
  KEY `idx_product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `sale_pricing`
--
 
CREATE TABLE `sale_pricing` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `price_formula` text,
  `debit_account_id` int(10) unsigned NOT NULL,
  `credit_account_id` int(10) unsigned NOT NULL,
  `debit_account_type` int(10) unsigned NOT NULL,
  `credit_account_type` int(10) unsigned NOT NULL,
  `debit_budget_id` int(10) unsigned DEFAULT NULL,
  `credit_budget_id` int(10) unsigned DEFAULT NULL,
  `order_num` int(10) DEFAULT NULL,
  `variable_formula` varchar(255) DEFAULT NULL,
  `debit_bill_num` int(10) unsigned DEFAULT NULL,
  `credit_bill_num` int(10) unsigned DEFAULT NULL,
  `qty_formula` text,
  `unit_price_formula` text,
  `added_product_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `sale_pricing_product`
--
 
CREATE TABLE `sale_pricing_product` (
  `sale_pricing_id` int(10) unsigned NOT NULL DEFAULT '0',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`sale_pricing_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `sale_pricing_profile`
--
 
CREATE TABLE `sale_pricing_profile` (
  `sale_pricing_id` int(10) unsigned NOT NULL,
  `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`sale_pricing_id`,`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `sale_trigger`
--
 
CREATE TABLE `sale_trigger` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `locked` tinyint(1) unsigned DEFAULT '0',
  `query` text,
  `validate_entry` tinyint(1) DEFAULT '0',
  `group_sales` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `spreadsheet_parameter`
--
 
CREATE TABLE `spreadsheet_parameter` (
  `file_number` int(10) NOT NULL,
  `spreadsheet_key` varchar(255) NOT NULL,
  `spreadsheet_value` varchar(255) NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `google_url` varchar(255) NOT NULL,
  `file_type` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`file_number`,`spreadsheet_key`,`spreadsheet_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `statistic`
--
 
CREATE TABLE `statistic` (
  `name` varchar(255) NOT NULL,
  `of_version` tinyint(3) NOT NULL DEFAULT '0',
  `value` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`name`,`of_version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `status`
--
 
CREATE TABLE `status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `abbrev` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `pictogram` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of functions for pilot';
 
--
-- Table structure for table `stock`
--
 
CREATE TABLE `stock` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `stock_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `stock_level`
--
 
CREATE TABLE `stock_level` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stock_id` int(10) unsigned NOT NULL,
  `qty` float NOT NULL DEFAULT '0',
  `stock_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `stock_type`
--
 
CREATE TABLE `stock_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `stock_variation`
--
 
CREATE TABLE `stock_variation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stock_id` int(10) unsigned NOT NULL,
  `qty` float NOT NULL DEFAULT '0',
  `variation_date` datetime DEFAULT NULL,
  `validated` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `stock_variation_account_entry`
--
 
CREATE TABLE `stock_variation_account_entry` (
  `product_id` int(10) unsigned NOT NULL DEFAULT '0',
  `stock_variation_id` int(10) unsigned NOT NULL,
  `account_entry_flow_id` int(10) unsigned NOT NULL,
  `person_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`product_id`,`stock_variation_id`,`account_entry_flow_id`),
  KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `structure`
--
 
CREATE TABLE `structure` (
  `id` int(10) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `info_cell` text,
  `logo` longblob,
  `logo_name` varchar(255) DEFAULT NULL,
  `logo_ext` varchar(25) DEFAULT NULL,
  `logo_size` int(11) DEFAULT NULL,
  `first_hour_displayed` time DEFAULT NULL,
  `last_hour_displayed` time DEFAULT NULL,
  `usual_profiles` bigint(20) unsigned DEFAULT NULL,
  `icao` varchar(6) DEFAULT NULL,
  `default_slot_range` int(10) unsigned DEFAULT NULL,
  `min_slot_range` tinyint(3) unsigned DEFAULT NULL,
  `twilight_range` tinyint(3) unsigned DEFAULT NULL,
  `mailing_list_name` varchar(255) DEFAULT NULL,
  `mailing_list_type` varchar(255) DEFAULT NULL,
  `structure_site_url` varchar(255) DEFAULT NULL,
  `default_timezone` varchar(255) DEFAULT NULL,
  `lang` varchar(255) DEFAULT NULL,
  `admin_num` int(10) unsigned NOT NULL,
  `default_view_type` int(10) unsigned DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `default_notification` int(3) unsigned DEFAULT NULL,
  `welcome_cell` text,
  `business` text,
  `default_activity_notification` bigint(20) unsigned DEFAULT NULL,
  `siren` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='DESCRIPTION OF ALL AIRCLUBS';
 
--
-- Table structure for table `supplier_bill`
--
 
CREATE TABLE `supplier_bill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_bill_type_id` int(10) unsigned NOT NULL,
  `bill_date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `ordinal` int(10) unsigned NOT NULL,
  `validated` tinyint(1) DEFAULT '0',
  `supplier_bill_file_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `supplier_bill_account_entry`
--
 
CREATE TABLE `supplier_bill_account_entry` (
  `supplier_bill_id` int(10) unsigned NOT NULL,
  `account_entry_flow_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`supplier_bill_id`,`account_entry_flow_id`),
  KEY `idx_account_entry_flow_id` (`account_entry_flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `supplier_bill_email_parsed`
--
 
CREATE TABLE `supplier_bill_email_parsed` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `email_address` varchar(255) DEFAULT NULL,
  `supplier_bill_file_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `supplier_bill_file`
--
 
CREATE TABLE `supplier_bill_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file_type` varchar(255) DEFAULT NULL,
  `content` longblob,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `supplier_bill_type`
--
 
CREATE TABLE `supplier_bill_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `vat_account_id` int(10) unsigned DEFAULT NULL,
  `supplier_budget_id` int(10) unsigned DEFAULT NULL,
  `account_budget_id` int(10) unsigned DEFAULT NULL,
  `vat_budget_id` int(10) unsigned DEFAULT NULL,
  `rule` text,
  `sender_email` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `table_trigger`
--
 
CREATE TABLE `table_trigger` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `monitored_table` varchar(255) NOT NULL,
  `trigger_formula` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `tank`
--
 
CREATE TABLE `tank` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aircraft_type_id` int(10) unsigned NOT NULL,
  `tank_type_id` int(10) unsigned NOT NULL,
  `unit_id` int(10) unsigned NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `max_quantity` decimal(15,2) DEFAULT '-1.00',
  `unlimited_quantity` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `track_record`
--
 
CREATE TABLE `track_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `in_progress` tinyint(1) unsigned DEFAULT NULL,
  `start_date` datetime DEFAULT '0000-00-00 00:00:00',
  `activated` tinyint(1) unsigned DEFAULT NULL,
  `datechsys_track_id` int(10) unsigned DEFAULT NULL,
  `resource_cat` int(10) unsigned NOT NULL,
  `resource_id` int(10) unsigned NOT NULL,
  `additional_information` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `track_record_data`
--
 
CREATE TABLE `track_record_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `record_id` int(10) unsigned NOT NULL,
  `record_date` datetime DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `altitude` int(7) DEFAULT NULL,
  `speed` double DEFAULT NULL,
  `track` int(3) unsigned DEFAULT NULL,
  `acc_x` int(6) DEFAULT NULL,
  `acc_y` int(6) DEFAULT NULL,
  `acc_z` int(6) DEFAULT NULL,
  `pressure` int(5) unsigned DEFAULT NULL,
  `battery_level` int(4) unsigned DEFAULT NULL,
  `gps_fix` tinyint(1) unsigned DEFAULT NULL,
  `receive_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_record_id` (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `track_resource`
--
 
CREATE TABLE `track_resource` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `uncomp_flight_type`
--
 
CREATE TABLE `uncomp_flight_type` (
  `id1` int(10) unsigned DEFAULT NULL,
  `id2` int(10) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of sales';
 
--
-- Table structure for table `validity`
--
 
CREATE TABLE `validity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned NOT NULL,
  `validity_type_id` int(10) unsigned NOT NULL,
  `registration_date` datetime NOT NULL,
  `expire_date` date DEFAULT NULL,
  `no_alert` tinyint(1) NOT NULL DEFAULT '0',
  `ident_value` varchar(255) DEFAULT NULL,
  `grant_date` date DEFAULT NULL,
  `checker_person_id` int(10) unsigned NOT NULL,
  `checking_date` date NOT NULL,
  `checking_sentence` varchar(255) NOT NULL,
  `is_current_validity` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `validity_person_id_validity_type_id_registration_date_uindex` (`person_id`,`validity_type_id`,`registration_date`),
  KEY `validity_validity_type_id_fk` (`validity_type_id`),
  CONSTRAINT `validity_person_id_fk` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
  CONSTRAINT `validity_validity_type_id_fk` FOREIGN KEY (`validity_type_id`) REFERENCES `validity_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `validity_2_validity_page`
--
 
CREATE TABLE `validity_2_validity_page` (
  `validity_id` int(10) unsigned NOT NULL,
  `validity_page_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`validity_id`,`validity_page_id`),
  KEY `validity_2_validity_page_validity_page_id_fk` (`validity_page_id`),
  CONSTRAINT `validity_2_validity_page_validity_id_fk` FOREIGN KEY (`validity_id`) REFERENCES `validity` (`id`),
  CONSTRAINT `validity_2_validity_page_validity_page_id_fk` FOREIGN KEY (`validity_page_id`) REFERENCES `validity_page` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `validity_page`
--
 
CREATE TABLE `validity_page` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `validity_type_page_id` int(10) unsigned NOT NULL,
  `filename` varchar(255) NOT NULL,
  `file` mediumblob NOT NULL,
  `file_extension` varchar(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `validity_page_validity_type_page_id_fk` (`validity_type_page_id`),
  CONSTRAINT `validity_page_validity_type_page_id_fk` FOREIGN KEY (`validity_type_page_id`) REFERENCES `validity_type_page` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `validity_type`
--
 
CREATE TABLE `validity_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `time_limitation` tinyint(1) NOT NULL DEFAULT '0',
  `ident_value_enable` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `grant_date_enable` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mandatory` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `experience_formula` text,
  `alert_on_login` int(10) DEFAULT '-2',
  `mandatory_access_control` tinyint(1) unsigned DEFAULT '0',
  `first_reminder_alert` int(10) unsigned DEFAULT '0',
  `reminder_frequency_alert` int(10) unsigned DEFAULT '0',
  `associate_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `certification_process` tinyint(1) NOT NULL DEFAULT '0',
  `is_contract` tinyint(1) NOT NULL DEFAULT '0',
  `contract_filename` varchar(255) NOT NULL,
  `contract_file` mediumblob NOT NULL,
  `contract_file_extension` varchar(4) NOT NULL,
  `is_OF_contract` tinyint(1) NOT NULL DEFAULT '0',
  `activated` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS LIST';
 
--
-- Table structure for table `validity_type_page`
--
 
CREATE TABLE `validity_type_page` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `validity_type_id` int(10) unsigned NOT NULL,
  `page_index` int(10) unsigned NOT NULL,
  `label` varchar(40) NOT NULL,
  `is_mandatory` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `validity_type_page_validity_type_id_page_index_uindex` (`validity_type_id`,`page_index`),
  CONSTRAINT `validity_type_page_validity_type_id_fk` FOREIGN KEY (`validity_type_id`) REFERENCES `validity_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `variable`
--
 
CREATE TABLE `variable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variable` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `category` tinyint(1) unsigned NOT NULL,
  `value_type` varchar(255) DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `variable_value`
--
 
CREATE TABLE `variable_value` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `variable_id` int(11) NOT NULL,
  `assign_value` decimal(15,2) DEFAULT '0.00',
  `start_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `web_feed`
--
 
CREATE TABLE `web_feed` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `channel_id` int(10) unsigned NOT NULL,
  `publication_date` datetime NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Table structure for table `web_feed_channel`
--
 
CREATE TABLE `web_feed_channel` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Description

Table 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

  • 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 pilote remplit le vol avant de voler.

Champs cachés

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 possible quand une des tables contient un champ caché :

  • Table structure :
    • 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: Tous les champs
  • Table log: Tous les champs
  • Table parameter: Tous les champs
  • Table person:
    • hash_password


Exemple de requêtes non autorisées :

SELECT * FROM structure;
 
SELECT hash_password FROM person;
 
SELECT person.id, validity.*
FROM person
LEFT JOIN validity ON (person.id=validity.person_id);