42 lines
2.5 KiB
SQL
42 lines
2.5 KiB
SQL
INSERT INTO `sentri`.`system_pages` (`page_uuid`,
|
|
`module_uuid`,
|
|
`page_name`,
|
|
`page_icon`,
|
|
`page_description`,
|
|
`page_location`,
|
|
`page_url`,
|
|
`page_color`)
|
|
VALUES ('f8cc7415-68a4-4827-a528-5d0ff3dea9b8',
|
|
'46f0a6d8-21be-4f76-8a95-2e22be8f3878',
|
|
'travelReimburse',
|
|
'fa-solid fa-hand-fist',
|
|
'dashboard_text_travelreimburse',
|
|
'/office/pageTravelReimbursement.php',
|
|
'/travelreimburse',
|
|
'primary');
|
|
|
|
ALTER TABLE `system_settings`
|
|
ADD COLUMN `office_travelreimburse_cents_homework_incl` INT(3) NULL DEFAULT 23 AFTER `mail_smtp_pass`,
|
|
ADD COLUMN `office_travelreimburse_cents_homework_excl` INT(3) NULL DEFAULT 23 AFTER `office_travelreimburse_cents_homework_incl`,
|
|
ADD COLUMN `office_travelreimburse_cents_business_incl` INT(3) NULL DEFAULT 23 AFTER `office_travelreimburse_cents_homework_excl`,
|
|
ADD COLUMN `office_travelreimburse_cents_business_excl` INT(3) NULL DEFAULT 23 AFTER `office_travelreimburse_cents_business_incl`;
|
|
|
|
-- Dumping structure for table sentri.office_travelreimburse
|
|
CREATE TABLE IF NOT EXISTS `office_travelreimburse` (
|
|
`reimburse_uuid` char(36) NOT NULL,
|
|
`user_uuid` char(36) NOT NULL,
|
|
`departure_postcode` varchar(16) NOT NULL,
|
|
`destination_postcode` varchar(16) NOT NULL,
|
|
`travel_distance` int(3) NOT NULL DEFAULT 0,
|
|
`travel_date` date NOT NULL DEFAULT current_timestamp(),
|
|
`travel_description` varchar(255) DEFAULT NULL,
|
|
`office_travelreimburse_company_uuid` varchar(36) DEFAULT NULL,
|
|
`office_travelreimburse_company_name` varchar(32) DEFAULT NULL,
|
|
`homework` int(1) NOT NULL,
|
|
PRIMARY KEY (`reimburse_uuid`),
|
|
KEY `user_uuid` (`user_uuid`),
|
|
KEY `FK_office_travelreimburse_companies` (`office_travelreimburse_company_uuid`) USING BTREE,
|
|
CONSTRAINT `FK_office_travelreimburse_companies` FOREIGN KEY (`office_travelreimburse_company_uuid`) REFERENCES `companies` (`company_uuid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
|
CONSTRAINT `FK_office_travelreimburse_system_users` FOREIGN KEY (`user_uuid`) REFERENCES `system_users` (`user_uuid`) ON DELETE CASCADE ON UPDATE NO ACTION
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
UPDATE `sentri`.`system_pages` SET `page_name`='portal-management', `page_url`='/portal-management' WHERE `page_uuid`='558df250-d6bd-4b81-b23d-99b472b2c72a'; |