public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_outings_archives');
     $this->hasColumn('outing_archive_id', 'integer', 11);
     $this->hasColumn('date', 'date', null);
     $this->hasColumn('activities', 'string', null);
     // array
     $this->hasColumn('height_diff_up', 'smallint', null);
     $this->hasColumn('height_diff_down', 'smallint', null);
     $this->hasColumn('outing_length', 'integer', 6);
     $this->hasColumn('min_elevation', 'smallint', 4);
     $this->hasColumn('max_elevation', 'smallint', 4);
     $this->hasColumn('partial_trip', 'boolean', null);
     $this->hasColumn('hut_status', 'smallint', 1);
     $this->hasColumn('frequentation_status', 'smallint', 1);
     $this->hasColumn('conditions_status', 'smallint', 1);
     $this->hasColumn('access_status', 'smallint', 1);
     $this->hasColumn('access_elevation', 'smallint', 4);
     $this->hasColumn('lift_status', 'smallint', 1);
     $this->hasColumn('glacier_status', 'smallint', 1);
     $this->hasColumn('up_snow_elevation', 'smallint', 4);
     $this->hasColumn('down_snow_elevation', 'smallint', 4);
     $this->hasColumn('track_status', 'smallint', 1);
     $this->hasColumn('outing_with_public_transportation', 'boolean', null);
     $this->hasColumn('avalanche_date', 'string', null);
     // array
     $this->hasColumn('v4_id', 'smallint', 5);
     $this->hasColumn('v4_app', 'string', 3);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_sites_archives');
     $this->hasColumn('site_archive_id', 'integer', 11);
     $this->hasColumn('routes_quantity', 'smallint', 4);
     $this->hasColumn('max_rating', 'smallint', 2);
     $this->hasColumn('min_rating', 'smallint', 2);
     $this->hasColumn('mean_rating', 'smallint', 2);
     $this->hasColumn('max_height', 'smallint', 4);
     $this->hasColumn('min_height', 'smallint', 4);
     $this->hasColumn('mean_height', 'smallint', 4);
     $this->hasColumn('equipment_rating', 'smallint', 1);
     $this->hasColumn('climbing_styles', 'string', null);
     // array in DB but Doctrine sees it as a string
     $this->hasColumn('rock_types', 'string', null);
     // array
     $this->hasColumn('site_types', 'string', null);
     // array
     $this->hasColumn('children_proof', 'smallint', 1);
     $this->hasColumn('rain_proof', 'smallint', 1);
     $this->hasColumn('facings', 'string', null);
     // array
     $this->hasColumn('best_periods', 'string', null);
     // array
     $this->hasColumn('v4_id', 'smallint', 5);
     $this->hasColumn('v4_type', 'string', 4);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_images_archives');
     $this->hasColumn('image_archive_id', 'integer', 11);
     $this->hasColumn('filename', 'string', null);
     $this->hasColumn('has_svg', 'boolean', null);
     $this->hasColumn('width', 'smallint', null);
     $this->hasColumn('height', 'smallint', null);
     $this->hasColumn('file_size', 'integer', null);
     $this->hasColumn('categories', 'string', null);
     // array
     $this->hasColumn('camera_name', 'string', 100);
     $this->hasColumn('exposure_time', 'double', null);
     $this->hasColumn('fnumber', 'double', null);
     $this->hasColumn('focal_length', 'double', null);
     $this->hasColumn('iso_speed', 'smallint', 4);
     $this->hasColumn('date_time', 'timestamp', null);
     $this->hasColumn('image_type', 'smallint');
     $this->hasColumn('v4_id', 'smallint', 5);
     $this->hasColumn('v4_app', 'string', 3);
     $this->hasColumn('activities', 'string', null);
     // array
     $this->hasColumn('author', 'string', 100);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_areas_archives');
     $this->hasColumn('area_archive_id', 'integer', 11);
     $this->hasColumn('area_type', 'smallint', 1);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_products_archives');
     $this->hasColumn('product_type', 'string', null);
     // array
     $this->hasColumn('url', 'string', 255);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_summits_archives');
     $this->hasColumn('summit_archive_id', 'integer', 11);
     $this->hasColumn('summit_type', 'smallint', null);
     $this->hasColumn('maps_info', 'string', 300);
     $this->hasColumn('v4_id', 'smallint', 5);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_maps_archives');
     $this->hasColumn('map_archive_id', 'integer', 11);
     $this->hasColumn('editor', 'string', 20);
     $this->hasColumn('scale', 'integer', null);
     $this->hasColumn('code', 'string', 20);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_users_archives');
     $this->hasColumn('user_archive_id', 'integer', 11);
     $this->hasColumn('v4_id', 'smallint', 5);
     $this->hasColumn('activities', 'string', null);
     // array
     $this->hasColumn('category', 'smallint', 1);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_articles_archives');
     $this->hasColumn('article_archive_id', 'integer', 11);
     $this->hasColumn('categories', 'string', null);
     // array
     $this->hasColumn('activities', 'string', null);
     // array
     $this->hasColumn('article_type', 'integer', 1);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_parkings_archives');
     $this->hasColumn('parking_archive_id', 'integer', 11);
     $this->hasColumn('public_transportation_rating', 'smallint', 1);
     $this->hasColumn('public_transportation_types', 'string', null);
     // array
     $this->hasColumn('snow_clearance_rating', 'smallint', 1);
     $this->hasColumn('lowest_elevation', 'smallint', 4);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_books_archives');
     $this->hasColumn('book_archive_id', 'integer', 11);
     $this->hasColumn('author', 'string', 100);
     $this->hasColumn('editor', 'string', 100);
     $this->hasColumn('activities', 'string', null);
     // array
     $this->hasColumn('url', 'string', 255);
     $this->hasColumn('isbn', 'string', 17);
     $this->hasColumn('langs', 'string', null);
     // array
     $this->hasColumn('book_types', 'string', null);
     // array
     $this->hasColumn('publication_date', 'string', 100);
     $this->hasColumn('nb_pages', 'small_int', null);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_huts_archives');
     $this->hasColumn('hut_archive_id', 'integer', 11);
     $this->hasColumn('shelter_type', 'integer', 1);
     $this->hasColumn('is_staffed', 'boolean', null);
     $this->hasColumn('phone', 'string', 50);
     $this->hasColumn('url', 'string', 255);
     $this->hasColumn('staffed_capacity', 'smallint', 3);
     $this->hasColumn('unstaffed_capacity', 'smallint', 2);
     $this->hasColumn('has_unstaffed_matress', 'samllint', 1);
     $this->hasColumn('has_unstaffed_blanket', 'samllint', 1);
     $this->hasColumn('has_unstaffed_gas', 'samllint', 1);
     $this->hasColumn('has_unstaffed_wood', 'samllint', 1);
     $this->hasColumn('activities', 'string', null);
     // array
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_routes_archives');
     $this->hasColumn('route_archive_id', 'integer', 11);
     $this->hasColumn('facing', 'smallint', null);
     $this->hasColumn('activities', 'string', null);
     // array in DB but Doctrine sees it as a string
     $this->hasColumn('height_diff_up', 'smallint', null);
     $this->hasColumn('height_diff_down', 'smallint', null);
     $this->hasColumn('route_type', 'smallint', null);
     $this->hasColumn('route_length', 'integer', 5);
     $this->hasColumn('min_elevation', 'smallint', null);
     $this->hasColumn('max_elevation', 'smallint', null);
     $this->hasColumn('duration', 'smallint', null);
     $this->hasColumn('slope', 'string', 100);
     $this->hasColumn('difficulties_height', 'smallint', null);
     $this->hasColumn('configuration', 'string', null);
     // array
     $this->hasColumn('global_rating', 'smallint', null);
     $this->hasColumn('engagement_rating', 'smallint', null);
     $this->hasColumn('objective_risk_rating', 'smallin', null);
     $this->hasColumn('equipment_rating', 'smallint', null);
     $this->hasColumn('is_on_glacier', 'boolean', null);
     $this->hasColumn('sub_activities', 'string', null);
     // array
     $this->hasColumn('toponeige_technical_rating', 'smallint', null);
     $this->hasColumn('toponeige_exposition_rating', 'smallint', null);
     $this->hasColumn('labande_ski_rating', 'smallint', null);
     $this->hasColumn('labande_global_rating', 'smallint', null);
     $this->hasColumn('ice_rating', 'smallint', null);
     $this->hasColumn('mixed_rating', 'smallint', null);
     $this->hasColumn('rock_free_rating', 'smallint', null);
     $this->hasColumn('rock_required_rating', 'smallint', null);
     $this->hasColumn('aid_rating', 'smallint', null);
     $this->hasColumn('rock_exposition_rating', 'smallint', null);
     $this->hasColumn('hiking_rating', 'smallint', null);
     $this->hasColumn('snowshoeing_rating', 'smallint', null);
 }
 public function setTableDefinition()
 {
     parent::setTableDefinition();
     $this->setTableName('app_portals_archives');
     $this->hasColumn('portal_archive_id', 'integer', 11);
     $this->hasColumn('activities', 'string', null);
     // array
     $this->hasColumn('has_map', 'boolean', null);
     $this->hasColumn('map_filter', 'string', 255);
     $this->hasColumn('topo_filter', 'string', 255);
     $this->hasColumn('nb_outings', 'small_int', null);
     $this->hasColumn('outing_filter', 'string', 255);
     $this->hasColumn('nb_images', 'small_int', null);
     $this->hasColumn('image_filter', 'string', 255);
     $this->hasColumn('nb_videos', 'small_int', null);
     $this->hasColumn('video_filter', 'string', 255);
     $this->hasColumn('nb_articles', 'small_int', null);
     $this->hasColumn('article_filter', 'string', 255);
     $this->hasColumn('nb_topics', 'small_int', null);
     $this->hasColumn('forum_filter', 'string', 255);
     $this->hasColumn('nb_news', 'small_int', null);
     $this->hasColumn('news_filter', 'string', 255);
     $this->hasColumn('design_file', 'string', 255);
 }