temporary project database

DROP TABLE IF EXISTS userInfo;

DROP TABLE IF EXISTS saleProductOffers;

DROP TABLE IF EXISTS exchangeProductOffers;

CREATE TABLE userInfo
(
userNumber INT UNSIGNED AUTO_INCREMENT UNIQUE NOT NULL,
userName VARCHAR(50) UNIQUE NOT NULL,
passcode VARCHAR(100) NOT NULL,
firstName VARCHAR(25) NOT NULL,
lastName VARCHAR(25) NOT NULL,
phoneNumber VARCHAR(15) UNIQUE NOT NULL,
email VARCHAR(100) UNIQUE,
placeWithoutDivision VARCHAR(25) NOT NULL,
division VARCHAR(25) NOT NULL,
profilePicture VARCHAR(255),
PRIMARY KEY (userName)
);

CREATE TABLE saleProductOffers
(
offerNumber INT UNSIGNED AUTO_INCREMENT UNIQUE NOT NULL,
productImage VARCHAR(255),
productName VARCHAR(100) NOT NULL,
productDescription VARCHAR(255) NOT NULL,
productPrice INT UNSIGNED NOT NULL,
productUploadDate DATE NOT NULL,
productUploadTime TIME NOT NULL,
productCategory VARCHAR(50) NOT NULL,
productSubCategory VARCHAR(50),
userName VARCHAR(50) NOT NULL,
PRIMARY KEY (offerNumber),
FOREIGN KEY (userName) REFERENCES userInfo(userName)
    ON UPDATE CASCADE
);

INSERT INTO userInfo (userNumber, userName, passcode, firstName, lastName, phoneNumber, email, placeWithoutDivision, division, profilePicture)
VALUES (NULL,'abdullah',1,'hasnat','abdullah','01761900888','hasnat.abdullah@gmail.com','shantinagar','dhaka','abdullah.jpg');

INSERT INTO userInfo (userNumber, userName, passcode, firstName, lastName, phoneNumber, email, placeWithoutDivision, division, profilePicture)
VALUES (NULL,'joy',1,'joy','rahman','01761900999','joy.rahman@gmail.com','uttara','dhaka','joy.jpg');

INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
values (NULL,'a4techKeyboard.jpg','A4TECH keyboard','Brand : A4TECH \n Used : 1 year',100,CURRENT_DATE,CURRENT_TIME,'Electronics','Mouse','abdullah');