File manager - Edit - /home/verseaumee/ptitsanes/plugins/solidres/experience/sql/mysql/updates/1.4.0.sql
Back
ALTER TABLE `#__sr_experiences` ADD COLUMN `created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'; ALTER TABLE `#__sr_experiences` ADD COLUMN `created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `#__sr_experiences` ADD COLUMN `modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'; ALTER TABLE `#__sr_experiences` ADD COLUMN `modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `#__sr_experiences` ADD COLUMN `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `#__sr_experiences` ADD COLUMN `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'; INSERT INTO `#__content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`, `router`, `content_history_options`) VALUES (0, 'Solidres Experience', 'com_solidres.experience', '{"special":{"dbtable":"#__sr_experiences","key":"id","type":"Experience","prefix":"SolidresTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"state","core_alias":"alias","core_created_time":"created_date","core_modified_time":"modified_date","core_body":"long_description", "core_hits":"null","core_publish_up":"null","core_publish_down":"null","core_access":"null", "core_params":"params", "core_featured":"null", "core_metadata":"null", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"ordering", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}, "special":{}}', 'SRExperienceHelper::getItemRoute', ''); ALTER TABLE `#__sr_experiences` ADD COLUMN `meta_title` VARCHAR(255) NOT NULL DEFAULT '' AFTER `checked_out_time`; ALTER TABLE `#__sr_experiences` ADD COLUMN `meta_key` VARCHAR(255) NOT NULL DEFAULT '' AFTER `meta_title`; ALTER TABLE `#__sr_experiences` ADD COLUMN `meta_desc` VARCHAR(255) NOT NULL DEFAULT '' AFTER `meta_key`; ALTER TABLE `#__sr_experiences` ADD COLUMN `tab_content` LONGTEXT AFTER `meta_desc`; ALTER TABLE `#__sr_experiences` ADD COLUMN `hits` INT(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `tab_content`; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `supplement_amount` DECIMAL(12,2) NOT NULL DEFAULT 0.00 AFTER `time_slot_to`; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `origin_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `supplement_amount`, ADD INDEX `fk_exp_res_origins1_idx` (`origin_id` ASC), ADD CONSTRAINT `fk_exp_res_origins1` FOREIGN KEY (`origin_id`) REFERENCES `#__sr_origins`(`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `time_slot_w_day` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `time_slot_to`; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_ua` VARCHAR(255) NOT NULL DEFAULT '' AFTER `origin_id`; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_ismobile` TINYINT(1) UNSIGNED NULL DEFAULT NULL AFTER `customer_ua`; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_ip` VARCHAR(50) NOT NULL DEFAULT '' AFTER `customer_ismobile`; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_coordinates` TEXT AFTER `customer_ip`; ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_language` VARCHAR(7) NULL DEFAULT NULL AFTER `customer_coordinates`; ALTER TABLE `#__sr_experience_timeslots` ADD COLUMN `w_day` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `to`; ALTER TABLE `#__sr_experience_categories` ADD COLUMN `image` VARCHAR(500) NOT NULL DEFAULT '' AFTER `state`; ALTER TABLE `#__sr_experience_categories` ADD COLUMN `description` VARCHAR(1000) NOT NULL DEFAULT '' AFTER `image`;
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings