· 6 years ago · Jun 06, 2019, 01:08 PM
1-- MySQL dump 10.13 Distrib 5.7.26, for Linux (x86_64)
2--
3-- Host: localhost Database: fpw19_DbSoruFrancesco
4-- ------------------------------------------------------
5-- Server version 5.7.26
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `grade`
20--
21
22DROP TABLE IF EXISTS `grade`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `grade` (
26 `id_paper` bigint(20) unsigned NOT NULL,
27 `id_user` bigint(20) unsigned NOT NULL,
28 `isGraded` tinyint(4) DEFAULT NULL,
29 `grade` tinyint(4) DEFAULT NULL,
30 `gradingDate` date DEFAULT NULL,
31 `authorComments` varchar(100) DEFAULT NULL,
32 `organizerComments` varchar(100) DEFAULT NULL,
33 PRIMARY KEY (`id_paper`),
34 KEY `id_user` (`id_user`),
35 CONSTRAINT `grade_ibfk_1` FOREIGN KEY (`id_paper`) REFERENCES `paper` (`id_paper`) ON DELETE CASCADE ON UPDATE CASCADE,
36 CONSTRAINT `id_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `grade`
42--
43
44LOCK TABLES `grade` WRITE;
45/*!40000 ALTER TABLE `grade` DISABLE KEYS */;
46INSERT INTO `grade` VALUES (1,6,1,3,'2019-04-01','author comment 1','organizer comment 1'),(2,6,1,2,'2018-12-03','author comment 2','organizer comment 2'),(3,6,0,NULL,NULL,NULL,NULL),(4,6,1,0,'2019-06-08','author comment 4','organizer comment 4'),(5,6,1,0,'2017-03-04','author comment 5','organizer comment 5'),(6,6,1,4,'2019-11-16','author comment 6','organizer comment 6'),(7,7,0,NULL,NULL,NULL,NULL),(8,7,1,1,'2017-11-05','author comment 8','organizer comment 8'),(9,7,1,2,'2019-03-28','author comment 9','organizer comment 9');
47/*!40000 ALTER TABLE `grade` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `paper`
52--
53
54DROP TABLE IF EXISTS `paper`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `paper` (
58 `id_paper` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
59 `id_user` bigint(20) unsigned DEFAULT NULL,
60 `title` varchar(50) DEFAULT NULL,
61 `submissionDate` date DEFAULT NULL,
62 `content` varchar(300) DEFAULT NULL,
63 `picture` varchar(50) DEFAULT NULL,
64 `category` varchar(15) DEFAULT NULL,
65 `status` varchar(15) DEFAULT NULL,
66 PRIMARY KEY (`id_paper`),
67 UNIQUE KEY `id_paper` (`id_paper`),
68 KEY `id_user` (`id_user`),
69 CONSTRAINT `paper_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE
70) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
71/*!40101 SET character_set_client = @saved_cs_client */;
72
73--
74-- Dumping data for table `paper`
75--
76
77LOCK TABLES `paper` WRITE;
78/*!40000 ALTER TABLE `paper` DISABLE KEYS */;
79INSERT INTO `paper` VALUES (1,6,'Inbox chiude','2019-03-29','inbox content',NULL,'AJAX','APERTO'),(2,6,'Google Stadia','2019-03-25','google stadia content',NULL,'SERVLET','RIFIUTATO'),(3,6,'Titolo random','2019-06-12','random content',NULL,'AJAX','VALUTAZIONE'),(4,6,'Articolo Prova di prova','2019-06-03','prova di prova content',NULL,'AJAX','APERTO'),(5,6,'Javascript test','2019-02-04','javascript content a caso here',NULL,'JAVASCRIPT','RIFIUTATO'),(6,6,'JSP HELP','2019-11-13','JSP content blabla',NULL,'JSP','APERTO'),(7,7,'Cosa ha di nuovo Java 10','2018-12-25','Content java',NULL,'JSP','VALUTAZIONE'),(8,7,'SS fatto semplice','2017-10-31','Content css',NULL,'CSS','ACCETTATO'),(9,7,'Altro articolo di test','2019-03-22','altro articolo content',NULL,'AJAX','APERTO');
80/*!40000 ALTER TABLE `paper` ENABLE KEYS */;
81UNLOCK TABLES;
82
83--
84-- Table structure for table `reviewer`
85--
86
87DROP TABLE IF EXISTS `reviewer`;
88/*!40101 SET @saved_cs_client = @@character_set_client */;
89/*!40101 SET character_set_client = utf8 */;
90CREATE TABLE `reviewer` (
91 `id_review` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
92 `id_paper` bigint(20) unsigned DEFAULT NULL,
93 `id_user` bigint(20) unsigned DEFAULT NULL,
94 PRIMARY KEY (`id_review`),
95 UNIQUE KEY `id_review` (`id_review`),
96 KEY `id_paper` (`id_paper`),
97 KEY `id_user` (`id_user`),
98 CONSTRAINT `reviewer_ibfk_1` FOREIGN KEY (`id_paper`) REFERENCES `paper` (`id_paper`) ON DELETE CASCADE ON UPDATE CASCADE,
99 CONSTRAINT `reviewer_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE
100) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
101/*!40101 SET character_set_client = @saved_cs_client */;
102
103--
104-- Dumping data for table `reviewer`
105--
106
107LOCK TABLES `reviewer` WRITE;
108/*!40000 ALTER TABLE `reviewer` DISABLE KEYS */;
109INSERT INTO `reviewer` VALUES (1,9,6),(2,7,6),(3,6,7),(4,4,7),(5,3,7),(6,1,7);
110/*!40000 ALTER TABLE `reviewer` ENABLE KEYS */;
111UNLOCK TABLES;
112
113--
114-- Table structure for table `user`
115--
116
117DROP TABLE IF EXISTS `user`;
118/*!40101 SET @saved_cs_client = @@character_set_client */;
119/*!40101 SET character_set_client = utf8 */;
120CREATE TABLE `user` (
121 `id_user` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
122 `name` varchar(24) NOT NULL,
123 `surname` varchar(24) NOT NULL,
124 `email` varchar(50) NOT NULL,
125 `password` varchar(24) NOT NULL,
126 `birthDate` date DEFAULT NULL,
127 `entity` varchar(24) DEFAULT NULL,
128 `organizer` tinyint(4) DEFAULT NULL,
129 `author` tinyint(4) DEFAULT NULL,
130 PRIMARY KEY (`id_user`),
131 UNIQUE KEY `id_user` (`id_user`)
132) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
133/*!40101 SET character_set_client = @saved_cs_client */;
134
135--
136-- Dumping data for table `user`
137--
138
139LOCK TABLES `user` WRITE;
140/*!40000 ALTER TABLE `user` DISABLE KEYS */;
141INSERT INTO `user` VALUES (4,'Maurizio','Loi','organizer1@mail.com','password1','1993-02-24',NULL,1,0),(5,'Francesco','Soru','email@email.com','password','1993-04-07',NULL,1,0),(6,'Giancarlo','Autore','author1@mail.com','password1','1995-02-24',NULL,0,1),(7,'Chiara','Autrice','author2@mail.com','password2','1992-08-10',NULL,0,1);
142/*!40000 ALTER TABLE `user` ENABLE KEYS */;
143UNLOCK TABLES;
144/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
145
146/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
147/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
148/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
149/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
150/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
151/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
152/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
153
154-- Dump completed on 2019-05-30 11:32:47