Spade
Mini Shell
| Directory:~$ /home/lmsyaran/public_html/administrator/components/com_jea/sql/ |
| [Home] [System Details] [Kill Me] |
-- --------------------------------------------------------
--
-- 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;