· 9 years ago · Jan 15, 2017, 08:08 AM
1DROP TABLE IF EXISTS userInfo;
2
3DROP TABLE IF EXISTS saleProductOffers;
4
5CREATE TABLE userInfo
6(
7userNumber INT UNSIGNED AUTO_INCREMENT UNIQUE NOT NULL,
8userName VARCHAR(50) UNIQUE NOT NULL,
9passcode VARCHAR(100) NOT NULL,
10firstName VARCHAR(25) NOT NULL,
11lastName VARCHAR(25) NOT NULL,
12phoneNumber VARCHAR(15) UNIQUE NOT NULL,
13email VARCHAR(100) UNIQUE,
14placeWithoutDivision VARCHAR(25) NOT NULL,
15division VARCHAR(25) NOT NULL,
16profilePicture VARCHAR(255),
17PRIMARY KEY (userName)
18);
19
20CREATE TABLE saleProductOffers
21(
22offerNumber INT UNSIGNED AUTO_INCREMENT UNIQUE NOT NULL,
23productImage VARCHAR(255),
24productName VARCHAR(100) NOT NULL,
25productDescription VARCHAR(255) NOT NULL,
26productPrice INT UNSIGNED NOT NULL,
27productUploadDate DATE NOT NULL,
28productUploadTime TIME NOT NULL,
29productCategory VARCHAR(50) NOT NULL,
30productSubCategory VARCHAR(50),
31userName VARCHAR(50) NOT NULL,
32PRIMARY KEY (offerNumber),
33FOREIGN KEY (userName) REFERENCES userInfo(userName)
34 ON UPDATE CASCADE
35);
36
37INSERT INTO userInfo (userNumber, userName, passcode, firstName, lastName, phoneNumber, email, placeWithoutDivision, division, profilePicture)
38VALUES (NULL,'abdullah','1','hasnat','abdullah','01761900888','hasnat.abdullah@gmail.com','shantinagar','dhaka','abdullah.jpg');
39
40INSERT INTO userInfo (userNumber, userName, passcode, firstName, lastName, phoneNumber, email, placeWithoutDivision, division, profilePicture)
41VALUES (NULL,'joy','1','joy','rahman','01761900999','joy.rahman@gmail.com','uttara','dhaka','joy.jpg');
42
43INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
44values (NULL,'a4techKeyboard.jpg','A4TECH keyboard','Brand : A4TECH \n Used : 1 year',100,CURRENT_DATE,CURRENT_TIME,'electronics','keyboard','abdullah');
45
46INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
47values (NULL,'a4techKeyboardAndMouse.jpg','A4TECH keyboard and mouse','Brand : A4TECH \n Used : 1 year',200,CURRENT_DATE,CURRENT_TIME,'electronics','mouse and keyboard','abdullah');
48
49INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
50values (NULL,'a4techMouse.jpg','A4TECH mouse','Brand : A4TECH \n Used : 1 year',100,CURRENT_DATE,CURRENT_TIME,'electronics','mouse','abdullah');
51
52INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
53values (NULL,'adjustable2PinAdapter.jpg','Adjustable 2 pin adapter','Brand : Many \n Used : 1 year',100,CURRENT_DATE,CURRENT_TIME,'electronics','adapter','abdullah');
54
55INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
56values (NULL,'bench.jpg','Bench','Homemade \n Used : 1 year \n Color : Black \n Quantity : 1 piece',1000,CURRENT_DATE,CURRENT_TIME,'furniture','bench','abdullah');
57
58INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
59values (NULL,'blackDuster.jpg','Duster','Brand : Faber Castle \n Color : Black \n Used : 1 month',100,CURRENT_DATE,CURRENT_TIME,'education','duster','abdullah');
60
61INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
62values (NULL,'chairs.jpg','Chair','Homemade \n Quantity : 2 pieces \n Used : 1 year',2000,CURRENT_DATE,CURRENT_TIME,'furniture','chair','abdullah');
63
64INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
65values (NULL,'coolineAC.jpg','Air conditioner','Brand : Cooline \n Type : 1.5 ton \n Used : 1 year',100000,CURRENT_DATE,CURRENT_TIME,'electronics','airconditionter','abdullah');
66
67INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
68values (NULL,'hitachiProjector.jpg','Projector','Brand : Hitachi \n Used : 1 year',10000,CURRENT_DATE,CURRENT_TIME,'electronics','projector','abdullah');
69
70INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
71values (NULL,'hpProbook450G1Laptop.jpg','HP Probook 450 G1 Laptop','Brand : A4TECH \n Used : 1 year',100000,CURRENT_DATE,CURRENT_TIME,'electronics','laptop','joy');
72
73INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
74values (NULL,'logitechMouse.jpg','Logitech mouse','Brand : Logitech \n Type : Bluetooth mouse \n Used : 1 year',2500,CURRENT_DATE,CURRENT_TIME,'electronics','mouse','joy');
75
76INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
77values (NULL,'manyMultiPlug.jpg','Multiplug','Brand : Many \n Used : 1 year',3000,CURRENT_DATE,CURRENT_TIME,'electronics','multiplug','joy');
78
79INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
80values (NULL,'transcend1TBExternalHarddisk.jpg','Transcend Harddisk','Brand : Transcend \n Memory : 1TB Type: External \n Used : 1 year',3000,CURRENT_DATE,CURRENT_TIME,'electronics','harddisk','joy');
81
82INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
83values (NULL,'transcend4GBPendrive.jpg','Transcend 4GB Pendrive','Brand : Transcend \n Memory : 4GB \n Used : 2 year',1000,CURRENT_DATE,CURRENT_TIME,'electronics','pendrive','joy');
84
85INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
86values (NULL,'transend64GBPendrive.jpg','Transcend 64GB Pendrive','Brand : Transcend \n Memory : 64GB \n Used : 2 year',10000,CURRENT_DATE,CURRENT_TIME,'electronics','pendrive','joy');
87
88INSERT INTO saleproductoffers(offerNumber,productImage,productName,productDescription,productPrice,productUploadDate,productUploadTime,productCategory,productSubCategory,username)
89values (NULL,'whiteBoard.jpg','Whiteboard','Homemade \n Quantity : 1 piece \n Used : 2 year',100,CURRENT_DATE,CURRENT_TIME,'education','whiteBoard','joy');