--
-- Host: localhost    Database: PROJ02
-- ------------------------------------------------------


--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `description` text,
  `organizer_email` varchar(200) NOT NULL,
  `room_number` varchar(30) NOT NULL,
  `event_date` date NOT NULL,
  `event_time` time NOT NULL,
  `expected_participants` int DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `approved` char(1) DEFAULT NULL,
  PRIMARY KEY (`room_number`,`event_date`,`event_time`),
  UNIQUE KEY `id` (`id`),
  KEY `organizer_email` (`organizer_email`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `event`
--

INSERT INTO `event` VALUES (1,'test','num','jaguero2@txwes.edu','','2024-12-04','22:00:00',2,'testing room num','F'),(2,'guest speaker: bill gates','bill gates will be here!','andrewgr141@txwes.edu','EJW','2024-12-06','12:32:00',400,'dimensions','T'),(3,'testing','hello world','jaguero2@txwes.edu','EJW','2024-12-12','15:00:00',12,'pls work','F'),(4,'New Years','celebrate the new year','newyears@gmail.com','EJW','2024-12-31','12:00:00',50,'new years','T'),(16,'Study Hall','study for final exams','student1@txwes.edu','EJW104','2024-12-04','11:00:00',20,'Student Group','T'),(5,'presentation','present the project','ajgraham@txwes.edu','MCF','2024-12-03','11:00:00',2,'csc4341','F'),(6,'tseting 1010','email check','jaguero2@txwes.edu','MCF','2024-12-03','12:00:00',15,'wahoo','F'),(7,'Project','testing','test@test.com','MCF','2024-12-25','13:30:00',15,'group2','F'),(8,'Piano Recital','music stuff','johndoe121@txwes.edu','MCF','2025-02-02','11:00:00',123,'Txwes Music','T'),(9,'Election party','We will be watching the election','johndoe121@txwes.edu','MCF 106','2024-11-15','17:00:00',30,NULL,'T'),(10,'Cinco de Mayo Celebration','Celebrating the hispanic community, there will be burgers','andrewgr141@txwes.edu','MUC 201','2024-11-20','10:30:00',70,NULL,'T'),(11,'test user','im using a new email','jaguero2@txwes.edu','STC','2002-12-23','14:00:00',123,'sjkagshkjfba','F'),(12,'Pizza party','Enjoying some pizza','jaguero2@txwes.edu','STC','2024-12-03','19:00:00',80,'Food club','T'),(13,'Graduation','We are celebrating the graduates of fall 2024','jaguero2@txwes.edu','STC','2024-12-12','11:00:00',20,'Dimensions Club','F'),(14,'science show','sciecne stuff here','john.doe@txwes.edu','STC','2024-12-12','15:30:00',30,'science club','F'),(15,'Guest speaker','We will be having an Texas wesleyan alumni speak','jaguero2@txwes.edu','STC 111','2024-11-01','12:00:00',20,NULL,'T'),(17,'Finals party','There will be pizza and soda','hjohnson@txwes.edu','STC103','2024-12-18','15:00:00',12,'dimesnions','T');

--
-- Table structure for table `privileges`
--

CREATE TABLE `privileges` (
  `title` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `privileges`
--

INSERT INTO `privileges` VALUES ('admin','Admin can approve or delete events'),('student','Students can create events');


