DB2.0

Jump to: navigation, search
 
-- 
-- 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` text,
  `activated` int(1) default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='List of account' AUTO_INCREMENT=28 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `account_aircraft`
-- 
 
CREATE TABLE `account_aircraft` (
  `aircraft_id` int(11) default NULL,
  `account_id` int(10) unsigned NOT NULL default '0',
  `account_type` int(10) unsigned default NULL,
  PRIMARY KEY  (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of aircraft accounts';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `account_aircraft_type`
-- 
 
CREATE TABLE `account_aircraft_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` text,
  `order_num` int(11) default NULL,
  `activated` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='account aircraft type description' AUTO_INCREMENT=4 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `account_club`
-- 
 
CREATE TABLE `account_club` (
  `account_id` int(10) unsigned NOT NULL default '0',
  `payment_allowed` tinyint(1) unsigned default '0',
  `order_num` int(11) default NULL,
  PRIMARY KEY  (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of club accounts';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `account_entry`
-- 
 
CREATE TABLE `account_entry` (
  `id` int(11) NOT NULL auto_increment,
  `double_entry_id` int(11) default NULL,
  `account_date` datetime default NULL,
  `account_id` int(11) default NULL,
  `credit` float default '0',
  `debit` float default '0',
  `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',
  PRIMARY KEY  (`id`),
  KEY `idx_account_date` (`account_date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='List of account entries' AUTO_INCREMENT=49 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `account_member`
-- 
 
CREATE TABLE `account_member` (
  `member_id` int(11) default NULL,
  `account_id` int(10) unsigned NOT NULL default '0',
  `account_type` int(10) unsigned default NULL,
  PRIMARY KEY  (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of member accounts';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `account_member_type`
-- 
 
CREATE TABLE `account_member_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` text,
  `order_num` int(11) default NULL,
  `activated` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='List of account member types' AUTO_INCREMENT=2 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `aircraft`
-- 
 
CREATE TABLE `aircraft` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `callsign` varchar(255) default NULL,
  `type` int(10) unsigned default NULL,
  `comments` varchar(255) default NULL,
  `order_num` int(11) default NULL,
  `non_bookable` tinyint(1) 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',
  `tolerance_time` int(11) unsigned default '6000',
  `last_counter` int(11) default NULL,
  `activated` tinyint(1) unsigned default '1',
  `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',
  `non_flightable` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `CALLSIGN` (`callsign`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='ALL AIRCRAFTS OF ALL AIRCLUBS' AUTO_INCREMENT=4 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `aircraft_type`
-- 
 
CREATE TABLE `aircraft_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `admin_desc` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `seats_available` tinyint(3) unsigned default '1',
  `comments` varchar(255) default NULL,
  `order_num` int(11) default NULL,
  `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',
  `activated` tinyint(1) unsigned NOT NULL default '1',
  `digit_counter_number` tinyint(1) unsigned NOT NULL default '4',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Types of aircraft' AUTO_INCREMENT=3 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `aircraft_type_allowed_function`
-- 
 
CREATE TABLE `aircraft_type_allowed_function` (
  `aircraft_type_id` int(10) unsigned default NULL,
  `place_num` int(10) unsigned default NULL,
  `function_id` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of allowed functions for each aircraft type';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `aircraft_type_mandatory_flight_type`
-- 
 
CREATE TABLE `aircraft_type_mandatory_flight_type` (
  `aircraft_type_id` int(10) unsigned default NULL,
  `flight_type_id` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of compulsory flight type for each aircraft type';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `aircraft_type_qualif`
-- 
 
CREATE TABLE `aircraft_type_qualif` (
  `aircraft_type_id` int(10) unsigned default NULL,
  `check_num` int(10) unsigned default NULL,
  `qualification_id` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Types of qualif required for each aircraft type';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `aircraft_type_uncomp_flight_type`
-- 
 
CREATE TABLE `aircraft_type_uncomp_flight_type` (
  `aircraft_type_id` int(10) unsigned default NULL,
  `flight_type_id` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of uncompatible flight type for each aircraft type';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `authentication`
-- 
 
CREATE TABLE `authentication` (
  `name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  `first_name` varchar(255) default NULL,
  `last_name` varchar(255) default NULL,
  `profile` mediumint(8) unsigned default NULL,
  `view_type` int(10) unsigned default NULL,
  `view_width` tinyint(3) unsigned NOT NULL default '12',
  `view_height` tinyint(4) unsigned NOT NULL default '30',
  `aircrafts_viewed` varchar(255) default NULL,
  `inst_viewed` varchar(255) default NULL,
  `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_id` char(2) default NULL,
  `total_flight_time` int(10) unsigned default '0',
  `date_total_flight_time` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='used for authentication' AUTO_INCREMENT=22 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `balance`
-- 
 
CREATE TABLE `balance` (
  `account_id` int(10) unsigned NOT NULL,
  `balance_date_id` int(10) unsigned NOT NULL default '0',
  `debit` float default '0',
  `credit` float default '0',
  PRIMARY KEY  (`account_id`,`balance_date_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- 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=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `booking`
-- 
 
CREATE TABLE `booking` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `start_date` datetime default NULL,
  `end_date` datetime default NULL,
  `aircraft_id` int(10) unsigned default NULL,
  `member_id` int(10) unsigned default NULL,
  `slot_type` tinyint(3) unsigned default NULL,
  `instructor_id` int(10) unsigned default NULL,
  `free_seats` tinyint(3) unsigned default NULL,
  `comments` varchar(255) default NULL,
  `airfield` varchar(6) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='RECORDS ALL THE SLOTS OF ALL AIRCRAFTS OF ALL AIRCLUBS' AUTO_INCREMENT=12 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `club`
-- 
 
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,
  `stylesheet_url` varchar(255) default NULL,
  `first_hour_displayed` time default NULL,
  `last_hour_displayed` time default NULL,
  `usual_profiles` mediumint(8) unsigned default NULL,
  `icao` varchar(6) default NULL,
  `default_slot_range` int(10) unsigned default NULL,
  `min_slot_range` tinyint(3) unsigned default NULL,
  `twilight_range` tinyint(3) unsigned default NULL,
  `mailing_list_name` varchar(255) default NULL,
  `mailing_list_type` varchar(255) default NULL,
  `club_site_url` varchar(255) default NULL,
  `default_timezone` varchar(255) NOT NULL,
  `lang` varchar(255) NOT 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` int(3) unsigned default NULL,
  `welcome_cell` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='DESCRIPTION OF ALL AIRCLUBS';
 
-- --------------------------------------------------------
 
-- 
-- 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,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `default_display`
-- 
 
CREATE TABLE `default_display` (
  `authentication_id` int(10) unsigned NOT NULL,
  `display_key` varchar(255) NOT NULL default '',
  `display_value` text,
  PRIMARY KEY  (`authentication_id`,`display_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `exceptionnal_inst_date`
-- 
 
CREATE TABLE `exceptionnal_inst_date` (
  `instructor_id` int(10) unsigned NOT NULL,
  `start_date` datetime default NULL,
  `end_date` datetime default NULL,
  `presence` tinyint(1) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `favorite_icao`
-- 
 
CREATE TABLE `favorite_icao` (
  `icao` varchar(6) character set latin1 NOT NULL,
  PRIMARY KEY  (`icao`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='favorite airfield list';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `fhp_aircraft_type`
-- 
 
CREATE TABLE `fhp_aircraft_type` (
  `fhp_id` int(10) default NULL,
  `aircraft_type_id` int(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='flight hour pricing aircraft type list';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `fhp_flight_type`
-- 
 
CREATE TABLE `fhp_flight_type` (
  `fhp_id` int(10) default NULL,
  `flight_type_id` int(10) default NULL,
  `excluded` tinyint(1) unsigned default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='flight hour pricing flight type list';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `fhp_member_pool`
-- 
 
CREATE TABLE `fhp_member_pool` (
  `fhp_id` int(10) default NULL,
  `member_pool_id` int(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='flight hour pricing flight type list';
 
-- --------------------------------------------------------
 
-- 
-- 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(10) unsigned default NULL,
  `flight_type_id` int(10) unsigned default NULL,
  `people_onboard` int(10) unsigned default NULL,
  `airfield_departure` varchar(6) default NULL,
  `airfield_arrival` varchar(6) 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',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='list of flight' AUTO_INCREMENT=37 ;
 
-- --------------------------------------------------------
 
-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='flight account entry join';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `flight_hours_pricing`
-- 
 
CREATE TABLE `flight_hours_pricing` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` text,
  `price_formula` text,
  `price_sentence` 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',
  `member_debited` tinyint(1) unsigned default '1',
  `order_num` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='list of flight hours pricing formula' AUTO_INCREMENT=18 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `flight_pilot`
-- 
 
CREATE TABLE `flight_pilot` (
  `flight_id` int(10) unsigned NOT NULL,
  `pilot_id` int(10) unsigned NOT NULL,
  `function_id` int(10) unsigned default NULL,
  `num` int(10) unsigned default NULL,
  PRIMARY KEY  (`flight_id`,`pilot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='list of crew for each flight';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `flight_tank_qty`
-- 
 
CREATE TABLE `flight_tank_qty` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `flight_id` int(10) unsigned NOT NULL,
  `tank_id` int(10) unsigned NOT NULL,
  `quantity` varchar(255) 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=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `flight_type`
-- 
 
CREATE TABLE `flight_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `order_num` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='list of flight type' AUTO_INCREMENT=65 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `flight_type_mandatory_qualification`
-- 
 
CREATE TABLE `flight_type_mandatory_qualification` (
  `flight_type_id` int(10) unsigned NOT NULL,
  `qualification_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`flight_type_id`,`qualification_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='list of mandatory qualification for each flight type';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `forget_flight`
-- 
 
CREATE TABLE `forget_flight` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `write_date` datetime default NULL,
  `aircraft_id` int(10) unsigned default NULL,
  `last_counter` int(10) unsigned default NULL,
  `new_counter` int(10) unsigned default NULL,
  `validated` tinyint(1) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='list of forget flight' AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `icao`
-- 
 
CREATE TABLE `icao` (
  `name` varchar(64) default NULL,
  `icao` varchar(6) NOT NULL,
  `lat` float default NULL,
  `lon` float default NULL,
  `alt` smallint(6) default NULL,
  PRIMARY KEY  (`icao`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='airfields coord';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `instructor`
-- 
 
CREATE TABLE `instructor` (
  `id` int(10) unsigned NOT NULL,
  `sign` varchar(255) default NULL,
  `order_num` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='LIST INSTRUCTORS AND THEIR AUTORIZATIONS';
 
-- --------------------------------------------------------
 
-- 
-- 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=MyISAM  DEFAULT CHARSET=latin1 COMMENT='BLACKLISTED IP' AUTO_INCREMENT=13 ;
 
-- --------------------------------------------------------
 
-- 
-- 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,
  `is_member` tinyint(1) unsigned default NULL,
  `is_instructor` tinyint(1) unsigned default NULL,
  `action` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_date_log` (`date_log`),
  KEY `idx_action` (`action`(8))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='list of logs' AUTO_INCREMENT=11337 ;
 
-- --------------------------------------------------------
 
-- 
-- 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 NOT NULL,
  PRIMARY KEY  (`key_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='key assignment description';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `key_host`
-- 
 
CREATE TABLE `key_host` (
  `id` tinyint(2) NOT NULL auto_increment,
  `timeout` tinyint(2) unsigned NOT NULL default '10',
  `num_key` tinyint(2) unsigned NOT NULL default '10',
  `ipkey` varchar(50) NOT NULL,
  `httpport` varchar(4) NOT NULL default '4080',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='key host configuration' AUTO_INCREMENT=2 ;
 
-- --------------------------------------------------------
 
-- 
-- 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` text,
  KEY `journal_id` (`journal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='part of logs';
 
-- --------------------------------------------------------
 
-- 
-- 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=MyISAM  DEFAULT CHARSET=latin1 COMMENT='BLACKLISTED LOGIN' AUTO_INCREMENT=13 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `member`
-- 
 
CREATE TABLE `member` (
  `id` int(10) unsigned NOT NULL,
  `member_num` int(11) default NULL,
  `subscription` date NOT NULL default '2003-12-31',
  `qualif_alert_delay` tinyint(3) unsigned NOT NULL default '8',
  `inscription_date` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='ALL MEMBERS OF ALL AIRCLUBS';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `member_awaiting_activation`
-- 
 
CREATE TABLE `member_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,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `member_pool`
-- 
 
CREATE TABLE `member_pool` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` text,
  `order_num` int(11) default NULL,
  `required_account_type` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='List of member pool' AUTO_INCREMENT=8 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `member_pool_join`
-- 
 
CREATE TABLE `member_pool_join` (
  `member_pool_id` int(10) unsigned default NULL,
  `member_id` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Correspondance between pools and members';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `member_qualif`
-- 
 
CREATE TABLE `member_qualif` (
  `member_id` int(10) unsigned NOT NULL,
  `qualif_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,
  PRIMARY KEY  (`member_id`,`qualif_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS OF EACH MEMBER';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `nationality`
-- 
 
CREATE TABLE `nationality` (
  `code` char(2) character set latin1 NOT NULL default '',
  `label` varchar(255) default NULL,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `parameter`
-- 
 
CREATE TABLE `parameter` (
  `code` varchar(255) NOT NULL,
  `enabled` tinyint(1) unsigned default '0',
  `int_value` int(10) unsigned default '0',
  `char_value` varchar(255) default NULL,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='APPLICATION PARAMETERS';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `payment_distribution`
-- 
 
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'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='payment distribution description';
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `payment_type`
-- 
 
CREATE TABLE `payment_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` text,
  `text_field_label` text,
  `order_num` int(11) default NULL,
  `supplier` varchar(255) default NULL,
  `only_admin` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='type of payment description' AUTO_INCREMENT=3 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `pilot_function`
-- 
 
CREATE TABLE `pilot_function` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `abbrev` varchar(10) default NULL,
  `name` varchar(100) default NULL,
  `order_num` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='List of functions for pilot' AUTO_INCREMENT=4 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `pricing_value`
-- 
 
CREATE TABLE `pricing_value` (
  `id` int(11) NOT NULL auto_increment,
  `variable_id` int(11) NOT NULL,
  `assign_value` decimal(10,2) NOT NULL,
  `start_date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `pricing_variable`
-- 
 
CREATE TABLE `pricing_variable` (
  `id` int(11) NOT NULL auto_increment,
  `variable` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `order_num` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `profile`
-- 
 
CREATE TABLE `profile` (
  `id` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) default NULL,
  `permits` int(10) unsigned default NULL,
  `permits2` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM 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',
  `bank_answer` varchar(255) default NULL,
  `bank_misc` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `qualification`
-- 
 
CREATE TABLE `qualification` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `time_limitation` tinyint(1) NOT NULL default '0',
  `order_num` int(11) default NULL,
  `ident_value_enable` tinyint(1) unsigned NOT NULL default '0',
  `grant_date_enable` tinyint(1) unsigned NOT NULL default '0',
  `is_for_instructor` tinyint(1) unsigned NOT NULL default '0',
  `mandatory` tinyint(1) unsigned NOT NULL default '0',
  `experience_formula` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='QUALIFICATIONS LIST' AUTO_INCREMENT=8 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `regular_presence_inst_date`
-- 
 
CREATE TABLE `regular_presence_inst_date` (
  `instructor_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=MyISAM DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `sale`
-- 
 
CREATE TABLE `sale` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `entry_id` int(10) unsigned default NULL,
  `unit_price` float default NULL,
  `quantity` float default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of sales' AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
-- 
-- 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,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
 
-- --------------------------------------------------------
 
-- 
-- 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=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of sales';