USE PandaMetaDB;

-- server redirection table
CREATE TABLE `redirect` (
       `service` varchar(30) NOT NULL default '',               -- service name
       `type` varchar(30) NOT NULL default '',                  -- service type name
       `site` varchar(30) NOT NULL default '',                  -- site name
       `description` varchar(120) NOT NULL default '',          -- description of this instance
       `url` varchar(250) NOT NULL default '',                  -- service URL
       `testurl` varchar(250) NOT NULL default '',              -- test URL
       `response` varchar(30) NOT NULL default '',              -- expected response
       `aliveresponse` varchar(30) NOT NULL default '',         -- expected response to isAlive
       `responsetime` mediumint,                                -- time to receive response in sec
       `rank` mediumint,                                        -- ranking of this service instance
       `performance` mediumint,                                 -- performance index
       `status` varchar(30) NOT NULL default '',                -- service status
       `log` varchar(250) NOT NULL default '',                  -- error log from access attempt
       `statustime` timestamp,                                  -- status update time
       `usetime` timestamp,                                     -- last usage time
       PRIMARY KEY (`url`)
) TYPE=NDB;
