proyecto1-nodejs/scripts.sql at main · JONATANZCH/proyecto1-nodejs · 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
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
insert
	into
	teachers
(first_name,
	last_name,
	birthday,
	age,
	email,
	phone)
values ('DavidJonatan',
'Chavez',
'1995-03-16',
28,
'david@academlo.com',
'+52 1 111 555 9999'),
('Juan',
'Rodolfo',
'1996-01-01',
25,
'juan@academlo.com',
'+52 1 111 555 9999');

insert
	into
	levels
("name",
	description)
values
('Beginner',
'for beginners'),
('Intermediate'),
('Advanced',
'The end of the course and the experience.');

insert
	into
	categories
(title,
	description)
values
('Web Development Basics',
'The begin of the web development.'),
('Front End with React',
'Learning React.js for Front End.');

insert
	into
	users
(nickname,
	first_name,
	last_name,
	birthday,
	age,
	email,
	"password",
	phone)
values
('pierinacorz',
'Pierina',
'Corzo',
'1991-08-31',
31,
'pierinacorz@gmail.com',
'root',
'+52 1 868 250 3757'),
('eloysand',
'Eloy',
'Sandoval',
'1990-07-15',
32,
'eloysand@gmail.com',
'root',
'+52 1 333 000 8181')
('GenesisMorales',
'Genesis',
'Morales',
'1996-09-08',
25,
'genesis@gmail.com',
'root',
'+52 1 553 880 8881');

insert
	into
	courses
(title,
	summary,
	description,
	level_id,
	teacher_id)
values
('HTML + CSS + JavaScript',
'Basics of the web development. Create interactive web pages.',
'The student will be acquire knowledge about HTML, CSS and JavaScript for the creation of modern web pages.',
1,
1),
('React.js: Crash Course',
'Create modern web apps with React, the library of Meta..',
'The student will be apply HTML, CSS and JavaScript for develop One Single App Pages.',
1,
1);

insert
	into
	course_category
(course_id,
	category_id)
values
(1,
1),
(2,
2);

insert
	into
	course_video
(title,
	summary,
	description,
	url,
	id_course)
values
('Introduction',
'Web development, the begin.',
'The history of the web development.',
'academlo.com/basics/introduction',
1),
('Introduction',
'Front End, the evolution of the Web Development',
'Using the library from Meta: React.js. Creating Modern Web apps.',
'academlo.com/react/introduction',
2);

insert
	into
	user_course
(course_id,
	user_id)
values
(1,
1),
(2,
1),
(1,
2),
(2,
2);