QzxCqz4W

1DROP TABLE IF EXISTS userInfo;
2
3DROP TABLE IF EXISTS saleProductOffers;
4
5DROP TABLE IF EXISTS exchangeProductOffers;
6 
7CREATE TABLE userInfo
8(
9userNumber INT UNSIGNED AUTO_INCREMENT UNIQUE NOT NULL,
10userName VARCHAR(255) UNIQUE NOT NULL,
11passcode VARCHAR(255) NOT NULL,
12firstName VARCHAR(255) NOT NULL,
13lastName VARCHAR(255) NOT NULL,
14phoneNumber VARCHAR(15) UNIQUE NOT NULL,
15email VARCHAR(255) UNIQUE,
16placeWithoutDivision VARCHAR(255) NOT NULL,
17division VARCHAR(255) NOT NULL,
18profilePicture VARCHAR(255),
19PRIMARY KEY (UserNumber)
20);
21
22CREATE TABLE saleProductOffers
23(
24offerNumber INT UNSIGNED AUTO_INCREMENT UNIQUE NOT NULL,
25productImage VARCHAR(255),
26productName VARCHAR(255) NOT NULL,
27productDescription VARCHAR(255) NOT NULL,
28productPrice INT UNSIGNED NOT NULL,
29productUploadDate DATE NOT NULL,
30productUploadTime TIME NOT NULL,
31productCategory VARCHAR(255) NOT NULL,
32productSubCategory VARCHAR(255).
33userName VARCHAR(255) NOT NULL,
34PRIMARY KEY (offerNumber)
35);
36
37CREATE TABLE exchangeProductOffers
38(
39offerNumber INT UNSIGNED AUTO_INCREMENT UNIQUE NOT NULL,
40fromProductImage VARCHAR(255),
41fromProductName VARCHAR(255) NOT NULL,
42fromProductDescription VARCHAR(255) NOT NULL,
43fromProductCategory VARCHAR(255) NOT NULL,
44fromProductUploadDate DATE NOT NULL,
45fromProductUploadTime TIME NOT NULL,
46toProductName VARCHAR(255) NOT NULL,
47toProductDescription VARCHAR(255) NOT NULL,
48toProductCategory VARCHAR(255) NOT NULL,
49userName VARCHAR(255) NOT NULL,
50PRIMARY KEY(offerNumber)
51);
52 
53INSERT INTO `userInfo` (`userNumber`, `userName`, `passcode`, `firstName`, `lastName`, `phoneNumber`, `email`, `placeWithoutDivision`, `division`, `profilePicture`)
54VALUES (NULL, 'cat0', 'cat0', 'white', 'cat0', '01111111110', NULL, 'myplace', 'mydivision', NULL);
55 
56INSERT INTO `userInfo` (`userNumber`, `userName`, `passcode`, `firstName`, `lastName`, `phoneNumber`, `email`, `placeWithoutDivision`, `division`, `profilePicture`)
57VALUES (NULL, 'cat1', 'cat1', 'white', 'cat1', '01111111111', NULL, 'myplace', 'mydivision', NULL);
58 
59INSERT INTO `userInfo` (`userNumber`, `userName`, `passcode`, `firstName`, `lastName`, `phoneNumber`, `email`, `placeWithoutDivision`, `division`, `profilePicture`)
60VALUES (NULL, 'cat2', 'cat2', 'white', 'cat2', '01111111112', NULL, 'myplace0', 'mydivision', NULL);
61 
62 
63INSERT INTO `saleproductoffers` (`offerNumber`, `productImage`, `productName`, `productDescription`, `productPrice`, `productUploadDate`, `productUploadTime`, `productCatagory`, `userName`) 
64VALUES (NULL, NULL, 'samsung galaxy s2', 'Android : 4.4 kitkat Used : 2 months', '6000', CURRENT_DATE(), CURRENT_TIME(), 'Mobile', 'cat0');
65
66INSERT INTO `saleproductoffers` (`offerNumber`, `productImage`, `productName`, `productDescription`, `productPrice`, `productUploadDate`, `productUploadTime`, `productCatagory`, `userName`) 
67VALUES (NULL, NULL, 'samsung galaxy j2', 'Android : 5.1 lolipop Used : 1 year', '10000', CURRENT_DATE(), CURRENT_TIME(), 'Mobile', 'cat0');
68
69INSERT INTO `saleproductoffers` (`offerNumber`, `productImage`, `productName`, `productDescription`, `productPrice`, `productUploadDate`, `productUploadTime`, `productCatagory`, `userName`) 
70VALUES (NULL, NULL, 'hp 450 g1 core i7', 'Windows : 10 (64 bit) Used : 1 year', '100000', CURRENT_DATE(), CURRENT_TIME(), 'Computer', 'cat1');
71
72
73INSERT INTO `exchangeproductoffers` (`offerNumber`, `fromProductImage`, `fromProductName`, `fromProductDescription`, `fromProductCatagory`, `fromProductUploadDate`, `fromProductUploadTime`, `toProductName`, `toProductDescription`, `toProductCatagory`, `userName`) VALUES (NULL, NULL, 'Galaxy grand 2', 'Android : 5.1
74Used : 1 year', 'Mobile', CURRENT_DATE(), CURRENT_TIME(), 'HP ProBook G1 core i3', 'Windows : any
75Used : any', 'Computer', 'cat0');
76
77INSERT INTO `exchangeproductoffers` (`offerNumber`, `fromProductImage`, `fromProductName`, `fromProductDescription`, `fromProductCatagory`, `fromProductUploadDate`, `fromProductUploadTime`, `toProductName`, `toProductDescription`, `toProductCatagory`, `userName`) VALUES (NULL, NULL, 'HP ProBook G1 core i3', 'Windows : 10
78Used : 1 year', 'Computer', CURRENT_DATE(), CURRENT_TIME(), 'Iphone 6S', 'OS version : any
79Used : any', 'Mobile', 'cat1');