mysql/icagenda.install.sql000060400000015706152456173300011645 0ustar00-- -- iCagenda: Install Database `icagenda` -- -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda` -- CREATE TABLE IF NOT EXISTS `#__icagenda` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `version` varchar(255) DEFAULT NULL, `releasedate` varchar(255) DEFAULT NULL, `params` text NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8; -- -- Dumping data for table `#__icagenda` -- INSERT IGNORE INTO `#__icagenda` (`id`, `version`, `releasedate`, `params`) VALUES (3,'3.5.12','2015-10-12',''); -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda_category` -- CREATE TABLE IF NOT EXISTS `#__icagenda_category` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ordering` int(11) NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `checked_out` int(11) NOT NULL, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `color` varchar(255) NOT NULL, `desc` text(65535) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda_events` -- CREATE TABLE IF NOT EXISTS `#__icagenda_events` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `asset_id` int(10) NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `approval` int(11) NOT NULL DEFAULT '0', `site_itemid` int(10) NOT NULL DEFAULT '0', `checked_out` int(11) NOT NULL, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `access` int(10) unsigned NOT NULL DEFAULT '0', `language` CHAR(7) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) unsigned NOT NULL DEFAULT '0', `created_by_alias` varchar(255) NOT NULL, `created_by_email` varchar(100) NOT NULL, `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(10) unsigned NOT NULL DEFAULT '0', `username` varchar(255) NOT NULL, `catid` int(11) NOT NULL, `image` varchar(255) NOT NULL, `file` varchar(255) NOT NULL, `displaytime` int(10) NOT NULL DEFAULT '1', `weekdays` varchar(255) NOT NULL, `daystime` varchar(255) NOT NULL, `startdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `enddate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `period` text(65535) NOT NULL, `dates` text(65535) NOT NULL, `next` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `time` varchar(255) NOT NULL, `place` varchar(255) NOT NULL, `website` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `coordinate` varchar(255) NOT NULL, `lat` float( 20, 16 ) NOT NULL, `lng` FLOAT( 20, 16 ) NOT NULL, `shortdesc` text NOT NULL, `desc` text(65535) NOT NULL , `metadesc` text NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda_registration` -- CREATE TABLE IF NOT EXISTS `#__icagenda_registration` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `asset_id` int(10) NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `checked_out` int(11) NOT NULL, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `userid` int(11) NOT NULL, `itemid` int(11) NOT NULL, `eventid` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `date` text(65535) NOT NULL, `period` tinyint(1) NOT NULL DEFAULT '0', `people` int(2) NOT NULL, `notes` text(65535) NOT NULL , `params` text NOT NULL , `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) unsigned NOT NULL DEFAULT '0', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda_customfields` -- CREATE TABLE IF NOT EXISTS `#__icagenda_customfields` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ordering` int(11) NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `checked_out` int(11) NOT NULL, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `description` mediumtext NOT NULL, `parent_form` int(11) NOT NULL DEFAULT '0', `type` varchar(255) NOT NULL, `options` mediumtext, `default` varchar(255) NOT NULL, `required` tinyint(3) NOT NULL DEFAULT '0', `language` varchar(10) NOT NULL DEFAULT '*', `params` mediumtext, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) unsigned NOT NULL DEFAULT '0', `created_by_alias` varchar(255) NOT NULL DEFAULT '', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda_customfields_data` -- CREATE TABLE IF NOT EXISTS `#__icagenda_customfields_data` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `state` tinyint(1) NOT NULL DEFAULT '1', `slug` varchar(255) NOT NULL, `parent_form` int(11) NOT NULL DEFAULT '0', `parent_id` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL, `language` varchar(10) NOT NULL DEFAULT '*', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda_feature` -- CREATE TABLE IF NOT EXISTS `#__icagenda_feature` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ordering` int(11) NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `checked_out` int(11) NOT NULL, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `desc` mediumtext NOT NULL, `icon` varchar(255) NOT NULL, `icon_alt` varchar(255) NOT NULL, `show_filter` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `#__icagenda_feature_xref` -- CREATE TABLE IF NOT EXISTS `#__icagenda_feature_xref` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `event_id` int(11) NOT NULL, `feature_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci; install.utf8.sql000060400000002164152456276200007630 0ustar00CREATE 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=utf8uninstall.utf8.sql000060400000000071152456276200010166 0ustar00drop table `#__xmap_items`; drop table `#__xmap_sitemap`;uninstall.postgresql.sql000060400000000071152456276200011503 0ustar00drop table "#__xmap_items"; drop table "#__xmap_sitemap";install.postgresql.sql000060400000002253152456276200011144 0ustar00CREATE TABLE "#__xmap_sitemap" ( "id" serial NOT NULL, "title" character varying(255) DEFAULT NULL, "alias" character varying(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" integer DEFAULT 0, "state" integer DEFAULT NULL, "access" integer DEFAULT NULL, "created" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, "count_xml" integer DEFAULT NULL, "count_html" integer DEFAULT NULL, "views_xml" integer DEFAULT NULL, "views_html" integer DEFAULT NULL, "lastvisit_xml" integer DEFAULT NULL, "lastvisit_html" integer DEFAULT NULL, PRIMARY KEY ("id") ); CREATE TABLE "#__xmap_items" ( "uid" character varying(100) NOT NULL, "itemid" integer NOT NULL, "view" character varying(10) NOT NULL, "sitemap_id" integer NOT NULL, "properties" varchar(300) DEFAULT NULL, PRIMARY KEY ("uid","itemid","view","sitemap_id") ); CREATE INDEX "#__xmap_items_idx_uid" on "#__xmap_items" ("uid", "itemid"); CREATE INDEX "#__xmap_items_idx_view" on "#__xmap_items" ("view"); index.html000060400000000036152456276200006545 0ustar00