nick@Vaxis:~$ ssh artemis
Linux artemis 5.10.0-28-amd64 #1 SMP Debian 5.10.209-2 (2024-01-31) x86_64

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Mon May  6 12:38:35 2024 from 136.168.32.41
nick@artemis:~$ echo use database name 3420_timeslots
use database name 3420_timeslots
nick@artemis:~$ echo use username timeslots
use username timeslots
nick@artemis:~$ echo use password 3420 timeslots
use password 3420 timeslots
nick@artemis:~$ mysql -u timeslots -p 3420_timeslots
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BWelcome to the MariaDB monitor.  Commands end with ; or \g.
BBYour MariaDB connection id is 8709
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10

BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

BMariaDB [3420_timeslots]> show tables;
+--------------------------+
| Tables_in_3420_timeslots |
+--------------------------+
| demo_times		   |
| group_names		   |
| group_times		   |
| view_available_times	   |
| view_unscheduled_groups  |
+--------------------------+
B5 rows in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> select * from demo_times;
+----------+
| timeslot |
+----------+
| 14:00:00 |
| 14:12:00 |
| 14:24:00 |
| 14:36:00 |
| 14:48:00 |
| 15:00:00 |
| 15:12:00 |
| 15:24:00 |
| 15:36:00 |
| 15:48:00 |
| 16:00:00 |
+----------+
B11 rows in set (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from group_names;
+--------------------+
| groupname	     |
+--------------------+
| break time!	     |
| databaes	     |
| databoyz	     |
| dreamsync	     |
| group3part2	     |
| gymjam	     |
| jarf		     |
| malevolentkitchen  |
| onlineordertracker |
| projectfood	     |
| rhymez	     |
+--------------------+
B11 rows in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> select * from group_times;
BEmpty set (0.000 sec)
BB
BMariaDB [3420_timeslots]> select * from view_available_times;
+----------+
| timeslot |
+----------+
| 14:00:00 |
| 14:12:00 |
| 14:24:00 |
| 14:36:00 |
| 14:48:00 |
| 15:00:00 |
| 15:12:00 |
| 15:24:00 |
| 15:36:00 |
| 15:48:00 |
| 16:00:00 |
+----------+
B11 rows in set (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from view_unscheduled_groups;
+--------------------+
| groupname	     |
+--------------------+
| break time!	     |
| databaes	     |
| databoyz	     |
| dreamsync	     |
| group3part2	     |
| gymjam	     |
| jarf		     |
| malevolentkitchen  |
| onlineordertracker |
| projectfood	     |
| rhymez	     |
+--------------------+
B11 rows in set (0.001 sec)
BB
BMariaDB [3420_timeslots]> show create table group_times;
+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table																																																								       |
+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| group_times | CREATE TABLE `group_times` (
  `groupname` varchar(50) NOT NULL,
  `timeslot` time DEFAULT NULL,
  PRIMARY KEY (`groupname`),
  UNIQUE KEY `timeslot` (`timeslot`),
  CONSTRAINT `group_times_ibfk_1` FOREIGN KEY (`timeslot`) REFERENCES `demo_times` (`timeslot`),
  CONSTRAINT `group_times_ibfk_2` FOREIGN KEY (`groupname`) REFERENCES `group_names` (`groupname`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci |
+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
B1 row in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> insert into group_times values ("break time!", "15:00:00");
BQuery OK, 1 row affected (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from view_available_times;
+----------+
| timeslot |
+----------+
| 14:00:00 |
| 14:12:00 |
| 14:24:00 |
| 14:36:00 |
| 14:48:00 |
| 15:12:00 |
| 15:24:00 |
| 15:36:00 |
| 15:48:00 |
| 16:00:00 |
+----------+
B10 rows in set (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from view_unscheduled_groups;
+--------------------+
| groupname	     |
+--------------------+
| databaes	     |
| databoyz	     |
| dreamsync	     |
| group3part2	     |
| gymjam	     |
| jarf		     |
| malevolentkitchen  |
| onlineordertracker |
| projectfood	     |
| rhymez	     |
+--------------------+
B10 rows in set (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from group_times;
+-------------+----------+
| groupname   | timeslot |
+-------------+----------+
| break time! | 15:00:00 |
+-------------+----------+
B1 row in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> exit
BBye
Bnick@artemis:~$ exit
logout
Connection to artemis.cs.csub.edu closed.
nick@Vaxis:~$ exit
exit