Creating Federated Tables

[Megha Razdan]

Hello All,
Following is the script:

CREATE TABLE `sys_client` (
`CLIENT_ID` bigint(20) NOT NULL DEFAULT '0',
`NAME` varchar(50) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`ACTIVE_FLAG` char(1) NOT NULL DEFAULT 'Y',
`ISSYS_FLAG` char(1) NOT NULL DEFAULT 'N',
`LICENSE_STARTDATE` datetime NOT NULL,
`LICENSE_ENDDATE` datetime NOT NULL,
`LICENSE_CONCURRENT_SESSION` int(10) unsigned NOT NULL DEFAULT '0',
`LICENSE_RENEWALMETHOD` char(1) NOT NULL DEFAULT 'A',
`CREATED_ON` datetime NOT NULL,
`CREATED_BY_USER_ID` bigint(20) unsigned NOT NULL,
`UPDATED_ON` datetime NOT NULL,
`UPDATED_BY_USER_ID` bigint(20) unsigned NOT NULL,
`ISDELETED` char(1) DEFAULT 'N',
PRIMARY KEY (`CLIENT_ID`),
UNIQUE KEY `UNI_SYS_CLIENT_NAME` (`NAME`),
KEY `INX_SYS_CLIENT_ACTIVE_FLAG` (`ACTIVE_FLAG`),
KEY `INX_SYS_CLIENT_ISSYS_FLAG` (`ISSYS_FLAG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='It is designed to partition all entities related' engine='FEDERATED'
connection='mysql://user:user1@192.168.40.22:3306/testDB/sys_client';
;
i ran this on my local server.
It gave the following error: "Unknown table engine 'FEDERATED'"

Server version is 5.1.30
Why is this happening?