| 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.2/ |
Upload File : |
DROP TABLE IF EXISTS `custom_attributes`;
CREATE TABLE `custom_attributes` (
`custom_attribute_id` mediumint(8) unsigned NOT NULL auto_increment,
`display_label` varchar(50) NOT NULL,
`display_type` tinyint(2) unsigned NOT NULL,
`attribute_category` tinyint(2) unsigned NOT NULL,
`validation_regex` varchar(50),
`is_required` tinyint(1) unsigned NOT NULL,
`possible_values` text,
`sort_order` tinyint(2) unsigned,
PRIMARY KEY (`custom_attribute_id`),
INDEX (`attribute_category`),
INDEX (`display_label`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
DROP TABLE IF EXISTS `custom_attribute_values`;
CREATE TABLE `custom_attribute_values` (
`custom_attribute_value_id` mediumint(8) unsigned NOT NULL auto_increment,
`custom_attribute_id` mediumint(8) unsigned NOT NULL,
`attribute_value` text NOT NULL,
`entity_id` mediumint(8) unsigned NOT NULL,
`attribute_category` tinyint(2) unsigned NOT NULL,
PRIMARY KEY (`custom_attribute_value_id`),
INDEX (`custom_attribute_id`),
INDEX `entity_category` (`entity_id`, `attribute_category`),
INDEX `entity_attribute` (`entity_id`, `custom_attribute_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
DROP TABLE IF EXISTS `account_activation`;
CREATE TABLE `account_activation` (
`account_activation_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`activation_code` varchar(30) NOT NULL,
`date_created` datetime NOT NULL,
PRIMARY KEY (`account_activation_id`),
INDEX (`activation_code`),
UNIQUE KEY (`activation_code`),
FOREIGN KEY (`user_id`)
REFERENCES users(`user_id`)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
DROP TABLE IF EXISTS `reservation_files`;
CREATE TABLE IF NOT EXISTS `reservation_files` (
`file_id` int unsigned NOT NULL auto_increment,
`series_id` int unsigned NOT NULL,
`file_name` varchar(250) NOT NULL,
`file_type` varchar(15) NOT NULL,
`file_size` varchar(45) NOT NULL,
`file_extension` varchar(10) NOT NULL,
PRIMARY KEY (`file_id`),
FOREIGN KEY (`series_id`)
REFERENCES reservation_series(`series_id`)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
insert into dbversion values('2.2', now());