Remove mulder dependency

merge remove-mulder-dependency into master

db/somattend_schema.sql

+-- MySQL dump 10.9
+--
+-- Host: localhost    Database: fpatrack
+-- ------------------------------------------------------
+-- Server version	4.1.22
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `attendance`
+--
+
+DROP TABLE IF EXISTS `attendance`;
+CREATE TABLE `attendance` (
+  `attendance_id` int(4) unsigned NOT NULL auto_increment,
+  `import_set_id` int(4) unsigned NOT NULL default '0',
+  `serial_number` varchar(255) default NULL,
+  `nuid` int(4) unsigned NOT NULL default '0',
+  `swipe_time` int(4) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`attendance_id`),
+  UNIQUE KEY `attendance_record` (`import_set_id`,`serial_number`,`nuid`,`swipe_time`),
+  KEY `serial_number` (`serial_number`),
+  KEY `nuid` (`nuid`),
+  KEY `swipe_time` (`swipe_time`),
+  CONSTRAINT `attendance_ibfk_1` FOREIGN KEY (`import_set_id`) REFERENCES `import_sets` (`import_set_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `attendance_ibfk_2` FOREIGN KEY (`nuid`) REFERENCES `people` (`nuid`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `comments`
+--
+
+DROP TABLE IF EXISTS `comments`;
+CREATE TABLE `comments` (
+  `comment_id` int(4) unsigned NOT NULL auto_increment,
+  `subject_nuid` int(4) unsigned NOT NULL default '0',
+  `poster_nuid` int(4) unsigned NOT NULL default '0',
+  `comment` text NOT NULL,
+  `entry_time` int(4) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`comment_id`),
+  KEY `subject_nuid` (`subject_nuid`),
+  KEY `poster_nuid` (`poster_nuid`),
+  CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`subject_nuid`) REFERENCES `people` (`nuid`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`poster_nuid`) REFERENCES `people` (`nuid`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `courses`
+--
+
+DROP TABLE IF EXISTS `courses`;
+CREATE TABLE `courses` (
+  `course_id` varchar(20) NOT NULL default '',
+  `department` varchar(255) NOT NULL default '',
+  `course_number` varchar(255) NOT NULL default '',
+  `section` varchar(8) NOT NULL default '',
+  `semester_code` int(4) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`course_id`),
+  UNIQUE KEY `course` (`department`,`course_number`,`section`,`semester_code`),
+  KEY `semester_code` (`semester_code`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `credit`
+--
+
+DROP TABLE IF EXISTS `credit`;
+CREATE TABLE `credit` (
+  `credit_id` int(4) unsigned NOT NULL auto_increment,
+  `nuid` int(4) unsigned NOT NULL default '0',
+  `event_id` int(4) unsigned NOT NULL default '0',
+  `credit` enum('yes','tardy','no') NOT NULL default 'yes',
+  PRIMARY KEY  (`credit_id`),
+  UNIQUE KEY `unique_credit` (`nuid`,`event_id`),
+  KEY `nuid` (`nuid`),
+  KEY `event_id` (`event_id`),
+  KEY `credit` (`credit`),
+  CONSTRAINT `credit_ibfk_1` FOREIGN KEY (`nuid`) REFERENCES `people` (`nuid`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `credit_ibfk_2` FOREIGN KEY (`event_id`) REFERENCES `events` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `enrollments`
+--
+
+DROP TABLE IF EXISTS `enrollments`;
+CREATE TABLE `enrollments` (
+  `enrollment_id` int(4) unsigned NOT NULL auto_increment,
+  `course_id` varchar(20) NOT NULL default '',
+  `nuid` int(4) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`enrollment_id`),
+  UNIQUE KEY `enrollment` (`course_id`,`nuid`),
+  KEY `course_id` (`course_id`),
+  KEY `nuid` (`nuid`),
+  CONSTRAINT `enrollments_ibfk_2` FOREIGN KEY (`nuid`) REFERENCES `people` (`nuid`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `enrollments_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `events`
+--
+
+DROP TABLE IF EXISTS `events`;
+CREATE TABLE `events` (
+  `event_id` int(4) unsigned NOT NULL auto_increment,
+  `semester_code` int(4) unsigned NOT NULL default '61',
+  `name` varchar(255) NOT NULL default '',
+  `display_name` varchar(255) NOT NULL default '',
+  `start_time` int(4) unsigned NOT NULL default '0',
+  `end_time` int(4) unsigned NOT NULL default '0',
+  `ugrad_credit` enum('true','false') NOT NULL default 'false',
+  `grad_credit` enum('true','false') NOT NULL default 'false',
+  PRIMARY KEY  (`event_id`),
+  UNIQUE KEY `name` (`name`),
+  KEY `semester_code` (`semester_code`),
+  KEY `ugrad_credit` (`ugrad_credit`),
+  KEY `grad_credit` (`grad_credit`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `import_sets`
+--
+
+DROP TABLE IF EXISTS `import_sets`;
+CREATE TABLE `import_sets` (
+  `import_set_id` int(4) unsigned NOT NULL auto_increment,
+  `event_id` int(4) unsigned NOT NULL default '0',
+  `reader_id` int(4) unsigned NOT NULL default '0',
+  `creation_time` int(4) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`import_set_id`),
+  UNIQUE KEY `import_set` (`event_id`,`reader_id`,`creation_time`),
+  KEY `event_id` (`event_id`),
+  KEY `reader_id` (`reader_id`),
+  CONSTRAINT `import_sets_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `import_sets_ibfk_2` FOREIGN KEY (`reader_id`) REFERENCES `readers` (`reader_id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `people`
+--
+
+DROP TABLE IF EXISTS `people`;
+CREATE TABLE `people` (
+  `nuid` int(4) unsigned NOT NULL default '0',
+  `user_name` varchar(255) NOT NULL default '',
+  `first_name` varchar(255) NOT NULL default '',
+  `middle_name` varchar(255) NOT NULL default '',
+  `last_name` varchar(255) NOT NULL default '',
+  `email` varchar(127) NOT NULL default '',
+  PRIMARY KEY  (`nuid`),
+  UNIQUE KEY `full_name` (`first_name`,`middle_name`,`last_name`),
+  UNIQUE KEY `user_name` (`user_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `readers`
+--
+
+DROP TABLE IF EXISTS `readers`;
+CREATE TABLE `readers` (
+  `reader_id` int(4) unsigned NOT NULL auto_increment,
+  `mac_address` varchar(17) NOT NULL default '',
+  `name` varchar(255) default NULL,
+  PRIMARY KEY  (`reader_id`),
+  UNIQUE KEY `mac_address` (`mac_address`),
+  UNIQUE KEY `name` (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `staff_assignments`
+--
+
+DROP TABLE IF EXISTS `staff_assignments`;
+CREATE TABLE `staff_assignments` (
+  `assignment_id` int(4) unsigned NOT NULL auto_increment,
+  `course_id` varchar(20) NOT NULL default '',
+  `nuid` int(4) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`assignment_id`),
+  UNIQUE KEY `assignment` (`course_id`,`nuid`),
+  KEY `nuid` (`nuid`),
+  CONSTRAINT `staff_assignments_ibfk_2` FOREIGN KEY (`nuid`) REFERENCES `people` (`nuid`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `staff_assignments_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+