poll table for the poll assignment (change the 'question' to anything your poll is about)
CREATE TABLE `poll` ( `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`question` varchar(100) NOT NULL,
`votes` int NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Users table for the Insecure assignment
CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`username` varchar(50) NOT NULL,
`password` text NOT NULL,
`imgage` varchar(512) NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Secure table for the Secure assignment
CREATE TABLE `secure` ( `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`username` varchar(50) NOT NULL,
`password` varchar(512) NOT NULL,
`imgage` varchar(512) NOT NULL,
`login_count` int default 0
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Products table for the Catalog assigment
CREATE TABLE `product` ( `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(50) NOT NULL,
`description` varchar(500) NOT NULL,
`image` varchar(100) NOT NULL,
`price` float NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;