#!/usr/bin/env php === CONNEXION RÉUSSIE À LA BASE DE DONNÉES === Base de données: aef_new Hôte: nj151-003.eu.clouddb.ovh.net:35649 === TABLES DISPONIBLES === - alerts - annonce - annonce_category - annonce_image - annonce_translation - audit_log - cart - cart_item - category - category_translation - command - contact_message - contact_thread - doctrine_migration_versions - geo_city - geo_country - geo_country_translation - geo_departement - geo_departement_translation - geo_region - geo_region_translation - item - item_categories - item_favorite - item_image - item_item_tag - item_period - item_period_translation - item_periods - item_statistics - item_style - item_style_translation - item_styles - item_tag - item_template - item_translation - jzadmin_users - mag - mag_category - mag_category_translation - mag_translation - member - member_member_specialty - member_specialties - member_specialty_translation - member_statistics - member_translation - member_trial - messenger_messages - news_post_translation - news_posts - newsletter_subscription - order_item - order_table - payment_failure - payments - paypal_payment - paypal_webhook - plan_configuration - quote_negotiation - shipping_quote - shipping_rule - shipping_zone - statistic_snapshots - stripe_event - subscription - temp_item_i18n_old - temp_item_old - user - users - wishlist - wishlist_item === ANALYSE DES TABLES D'IMPORT === --- Table: geo_country --- Colonnes: - id: int NOT NULL - name: varchar(100) NOT NULL - code: varchar(2) NOT NULL - iso3: varchar(3) NOT NULL - currency: varchar(10) NULL - locale: varchar(10) NULL - timezone: varchar(20) NULL - active: tinyint(1) NOT NULL - sort_order: int NOT NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: geo_country_translation --- Colonnes: - id: int NOT NULL - geo_country_id: int NOT NULL - locale: varchar(2) NOT NULL - name: varchar(255) NOT NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: geo_region --- Colonnes: - id: int NOT NULL - country_id: int NOT NULL - name: varchar(100) NOT NULL - code: varchar(10) NULL - active: tinyint(1) NOT NULL - sort_order: int NOT NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: geo_region_translation --- Colonnes: - id: int NOT NULL - geo_region_id: int NOT NULL - locale: varchar(2) NOT NULL - name: varchar(255) NOT NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: category --- Colonnes: - id: int NOT NULL - parent_id: int NULL - name: varchar(255) NOT NULL - slug: varchar(255) NOT NULL - description: longtext NULL - image: varchar(255) NULL - sort_order: int NOT NULL - is_active: tinyint(1) NOT NULL Enregistrements: 0 --- Table: category_translation --- Colonnes: - id: int NOT NULL - category_id: int NOT NULL - locale: varchar(2) NOT NULL - name: varchar(255) NOT NULL - description: longtext NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: item_style --- Colonnes: - id: int NOT NULL - name: varchar(100) NOT NULL - slug: varchar(100) NOT NULL - description: longtext NULL - start_year: int NULL - end_year: int NULL - active: tinyint(1) NOT NULL - sort_order: int NOT NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: item_style_translation --- Colonnes: - id: int NOT NULL - item_style_id: int NOT NULL - locale: varchar(2) NOT NULL - name: varchar(255) NOT NULL - description: longtext NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: item_period --- Colonnes: - id: int NOT NULL - name: varchar(100) NOT NULL - slug: varchar(100) NOT NULL - description: longtext NULL - start_year: int NULL - end_year: int NULL - century: varchar(10) NULL - active: tinyint(1) NOT NULL - sort_order: int NOT NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 --- Table: item_period_translation --- Colonnes: - id: int NOT NULL - item_period_id: int NOT NULL - locale: varchar(2) NOT NULL - name: varchar(255) NOT NULL - description: longtext NULL - created_at: datetime NOT NULL - updated_at: datetime NOT NULL Enregistrements: 0 === TABLES SIMILAIRES TROUVÉES === Tables contenant 'geo_': - geo_city - geo_country - geo_country_translation - geo_departement - geo_departement_translation - geo_region - geo_region_translation Tables contenant 'category': - annonce_category - category - category_translation - mag_category - mag_category_translation Tables contenant 'item_': - item_categories - item_favorite - item_image - item_item_tag - item_period - item_period_translation - item_periods - item_statistics - item_style - item_style_translation - item_styles - item_tag - item_template - item_translation - temp_item_i18n_old - temp_item_old Tables contenant 'translation': - annonce_translation - category_translation - geo_country_translation - geo_departement_translation - geo_region_translation - item_period_translation - item_style_translation - item_translation - mag_category_translation - mag_translation - member_specialty_translation - member_translation - news_post_translation