--
-- Host: 127.0.0.1    Database: db_access_02709
-- ------------------------------------------------------


--
-- Table structure for table `info_society_copy`
--

CREATE TABLE `info_society_copy` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name_society` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `pseudo` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `info_societies_name_society_unique` (`name_society`),
  UNIQUE KEY `info_societies_pseudo_unique` (`pseudo`),
  UNIQUE KEY `info_societies_email_unique` (`email`),
  UNIQUE KEY `info_societies_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `info_society_copy`
--

INSERT INTO `info_society_copy` VALUES (1,'SOLVEN','nsangu','dave','dan','chrisnyangss@gmail.com','$2y$12$7qPhSF9V.sdqArq57ukW0O8eGq2infu4lrIoscPNvFwF82eP0/Kx6','+243815663001','RDC',0,'2023-12-11 00:38:36','2023-12-11 14:02:50'),(2,'BDOM','adi','adi','adi','chrisnyangslll@gmail.com','$2y$12$07YLElVTKNKJm1DVkHU.uuc6lOHepNYiEXzoFLK/9AL7qYyQizEg.','25666','RDC',0,'2023-12-11 14:08:31','2023-12-11 14:18:11'),(3,'MDE SERVICES','kapena','patrick','patrick','chrisnyangs@gmail.com','$2y$12$KLiyHFQdQcvdpRJDTzgfEeW/v4NgM.LujTHfYNQm2AR.4oTouPEWq','25566','RDC',0,'2023-12-11 14:34:20',NULL);


