-
Notifications
You must be signed in to change notification settings - Fork 1
/
PSMDumpFinal.sql
228 lines (193 loc) · 21.3 KB
/
PSMDumpFinal.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
CREATE DATABASE IF NOT EXISTS `dbpsm` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `dbpsm`;
-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost Database: dbpsm
-- ------------------------------------------------------
-- Server version 5.7.18-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `tblanswers`
--
DROP TABLE IF EXISTS `tblanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblanswers` (
`intAnswerID` int(11) NOT NULL AUTO_INCREMENT,
`strAnswerSNum` char(15) NOT NULL,
`intAnswer` int(3) NOT NULL,
PRIMARY KEY (`intAnswerID`),
KEY `strAnswerSNum_idx` (`strAnswerSNum`),
KEY `intAnswer_idx` (`intAnswer`),
CONSTRAINT `intAnswer` FOREIGN KEY (`intAnswer`) REFERENCES `tblchoices` (`intChID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `strAnswerSNum` FOREIGN KEY (`strAnswerSNum`) REFERENCES `tbluser` (`strSNum`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblanswers`
--
INSERT INTO `tblanswers` VALUES (51,'2015-04593-MN-0',90),(52,'2015-04593-MN-0',65),(53,'2015-04593-MN-0',95),(54,'2015-04593-MN-0',53),(55,'2015-04593-MN-0',38),(56,'2015-04593-MN-0',2),(57,'2015-04593-MN-0',26),(58,'2015-04593-MN-0',41),(59,'2015-04593-MN-0',46),(60,'2015-04593-MN-0',14),(61,'2015-01216-MN-0',69),(62,'2015-01216-MN-0',2),(63,'2015-01216-MN-0',17),(64,'2015-01216-MN-0',24),(65,'2015-01216-MN-0',26),(66,'2015-01216-MN-0',33),(67,'2015-01216-MN-0',46),(68,'2015-01216-MN-0',53),(69,'2015-01216-MN-0',60),(70,'2015-01216-MN-0',65),(71,'2015-04834-MN-0',82),(72,'2015-04834-MN-0',8),(73,'2015-04834-MN-0',11),(74,'2015-04834-MN-0',41),(75,'2015-04834-MN-0',46),(76,'2015-04834-MN-0',51),(77,'2015-04834-MN-0',53),(78,'2015-04834-MN-0',60),(79,'2015-04834-MN-0',63),(80,'2015-04834-MN-0',65),(81,'2015-01341-MN-0',95),(82,'2015-01341-MN-0',8),(83,'2015-01341-MN-0',14),(84,'2015-01341-MN-0',24),(85,'2015-01341-MN-0',38),(86,'2015-01341-MN-0',41),(87,'2015-01341-MN-0',51),(88,'2015-01341-MN-0',69),(89,'2015-01341-MN-0',82),(90,'2015-01341-MN-0',87),(91,'2015-04253-MN-0',90),(92,'2015-04253-MN-0',8),(93,'2015-04253-MN-0',17),(94,'2015-04253-MN-0',32),(95,'2015-04253-MN-0',33),(96,'2015-04253-MN-0',51),(97,'2015-04253-MN-0',53),(98,'2015-04253-MN-0',63),(99,'2015-04253-MN-0',65),(100,'2015-04253-MN-0',87),(101,'2015-11114-MN-0',8),(102,'2015-11114-MN-0',11),(103,'2015-11114-MN-0',14),(104,'2015-11114-MN-0',26),(105,'2015-11114-MN-0',38),(106,'2015-11114-MN-0',60),(107,'2015-11114-MN-0',63),(108,'2015-11114-MN-0',65),(109,'2015-11114-MN-0',87),(110,'2015-11114-MN-0',95),(111,'2015-05757-MN-0',82),(112,'2015-05757-MN-0',14),(113,'2015-05757-MN-0',17),(114,'2015-05757-MN-0',24),(115,'2015-05757-MN-0',26),(116,'2015-05757-MN-0',32),(117,'2015-05757-MN-0',33),(118,'2015-05757-MN-0',38),(119,'2015-05757-MN-0',53),(120,'2015-05757-MN-0',73),(121,'2015-02766-MN-0',90),(122,'2015-02766-MN-0',2),(123,'2015-02766-MN-0',24),(124,'2015-02766-MN-0',32),(125,'2015-02766-MN-0',41),(126,'2015-02766-MN-0',53),(127,'2015-02766-MN-0',63),(128,'2015-02766-MN-0',60),(129,'2015-02766-MN-0',65),(130,'2015-02766-MN-0',82),(131,'2015-02820-MN-0',87),(132,'2015-02820-MN-0',2),(133,'2015-02820-MN-0',6),(134,'2015-02820-MN-0',11),(135,'2015-02820-MN-0',36),(136,'2015-02820-MN-0',53),(137,'2015-02820-MN-0',65),(138,'2015-02820-MN-0',74),(139,'2015-02820-MN-0',82),(140,'2015-02820-MN-0',69),(141,'2015-08887-MN-0',90),(142,'2015-08887-MN-0',6),(143,'2015-08887-MN-0',11),(144,'2015-08887-MN-0',26),(145,'2015-08887-MN-0',33),(146,'2015-08887-MN-0',46),(147,'2015-08887-MN-0',53),(148,'2015-08887-MN-0',69),(149,'2015-08887-MN-0',74),(150,'2015-08887-MN-0',82),(151,'2015-02043-MN-0',95),(152,'2015-02043-MN-0',14),(153,'2015-02043-MN-0',24),(154,'2015-02043-MN-0',26),(155,'2015-02043-MN-0',32),(156,'2015-02043-MN-0',60),(157,'2015-02043-MN-0',74),(158,'2015-02043-MN-0',79),(159,'2015-02043-MN-0',82),(160,'2015-02043-MN-0',87),(161,'2015-01234-MN-0',90),(162,'2015-01234-MN-0',2),(163,'2015-01234-MN-0',6),(164,'2015-01234-MN-0',17),(165,'2015-01234-MN-0',46),(166,'2015-01234-MN-0',63),(167,'2015-01234-MN-0',65),(168,'2015-01234-MN-0',69),(169,'2015-01234-MN-0',79),(170,'2015-01234-MN-0',82);
--
-- Table structure for table `tblcategories`
--
DROP TABLE IF EXISTS `tblcategories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcategories` (
`intCatID` int(1) NOT NULL,
`strCatName` varchar(30) NOT NULL,
PRIMARY KEY (`intCatID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcategories`
--
INSERT INTO `tblcategories` VALUES (1,'Books'),(2,'School Supplies'),(3,'Food'),(4,'Misc.');
--
-- Table structure for table `tblchoices`
--
DROP TABLE IF EXISTS `tblchoices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblchoices` (
`intChID` int(3) NOT NULL,
`intChQuestionID` int(2) NOT NULL,
`strChoice` varchar(100) NOT NULL,
`boolCorrect` int(1) NOT NULL,
PRIMARY KEY (`intChID`),
KEY `intChQuestionID_idx` (`intChQuestionID`),
CONSTRAINT `intChQuestionID` FOREIGN KEY (`intChQuestionID`) REFERENCES `tblquestions` (`intQuestionID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblchoices`
--
INSERT INTO `tblchoices` VALUES (1,1,'Beside the gym',0),(2,1,'Freedom Park',1),(3,1,'Beside the Chapel',0),(4,1,'Inside the Field',0),(5,2,'5',0),(6,2,'4',1),(7,2,'3',0),(8,2,'6',0),(9,3,'Jose Rizal',0),(10,3,'Gregorio Del Pilar',0),(11,3,'Apolinario Mabini',1),(12,3,'Emilio Aguinaldo',0),(13,4,'A well known professor',0),(14,4,'The mascot of PUP',1),(15,4,'The president of PUP',0),(16,4,'A seller of cooked lunch',0),(17,5,'Beside the Library/NALLRC',1),(18,5,'Beside the main building',0),(19,5,'Inside the lagoon',0),(20,5,'In front of the chapel',0),(21,6,'SM Megamall',0),(22,6,'SM North',0),(23,6,'Market! Market!',0),(24,6,'SM Centerpoint',1),(25,7,'Fish, Egg With Apple',0),(26,7,'Footlong, Egg Wrap Around',1),(27,7,'Fried Espasol with Almond',0),(28,7,'Fried eggplant with Atsara',0),(29,8,'2',0),(30,8,'1',0),(31,8,'4',0),(32,8,'3',1),(33,9,'2',1),(34,9,'1',0),(35,9,'4',0),(36,9,'3',0),(37,10,'Polytechnic University of the Philippines',0),(38,10,'Philippine School of Commerce',1),(39,10,'Polytechnic College',0),(40,10,'Unibersidad de Politekniko',0),(41,11,'1904',1),(42,11,'1910',0),(43,11,'1907',0),(44,11,'1969',0),(45,12,'Sit on the floor',0),(46,12,'Get a chair from other classrooms',1),(47,12,'Just stand',0),(48,12,'Burn more chairs as a protest',0),(49,13,'Emmanuel Malto',0),(50,13,'Angelito Casasis',0),(51,13,'Ruben Madridejos',1),(52,13,'Albert dela Cruz',0),(53,14,'Emanuel de Guzman',1),(54,14,'Perry David Solosa',0),(55,14,'Dante Gueverra',0),(56,14,'Samuel Salvador',0),(57,15,'15',0),(58,15,'10',0),(59,15,'11',0),(60,15,'12',1),(61,16,'Oblation Run',0),(62,16,'Naked Run',0),(63,16,'Pylon Run',1),(64,16,'Fanservice Run',0),(65,17,'6',1),(66,17,'4',0),(67,17,'5',0),(68,17,'7',0),(69,18,'FEWA',1),(70,18,'ID Lace',0),(71,18,'School Supplies',0),(72,18,'Spaghetti',0),(73,19,'Park',0),(74,19,'Lagoon',1),(75,19,'Building',0),(76,19,'Fountain',0),(77,20,'Silog',0),(78,20,'Red Panda',0),(79,20,'Submarine',1),(80,20,'Kalog',0),(81,21,'Inside the main building',0),(82,21,'NALLRC building',1),(83,21,'Inside Charlie del Rosario',0),(84,21,'At the middle of the oval',0),(85,22,'1/3 of the class time',1),(86,22,'1/2 of the class time',0),(87,22,'1/4 of the class time',0),(88,22,'None of the choices',0),(89,23,'11:00 pm',0),(90,23,'9:00 pm',1),(91,23,'10:30 pm',0),(92,23,'8:00 pm',0),(93,24,'Outside PUP',0),(94,24,'1st floor',0),(95,24,'6th floor',1),(96,24,'3rd floor',0);
--
-- Table structure for table `tblitem`
--
DROP TABLE IF EXISTS `tblitem`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblitem` (
`intItemID` int(11) NOT NULL AUTO_INCREMENT,
`strItemTitle` varchar(50) NOT NULL,
`fltItemPrice` float NOT NULL,
`strItemSNum` char(15) NOT NULL,
`datPostDate` date NOT NULL,
`txtItemDesc` varchar(250) DEFAULT NULL,
`strOrderPass` varchar(45) NOT NULL,
`strFirstPic` varchar(100) DEFAULT NULL,
`strSecondPic` varchar(100) DEFAULT NULL,
`strThirdPic` varchar(100) DEFAULT NULL,
`intItemCat` int(1) NOT NULL,
PRIMARY KEY (`intItemID`),
KEY `strItemSNum_idx` (`strItemSNum`),
KEY `intItemCat_idx` (`intItemCat`),
CONSTRAINT `intItemCat` FOREIGN KEY (`intItemCat`) REFERENCES `tblcategories` (`intCatID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `strItemSNum` FOREIGN KEY (`strItemSNum`) REFERENCES `tbluser` (`strSNum`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblitem`
--
INSERT INTO `tblitem` VALUES (24,'Drawstrings',200,'2015-04593-MN-0','2017-10-17','Drawstring Bags','drwastrings','2015-04593-MN-0-EgHdMIDqE4D7ngNVwbTZJYq86XncY1bHDXZAyazrEvXtrOGkvY-1.jpg','2015-04593-MN-0-EgHdMIDqE4D7ngNVwbTZJYq86XncY1bHDXZAyazrEvXtrOGkvY-2.jpg','2015-04593-MN-0-EgHdMIDqE4D7ngNVwbTZJYq86XncY1bHDXZAyazrEvXtrOGkvY-3.jpg',4),(25,'History Book',450.5,'2015-04593-MN-0','2017-10-17','World History Book\r\nslightly used\r\npresentable','hitorybooks','2015-04593-MN-0-zbzbJvG5ciR13lPypYt2K2hvGJEhNQMwJn0ENDQMb9SrmYtz26-1.jpg','2015-04593-MN-0-zbzbJvG5ciR13lPypYt2K2hvGJEhNQMwJn0ENDQMb9SrmYtz26-2.jpg','2015-04593-MN-0-zbzbJvG5ciR13lPypYt2K2hvGJEhNQMwJn0ENDQMb9SrmYtz26-3.jpg',1),(26,'Samyang Spicy Noodles',70,'2015-04834-MN-0','2017-10-17','Samyang Spicy noodles','spicysamyang','2015-04834-MN-0-XcebpzTjPws0j7RlEMAq2FSgJrWXQPsLuhjTNpXYjJaq8hB5uN-1.jpg','2015-04834-MN-0-XcebpzTjPws0j7RlEMAq2FSgJrWXQPsLuhjTNpXYjJaq8hB5uN-2.jpg','2015-04834-MN-0-XcebpzTjPws0j7RlEMAq2FSgJrWXQPsLuhjTNpXYjJaq8hB5uN-3.jpg',3),(27,'Frixion Pen',30,'2015-04834-MN-0','2017-10-17','Erasable Pen\r\n.5\r\nreffilable','erasable','2015-04834-MN-0-SZAZgCvtxpEpUAQGzKGg4FSJVUy00d2mXZ9jFd3FUPxPBrCKqV-1.jpg','2015-04834-MN-0-SZAZgCvtxpEpUAQGzKGg4FSJVUy00d2mXZ9jFd3FUPxPBrCKqV-2.jpg','2015-04834-MN-0-SZAZgCvtxpEpUAQGzKGg4FSJVUy00d2mXZ9jFd3FUPxPBrCKqV-3.jpg',2),(28,'Sunflower',250,'2015-01341-MN-0','2017-10-17','Sunflower \r\n250 each\r\n400 (2pcs)','flowersun','2015-01341-MN-0-3dkTyi7cWeXCWkNbladGjzCHSuNRbbSqhiu2F7AWFoCUOzmYm4-1.jpg','2015-01341-MN-0-3dkTyi7cWeXCWkNbladGjzCHSuNRbbSqhiu2F7AWFoCUOzmYm4-2.jpg','2015-01341-MN-0-3dkTyi7cWeXCWkNbladGjzCHSuNRbbSqhiu2F7AWFoCUOzmYm4-3.jpg',4),(29,'Moon Necklace',185,'2015-02820-MN-0','2017-10-17','MOON NECKLACE \r\nNow Available! \r\n-Stainless Steel \r\n-Glow in the dark\r\n-size: pendant 2cm,Chain 41cm\r\n185 only! W/box na po ','moonlight','2015-02820-MN-0-LOQQng0zYlA2EycAjZR3LoWjKE5UqVXrPwYAmZln5gT3RLx18z-1.jpg','2015-02820-MN-0-LOQQng0zYlA2EycAjZR3LoWjKE5UqVXrPwYAmZln5gT3RLx18z-2.jpg','2015-02820-MN-0-LOQQng0zYlA2EycAjZR3LoWjKE5UqVXrPwYAmZln5gT3RLx18z-3.jpg',4),(30,'MSA College Admission Tests Reviewer',499,'2015-01216-MN-0','2017-10-17','Reviewer for UPCAT, ACET, De la salle, UST, UA&P and other college entrance exams with ANSWERS AND SOLUTIONS MANUAL.\r\n\r\nIn good condition(with plastic cover pa!!!)\r\n\r\nOriginally bought it for 648.Now selling both books for only 499 !!!','reviewer','2015-01216-MN-0-IvgMO1QKXK1Aav65nPTSGKfqrLPghdsdplbd9wqA4O560IqWRS-1.jpg','2015-01216-MN-0-IvgMO1QKXK1Aav65nPTSGKfqrLPghdsdplbd9wqA4O560IqWRS-2.jpg','2015-01216-MN-0-IvgMO1QKXK1Aav65nPTSGKfqrLPghdsdplbd9wqA4O560IqWRS-3.jpg',1),(31,'SHIRTS',160,'2015-05757-MN-0','2017-10-17','160\r\nClip art Shirts! \r\nFor only Php 160.00\r\nAvail size: Small - XXL ','cliparts','2015-05757-MN-0-3QhPIp78MhYfE20SyAF4ynImhsqYKZbne4uQJljTV5ITs19q9o-1.jpg','blank.jpg','blank.jpg',4),(32,'Zenfone 3',5000,'2015-11114-MN-0','2017-10-17','for sale asus zenfone 3 max 5.2 no issie 2months old. more info about nasa picture posted.\r\n\r\nneed cash for upgrade.','asusnuma1','2015-11114-MN-0-RyiUl0cLPtYextUlM4xttS3s0g2INDGDFzO8ot8STX3tfH1wrk-1.jpg','2015-11114-MN-0-RyiUl0cLPtYextUlM4xttS3s0g2INDGDFzO8ot8STX3tfH1wrk-2.jpg','2015-11114-MN-0-RyiUl0cLPtYextUlM4xttS3s0g2INDGDFzO8ot8STX3tfH1wrk-3.jpg',4),(33,'Oreo cheesecake',85,'2015-04253-MN-0','2017-10-17','Guys sno pa po hahabol? Order na po solid na creamcheese po ang nasa gitna, at ang lasa niya e parang white chocolate bukas po available mga bessywap.\r\n\r\nAvalable monday&tuesday!\r\n\r\nMeetup pureza lrt station / nso','cheesecake','2015-04253-MN-0-GCMJJCNmJ1YFBCDqgqlIfIAwSpbJYe2C6b547MmCoINEfZfBrJ-1.jpg','2015-04253-MN-0-GCMJJCNmJ1YFBCDqgqlIfIAwSpbJYe2C6b547MmCoINEfZfBrJ-2.jpg','blank.jpg',3),(34,'Hershey\'s Syrup',100,'2015-04253-MN-0','2017-10-17','Hershey\'s syrup for sale!!! 100 pesos only!\r\n\r\n-Legit \r\n-Minimum 2pcs','Hershey\'s','2015-04253-MN-0-eu9EdSyNcmtuN293LxlzHHsHAn0e3SrMbDbqpSOw8rLjZ0d1tV-1.jpg','2015-04253-MN-0-eu9EdSyNcmtuN293LxlzHHsHAn0e3SrMbDbqpSOw8rLjZ0d1tV-2.jpg','blank.jpg',3),(35,'Dante\'s inferno',200,'2015-08887-MN-0','2017-10-17','200php each without sf\r\n600php set with sf\r\n500php pick up at pureza lrt\r\nVisit kelzshoppe for more book titles','infernob','2015-08887-MN-0-XeYfamNC9Zzu0zoNm6EzxkJ4kj1sOfrK2cNAbLFv5pk5czzKbK-1.jpg','blank.jpg','blank.jpg',1),(36,'100% original casio watches',1299,'2015-02766-MN-0','2017-10-17','101% authentic\r\n101% legit\r\nbrandnew/onhand\r\ncomplete with casio box,manual,tag and warranty\r\n1299-2999 depende po sa unit\r\ntriple ur money back pag fake\r\ndi po eto oem,replica or class a \r\nfree delivery/ cod around pasig\r\n','123456789','2015-02766-MN-0-Cyq66ZiEMXNopqtBgvN7SITXKsqniVFFHM7eTbarOK57xWEThU-1.jpg','2015-02766-MN-0-Cyq66ZiEMXNopqtBgvN7SITXKsqniVFFHM7eTbarOK57xWEThU-2.jpg','2015-02766-MN-0-Cyq66ZiEMXNopqtBgvN7SITXKsqniVFFHM7eTbarOK57xWEThU-3.jpg',4);
--
-- Table structure for table `tblquestions`
--
DROP TABLE IF EXISTS `tblquestions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblquestions` (
`intQuestionID` int(2) NOT NULL,
`strQuestion` varchar(150) NOT NULL,
`boolUsed` int(1) NOT NULL,
PRIMARY KEY (`intQuestionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblquestions`
--
INSERT INTO `tblquestions` VALUES (1,'Where is the Obelisk located at?',1),(2,'How many wings does the main building have?',1),(3,'Who is the national hero that has a \"tahanan\" in our Sintang Paaralan?',0),(4,'Who is Ted Pylon?',0),(5,'Where is the UFO/Watertank located at in PUP?',1),(6,'The favorite mall of students when there are no professors',0),(7,'What does \"FEWA\" mean?',0),(8,'How many basketball courts does PUP Sta. Mesa have?',0),(9,'How many 7/11 branches are there near PUP Sta. Mesa?',0),(10,'What is the first name of PUP?',0),(11,'What year did PUP officially become a university?',0),(12,'What would you do if there is a shortage of chairs in your room?',1),(13,'Who is the \"Einstein\" of PUP Sta. Mesa?',0),(14,'Who is the current president of PUP?',0),(15,'How many characters does the student number have (excluding dashes)?',0),(16,'What is the real name of the event \"Kikiam run\"?',1),(17,'How many floors does the PUP main building have?',1),(18,'What does \"Virgin\" sell?',1),(19,'Currently, what does \"Intramuros\" behold inside?',0),(20,'Other than the FEWA, what is the other famous food from PUP?',1),(21,'Where is the most presentable comfort room located at in PUP Sta. Mesa?',1),(22,'How long do you have to wait until you could safely assume that your professor is absent?',0),(23,'What is the latest end of classes in PUP?',1),(24,'When you were a freshie, how long did the line go during registration?',0);
--
-- Table structure for table `tblreport`
--
DROP TABLE IF EXISTS `tblreport`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblreport` (
`intReportID` int(11) NOT NULL AUTO_INCREMENT,
`intReportItemID` int(11) NOT NULL,
`strReportSNum` char(15) NOT NULL,
PRIMARY KEY (`intReportID`),
KEY `intReportItemID_idx` (`intReportItemID`),
KEY `strReportSNum_idx` (`strReportSNum`),
CONSTRAINT `intReportItemID` FOREIGN KEY (`intReportItemID`) REFERENCES `tblitem` (`intItemID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `strReportSNum` FOREIGN KEY (`strReportSNum`) REFERENCES `tbluser` (`strSNum`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblreport`
--
--
-- Table structure for table `tbltransaction`
--
DROP TABLE IF EXISTS `tbltransaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbltransaction` (
`intTransID` int(11) NOT NULL AUTO_INCREMENT,
`intTransItemID` int(11) NOT NULL,
`strBuyerSNum` char(15) NOT NULL,
`datDateStarted` date NOT NULL,
`strTransStatus` varchar(20) NOT NULL,
`datDateFinished` date DEFAULT NULL,
PRIMARY KEY (`intTransID`),
KEY `intTransItemID_idx` (`intTransItemID`),
KEY `strBuyerSNum_idx` (`strBuyerSNum`),
CONSTRAINT `intTransItemID` FOREIGN KEY (`intTransItemID`) REFERENCES `tblitem` (`intItemID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `strBuyerSNum` FOREIGN KEY (`strBuyerSNum`) REFERENCES `tbluser` (`strSNum`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbltransaction`
--
INSERT INTO `tbltransaction` VALUES (15,24,'2015-02766-MN-0','2017-10-17','Ongoing',NULL);
--
-- Table structure for table `tbluser`
--
DROP TABLE IF EXISTS `tbluser`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbluser` (
`strSNum` char(15) NOT NULL,
`strName` varchar(100) NOT NULL,
`strEmail` varchar(45) NOT NULL,
`txtContact` varchar(250) DEFAULT NULL,
`strPassword` varchar(50) NOT NULL,
`strStatus` varchar(20) NOT NULL,
`intCommend` int(6) NOT NULL,
`intReport` int(6) NOT NULL,
`strProfilePicture` varchar(100) DEFAULT NULL,
PRIMARY KEY (`strSNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbluser`
--
INSERT INTO `tbluser` VALUES ('2015-01216-MN-0','Jon Ervin Balmaceda','balmacedajonervin@gmail.com','09236835707','idolbule','verified',0,0,'blank.jpg'),('2015-01234-MN-0','Niño Escueta','juandelacruz@gmail.com','@juandc','abcde1234','unregistered',0,0,'blank.jpg'),('2015-01341-MN-0','Vince Miguel Oreta','vincemiguel14@yahoo.com','09083586708','niggaidesireu','verified',0,0,'2015-01341-MN-0-daZ7cxTCJ5Gz3EFoR1cbnHmgApDGHecOD72IMxvhqBL8JBIGVx-dp.jpg'),('2015-02043-MN-0','Dennin Mendiola','denninmendiola@yahoo.com','09053194681','DENGGG123','unregistered',0,0,'blank.jpg'),('2015-02766-MN-0','Dustin Alpasar','dustinalpasar69@gmail.com','facebook.com/penoyaquino\r\n09287490026','3223548222','verified',0,0,'2015-02766-MN-0-fuGLQZIgx5P0rcJ1CzWnFYtxUx2RHVsj1tw17dhrZzSFAVLTm9-dp.jpg'),('2015-02820-MN-0','Keynie Mae Orial','keyniemae@yahoo.com','09499451798','gandako123','verified',0,0,'blank.jpg'),('2015-04253-MN-0','Arjay de Guia jr.','sendodeguia@gmail.com','09069301452','ARJAYPOGI','verified',0,0,'blank.jpg'),('2015-04593-MN-0','Jethro Jhay Samson','jethrosamson@yahoo.com','09752264511\r\nhttps://www.facebook.com/jethro.samson.52','wordpass123','verified',0,0,'2015-04593-MN-0-kB6ozZlMqb6PELvhynHo8A7dX9yeWudJF13nUmJkzt5Evv5nsv-dp.jpg'),('2015-04834-MN-0','Lance Jeron San Pablo','lancejeron26@gmail.com','09199691903\r\nhttps://www.facebook.com/lancejeron','kate1434','verified',0,0,'2015-04834-MN-0-LkvJlzZQ5WMLNnDRUxRMTA2MMBegTuiaIOiGTQNsel8P56oTa6-dp.jpg'),('2015-05757-MN-0','John Carlo Doronila','joshuaburnay@gmail.com','https://www.facebook.com/jc.doronila.35','idealgirl','verified',0,0,'blank.jpg'),('2015-08887-MN-0','Crisaldo Ibay Santos','crisaldo.santos.22@gmail.com','09178908490','crisaldopogi','verified',0,0,'2015-08887-MN-0-AGBfGqgAcv5vD5jUYAx3zEeSSpWLkAtDKaOS93fpYKB1D66f7u-dp.jpg'),('2015-11114-MN-0','Matthew James Victore','victorematthew@gmail.com','09481832944','MatthewVictore2','verified',0,0,'2015-11114-MN-0-5fscHcFLOkvWrom51DAjL8q0SNDJs01uESVQPgGUpxOL3Pabuy-dp.jpg'),('admin','Admin User','psm.sup.adm@gmail.com','psm.sup.adm@gmail.com','admin','admin',0,0,NULL);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed