File manager

File manager - Edit - /home/jardides/www/Jardi-design/old/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> <driver>pdomysql</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, `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `street` varchar(255) NOT NULL, `plz` varchar(10) NOT NULL, `town` varchar(255) NOT NULL, `administrative_area_level_1` 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` int(11) NOT NULL, `created` datetime NULL, `state` tinyint(1) unsigned NOT NULL DEFAULT '0', `publish_up` datetime NULL, `publish_down` datetime NULL, `modified` datetime NULL, `modified_by` int(11) NOT NULL, `customfields` text, `params` text NOT NULL, `language` char(7) NOT NULL DEFAULT '', `access` int(10) unsigned NOT NULL DEFAULT '1', `import_table` varchar(255) COMMENT 'If we import data from 3rd party components we store the table_id here', `import_id` int(11) 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 NULL, `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 NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="publish_down"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `publish_down` datetime NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="modified"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `modified` datetime NULL; ]]></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) COMMENT 'Original id of the stored object'; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="autoruserid" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `autoruserid` `created_by` int(11) NOT NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="autor" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `autor` `created_by_alias` varchar(255) NOT NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="autorip" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `autorip` `created_by_ip` int(11) unsigned NOT NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="created_by_ip" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` DROP `created_by_ip`; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="vote" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` DROP `vote`; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="votenum" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` DROP `votenum`; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="postdate" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `postdate` `created` datetime NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="customfields"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `customfields` text; ]]></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="1"> <condition type="missing" value="name" operator="not"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `name` `title` varchar(255) NOT NULL; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="administrative_area_level_1" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `administrative_area_level_1` varchar(255) NOT NULL AFTER `town`; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="missing" value="alias" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` ADD `alias` varchar(255) NOT NULL; ]]></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 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> <action table="#__hotspots_marker" canfail="1"> <condition type="equals" operator="not" value="0"><![CDATA[ SELECT COUNT() FROM `#__hotspots_marker` WHERE `language` = ""; ]]></condition> <query><![CDATA[ UPDATE `#__hotspots_marker` SET `language` = "*" WHERE `language` = ""; ]]></query> </action> <action table="#__hotspots_marker" canfail="1"> <condition type="true" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `import_id` `import_id` INT(11) COMMENT 'Original id of the stored object'; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="type" coltype="datetime" value="created" operator="not" default="NULL"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `created` `created` datetime NULL; ]]></query> <query><![CDATA[ UPDATE `#__hotspots_marker` SET `created` = NULL WHERE `created` = '0000-00-00 00:00:00'; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="type" coltype="datetime" value="publish_up" operator="not" default="NULL"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `publish_up` `publish_up` datetime NULL; ]]></query> <query><![CDATA[ UPDATE `#__hotspots_marker` SET `publish_up` = NULL WHERE `publish_up` = '0000-00-00 00:00:00'; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="type" coltype="datetime" value="publish_down" operator="not" default="NULL"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `publish_down` `publish_down` datetime NULL; ]]></query> <query><![CDATA[ UPDATE `#__hotspots_marker` SET `publish_down` = NULL WHERE `publish_down` = '0000-00-00 00:00:00'; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="type" coltype="datetime" value="publish_down" operator="not" default="NULL"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `modified` `modified` datetime NULL; ]]></query> <query><![CDATA[ UPDATE `#__hotspots_marker` SET `modified` = NULL WHERE `modified` = '0000-00-00 00:00:00'; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="type" coltype="varchar(255)" value="import_table" operator="not" default="NULL" null="yes" /> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `import_table` `import_table` varchar(255) COMMENT 'If we import data from 3rd party components we store the table_id here'; ]]></query> </action> <action table="#__hotspots_marker" canfail="0"> <condition type="type" coltype="text" value="customfields" operator="not" default="NULL" null="yes"/> <query><![CDATA[ ALTER TABLE `#__hotspots_marker` CHANGE `customfields` `customfields` text; ]]></query> </action> </sql> </schema>

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