| Server IP : 94.23.64.18 / Your IP :
216.73.216.185 [
Web Server : Apache System : Linux webm005.cluster107.gra.hosting.ovh.net 5.15.167-ovh-vps-grsec-zfs-classid #1 SMP Tue Sep 17 08:14:20 UTC 2024 x86_64 User : villadal ( 6036) PHP Version : 7.4.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/villadal/www/old/booked/database_schema/upgrades/2.5/ |
Upload File : |
ALTER TABLE `custom_attributes` ADD COLUMN `entity_id` mediumint(8) unsigned;
ALTER TABLE `resources` ADD COLUMN `resource_type_id` mediumint(8) unsigned;
DROP TABLE IF EXISTS `resource_group_assignment`;
DROP TABLE IF EXISTS `resource_groups`;
CREATE TABLE `resource_groups` (
`resource_group_id` mediumint(8) unsigned NOT NULL auto_increment,
`resource_group_name` VARCHAR(75),
`parent_id` mediumint(8) unsigned,
PRIMARY KEY (`resource_group_id`),
INDEX `resource_groups_parent_id` (`parent_id`),
FOREIGN KEY (`parent_id`)
REFERENCES resource_groups(`resource_group_id`)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
DROP TABLE IF EXISTS `resource_types`;
CREATE TABLE `resource_types` (
`resource_type_id` mediumint(8) unsigned NOT NULL auto_increment,
`resource_type_name` VARCHAR(75),
`resource_type_description` TEXT,
PRIMARY KEY (`resource_type_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
ALTER TABLE `resources` ADD FOREIGN KEY (`resource_type_id`) REFERENCES resource_types(`resource_type_id`) ON DELETE SET NULL;
DROP TABLE IF EXISTS `resource_group_assignment`;
CREATE TABLE `resource_group_assignment` (
`resource_group_id` mediumint(8) unsigned NOT NULL,
`resource_id` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`resource_group_id`, `resource_id`),
INDEX `resource_group_assignment_resource_id` (`resource_id`),
INDEX `resource_group_assignment_resource_group_id` (`resource_group_id`),
FOREIGN KEY (`resource_group_id`)
REFERENCES resource_groups(`resource_group_id`)
ON DELETE CASCADE,
FOREIGN KEY (`resource_id`)
REFERENCES resources(`resource_id`)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
DROP TABLE IF EXISTS `blackout_series_resources`;
CREATE TABLE `blackout_series_resources` (
`blackout_series_id` int unsigned NOT NULL,
`resource_id` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`blackout_series_id`, `resource_id`),
FOREIGN KEY (`blackout_series_id`)
REFERENCES blackout_series(`blackout_series_id`)
ON DELETE CASCADE,
FOREIGN KEY (`resource_id`)
REFERENCES resources(`resource_id`)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
DELETE blackout_series
FROM blackout_series
LEFT JOIN resources ON blackout_series.resource_id = resources.resource_id
WHERE resources.resource_id IS NULL;
INSERT INTO blackout_series_resources SELECT blackout_series_id, resource_id FROM blackout_series;
ALTER TABLE `blackout_series` DROP COLUMN `resource_id`;
ALTER TABLE `blackout_series` ADD COLUMN `repeat_type` varchar(10) default NULL;
ALTER TABLE `blackout_series` ADD COLUMN `repeat_options` varchar(255) default NULL;
DROP TABLE IF EXISTS `user_preferences`;
CREATE TABLE `user_preferences` (
`user_preferences_id` int unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`name` varchar(100) NOT NULL,
`value` varchar(100),
PRIMARY KEY (`user_preferences_id`),
INDEX (`user_id`),
FOREIGN KEY (`user_id`)
REFERENCES users(`user_id`)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
ALTER TABLE `accessories` MODIFY COLUMN accessory_quantity smallint(5) unsigned;
ALTER TABLE `reservation_accessories` MODIFY COLUMN quantity smallint(5) unsigned;
DROP TABLE IF EXISTS `resource_status_reasons`;
CREATE TABLE `resource_status_reasons` (
`resource_status_reason_id` smallint(5) unsigned NOT NULL auto_increment,
`status_id` tinyint unsigned NOT NULL,
`description` varchar(100),
PRIMARY KEY (`resource_status_reason_id`),
INDEX (`status_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
ALTER TABLE `resources` ADD COLUMN `status_id` tinyint unsigned NOT NULL DEFAULT 1;
ALTER TABLE `resources` ADD COLUMN `resource_status_reason_id` smallint(5) unsigned;
ALTER TABLE `resources` ADD FOREIGN KEY (`resource_status_reason_id`) REFERENCES resource_status_reasons(`resource_status_reason_id`) ON DELETE SET NULL;
UPDATE resources SET status_id = isactive;
ALTER TABLE `resources` DROP COLUMN `isactive`;
ALTER TABLE `resources` ADD COLUMN `buffer_time` int unsigned;