-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.txt
82 lines (71 loc) · 5.7 KB
/
database.txt
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
-- CREATE DATABASE petmeet;
use petmeet;
CREATE TABLE users (
user_id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
email VARCHAR(100) UNIQUE,
password VARCHAR(100) NOT NULL
);
use petmeet;
CREATE TABLE event (
eventId INT AUTO_INCREMENT PRIMARY KEY,
eventTitle VARCHAR(100) NOT NULL,
eventDetail VARCHAR(2000) NOT NULL,
eventPicUrl VARCHAR(500) NULL,
date Date NOT NULL,
timeStart Time NOT NULL,
timeEnd Time NOT NULL,
place VARCHAR(100) NULL,
sponsorId INT NULL,
sponsorName VARCHAR(100) NULL,
sponsorPetId INT ,
sponsorPetName VARCHAR(100) NULL,
partNum INT NULL,
partIdList VARCHAR(500) NULL,
partNameList VARCHAR(2000) NULL,
partStatusList VARCHAR(500) NULL,
likeNum INT NULL,
unLikeNum INT NULL,
favoriteNum INT NULL,
createDate Date NULL,
upateDate Date NULL,
status VARCHAR(100) NULL
);
use petmeet;
CREATE TABLE profile
(id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL,
phone VARCHAR(100) NULL,
location VARCHAR(500) NULL,
password VARCHAR(100) NOT NULL,
personPicUrl VARCHAR(2000) NULL,
bio VARCHAR(100) NOT NULL,
petId INT NULL,
petName VARCHAR(100) NULL,
petAge INT NULL,
petBreed VARCHAR(100) NULL,
petPicUrl VARCHAR(2000) NULL,
status VARCHAR(100) NULL);
use petmeet;
insert into users
values (1,"kara","[email protected]","123456");
insert into users
values (2,"stein","[email protected]","123456");
insert into users
values (3,"yuga","[email protected]","123456");
insert into users
values (4,"james","[email protected]","123456");
insert into users
values (5,"andy","[email protected]","123456");
select * from users;
commit;
-- Query: select * from event
LIMIT 0, 1000
-- Date: 2024-04-13 23:37
*/
INSERT INTO `` (`eventId`,`eventTitle`,`eventDetail`,`eventPicUrl`,`date`,`timeStart`,`timeEnd`,`place`,`sponsorId`,`sponsorName`,`sponsorPetId`,`sponsorPetName`,`partNum`,`partIdList`,`partNameList`,`partStatusList`,`likeNum`,`unLikeNum`,`favoriteNum`,`createDate`,`upateDate`,`status`) VALUES (1,'zhuli pet happy@moutain view park--','zhuli pet happy @moutain view park-- ahahahahahahahahahahahahahahahahahahahahahaha--','','2024-03-10','11:30:00','14:30:00','Mountain View Park--',1,'kara',1,'Wangcai',10,'2,3,5','stein,yuga,andy','Active,Active,Cancel',200,10,2,'2024-03-10','2024-03-12','Active');
INSERT INTO `` (`eventId`,`eventTitle`,`eventDetail`,`eventPicUrl`,`date`,`timeStart`,`timeEnd`,`place`,`sponsorId`,`sponsorName`,`sponsorPetId`,`sponsorPetName`,`partNum`,`partIdList`,`partNameList`,`partStatusList`,`likeNum`,`unLikeNum`,`favoriteNum`,`createDate`,`upateDate`,`status`) VALUES (2,'zhuli222 pet happy@moutain view park','zhuli222 pet happy @moutain view park ahahahahahahahahahahahahahahahahahahahahahaha','','2024-03-10','11:00:00','14:00:00','Mountain View Park',1,'kara',1,'Wangcai',10,'2,3','stein,yuga','Active,Active',200,10,2,'2024-03-15','2024-03-18','Active');
INSERT INTO `` (`eventId`,`eventTitle`,`eventDetail`,`eventPicUrl`,`date`,`timeStart`,`timeEnd`,`place`,`sponsorId`,`sponsorName`,`sponsorPetId`,`sponsorPetName`,`partNum`,`partIdList`,`partNameList`,`partStatusList`,`likeNum`,`unLikeNum`,`favoriteNum`,`createDate`,`upateDate`,`status`) VALUES (3,'zhuli222 pet happy@moutain view park','zhuli222 pet happy @moutain view park ahahahahahahahahahahahahahahahahahahahahahaha','','2024-03-10','11:00:00','14:00:00','Mountain View Park',1,'kara',1,'Wangcai',10,'2,3','stein,yuga','Active,Active',200,10,2,'2024-03-15','2024-03-18','Active');
INSERT INTO `` (`eventId`,`eventTitle`,`eventDetail`,`eventPicUrl`,`date`,`timeStart`,`timeEnd`,`place`,`sponsorId`,`sponsorName`,`sponsorPetId`,`sponsorPetName`,`partNum`,`partIdList`,`partNameList`,`partStatusList`,`likeNum`,`unLikeNum`,`favoriteNum`,`createDate`,`upateDate`,`status`) VALUES (4,'zhuli222 pet happy@moutain view park','zhuli222 pet happy @moutain view park ahahahahahahahahahahahahahahahahahahahahahaha','','2024-03-10','11:00:00','14:00:00','Mountain View Park',1,'kara',1,'Wangcai',10,'2,3','stein,yuga','Active,Active',200,10,2,'2024-03-15','2024-03-18','Active');
INSERT INTO `` (`eventId`,`eventTitle`,`eventDetail`,`eventPicUrl`,`date`,`timeStart`,`timeEnd`,`place`,`sponsorId`,`sponsorName`,`sponsorPetId`,`sponsorPetName`,`partNum`,`partIdList`,`partNameList`,`partStatusList`,`likeNum`,`unLikeNum`,`favoriteNum`,`createDate`,`upateDate`,`status`) VALUES (5,'kara\'s happy time @moutain view!','On March 20th, Mountain View will host an enchanting gathering where our four-legged friends come together for a special doggy date. Set against the scenic backdrop of the city\'s parks and green spaces, this event promises a day of tail-wagging excitement and furry camaraderie. From playful pups to wise old souls, dogs of all ages and breeds will converge to socialize, sniff, and strut their stuff. As their human companions mingle, dogs will romp and frolic, exchanging playful barks and friendly sniffs. Attendees can look forward to a variety of activities, including dog-friendly games, agility courses, and perhaps even a doggy fashion show. Throughout the event, local shelters and rescue organizations will be on hand, showcasing adoptable dogs in search of loving forever homes. It\'s a chance for dog lovers to connect, share stories, and celebrate the unconditional love and joy that our canine companions bring into our lives. So mark your calendars, grab your leashes, and join us for a day filled with laughter, tail wags, and unforgettable moments in the heart of Mountain View.\r\n','','2024-03-10','11:30:00','14:30:00','Mountain View Park',1,'kara2',1,'Wangcai2',1,'2,3,5','stein,yuga,andy','Draft,Active,Cancel',200,10,2,'2024-03-10','2024-03-12','Active');