/* If you are running this script on your local host, uncomment the next 5 lines. */
— drop database if exists newquora;
— create database newquora /*!40100 DEFAULT CHARACTER SET utf8 */;
— use newquora;
Copyright By PowCoder代写 加微信 powcoder
— SET GLOBAL sql_mode=(SELECT
— SET sql_mode=(SELECT
/*!40101 SET */;
/*!40101 SET */;
/*!40101 SET */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET */;
/*!40103 SET TIME_ZONE=’+00:00′ */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;
/*!40111 SET SQL_NOTES=0 */;
— Table structure for table `forum`
UNLOCK TABLES;
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`Id` int(11) NOT NULL,
`Topic` varchar(100) NOT NULL,
`WhenCreated` timestamp NOT NULL,
`CreatedBy` int(11) NOT NULL,
PRIMARY KEY (`Id`),
KEY `fk_Forum_Moderator1_idx` (`CreatedBy`),
CONSTRAINT `fk_Forum_Moderator1` FOREIGN KEY (`CreatedBy`) REFERENCES `admin` (`Id`) 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 `forum`
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (1,’Farewell to class of 2020′,’2020-10-29 22:30:00′,5),(2,’Welcome to class of 2021′,’2021-01-28 22:00:00′,4),(3,’About the campus’,’2020-01-31 22:00:00′,5),(4,’Buy and sell textbooks’,’2021-02-14 02:30:00′,5),(5,’Interesting science facts’,’2021-03-03 05:45:00′,4), (6,’Physics 101′,’2022-10-29 22:30:00′,5);
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `friendof`
DROP TABLE IF EXISTS `friendof`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `friendof` (
`user1` int(11) NOT NULL,
`user2` int(11) NOT NULL,
`WhenRequested` timestamp,
`WhenRejected` timestamp NULL DEFAULT NULL,
`WhenConfirmed` timestamp NULL DEFAULT NULL,
`WhenUnfriended` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`user1`,`user2`),
KEY `fk_Friendof_EndUser2_idx` (`user2`),
CONSTRAINT `fk_Friendof_EndUser1` FOREIGN KEY (`user1`) REFERENCES `student` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_Friendof_EndUser2` FOREIGN KEY (`user2`) REFERENCES `student` (`Id`) 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 `friendof`
LOCK TABLES `friendof` WRITE;
/*!40000 ALTER TABLE `friendof` DISABLE KEYS */;
INSERT INTO `friendof` VALUES (2,6,’2021-03-08 13:00:00′,NULL,’2021-12-28 13:00:00′,’2022-01-06 13:00:00′),(2,8,’2021-05-23 14:00:00′,NULL,’2021-08-11 14:00:00′,NULL),(2,3,’2021-02-07 13:00:00′,’2021-07-17 14:00:00′,NULL,NULL),(3,7,’2021-01-04 13:00:00′,NULL,’2021-08-13 14:00:00′,NULL),(3,8,’2021-01-29 13:00:00′,NULL,’2021-07-08 14:00:00′,’2022-06-30 13:00:00′),(6,8,’2021-03-17 13:00:00′,NULL,’2021-09-01 14:00:00′,NULL),(2,7,’2021-04-30 14:00:00′,’2021-11-06 13:00:00′,NULL,NULL),(6,7,’2021-03-02 13:00:00′,NULL,’2021-08-09 14:00:00′,NULL),(7,8,’2021-04-23 14:00:00′,NULL,’2021-07-01 14:00:00′,NULL),(2,10,’2021-02-09 13:00:00′,NULL,’2021-09-21 14:00:00′,NULL),(3,10,’2021-02-09 13:00:00′,NULL,’2021-02-10 13:00:00′,NULL),(6,10,’2021-02-09 14:00:00′,NULL,NULL,NULL);
/*!40000 ALTER TABLE `friendof` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `following`
DROP TABLE IF EXISTS `following`;
CREATE TABLE `following` (
`Follower` int(11) NOT NULL,
`Following` int(11) NOT NULL,
`WhenStartedFollowing` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`Follower`,`Following`),
KEY `fk_Friendof_EndUser2_idx` (`Following`),
CONSTRAINT `fk_Following_EndUser1` FOREIGN KEY (`Follower`) REFERENCES `generaluser` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_Following_EndUser2` FOREIGN KEY (`Following`) REFERENCES `generaluser` (`Id`) 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 `following`
LOCK TABLES `following` WRITE;
/*!40000 ALTER TABLE `following` DISABLE KEYS */;
INSERT INTO `following` VALUES (1,2,’2021-03-08 13:00:00′),(1,8,’2021-05-23 14:00:00′),(1,3,’2021-02-07 13:00:00′),(2,3,’2021-01-04 13:00:00′),(3,8,’2021-01-29 13:00:00′),(3,1,’2021-03-17 13:00:00′),(2,6,’2021-04-30 14:00:00′);
/*!40000 ALTER TABLE `following` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `admin`
DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin` (
`Id` int(11) NOT NULL,
`Phone` char(12) NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `fk_Moderator_User1` FOREIGN KEY (`Id`) REFERENCES `user` (`Id`) 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 `admin`
LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (4,’83441234′),(5,’83444321′),(9,’83444000′);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `upvote`
DROP TABLE IF EXISTS `upvote`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upvote` (
`Post` int(11) NOT NULL,
`User` int(11) NOT NULL,
`WhenUpvoted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`Post`,`User`),
KEY `fk_LikePost_Post1_idx` (`Post`),
KEY `fk_LikePost_User1_idx` (`User`),
CONSTRAINT `fk_LikePost_Post1` FOREIGN KEY (`Post`) REFERENCES `post` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_LikePost_User1` FOREIGN KEY (`User`) REFERENCES `user` (`Id`) 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 `upvote`
LOCK TABLES `upvote` WRITE;
/*!40000 ALTER TABLE `upvote` DISABLE KEYS */;
INSERT INTO `upvote` VALUES (1,4,’2022-06-30 13:00:00′),(1,5,’2022-06-29 13:00:00′),(1,9,’2022-07-22 14:00:00′),(2,2,’2022-04-02 13:00:00′),(2,9,’2022-03-18 13:00:00′),(3,1,’2022-07-12 14:00:00′),(3,2,’2022-11-03 13:00:00′),(3,8,’2022-08-21 14:00:00′),(3,10,’2022-01-30 13:00:00′),(4,5,’2022-06-19 14:00:00′),(4,7,’2022-08-08 14:00:00′),(5,3,’2022-07-04 14:00:00′),(7,1,’2022-09-10 14:00:00′),(7,4,’2022-11-21 13:00:00′),(7,6,’2022-12-29 13:00:00′),(10,6,’2022-10-28 13:00:00′),(12,6,’2022-09-04 14:00:00′),(15,6,’2022-08-26 14:00:00′),(17,5,’2022-08-10 14:00:00′),(21,5,’2022-08-13 14:00:00′),(23,6,’2022-05-12 14:00:00′),(25,6,’2022-08-10 14:00:00′),(26,3,’2022-09-24 13:00:00′),(30,1,’2022-04-25 14:00:00′),(32,5,’2022-05-11 14:00:00′),(32,7,’2022-01-27 13:00:00′),(38,4,’2022-03-27 13:00:00′),(39,9,’2022-05-28 14:00:00′),(39,10,’2022-09-30 14:00:00′),(41,10,’2022-07-29 14:00:00′),(44,1,’2022-04-25 13:00:00′),(46,4,’2022-03-29 13:00:00′),(47,6,’2022-01-04 13:00:00′),(49,1,’2022-08-07 14:00:00′),(54,10,’2022-07-24 14:00:00′),(55,7,’2022-12-31 14:00:00′),(58,5,’2022-08-21 14:00:00′),(59,10,’2022-11-28 13:00:00′),(60,7,’2022-12-24 13:00:00′),(63,1,’2022-10-28 13:00:00′),(63,5,’2022-08-04 14:00:00′),(64,6,’2022-02-07 13:00:00′),(64,7,’2022-12-07 13:00:00′),(67,7,’2022-07-20 14:00:00′),(71,8,’2022-05-24 14:00:00′),(72,4,’2022-07-20 14:00:00′),(75,8,’2022-11-19 13:00:00′),(77,9,’2022-07-18 14:00:00′),(78,8,’2022-04-01 13:00:00′),(80,6,’2022-07-02 14:00:00′);
/*!40000 ALTER TABLE `upvote` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `post`
DROP TABLE IF EXISTS `post`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `post` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`PostedBy` int(11) NOT NULL,
`Forum` int(11) DEFAULT NULL,
`Content` text NOT NULL,
`ParentPost` int(11) DEFAULT NULL,
`WhenPosted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`Id`),
KEY `fk_Post_Forum1_idx` (`Forum`),
KEY `fk_Post_User1_idx` (`PostedBy`),
KEY `fk_Post_Forum2_idx` (`ParentPost`),
CONSTRAINT `fk_Post_Forum1` FOREIGN KEY (`Forum`) REFERENCES `forum` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_Post_Forum2` FOREIGN KEY (`ParentPost`) REFERENCES `post` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_Post_User1` FOREIGN KEY (`PostedBy`) REFERENCES `user` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
— Dumping data for table `post`
LOCK TABLES `post` WRITE;
/*!40000 ALTER TABLE `post` DISABLE KEYS */;
INSERT INTO `post` VALUES (1,4,NULL,’April is the cruellest month, breeding’,4,’2022-06-04 01:00:00′ ),(2,4,3,’Lilacs out of the dead land, mixing’,NULL,’2022-03-11 00:00:00′ ),(3,3,NULL,’Memory and desire, stirring’,17,’2021-11-04 00:00:00′ ),(4,3,NULL,’Dull roots with spring rain.’,68,’2022-06-03 02:00:00′ ),(5,3,NULL,’Winter kept us warm, covering’,38,’2021-01-01 00:00:00′ ),(6,3,NULL,’Earth in forgetful snow, feeding’,75,’2022-06-05 00:00:00′ ),(7,3,NULL,’A little life with dried tubers.’,6,’2022-06-07 00:00:00′ ),(8,5,NULL,’Summer surprised us, coming over the Starnbergersee’,76,’2022-07-20 00:00:00′ ),(9,5,NULL,’With a shower of rain; we stopped in the colonnade,’,21,’2022-02-19 00:00:00′ ),(10,4,3,’And went on in sunlight, into the Hofgarten,’,NULL,’2022-07-21 00:00:00′ ),(11,4,1,’And drank coffee, and talked for an hour.’,NULL,’2021-12-07 00:00:00′ ),(12,6,NULL,’Bin gar keine Russin, stamm aus Litauen, echt deutsch.’,70,’2022-06-25 00:00:00′ ),(13,5,NULL,’And when we were children, staying at the arch-dukes,’,3,’2022-03-17 00:00:00′ ),(14,4,NULL,’My cousins, he took me out on a sled,’,49,’2022-08-03 01:00:00′ ),(15,4,5,’And I was frightened. He said, Marie,’,NULL,’2022-07-04 00:00:00′ ),(16,4,NULL,’Marie, hold on tight. And down we went.’,94,’2022-03-10 00:00:00′ ),(17,4,NULL,’In the mountains, there you feel free.’,91,’2021-03-04 00:00:00′ ),(18,5,3,’I read, much of the night, and go south in the winter.’,NULL,’2022-08-17 00:00:00′ ),(19,5,NULL,’What are the roots that clutch, what branches grow’,24,’2022-06-02 00:00:00′ ),(20,4,NULL,’Out of this stony rubbish Son of man,’,28,’2022-05-13 00:00:00′ ),(21,4,NULL,’You cannot say, or guess, for you know only’,37,’2022-02-18 00:00:00′ ),(22,5,5,’A heap of broken images, where the sun beats,’,NULL,’2022-06-24 00:00:00′ ),(23,6,5,’And the dead tree gives no shelter, the cricket no relief,’,NULL,’2021-07-11 01:00:00′ ),(24,4,NULL,’And the dry stone no sound of water. Only’,83,’2022-06-01 00:00:00′ ),(25,4,4,’There is shadow under this red rock,’,NULL,’2022-07-01 01:00:00′ ),(26,4,3,'(Come in under the shadow of this red rock),’,NULL,’2022-07-30 00:00:00′ ),(27,5,3,’And I will show you something different from either’,NULL,’2022-03-22 00:00:00′ ),(28,4,4,’Your shadow at morning striding behind you’,NULL,’2022-04-29 00:00:00′ ),(29,5,NULL,’Or your shadow at evening rising to meet you;’,56,’2022-03-26 00:00:00′ ),(30,4,1,’I will show you fear in a handful of dust.’,NULL,’2021-12-25 00:00:00′ ),(31,2,2,’Frisch weht der Wind’,NULL,’2022-06-10 00:00:00′ ),(32,1,2,’ zu’,NULL,’2021-02-19 00:00:00′ ),(33,2,NULL,’ Kind,’,20,’2022-06-18 00:00:00′ ),(34,1,NULL,’Wo weilest du?’,51,’2022-04-20 00:00:00′ ),(35,4,NULL,’\”You gave me hyacinths first a year ago;’,71,’2021-11-04 00:00:00′ ),(36,4,1,’\”They called me the hyacinth girl.\”‘,NULL,’2021-12-19 00:00:00′ ),(37,6,NULL,’Yet when we came back, late, from the Hyacinth garden,’,83,’2022-02-17 00:00:00′ ),(38,5,3,’Your arms full, and your hair wet, I could not’,NULL,’2021-01-01 00:00:00′ ),(39,4,3,’Speak, and my eyes failed, I was neither’,NULL,’2022-05-02 00:00:00′ ),(40,4,NULL,’Living nor dead, and I knew nothing,’,75,’2021-10-06 00:00:00′ ),(41,5,1,’Looking into the heart of light, the silence.’,NULL,’2021-12-09 00:00:00′ ),(42,2,4,’Oed und leer das Meer.’,NULL,’2022-05-06 01:00:00′ ),(43,4,NULL,’Madame Sosostris, famous clairvoyante,’,98,’2021-11-09 00:00:00′ ),(44,3,NULL,’Had a bad cold, nevertheless’,100,’2022-04-15 00:00:00′ ),(45,4,1,’Is known to be the wisest woman in Europe,’,NULL,’2021-06-09 00:00:00′ ),(46,4,1,’With a wicked pack of cards. Here, said she,’,NULL,’2021-07-01 00:00:00′ ),(47,4,1,’Is your card, the drowned Phoenician Sailor,’,NULL,’2021-12-16 00:00:00′ ),(48,4,1,'(Those are pearls that were his eyes. Look!)’,NULL,’2021-11-21 00:00:00′ ),(49,4,NULL,’Here is Belladonna, the Lady of the Rocks,’,25,’2022-07-03 01:00:00′ ),(50,2,4,’The lady of situations.’,NULL,’2022-06-21 00:00:00′ ),(51,5,NULL,’Here is the man with three staves, and here the Wheel,’,32,’2021-02-20 00:00:00′ ),(52,5,NULL,’And here is the one-eyed merchant, and this card,’,78,’2022-06-12 00:00:00′ ),(53,5,3,’Which is blank, is something he carries on his back,’,NULL,’2022-07-16 00:00:00′ ),(54,4,NULL,’Which I am forbidden to see. I do not find’,90,’2021-11-11 00:00:00′ ),(55,4,NULL,’The Hanged Man. Fear death by water.’,4,’2022-11-28 00:00:00′ ),(56,5,NULL,’I see crowds of people, walking round in a ring.’,98,’2022-02-10 00:00:00′ ),(57,4,NULL,’Thank you. If you see dear Mrs. Equitone,’,40,’2022-08-23 01:00:00′ ),(58,4,2,’Tell her I bring the horoscope myself:’,NULL,’2022-06-20 00:00:00′ ),(59,3,NULL,’One must be so careful these days.’,5,’2022-04-17 00:00:00′ ),(60,1,NULL,’Unreal City,’,42,’2022-07-19 00:00:00′ ),(61,4,4,’Under the brown fog of a winter dawn,’,NULL,’2021-06-18 00:00:00′ ),(62,4,NULL,’A crowd flowed over London Bridge, so many,’,90,’2022-03-28 00:00:00′ ),(63,4,5,’I had not thought death had undone so many.’,NULL,’2022-07-19 01:00:00′ ),(64,4,NULL,’Sighs, short and infrequent, were exhaled,’,97,’2021-12-22 00:00:00′ ),(65,4,5,’And each man fixed his eyes before his feet.’,NULL,’2022-06-25 00:00:00′ ),(66,5,NULL,’Flowed up the hill and down Street,’,5,’2021-05-02 00:00:00′ ),(67,4,NULL,’To where Saint Mary Woolnoth kept the hours’,45,’2021-07-12 00:00:00′ ),(68,5,NULL,’With a dead sound on the final stroke of nine.’,24,’2022-06-02 03:00:00′ ),(69,6,NULL,’There I saw one I knew, and stopped him, crying: \”Stetson!’,71,’2022-04-10 00:00:00′ ),(70,4,NULL,’You who were with me in the ships at Mylae!’,27,’2022-06-16 00:00:00′ ),(71,4,NULL,’That corpse you planted last year in your garden,’,23,’2021-07-13 02:00:00′), (72,5,NULL,’Has it begun to sprout? Will it bloom this year?’,67,’2021-12-31 00:00:00′ ),(73,4,NULL,’Or has the sudden frost disturbed its bed?’,66,’2021-12-02 00:00:00′ ),(74,5,NULL,’Oh keep the Dog far hence, thats friend to men,’,45,’2022-02-28 00:00:00′ ),(75,4,NULL,’Or with his nails hell dig it up again!’,51,’2021-03-20 00:00:00′ ),(76,5,NULL,’You! hypocrite lecteur! – mon semblable, – mon frere!\”‘,90,’2022-07-18 00:00:00′ ),(77,5,1,’The Chair she sat in, like a burnished throne,’,NULL,’2021-11-18 00:00:00′ ),(78,4,NULL,’Glowed on the marble, where the glass’,13,’2022-03-20 00:00:00′ ),(79,5,2,’Held up by standards wrought with fruited vines’,NULL,’2022-03-24 00:00:00′ ),(80,4,NULL,’From which a golden Cupidon peeped out’,1,’2022-06-25 00:00:00′ ),(81,4,NULL,'(Another hid his eyes behind his wing)’,61,’2021-11-03 00:00:00′ ),(82,5,NULL,’Doubled the flames of sevenbranched candelabra’,86,’2022-03-08 00:00:00′ ),(83,3,NULL,’Reflecting light upon the table as’,89,’2022-02-16 00:00:00′ ),(84,4,5,’The glitter of her jewels rose to meet it,’,NULL,’2022-08-16 01:00:00′ ),(85,4,NULL,’From satin cases poured in rich profusion;’,58,’2022-09-06 00:00:00′ ),(86,4,NULL,’In vials of ivory and coloured glass’,40,’2021-11-04 00:00:00′ ),(87,5,1,’Unstoppered, lurked her strange synthetic perfumes,’,NULL,’2021-12-02 00:00:00′ ),(88,5,NULL,’Unguent, powdered, or liquid – troubled, confused’,59,’2022-08-20 00:00:00′ ),(89,5,2,’And drowned the sense in odours; stirred by the air’,NULL,’2022-02-15 00:00:00′ ),(90,5,NULL,’That freshened from the window, these ascended’,92,’2021-07-03 00:00:00′ ),(91,4,4,’In fattening the prolonged candle-flames,’,NULL,’2021-02-24 00:00:00′ ),(92,4,NULL,’Flung their smoke into the laquearia,’,46,’2021-07-02 01:00:00′ ),(93,5,NULL,’Stirring the pattern on the coffered ceiling.’,27,’2022-06-28 00:00:00′ ),(94,3,NULL,’Huge sea-wood fed with copper’,74,’2022-03-02 00:00:00′ ),(95,5,NULL,’Burned green and orange, framed by the coloured stone,’,61,’2022-08-06 00:00:00′ ),(96,4,1,’In which sad light a carved dolphin swam.’,NULL,’2021-12-27 00:00:00′ ),(97,4,NULL,’Above the antique mantel was displayed’,66,’2021-12-15 00:00:00′ ),(98,5,2,’As though a window gave upon the sylvan scene’,NULL,’2021-05-07 00:00:00′ ),(99,5,NULL,’The change of Philomel, by the barbarous king’,78,’2022-03-23 00:00:00′ ),(100,4,NULL,’So rudely forced; yet there the nightingale’,91,’2022-07-30 01:00:00′ ),(101,4,NULL,’Also That corpse you planted last year in your garden,’,31,’2022-06-10 01:00:00′),(102,6,NULL,’Please help me with the assignment!’,31,’2022-06-10 01:00:00′);
/*!40000 ALTER TABLE `post` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `subscribe`
DROP TABLE IF EXISTS `subscribe`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscribe` (
`Forum` int(11) NOT NULL,
`User` int(11) NOT NULL,
`WhenSubscribed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`Forum`,`User`),
KEY `fk_Subscribe_User1_idx` (`User`),
KEY `fk_Subscribe_Forum1_idx` (`Forum`),
CONSTRAINT `fk_Subscribe_Forum1` FOREIGN KEY (`Forum`) REFERENCES `forum` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_Subscribe_User1` FOREIGN KEY (`User`) REFERENCES `user` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
— Dumping data for table `subscribe`
LOCK TABLES `subscribe` WRITE;
/*!40000 ALTER TABLE `subscribe` DISABLE KEYS */;
INSERT INTO `subscribe` VALUES (1,1,’2022-01-04 01:00:00′),(1,2,’2022-01-05 01:00:00′),(1,3,’2022-01-06 01:00:00′),(1,7,’2022-01-10 01:00:00′), (2,2,’2022-02-04 01:00:00′),(3,1,’2021-06-04 01:00:00′),(3,2,’2021-06-04 01:00:00′),(3,9,’2021-06-04 01:00:00′),(3,10,’2021-06-04 01:00:00′);
/*!40000 ALTER TABLE `subscribe` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `generaluser`
DROP TABLE IF EXISTS `generaluser`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `generaluser` (
`Id` int(11) NOT NULL,
`WhenJoined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`Id`),
CONSTRAINT `fk_EndUser_User1` FOREIGN KEY (`Id`) REFERENCES `user` (`Id`) 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 `generaluser`
LOCK TABLES `generaluser` WRITE;
/*!40000 ALTER TABLE `generaluser` DISABLE KEYS */;
INSERT INTO `generaluser` VALUES (1,’2021-01-04 01:00:00′),(2,’2020-06-04 01:10:00′),(3,’2020-08-04 02:00:00′),(6,’2020-08-04 06:00:00′),(7,’2021-01-02 01:00:00′),(8,’2020-06-06 01:00:00′),(10,’2021-02-07 01:00:00′), (11,’2020-09-08 01:00:00′);
/*!40000 ALTER TABLE `generaluser` ENABLE KEYS */;
UNLOCK TABLES;
— Table structure for table `user`
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Username` char(20) NOT NULL,
`Password` varchar(45) NOT NULL,
`Firstname` varchar(45) DEFAULT NULL,
`Lastname` varchar(45) NOT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `Username_UNIQUE` (`Username`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @s
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com