File manager

File manager - Edit - /home/jardides/www/Jardi-design/sitetest/administrator/components/com_hotspots/sql/xml/mysql.xml

Back
<?xml version="1.0" encoding="UTF-8"?> <schema> <!-- Metadata --> <meta> <!-- Supported driver types --> <drivers> <driver>mysql</driver> <driver>mysqli</driver> </drivers> </meta> <!-- SQL commands to run on installation and update --> <sql> <action table="#__hotspots_marker" canfail="0"> <condition type="missing" value="" /> <query><![CDATA[ CREATE TABLE `#__hotspots_marker` ( `id` int(11) NOT NULL AUTO_INCREMENT, `asset_id` int(11) NOT NULL COMMENT 'FK to #__assets', `catid` int(11) NOT NULL, `name` varchar(255) NOT NULL, `street` varchar(255) NOT NULL, `plz` varchar(10) NOT NULL, `town` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `gmlat` float(10,6) NOT NULL, `gmlng` float(10,6) NOT NULL, `description` mediumtext NOT NULL, `description_small` mediumtext NOT NULL, `picture` varchar(255) NOT NULL, `picture_thumb` varchar(255) NOT NULL, `created_by_alias` varchar(255) NOT NULL, `created_by_ip` int(11) unsigned NOT NULL, `created_by` int(11) NOT NULL, `created` datetime NOT NULL, `vote` float NOT NULL DEFAULT '0', `votenum` int(11) NOT NULL, `state` tinyint(1) unsigned NOT NULL DEFAULT '0', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL, `customfields` text NOT NULL, `params` text NOT NULL, `language` char(7) NOT NULL, `access` int(10) unsigned NOT NULL DEFAULT '1', `import_table` varchar(255) NOT NULL COMMENT 'If we import data from 3rd party components we store the table_id here', `import_id` int(11) NOT NULL COMMENT 'Original id of the stored object', PRIMARY KEY (`id`), KEY `gmlat` (`gmlat`), KEY `gmlng` (`gmlng`), KEY `catid` (`catid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; ]]></query> </action> <action table="#__hotspots_kmls" canfail="0"> <condition type="missing" value="" /> <query><![CDATA[ CREATE TABLE `#__hotspots_kmls` ( `hotspots_kml_id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `catid` int(11) NOT NULL COMMENT 'FK to #__categories', `description` text NOT NULL, `original_filename` varchar(1024) NOT NULL, `mangled_filename` varchar(1024) NOT NULL, `mime_type` varchar(255) NOT NULL DEFAULT 'application/octet-stream', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` bigint(20) NOT NULL DEFAULT '0', `state` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`hotspots_kml_id`) ); ]]></query> </action> <action table="#__hotspots_customfields" canfail="0"> <condition type="missing" operator="not" /> <query><![CDATA[ INSERT INTO `#__compojoom_customfields`(`title`, `slug`, `component`, `show` , `type` , `options`, `default` , `allow_empty`, `params`, `enabled`, `filter`, `ordering`, `created_by`, `created_on`, `modified_by`, `modified_on`) SELECT `title`, `slug`, "com_hotspots.hotspot" AS `component`, `show` , `type` , `options`, `default`, `allow_empty`, `params`, `enabled`, "0" AS `filter`, `ordering`, `created_by`, `created_on`, `modified_by`, `modified_on` FROM `#__hotspots_customfields`; ]]></query> <query><![CDATA[ DROP TABLE IF EXISTS `#__hotspots_customfields`; ]]></query> </action> <action table="#__hotspots_customfields_cats" canfail="0"> <condition type="missing" operator="not" /> <query><![CDATA[ DROP TABLE IF EXISTS `#__hotspots_customfields_cats`; ]]></query> </action> <action table="#__hotspots_mappings" canfail="0"> <condition type="missing" value="" /> <query><![CDATA[ CREATE TABLE `#__hotspots_mappings` ( `marker_id` int(11) NOT NULL, `foreign_id` int(11) NOT NULL, `component` varchar(255) DEFAULT '', PRIMARY KEY (`marker_id`,`foreign_id`) ) DEFAULT CHARSET=utf8; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="asset_id" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `asset_id` int(11) NOT NULL COMMENT 'FK to #__assets'; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="publish_up" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="publish_down" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="modified" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="modified_by" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `modified_by` int(11) NOT NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="params" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `params` text NOT NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="language" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `language` char(7) NOT NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="access" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `access` int(10) unsigned NOT NULL DEFAULT '0'; ]]></query> <query><![CDATA[ UPDATE `#__hotspots_marker` SET `access` = 1 WHERE `access` = 0; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="missing" value="published" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `published` `state` tinyint(1) unsigned NOT NULL DEFAULT '0'; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="import_table" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `import_table` varchar(255) NOT NULL COMMENT 'If we import data from 3rd party components we store the table_id here'; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="import_id" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD import_id` int(11) NOT NULL COMMENT 'Original id of the stored object'; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="missing" value="picture" operator="not"/> <query canfail="0"><![CDATA[ INSERT INTO #__compojoom_multimedia (item_id, type_alias, mangled_filename, origin, created_by, created_on) SELECT id, "com_hotspots.hotspot", picture, "com_hotspots.migrate", created_by, created FROM #__hotspots_marker WHERE picture <> ""; ]]></query> <query canfail="0"><![CDATA[ ALTER TABLE #__hotspots_marker DROP COLUMN picture; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="missing" value="picture_thumb" operator="not"/> <query><![CDATA[ ALTER TABLE #__hotspots_marker DROP COLUMN picture_thumb; ]]></query> </action> <action table="#__hotspots_kmls" canfail="1"> <condition type="missing" value="title" /> <query><![CDATA[ ALTER TABLE `#__hotspots_kmls` ADD `title` varchar(255) NOT NULL; ]]></query> </action> <action table="#__hotspots_kmls" canfail="1"> <condition type="missing" value="description" /> <query><![CDATA[ ALTER TABLE `#__hotspots_kmls` ADD `description` text NOT NULL; ]]></query> </action> <action table="#__hotspots_kmls" canfail="0"> <condition type="missing" value="created_on" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_kmls` CHANGE `created_on` `created` datetime NOT NULL; ]]></query> </action> <action table="#__hotspots_kmls" canfail="0"> <condition type="missing" value="status" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_kmls` CHANGE `status` `state` tinyint(4) NOT NULL DEFAULT '1'; ]]></query> </action> <action table="#__hotspots_version"> <condition type="missing" operator="not"/> <query><![CDATA[ DROP TABLE IF EXISTS `#__hotspots_version`; ]]></query> </action> <action table="#__hotspots_settings"> <condition type="missing" operator="not"/> <query><![CDATA[ DROP TABLE IF EXISTS `#__hotspots_settings`; ]]></query> </action> </sql> </schema>

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.02 | proxy | phpinfo | Settings