. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
| 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.4/ |
Upload File : |
DROP TABLE IF EXISTS `user_session`; CREATE TABLE `user_session` ( `user_session_id` mediumint(8) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL, `last_modified` datetime NOT NULL, `session_token` varchar(50) NOT NULL, `user_session_value` text NOT NULL, PRIMARY KEY (`user_session_id`), INDEX `user_session_user_id` (`user_id`), INDEX `user_session_session_token` (`session_token`), FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; ALTER TABLE `time_blocks` ADD COLUMN `day_of_week` SMALLINT(5) unsigned; DROP TABLE IF EXISTS `reminders`; CREATE TABLE `reminders` ( `reminder_id` int(11) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL, `address` text NOT NULL, `message` text NOT NULL, `sendtime` datetime NOT NULL, `refnumber` text NOT NULL, PRIMARY KEY (`reminder_id`), INDEX `reminders_user_id` (`user_id`), FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; DROP TABLE IF EXISTS `reservation_reminders`; CREATE TABLE `reservation_reminders` ( `reminder_id` int(11) unsigned NOT NULL auto_increment, `series_id` int unsigned NOT NULL, `minutes_prior` int unsigned NOT NULL, `reminder_type` tinyint(2) unsigned NOT NULL, PRIMARY KEY (`reminder_id`), FOREIGN KEY (`series_id`) REFERENCES reservation_series(`series_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; ALTER TABLE `users` ADD COLUMN `default_schedule_id` smallint(5) unsigned;