source include/federated.inc; source include/have_innodb.inc; connection slave; drop table if exists federated.t1; CREATE TABLE federated.t1 ( categoryId int(11) NOT NULL auto_increment, domainId varchar(40) NOT NULL default '', parentCategoryId int(11) default '0', categoryName varchar(255) NOT NULL default '', categoryDesc text, categoryCreationDate datetime default NULL, categoryModifiedDate datetime default NULL, categoryOrder int(11) default '0', categoryOption int(11) default NULL, categoryStatus int(11) default NULL, resource_uuid varchar(32) default NULL, lastUpdDate timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (categoryId), UNIQUE KEY idx_unique_category_categoryName (domainId,categoryName), KEY idx_category_domainId (domainId) )ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='category'; connection master; drop table if exists federated.t1; CREATE TABLE federated.t1 ( categoryId int(11) NOT NULL auto_increment, domainId varchar(40) NOT NULL default '', parentCategoryId int(11) default '0', categoryName varchar(255) NOT NULL default '', categoryDesc text, categoryCreationDate datetime default NULL, categoryModifiedDate datetime default NULL, categoryOrder int(11) default '0', categoryOption int(11) default NULL, categoryStatus int(11) default NULL, resource_uuid varchar(32) default NULL, lastUpdDate timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (categoryId), UNIQUE KEY idx_unique_category_categoryName (domainId,categoryName), KEY idx_category_domainId (domainId) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 COMMENT='category' CONNECTION='mysql://root@127.0.0.1:@/too/many/items/federated/t1';