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 ?