File manager - Edit - /home/opticamezl/www/newok/administrator/components/com_xmap/install/install.utf8.sql
Back
CREATE TABLE IF NOT EXISTS `#__xmap_sitemap` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `alias` varchar(255) DEFAULT NULL, `introtext` text DEFAULT NULL, `metadesc` text DEFAULT NULL, `metakey` text DEFAULT NULL, `attribs` text DEFAULT NULL, `selections` text DEFAULT NULL, `excluded_items` text DEFAULT NULL, `is_default` int(1) DEFAULT 0, `state` int(2) DEFAULT NULL, `access` int DEFAULT NULL, `created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `count_xml` int(11) DEFAULT NULL, `count_html` int(11) DEFAULT NULL, `views_xml` int(11) DEFAULT NULL, `views_html` int(11) DEFAULT NULL, `lastvisit_xml` int(11) DEFAULT NULL, `lastvisit_html` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__xmap_items` ( `uid` varchar(100) NOT NULL, `itemid` int(11) NOT NULL, `view` varchar(10) NOT NULL, `sitemap_id` int(11) NOT NULL, `properties` varchar(300) DEFAULT NULL, PRIMARY KEY (`uid`,`itemid`,`view`,`sitemap_id`), KEY `uid` (`uid`,`itemid`), KEY `view` (`view`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Generation time: 0.05 |
proxy
|
phpinfo
|
Settings