--
-- Host: localhost    Database: socomea
-- ------------------------------------------------------


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `firstName` text NOT NULL,
  `lastName` text NOT NULL,
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `password` text NOT NULL,
  `social_facebook` text,
  `social_instagram` text,
  `social_linkedin` text,
  `social_pinterest` text,
  `social_reddit` text,
  `social_snapchat` text,
  `social_tiktok` text,
  `social_twitter_x` text,
  `social_whatsapp` text,
  `social_youtube` text,
  `email_verified` tinyint(1) NOT NULL DEFAULT '0',
  `phone_verified` tinyint(1) NOT NULL DEFAULT '0',
  `created_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`(255)),
  UNIQUE KEY `email` (`email`(255)),
  UNIQUE KEY `phone` (`phone`(255))
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'Vince','Vincer','Vincer','asdf@asdfasdf.com','999-999-9999','Socomea1207@!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2024-11-04 08:02:09','2024-11-04 09:33:59'),(3,'Tabitha','Tabitha','Castillo','tkcastillo08@yahoo.com','813-325-1193','Tabi1207rocks@!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2024-11-04 09:53:41','2024-11-04 09:53:41');


