SPONSORS MODULE

Rudimentary sponsor pages based on the staff pages:

• http://localhost:2354/admin/dashboard (see index link under "more entities")
• http://localhost:2354/sponsors
• http://localhost:2354/sponsors/1
• http://localhost:2354/admin/sponsors/add
• http://localhost:2354/admin/sponsors/edit/1
• http://localhost:2354/admin/sponsors/delete/1

run this first in MySQL console or SQL tab of PHP myadmin

use cdli_db;
CREATE TABLE sponsors LIKE staff;
ALTER TABLE `sponsors` CHANGE `staff_type_id` `sponsor_type_id` INT(11) UNSIGNED NOT NULL;
ALTER TABLE `sponsors` DROP `author_id`;
ALTER TABLE `sponsors` CHANGE `cdli_title` `sponsor` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `sponsors` ADD `url` VARCHAR(300) NULL AFTER `sponsor`;
CREATE TABLE sponsor_types LIKE staff_types;
ALTER TABLE `sponsor_types` CHANGE `staff_type` `sponsor_type` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
INSERT INTO `sponsor_types` (`id`, `sponsor_type`) VALUES (NULL, 'Academic institution'), (NULL, 'Funding agency');
INSERT INTO `sponsor_types` (`id`, `sponsor_type`) VALUES (NULL, 'Foundation');
INSERT INTO `sponsor_types` (`id`, `sponsor_type`) VALUES (NULL, 'Fund');
INSERT INTO `sponsors` (`id`, `sponsor_type_id`, `sponsor`, `url`, `contribution`, `sequence`) VALUES (NULL, '2', 'National Endowment for the Humanities', 'https://www.neh.gov/', 'The NEH has funded numerous projects created or supported by the Cuneiform Digital Library Initiative. ', '1'), (NULL, '1', 'Max Planck Institute for the History of Science in Berlin', 'https://www.mpiwg-berlin.mpg.de/', 'The MPIWG has seen the inception of the Cuneiform Digital Library Initiative in its midst. It has since then generously supported the initiative.', '1');