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: Wed Mar 29 13:00:11 2023 from 136.168.38.8 nick@artemis:~$ clear nick@artemis:~$ mysql companys23 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 45805 Server version: 10.3.36-MariaDB-0+deb10u2 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 [companys23]> select * from Dependent; +-------------+-------+------------+--------------+ | SSN | Dname | Bdate | Relationship | +-------------+-------+------------+--------------+ | 123-45-6789 | Banjo | 2016-03-17 | Cat | +-------------+-------+------------+--------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> select * from Employee where SSN = '123-45-6789'; +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> delete from Employee where SSN = '123-45-6789'; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`companys23`.`Dependent`, CONSTRAINT `Dependent_ibfk_1` FOREIGN KEY (`SSN`) REFERENCES `Employee` (`SSN`)) BBMariaDB [companys23]> show create table Dependent; +-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Dependent | CREATE TABLE `Dependent` ( `SSN` char(11) NOT NULL, `Dname` varchar(40) NOT NULL, `Bdate` date DEFAULT NULL, `Relationship` varchar(20) DEFAULT NULL, PRIMARY KEY (`SSN`,`Dname`), CONSTRAINT `Dependent_ibfk_1` FOREIGN KEY (`SSN`) REFERENCES `Employee` (`SSN`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> alter table Dependent drop constraint `Dependent_ibfk_1`; BQuery OK, 0 rows affected (0.030 sec) BBRecords: 0 Duplicates: 0 Warnings: 0 BB E;ariaDB [companys23]> alter table Dependent add foreign key (SSN) REFERENCES Employee(SSN) ON DELETE CASCADE ON UPDATE CASCAD BQuery OK,f12rownaffectede(0.014 sec) of stage done BBRecords: 1 Duplicates: 0 Warnings: 0 BB E;dropDconstraints`Dependent_ibfk_1`;pendent add foreign key (SSN) REFERENCES Employee(SSN) ON DELETE CASCADE ON UPDATE CASCADE show create table Dependent; +-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Dependent | CREATE TABLE `Dependent` ( `SSN` char(11) NOT NULL, `Dname` varchar(40) NOT NULL, `Bdate` date DEFAULT NULL, `Relationship` varchar(20) DEFAULT NULL, PRIMARY KEY (`SSN`,`Dname`), CONSTRAINT `Dependent_ibfk_1` FOREIGN KEY (`SSN`) REFERENCES `Employee` (`SSN`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.001 sec) BB E;droptconstraintd`Dependent_ibfk_1`;b(SSN)pREFERENCES Employee(SSN) ON DELETE CASCADE ON UPDATE CASCADE createtempoarytablemeasselect* = '123-45-6789'; BQuery OK, 1 row affected (0.006 sec) BBRecords: 1 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> select * from me; +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ B1 row in set (0.000 sec) BB E;droptconstraintd`Dependent_ibfk_1`;r(SSN)lREFERENCESlEmployee(SSN)pONyDELETErCASCADE ON2UPDATE7CASCADE deleter*rom EmployeepwheretSSN = '123-45-6789'; BQuery OK, 1 row affected (0.001 sec) BB BMariaDB [companys23]> selectd*nfromfWorksOn limit 1; +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 108-30-6419 | 4 | 41.97 | +-------------+---------+-------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> select * from WorksOn order by rand() +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 735-36-0902 | 3 | 28.33 | +-------------+---------+-------+ B1 row in set (0.001 sec) BB deleteDfromoEmployee]whereeSSN*=f'735-36-0902';der by rand() limit 1; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`companys23`.`WorksOn`, CONSTRAINT `WorksOn_ibfk_1` FOREIGN KEY (`SSN`) REFERENCES `Employee` (`SSN`)) BBMariaDB [companys23]> show create table WorksOn; +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | WorksOn | CREATE TABLE `WorksOn` ( `SSN` char(11) NOT NULL, `Pnumber` int(11) NOT NULL, `Hours` float DEFAULT NULL, PRIMARY KEY (`SSN`,`Pnumber`), KEY `Pnumber` (`Pnumber`), CONSTRAINT `WorksOn_ibfk_1` FOREIGN KEY (`SSN`) REFERENCES `Employee` (`SSN`), CONSTRAINT `WorksOn_ibfk_2` FOREIGN KEY (`Pnumber`) REFERENCES `Project` (`Pnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> alter table WorksOn drop constraint `WorksOn_ibfk_1`; BQuery OK, 0 rows affected (0.002 sec) BBRecords: 0 Duplicates: 0 Warnings: 0 BB ;MariaDB [companys23]> alter table WorksOnaddoforeignrkeyt(SSN)kREFERENCES`Employee(SSN) ON DELETE CASCADE ON UPDATE CASCADE; BQuery OK,f250'rowslaffected'(0.0150sec) stage done BBRecords: 250 Duplicates: 0 Warnings: 0 BB dropiconstraintn`WorksOn_ibfk_1`;e WorksOn add foreign key (SSN) REFERENCES Employee(SSN) ON DELETE CASCADE ON UPDATE CASCADE; show create table WorksOn; +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | WorksOn | CREATE TABLE `WorksOn` ( `SSN` char(11) NOT NULL, `Pnumber` int(11) NOT NULL, `Hours` float DEFAULT NULL, PRIMARY KEY (`SSN`,`Pnumber`), KEY `Pnumber` (`Pnumber`), CONSTRAINT `WorksOn_ibfk_2` FOREIGN KEY (`Pnumber`) REFERENCES `Project` (`Pnumber`), CONSTRAINT `WorksOn_ibfk_3` FOREIGN KEY (`SSN`) REFERENCES `Employee` (`SSN`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.001 sec) BB droprconstraintk`WorksOn_ibfk_1`;eyt(SSN)WREFERENCES Employee(SSN) ON DELETE CASCADE ON UPDATE CASCADE; deleterfrom Employeerwhere SSN = '735-36-0902'; BQuery OK, 1 row affected (0.001 sec) BB BMariaDB [companys23]> select * from WorksOn where SSN = '735-36-0902'; BEmpty set (0.000 sec) BB BMariaDB [companys23]> select SSN from WorksOn order byyrand() limit 1; +-------------+ | SSN | +-------------+ | 893-15-9265 | +-------------+ B1 row in set (0.001 sec) BB BMariaDB [companys23]> update Employee set SSN = '893-15-9266' where SSN = '893-15-9265'; BQuery OK, 1 row affected (0.001 sec) BBRows matched: 1 Changed: 1 Warnings: 0 BB BMariaDB [companys23]> select * from WorksOn where SSNN= '893-15-9266'; +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 893-15-9266 | 3 | 41.96 | | 893-15-9266 | 4 | 5.92 | +-------------+---------+-------+ B2 rows in set (0.000 sec) BB BMariaDB [companys23]> create table EmployeeHistory like Employee; BQuery OK, 0 rows affected (0.005 sec) BB BMariaDB [companys23]> show create table EmployeeHistory; +-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | EmployeeHistory | CREATE TABLE `EmployeeHistory` ( `SSN` char(11) NOT NULL, `Fname` varchar(20) NOT NULL, `Minit` char(1) DEFAULT NULL, `Lname` varchar(20) NOT NULL, `Bdate` date DEFAULT NULL, `Address` varchar(100) DEFAULT NULL, `Salary` decimal(14,2) DEFAULT NULL, `Super_SSN` char(11) DEFAULT NULL, `Dnumber` int(11) DEFAULT NULL, PRIMARY KEY (`SSN`), KEY `Super_SSN` (`Super_SSN`), KEY `Dnumber` (`Dnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.001 sec) BB selectD*afromEEmployeeHistory;ikeeEmployee;ployeeHistory; BEmpty set (0.000 sec) BB BMariaDB [companys23]> insert into Employee select * from me; BQuery OK, 1 row affected (0.001 sec) BBRecords: 1 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> show tables; +----------------------+ | Tables_in_companys23 | +----------------------+ | Department | | DepartmentLocations | | Dependent | | Employee | | EmployeeHistory | | EmployeeSupervisors | | Project | | WorksOn | +----------------------+ B8 rows in set (0.000 sec) BB BMariaDB [companys23]> show triggers; BEmpty set (0.001 sec) BB BMariaDB [companys23]> use company; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BDatabase changed BMariaDB [company]> showctriggers; +-------------------------------+--------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation | +-------------------------------+--------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | UpdateEmployeeCount | INSERT | Employee | BEGIN UPDATE Department SET EmployeeCount = EmployeeCount + 1 Where Number = NEW.DeptNumber; END | BEFORE | 2023-03-06 14:08:29.28 | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | nick@localhost | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ChangeDepartmentEmployeeCount | UPDATE | Employee | BEGIN UPDATE Department SET EmployeeCount = EmployeeCount - 1 Where Number = OLD.DeptNumber; UPDATE Department SET EmployeeCount = EmployeeCount + 1 Where Number = NEW.DeptNumber; END | BEFORE | 2023-03-06 14:08:29.28 | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | nick@localhost | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | DeleteEmployee | DELETE | Employee | BEGIN INSERT INTO EmployeeHistory (SSN, Bdate, Fname, Minit, Lname, Address, Salary, DeptNumber, SupervisorSSN) VALUES (OLD.SSN, OLD.Bdate, OLD.Fname, OLD.Minit, OLD.Lname, OLD.Address, OLD.Salary, OLD.DeptNumber, OLD.SupervisorSSN); UPDATE Department SET Employee = EmployeeCount - 1 Where Number = OLD.DeptNumber; END | BEFORE | 2023-03-06 14:08:29.28 | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | nick@localhost | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | +-------------------------------+--------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ B3 rows in set (0.001 sec) BB BMariaDB [company]> showcprocedure status; +---------------------+-----------------------------+-----------+-------------------------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +---------------------+-----------------------------+-----------+-------------------------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | acardenassil | AnswerLab5Question | PROCEDURE | acardenassil@localhost | 2023-03-07 09:50:52 | 2023-03-07 09:50:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | acardenassil | GetNextLab5Question | PROCEDURE | acardenassil@localhost | 2023-03-07 09:50:52 | 2023-03-07 09:50:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | acardenassil | lab5size | PROCEDURE | acardenassil@localhost | 2023-03-07 12:54:26 | 2023-03-07 12:54:26 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | acardenassil | makelab5subset | PROCEDURE | acardenassil@localhost | 2023-03-07 12:54:26 | 2023-03-07 12:54:26 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | amilin | AnswerLab5Question | PROCEDURE | amilin@localhost | 2023-03-10 17:48:51 | 2023-03-10 17:48:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | amilin | GetNextLab5Question | PROCEDURE | amilin@localhost | 2023-03-10 17:48:51 | 2023-03-10 17:48:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | amilin | lab5size | PROCEDURE | amilin@localhost | 2023-03-10 18:18:46 | 2023-03-10 18:18:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | amilin | makelab5subset | PROCEDURE | amilin@localhost | 2023-03-10 18:18:46 | 2023-03-10 18:18:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | aparriott | AnswerLab5Question | PROCEDURE | aparriott@localhost | 2023-02-28 10:18:53 | 2023-02-28 10:18:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | aparriott | GetNextLab5Question | PROCEDURE | aparriott@localhost | 2023-02-28 10:18:53 | 2023-02-28 10:18:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | aparriott | lab5size | PROCEDURE | aparriott@localhost | 2023-02-28 14:25:23 | 2023-02-28 14:25:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | aparriott | makelab5subset | PROCEDURE | aparriott@localhost | 2023-02-28 14:25:23 | 2023-02-28 14:25:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | CalcGallons | PROCEDURE | benco@localhost | 2022-12-10 23:56:13 | 2022-12-10 23:56:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | CreateOrder | PROCEDURE | benco@localhost | 2022-12-08 21:17:07 | 2022-12-08 21:17:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | CustomerLoadCount | PROCEDURE | benco@localhost | 2022-12-08 21:38:47 | 2022-12-08 21:38:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | DeleteOrder | PROCEDURE | benco@localhost | 2022-12-08 21:21:08 | 2022-12-08 21:21:08 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | DispatchLoads | PROCEDURE | benco@localhost | 2022-12-12 03:52:33 | 2022-12-12 03:52:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | InputData | PROCEDURE | benco@localhost | 2022-12-11 16:57:19 | 2022-12-11 16:57:19 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | MassDeliverOrders | PROCEDURE | benco@localhost | 2022-12-11 18:30:04 | 2022-12-11 18:30:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | OrderLoading | PROCEDURE | benco@localhost | 2022-12-11 18:18:59 | 2022-12-11 18:18:59 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | TempCorrectGals | PROCEDURE | benco@localhost | 2022-12-10 00:54:34 | 2022-12-10 00:54:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | ToUpdateCustomer | PROCEDURE | benco@localhost | 2022-12-08 13:24:05 | 2022-12-08 13:24:05 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | benco | UpdateCustomer | PROCEDURE | benco@localhost | 2022-12-08 21:28:56 | 2022-12-08 21:28:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | blockbuster2 | ConvertMovieName | PROCEDURE | blockbuster2@localhost | 2021-12-07 22:19:57 | 2021-12-07 22:19:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | blockbuster2 | DeleteConsumer | PROCEDURE | blockbuster2@localhost | 2021-12-01 15:47:26 | 2021-12-01 15:47:26 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | blockbuster2 | RegisterConsumer | PROCEDURE | blockbuster2@localhost | 2021-12-01 15:23:25 | 2021-12-01 15:23:25 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | blockbuster2 | SearchIMDB | PROCEDURE | blockbuster2@localhost | 2021-12-07 16:13:29 | 2021-12-07 16:13:29 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | blockbuster2 | SearchMovie | PROCEDURE | blockbuster2@localhost | 2021-12-07 18:57:05 | 2021-12-07 18:57:05 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | blockbuster2 | SearchPlatform | PROCEDURE | blockbuster2@localhost | 2021-12-07 20:50:24 | 2021-12-07 20:50:24 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | bobabuddy | AddDrink | PROCEDURE | mfuentesrive@localhost | 2022-11-17 15:27:32 | 2022-11-17 15:27:32 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | bobabuddy | AdjustOrder | PROCEDURE | mfuentesrive@localhost | 2022-11-17 16:32:58 | 2022-11-17 16:32:58 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | bobabuddy | RemoveDrink | PROCEDURE | mfuentesrive@localhost | 2022-11-17 16:15:09 | 2022-11-17 16:15:09 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | bobabuddy | ShowMostPurchased | PROCEDURE | mfuentesrive@localhost | 2022-11-21 11:50:54 | 2022-11-21 11:50:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | booksbooksbooks | spAvgBookPrice | PROCEDURE | booksbooksbooks@localhost | 2021-11-29 22:31:57 | 2021-11-29 22:31:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | booksbooksbooks | spInsertIntoBook | PROCEDURE | booksbooksbooks@localhost | 2021-11-29 21:06:43 | 2021-11-29 21:06:43 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | booksbooksbooks | spRemoveFromBook | PROCEDURE | booksbooksbooks@localhost | 2021-11-29 21:53:14 | 2021-11-29 21:53:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | bookworm | addCustomer | PROCEDURE | cmartinez@localhost | 2021-11-24 13:17:51 | 2021-11-24 13:17:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | bookworm | deleteBook | PROCEDURE | cmartinez@localhost | 2021-11-24 13:42:00 | 2021-11-24 13:42:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | bookworm | mostPopularClub | PROCEDURE | cmartinez@localhost | 2021-11-24 15:00:54 | 2021-11-24 15:00:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | buddydj | AddSongToPlaylist | PROCEDURE | ekyles@localhost | 2022-05-10 11:35:21 | 2022-05-10 11:35:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | buddydj | DeletePlaylist | PROCEDURE | ekyles@localhost | 2022-05-20 10:19:56 | 2022-05-20 10:19:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | buddydj | DeleteSongFromPlaylist | PROCEDURE | ekyles@localhost | 2022-05-20 10:35:27 | 2022-05-20 10:35:27 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | buddydj | MaySongs | PROCEDURE | ekyles@localhost | 2022-05-06 17:52:46 | 2022-05-06 17:52:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | buddydj | NewPlaylist | PROCEDURE | ekyles@localhost | 2022-05-06 17:41:49 | 2022-05-06 17:41:49 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | buddydj | RegisterUser | PROCEDURE | ekyles@localhost | 2022-05-06 16:47:57 | 2022-05-06 16:47:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | buddydj | ShowUserPlaylist | PROCEDURE | ekyles@localhost | 2022-05-10 12:01:43 | 2022-05-10 12:01:43 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cart_pushers | average_sales | PROCEDURE | ewarren@localhost | 2022-05-16 11:27:42 | 2022-05-16 11:27:42 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cart_pushers | CreateCustomer | PROCEDURE | jpereyra@localhost | 2022-05-02 21:55:41 | 2022-05-02 21:55:41 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cart_pushers | DeleteCustomer | PROCEDURE | ewarren@localhost | 2022-05-03 10:22:50 | 2022-05-03 10:22:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cart_pushers | largest_sale | PROCEDURE | ewarren@localhost | 2022-05-19 17:09:10 | 2022-05-19 17:09:10 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cart_pushers | most_prod_purch | PROCEDURE | ewarren@localhost | 2022-05-19 16:52:23 | 2022-05-19 16:52:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cart_pushers | stat | PROCEDURE | ewarren@localhost | 2022-05-19 15:19:25 | 2022-05-19 15:19:25 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cokpara | AddFighter | PROCEDURE | cokpara@localhost | 2022-11-18 16:27:19 | 2022-11-18 16:27:19 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cokpara | dfighter | PROCEDURE | cokpara@localhost | 2022-11-18 16:11:03 | 2022-11-18 16:11:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cokpara | loc | PROCEDURE | cokpara@localhost | 2022-11-18 16:02:54 | 2022-11-18 16:02:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cokpara | rec | PROCEDURE | cokpara@localhost | 2022-11-18 15:04:39 | 2022-11-18 15:04:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cokpara | uwl | PROCEDURE | cokpara@localhost | 2022-11-18 16:10:27 | 2022-11-18 16:10:27 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | cokpara | Wclass | PROCEDURE | cokpara@localhost | 2022-11-18 13:20:12 | 2022-11-18 13:20:12 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | company | ChangeEmployeeDepartment | PROCEDURE | nick@localhost | 2022-11-07 14:12:50 | 2022-11-07 14:12:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | company | GetDepartmentEmployees | PROCEDURE | nick@localhost | 2022-11-28 13:23:33 | 2022-11-28 13:23:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | company | GetEmployees | PROCEDURE | nick@localhost | 2022-11-03 02:39:06 | 2022-11-03 02:39:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | companys23 | ChangeEmployeeDepartment | PROCEDURE | nick@localhost | 2023-03-22 13:24:45 | 2023-03-22 13:24:45 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | companys23 | GetDepartmentEmployees | PROCEDURE | nick@localhost | 2023-03-22 13:16:47 | 2023-03-22 13:16:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | companys23 | GetEmployees | PROCEDURE | nick@localhost | 2023-03-22 13:16:47 | 2023-03-22 13:16:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | companys23 | GetEmployeesByDept | PROCEDURE | nick@localhost | 2023-03-22 13:08:43 | 2023-03-22 13:08:43 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ctennison | AnswerLab5Question | PROCEDURE | ctennison@localhost | 2023-03-02 19:30:47 | 2023-03-02 19:30:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ctennison | GetNextLab5Question | PROCEDURE | ctennison@localhost | 2023-03-02 19:30:47 | 2023-03-02 19:30:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ctennison | lab5size | PROCEDURE | ctennison@localhost | 2023-03-02 20:36:23 | 2023-03-02 20:36:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ctennison | makelab5subset | PROCEDURE | ctennison@localhost | 2023-03-02 20:36:23 | 2023-03-02 20:36:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dcasas | AnswerLab5Question | PROCEDURE | dcasas@localhost | 2023-02-28 14:24:48 | 2023-02-28 14:24:48 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dcasas | GetNextLab5Question | PROCEDURE | dcasas@localhost | 2023-02-28 14:24:48 | 2023-02-28 14:24:48 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dcasas | lab5size | PROCEDURE | dcasas@localhost | 2023-02-28 15:35:01 | 2023-02-28 15:35:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dcasas | makelab5subset | PROCEDURE | dcasas@localhost | 2023-02-28 15:35:01 | 2023-02-28 15:35:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | deejayscafe | AddEmployee | PROCEDURE | deejayscafe@localhost | 2021-11-30 23:39:12 | 2021-11-30 23:39:12 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | deejayscafe | DeleteEmployee | PROCEDURE | deejayscafe@localhost | 2021-12-01 00:09:59 | 2021-12-01 00:09:59 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dmesa | AnswerLab5Question | PROCEDURE | dmesa@localhost | 2023-03-06 23:23:59 | 2023-03-06 23:23:59 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dmesa | GetNextLab5Question | PROCEDURE | dmesa@localhost | 2023-03-06 23:23:59 | 2023-03-06 23:23:59 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dmesa | lab5size | PROCEDURE | dmesa@localhost | 2023-03-07 00:47:34 | 2023-03-07 00:47:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dmesa | makelab5subset | PROCEDURE | dmesa@localhost | 2023-03-07 00:47:34 | 2023-03-07 00:47:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dpham | deleteFlight | PROCEDURE | dpham@localhost | 2022-01-10 18:04:57 | 2022-01-10 18:04:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dpham | limitPrice | PROCEDURE | dpham@localhost | 2022-01-10 18:04:57 | 2022-01-10 18:04:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dpham | mostPopularFlights | PROCEDURE | dpham@localhost | 2022-01-10 18:04:57 | 2022-01-10 18:04:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dpham | newFlight | PROCEDURE | dpham@localhost | 2022-01-10 18:04:57 | 2022-01-10 18:04:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | dpham | openSeats | PROCEDURE | dpham@localhost | 2022-01-10 18:04:57 | 2022-01-10 18:04:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eldenbees | DeleteCampaign | PROCEDURE | sflores@localhost | 2022-12-12 01:26:00 | 2022-12-12 01:26:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eldenbees | HashPasses | PROCEDURE | sflores@localhost | 2022-12-12 02:14:22 | 2022-12-12 02:14:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eldenbees | NewCampaign | PROCEDURE | sflores@localhost | 2022-12-12 01:03:59 | 2022-12-12 01:03:59 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | AppliedJobs | PROCEDURE | eposting@localhost | 2021-12-08 09:52:35 | 2021-12-08 09:52:35 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | deleteApplication | PROCEDURE | eposting@localhost | 2021-12-08 00:22:55 | 2021-12-08 00:22:55 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | deleteEmployee | PROCEDURE | eposting@localhost | 2021-12-07 23:39:03 | 2021-12-07 23:39:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | deleteJob | PROCEDURE | eposting@localhost | 2021-12-07 23:52:52 | 2021-12-07 23:52:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | newApplication | PROCEDURE | eposting@localhost | 2021-12-08 03:49:11 | 2021-12-08 03:49:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | newJoblist | PROCEDURE | eposting@localhost | 2021-12-08 12:49:56 | 2021-12-08 12:49:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | Post_job | PROCEDURE | eposting@localhost | 2021-12-07 20:20:46 | 2021-12-07 20:20:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | RegisterEmployee | PROCEDURE | eposting@localhost | 2021-12-07 21:38:01 | 2021-12-07 21:38:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | RegisterEmployer | PROCEDURE | eposting@localhost | 2021-12-07 21:37:54 | 2021-12-07 21:37:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | eposting | updateResume | PROCEDURE | eposting@localhost | 2021-12-08 12:19:03 | 2021-12-08 12:19:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | erosales | AnswerLab5Question | PROCEDURE | erosales@localhost | 2023-02-28 10:25:01 | 2023-02-28 10:25:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | erosales | GetNextLab5Question | PROCEDURE | erosales@localhost | 2023-02-28 10:25:01 | 2023-02-28 10:25:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | erosales | lab5size | PROCEDURE | erosales@localhost | 2023-02-28 16:52:42 | 2023-02-28 16:52:42 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | erosales | makelab5subset | PROCEDURE | erosales@localhost | 2023-02-28 16:52:42 | 2023-02-28 16:52:42 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | addFiAccount | PROCEDURE | mschmidt@localhost | 2021-12-08 15:02:53 | 2021-12-08 15:02:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | addUser | PROCEDURE | mschmidt@localhost | 2021-12-08 15:02:53 | 2021-12-08 15:02:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | deletecheckingAccountOnly | PROCEDURE | financingfordummies@localhost | 2021-11-24 13:20:23 | 2021-11-24 13:20:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | deleteCheckingOnly | PROCEDURE | mschmidt@localhost | 2021-12-08 15:02:53 | 2021-12-08 15:02:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | deleteLoanOnly | PROCEDURE | mschmidt@localhost | 2021-12-08 15:02:53 | 2021-12-08 15:02:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | deleteSavingsOnly | PROCEDURE | mschmidt@localhost | 2021-12-08 15:02:53 | 2021-12-08 15:02:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | deleteUser | PROCEDURE | mschmidt@localhost | 2021-12-08 15:02:53 | 2021-12-08 15:02:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | financingfordummies | reportAggregates | PROCEDURE | mschmidt@localhost | 2021-12-08 15:02:53 | 2021-12-08 15:02:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flightclub | deleteFlight | PROCEDURE | dpham@localhost | 2022-01-10 17:52:07 | 2022-01-10 17:52:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flightclub | limitPrice | PROCEDURE | dpham@localhost | 2022-01-10 17:52:07 | 2022-01-10 17:52:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flightclub | mostPopularFlights | PROCEDURE | dpham@localhost | 2022-01-10 17:52:07 | 2022-01-10 17:52:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flightclub | newFlight | PROCEDURE | dpham@localhost | 2022-01-10 17:52:07 | 2022-01-10 17:52:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flightclub | openSeats | PROCEDURE | dpham@localhost | 2022-01-10 17:52:07 | 2022-01-10 17:52:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flin | AnswerLab5Question | PROCEDURE | flin@localhost | 2023-02-28 10:29:00 | 2023-02-28 10:29:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flin | GetNextLab5Question | PROCEDURE | flin@localhost | 2023-02-28 10:29:00 | 2023-02-28 10:29:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flin | lab5size | PROCEDURE | flin@localhost | 2023-02-28 11:57:07 | 2023-02-28 11:57:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | flin | makelab5subset | PROCEDURE | flin@localhost | 2023-02-28 11:57:07 | 2023-02-28 11:57:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | AdoptionsCheck | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:15:21 | 2021-12-08 13:15:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | AdoptionsLastMonth | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:14:07 | 2021-12-08 13:14:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | AnimalAdoption | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:15:21 | 2021-12-08 13:15:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | DeleteUser | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:15:21 | 2021-12-08 13:15:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | GenerateID | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:15:21 | 2021-12-08 13:15:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | RegisterEmployee | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:15:21 | 2021-12-08 13:15:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | RegisterUser | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:15:21 | 2021-12-08 13:15:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | furryfriendfinder | UsersAdoptions | PROCEDURE | furryfriendfinder@localhost | 2021-12-08 13:15:21 | 2021-12-08 13:15:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gititfresh | addProduct | PROCEDURE | gititfresh@localhost | 2021-11-19 16:35:35 | 2021-11-19 16:35:35 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gititfresh | customerRegister | PROCEDURE | gititfresh@localhost | 2021-12-07 21:49:07 | 2021-12-07 21:49:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gititfresh | deleteEmployee | PROCEDURE | gititfresh@localhost | 2021-11-19 16:45:34 | 2021-11-19 16:45:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gititfresh | deleteProduct | PROCEDURE | gititfresh@localhost | 2021-11-19 16:51:49 | 2021-11-19 16:51:49 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gititfresh | popularItem | PROCEDURE | gititfresh@localhost | 2021-11-28 16:45:32 | 2021-11-28 16:45:32 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | grading_lab6 | GetNotes | PROCEDURE | nick@localhost | 2022-11-23 02:37:09 | 2022-11-23 02:37:09 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | grading_lab6 | GetScore | PROCEDURE | nick@localhost | 2022-11-23 02:35:16 | 2022-11-23 02:35:16 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | addGold | PROCEDURE | guilddb@localhost | 2022-12-06 02:20:40 | 2022-12-06 02:20:40 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | createActivity | PROCEDURE | guilddb@localhost | 2022-12-12 04:24:41 | 2022-12-12 04:24:41 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | deleteParticipant | PROCEDURE | guilddb@localhost | 2022-12-06 03:33:22 | 2022-12-06 03:33:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | getPlayers | PROCEDURE | guilddb@localhost | 2022-12-05 12:35:25 | 2022-12-05 12:35:25 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | guildActiveStatus | PROCEDURE | guilddb@localhost | 2022-12-07 13:24:52 | 2022-12-07 13:24:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | insertDates | PROCEDURE | guilddb@localhost | 2022-12-06 18:19:01 | 2022-12-06 18:19:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | readme | PROCEDURE | guilddb@localhost | 2022-12-07 13:28:43 | 2022-12-07 13:28:43 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | showGuild | PROCEDURE | guilddb@localhost | 2022-12-09 13:24:16 | 2022-12-09 13:24:16 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | showLeaderboard | PROCEDURE | guilddb@localhost | 2022-12-07 15:26:18 | 2022-12-07 15:26:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | guilddb | showPlayer | PROCEDURE | guilddb@localhost | 2022-12-09 14:07:40 | 2022-12-09 14:07:40 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gymtraffic | ChangeCustomer | PROCEDURE | gymtraffic@localhost | 2022-12-05 13:40:59 | 2022-12-05 13:40:59 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gymtraffic | ChangeCustomerEmail | PROCEDURE | gymtraffic@localhost | 2022-12-11 19:59:16 | 2022-12-11 19:59:16 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gymtraffic | ChangeCustomerPhoneNumber | PROCEDURE | gymtraffic@localhost | 2022-12-11 20:50:42 | 2022-12-11 20:50:42 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gymtraffic | DeleteCustomer | PROCEDURE | gymtraffic@localhost | 2022-12-11 21:06:27 | 2022-12-11 21:06:27 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gymtraffic | NewCustomer | PROCEDURE | gymtraffic@localhost | 2022-12-11 21:43:09 | 2022-12-11 21:43:09 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | gymtraffic | NumofPeopleCheckedIn | PROCEDURE | gymtraffic@localhost | 2022-12-11 21:32:33 | 2022-12-11 21:32:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hallen | AnswerLab5Question | PROCEDURE | hallen@localhost | 2023-03-07 01:32:10 | 2023-03-07 01:32:10 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hallen | GetNextLab5Question | PROCEDURE | hallen@localhost | 2023-03-07 01:32:10 | 2023-03-07 01:32:10 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hallen | lab5size | PROCEDURE | hallen@localhost | 2023-03-07 03:33:02 | 2023-03-07 03:33:02 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hallen | makelab5subset | PROCEDURE | hallen@localhost | 2023-03-07 03:33:02 | 2023-03-07 03:33:02 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hayleeco | ChangeUserLikedSong | PROCEDURE | hallen@localhost | 2022-12-06 20:52:56 | 2022-12-06 20:52:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hayleeco | DeleteUserLikedSong | PROCEDURE | hallen@localhost | 2022-12-07 21:25:01 | 2022-12-07 21:25:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hayleeco | GenreThatAppearsTheMost | PROCEDURE | hallen@localhost | 2022-12-12 05:38:42 | 2022-12-12 05:38:42 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hayleeco | InsertAlbumRecord | PROCEDURE | hallen@localhost | 2022-12-06 01:28:49 | 2022-12-06 01:28:49 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hmmc | addCart | PROCEDURE | hmmc@localhost | 2021-12-05 12:50:28 | 2021-12-05 12:50:28 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hmmc | checkout | PROCEDURE | nick@localhost | 2021-12-06 16:12:09 | 2021-12-06 16:12:09 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hmmc | createAccount | PROCEDURE | hmmc@localhost | 2021-12-04 20:40:01 | 2021-12-04 20:40:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hmmc | removeCart | PROCEDURE | hmmc@localhost | 2021-12-04 16:06:50 | 2021-12-04 16:06:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hmmc | subscribe | PROCEDURE | hmmc@localhost | 2021-12-07 00:51:56 | 2021-12-07 00:51:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hmmc | view_sub | PROCEDURE | hmmc@localhost | 2021-12-07 04:25:01 | 2021-12-07 04:25:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | AddNewEmployee | PROCEDURE | hotelbookingsystem@localhost | 2022-12-10 10:19:47 | 2022-12-10 10:19:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | AddNewHotel | PROCEDURE | hotelbookingsystem@localhost | 2022-12-10 18:29:31 | 2022-12-10 18:29:31 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | AddNewHotels | PROCEDURE | hotelbookingsystem@localhost | 2022-11-10 14:38:51 | 2022-11-10 14:38:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | BookingOrder | PROCEDURE | hotelbookingsystem@localhost | 2022-11-25 18:52:11 | 2022-11-25 18:52:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | CancelOrders | PROCEDURE | hotelbookingsystem@localhost | 2022-12-02 21:14:41 | 2022-12-02 21:14:41 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | ChangeRoomStatus | PROCEDURE | hotelbookingsystem@localhost | 2022-12-09 22:42:38 | 2022-12-09 22:42:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | ConfirmOrders | PROCEDURE | hotelbookingsystem@localhost | 2022-12-02 21:26:57 | 2022-12-02 21:26:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | DeleteEmployeeData | PROCEDURE | hotelbookingsystem@localhost | 2022-12-10 10:43:53 | 2022-12-10 10:43:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | deleteHotels | PROCEDURE | hotelbookingsystem@localhost | 2022-11-10 14:55:48 | 2022-11-10 14:55:48 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | DeleteRoomType | PROCEDURE | hotelbookingsystem@localhost | 2022-12-09 18:24:03 | 2022-12-09 18:24:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | InquireAvailableRoomType | PROCEDURE | hotelbookingsystem@localhost | 2022-12-01 16:41:23 | 2022-12-01 16:41:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | InsertNewType | PROCEDURE | hotelbookingsystem@localhost | 2022-12-09 06:07:17 | 2022-12-09 06:07:17 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | MonthReport | PROCEDURE | hotelbookingsystem@localhost | 2022-11-11 17:00:45 | 2022-11-11 17:00:45 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | OccupancyMonthReport | PROCEDURE | hotelbookingsystem@localhost | 2022-12-10 21:20:00 | 2022-12-10 21:20:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | OperationMonthReport | PROCEDURE | hotelbookingsystem@localhost | 2022-12-10 21:52:34 | 2022-12-10 21:52:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | RegisterSystemUser | PROCEDURE | hotelbookingsystem@localhost | 2022-12-11 11:05:38 | 2022-12-11 11:05:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | RegisterUser | PROCEDURE | hotelbookingsystem@localhost | 2022-11-26 19:30:47 | 2022-11-26 19:30:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | SaveEditType | PROCEDURE | hotelbookingsystem@localhost | 2022-12-09 16:16:36 | 2022-12-09 16:16:36 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | SaveNewRoom | PROCEDURE | hotelbookingsystem@localhost | 2022-12-09 22:05:31 | 2022-12-09 22:05:31 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | SaveRoomType | PROCEDURE | hotelbookingsystem@localhost | 2022-11-30 10:28:39 | 2022-11-30 10:28:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | SelectCity | PROCEDURE | hotelbookingsystem@localhost | 2022-11-10 20:57:24 | 2022-11-10 20:57:24 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | hotelbookingsystem | updateHotels | PROCEDURE | hotelbookingsystem@localhost | 2022-11-11 09:02:08 | 2022-11-11 09:02:08 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | imacias | AnswerLab5Question | PROCEDURE | imacias@localhost | 2023-03-05 09:57:06 | 2023-03-05 09:57:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | imacias | GetNextLab5Question | PROCEDURE | imacias@localhost | 2023-03-05 09:57:06 | 2023-03-05 09:57:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | imacias | lab5size | PROCEDURE | imacias@localhost | 2023-03-05 19:14:56 | 2023-03-05 19:14:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | imacias | makelab5subset | PROCEDURE | imacias@localhost | 2023-03-05 19:14:56 | 2023-03-05 19:14:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | CatchAmount | PROCEDURE | sdenney@localhost | 2022-05-19 23:31:47 | 2022-05-19 23:31:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | DropCatch | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | DropFisherman | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | FishBody | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | FishermanCatches | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | fishInBody | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | fishInfo | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | fishSwims | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | InsertRole | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | IsAdmin | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | RegisterFisherman | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | specificFish | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | inform_a_fish | TopCaughtFish | PROCEDURE | sdenney@localhost | 2022-05-20 00:12:14 | 2022-05-20 00:12:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jbankston | AnswerLab5Question | PROCEDURE | jbankston@localhost | 2023-03-05 13:27:18 | 2023-03-05 13:27:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jbankston | GetNextLab5Question | PROCEDURE | jbankston@localhost | 2023-03-05 13:27:18 | 2023-03-05 13:27:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jbankston | lab5size | PROCEDURE | jbankston@localhost | 2023-03-05 13:27:18 | 2023-03-05 13:27:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jbankston | makelab5subset | PROCEDURE | jbankston@localhost | 2023-03-05 13:27:18 | 2023-03-05 13:27:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jcox | AnswerLab5Question | PROCEDURE | jcox@localhost | 2023-03-04 16:44:22 | 2023-03-04 16:44:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jcox | GetNextLab5Question | PROCEDURE | jcox@localhost | 2023-03-04 16:44:22 | 2023-03-04 16:44:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jcox | lab5size | PROCEDURE | jcox@localhost | 2023-03-06 19:26:01 | 2023-03-06 19:26:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jcox | makelab5subset | PROCEDURE | jcox@localhost | 2023-03-06 19:26:01 | 2023-03-06 19:26:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jhicks | AnswerLab5Question | PROCEDURE | jhicks@localhost | 2023-02-28 10:14:22 | 2023-02-28 10:14:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jhicks | GetNextLab5Question | PROCEDURE | jhicks@localhost | 2023-02-28 10:14:22 | 2023-02-28 10:14:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jhicks | lab5size | PROCEDURE | jhicks@localhost | 2023-02-28 11:16:27 | 2023-02-28 11:16:27 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jhicks | makelab5subset | PROCEDURE | jhicks@localhost | 2023-02-28 11:16:27 | 2023-02-28 11:16:27 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jkuo | AnswerLab5Question | PROCEDURE | jkuo@localhost | 2023-03-06 23:06:55 | 2023-03-06 23:06:55 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jkuo | CreateCustomer | PROCEDURE | jkuo@localhost | 2022-05-02 21:31:20 | 2022-05-02 21:31:20 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jkuo | GetNextLab5Question | PROCEDURE | jkuo@localhost | 2023-03-06 23:06:55 | 2023-03-06 23:06:55 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jkuo | lab5size | PROCEDURE | jkuo@localhost | 2023-03-07 17:10:13 | 2023-03-07 17:10:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jkuo | makelab5subset | PROCEDURE | jkuo@localhost | 2023-03-07 17:10:13 | 2023-03-07 17:10:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jtagaca | AnswerLab5Question | PROCEDURE | jtagaca@localhost | 2023-02-28 17:12:11 | 2023-02-28 17:12:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jtagaca | GetNextLab5Question | PROCEDURE | jtagaca@localhost | 2023-02-28 17:12:11 | 2023-02-28 17:12:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jtagaca | lab5size | PROCEDURE | jtagaca@localhost | 2023-03-01 20:33:33 | 2023-03-01 20:33:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | jtagaca | makelab5subset | PROCEDURE | jtagaca@localhost | 2023-03-01 20:33:33 | 2023-03-01 20:33:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | learnapp | RegisterUser | PROCEDURE | learnapp@localhost | 2022-12-05 18:23:22 | 2022-12-05 18:23:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | learnapp | UploadVid | PROCEDURE | learnapp@localhost | 2022-12-06 19:41:18 | 2022-12-06 19:41:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lgamboa | AnswerLab5Question | PROCEDURE | lgamboa@localhost | 2023-02-28 10:32:06 | 2023-02-28 10:32:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lgamboa | GetNextLab5Question | PROCEDURE | lgamboa@localhost | 2023-02-28 10:32:06 | 2023-02-28 10:32:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lgamboa | lab5size | PROCEDURE | lgamboa@localhost | 2023-02-28 10:32:06 | 2023-02-28 10:32:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lgamboa | makelab5subset | PROCEDURE | lgamboa@localhost | 2023-02-28 10:32:06 | 2023-02-28 10:32:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | addItem | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | AddOwner | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | deleteItem | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | deleteLocation | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | editLocation | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | newLocation | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | newOwner | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | ownerMostItems | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | showusersitems | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | lost_items | upgrade | PROCEDURE | jflores@localhost | 2022-05-20 01:09:52 | 2022-05-20 01:09:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mbuenonunez | AnswerLab5Question | PROCEDURE | mbuenonunez@localhost | 2023-02-28 12:07:04 | 2023-02-28 12:07:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mbuenonunez | GetNextLab5Question | PROCEDURE | mbuenonunez@localhost | 2023-02-28 12:07:04 | 2023-02-28 12:07:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mbuenonunez | lab5size | PROCEDURE | mbuenonunez@localhost | 2023-02-28 15:35:54 | 2023-02-28 15:35:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mbuenonunez | makelab5subset | PROCEDURE | mbuenonunez@localhost | 2023-02-28 15:35:54 | 2023-02-28 15:35:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mcha | AnswerLab5Question | PROCEDURE | mcha@localhost | 2023-02-28 10:41:47 | 2023-02-28 10:41:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mcha | GetNextLab5Question | PROCEDURE | mcha@localhost | 2023-02-28 10:41:47 | 2023-02-28 10:41:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mcha | lab5size | PROCEDURE | mcha@localhost | 2023-03-02 20:48:44 | 2023-03-02 20:48:44 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mcha | makelab5subset | PROCEDURE | mcha@localhost | 2023-03-02 20:48:44 | 2023-03-02 20:48:44 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mdeguia | AnswerLab5Question | PROCEDURE | mdeguia@localhost | 2023-03-07 08:32:38 | 2023-03-07 08:32:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mdeguia | GetNextLab5Question | PROCEDURE | mdeguia@localhost | 2023-03-07 08:32:38 | 2023-03-07 08:32:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mdeguia | lab5size | PROCEDURE | mdeguia@localhost | 2023-03-07 10:01:53 | 2023-03-07 10:01:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mdeguia | makelab5subset | PROCEDURE | mdeguia@localhost | 2023-03-07 10:01:53 | 2023-03-07 10:01:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mervin | AnswerLab5Question | PROCEDURE | mervin@localhost | 2023-02-28 11:21:40 | 2023-02-28 11:21:40 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mervin | GetNextLab5Question | PROCEDURE | mervin@localhost | 2023-02-28 11:21:40 | 2023-02-28 11:21:40 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mervin | lab5size | PROCEDURE | mervin@localhost | 2023-03-06 20:15:41 | 2023-03-06 20:15:41 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mervin | makelab5subset | PROCEDURE | mervin@localhost | 2023-03-06 20:15:41 | 2023-03-06 20:15:41 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mlara | AnswerLab5Question | PROCEDURE | mlara@localhost | 2023-03-02 11:32:56 | 2023-03-02 11:32:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mlara | GetNextLab5Question | PROCEDURE | mlara@localhost | 2023-03-02 11:32:56 | 2023-03-02 11:32:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mlara | lab5size | PROCEDURE | mlara@localhost | 2023-03-02 13:28:46 | 2023-03-02 13:28:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mlara | makelab5subset | PROCEDURE | mlara@localhost | 2023-03-02 13:28:46 | 2023-03-02 13:28:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | moviedb | ChangePassword | PROCEDURE | thooser@localhost | 2022-11-20 16:29:20 | 2022-11-20 16:29:20 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | moviedb | CreateAccount | PROCEDURE | thooser@localhost | 2022-11-20 16:00:50 | 2022-11-20 16:00:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | moviedb | DeleteAccount | PROCEDURE | thooser@localhost | 2022-11-20 16:56:51 | 2022-11-20 16:56:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | moviedb | RevenueSummary | PROCEDURE | thooser@localhost | 2022-11-20 18:09:01 | 2022-11-20 18:09:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mschmidt | reportAggregates | PROCEDURE | mschmidt@localhost | 2021-11-20 19:58:39 | 2021-11-20 19:58:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mschmidt | TestProc | PROCEDURE | mschmidt@localhost | 2021-11-20 19:51:57 | 2021-11-20 19:51:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | addCalendarEntry | PROCEDURE | myhealthypet@localhost | 2022-04-25 20:18:39 | 2022-04-25 20:18:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | addCondition | PROCEDURE | myhealthypet@localhost | 2022-04-25 22:28:58 | 2022-04-25 22:28:58 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | addDailyHealth | PROCEDURE | myhealthypet@localhost | 2022-04-25 22:32:45 | 2022-04-25 22:32:45 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | addGenHealth | PROCEDURE | myhealthypet@localhost | 2022-04-25 22:16:00 | 2022-04-25 22:16:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | addMed | PROCEDURE | myhealthypet@localhost | 2022-04-25 20:43:11 | 2022-04-25 20:43:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | addPetVacc | PROCEDURE | myhealthypet@localhost | 2022-05-05 14:34:50 | 2022-05-05 14:34:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | addVetFac | PROCEDURE | myhealthypet@localhost | 2022-05-05 15:25:16 | 2022-05-05 15:25:16 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | changePassword | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:27:37 | 2022-04-26 19:27:37 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | createAccount | PROCEDURE | myhealthypet@localhost | 2022-04-13 18:41:15 | 2022-04-13 18:41:15 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | createPetProfile | PROCEDURE | myhealthypet@localhost | 2022-04-26 23:41:51 | 2022-04-26 23:41:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deleteCalendarEvent | PROCEDURE | myhealthypet@localhost | 2022-04-26 20:23:49 | 2022-04-26 20:23:49 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deleteCondition | PROCEDURE | myhealthypet@localhost | 2022-04-26 20:27:24 | 2022-04-26 20:27:24 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deleteMedication | PROCEDURE | myhealthypet@localhost | 2022-04-26 20:25:08 | 2022-04-26 20:25:08 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deletePetProfile | PROCEDURE | myhealthypet@localhost | 2022-05-05 16:16:42 | 2022-05-05 16:16:42 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deletePetVacc | PROCEDURE | myhealthypet@localhost | 2022-04-26 20:32:15 | 2022-04-26 20:32:15 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deleteUserHelper | PROCEDURE | myhealthypet@localhost | 2022-05-05 17:21:36 | 2022-05-05 17:21:36 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deleteUserProfile | PROCEDURE | myhealthypet@localhost | 2022-05-05 17:22:57 | 2022-05-05 17:22:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | deleteVetFacility | PROCEDURE | myhealthypet@localhost | 2022-04-26 20:29:39 | 2022-04-26 20:29:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editCalendarEvent | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:32:18 | 2022-04-26 19:32:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editCondition | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:57:45 | 2022-04-26 19:57:45 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editDailyHealth | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:48:14 | 2022-04-26 19:48:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editGenHealth | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:51:04 | 2022-04-26 19:51:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editMed | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:34:33 | 2022-04-26 19:34:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editPet | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:29:29 | 2022-04-26 19:29:29 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editPetVacc | PROCEDURE | myhealthypet@localhost | 2022-04-26 20:06:23 | 2022-04-26 20:06:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editUserInfo | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:24:57 | 2022-04-26 19:24:57 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | editVet | PROCEDURE | myhealthypet@localhost | 2022-05-05 15:26:45 | 2022-05-05 15:26:45 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getDaysHealth | PROCEDURE | myhealthypet@localhost | 2022-05-07 19:29:55 | 2022-05-07 19:29:55 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getMedications | PROCEDURE | myhealthypet@localhost | 2022-05-07 19:30:03 | 2022-05-07 19:30:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getPetHeader | PROCEDURE | myhealthypet@localhost | 2022-04-26 19:54:32 | 2022-04-26 19:54:32 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getPetPic | PROCEDURE | myhealthypet@localhost | 2022-05-07 19:29:43 | 2022-05-07 19:29:43 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getPetVaccines | PROCEDURE | myhealthypet@localhost | 2022-05-07 19:30:12 | 2022-05-07 19:30:12 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getUserPets | PROCEDURE | myhealthypet@localhost | 2022-05-07 19:30:44 | 2022-05-07 19:30:44 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getUserProfile | PROCEDURE | myhealthypet@localhost | 2022-04-25 23:10:14 | 2022-04-25 23:10:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getVaccList | PROCEDURE | myhealthypet@localhost | 2022-05-07 19:30:37 | 2022-05-07 19:30:37 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | myhealthypet | getVetView | PROCEDURE | myhealthypet@localhost | 2022-05-07 19:30:27 | 2022-05-07 19:30:27 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | mysql | AddGeometryColumn | PROCEDURE | root@localhost | 2022-12-20 11:27:54 | 2022-12-20 11:27:54 | INVOKER | | utf8 | utf8_general_ci | utf8mb4_general_ci | | mysql | DropGeometryColumn | PROCEDURE | root@localhost | 2022-12-20 11:27:54 | 2022-12-20 11:27:54 | INVOKER | | utf8 | utf8_general_ci | utf8mb4_general_ci | | nanocenter | RegisterUser | PROCEDURE | erosales@localhost | 2022-04-27 14:09:10 | 2022-04-27 14:09:10 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | nick | AnswerLab5Question | PROCEDURE | nick@localhost | 2023-02-28 10:15:02 | 2023-02-28 10:15:02 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | nick | EmployeeSubset | PROCEDURE | nick@localhost | 2023-02-28 01:09:31 | 2023-02-28 01:09:31 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | nick | GetNextLab5Question | PROCEDURE | nick@localhost | 2023-02-28 10:15:02 | 2023-02-28 10:15:02 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | nick | lab5size | PROCEDURE | nick@localhost | 2023-02-28 10:22:25 | 2023-02-28 10:22:25 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | nick | lab5subset | PROCEDURE | nick@localhost | 2023-02-28 01:13:23 | 2023-02-28 01:13:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | nick | makelab5subset | PROCEDURE | nick@localhost | 2023-02-28 10:22:25 | 2023-02-28 10:22:25 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | nick | testIt | PROCEDURE | nick@localhost | 2021-12-14 16:19:18 | 2021-12-14 16:19:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | AddTransaction | PROCEDURE | mvargas@localhost | 2022-12-11 00:32:21 | 2022-12-11 00:32:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | AddUserToSession | PROCEDURE | dtorres@localhost | 2022-12-09 07:42:27 | 2022-12-09 07:42:27 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | CreateNewUser | PROCEDURE | sledwell@localhost | 2022-12-04 19:36:25 | 2022-12-04 19:36:25 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | DeleteUser | PROCEDURE | sledwell@localhost | 2022-12-04 21:16:50 | 2022-12-04 21:16:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | EditFName | PROCEDURE | sledwell@localhost | 2022-12-04 21:23:02 | 2022-12-04 21:23:02 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | GetMembers | PROCEDURE | dtorres@localhost | 2022-12-11 13:47:19 | 2022-12-11 13:47:19 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | GetTransactions | PROCEDURE | dtorres@localhost | 2022-12-11 01:03:48 | 2022-12-11 01:03:48 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | RemoveTransaction | PROCEDURE | dtorres@localhost | 2022-12-11 04:24:22 | 2022-12-11 04:24:22 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | UpdatePercentages | PROCEDURE | dtorres@localhost | 2022-12-11 14:30:08 | 2022-12-11 14:30:08 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | paypool | UserSpendRankByDateInterval | PROCEDURE | sledwell@localhost | 2022-12-04 21:42:06 | 2022-12-04 21:42:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | pcruz | AnswerLab5Question | PROCEDURE | pcruz@localhost | 2023-03-06 18:22:06 | 2023-03-06 18:22:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | pcruz | GetNextLab5Question | PROCEDURE | pcruz@localhost | 2023-03-06 18:22:06 | 2023-03-06 18:22:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | pcruz | lab5size | PROCEDURE | pcruz@localhost | 2023-03-06 19:39:34 | 2023-03-06 19:39:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | pcruz | makelab5subset | PROCEDURE | pcruz@localhost | 2023-03-06 19:39:34 | 2023-03-06 19:39:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ppark | AnswerLab5Question | PROCEDURE | ppark@localhost | 2023-02-28 11:03:03 | 2023-02-28 11:03:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ppark | GetNextLab5Question | PROCEDURE | ppark@localhost | 2023-02-28 11:03:03 | 2023-02-28 11:03:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ppark | lab5size | PROCEDURE | ppark@localhost | 2023-03-05 14:28:30 | 2023-03-05 14:28:30 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ppark | makelab5subset | PROCEDURE | ppark@localhost | 2023-03-05 14:28:30 | 2023-03-05 14:28:30 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ramrod | RegisterUser | PROCEDURE | ramrod@localhost | 2022-12-06 14:56:25 | 2022-12-06 14:56:25 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | accountRating | PROCEDURE | rateem@localhost | 2022-04-29 15:10:39 | 2022-04-29 15:10:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | addComment | PROCEDURE | rateem@localhost | 2022-04-29 13:59:28 | 2022-04-29 13:59:28 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | addOccupant | PROCEDURE | rateem@localhost | 2022-04-22 22:58:11 | 2022-04-22 22:58:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | addProperty | PROCEDURE | rateem@localhost | 2022-04-03 21:27:26 | 2022-04-03 21:27:26 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | bedRooms | PROCEDURE | rateem@localhost | 2022-04-04 20:32:58 | 2022-04-04 20:32:58 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | deleteLandlord | PROCEDURE | rateem@localhost | 2022-04-03 21:28:39 | 2022-04-03 21:28:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | deleteProperty | PROCEDURE | rateem@localhost | 2022-04-30 18:53:53 | 2022-04-30 18:53:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | deleteTenant | PROCEDURE | rateem@localhost | 2022-04-30 18:46:18 | 2022-04-30 18:46:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | deleteTenantAcc | PROCEDURE | rateem@localhost | 2022-05-01 03:02:39 | 2022-05-01 03:02:39 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | landlordRegister | PROCEDURE | rateem@localhost | 2022-04-18 14:20:38 | 2022-04-18 14:20:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | propertyRating | PROCEDURE | rateem@localhost | 2022-04-30 19:19:03 | 2022-04-30 19:19:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | tenantRegister | PROCEDURE | rateem@localhost | 2022-04-18 13:45:23 | 2022-04-18 13:45:23 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | updateOccupies | PROCEDURE | rateem@localhost | 2022-04-30 17:44:52 | 2022-04-30 17:44:52 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rateem | updateProperty | PROCEDURE | rateem@localhost | 2022-04-30 18:12:07 | 2022-04-30 18:12:07 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | restaurant | FoodMostUsed | PROCEDURE | adiazperez@localhost | 2022-12-01 13:03:17 | 2022-12-01 13:03:17 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | restaurant | FoodMostUsedOnDate | PROCEDURE | adiazperez@localhost | 2022-12-01 18:00:03 | 2022-12-01 18:00:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | restaurant | NewFood | PROCEDURE | adiazperez@localhost | 2022-12-01 12:14:55 | 2022-12-01 12:14:55 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | restaurant | RemoveWorker | PROCEDURE | adiazperez@localhost | 2022-12-01 12:20:15 | 2022-12-01 12:20:15 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | restaurant | UpdateWorkerWage | PROCEDURE | adiazperez@localhost | 2022-12-01 12:27:28 | 2022-12-01 12:27:28 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rgrewal | AnswerLab5Question | PROCEDURE | rgrewal@localhost | 2023-02-28 10:36:00 | 2023-02-28 10:36:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rgrewal | GetNextLab5Question | PROCEDURE | rgrewal@localhost | 2023-02-28 10:36:00 | 2023-02-28 10:36:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rgrewal | lab5size | PROCEDURE | rgrewal@localhost | 2023-03-06 12:35:11 | 2023-03-06 12:35:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rgrewal | makelab5subset | PROCEDURE | rgrewal@localhost | 2023-03-06 12:35:11 | 2023-03-06 12:35:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rmojica | AnswerLab5Question | PROCEDURE | rmojica@localhost | 2023-03-06 08:44:20 | 2023-03-06 08:44:20 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rmojica | GetNextLab5Question | PROCEDURE | rmojica@localhost | 2023-03-06 08:44:20 | 2023-03-06 08:44:20 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rmojica | lab5size | PROCEDURE | rmojica@localhost | 2023-03-06 18:25:44 | 2023-03-06 18:25:44 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rmojica | makelab5subset | PROCEDURE | rmojica@localhost | 2023-03-06 18:25:44 | 2023-03-06 18:25:44 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rocket_power | IsAdmin | PROCEDURE | aesa@localhost | 2022-05-10 18:39:10 | 2022-05-10 18:39:10 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rocket_power | RegisterUser | PROCEDURE | aesa@localhost | 2022-05-19 18:38:13 | 2022-05-19 18:38:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rocket_power | SubmitSpot | PROCEDURE | aesa@localhost | 2022-05-19 18:38:13 | 2022-05-19 18:38:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rvelasquez | AnswerLab5Question | PROCEDURE | rvelasquez@localhost | 2023-02-28 10:33:04 | 2023-02-28 10:33:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rvelasquez | GetNextLab5Question | PROCEDURE | rvelasquez@localhost | 2023-02-28 10:33:04 | 2023-02-28 10:33:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rvelasquez | lab5size | PROCEDURE | rvelasquez@localhost | 2023-03-05 15:36:38 | 2023-03-05 15:36:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | rvelasquez | makelab5subset | PROCEDURE | rvelasquez@localhost | 2023-03-05 15:36:38 | 2023-03-05 15:36:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sdenney | DropFisherman | PROCEDURE | sdenney@localhost | 2022-04-28 21:55:01 | 2022-04-28 21:55:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sdenney | FishermanCatches | PROCEDURE | sdenney@localhost | 2022-04-28 21:55:01 | 2022-04-28 21:55:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sdenney | FishermanCaught | PROCEDURE | sdenney@localhost | 2022-04-28 10:18:10 | 2022-04-28 10:18:10 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sdenney | RegisterFisherman | PROCEDURE | sdenney@localhost | 2022-04-28 21:55:01 | 2022-04-28 21:55:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sdenney | TopCaughtFish | PROCEDURE | sdenney@localhost | 2022-04-28 21:55:01 | 2022-04-28 21:55:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sercoli | AnswerLab5Question | PROCEDURE | sercoli@localhost | 2023-03-05 19:47:33 | 2023-03-05 19:47:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sercoli | GetNextLab5Question | PROCEDURE | sercoli@localhost | 2023-03-05 19:47:33 | 2023-03-05 19:47:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sercoli | lab5size | PROCEDURE | sercoli@localhost | 2023-03-05 20:23:18 | 2023-03-05 20:23:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sercoli | makelab5subset | PROCEDURE | sercoli@localhost | 2023-03-05 20:23:18 | 2023-03-05 20:23:18 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skaing | AnswerLab5Question | PROCEDURE | skaing@localhost | 2023-02-28 10:35:13 | 2023-02-28 10:35:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skaing | GetNextLab5Question | PROCEDURE | skaing@localhost | 2023-02-28 10:35:13 | 2023-02-28 10:35:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skaing | lab5size | PROCEDURE | skaing@localhost | 2023-03-02 20:36:04 | 2023-03-02 20:36:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skaing | makelab5subset | PROCEDURE | skaing@localhost | 2023-03-02 20:36:04 | 2023-03-02 20:36:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skurtz | AnswerLab5Question | PROCEDURE | skurtz@localhost | 2023-02-28 11:14:00 | 2023-02-28 11:14:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skurtz | GetNextLab5Question | PROCEDURE | skurtz@localhost | 2023-02-28 11:14:00 | 2023-02-28 11:14:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skurtz | lab5size | PROCEDURE | skurtz@localhost | 2023-03-02 12:51:16 | 2023-03-02 12:51:16 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | skurtz | makelab5subset | PROCEDURE | skurtz@localhost | 2023-03-02 12:51:16 | 2023-03-02 12:51:16 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sledwell | AnswerLab5Question | PROCEDURE | sledwell@localhost | 2023-03-06 19:53:50 | 2023-03-06 19:53:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sledwell | GetNextLab5Question | PROCEDURE | sledwell@localhost | 2023-03-06 19:53:50 | 2023-03-06 19:53:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sledwell | lab5size | PROCEDURE | sledwell@localhost | 2023-03-06 20:42:13 | 2023-03-06 20:42:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sledwell | makelab5subset | PROCEDURE | sledwell@localhost | 2023-03-06 20:42:13 | 2023-03-06 20:42:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | AddBuddy | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | AddLog | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | BecomePremium | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | BuddiesWith | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | DeleteBuddy | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | DeleteLog | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | EditIsDone | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | EditLog | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | fetchAllPremBuddies | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | IsPremium | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | LogIn | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | LogSharedWith | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | LogSharedWithBuddy | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | MostRecentUserLog | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | OneUserAllTheirLogs | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | optOutPremium | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | RegisterUser | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | TotalSleepPerSession | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | sleep_tracker | ViewAllBuddyLogs | PROCEDURE | jkuo@localhost | 2022-05-19 18:28:51 | 2022-05-19 18:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | stay_fresh | Item_stats | PROCEDURE | acardenassil@localhost | 2022-05-20 07:42:43 | 2022-05-20 07:42:43 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | stay_fresh | New_item | PROCEDURE | acardenassil@localhost | 2022-05-20 04:08:02 | 2022-05-20 04:08:02 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | subscriptions | CancelSub | PROCEDURE | sjue@localhost | 2022-05-19 14:58:05 | 2022-05-19 14:58:05 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | subscriptions | CountSubs | PROCEDURE | sjue@localhost | 2022-05-19 15:48:56 | 2022-05-19 15:48:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | subscriptions | newSub | PROCEDURE | sjue@localhost | 2022-05-19 14:11:09 | 2022-05-19 14:11:09 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | svargas | AnswerLab5Question | PROCEDURE | svargas@localhost | 2023-03-06 18:56:38 | 2023-03-06 18:56:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | svargas | GetNextLab5Question | PROCEDURE | svargas@localhost | 2023-03-06 18:56:38 | 2023-03-06 18:56:38 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | svargas | lab5size | PROCEDURE | svargas@localhost | 2023-03-06 20:44:05 | 2023-03-06 20:44:05 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | svargas | makelab5subset | PROCEDURE | svargas@localhost | 2023-03-06 20:44:05 | 2023-03-06 20:44:05 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | thooser | AnswerLab5Question | PROCEDURE | thooser@localhost | 2023-03-04 20:15:13 | 2023-03-04 20:15:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | thooser | GetNextLab5Question | PROCEDURE | thooser@localhost | 2023-03-04 20:15:13 | 2023-03-04 20:15:13 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | thooser | lab5size | PROCEDURE | thooser@localhost | 2023-03-04 20:32:46 | 2023-03-04 20:32:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | thooser | makelab5subset | PROCEDURE | thooser@localhost | 2023-03-04 20:32:46 | 2023-03-04 20:32:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | createEmp | PROCEDURE | ichavez@localhost | 2022-12-06 16:22:04 | 2022-12-06 16:22:04 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | DeleteEmployee | PROCEDURE | rpatel@localhost | 2022-11-17 15:25:21 | 2022-11-17 15:25:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | empHist | PROCEDURE | ichavez@localhost | 2022-12-06 17:06:11 | 2022-12-06 17:06:11 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | GetDept | PROCEDURE | ichavez@localhost | 2022-11-17 15:24:32 | 2022-11-17 15:24:32 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | INSERTEmployee | PROCEDURE | rpatel@localhost | 2022-11-17 15:23:14 | 2022-11-17 15:23:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | NewEmp | PROCEDURE | ichavez@localhost | 2022-11-17 15:59:06 | 2022-11-17 15:59:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | noMoreEmp | PROCEDURE | ichavez@localhost | 2022-12-06 17:06:32 | 2022-12-06 17:06:32 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | timesheet | UpdateDep | PROCEDURE | ichavez@localhost | 2022-12-06 17:15:56 | 2022-12-06 17:15:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | addUser | PROCEDURE | cnavarro@localhost | 2022-11-16 14:11:10 | 2022-11-16 14:11:10 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | adminUpdateListingsInfo | PROCEDURE | etagaca@localhost | 2022-12-11 12:47:33 | 2022-12-11 12:47:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | averageUserTransactions | PROCEDURE | etagaca@localhost | 2022-11-17 21:29:56 | 2022-11-17 21:29:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | createListing | PROCEDURE | etagaca@localhost | 2022-12-10 17:28:30 | 2022-12-10 17:28:30 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | deleteListingsInfo | PROCEDURE | etagaca@localhost | 2022-12-09 22:32:37 | 2022-12-09 22:32:37 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | getUserNameById | PROCEDURE | etagaca@localhost | 2022-12-08 18:09:45 | 2022-12-08 18:09:45 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | RegisterUser | PROCEDURE | tradespace@localhost | 2022-12-09 16:46:46 | 2022-12-09 16:46:46 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | updateListingsInfo | PROCEDURE | etagaca@localhost | 2022-12-11 12:12:02 | 2022-12-11 12:12:02 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | tradespace | updateUserId | PROCEDURE | etagaca@localhost | 2022-11-15 18:33:03 | 2022-11-15 18:33:03 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | addBout | PROCEDURE | cokpara@localhost | 2022-12-10 01:15:47 | 2022-12-10 01:15:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | AddFighter | PROCEDURE | cokpara@localhost | 2022-11-19 12:09:30 | 2022-11-19 12:09:30 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | adjrec | PROCEDURE | cokpara@localhost | 2022-12-10 05:41:14 | 2022-12-10 05:41:14 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | bday | PROCEDURE | cokpara@localhost | 2022-11-19 12:27:01 | 2022-11-19 12:27:01 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | dfighter | PROCEDURE | cokpara@localhost | 2022-11-19 12:39:00 | 2022-11-19 12:39:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | fem | PROCEDURE | cokpara@localhost | 2022-11-19 12:00:34 | 2022-11-19 12:00:34 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | findfighter | PROCEDURE | cokpara@localhost | 2022-12-06 17:44:54 | 2022-12-06 17:44:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | FindFighterInWC | PROCEDURE | nick@localhost | 2022-12-08 14:23:51 | 2022-12-08 14:23:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | getbouts | PROCEDURE | cokpara@localhost | 2022-12-08 14:30:24 | 2022-12-08 14:30:24 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | getchamps | PROCEDURE | cokpara@localhost | 2022-12-08 14:18:49 | 2022-12-08 14:18:49 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | getclass | PROCEDURE | cokpara@localhost | 2022-12-08 14:22:37 | 2022-12-08 14:22:37 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | idfighter | PROCEDURE | cokpara@localhost | 2022-12-06 21:18:00 | 2022-12-06 21:18:00 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | loc | PROCEDURE | cokpara@localhost | 2022-11-19 12:18:56 | 2022-11-19 12:18:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | rec | PROCEDURE | cokpara@localhost | 2022-11-19 11:51:12 | 2022-11-19 11:51:12 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | uwl | PROCEDURE | cokpara@localhost | 2022-11-18 16:28:51 | 2022-11-18 16:28:51 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ufcdb | Wclass | PROCEDURE | cokpara@localhost | 2022-11-18 13:22:09 | 2022-11-18 13:22:09 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | useraccountsdemo | EditPost | PROCEDURE | nick@localhost | 2021-11-15 15:58:26 | 2021-11-15 15:58:26 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | useraccountsdemo | GetPosts | PROCEDURE | nick@localhost | 2022-04-21 20:46:53 | 2022-04-21 20:46:53 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | useraccountsdemo | GetRoles | PROCEDURE | nick@localhost | 2021-11-12 14:53:56 | 2021-11-12 14:53:56 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | useraccountsdemo | IsAdmin | PROCEDURE | nick@localhost | 2021-11-12 18:46:08 | 2021-11-12 18:46:08 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | useraccountsdemo | RegisterUser | PROCEDURE | nick@localhost | 2022-04-08 12:38:35 | 2022-04-08 12:38:35 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | useraccountsdemo | WritePost | PROCEDURE | nick@localhost | 2021-11-10 17:13:21 | 2021-11-10 17:13:21 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ybond | AnswerLab5Question | PROCEDURE | ybond@localhost | 2023-03-07 03:47:50 | 2023-03-07 03:47:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ybond | GetNextLab5Question | PROCEDURE | ybond@localhost | 2023-03-07 03:47:50 | 2023-03-07 03:47:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ybond | lab5size | PROCEDURE | ybond@localhost | 2023-03-07 04:44:54 | 2023-03-07 04:44:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | ybond | makelab5subset | PROCEDURE | ybond@localhost | 2023-03-07 04:44:54 | 2023-03-07 04:44:54 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | +---------------------+-----------------------------+-----------+-------------------------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ B460 rows in set (0.014 sec) BB BMariaDB [company]> show procedure status;where db='company'; +---------+--------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +---------+--------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | company | ChangeEmployeeDepartment | PROCEDURE | nick@localhost | 2022-11-07 14:12:50 | 2022-11-07 14:12:50 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | company | GetDepartmentEmployees | PROCEDURE | nick@localhost | 2022-11-28 13:23:33 | 2022-11-28 13:23:33 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | company | GetEmployees | PROCEDURE | nick@localhost | 2022-11-03 02:39:06 | 2022-11-03 02:39:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | +---------+--------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ B3 rows in set (0.013 sec) BB usercompanys23;ny]> show procedure status where db='company'; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BDatabase changed BMariaDB [companys23]> showcprocedure;status where db='companys23'; +------------+--------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+--------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | companys23 | ChangeEmployeeDepartment | PROCEDURE | nick@localhost | 2023-03-22 13:24:45 | 2023-03-22 13:24:45 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | companys23 | GetDepartmentEmployees | PROCEDURE | nick@localhost | 2023-03-22 13:16:47 | 2023-03-22 13:16:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | companys23 | GetEmployees | PROCEDURE | nick@localhost | 2023-03-22 13:16:47 | 2023-03-22 13:16:47 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | companys23 | GetEmployeesByDept | PROCEDURE | nick@localhost | 2023-03-22 13:08:43 | 2023-03-22 13:08:43 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | +------------+--------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ B4 rows in set (0.013 sec) BB BMariaDB [companys23]> show create procedure GetDepartmentEmployees; +------------------------+-------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +------------------------+-------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | GetDepartmentEmployees | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`nick`@`localhost` PROCEDURE `GetDepartmentEmployees`(deptID int) BEGIN SELECT SSN, Fname, Lname, Dnumber FROM Employee WHERE Dnumber = deptID; END | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | +------------------------+-------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> describe EmployeeHistory; +-----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+-------+ | SSN | char(11) | NO | PRI | NULL | | | Fname | varchar(20) | NO | | NULL | | | Minit | char(1) | YES | | NULL | | | Lname | varchar(20) | NO | | NULL | | | Bdate | date | YES | | NULL | | | Address | varchar(100) | YES | | NULL | | | Salary | decimal(14,2) | YES | | NULL | | | Super_SSN | char(11) | YES | MUL | NULL | | | Dnumber | int(11) | YES | MUL | NULL | | +-----------+---------------+------+-----+---------+-------+ B9 rows in set (0.001 sec) BB BMariaDB [companys23]> describe Department; +-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+----------------+ | Dnumber | int(11) | NO | PRI | NULL | auto_increment | | Dname | varchar(20) | YES | UNI | NULL | | | Mgr_SSN | char(11) | YES | MUL | NULL | | | Mgr_start | date | YES | | NULL | | +-----------+-------------+------+-----+---------+----------------+ B4 rows in set (0.001 sec) BB BMariaDB [companys23]> alter table Department add column EmployeeCount int default 0; BQuery OK, 0 rows affected (0.002 sec) BBRecords: 0 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> select * from Department; +---------+----------------------+-------------+------------+---------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | EmployeeCount | +---------+----------------------+-------------+------------+---------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | 0 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | 0 | | 3 | Sales | 626-86-0981 | 2010-12-26 | 0 | | 4 | R&D | 521-40-4757 | 2005-01-05 | 0 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | 0 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | 0 | +---------+----------------------+-------------+------------+---------------+ B6 rows in set (0.000 sec) BB t.Dnumber);ompanys23]> update Department set EmployeeCount = (select count(*) from Employee WHERE Employee.Dnumber = Departmen BQuery OK, 6 rows affected (0.001 sec) BBRows matched: 6 Changed: 6 Warnings: 0 BB t.Dnumber);selects*3frompDepartment;ment set EmployeeCount = (select count(*) from Employee WHERE Employee.Dnumber = Department selectt*bfromeDepartment;d column EmployeeCount int default 0; +---------+----------------------+-------------+------------+---------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | EmployeeCount | +---------+----------------------+-------------+------------+---------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | 21 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | 13 | | 3 | Sales | 626-86-0981 | 2010-12-26 | 19 | | 4 | R&D | 521-40-4757 | 2005-01-05 | 16 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | 12 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | 19 | +---------+----------------------+-------------+------------+---------------+ B6 rows in set (0.000 sec) BB t.Dnumber);selects*efrompDepartment;=D(selectncount(*) from Employee WHERE Employee.Dnumber = Department create table DependentHistory like Dependent; BQuery OK, 0 rows affected (0.004 sec) BB BMariaDB [companys23]> show create table DependentHistory; +------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | DependentHistory | CREATE TABLE `DependentHistory` ( `SSN` char(11) NOT NULL, `Dname` varchar(40) NOT NULL, `Bdate` date DEFAULT NULL, `Relationship` varchar(20) DEFAULT NULL, PRIMARY KEY (`SSN`,`Dname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.001 sec) BB BMariaDB [companys23]> create table WorksOnHistory like WorksOn; BQuery OK, 0 rows affected (0.004 sec) BB BMariaDB [companys23]> show create table WorksOnHistory; +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | WorksOnHistory | CREATE TABLE `WorksOnHistory` ( `SSN` char(11) NOT NULL, `Pnumber` int(11) NOT NULL, `Hours` float DEFAULT NULL, PRIMARY KEY (`SSN`,`Pnumber`), KEY `Pnumber` (`Pnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.001 sec) BB BMariaDB [companys23]> alter table WorksOnHistory drop primary key; BQuery OK,f02rowsaaffectedy(0.008 sec)of stage done BBRecords: 0 Duplicates: 0 Warnings: 0 BB showicreateotablesWorksOnHistory;e WorksOnHistory drop primary key; +----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | WorksOnHistory | CREATE TABLE `WorksOnHistory` ( `SSN` char(11) NOT NULL, `Pnumber` int(11) NOT NULL, `Hours` float DEFAULT NULL, KEY `Pnumber` (`Pnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.001 sec) BB BMariaDB [companys23]> alter tableEEmployeeHistory ADD COLUMN FiredOn DEFAULT NOW(); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT NOW()' at line 1 BBMariaDB [companys23]> alter table EmployeeHistory ADD COLUMN FiredOn DEFAULT CURRENT_TIMESTAMP; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT CURRENT_TIMESTAMP' at line 1 alteritablecEmployeeHistoryeADDaCOLUMNpFiredOnsateTimeDCURRENT_TIMESTAMP;FAULT CURRENT_TIMESTAMP; BQuery OK, 0 rows affected (0.002 sec) BBRecords: 0 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> show create table EmployeeHistory; +-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | EmployeeHistory | CREATE TABLE `EmployeeHistory` ( `SSN` char(11) NOT NULL, `Fname` varchar(20) NOT NULL, `Minit` char(1) DEFAULT NULL, `Lname` varchar(20) NOT NULL, `Bdate` date DEFAULT NULL, `Address` varchar(100) DEFAULT NULL, `Salary` decimal(14,2) DEFAULT NULL, `Super_SSN` char(11) DEFAULT NULL, `Dnumber` int(11) DEFAULT NULL, `FiredOn` datetime DEFAULT current_timestamp(), PRIMARY KEY (`SSN`), KEY `Super_SSN` (`Super_SSN`), KEY `Dnumber` (`Dnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> alter table `EmployeeHistory` drop primary key; BQuery OK,f02rowsaaffectedy(0.010 sec)of stage done BBRecords: 0 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> alter table `EmployeeHistory` addpprimaryykeyy(SSN, FiredOn); BQuery OK, 0 rows affected (0.009 sec) BBRecords: 0 Duplicates: 0 Warnings: 0 BB showicreateotablesEmployeeHistory; `EmployeeHistory` droppprimarykkey;SSN, FiredOn); +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | EmployeeHistory | CREATE TABLE `EmployeeHistory` ( `SSN` char(11) NOT NULL, `Fname` varchar(20) NOT NULL, `Minit` char(1) DEFAULT NULL, `Lname` varchar(20) NOT NULL, `Bdate` date DEFAULT NULL, `Address` varchar(100) DEFAULT NULL, `Salary` decimal(14,2) DEFAULT NULL, `Super_SSN` char(11) DEFAULT NULL, `Dnumber` int(11) DEFAULT NULL, `FiredOn` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`SSN`,`FiredOn`), KEY `Super_SSN` (`Super_SSN`), KEY `Dnumber` (`Dnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 `ENCRYPTION_KEY_ID`=100 | +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> select SSN from me; +-------------+ | SSN | +-------------+ | 123-45-6789 | +-------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> exitte BBye Bnick@artemis:~$ cd 3420/company/s23 nick@artemis:~/3420/company/s23$ ls -l total 124 -rw-r--r-- 1 nick nick 33844 Mar 6 14:04 company.dump.sql -rw-r--r-- 1 nick nick 6474 Mar 6 14:03 companys23.dump.sql -rw-rw-r-- 1 nick nick 1811 Mar 29 13:16 company.sql -rw-r--r-- 1 nick nick 549 Mar 15 13:46 Department.sql -rw-r--r-- 1 nick nick 15218 Mar 15 13:35 Employee.sql -rw-r--r-- 1 nick nick 33988 Mar 6 14:12 somefile.txt -rw-r--r-- 1 nick nick 1232 Mar 22 13:24 sp_changeemployee.sql -rw-r--r-- 1 nick nick 184 Mar 22 13:08 sp_example.sql -rw-r--r-- 1 nick nick 545 Mar 22 13:00 sp_getemployee.sql -rw-r--r-- 1 nick nick 677 Mar 29 13:46 trigger.sql -rw-rw-r-- 1 nick nick 449 Mar 20 13:09 Views.sql nick@artemis:~/3420/company/s23$ mysql companys23 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 45820 Server version: 10.3.36-MariaDB-0+deb10u2 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 [companys23]> source trigger.sql BQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB electcSSNtfrombme;EmployeeHistory;primaryykeyy(SSN,sFiredOn); ERROR 1146 (42S02): Table 'companys23.me' doesn't exist BBMariaDB [companys23]> select SSN from me; ERROR 1146 (42S02): Table 'companys23.me' doesn't exist BBMariaDB [companys23]> select * from Employee where SSN = '123-45-6789'; +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+ B1 row in set (0.001 sec) BB createDtemporaryytable melast * from Employee where SSN = '123-45-6789'; BQuery OK, 1 row affected (0.005 sec) BBRecords: 1 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> delete from Employee where SSN in (select SSN from me); BQuery OK, 1 row affected (0.002 sec) BB BMariaDB [companys23]> select *ofrom EmployeeHistory; +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+---------------------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | FiredOn | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+---------------------+ | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | 2023-03-29 13:47:40 | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+---------------------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> insert into Employee select * from me; BQuery OK, 1 row affected (0.001 sec) BBRecords: 1 Duplicates: 0 Warnings: 0 BB deleteDfromoEmployeeewhereoSSNiino(selecteSSNefrom me);om me; BQuery OK, 1 row affected (0.003 sec) BB selectD*nfrommEmployeeHistory;from me;loyee where SSN in (select SSN from me); +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+---------------------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | FiredOn | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+---------------------+ | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | 2023-03-29 13:47:40 | | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | 2023-03-29 13:48:17 | +-------------+-------+-------+----------+------------+---------+-----------+-------------+---------+---------------------+ B2 rows in set (0.000 sec) BB BMariaDB [companys23]> select SSN from WorksOn order by rand() limitt1; +-------------+ | SSN | +-------------+ | 725-13-9144 | +-------------+ B1 row in set (0.001 sec) BB BMariaDB [companys23]> select count(*) from WorksOn where SSN = '725-13-9144'; +----------+ | count(*) | +----------+ | 2 | +----------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> select * from WorksOnHistory; BEmpty set (0.000 sec) BB BMariaDB [companys23]> delete from Employee whereeSSN = "725-13-9144"; BQuery OK, 1 row affected (0.003 sec) BB selectD* frompWorksOnHistory; from Employee where SSN = "725-13-9144"; +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 725-13-9144 | 2 | 11.41 | | 725-13-9144 | 3 | 2.44 | +-------------+---------+-------+ B2 rows in set (0.000 sec) BB selecto*rfrommEmployeeHistory;finm(select'SSN-from1me); +-------------+-------+-------+----------+------------+--------------------+-----------+-------------+---------+---------------------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | FiredOn | +-------------+-------+-------+----------+------------+--------------------+-----------+-------------+---------+---------------------+ | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | 2023-03-29 13:47:40 | | 123-45-6789 | Nick | J | Toothman | 2000-01-01 | Home | 100000.00 | 622-30-0735 | 4 | 2023-03-29 13:48:17 | | 725-13-9144 | Banky | NULL | Wright | 1907-10-14 | 40598 Center Drive | 23840.00 | 622-30-0735 | 3 | 2023-03-29 13:49:42 | +-------------+-------+-------+----------+------------+--------------------+-----------+-------------+---------+---------------------+ B3 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from Department; +---------+----------------------+-------------+------------+---------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | EmployeeCount | +---------+----------------------+-------------+------------+---------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | 21 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | 13 | | 3 | Sales | 626-86-0981 | 2010-12-26 | 18 | | 4 | R&D | 521-40-4757 | 2005-01-05 | 14 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | 12 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | 19 | +---------+----------------------+-------------+------------+---------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> insert into Employee select * from me; BQuery OK, 1 row affected (0.001 sec) BBRecords: 1 Duplicates: 0 Warnings: 0 BB selectD* frompDepartment;sert into Employee select * from me; +---------+----------------------+-------------+------------+---------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | EmployeeCount | +---------+----------------------+-------------+------------+---------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | 21 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | 13 | | 3 | Sales | 626-86-0981 | 2010-12-26 | 18 | | 4 | R&D | 521-40-4757 | 2005-01-05 | 14 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | 12 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | 19 | +---------+----------------------+-------------+------------+---------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> delete from Employee whereeSSN in (select SSN from me); BQuery OK, 1 row affected (0.004 sec) BB selectD* frompDepartment;lete from Employee where SSN in (select SSN from me); +---------+----------------------+-------------+------------+---------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | EmployeeCount | +---------+----------------------+-------------+------------+---------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | 21 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | 13 | | 3 | Sales | 626-86-0981 | 2010-12-26 | 18 | | 4 | R&D | 521-40-4757 | 2005-01-05 | 13 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | 12 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | 19 | +---------+----------------------+-------------+------------+---------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> source trigger.sql BQuery OK, 0 rows affected (0.000 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected (0.001 sec) BB BMariaDB [companys23]> insert into Department (Dname) values ('Secret Shadow Organization'); ERROR 1406 (22001): Data too long for column 'Dname' at row 1 BBMariaDB [companys23]> insert into Department (Dname) values ('SecretOrg');;;;;;;;;;;;;;;;;; BQuery OK, 1 row affected (0.002 sec) BB BMariaDB [companys23]> select * from Department; +---------+----------------------+-------------+------------+---------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | EmployeeCount | +---------+----------------------+-------------+------------+---------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | 21 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | 13 | | 3 | Sales | 626-86-0981 | 2010-12-26 | 18 | | 4 | R&D | 521-40-4757 | 2005-01-05 | 13 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | 12 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | 19 | | 7 | SecretOrg | 155-65-2686 | NULL | 0 | +---------+----------------------+-------------+------------+---------------+ B7 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from Employee where SSN = '155-65-2686'; +-------------+-------+-------+-------+------------+----------------------+----------+-------------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+-------+-------+-------+------------+----------------------+----------+-------------+---------+ | 155-65-2686 | Sandi | NULL | Berni | 1910-09-19 | 42355 Fremont Avenue | 74728.00 | 327-45-5907 | 2 | +-------------+-------+-------+-------+------------+----------------------+----------+-------------+---------+ B1 row in set (0.000 sec) BB BMariaDB [companys23]> exit BBye Bnick@artemis:~/3420/company/s23$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ exit exit