Structure de la base de données : Différence entre versions
(→Structure) |
(→Structure) |
||
Ligne 10 : | Ligne 10 : | ||
`name` text, | `name` text, | ||
`export_account` varchar(255) DEFAULT NULL, | `export_account` varchar(255) DEFAULT NULL, | ||
− | `activated` tinyint(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 | + | ) 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 ' | + | `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 ' | + | `day_alert3` smallint(3) DEFAULT '8', |
− | + | ||
− | + | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT=' | + | ) 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 | + | `id` int(10) unsigned NOT NULL, |
− | `flight_time_formula` varchar(255) DEFAULT | + | `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', | ||
− | |||
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) | + | `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 | + | `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 | + | ) 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 | + | ) 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=' | + | ) 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) | + | `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 | + | ) 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) | + | `order_num` int(11) NOT NULL, |
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) 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) | + | `label` varchar(255) DEFAULT NULL, |
− | `value_type` varchar(40) | + | `value_type` varchar(40) DEFAULT NULL, |
− | `category` varchar(255) | + | `category` varchar(255) DEFAULT NULL, |
− | `order_num` int(11) | + | `order_num` int(11) DEFAULT NULL, |
− | `dsn` varchar(20) DEFAULT | + | `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 | + | ) 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 | + | ) 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) | + | `label` varchar(255) DEFAULT NULL, |
− | `predicate` text | + | `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 | + | ) 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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 429 : | Ligne 464 : | ||
`content` longblob, | `content` longblob, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) 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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 461 : | Ligne 497 : | ||
`content` longblob, | `content` longblob, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) 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 | + | ) 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 | + | ) 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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 553 : | Ligne 590 : | ||
`description` text, | `description` text, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) 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` | + | `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 | + | ) 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 | + | `sale_trigger_id` int(10) unsigned DEFAULT NULL, |
`query` text, | `query` text, | ||
− | `variable_formula` | + | `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) | + | `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) | + | `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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 721 : | Ligne 781 : | ||
CREATE TABLE `flight_track` ( | CREATE TABLE `flight_track` ( | ||
− | ` | + | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
− | ` | + | `flight_id` int(10) NOT NULL, |
− | PRIMARY KEY (` | + | `track` mediumblob NOT NULL, |
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | 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 | + | `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 | + | ) 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) | + | `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 | + | `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 ' | + | `num_key` tinyint(2) unsigned NOT NULL DEFAULT '8', |
− | `ipkey` varchar(50) | + | `ipkey` varchar(50) DEFAULT NULL, |
− | `httpport` int(11) | + | `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) | + | `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=' | + | ) 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) | + | `label` varchar(255) DEFAULT NULL, |
PRIMARY KEY (`code`) | PRIMARY KEY (`code`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) 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) | + | `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 | + | `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) | + | `login` varchar(255) DEFAULT NULL, |
− | `ip` varchar(255) | + | `ip` varchar(255) DEFAULT NULL, |
− | `code` varchar(255) | + | `code` varchar(255) DEFAULT NULL, |
− | `category` varchar(255) | + | `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 | + | ) 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) | + | `label` varchar(255) DEFAULT NULL, |
− | `unit` varchar(255) | + | `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 | + | ) 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 | + | `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 | + | `profile_id` bigint(20) unsigned NOT NULL, |
− | `account_type_id` int(10) unsigned NOT NULL | + | `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 | + | `profile_id` bigint(20) unsigned NOT NULL, |
− | `resource_type_id` int(10) unsigned NOT NULL | + | `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, |
+ | `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 | + | ) 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 | + | ) 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 | + | `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) | + | `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 | + | ) 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 | + | `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 | + | ) 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 ` | + | KEY `idx_product_id` (`product_id`) |
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) 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 | + | `debit_account_id` int(10) unsigned NOT NULL, |
− | `credit_account_id` int(10) unsigned | + | `credit_account_id` int(10) unsigned NOT NULL, |
− | `debit_account_type` | + | `debit_account_type` int(10) unsigned NOT NULL, |
− | `credit_account_type | + | `credit_account_type` int(10) unsigned NOT NULL, |
− | + | ||
`debit_budget_id` int(10) unsigned DEFAULT 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, | `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 | + | ) 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 | + | `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 | + | ) 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) | + | `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) | + | `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 | + | ) 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 | + | ) 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) | + | `label` varchar(255) DEFAULT NULL, |
− | `unit` varchar(255) | + | `unit` varchar(255) DEFAULT NULL, |
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) 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 | + | ) 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 | + | `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 | + | ) 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 | + | `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) | + | `default_timezone` varchar(255) DEFAULT NULL, |
− | `lang` varchar(255) | + | `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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='DESCRIPTION OF ALL AIRCLUBS'; |
+ | |||
+ | -- | ||
+ | -- Table structure for table `supplier` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `supplier` ( | ||
+ | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) DEFAULT NULL, | ||
+ | `account_id` int(11) NOT NULL, | ||
+ | `activated` tinyint(1) NOT NULL DEFAULT '1', | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
-- | -- | ||
Ligne 1 585 : | Ligne 1 770 : | ||
`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) | + | `supplier_bill_file_id` int(10) DEFAULT NULL, |
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 598 : | Ligne 1 783 : | ||
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 | + | ) 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 805 : | ||
`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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 624 : | Ligne 1 822 : | ||
`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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 647 : | Ligne 1 848 : | ||
`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) | + | `label` varchar(255) DEFAULT NULL, |
− | `max_quantity` decimal(15,2) | + | `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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 667 : | Ligne 1 868 : | ||
`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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 691 : | Ligne 1 892 : | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
KEY `idx_record_id` (`record_id`) | KEY `idx_record_id` (`record_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 717 : | Ligne 1 918 : | ||
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, | ||
+ | `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_backup` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `validity_backup` ( | ||
+ | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
+ | `person_id` int(10) unsigned NOT NULL DEFAULT '0', | ||
`validity_type_id` int(10) unsigned NOT NULL, | `validity_type_id` int(10) unsigned NOT NULL, | ||
`expire_date` date DEFAULT NULL, | `expire_date` date DEFAULT NULL, | ||
Ligne 1 723 : | Ligne 1 962 : | ||
`ident_value` varchar(255) DEFAULT NULL, | `ident_value` varchar(255) DEFAULT NULL, | ||
`grant_date` date DEFAULT NULL, | `grant_date` date DEFAULT NULL, | ||
− | + | `checker_person_id` int(10) NOT NULL, | |
+ | `checking_date` date NOT NULL, | ||
+ | `checking_sentence` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS OF EACH MEMBER'; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS OF EACH MEMBER'; | ||
+ | |||
+ | -- | ||
+ | -- 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 2 000 : | ||
`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', | ||
− | |||
`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 2 009 : | ||
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 030 : | ||
CREATE TABLE `variable` ( | CREATE TABLE `variable` ( | ||
− | `id` int( | + | `id` int(11) NOT NULL AUTO_INCREMENT, |
− | `variable` varchar(255) | + | `variable` varchar(255) DEFAULT NULL, |
− | `label` varchar(255) | + | `label` varchar(255) DEFAULT NULL, |
− | `category` tinyint(1) | + | `category` tinyint(1) unsigned NOT NULL, |
`value_type` varchar(255) DEFAULT NULL, | `value_type` varchar(255) DEFAULT NULL, | ||
− | `order_num` int(11) | + | `order_num` int(11) DEFAULT NULL, |
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 775 : | Ligne 2 046 : | ||
`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) | + | `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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 791 : | Ligne 2 062 : | ||
`content` text, | `content` text, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 799 : | Ligne 2 070 : | ||
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) | + | `label` varchar(255) DEFAULT NULL, |
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1;</sql> |
=Description= | =Description= |
Version du 11 juin 2020 à 14:35
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` -- CREATE TABLE `supplier` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `account_id` int(11) NOT NULL, `activated` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- 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_backup` -- CREATE TABLE `validity_backup` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `person_id` int(10) unsigned NOT NULL DEFAULT '0', `validity_type_id` int(10) unsigned NOT NULL, `expire_date` date DEFAULT NULL, `no_alert` tinyint(1) unsigned NOT NULL DEFAULT '0', `ident_value` varchar(255) DEFAULT NULL, `grant_date` date DEFAULT NULL, `checker_person_id` int(10) NOT NULL, `checking_date` date NOT NULL, `checking_sentence` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS OF EACH MEMBER'; -- -- 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
- 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);