--
-- Table structure for table `lams_fed_server`
--
DROP TABLE IF EXISTS `lams_fed_server`;
CREATE TABLE `lams_fed_server` (
  `sid` int(11) NOT NULL auto_increment,
  `fed_id` int(11) NOT NULL UNIQUE,
  `name` varchar(255) NOT NULL,
  `institution` varchar(255),
  `url` varchar(255) NOT NULL,
  `privatekey` varchar(255) NOT NULL,
  PRIMARY KEY  (`sid`),
  UNIQUE KEY `name` (`name`)
) TYPE=InnoDB;

--
-- Table structure for table `lams_fed_lesson`
--
DROP TABLE IF EXISTS `lams_fed_lesson`;
CREATE TABLE `lams_fed_lesson` (
  `sid` int(11) NOT NULL auto_increment,
  `server_sid` int(11) NOT NULL,
  `ext_org_id` bigint(20) NOT NULL,
  `lesson_id` bigint(20) NOT NULL,
  PRIMARY KEY  (`sid`)
) TYPE=InnoDB;