-- 
-- Database: `XRI_DB`
-- Credits : Mike Lindelsee, Gabe Wachob, Sudhir Ancha
-- 

-- Enabled Next 3 Lines if New Database also needs to be Created

-- DROP DATABASE `XRI_DB`;
-- CREATE DATABASE `XRI_DB` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- USE XRI_DB;

-- --------------------------------------------------------

-- 
-- Table structure for table `extension_attribute`
-- 

CREATE TABLE `extension_attribute` (
  `serial_num` int(11) NOT NULL auto_increment,
  `extension_attribute_key` int(11) NOT NULL default '0',
  `extension_attr_list_key` int(11) NOT NULL default '0',
  PRIMARY KEY  (`serial_num`),
  KEY `extension_attribute_key` (`extension_attribute_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `extension_attribute_list`
-- 

CREATE TABLE `extension_attribute_list` (
  `extension_attr_list_key` int(11) NOT NULL auto_increment,
  `namespace_key` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`extension_attr_list_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `extension_element`
-- 

CREATE TABLE `extension_element` (
  `serial_num` int(11) NOT NULL auto_increment,
  `extension_element_key` int(11) NOT NULL default '0',
  `extension_xml` text NOT NULL,
  PRIMARY KEY  (`serial_num`),
  KEY `extension_element_key` (`extension_element_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `last_extension_attribute_key`
-- 

CREATE TABLE `last_extension_attribute_key` (
  `key` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `last_extension_element_key`
-- 

CREATE TABLE `last_extension_element_key` (
  `key` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `last_media_type_key`
-- 

CREATE TABLE `last_media_type_key` (
  `key` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `last_trust_mechanism_key`
-- 

CREATE TABLE `last_trust_mechanism_key` (
  `key` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `last_uri_prority_key`
-- 

CREATE TABLE `last_uri_prority_key` (
  `key` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `media_type`
-- 

CREATE TABLE `media_type` (
  `serial_num` int(11) NOT NULL auto_increment,
  `media_type_key` int(11) NOT NULL default '0',
  `media_type_string` varchar(255) NOT NULL default '',
  `extension_attribute_key` int(11) default NULL,
  PRIMARY KEY  (`serial_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `namespace_list`
-- 

CREATE TABLE `namespace_list` (
  `namespace_key` int(11) NOT NULL auto_increment,
  `prefix` varchar(255) NOT NULL default '',
  `uri` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`namespace_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `trust_mechanism`
-- 

CREATE TABLE `trust_mechanism` (
  `serial_num` int(11) NOT NULL auto_increment,
  `trust_mechanism_key` int(11) NOT NULL default '0',
  `trust_mechanism-uri_key` int(11) NOT NULL default '0',
  PRIMARY KEY  (`serial_num`),
  KEY `trust_mechanism-uri_key` (`trust_mechanism-uri_key`),
  KEY `trust_mechanism_key` (`trust_mechanism_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `uri`
-- 

CREATE TABLE `uri` (
  `uri_key` int(11) NOT NULL auto_increment,
  `uri` varchar(255) NOT NULL default '',
  `extension_attribute_key` int(11) default NULL,
  PRIMARY KEY  (`uri_key`),
  KEY `uri` (`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `uri_priority`
-- 

CREATE TABLE `uri_priority` (
  `serial_num` int(11) NOT NULL auto_increment,
  `uri_priority_key` int(11) NOT NULL default '0',
  `uri_key` int(11) NOT NULL default '0',
  `priority` int(11) NOT NULL default '0',
  PRIMARY KEY  (`serial_num`),
  KEY `uri_key` (`uri_key`),
  KEY `uri_priority_key` (`uri_priority_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `xrid_authority_element`
-- 

CREATE TABLE `xrid_authority_element` (
  `xri_authority_element_key` int(11) NOT NULL auto_increment,
  `xrid_key` int(11) NOT NULL default '0',
  `extension_attribute_key` int(11) default NULL,
  `extension_element_key` int(11) default NULL,
  `authority_id` varchar(255) NOT NULL default '',
  `authority_id_extens_attr_key` int(11) default NULL,
  `priority` int(11) default NULL,
  `type-uri_key` int(11) default NULL,
  `uri_priority_key` int(11) default NULL,
  `trust_mechanism_key` int(11) default NULL,
  PRIMARY KEY  (`xri_authority_element_key`),
  KEY `xrid_key` (`xrid_key`),
  KEY `extension_element_key` (`extension_element_key`),
  KEY `extension_attribute_key` (`extension_attribute_key`),
  KEY `type-uri_key` (`type-uri_key`),
  KEY `uri_priority_key` (`uri_priority_key`),
  KEY `trust_mechanism_key` (`trust_mechanism_key`),
  KEY `authority_id_extens_attr_key` (`authority_id_extens_attr_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `xrid_element`
-- 

CREATE TABLE `xrid_element` (
  `xrid_key` int(11) NOT NULL auto_increment,
  `parent_authority_id` varchar(255) NOT NULL default '',
  `subsegment` varchar(255) NOT NULL default '',
  `subsegment_ext_attr_key` int(11) default NULL,
  `extension_element_key` int(11) default NULL,
  `extension_attribute_key` int(11) default NULL,
  `enabled` char(1) NOT NULL default 'N',
  `update_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `creation_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `trust_mechanism_key` int(11) default NULL,
  `expiry_time` datetime default NULL,
  `expiry_time_ext_attr_key` int(11) default NULL,
  PRIMARY KEY  (`xrid_key`),
  UNIQUE KEY `parent_authority_id` (`parent_authority_id`,`subsegment`),
  KEY `extension_element_key` (`extension_element_key`),
  KEY `extension_attribute_key` (`extension_attribute_key`),
  KEY `trust_mechanism_key` (`trust_mechanism_key`),
  KEY `expiry_time_ext_attr_key` (`expiry_time_ext_attr_key`),
  KEY `subsegment_ext_attr_key` (`subsegment_ext_attr_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `xrid_service_element`
-- 

CREATE TABLE `xrid_service_element` (
  `xrid_service_element_key` int(11) NOT NULL auto_increment,
  `xrid_key` int(11) NOT NULL default '0',
  `extension_element_key` int(11) default NULL,
  `extension_attribute_key` int(11) default NULL,
  `type-uri_key` int(11) default NULL,
  `priority` int(11) default NULL,
  `uri_priority_key` int(11) default NULL,
  `media_type_key` int(11) default NULL,
  PRIMARY KEY  (`xrid_service_element_key`),
  KEY `xrid_key` (`xrid_key`),
  KEY `extension_element_key` (`extension_element_key`),
  KEY `extension_attribute_key` (`extension_attribute_key`),
  KEY `type-uri_key` (`type-uri_key`),
  KEY `uri_priority_key` (`uri_priority_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `xrid_synonym_element`
-- 

CREATE TABLE `xrid_synonym_element` (
  `xrid_synonym_element_key` int(11) NOT NULL auto_increment,
  `xrid_key` int(11) NOT NULL default '0',
  `extension_attribute_key` int(11) default NULL,
  `extension_element_key` int(11) default NULL,
  `internal_uri_priority_key` int(11) default NULL,
  `external_uri_priority_key` int(11) default NULL,
  PRIMARY KEY  (`xrid_synonym_element_key`),
  KEY `extension_element_key` (`extension_element_key`),
  KEY `internal_uri_priority_key` (`internal_uri_priority_key`),
  KEY `external_uri_priority_key` (`external_uri_priority_key`),
  KEY `extension_attribute_key` (`extension_attribute_key`),
  KEY `xrid_key` (`xrid_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `cachetable`
-- 

CREATE TABLE `cachetable` (
  `key` int(11) NOT NULL auto_increment,
  `parentuuid` varchar(255) NOT NULL default '',
  `subsegment` varchar(255) NOT NULL default '',
  `signed` smallint(1) NOT NULL default '0',
  `xridstring` text NOT NULL,
  `update_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`key`),
  UNIQUE KEY `parentuuid` (`parentuuid`,`subsegment`,`signed`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------


-- 
-- Constraints for dumped tables
-- 

-- 
-- Constraints for table `xrid_authority_element`
-- 
ALTER TABLE `xrid_authority_element`
  ADD CONSTRAINT `xrid_authority_element_ibfk_1` FOREIGN KEY (`type-uri_key`) REFERENCES `uri` (`uri_key`);