Database OF35
Revision as of 10:24, 2 October 2014 by Claratte (Talk | contribs) (Created page with "<sql>CREATE TABLE `account` ( `id` int(10) unsigned NOT NULL, `creation_date` date DEFAULT NULL, `name` text, `export_account` varchar(255) DEFAULT NULL, `activated` tiny...")
CREATE TABLE `account` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `accounting` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `accounting_profile` ( `accounting_id` int(10) unsigned NOT NULL DEFAULT '0', `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `account_entry` ( `id` int(11) NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `account_type` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `account_type_profile` ( `account_type_id` int(10) unsigned NOT NULL DEFAULT '0', `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `aircraft` ( `id` int(10) unsigned NOT NULL DEFAULT '0', `ref_date` datetime DEFAULT NULL, `ref_hours` int(11) DEFAULT NULL, `inspection_date` date DEFAULT NULL, `inspection_time` int(11) DEFAULT NULL, `interval_visit` int(11) unsigned DEFAULT '30000', `tolerance_time` int(11) unsigned DEFAULT '6000', `last_counter` int(11) DEFAULT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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; CREATE TABLE `aircraft_type_mandatory_flight_type` ( `aircraft_type_id` int(10) unsigned DEFAULT NULL, `flight_type_id` int(10) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `aircraft_type_uncomp_flight_type` ( `aircraft_type_id` int(10) unsigned DEFAULT NULL, `flight_type_id` int(10) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `balance_date` ( `id` int(10) unsigned NOT NULL, `balance_date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `booking` ( `id` int(10) unsigned NOT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `resource_id` int(10) unsigned DEFAULT NULL, `person_id` int(10) unsigned DEFAULT NULL, `slot_type` tinyint(3) unsigned DEFAULT NULL, `instructor_id` int(10) unsigned DEFAULT NULL, `free_seats` int(10) unsigned DEFAULT NULL, `departure_location_id` int(10) unsigned DEFAULT NULL, `arrival_location_id` int(10) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `budget` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `budget_group` ( `id` int(10) unsigned NOT NULL, `name` varchar(255) DEFAULT NULL, `order_num` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `club` ( `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, `club_site_url` varchar(255) DEFAULT NULL, `default_timezone` varchar(255) DEFAULT NULL, `lang` varchar(255) DEFAULT NULL, `admin_num` int(10) unsigned NOT NULL, `mail_from_address` varchar(255) DEFAULT 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` tinyint(3) unsigned DEFAULT NULL, `welcome_cell` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `criteria` ( `id` int(11) NOT NULL, `label` varchar(255) DEFAULT NULL, `predicate` text, `order_num` int(11) DEFAULT NULL, `dsn` varchar(20) NOT NULL DEFAULT 'customer' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `criteria_profile` ( `criteria_id` int(10) unsigned NOT NULL, `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `customer_bill_entry` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `customer_bill_file` ( `id` int(10) unsigned NOT NULL, `file_type` varchar(255) DEFAULT NULL, `content` longblob ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `default_display` ( `person_id` int(10) unsigned NOT NULL DEFAULT '0', `display_key` varchar(255) NOT NULL DEFAULT '', `display_value` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `default_multi_display` ( `resource_type` char(30) NOT NULL, `person_id` int(10) unsigned NOT NULL DEFAULT '0', `resource_id` int(10) unsigned NOT NULL, `display_value` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `exceptionnal_inst_date` ( `person_id` int(10) unsigned DEFAULT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `presence` tinyint(1) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `extra_field` ( `id` int(10) unsigned NOT NULL, `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_extra_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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `extra_field_content` ( `category_id` int(10) unsigned NOT NULL, `extra_field_id` int(10) unsigned NOT NULL, `content` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `extra_field_profile` ( `extra_field_id` int(10) unsigned NOT NULL DEFAULT '0', `booking_popup_display_4_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `facebook` ( `id` int(10) unsigned NOT NULL, `category` int(10) unsigned NOT NULL, `owner_id` int(10) unsigned NOT NULL, `small` blob, `original` mediumblob NOT NULL, `label` text, `description` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `favorite_icao` ( `icao` varchar(6) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `fhp_aircraft_type` ( `fhp_id` int(10) NOT NULL DEFAULT '0', `aircraft_type_id` int(10) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `fhp_flight_type` ( `fhp_id` int(10) NOT NULL DEFAULT '0', `flight_type_id` int(10) NOT NULL DEFAULT '0', `excluded` tinyint(1) unsigned DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `fhp_profile` ( `fhp_id` int(10) unsigned NOT NULL, `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', `place_num` tinyint(1) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `file` ( `id` int(10) unsigned NOT NULL, `name` varchar(255) DEFAULT NULL, `content` mediumblob, `file_type` varchar(255) DEFAULT NULL, `category` tinyint(1) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `flight` ( `id` int(10) unsigned NOT NULL, `aircraft_id` int(10) unsigned DEFAULT NULL, `start_date` datetime DEFAULT NULL, `duration` int(10) unsigned DEFAULT NULL, `flight_type_id` int(10) 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, `comments` varchar(255) DEFAULT NULL, `airborne` tinyint(1) unsigned DEFAULT NULL, `validated` tinyint(3) unsigned DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `flight_account_entry` ( `flight_id` int(10) unsigned NOT NULL DEFAULT '0', `account_entry_id` int(10) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `flight_hours_pricing` ( `id` int(10) unsigned NOT NULL, `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, `extra_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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `flight_tank_qty` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `flight_track` ( `flight_id` int(10) unsigned NOT NULL, `track_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `flight_type` ( `id` int(10) unsigned NOT NULL, `name` varchar(255) DEFAULT NULL, `order_num` int(11) DEFAULT NULL, `activated` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `flight_type_mandatory_validity_type` ( `flight_type_id` int(10) unsigned NOT NULL, `validity_type_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `import` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `ip_stopped` ( `id` int(10) unsigned NOT NULL, `ip` varchar(255) DEFAULT NULL, `counter` tinyint(1) unsigned NOT NULL, `expire_date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `journal` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `key_alert` ( `id` int(10) unsigned NOT NULL, `alert_date` datetime DEFAULT NULL, `STATUS` int(10) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `key_host` ( `id` tinyint(2) NOT NULL, `timeout` tinyint(2) unsigned NOT NULL DEFAULT '10', `num_key` tinyint(2) unsigned NOT NULL DEFAULT '8', `ipkey` varchar(50) DEFAULT NULL, `httpport` varchar(4) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `key_log` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `location` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `logger` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `login_stopped` ( `id` int(10) unsigned NOT NULL, `login` varchar(255) DEFAULT NULL, `counter` tinyint(3) unsigned NOT NULL, `expire_date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `map_logger_monitoring` ( `record_id` int(10) unsigned NOT NULL, `count_data` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `map_track` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `m_component` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `m_component_type` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `m_history` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `m_operation` ( `id` int(10) unsigned NOT NULL, `content` text, `m_component_type_id` int(10) unsigned NOT NULL, `order_num` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `nationality` ( `code` char(2) NOT NULL DEFAULT '', `label` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `payment_distribution` ( `payment_id` int(10) unsigned DEFAULT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `payment_type` ( `id` int(10) unsigned NOT NULL, `name` text, `text_field_label` text, `supplier` varchar(255) DEFAULT NULL, `only_admin` tinyint(1) unsigned NOT NULL DEFAULT '0', `order_num` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `person` ( `id` int(10) unsigned NOT NULL, `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 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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `person_awaiting_activation` ( `id` int(10) unsigned NOT NULL, `login` varchar(255) DEFAULT NULL, `ip` varchar(255) DEFAULT NULL, `code` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `product` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `profile_extra_field_join` ( `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', `extra_field_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `profile_profile_view` ( `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', `viewable_profile_id` bigint(20) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `profile_required_account_type` ( `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', `account_type_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `profile_resource_type_place` ( `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', `resource_type_id` int(10) unsigned NOT NULL, `place_num` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `profile_resource_type_view` ( `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', `viewable_resource_type_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `profile_validity_type_join` ( `profile_id` bigint(20) unsigned NOT NULL DEFAULT '0', `validity_type_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `psp_return` ( `id` int(10) unsigned NOT NULL, `psp_transaction_id` int(10) unsigned DEFAULT NULL, `bank_answer` text, `bank_misc` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `psp_transaction` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `regular_presence_inst_date` ( `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `resource` ( `id` int(10) unsigned NOT NULL, `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', `non_bookable` tinyint(1) unsigned NOT NULL DEFAULT '0', `virtual` tinyint(10) unsigned DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `resource_type` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `sale_2_stock` ( `id` int(10) unsigned NOT NULL, `product_id` int(10) unsigned DEFAULT NULL, `stock_id` int(10) unsigned NOT NULL, `stock_variation_qty_per_sale` float NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `sale_2_validity_type` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `sale_pricing` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `sale_pricing_product` ( `sale_pricing_id` int(10) unsigned NOT NULL DEFAULT '0', `product_id` int(10) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `sale_pricing_profile` ( `sale_pricing_id` int(10) unsigned NOT NULL, `profile_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `sale_trigger` ( `id` int(10) NOT NULL DEFAULT '0', `name` varchar(255) DEFAULT NULL, `event` varchar(255) DEFAULT NULL, `locked` tinyint(1) unsigned DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `statistic` ( `name` varchar(255) NOT NULL, `of_version` tinyint(3) NOT NULL DEFAULT '0', `value` decimal(15,2) DEFAULT '0.00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `status` ( `id` int(10) unsigned NOT NULL, `abbrev` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `order_num` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `stock` ( `id` int(10) unsigned NOT NULL, `label` varchar(255) DEFAULT NULL, `stock_type_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `stock_level` ( `id` int(10) unsigned NOT NULL, `stock_id` int(10) unsigned NOT NULL, `qty` float NOT NULL DEFAULT '0', `stock_date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `stock_type` ( `id` int(10) unsigned NOT NULL, `label` varchar(255) DEFAULT NULL, `unit` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `stock_variation` ( `id` int(10) unsigned NOT NULL, `stock_id` int(10) unsigned NOT NULL, `qty` float NOT NULL DEFAULT '0', `variation_date` datetime DEFAULT NULL, `validated` tinyint(1) unsigned DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `supplier_bill` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `supplier_bill_account_entry` ( `supplier_bill_id` int(10) unsigned NOT NULL, `account_entry_flow_id` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `supplier_bill_type` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `tank` ( `id` int(10) unsigned NOT NULL, `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' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `track_record` ( `id` int(10) unsigned NOT NULL, `box_id` int(10) unsigned DEFAULT '0', `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `track_record_data` ( `id` int(10) unsigned NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `uncomp_flight_type` ( `id1` int(10) unsigned DEFAULT NULL, `id2` int(10) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `validity` ( `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `validity_type` ( `id` int(10) unsigned NOT NULL, `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` varchar(255) DEFAULT NULL, `alert_on_login` int(10) DEFAULT '-2', `mandatory_access_control` tinyint(1) unsigned DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `variable` ( `id` int(11) NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `variable_value` ( `id` int(11) NOT NULL, `variable_id` int(11) NOT NULL, `assign_value` decimal(15,2) DEFAULT '0.00', `start_date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `web_feed` ( `id` int(10) unsigned NOT NULL, `channel_id` int(10) unsigned NOT NULL, `publication_date` datetime NOT NULL, `title` varchar(255) DEFAULT NULL, `content` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `web_feed_channel` ( `id` int(10) unsigned NOT NULL, `label` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `account` ADD PRIMARY KEY (`id`), ADD KEY `idx_owner_id` (`owner_id`); ALTER TABLE `accounting` ADD PRIMARY KEY (`id`); ALTER TABLE `accounting_profile` ADD PRIMARY KEY (`accounting_id`,`profile_id`); ALTER TABLE `account_entry` ADD PRIMARY KEY (`id`), ADD KEY `idx_account_date` (`account_date`), ADD KEY `idx_flow_id` (`flow_id`); ALTER TABLE `account_type` ADD PRIMARY KEY (`id`); ALTER TABLE `account_type_profile` ADD PRIMARY KEY (`account_type_id`,`profile_id`); ALTER TABLE `aircraft` ADD PRIMARY KEY (`id`); ALTER TABLE `aircraft_type` ADD PRIMARY KEY (`id`); ALTER TABLE `aircraft_type_validity_type` ADD PRIMARY KEY (`aircraft_type_id`,`validity_type_id`,`check_num`); ALTER TABLE `balance` ADD PRIMARY KEY (`account_id`,`balance_date_id`); ALTER TABLE `balance_date` ADD PRIMARY KEY (`id`); ALTER TABLE `booking` ADD PRIMARY KEY (`id`); ALTER TABLE `booking_account_entry` ADD PRIMARY KEY (`booking_id`,`account_entry_flow_id`); ALTER TABLE `budget` ADD PRIMARY KEY (`id`); ALTER TABLE `budget_group` ADD PRIMARY KEY (`id`); ALTER TABLE `club` ADD PRIMARY KEY (`id`); ALTER TABLE `criteria` ADD PRIMARY KEY (`id`); ALTER TABLE `criteria_profile` ADD PRIMARY KEY (`criteria_id`,`profile_id`); ALTER TABLE `customer_bill_entry` ADD PRIMARY KEY (`id`), ADD KEY `idx_account_entry_id` (`account_entry_id`), ADD KEY `idx_account_entry_flow_id` (`account_entry_flow_id`); ALTER TABLE `customer_bill_file` ADD PRIMARY KEY (`id`); ALTER TABLE `default_display` ADD PRIMARY KEY (`person_id`,`display_key`); ALTER TABLE `default_multi_display` ADD PRIMARY KEY (`resource_type`,`person_id`,`resource_id`); ALTER TABLE `extra_field` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `variable` (`variable`); ALTER TABLE `extra_field_content` ADD PRIMARY KEY (`category_id`,`extra_field_id`); ALTER TABLE `extra_field_profile` ADD PRIMARY KEY (`extra_field_id`,`booking_popup_display_4_profile_id`); ALTER TABLE `facebook` ADD PRIMARY KEY (`id`); ALTER TABLE `favorite_icao` ADD PRIMARY KEY (`icao`); ALTER TABLE `fhp_aircraft_type` ADD PRIMARY KEY (`fhp_id`,`aircraft_type_id`); ALTER TABLE `fhp_flight_type` ADD PRIMARY KEY (`fhp_id`,`flight_type_id`); ALTER TABLE `fhp_profile` ADD PRIMARY KEY (`fhp_id`,`profile_id`,`place_num`); ALTER TABLE `file` ADD PRIMARY KEY (`id`); ALTER TABLE `flight` ADD PRIMARY KEY (`id`); ALTER TABLE `flight_account_entry` ADD PRIMARY KEY (`flight_id`,`account_entry_id`), ADD KEY `idx_account_entry_id` (`account_entry_id`); ALTER TABLE `flight_hours_pricing` ADD PRIMARY KEY (`id`); ALTER TABLE `flight_pilot` ADD PRIMARY KEY (`flight_id`,`pilot_id`,`num`); ALTER TABLE `flight_tank_qty` ADD PRIMARY KEY (`id`); ALTER TABLE `flight_track` ADD PRIMARY KEY (`track_id`,`flight_id`); ALTER TABLE `flight_type` ADD PRIMARY KEY (`id`); ALTER TABLE `flight_type_mandatory_validity_type` ADD PRIMARY KEY (`flight_type_id`,`validity_type_id`); ALTER TABLE `import` ADD PRIMARY KEY (`id`); ALTER TABLE `ip_stopped` ADD PRIMARY KEY (`id`); ALTER TABLE `journal` ADD PRIMARY KEY (`id`), ADD KEY `idx_date_log` (`date_log`), ADD KEY `idx_action` (`action`(8)); ALTER TABLE `key_alert` ADD PRIMARY KEY (`id`); ALTER TABLE `key_assignment` ADD PRIMARY KEY (`key_id`); ALTER TABLE `key_host` ADD PRIMARY KEY (`id`); ALTER TABLE `key_log` ADD PRIMARY KEY (`id`); ALTER TABLE `location` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `icao_name` (`icao_name`); ALTER TABLE `log` ADD KEY `journal_id` (`journal_id`); ALTER TABLE `logger` ADD PRIMARY KEY (`id`); ALTER TABLE `login_stopped` ADD PRIMARY KEY (`id`); ALTER TABLE `map_logger_monitoring` ADD PRIMARY KEY (`record_id`); ALTER TABLE `map_track` ADD PRIMARY KEY (`id`); ALTER TABLE `m_component` ADD PRIMARY KEY (`id`); ALTER TABLE `m_component_type` ADD PRIMARY KEY (`id`); ALTER TABLE `m_component_type_parentality` ADD PRIMARY KEY (`m_component_type_id`,`m_component_type_parent_id`); ALTER TABLE `m_history` ADD PRIMARY KEY (`id`); ALTER TABLE `m_operation` ADD PRIMARY KEY (`id`); ALTER TABLE `nationality` ADD PRIMARY KEY (`code`); ALTER TABLE `parameter` ADD PRIMARY KEY (`code`,`key_id`); ALTER TABLE `payment_type` ADD PRIMARY KEY (`id`); ALTER TABLE `person` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_name` (`name`); ALTER TABLE `person_awaiting_activation` ADD PRIMARY KEY (`id`); ALTER TABLE `product` ADD PRIMARY KEY (`id`); ALTER TABLE `profile` ADD PRIMARY KEY (`id`); ALTER TABLE `profile_extra_field_join` ADD PRIMARY KEY (`profile_id`,`extra_field_id`); ALTER TABLE `profile_profile_view` ADD PRIMARY KEY (`profile_id`,`viewable_profile_id`); ALTER TABLE `profile_required_account_type` ADD PRIMARY KEY (`profile_id`,`account_type_id`); ALTER TABLE `profile_resource_type_place` ADD PRIMARY KEY (`profile_id`,`resource_type_id`,`place_num`); ALTER TABLE `profile_resource_type_view` ADD PRIMARY KEY (`profile_id`,`viewable_resource_type_id`); ALTER TABLE `profile_validity_type_join` ADD PRIMARY KEY (`profile_id`,`validity_type_id`); ALTER TABLE `profile_validity_type_notification` ADD PRIMARY KEY (`profile_id`,`validity_type_id`); ALTER TABLE `psp_return` ADD PRIMARY KEY (`id`); ALTER TABLE `psp_transaction` ADD PRIMARY KEY (`id`); ALTER TABLE `resource` ADD PRIMARY KEY (`id`); ALTER TABLE `resource_type` ADD PRIMARY KEY (`id`); ALTER TABLE `resource_type_place_tag` ADD PRIMARY KEY (`resource_type_id`,`place_num`); ALTER TABLE `sale_2_stock` ADD PRIMARY KEY (`id`); ALTER TABLE `sale_2_validity_type` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `validity_type_id` (`validity_type_id`), ADD KEY `idx_product` (`product_id`); ALTER TABLE `sale_pricing` ADD PRIMARY KEY (`id`); ALTER TABLE `sale_pricing_product` ADD PRIMARY KEY (`sale_pricing_id`,`product_id`); ALTER TABLE `sale_pricing_profile` ADD PRIMARY KEY (`sale_pricing_id`,`profile_id`); ALTER TABLE `sale_trigger` ADD PRIMARY KEY (`id`); ALTER TABLE `statistic` ADD PRIMARY KEY (`name`,`of_version`); ALTER TABLE `status` ADD PRIMARY KEY (`id`); ALTER TABLE `stock` ADD PRIMARY KEY (`id`); ALTER TABLE `stock_level` ADD PRIMARY KEY (`id`); ALTER TABLE `stock_type` ADD PRIMARY KEY (`id`); ALTER TABLE `stock_variation` ADD PRIMARY KEY (`id`); ALTER TABLE `stock_variation_account_entry` ADD PRIMARY KEY (`product_id`,`stock_variation_id`,`account_entry_flow_id`), ADD KEY `idx_account_entry_flow_id` (`account_entry_flow_id`); ALTER TABLE `supplier_bill` ADD PRIMARY KEY (`id`); ALTER TABLE `supplier_bill_account_entry` ADD PRIMARY KEY (`supplier_bill_id`,`account_entry_flow_id`), ADD KEY `idx_account_entry_flow_id` (`account_entry_flow_id`); ALTER TABLE `supplier_bill_type` ADD PRIMARY KEY (`id`); ALTER TABLE `tank` ADD PRIMARY KEY (`id`); ALTER TABLE `track_record` ADD PRIMARY KEY (`id`), ADD KEY `idx_box_id` (`box_id`); ALTER TABLE `track_record_data` ADD PRIMARY KEY (`id`), ADD KEY `idx_record_id` (`record_id`); ALTER TABLE `validity` ADD PRIMARY KEY (`person_id`,`validity_type_id`); ALTER TABLE `validity_type` ADD PRIMARY KEY (`id`); ALTER TABLE `variable` ADD PRIMARY KEY (`id`); ALTER TABLE `variable_value` ADD PRIMARY KEY (`id`); ALTER TABLE `web_feed` ADD PRIMARY KEY (`id`); ALTER TABLE `web_feed_channel` ADD PRIMARY KEY (`id`); ALTER TABLE `account` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `accounting` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `account_entry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `account_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `balance_date` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `booking` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `budget` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `budget_group` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `criteria` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `customer_bill_entry` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `customer_bill_file` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `extra_field` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `facebook` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `file` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `flight` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `flight_hours_pricing` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `flight_tank_qty` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `import` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `ip_stopped` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `journal` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `key_alert` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `key_host` MODIFY `id` tinyint(2) NOT NULL AUTO_INCREMENT; ALTER TABLE `key_log` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `location` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `logger` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `login_stopped` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `map_track` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `m_component` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `m_component_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `m_history` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `m_operation` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `payment_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `person` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `person_awaiting_activation` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `product` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `psp_return` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `psp_transaction` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `resource` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `resource_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `sale_2_stock` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `sale_2_validity_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `sale_pricing` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `status` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `stock` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `stock_level` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `stock_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `stock_variation` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `supplier_bill` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `supplier_bill_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `tank` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `track_record` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `track_record_data` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `validity_type` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `variable` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `variable_value` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `web_feed` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT; ALTER TABLE `web_feed_channel` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;