CREATE TABLE `categorie` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `commande` (
  `commande_id` int(10) NOT NULL AUTO_INCREMENT,
  `code_commande` varchar(50) NOT NULL,
  `status` varchar(1) DEFAULT '1',
  `nom` varchar(50) NOT NULL,
  `prenom` varchar(50) NOT NULL,
  `pays` varchar(50) DEFAULT NULL,
  `adress` varchar(5000) DEFAULT NULL,
  `wilaya` varchar(50) DEFAULT NULL,
  `commune` varchar(50) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `mail` varchar(50) DEFAULT NULL,
  `methode_payement` varchar(50) DEFAULT NULL,
  `code_promo` varchar(50) DEFAULT NULL,
  `news_lettre` varchar(1) DEFAULT NULL,
  `date_valide_commande` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `observation` varchar(2000) DEFAULT '',
  `type` int(1) NOT NULL DEFAULT 1,
  `ip` varchar(20) DEFAULT '',
  PRIMARY KEY (`commande_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5015 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ciCREATE TABLE `contact` (
  `contact_id` int(10) NOT NULL AUTO_INCREMENT,
  `mail` varchar(100) DEFAULT NULL,
  `localisation` varchar(100) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `fax` varchar(50) DEFAULT NULL,
  `facebook` varchar(100) DEFAULT NULL,
  `instagram` varchar(100) DEFAULT NULL,
  `twitter` varchar(100) DEFAULT NULL,
  `youtube` varchar(100) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`contact_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `controllers` (
  `controller_id` int(11) NOT NULL AUTO_INCREMENT,
  `controller_name` varchar(200) NOT NULL,
  `c_name` varchar(100) NOT NULL,
  `order_c` int(11) DEFAULT 0,
  `icon_c` varchar(20) DEFAULT '',
  `level` varchar(1) NOT NULL,
  `parent_id` int(11) DEFAULT 0,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`controller_id`),
  UNIQUE KEY `controller_name` (`controller_name`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `controllers_methodes_privilege` (
  `controllers_methodes_privilege_id` int(11) NOT NULL AUTO_INCREMENT,
  `methode_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `show_methode` varchar(1) DEFAULT '0',
  `add_methode` varchar(1) DEFAULT '0',
  `update_methode` varchar(1) DEFAULT '0',
  `validate_methode` varchar(1) DEFAULT '0',
  `cancel_methode` varchar(1) DEFAULT '0',
  `print_methode` varchar(1) DEFAULT '0',
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`controllers_methodes_privilege_id`),
  KEY `methode_id` (`methode_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `couleur` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) DEFAULT NULL,
  `photo` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=220 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `evenements` (
  `event_id` int(10) NOT NULL AUTO_INCREMENT,
  `titre` varchar(50) NOT NULL,
  `localisation` varchar(50) NOT NULL,
  `date` date NOT NULL,
  `status` varchar(1) DEFAULT '1',
  `photo` varchar(50) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `fonctionalite` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `gallery` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `product_id` int(10) NOT NULL,
  `path` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3263 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `gallery_events` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `event_id` int(10) NOT NULL,
  `path` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `history` (
  `history_id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(11) NOT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `code` varchar(300) DEFAULT NULL,
  `v` varchar(100) DEFAULT NULL,
  `og` varchar(100) DEFAULT NULL,
  `ot` int(11) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`history_id`),
  KEY `users_id` (`users_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6332 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `marque` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) DEFAULT NULL,
  `photo` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `matiere` (
  `matiere_id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`matiere_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `methodes` (
  `methode_id` int(11) NOT NULL AUTO_INCREMENT,
  `controller_id` int(11) NOT NULL,
  `methode_name` varchar(200) NOT NULL,
  `m_name` varchar(100) NOT NULL,
  `exist_show` varchar(1) DEFAULT '0',
  `exist_add` varchar(1) DEFAULT '0',
  `exist_update` varchar(1) DEFAULT '0',
  `exist_validate` varchar(1) DEFAULT '0',
  `exist_cancel` varchar(1) DEFAULT '0',
  `exist_print` varchar(1) DEFAULT '0',
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`methode_id`),
  KEY `controller_id` (`controller_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `mouvement` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `prod_commande` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `commande_id` int(10) DEFAULT NULL,
  `quantite_commande` int(20) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `product_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `info_id` (`commande_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5018 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ciCREATE TABLE `products` (
  `product_id` int(10) NOT NULL AUTO_INCREMENT,
  `reference` varchar(20) NOT NULL,
  `libelle` varchar(20) NOT NULL,
  `prix` int(100) DEFAULT NULL,
  `genre` varchar(1) DEFAULT NULL,
  `quantite` int(20) DEFAULT NULL,
  `marque_id` varchar(10) DEFAULT NULL,
  `fonctionalite_id` int(10) DEFAULT NULL,
  `mouvement_id` int(10) DEFAULT NULL,
  `bracelet_id` int(10) DEFAULT NULL,
  `verre_montres_id` int(10) DEFAULT NULL,
  `couleur_id` int(10) DEFAULT NULL,
  `matiere_id_bras` int(10) DEFAULT NULL,
  `matiere_id_monture` int(10) DEFAULT NULL,
  `categorie_id` int(10) DEFAULT NULL,
  `categorie_prod` varchar(10) DEFAULT '1',
  `photo` varchar(50) DEFAULT NULL,
  `taille_boitier_montre` varchar(100) DEFAULT NULL,
  `taille_montre` varchar(100) DEFAULT NULL,
  `etanchiete` varchar(100) DEFAULT NULL,
  `garantie_montre` varchar(20) DEFAULT NULL,
  `designation_montre` varchar(1000) DEFAULT NULL,
  `couleur_bracelet` int(20) DEFAULT NULL,
  `couleur_cadran` int(20) DEFAULT NULL,
  `couleur_boitier` int(20) DEFAULT NULL,
  `dimension` varchar(15) DEFAULT NULL,
  `couleur_monture` int(20) DEFAULT NULL,
  `couleur_bras` int(20) DEFAULT NULL,
  `couleur_verre` int(20) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `new_prod` varchar(2) DEFAULT '1',
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `reference` (`reference`),
  UNIQUE KEY `libelle` (`libelle`),
  KEY `couleur_id` (`couleur_id`),
  KEY `matiere_id_monture` (`matiere_id_monture`),
  KEY `matiere_id_bras` (`matiere_id_bras`),
  KEY `categorie_id` (`categorie_id`),
  KEY `marque_id` (`marque_id`),
  KEY `fonctionalite_id` (`fonctionalite_id`),
  KEY `mouvement_id` (`mouvement_id`),
  KEY `bracelet_id` (`bracelet_id`),
  KEY `verre_montres_id` (`verre_montres_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2608 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ciCREATE TABLE `promotion` (
  `promotion_id` int(10) NOT NULL AUTO_INCREMENT,
  `product_id` int(10) NOT NULL,
  `valeur_promo` int(10) NOT NULL,
  `debut_promo` date NOT NULL,
  `fin_promo` date NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`promotion_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=335 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ciCREATE TABLE `review` (
  `review_id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) DEFAULT NULL,
  `prenom` varchar(50) DEFAULT NULL,
  `comment` varchar(1000) DEFAULT NULL,
  `nature` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT '1',
  `photo` varchar(500) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `slider` (
  `slide_id` int(10) NOT NULL AUTO_INCREMENT,
  `description` varchar(2000) DEFAULT NULL,
  `titre_button` varchar(2000) NOT NULL,
  `lien` varchar(500) NOT NULL,
  `photo` varchar(500) NOT NULL,
  `status` varchar(1) DEFAULT '1',
  `priority` varchar(50) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`slide_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `type_bracelet` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `type_service` (
  `type_service_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(100) NOT NULL,
  `designation` varchar(300) DEFAULT '',
  `type_created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `type_updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`type_service_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` char(64) NOT NULL,
  `full_name` varchar(100) NOT NULL,
  `type_service_id` int(11) NOT NULL,
  `photo` varchar(50) DEFAULT 'profil.png',
  `phone` varchar(50) DEFAULT '+213 06 60 00 00 00',
  `type` varchar(1) DEFAULT '0',
  `status` varchar(1) DEFAULT '0',
  `last_connexion` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `signature` varchar(100) DEFAULT NULL,
  `abbreviation` varchar(1) DEFAULT '0',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  KEY `type_service_id` (`type_service_id`)
) ENGINE=MyISAM AUTO_INCREMENT=168 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciCREATE TABLE `verre_montre` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ciDatabase transfer completed successfully.