nick@Vaxis:~$ ssh artemis
Linux artemis 4.19.0-18-amd64 #1 SMP Debian 4.19.208-1 (2021-09-29) 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: Thu May 11 13:13:14 2023 from 136.168.36.190
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 485
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 * fromddemo_times;
+----------+
| timeslot |
+----------+
| 14:00:00 |
| 14:15:00 |
| 14:30:00 |
| 14:45:00 |
| 15:00:00 |
| 15:15:00 |
| 15:30:00 |
| 15:45:00 |
| 16:00:00 |
| 16:15:00 |
+----------+
B10 rows in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> select * from group_names;
+-------------------+
| groupname	    |
+-------------------+
| anibase	    |
| autosource	    |
| harwaremerchants  |
| honestcollective  |
| lostchapter	    |
| luxuryautomotives |
| mealdb	    |
| plantpage	    |
| sparksocial	    |
| thriftstore	    |
+-------------------+
B10 rows in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> select * from view_available_times;
+----------+
| timeslot |
+----------+
| 14:00:00 |
| 14:15:00 |
| 14:30:00 |
| 14:45:00 |
| 15:00:00 |
| 15:15:00 |
| 15:30:00 |
| 15:45:00 |
| 16:00:00 |
| 16:15:00 |
+----------+
B10 rows in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> select * from view_unscheduled_groups;
+-------------------+
| groupname	    |
+-------------------+
| anibase	    |
| autosource	    |
| harwaremerchants  |
| honestcollective  |
| lostchapter	    |
| luxuryautomotives |
| mealdb	    |
| plantpage	    |
| sparksocial	    |
| thriftstore	    |
+-------------------+
B10 rows in set (0.000 sec)
BB
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]> 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`)
) 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 ('anibase', '14:00:00');
BQuery OK, 1 row affected (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from view_unscheduled_groups;
+-------------------+
| groupname	    |
+-------------------+
| autosource	    |
| harwaremerchants  |
| honestcollective  |
| lostchapter	    |
| luxuryautomotives |
| mealdb	    |
| plantpage	    |
| sparksocial	    |
| thriftstore	    |
+-------------------+
B9 rows in set (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from view_available_times;
+----------+
| timeslot |
+----------+
| 14:15:00 |
| 14:30:00 |
| 14:45:00 |
| 15:00:00 |
| 15:15:00 |
| 15:30:00 |
| 15:45:00 |
| 16:00:00 |
| 16:15:00 |
+----------+
B9 rows in set (0.001 sec)
BB
BMariaDB [3420_timeslots]> select * from group_times;
+-----------+----------+
| groupname | timeslot |
+-----------+----------+
| anibase   | 14:00:00 |
+-----------+----------+
B1 row in set (0.000 sec)
BB
BMariaDB [3420_timeslots]> delete from group_times;
ERROR 1142 (42000): DELETE command denied to user 'timeslots'@'localhost' for table `3420_timeslots`.`group_times`
BBMariaDB [3420_timeslots]> exit
BBye
Bnick@artemis:~$ exit
logout
Connection to artemis.cs.csub.edu closed.
nick@Vaxis:~$ exit
exit