Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_jea/sql/install.mysql.utf8.sql

Назад
-- -------------------------------------------------------- -- -- Table schema `#__jea_advantages` -- CREATE TABLE IF NOT EXISTS `#__jea_amenities` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL COMMENT 'language where amenity is shown', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_areas` -- CREATE TABLE IF NOT EXISTS `#__jea_areas` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `town_id` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_conditions` -- CREATE TABLE IF NOT EXISTS `#__jea_conditions` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL COMMENT 'language where condition is shown', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_departments` -- CREATE TABLE IF NOT EXISTS `#__jea_departments` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `name` (`value`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_heatingtypes` -- CREATE TABLE IF NOT EXISTS `#__jea_heatingtypes` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL COMMENT 'language where heatingtype is shown', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_hotwatertypes` -- CREATE TABLE IF NOT EXISTS `#__jea_hotwatertypes` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL COMMENT 'language where hotwatertype is shown', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_properties` -- CREATE TABLE IF NOT EXISTS `#__jea_properties` ( `id` int(11) NOT NULL auto_increment, `asset_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table', `ref` varchar(20) NOT NULL default '', `title` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `transaction_type` ENUM('RENTING', 'SELLING') NOT NULL default 'SELLING', `type_id` int(11) NOT NULL default '0', `price` decimal(12,2) NOT NULL default '0.00', `rate_frequency` ENUM( 'MONTHLY', 'WEEKLY', 'DAILY' ) NOT NULL default 'MONTHLY', `address` varchar(255) NOT NULL default '', `town_id` int(11) NOT NULL default '0', `area_id` int(11) NOT NULL default '0', `zip_code` varchar(10) NOT NULL default '', `department_id` int(11) NOT NULL default '0', `condition_id` int(11) NOT NULL default '0', `living_space` int(11) NOT NULL default '0', `land_space` int(11) NOT NULL default '0', `rooms` int(11) NOT NULL default '0', `bedrooms` int(11) NOT NULL default '0', `charges` decimal(12,2) NOT NULL default '0.00', `fees` decimal(12,2) NOT NULL default '0.00', `deposit` decimal(12,2) NOT NULL default '0.00', `hot_water_type` tinyint(1) NOT NULL default '0', `heating_type` tinyint(2) NOT NULL default '0', `bathrooms` tinyint(3) NOT NULL default '0', `toilets` tinyint(3) NOT NULL default '0', `availability` date NOT NULL default '0000-00-00', `floor` int(11) NOT NULL default '0', `floors_number` int(11) NOT NULL default '0', `orientation` ENUM('0', 'N', 'NE', 'NW', 'NS', 'E', 'W', 'S', 'SW', 'SE', 'EW') NOT NULL default '0', `amenities` varchar(255) NOT NULL default '' COMMENT 'amenities list', `description` text NOT NULL, `slogan_id` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `access` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `featured` tinyint(1) NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL default '0', `hits` int(11) NOT NULL default '0', `images` TEXT NOT NULL, `latitude` varchar(20) NOT NULL default '0', `longitude` varchar(20) NOT NULL default '0', `notes` TEXT NOT NULL, `language` char(7) NOT NULL COMMENT 'language where property is shown', `provider` varchar(50) NOT NULL default '' COMMENT 'A gateway provider name', PRIMARY KEY (`id`), KEY `idx_jea_transactiontype` (`transaction_type`), KEY `idx_jea_typeid` (`type_id`), KEY `idx_jea_departmentid` (`department_id`), KEY `idx_jea_townid` (`town_id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_tools` -- CREATE TABLE IF NOT EXISTS `#__jea_tools` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `link` varchar(255) NOT NULL default '', `icon` varchar(255) NOT NULL default '', `params` TEXT NOT NULL, `access` TEXT NOT NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; INSERT INTO `#__jea_tools` (`id` , `title` , `link` , `icon` , `params` , `access`) VALUES ('1', 'com_jea_import', 'index.php?option=com_jea&view=gateways&layout=import', 'download', '', '[''core.manage'', ''com_jea'', ''core.create'', ''com_jea'']'), ('2', 'com_jea_export', 'index.php?option=com_jea&view=gateways&layout=export', 'upload', '', '[''core.manage'', ''com_jea'', ''core.create'', ''com_jea'']'); -- -------------------------------------------------------- -- -- Table schema `#__jea_slogans` -- CREATE TABLE IF NOT EXISTS `#__jea_slogans` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL COMMENT 'language where slogan is shown', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_towns` -- CREATE TABLE IF NOT EXISTS `#__jea_towns` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `department_id` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_types` -- CREATE TABLE IF NOT EXISTS `#__jea_types` ( `id` int(11) NOT NULL auto_increment, `value` varchar(255) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL COMMENT 'language where type is shown', PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table schema `#__jea_gateways` -- CREATE TABLE IF NOT EXISTS `#__jea_gateways` ( `id` int(11) NOT NULL auto_increment, `type` varchar(50) NOT NULL default '', `provider` varchar(50) NOT NULL default '', `title` varchar(255) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `params` TEXT NOT NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0.04 | proxy | phpinfo | Настройка