Файловый менеджер - Редактировать - /home/wuectly/www/03cbe/install.tar
Назад
mysql/icagenda.install.sql 0000604 00000015706 15245617330 0011645 0 ustar 00 -- -- 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.sql 0000604 00000002164 15245627620 0007630 0 ustar 00 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 uninstall.utf8.sql 0000604 00000000071 15245627620 0010166 0 ustar 00 drop table `#__xmap_items`; drop table `#__xmap_sitemap`; uninstall.postgresql.sql 0000604 00000000071 15245627620 0011503 0 ustar 00 drop table "#__xmap_items"; drop table "#__xmap_sitemap"; install.postgresql.sql 0000604 00000002253 15245627620 0011144 0 ustar 00 CREATE 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.html 0000604 00000000036 15245627620 0006545 0 ustar 00 <!DOCTYPE html><title></title>