Page History

h2.

h3. DB

{gliffy:name=DB Schema 2|space=IEPM|page=PerfSONAR_PS File Transfer MA|pageid=57348062|align=center|size=L}

h3. Sql Statements


h4. Data Table

{code}
 CREATE TABLE `Data` (
  `ID` int(10) NOT NULL,
  `Metadata_ID` int(10) NOT NULL,
  `TransferTime` datetime NOT NULL,
  `NBytes` int(20) NOT NULL,
  `Duration` int(20) NOT NULL,
  KEY `TransferTimeIndex` (`TransferTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin {code}

h4. Metadata Table

{code}

CREATE TABLE `Metadata` (
  `Stripes` varchar(255) default NULL,
  `BufferSize` int(32) default NULL,
  `BlockSize` int(32) default NULL,
  `Program` varchar(22) default NULL,
  `User` varchar(50) default NULL,
  `EndPointID` varchar(11) default NULL,
  `Streams` int(32) default NULL,
  `DestPath` varchar(255) default NULL,
  `SrcPath` varchar(255) default NULL,
  `ID` int(10) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `uni_metadata` (`Streams`,`Stripes`,`BufferSize`,`BlockSize`,`Program`,`User`,`EndPointID`,`DestPath`,`SrcPath`)
) ENGINE=InnoDB AUTO_INCREMENT=497967 DEFAULT CHARSET=utf8 COLLATE=utf8_bin \|
{code}


h4. EndPoints Table

{code}

CREATE TABLE `EndPoints` (
  `ID` int(11) NOT NULL auto_increment,
  `DestIP` varchar(32) NOT NULL,
  `SrcIP` varchar(32) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `uni_endpoint` (`DestIP`,`SrcIP`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_bin \|
{code}


h3. System Design
{gliffy:name=FilesetFilesAndChunks2|space=IEPM|page=PerfSONAR_PS File Transfer MA|pageid=57348062|align=center|size=L}

h3. Xml Schema

[][