| Server IP : 180.180.241.3 / Your IP : 216.73.216.127 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/AppServ/www/app/webroot/news/administrator/components/com_phocamaps/ |
Upload File : |
DROP TABLE IF EXISTS `#__phocamaps_map`; CREATE TABLE `#__phocamaps_map` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `width` int(5) NOT NULL default '0', `height` int(5) NOT NULL default '0', `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `zoom` int(3) NOT NULL default '0', `lang` varchar(6) NOT NULL default '', `border` tinyint(1) NOT NULL default '0', `continuouszoom` tinyint(1) NOT NULL default '0', `doubleclickzoom` tinyint(1) NOT NULL default '0', `scrollwheelzoom` tinyint(1) NOT NULL default '0', `zoomcontrol` tinyint(1) NOT NULL default '0', `scalecontrol` tinyint(1) NOT NULL default '0', `typeid` tinyint(1) NOT NULL default '0', `typecontrol` tinyint(1) NOT NULL default '0', `typecontrolposition` tinyint(1) NOT NULL default '0', `collapsibleoverview` tinyint(1) NOT NULL default '0', `dynamiclabel` tinyint(1) NOT NULL default '0', `googlebar` tinyint(1) NOT NULL default '0', `displayroute` tinyint(1) NOT NULL default '0', `kmlfile` varchar(255) NOT NULL default '', `description` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `cat_idx` (`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) CHARACTER SET `utf8`; DROP TABLE IF EXISTS `#__phocamaps_marker`; CREATE TABLE `#__phocamaps_marker` ( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `latitude` varchar(20) NOT NULL default '', `longitude` varchar(20) NOT NULL default '', `gpslatitude` varchar(50) NOT NULL default '', `gpslongitude` varchar(50) NOT NULL default '', `displaygps` tinyint(1) NOT NULL default '0', `icon` tinyint(1) NOT NULL default '0', `description` text NOT NULL, `contentwidth` varchar(8) NOT NULL default '', `contentheight` varchar(8) NOT NULL default '', `markerwindow` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`) ) CHARACTER SET `utf8`; -- UPDATE 1.1.0 -- ALTER TABLE `#__phocamaps_map` ADD `typecontrolposition` tinyint(1) NOT NULL default '0' AFTER `typecontrol`; -- ALTER TABLE `#__phocamaps_map` ADD `typeid` tinyint(1) NOT NULL default '0' AFTER `typecontrol`; -- ALTER TABLE `#__phocamaps_map` ADD `kmlfile` varchar(255) NOT NULL default '' AFTER `displayroute`; -- ALTER TABLE `#__phocamaps_marker` ADD `contentwidth` varchar(8) NOT NULL default '' AFTER `description`; -- ALTER TABLE `#__phocamaps_marker` ADD `contentheight` varchar(8) NOT NULL default '' AFTER `description`; -- ALTER TABLE `#__phocamaps_marker` ADD `markerwindow` tinyint(1) NOT NULL default '0' AFTER `description`;