Structure de la base de données : Différence entre versions
(→Table flight) |
(→Structure) |
||
Ligne 21 : | Ligne 21 : | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
KEY `idx_owner_id` (`owner_id`) | KEY `idx_owner_id` (`owner_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 32 : | Ligne 32 : | ||
`account_date` datetime DEFAULT NULL, | `account_date` datetime DEFAULT NULL, | ||
`account_id` int(11) DEFAULT NULL, | `account_id` int(11) DEFAULT NULL, | ||
− | `credit` decimal(15,5) | + | `credit` decimal(15,5) DEFAULT '0.00000', |
− | `debit` decimal(15,5) | + | `debit` decimal(15,5) DEFAULT '0.00000', |
`payment_type` int(10) unsigned DEFAULT NULL, | `payment_type` int(10) unsigned DEFAULT NULL, | ||
`payment_description` text, | `payment_description` text, | ||
Ligne 46 : | Ligne 46 : | ||
KEY `idx_flow_id` (`flow_id`), | KEY `idx_flow_id` (`flow_id`), | ||
KEY `idx_account_date` (`account_date`) | KEY `idx_account_date` (`account_date`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 81 : | Ligne 81 : | ||
`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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 92 : | Ligne 92 : | ||
`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) | + | `format` tinyint(1) DEFAULT NULL, |
`decimal_precision` int(10) unsigned DEFAULT '2', | `decimal_precision` int(10) unsigned DEFAULT '2', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
Ligne 112 : | Ligne 112 : | ||
CREATE TABLE `activity_type` ( | CREATE TABLE `activity_type` ( | ||
− | `id` | + | `id` bigint(20) unsigned NOT NULL DEFAULT '0', |
`name` varchar(255) DEFAULT NULL, | `name` varchar(255) DEFAULT NULL, | ||
`order_num` int(11) DEFAULT NULL, | `order_num` int(11) DEFAULT NULL, | ||
Ligne 118 : | Ligne 118 : | ||
`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 126 : | Ligne 126 : | ||
CREATE TABLE `aircraft` ( | CREATE TABLE `aircraft` ( | ||
`id` int(10) unsigned NOT NULL DEFAULT '0', | `id` int(10) unsigned NOT NULL DEFAULT '0', | ||
− | |||
`ref_date` datetime DEFAULT NULL, | `ref_date` datetime DEFAULT NULL, | ||
`ref_hours` int(11) DEFAULT NULL, | `ref_hours` int(11) DEFAULT NULL, | ||
Ligne 141 : | Ligne 140 : | ||
`tolerance_time` int(10) unsigned DEFAULT '6000', | `tolerance_time` int(10) unsigned DEFAULT '6000', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 148 : | Ligne 147 : | ||
CREATE TABLE `aircraft_type` ( | CREATE TABLE `aircraft_type` ( | ||
− | `id` int(10) unsigned NOT NULL, | + | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`flight_time_formula` varchar(255) DEFAULT '%DURATION', | `flight_time_formula` varchar(255) DEFAULT '%DURATION', | ||
`counter_state` tinyint(2) NOT NULL DEFAULT '-1', | `counter_state` tinyint(2) NOT NULL DEFAULT '-1', | ||
Ligne 155 : | Ligne 154 : | ||
`true_air_speed` int(10) unsigned NOT NULL DEFAULT '0', | `true_air_speed` int(10) unsigned NOT NULL DEFAULT '0', | ||
`digit_counter_number` tinyint(1) unsigned NOT NULL DEFAULT '4', | `digit_counter_number` tinyint(1) unsigned NOT NULL DEFAULT '4', | ||
− | |||
− | |||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 168 : | Ligne 165 : | ||
`place_num` int(10) unsigned DEFAULT NULL, | `place_num` int(10) unsigned DEFAULT NULL, | ||
`status_id` int(10) unsigned DEFAULT NULL | `status_id` int(10) unsigned DEFAULT NULL | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 176 : | Ligne 173 : | ||
CREATE TABLE `aircraft_type_mandatory_flight_type` ( | CREATE TABLE `aircraft_type_mandatory_flight_type` ( | ||
`aircraft_type_id` int(10) unsigned DEFAULT NULL, | `aircraft_type_id` int(10) unsigned DEFAULT NULL, | ||
− | ` | + | `activity_type_id` bigint(20) unsigned DEFAULT NULL |
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 185 : | Ligne 182 : | ||
CREATE TABLE `aircraft_type_uncomp_flight_type` ( | CREATE TABLE `aircraft_type_uncomp_flight_type` ( | ||
`aircraft_type_id` int(10) unsigned DEFAULT NULL, | `aircraft_type_id` int(10) unsigned DEFAULT NULL, | ||
− | ` | + | `activity_type_id` bigint(20) unsigned DEFAULT NULL |
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 197 : | Ligne 194 : | ||
`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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 206 : | Ligne 203 : | ||
`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, | ||
− | `debit` decimal(15,5) | + | `debit` decimal(15,5) DEFAULT '0.00000', |
− | `credit` decimal(15,5) | + | `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 231 : | Ligne 228 : | ||
`end_date` datetime DEFAULT NULL, | `end_date` datetime DEFAULT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 326 : | Ligne 323 : | ||
`compulsory_fill` tinyint(1) DEFAULT '0', | `compulsory_fill` tinyint(1) DEFAULT '0', | ||
`linked_category` varchar(255) DEFAULT NULL, | `linked_category` varchar(255) DEFAULT NULL, | ||
− | ` | + | `linked_business_field_id` int(10) unsigned DEFAULT NULL, |
`linked_field_name` varchar(255) DEFAULT NULL, | `linked_field_name` varchar(255) DEFAULT NULL, | ||
`max_display` int(10) DEFAULT '-1', | `max_display` int(10) DEFAULT '-1', | ||
Ligne 334 : | Ligne 331 : | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
UNIQUE KEY `variable` (`variable`) | UNIQUE KEY `variable` (`variable`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 354 : | Ligne 351 : | ||
CREATE TABLE `business_field_content` ( | CREATE TABLE `business_field_content` ( | ||
`category_id` int(10) unsigned NOT NULL, | `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', | `person_id` int(10) unsigned NOT NULL DEFAULT '0', | ||
`content` text, | `content` text, | ||
`placeholder` text, | `placeholder` text, | ||
− | PRIMARY KEY (`category_id`,` | + | PRIMARY KEY (`category_id`,`business_field_id`,`person_id`) |
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 371 : | Ligne 368 : | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
-- | -- | ||
Ligne 448 : | Ligne 405 : | ||
`customer_bill_id` int(10) unsigned DEFAULT NULL, | `customer_bill_id` int(10) unsigned DEFAULT NULL, | ||
`product_id` int(10) unsigned DEFAULT NULL, | `product_id` int(10) unsigned DEFAULT NULL, | ||
− | `qty` decimal(15, | + | `qty` decimal(15,2) DEFAULT '0.00', |
`unit_price` decimal(15,5) DEFAULT '0.00000', | `unit_price` decimal(15,5) DEFAULT '0.00000', | ||
`debit` decimal(15,5) DEFAULT '0.00000', | `debit` decimal(15,5) DEFAULT '0.00000', | ||
Ligne 474 : | Ligne 431 : | ||
CREATE TABLE `default_display` ( | CREATE TABLE `default_display` ( | ||
− | `person_id` int(10) unsigned NOT NULL | + | `person_id` int(10) unsigned NOT NULL, |
`display_key` varchar(255) NOT NULL DEFAULT '', | `display_key` varchar(255) NOT NULL DEFAULT '', | ||
`display_value` text, | `display_value` text, | ||
Ligne 530 : | Ligne 487 : | ||
CREATE TABLE `exceptionnal_inst_date` ( | CREATE TABLE `exceptionnal_inst_date` ( | ||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
− | `person_id` int(10) unsigned | + | `person_id` int(10) unsigned DEFAULT NULL, |
`start_date` datetime DEFAULT NULL, | `start_date` datetime DEFAULT NULL, | ||
`end_date` datetime DEFAULT NULL, | `end_date` datetime DEFAULT NULL, | ||
Ligne 542 : | Ligne 499 : | ||
CREATE 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', | `booking_popup_display_4_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', | ||
− | PRIMARY KEY (` | + | PRIMARY KEY (`business_field_id`,`booking_popup_display_4_profile_id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
Ligne 567 : | Ligne 524 : | ||
CREATE TABLE `favorite_icao` ( | CREATE TABLE `favorite_icao` ( | ||
− | `icao` varchar(6) NOT NULL | + | `icao` varchar(6) NOT NULL, |
PRIMARY KEY (`icao`) | PRIMARY KEY (`icao`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 598 : | Ligne 555 : | ||
`aircraft_type_id` int(10) NOT NULL DEFAULT '0', | `aircraft_type_id` int(10) NOT NULL DEFAULT '0', | ||
PRIMARY KEY (`fhp_id`,`aircraft_type_id`) | PRIMARY KEY (`fhp_id`,`aircraft_type_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 606 : | Ligne 563 : | ||
CREATE TABLE `fhp_flight_type` ( | CREATE TABLE `fhp_flight_type` ( | ||
`fhp_id` int(10) NOT NULL DEFAULT '0', | `fhp_id` int(10) NOT NULL DEFAULT '0', | ||
− | ` | + | `activity_type_id` bigint(20) unsigned NOT NULL DEFAULT '0', |
`excluded` tinyint(1) unsigned DEFAULT '0', | `excluded` tinyint(1) unsigned DEFAULT '0', | ||
− | PRIMARY KEY (`fhp_id`,` | + | PRIMARY KEY (`fhp_id`,`activity_type_id`) |
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 617 : | Ligne 574 : | ||
CREATE TABLE `fhp_profile` ( | CREATE TABLE `fhp_profile` ( | ||
`fhp_id` int(10) unsigned NOT NULL, | `fhp_id` int(10) unsigned NOT NULL, | ||
− | `profile_id` bigint(20) unsigned NOT NULL | + | `profile_id` bigint(20) unsigned NOT NULL, |
`place_num` tinyint(1) unsigned NOT NULL DEFAULT '0', | `place_num` tinyint(1) unsigned NOT NULL DEFAULT '0', | ||
PRIMARY KEY (`fhp_id`,`profile_id`,`place_num`) | PRIMARY KEY (`fhp_id`,`profile_id`,`place_num`) | ||
Ligne 643 : | Ligne 600 : | ||
`aircraft_id` int(10) unsigned DEFAULT NULL, | `aircraft_id` int(10) unsigned DEFAULT NULL, | ||
`start_date` datetime DEFAULT NULL, | `start_date` datetime DEFAULT NULL, | ||
− | `duration` int( | + | `duration` int(11) DEFAULT NULL, |
− | ` | + | `activity_type_id` bigint(20) unsigned DEFAULT NULL, |
`people_onboard` int(10) unsigned DEFAULT NULL, | `people_onboard` int(10) unsigned DEFAULT NULL, | ||
`departure_location_id` int(10) unsigned DEFAULT NULL, | `departure_location_id` int(10) unsigned DEFAULT NULL, | ||
Ligne 654 : | Ligne 611 : | ||
`validated` tinyint(3) unsigned DEFAULT '0', | `validated` tinyint(3) unsigned DEFAULT '0', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 665 : | Ligne 622 : | ||
PRIMARY KEY (`flight_id`,`account_entry_id`), | PRIMARY KEY (`flight_id`,`account_entry_id`), | ||
KEY `idx_account_entry_id` (`account_entry_id`) | KEY `idx_account_entry_id` (`account_entry_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 685 : | Ligne 642 : | ||
`sale_trigger_id` int(10) unsigned DEFAULT '0', | `sale_trigger_id` int(10) unsigned DEFAULT '0', | ||
`query` text, | `query` text, | ||
− | `variable_formula` | + | `variable_formula` text, |
− | ` | + | `business_field_id` int(10) unsigned DEFAULT NULL, |
`debit_bill_num` int(10) unsigned DEFAULT NULL, | `debit_bill_num` int(10) unsigned DEFAULT NULL, | ||
`credit_bill_num` int(10) unsigned DEFAULT NULL, | `credit_bill_num` int(10) unsigned DEFAULT NULL, | ||
Ligne 692 : | Ligne 649 : | ||
`unit_price_formula` text, | `unit_price_formula` text, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 704 : | Ligne 661 : | ||
`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`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 729 : | Ligne 686 : | ||
`track_id` int(10) unsigned NOT NULL, | `track_id` int(10) unsigned NOT NULL, | ||
PRIMARY KEY (`track_id`,`flight_id`) | PRIMARY KEY (`track_id`,`flight_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 736 : | Ligne 693 : | ||
CREATE 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 DEFAULT '0', | `validity_type_id` int(10) unsigned NOT NULL DEFAULT '0', | ||
− | PRIMARY KEY (` | + | PRIMARY KEY (`activity_type_id`,`validity_type_id`) |
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 770 : | Ligne 727 : | ||
`expire_date` datetime NOT NULL, | `expire_date` datetime NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 787 : | Ligne 744 : | ||
KEY `idx_date_log` (`date_log`), | KEY `idx_date_log` (`date_log`), | ||
KEY `idx_action` (`action`(8)) | KEY `idx_action` (`action`(8)) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 798 : | Ligne 755 : | ||
`status` int(10) unsigned NOT NULL DEFAULT '0', | `status` int(10) unsigned NOT NULL DEFAULT '0', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 811 : | Ligne 768 : | ||
`key_word` bigint(20) unsigned DEFAULT '0', | `key_word` bigint(20) unsigned DEFAULT '0', | ||
PRIMARY KEY (`key_id`) | PRIMARY KEY (`key_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 820 : | Ligne 777 : | ||
`id` tinyint(2) NOT NULL AUTO_INCREMENT, | `id` tinyint(2) NOT NULL AUTO_INCREMENT, | ||
`timeout` tinyint(2) NOT NULL DEFAULT '10', | `timeout` tinyint(2) NOT NULL DEFAULT '10', | ||
− | `num_key` tinyint(2) unsigned NOT NULL DEFAULT ' | + | `num_key` tinyint(2) unsigned NOT NULL DEFAULT '10', |
`ipkey` varchar(50) NOT NULL DEFAULT '127.0.0.1', | `ipkey` varchar(50) NOT NULL DEFAULT '127.0.0.1', | ||
`httpport` int(11) NOT NULL DEFAULT '4080', | `httpport` int(11) NOT NULL DEFAULT '4080', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 837 : | Ligne 794 : | ||
`key_id` int(10) unsigned DEFAULT NULL, | `key_id` int(10) unsigned DEFAULT NULL, | ||
`person_id` int(10) unsigned DEFAULT NULL, | `person_id` int(10) unsigned DEFAULT NULL, | ||
− | `xmlrpc` int(10) unsigned | + | `xmlrpc` int(10) unsigned NOT NULL, |
`error` varchar(255) DEFAULT NULL, | `error` varchar(255) DEFAULT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 857 : | Ligne 814 : | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
UNIQUE KEY `icao_name` (`icao_name`) | UNIQUE KEY `icao_name` (`icao_name`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 871 : | Ligne 828 : | ||
KEY `idx_journal_id` (`journal_id`), | KEY `idx_journal_id` (`journal_id`), | ||
KEY `idx_field_value` (`field_value`) | KEY `idx_field_value` (`field_value`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 884 : | Ligne 841 : | ||
`order_num` int(10) unsigned NOT NULL, | `order_num` int(10) unsigned NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 896 : | Ligne 853 : | ||
`expire_date` datetime NOT NULL, | `expire_date` datetime NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 971 : | Ligne 928 : | ||
CREATE TABLE `m_operation` ( | CREATE TABLE `m_operation` ( | ||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
− | `content` text | + | `content` text, |
− | `m_component_type_id` int( | + | `m_component_type_id` int(10) unsigned NOT NULL, |
`order_num` int(11) NOT NULL, | `order_num` int(11) NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
Ligne 985 : | Ligne 942 : | ||
`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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 003 : | Ligne 960 : | ||
`visible` tinyint(1) unsigned NOT NULL DEFAULT '1', | `visible` tinyint(1) unsigned NOT NULL DEFAULT '1', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 010 : | Ligne 967 : | ||
CREATE TABLE `nationality` ( | CREATE TABLE `nationality` ( | ||
− | `code` char(2) NOT NULL | + | `code` char(2) NOT NULL, |
`label` varchar(255) NOT NULL, | `label` varchar(255) NOT NULL, | ||
PRIMARY KEY (`code`) | PRIMARY KEY (`code`) | ||
Ligne 1 026 : | Ligne 983 : | ||
`char_value` text, | `char_value` text, | ||
PRIMARY KEY (`code`,`key_id`) | PRIMARY KEY (`code`,`key_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 039 : | Ligne 996 : | ||
`treasury_budget_id` int(10) unsigned DEFAULT NULL, | `treasury_budget_id` int(10) unsigned DEFAULT NULL, | ||
PRIMARY KEY (`payment_id`) | PRIMARY KEY (`payment_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 068 : | Ligne 1 025 : | ||
`pos_key_id` int(10) unsigned DEFAULT NULL, | `pos_key_id` int(10) unsigned DEFAULT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 080 : | Ligne 1 037 : | ||
`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 NOT NULL DEFAULT '0', |
`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 102 : | Ligne 1 059 : | ||
`total_flight_time` int(10) unsigned DEFAULT '0', | `total_flight_time` int(10) unsigned DEFAULT '0', | ||
`date_total_flight_time` datetime DEFAULT NULL, | `date_total_flight_time` datetime DEFAULT NULL, | ||
− | ` | + | `guid` varchar(255) DEFAULT NULL, |
− | + | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
UNIQUE KEY `idx_name` (`name`) | UNIQUE KEY `idx_name` (`name`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 168 : | Ligne 1 124 : | ||
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 DEFAULT '0', |
− | ` | + | `business_field_id` int(10) unsigned NOT NULL DEFAULT '0', |
− | PRIMARY KEY (`profile_id`,` | + | PRIMARY KEY (`profile_id`,`business_field_id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
Ligne 1 178 : | Ligne 1 134 : | ||
CREATE TABLE `profile_profile_view` ( | CREATE TABLE `profile_profile_view` ( | ||
− | `profile_id` bigint(20) unsigned NOT NULL | + | `profile_id` bigint(20) unsigned NOT NULL, |
`viewable_profile_id` bigint(20) unsigned NOT NULL, | `viewable_profile_id` bigint(20) unsigned NOT NULL, | ||
PRIMARY KEY (`profile_id`,`viewable_profile_id`) | PRIMARY KEY (`profile_id`,`viewable_profile_id`) | ||
Ligne 1 188 : | Ligne 1 144 : | ||
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 DEFAULT '0', |
− | `account_type_id` int(10) unsigned NOT NULL, | + | `account_type_id` int(10) unsigned NOT NULL DEFAULT '0', |
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 198 : | Ligne 1 154 : | ||
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 DEFAULT '0', |
− | `resource_type_id` int(10) unsigned NOT NULL, | + | `resource_type_id` int(10) unsigned NOT NULL DEFAULT '0', |
`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 209 : | Ligne 1 165 : | ||
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, |
`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 219 : | Ligne 1 175 : | ||
CREATE TABLE `profile_validity_type_join` ( | CREATE TABLE `profile_validity_type_join` ( | ||
− | `profile_id` bigint(20) unsigned NOT NULL, | + | `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', |
− | `validity_type_id` int(10) unsigned NOT NULL, | + | `validity_type_id` int(10) unsigned 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 230 : | Ligne 1 186 : | ||
CREATE TABLE `profile_validity_type_notification` ( | CREATE TABLE `profile_validity_type_notification` ( | ||
`profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', | `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', | ||
− | `validity_type_id` int(10) unsigned NOT NULL, | + | `validity_type_id` int(10) unsigned 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 352 : | Ligne 1 308 : | ||
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 DEFAULT '0', |
`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 365 : | Ligne 1 321 : | ||
CREATE TABLE `sale_2_stock` ( | CREATE TABLE `sale_2_stock` ( | ||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
− | `product_id` int(10) unsigned | + | `product_id` int(10) unsigned DEFAULT NULL, |
`stock_id` int(10) unsigned NOT NULL, | `stock_id` int(10) unsigned NOT NULL, | ||
`stock_variation_qty_per_sale` float NOT NULL DEFAULT '0', | `stock_variation_qty_per_sale` float NOT NULL DEFAULT '0', | ||
Ligne 1 380 : | Ligne 1 336 : | ||
`new_formula` varchar(255) DEFAULT NULL, | `new_formula` varchar(255) DEFAULT NULL, | ||
`update_formula` varchar(255) DEFAULT NULL, | `update_formula` varchar(255) DEFAULT NULL, | ||
− | `product_id` int(10) unsigned | + | `product_id` int(10) unsigned DEFAULT NULL, |
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
UNIQUE KEY `validity_type_id` (`validity_type_id`), | UNIQUE KEY `validity_type_id` (`validity_type_id`), | ||
− | |||
− | |||
KEY `idx_product` (`product_id`) | KEY `idx_product` (`product_id`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
Ligne 1 394 : | Ligne 1 348 : | ||
CREATE TABLE `sale_pricing` ( | CREATE TABLE `sale_pricing` ( | ||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
− | |||
`price_formula` text, | `price_formula` text, | ||
`debit_account_id` int(10) unsigned DEFAULT NULL, | `debit_account_id` int(10) unsigned DEFAULT NULL, | ||
Ligne 1 403 : | Ligne 1 356 : | ||
`debit_budget_id` int(10) unsigned DEFAULT NULL, | `debit_budget_id` int(10) unsigned DEFAULT NULL, | ||
`order_num` int(11) DEFAULT NULL, | `order_num` int(11) DEFAULT NULL, | ||
+ | `label` varchar(255) 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 437 : | Ligne 1 391 : | ||
CREATE TABLE `sale_trigger` ( | CREATE TABLE `sale_trigger` ( | ||
− | `id` int(10) NOT NULL | + | `id` int(10) NOT NULL AUTO_INCREMENT, |
`name` varchar(255) DEFAULT NULL, | `name` varchar(255) DEFAULT NULL, | ||
`event` varchar(255) DEFAULT NULL, | `event` varchar(255) DEFAULT NULL, | ||
`locked` tinyint(1) unsigned NOT NULL DEFAULT '0', | `locked` tinyint(1) unsigned NOT NULL DEFAULT '0', | ||
+ | `query` text, | ||
+ | `validate_entry` tinyint(1) DEFAULT '0', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
Ligne 1 465 : | Ligne 1 421 : | ||
`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) DEFAULT '0.00', | + | `value` decimal(15,2) NOT NULL 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 479 : | Ligne 1 435 : | ||
`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 539 : | Ligne 1 495 : | ||
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; | ||
+ | |||
+ | -- | ||
+ | -- 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 NOT NULL DEFAULT '0', | ||
+ | `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) NOT NULL, | ||
+ | `lang` varchar(255) NOT 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, | ||
+ | PRIMARY KEY (`id`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
Ligne 1 665 : | Ligne 1 661 : | ||
`id1` int(10) unsigned DEFAULT NULL, | `id1` int(10) unsigned DEFAULT NULL, | ||
`id2` int(10) unsigned DEFAULT NULL | `id2` int(10) unsigned DEFAULT NULL | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 676 : | Ligne 1 672 : | ||
`expire_date` date DEFAULT NULL, | `expire_date` date DEFAULT NULL, | ||
`no_alert` tinyint(1) unsigned NOT NULL DEFAULT '0', | `no_alert` tinyint(1) unsigned NOT NULL DEFAULT '0', | ||
+ | `DOCU` set('oui','non') NOT NULL DEFAULT 'non', | ||
`ident_value` varchar(255) DEFAULT NULL, | `ident_value` varchar(255) DEFAULT NULL, | ||
`grant_date` date DEFAULT NULL, | `grant_date` date DEFAULT NULL, | ||
PRIMARY KEY (`person_id`,`validity_type_id`) | PRIMARY KEY (`person_id`,`validity_type_id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 692 : | Ligne 1 689 : | ||
`grant_date_enable` tinyint(1) NOT NULL DEFAULT '0', | `grant_date_enable` tinyint(1) NOT NULL DEFAULT '0', | ||
`mandatory` tinyint(1) NOT NULL DEFAULT '0', | `mandatory` tinyint(1) NOT NULL DEFAULT '0', | ||
− | `experience_formula` | + | `experience_formula` text, |
− | `alert_on_login` int( | + | `alert_on_login` int(10) DEFAULT '-2', |
`mandatory_access_control` tinyint(1) unsigned DEFAULT '0', | `mandatory_access_control` tinyint(1) unsigned DEFAULT '0', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | + | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
-- | -- | ||
Ligne 1 703 : | Ligne 1 700 : | ||
CREATE TABLE `variable` ( | CREATE TABLE `variable` ( | ||
− | `id` int( | + | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`variable` varchar(255) NOT NULL, | `variable` varchar(255) NOT NULL, | ||
`label` varchar(255) NOT NULL, | `label` varchar(255) NOT NULL, |
Version du 7 novembre 2017 à 14:14
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) unsigned 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, PRIMARY KEY (`id`), KEY `idx_owner_id` (`owner_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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, `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', `registration_date` datetime DEFAULT NULL, `budget_id` int(10) unsigned DEFAULT NULL, `product_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_flow_id` (`flow_id`), KEY `idx_account_date` (`account_date`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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) 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; -- -- 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) 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_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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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, `interval_visit` int(11) unsigned DEFAULT '30000', `time_alert1` int(11) DEFAULT '6000', `time_alert2` int(11) DEFAULT '0', `time_alert3` int(11) DEFAULT '-3000', `day_alert1` smallint(3) DEFAULT '15', `day_alert2` smallint(3) DEFAULT '0', `day_alert3` smallint(3) DEFAULT '-8', `last_counter` int(11) DEFAULT NULL, `tolerance_time` int(10) unsigned DEFAULT '6000', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `aircraft_type` -- CREATE TABLE `aircraft_type` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `flight_time_formula` varchar(255) DEFAULT '%DURATION', `counter_state` tinyint(2) NOT NULL DEFAULT '-1', `tolerance` int(11) DEFAULT '0', `autonomy` int(11) DEFAULT '5990', `true_air_speed` int(10) unsigned NOT NULL DEFAULT '0', `digit_counter_number` tinyint(1) unsigned NOT NULL DEFAULT '4', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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; -- -- 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; -- -- 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 DEFAULT '0', `check_num` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`aircraft_type_id`,`validity_type_id`,`check_num`) ) 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, `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; -- -- 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) DEFAULT 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) DEFAULT 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) NOT NULL, `value_type` varchar(40) NOT NULL, `category` varchar(255) NOT NULL, `order_num` int(11) NOT NULL, `dsn` varchar(20) DEFAULT 'customer', `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, PRIMARY KEY (`id`), UNIQUE KEY `variable` (`variable`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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` int(10) 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; -- -- 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) NOT NULL, `predicate` text NOT NULL, `order_num` int(11) DEFAULT NULL, `dsn` varchar(20) 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 `default_display` -- CREATE TABLE `default_display` ( `person_id` int(10) unsigned NOT NULL, `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, `resource_id` int(10) unsigned 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, PRIMARY KEY (`icao`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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_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; -- -- 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; -- -- 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` mediumblob, `file_type` varchar(255) DEFAULT NULL, `category` tinyint(1) unsigned 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) unsigned DEFAULT NULL, `airborne` tinyint(1) unsigned DEFAULT NULL, `validated` tinyint(3) unsigned DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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; -- -- 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 '0', `query` text, `variable_formula` text, `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; -- -- 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) unsigned DEFAULT NULL, `num` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`flight_id`,`pilot_id`,`num`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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) NOT NULL DEFAULT '0.00', `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` ( `flight_id` int(10) unsigned NOT NULL, `track_id` int(10) unsigned NOT NULL, PRIMARY KEY (`track_id`,`flight_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 DEFAULT '0', PRIMARY KEY (`activity_type_id`,`validity_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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) NOT NULL, `counter` tinyint(1) unsigned NOT NULL, `expire_date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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; -- -- 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; -- -- 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 '0', PRIMARY KEY (`key_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `key_host` -- CREATE TABLE `key_host` ( `id` tinyint(2) NOT NULL AUTO_INCREMENT, `timeout` tinyint(2) NOT NULL DEFAULT '10', `num_key` tinyint(2) unsigned NOT NULL DEFAULT '10', `ipkey` varchar(50) NOT NULL DEFAULT '127.0.0.1', `httpport` int(11) NOT NULL DEFAULT '4080', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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; -- -- Table structure for table `location` -- CREATE TABLE `location` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `icao_name` varchar(6) DEFAULT 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 (`id`), UNIQUE KEY `icao_name` (`icao_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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; -- -- 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; -- -- Table structure for table `login_stopped` -- CREATE TABLE `login_stopped` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(255) NOT NULL, `counter` tinyint(3) unsigned NOT NULL, `expire_date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 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 `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; -- -- 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; -- -- Table structure for table `nationality` -- CREATE TABLE `nationality` ( `code` char(2) NOT NULL, `label` varchar(255) NOT NULL, PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `parameter` -- CREATE TABLE `parameter` ( `code` varchar(255) NOT NULL, `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; -- -- 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; -- -- 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; -- -- Table structure for table `person` -- CREATE TABLE `person` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `hash_password` varchar(255) NOT NULL, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `profile` bigint(20) unsigned NOT NULL DEFAULT '0', `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, PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `person_awaiting_activation` -- CREATE TABLE `person_awaiting_activation` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(255) NOT NULL, `ip` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `category` varchar(255) NOT 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) NOT NULL, `unit` varchar(255) NOT 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 DEFAULT '0', `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, `viewable_profile_id` bigint(20) unsigned NOT NULL, 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 DEFAULT '0', `account_type_id` int(10) unsigned NOT NULL DEFAULT '0', 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 DEFAULT '0', `resource_type_id` int(10) unsigned NOT NULL DEFAULT '0', `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, `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 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 `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', 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 DEFAULT NULL, `seats_available` int(11) DEFAULT '-1', `comments` varchar(255) DEFAULT NULL, `order_num` int(11) DEFAULT NULL, `activated` tinyint(1) unsigned 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 DEFAULT '0', `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` (`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, `price_formula` text, `debit_account_id` int(10) unsigned DEFAULT NULL, `credit_account_id` int(10) unsigned DEFAULT NULL, `debit_account_type` tinyint(1) unsigned DEFAULT '0', `credit_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, `label` varchar(255) 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 NOT NULL DEFAULT '0', `query` text, `validate_entry` 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) NOT NULL 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; -- -- Table structure for table `stock` -- CREATE TABLE `stock` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `label` varchar(255) NOT 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) NOT NULL, `unit` varchar(255) NOT 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 NOT 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 NOT NULL DEFAULT '0', `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) NOT NULL, `lang` varchar(255) NOT 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, PRIMARY KEY (`id`) ) ENGINE=InnoDB 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` date DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `ordinal` int(10) unsigned NOT NULL, `validated` tinyint(1) DEFAULT '0', 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_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, 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) NOT NULL, `max_quantity` decimal(15,2) NOT NULL 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; -- -- Table structure for table `validity` -- CREATE TABLE `validity` ( `person_id` int(10) unsigned NOT NULL, `validity_type_id` int(10) unsigned NOT NULL, `expire_date` date DEFAULT NULL, `no_alert` tinyint(1) unsigned NOT NULL DEFAULT '0', `DOCU` set('oui','non') NOT NULL DEFAULT 'non', `ident_value` varchar(255) DEFAULT NULL, `grant_date` date DEFAULT NULL, PRIMARY KEY (`person_id`,`validity_type_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) NOT NULL, `time_limitation` tinyint(1) NOT NULL DEFAULT '0', `ident_value_enable` tinyint(1) NOT NULL DEFAULT '0', `grant_date_enable` tinyint(1) NOT NULL DEFAULT '0', `mandatory` tinyint(1) NOT NULL DEFAULT '0', `experience_formula` text, `alert_on_login` int(10) DEFAULT '-2', `mandatory_access_control` tinyint(1) unsigned DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `variable` -- CREATE TABLE `variable` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `variable` varchar(255) NOT NULL, `label` varchar(255) NOT NULL, `category` tinyint(1) DEFAULT NULL, `value_type` varchar(255) DEFAULT NULL, `order_num` int(11) NOT 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) NOT NULL, `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) NOT 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 possivle quand une des tables contient un champ caché :
- Table club:
- name
- info_cell
- logo
- logo_name
- logo_ext
- logo_size
- first_hour_displayed
- last_hour_displayed
- usual_profiles
- default_slot_range
- min_slot_range
- twilight_range
- mailing_list_name
- mailing_list_type
- default_timezone
- lang
- admin_num
- mail_from_address
- default_view_type
- address
- zipcode
- city
- state
- country
- phone
- fax
- 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 club; SELECT hash_password FROM person; SELECT person.id, validity.* FROM person LEFT JOIN validity ON (person.id=validity.person_id);