Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

pans9-project/calendar.sql

Go to file
 
 
Cannot retrieve contributors at this time
161 lines (147 sloc) 7.67 KB
Raw Blame
Open in GitHub Desktop
-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 8.0.17 - MySQL Community Server - GPL
-- 服务器OS: Win64
-- HeidiSQL 版本: 10.2.0.5599
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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' */;
-- Dumping database structure for activity1
CREATE DATABASE IF NOT EXISTS `activity3` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `activity3`;
-- Dumping structure for table activity1.activity
CREATE TABLE IF NOT EXISTS `activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text COLLATE utf8_bin NOT NULL,
`description` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`url` text COLLATE utf8_bin NOT NULL,
`location` text COLLATE utf8_bin NOT NULL,
`fromTime` text COLLATE utf8_bin,
`toTime` text COLLATE utf8_bin,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Dumping data for table activity1.activity: ~19 rows (大约)
/*!40000 ALTER TABLE `activity` DISABLE KEYS */;
INSERT INTO `activity` (`id`, `title`, `description`, `url`, `location`, `fromTime`, `toTime`) VALUES
(1, '123', '123 ', '123', '123', NULL, NULL),
(2, '123', '123 ', '123', '123', NULL, NULL),
(3, '123', '123 ', '123', '123', NULL, NULL),
(4, '123', '123 ', '123', '123', NULL, NULL),
(5, '123', '123 ', '123', '123', NULL, NULL),
(6, '123', '123 ', '123', '123', NULL, NULL),
(8, '12312', '12312 ', '12312', '12312', NULL, NULL),
(9, '12312', '12312 ', '12312', '12312', NULL, NULL),
(12, '123', '123 ', '123', '123', NULL, NULL),
(15, '冲浪', '冲浪 ', '冲浪', '冲浪', NULL, NULL),
(16, 'guangjie', 'guangjie ', 'guangjie', 'guangjie', NULL, NULL),
(17, 'asd', 'asd ', 'asd', 'asd', 'Thu Dec 05 2019 03:16:28 GMT+0800 (中国标准时间)', 'Thu Dec 05 2019 04:16:28 GMT+0800 (中国标准时间)'),
(18, 'oop', 'oop ', 'oop', 'oop', 'Thu Dec 05 2019 03:18:01 GMT+0800 (中国标准时间)', 'Thu Dec 05 2019 05:18:01 GMT+0800 (中国标准时间)'),
(19, 'oop', 'oop ', 'oop', 'oop', '十二月-十二月-11-3', '十二月-十二月-11-6'),
(20, 'asdasd', 'asdasd ', 'asdasd', 'asdasd', '十二月-11-3', '十二月-11-6'),
(21, '123', '123 ', '123', '123', 'null-undefined', 'null-123'),
(22, '1231', '123 ', '1231', '123', '12-04-undefined', '12-04-1231'),
(24, 'chong', 'chong ', 'asd', 'chong', '12-11-12', '12-11-14'),
(25, '逛街', '逛街 ', 'guangjie', '广州', 'null-13', 'null-13'),
(26, '逛街', '逛街 ', 'www.bai.com', '广州', '12-05-14', '12-05-16'),
(27, '123', '123 ', '123', '123', '12-05-123', '12-05-123'),
(28, '逛街', '逛街 ', 'www.baidu.com', '广州', '12-12-1', '12-12-3');
/*!40000 ALTER TABLE `activity` ENABLE KEYS */;
-- Dumping structure for table activity1.calendar
CREATE TABLE IF NOT EXISTS `calendar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`location` text COLLATE utf8_bin NOT NULL,
`userId` int(11) NOT NULL,
`activityId` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Dumping data for table activity1.calendar: ~13 rows (大约)
/*!40000 ALTER TABLE `calendar` DISABLE KEYS */;
INSERT INTO `calendar` (`id`, `date`, `location`, `userId`, `activityId`) VALUES
(3, '十二月-4', '12312', 1, 8),
(4, '十二月-4', '12312', 1, 9),
(7, '十二月-12', '123', 1, 12),
(10, '十二月-12', '逛街', 2, 15),
(11, '十二月-11', '冲浪', 1, 16),
(12, '十二月-11', 'asd', 1, 17),
(13, '十二月-11', 'oop', 1, 18),
(14, '十二月-11', 'oop', 1, 19),
(15, '十二月-11', 'asdasd', 1, 20),
(16, 'null', '123', 1, 21),
(17, '12-04', '123', 1, 22),
(19, '12-11', 'chong', 1, 24),
(20, '12-12', '广州', 6, 28);
/*!40000 ALTER TABLE `calendar` ENABLE KEYS */;
-- Dumping structure for table activity1.comments
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`activityId` int(11) NOT NULL,
`allText` text COLLATE utf8_bin NOT NULL,
`dateCreated` text COLLATE utf8_bin NOT NULL,
`dateModified` text COLLATE utf8_bin,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Dumping data for table activity1.comments: ~11 rows (大约)
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
INSERT INTO `comments` (`id`, `userId`, `activityId`, `allText`, `dateCreated`, `dateModified`) VALUES
(1, 1, 10, '123', '1575550835360', NULL),
(2, 1, 10, 'asdas', '1575552995949', NULL),
(3, 2, 14, '我喜欢冲浪 !!!!', '1575556446119', NULL),
(4, 2, 15, '冲浪', '1575556635350', NULL),
(5, 1, 16, '逛街', '1575557037150', NULL),
(6, 2, 16, '好的', '1575557064605', NULL),
(7, 1, 16, '123123', '1575785968681', NULL),
(8, 1, 24, 'haode', '1575786059921', NULL),
(9, 6, 28, 'ok，去不去？', '1575788844248', NULL),
(10, 6, 28, 'ok，去不去？', '1575788844249', NULL),
(11, 1, 28, '我去', '1575788884628', NULL);
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
-- Dumping structure for table activity1.taggedusers
CREATE TABLE IF NOT EXISTS `taggedusers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`taggedUserId` int(11) NOT NULL,
`taggedByUserId` int(11) NOT NULL,
`calendarItemId` int(11) NOT NULL,
`accepted` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Dumping data for table activity1.taggedusers: ~9 rows (大约)
/*!40000 ALTER TABLE `taggedusers` DISABLE KEYS */;
INSERT INTO `taggedusers` (`id`, `taggedUserId`, `taggedByUserId`, `calendarItemId`, `accepted`) VALUES
(5, 2, 1, 7, 1),
(8, 1, 2, 10, 0),
(9, 2, 1, 11, 1),
(10, 2, 1, 12, 0),
(11, 2, 1, 13, 0),
(12, 2, 1, 14, 0),
(13, 2, 1, 15, 0),
(14, 2, 1, 16, 1),
(15, 2, 1, 17, 0),
(17, 2, 1, 19, 0),
(18, 1, 6, 20, 1);
/*!40000 ALTER TABLE `taggedusers` ENABLE KEYS */;
-- Dumping structure for table activity1.user
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_bin NOT NULL,
`password` text COLLATE utf8_bin NOT NULL,
`phone` text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Dumping data for table activity1.user: ~6 rows (大约)
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `name`, `password`, `phone`) VALUES
(1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '1'),
(2, '123', 'e10adc3949ba59abbe56e057f20f883e', '123'),
(3, 'root', 'e10adc3949ba59abbe56e057f20f883e', 'confirm'),
(4, 'qsd', 'e10adc3949ba59abbe56e057f20f883e', '123456_oop'),
(5, 'uu', 'e10adc3949ba59abbe56e057f20f883e', 'uu_123uuuu'),
(6, 'kill', 'e10adc3949ba59abbe56e057f20f883e', 'kill_123');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;