Mister estate ve Ea improved bileşenleri var ben mister estatedeki verileri ea improvede sokmak istiyorum... fakat sanırım biraz sql bilgisi gerektiriyor çözemedim bunu
ea improved yapısı:
CREATE TABLE IF NOT EXISTS `jos_estateagent` (
`id` int(10) NOT NULL auto_increment,
`obj_id` varchar(25) NOT NULL default '',
`cat` int(10) NOT NULL default '0',
`type` tinyint(2) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`location` text NOT NULL,
`condition` text NOT NULL,
`other` text NOT NULL,
`rooms` smallint(4) NOT NULL default '0',
`bedrooms` smallint(4) NOT NULL default '0',
`wc` smallint(4) NOT NULL default '0',
`space` decimal(10,2) NOT NULL default '0.00',
`homes` smallint(5) NOT NULL default '0',
`homes_size` decimal(10,2) NOT NULL default '0.00',
`pp_size` decimal(10,2) NOT NULL default '0.00',
`trade_units` smallint(5) NOT NULL default '0',
`trade_size` decimal(10,2) NOT NULL default '0.00',
`position` varchar(50) NOT NULL default '',
`lift` tinyint(1) NOT NULL default '0',
`handicap` tinyint(1) NOT NULL default '0',
`yobuilt` varchar(10) NOT NULL default '',
`toheat` tinytext NOT NULL,
`toheat_ufloor` tinyint(1) NOT NULL default '0',
`fireside` tinyint(1) NOT NULL default '0',
`aircondition` tinyint(1) NOT NULL default '0',
`tv` tinyint(1) NOT NULL default '0',
`dsl` tinyint(1) NOT NULL default '0',
`swpool` tinyint(1) NOT NULL default '0',
`balcony` tinyint(1) NOT NULL default '0',
`terrace` tinyint(1) NOT NULL default '0',
`garden` tinyint(1) NOT NULL default '0',
`parkarea` tinyint(1) NOT NULL default '0',
`garage` tinyint(1) NOT NULL default '0',
`rent` decimal(10,2) NOT NULL default '0.00',
`rent_extra` decimal(10,2) NOT NULL default '0.00',
`price` decimal(20,2) NOT NULL default '0.00',
`commis` varchar(15) NOT NULL default '',
`secure` decimal(10,2) NOT NULL default '0.00',
`receipts` decimal(10,2) NOT NULL default '0.00',
`street` varchar(255) NOT NULL default '',
`streetnr` varchar(5) NOT NULL default '',
`pcode` varchar(10) NOT NULL default '',
`town` tinytext NOT NULL,
`district` tinytext NOT NULL,
`locstate` tinytext NOT NULL,
`country` tinytext NOT NULL,
`hits` int(6) NOT NULL default '0',
`hot` tinyint(1) NOT NULL default '0',
`sold` tinyint(1) NOT NULL default '0',
`mapcoords` tinytext NOT NULL,
`metadesc` varchar(255) NOT NULL default '',
`metakey` varchar(255) NOT NULL default '',
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`created_by` int(11) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`publish_up` datetime NOT NULL,
`publish_down` datetime NOT NULL,
`published` tinyint(1) NOT NULL default '1',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Tablo döküm verisi `jos_estateagent`
--
mister estate:
CREATE TABLE IF NOT EXISTS `jos_misterestate` (
`id` int(10) NOT NULL auto_increment,
`obj_id` varchar(25) NOT NULL default '',
`cat` tinyint(4) NOT NULL default '0',
`type` tinyint(2) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`location` text NOT NULL,
`condition` text NOT NULL,
`other` text NOT NULL,
`rooms` smallint(4) NOT NULL default '0',
`bedrooms` smallint(4) NOT NULL default '0',
`wc` smallint(4) NOT NULL default '0',
`space` decimal(10,2) NOT NULL default '0.00',
`homes` smallint(5) NOT NULL default '0',
`homes_size` decimal(10,2) NOT NULL default '0.00',
`pp_size` decimal(10,2) NOT NULL default '0.00',
`trade_units` smallint(5) NOT NULL default '0',
`trade_size` decimal(10,2) NOT NULL default '0.00',
`position` varchar(50) NOT NULL default '',
`lift` tinyint(1) NOT NULL default '0',
`handicap` tinyint(1) NOT NULL default '0',
`yobuilt` varchar(10) NOT NULL default '',
`toheat` tinytext NOT NULL,
`toheat_ufloor` tinyint(1) NOT NULL default '0',
`fireside` tinyint(1) NOT NULL default '0',
`aircondition` tinyint(1) NOT NULL default '0',
`tv` tinyint(1) NOT NULL default '0',
`dsl` tinyint(1) NOT NULL default '0',
`swpool` tinyint(1) NOT NULL default '0',
`balcony` tinyint(1) NOT NULL default '0',
`terrace` tinyint(1) NOT NULL default '0',
`garden` tinyint(1) NOT NULL default '0',
`parkarea` tinyint(1) NOT NULL default '0',
`garage` tinyint(1) NOT NULL default '0',
`rent` decimal(10,2) NOT NULL default '0.00',
`rent_extra` decimal(10,2) NOT NULL default '0.00',
`price` decimal(10,2) NOT NULL default '0.00',
`commis` varchar(15) NOT NULL default '',
`secure` decimal(10,2) NOT NULL default '0.00',
`receipts` decimal(10,2) NOT NULL default '0.00',
`street` varchar(255) NOT NULL default '',
`streetnr` varchar(5) NOT NULL default '',
`pcode` varchar(10) NOT NULL default '',
`town` tinytext NOT NULL,
`district` tinytext NOT NULL,
`state` tinytext NOT NULL,
`country` tinytext NOT NULL,
`hits` int(6) NOT NULL default '0',
`hot` tinyint(1) NOT NULL default '0',
`metadesc` varchar(255) NOT NULL default '',
`metakey` varchar(255) NOT NULL default '',
`created` date NOT NULL default '0000-00-00',
`created_by` int(11) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`verified` tinyint(1) NOT NULL default '-1',
`publish_up` date NOT NULL default '0000-00-00',
`publish_down` date NOT NULL default '0000-00-00',
`publish` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=385 ;
bu yapılabilr mi ?