Dropbox-React-SpringBoot/database_dump.sql at master · gneatfosacho/Dropbox-React-SpringBoot · GitHub

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
create database cmpe273;

use cmpe273;

create table files
(
	filename varchar(255) not null,
	filepath varchar(500) not null
		primary key,
	fileparent varchar(500) null,
	isfile varchar(1) null,
	starred varchar(1) null,
	owner varchar(255) null,
	sharedcount int null
)
;

create table groupmembers
(
	id int auto_increment
		primary key,
	groupId int null,
	email varchar(200) null
)
;

create index groupmembers_groups_groupId_fk
	on groupmembers (groupId)
;

create index groupmembers_users_email_fk
	on groupmembers (email)
;

create table groups
(
	groupId int auto_increment
		primary key,
	groupname varchar(200) null,
	membercount int null,
	owner varchar(200) null
)
;

create index groups_users_email_fk
	on groups (owner)
;

alter table groupmembers
	add constraint groupmembers_groups_groupId_fk
		foreign key (groupId) references groups (groupId)
;

create table members
(
	memberId int auto_increment
		primary key,
	firstname varchar(200) null,
	lastname varchar(200) null,
	email varchar(200) null
)
;

create table userfiles
(
	ID int auto_increment
		primary key,
	filepath varchar(500) null,
	email varchar(500) null,
	constraint userfiles_ibfk_1
		foreign key (filepath) references files (filepath)
)
;

create index email
	on userfiles (email)
;

create index filepath
	on userfiles (filepath)
;

create table userlog
(
	ID int auto_increment
		primary key,
	filename varchar(255) null,
	filepath varchar(500) null,
	isfile varchar(1) null,
	email varchar(500) null,
	action varchar(100) null,
	actiontime varchar(100) null
)
;

create index email
	on userlog (email)
;

create table users
(
	firstname varchar(255) not null,
	lastname varchar(255) null,
	email varchar(500) not null
		primary key,
	password varchar(255) null,
	contact varchar(255) null,
	interests varchar(255) null,
	lastlogin varchar(255) null
)
;

alter table groupmembers
	add constraint groupmembers_users_email_fk
		foreign key (email) references users (email)
;

alter table groups
	add constraint groups_users_email_fk
		foreign key (owner) references users (email)
;

alter table userfiles
	add constraint userfiles_ibfk_2
		foreign key (email) references users (email)
;

alter table userlog
	add constraint userlog_ibfk_1
		foreign key (email) references users (email)
;