File manager - Edit - /home/capoccitel/www/administrator/components/com_rtform/sql/install.mysql.utf8.sql
Back
CREATE TABLE IF NOT EXISTS `#__rtform_submissions` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL , `email` VARCHAR(255) NOT NULL , `appointment_date` DATE NOT NULL , `phone` VARCHAR(255) NOT NULL , `message` TEXT NOT NULL , `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci; INSERT INTO `#__content_types` (`type_title`, `type_alias`, `table`, `content_history_options`) SELECT * FROM ( SELECT 'Submit','com_rtform.submit','{"special":{"dbtable":"#__rtform_submissions","key":"id","type":"Submit","prefix":"RT FormTable"}}', '{"formFile":"administrator\/components\/com_rtform\/models\/forms\/submit.xml", "hideFields":["checked_out","checked_out_time","params","language" ,"message"], "ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time"], "convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"group_id","targetTable":"#__usergroups","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}') AS tmp WHERE NOT EXISTS ( SELECT type_alias FROM `#__content_types` WHERE (`type_alias` = 'com_rtform.submit') ) LIMIT 1;
| ver. 1.6 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings