Skip to content

Instantly share code, notes, and snippets.

@ryanstrandt

ryanstrandt/MT database dump

Created August 11, 2010 15:15
Show Gist options
  • Save ryanstrandt/519134 to your computer and use it in GitHub Desktop.
Save ryanstrandt/519134 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MT database dump
# Sequel Pro dump
# Version 2492
# http://code.google.com/p/sequel-pro
#
# Host: 127.0.0.1 (MySQL 5.1.38-log)
# Database: MT
# Generation Time: 2010-08-11 11:14:00 -0400
# ************************************************************
# Dump of table addresses
# ------------------------------------------------------------
DROP TABLE IF EXISTS `addresses`;
CREATE TABLE `addresses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`address_type` text,
`title` varchar(255) DEFAULT NULL,
`address1` varchar(255) DEFAULT NULL,
`address2` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`zip` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`alternate_phone` varchar(255) DEFAULT NULL,
`dorm` varchar(255) DEFAULT NULL,
`room` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`created_at` date DEFAULT NULL,
`updated_at` date DEFAULT NULL,
`email_validated` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `person_id` (`person_id`),
KEY `index_addresses_on_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=623038 DEFAULT CHARSET=utf8;
# Dump of table campus_involvements
# ------------------------------------------------------------
DROP TABLE IF EXISTS `campus_involvements`;
CREATE TABLE `campus_involvements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`campus_id` int(11) DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`ministry_id` int(11) DEFAULT NULL,
`added_by_id` int(11) DEFAULT NULL,
`graduation_date` date DEFAULT NULL,
`school_year_id` int(11) DEFAULT NULL,
`major` varchar(255) DEFAULT NULL,
`minor` varchar(255) DEFAULT NULL,
`last_history_update_date` date DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_campus_involvements_on_p_id_and_c_id_and_end_date` (`person_id`,`campus_id`,`end_date`),
KEY `index_campus_involvements_on_ministry_id` (`ministry_id`),
KEY `index_campus_involvements_on_campus_id` (`campus_id`),
KEY `person_id` (`person_id`)
) ENGINE=InnoDB AUTO_INCREMENT=94792 DEFAULT CHARSET=utf8;
# Dump of table campuses
# ------------------------------------------------------------
DROP TABLE IF EXISTS `campuses`;
CREATE TABLE `campuses` (
`id` int(11) unsigned NOT NULL,
`name` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`zip` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`abbrv` varchar(255) DEFAULT NULL,
`is_secure` varchar(100) DEFAULT NULL,
`enrollment` varchar(100) DEFAULT NULL,
`created_at` date DEFAULT NULL,
`updated_at` date DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`address2` varchar(255) DEFAULT NULL,
`county` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_campuses_on_county` (`county`),
KEY `index_campuses_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table columns
# ------------------------------------------------------------
DROP TABLE IF EXISTS `columns`;
CREATE TABLE `columns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`update_clause` varchar(255) DEFAULT NULL,
`from_clause` varchar(255) DEFAULT NULL,
`select_clause` text,
`column_type` varchar(255) DEFAULT NULL,
`writeable` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`join_clause` varchar(255) DEFAULT NULL,
`source_model` varchar(255) DEFAULT NULL,
`source_column` varchar(255) DEFAULT NULL,
`foreign_key` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
# Dump of table conference_registrations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `conference_registrations`;
CREATE TABLE `conference_registrations` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`registrationDate` datetime DEFAULT NULL,
`registrationType` varchar(80) DEFAULT NULL,
`preRegistered` char(1) DEFAULT NULL,
`newPersonID` int(10) DEFAULT NULL,
`conference_id` int(10) DEFAULT NULL,
`arriveDate` datetime DEFAULT NULL,
`leaveDate` datetime DEFAULT NULL,
`additionalRooms` int(10) DEFAULT NULL,
`spouseComing` int(10) DEFAULT NULL,
`spouseRegistrationID` int(10) DEFAULT NULL,
`registeredFirst` char(1) DEFAULT NULL,
`isOnsite` char(1) DEFAULT NULL,
`fk_RegistrationTypeID` int(10) DEFAULT NULL,
`person_id` int(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_RegistrationTypeID` (`fk_RegistrationTypeID`),
KEY `fk_PersonID` (`person_id`),
KEY `fk_ConferenceID` (`conference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=191174 DEFAULT CHARSET=utf8;
# Dump of table conferences
# ------------------------------------------------------------
DROP TABLE IF EXISTS `conferences`;
CREATE TABLE `conferences` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`createDate` datetime DEFAULT NULL,
`attributesAsked` varchar(30) DEFAULT NULL,
`name` varchar(64) DEFAULT NULL,
`theme` varchar(128) DEFAULT NULL,
`password` varchar(20) DEFAULT NULL,
`staffPassword` varchar(20) DEFAULT NULL,
`region` varchar(3) DEFAULT NULL,
`briefDescription` varchar(8000) DEFAULT NULL,
`contactName` varchar(60) DEFAULT NULL,
`contactEmail` varchar(50) DEFAULT NULL,
`contactPhone` varchar(24) DEFAULT NULL,
`contactAddress1` varchar(35) DEFAULT NULL,
`contactAddress2` varchar(35) DEFAULT NULL,
`contactCity` varchar(30) DEFAULT NULL,
`contactState` varchar(6) DEFAULT NULL,
`contactZip` varchar(10) DEFAULT NULL,
`splashPageURL` varchar(128) DEFAULT NULL,
`confImageId` varchar(64) DEFAULT NULL,
`fontFace` varchar(64) DEFAULT NULL,
`backgroundColor` varchar(6) DEFAULT NULL,
`foregroundColor` varchar(6) DEFAULT NULL,
`highlightColor` varchar(6) DEFAULT NULL,
`confirmationEmail` varchar(4000) DEFAULT NULL,
`acceptCreditCards` char(1) DEFAULT NULL,
`acceptEChecks` char(1) DEFAULT NULL,
`acceptScholarships` char(1) DEFAULT NULL,
`authnetPassword` varchar(200) DEFAULT NULL,
`preRegStart` datetime DEFAULT NULL,
`preRegEnd` datetime DEFAULT NULL,
`defaultDateStaffArrive` datetime DEFAULT NULL,
`defaultDateStaffLeave` datetime DEFAULT NULL,
`defaultDateGuestArrive` datetime DEFAULT NULL,
`defaultDateGuestLeave` datetime DEFAULT NULL,
`defaultDateStudentArrive` datetime DEFAULT NULL,
`defaultDateStudentLeave` datetime DEFAULT NULL,
`masterDefaultDateArrive` datetime DEFAULT NULL,
`masterDefaultDateLeave` datetime DEFAULT NULL,
`ministryType` varchar(2) DEFAULT NULL,
`isCloaked` varchar(1) DEFAULT NULL,
`onsiteCost` double DEFAULT NULL,
`commuterCost` double DEFAULT NULL,
`preRegDeposit` double DEFAULT NULL,
`discountFullPayment` double DEFAULT NULL,
`discountEarlyReg` double DEFAULT NULL,
`discountEarlyRegDate` datetime DEFAULT NULL,
`checkPayableTo` varchar(40) DEFAULT NULL,
`merchantAcctNum` varchar(64) DEFAULT NULL,
`backgroundColor3` varchar(6) DEFAULT NULL,
`backgroundColor2` varchar(6) DEFAULT NULL,
`highlightColor2` varchar(6) DEFAULT NULL,
`requiredColor` varchar(6) DEFAULT NULL,
`acceptVisa` char(1) DEFAULT NULL,
`acceptMasterCard` char(1) DEFAULT NULL,
`acceptAmericanExpress` char(1) DEFAULT NULL,
`acceptDiscover` char(1) DEFAULT NULL,
`staffProfileNumber` int(10) DEFAULT NULL,
`staffProfileReqNumber` int(10) DEFAULT NULL,
`guestProfileNumber` int(10) DEFAULT NULL,
`guestProfileReqNumber` int(10) DEFAULT NULL,
`studentProfileNumber` int(10) DEFAULT NULL,
`studentProfileReqNumber` int(10) DEFAULT NULL,
`askStudentChildren` char(1) DEFAULT NULL,
`askStaffChildren` char(1) DEFAULT NULL,
`askGuestChildren` char(1) DEFAULT NULL,
`studentLabel` varchar(64) DEFAULT NULL,
`staffLabel` varchar(64) DEFAULT NULL,
`guestLabel` varchar(64) DEFAULT NULL,
`studentDesc` varchar(255) DEFAULT NULL,
`staffDesc` varchar(255) DEFAULT NULL,
`guestDesc` varchar(255) DEFAULT NULL,
`askStudentSpouse` char(1) DEFAULT NULL,
`askStaffSpouse` char(1) DEFAULT NULL,
`askGuestSpouse` char(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=utf8;
# Dump of table correspondence_types
# ------------------------------------------------------------
DROP TABLE IF EXISTS `correspondence_types`;
CREATE TABLE `correspondence_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`overdue_lifespan` int(11) DEFAULT NULL,
`expiry_lifespan` int(11) DEFAULT NULL,
`actions_now_task` varchar(255) DEFAULT NULL,
`actions_overdue_task` varchar(255) DEFAULT NULL,
`actions_followup_task` varchar(255) DEFAULT NULL,
`redirect_params` text,
`redirect_target_id_type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table correspondences
# ------------------------------------------------------------
DROP TABLE IF EXISTS `correspondences`;
CREATE TABLE `correspondences` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`correspondence_type_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`receipt` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`visited` date DEFAULT NULL,
`completed` date DEFAULT NULL,
`overdue_at` date DEFAULT NULL,
`expire_at` date DEFAULT NULL,
`token_params` text,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_correspondences_on_receipt` (`receipt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table counties
# ------------------------------------------------------------
DROP TABLE IF EXISTS `counties`;
CREATE TABLE `counties` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_counties_on_state` (`state`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
# Dump of table countries
# ------------------------------------------------------------
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country` varchar(100) DEFAULT NULL,
`code` varchar(10) DEFAULT NULL,
`closed` tinyint(1) DEFAULT '0',
`iso_code` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8;
# Dump of table custom_attributes
# ------------------------------------------------------------
DROP TABLE IF EXISTS `custom_attributes`;
CREATE TABLE `custom_attributes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ministry_id` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`value_type` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_custom_attributes_on_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
# Dump of table custom_values
# ------------------------------------------------------------
DROP TABLE IF EXISTS `custom_values`;
CREATE TABLE `custom_values` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`custom_attribute_id` int(11) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
# Dump of table delayed_jobs
# ------------------------------------------------------------
DROP TABLE IF EXISTS `delayed_jobs`;
CREATE TABLE `delayed_jobs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`priority` int(11) DEFAULT '0',
`attempts` int(11) DEFAULT '0',
`handler` text,
`last_error` varchar(255) DEFAULT NULL,
`run_at` datetime DEFAULT NULL,
`locked_at` datetime DEFAULT NULL,
`failed_at` datetime DEFAULT NULL,
`locked_by` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
# Dump of table dorms
# ------------------------------------------------------------
DROP TABLE IF EXISTS `dorms`;
CREATE TABLE `dorms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`campus_id` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`created_at` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
# Dump of table email_templates
# ------------------------------------------------------------
DROP TABLE IF EXISTS `email_templates`;
CREATE TABLE `email_templates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`correspondence_type_id` int(11) DEFAULT NULL,
`outcome_type` varchar(255) DEFAULT NULL,
`subject` varchar(255) NOT NULL,
`from` varchar(255) NOT NULL,
`bcc` varchar(255) DEFAULT NULL,
`cc` varchar(255) DEFAULT NULL,
`body` text NOT NULL,
`template` text,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table emails
# ------------------------------------------------------------
DROP TABLE IF EXISTS `emails`;
CREATE TABLE `emails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject` varchar(255) DEFAULT NULL,
`body` text,
`people_ids` text,
`missing_address_ids` text,
`search_id` int(11) DEFAULT NULL,
`sender_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
# Dump of table free_times
# ------------------------------------------------------------
DROP TABLE IF EXISTS `free_times`;
CREATE TABLE `free_times` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`start_time` int(11) DEFAULT NULL,
`end_time` int(11) DEFAULT NULL,
`day_of_week` int(11) DEFAULT NULL,
`timetable_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`css_class` varchar(255) DEFAULT NULL,
`weight` decimal(4,2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
# Dump of table group_involvements
# ------------------------------------------------------------
DROP TABLE IF EXISTS `group_involvements`;
CREATE TABLE `group_involvements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
`level` varchar(255) DEFAULT NULL,
`requested` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_membership` (`person_id`,`group_id`,`level`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
# Dump of table group_types
# ------------------------------------------------------------
DROP TABLE IF EXISTS `group_types`;
CREATE TABLE `group_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ministry_id` int(11) DEFAULT NULL,
`group_type` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`mentor_priority` tinyint(1) DEFAULT NULL,
`public` tinyint(1) DEFAULT NULL,
`unsuitability_leader` int(11) DEFAULT NULL,
`unsuitability_coleader` int(11) DEFAULT NULL,
`unsuitability_participant` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
# Dump of table groups
# ------------------------------------------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`address_2` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`zip` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`dorm_id` int(11) DEFAULT NULL,
`ministry_id` int(11) DEFAULT NULL,
`campus_id` int(11) DEFAULT NULL,
`start_time` int(11) DEFAULT NULL,
`end_time` int(11) DEFAULT NULL,
`day` int(11) DEFAULT NULL,
`group_type_id` int(11) DEFAULT NULL,
`needs_approval` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_groups_on_ministry_id` (`ministry_id`),
KEY `index_groups_on_campus_id` (`campus_id`),
KEY `index_groups_on_dorm_id` (`dorm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
# Dump of table imports
# ------------------------------------------------------------
DROP TABLE IF EXISTS `imports`;
CREATE TABLE `imports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`size` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`content_type` varchar(255) DEFAULT NULL,
`filename` varchar(255) DEFAULT NULL,
`thumbnail` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table involvement_histories
# ------------------------------------------------------------
DROP TABLE IF EXISTS `involvement_histories`;
CREATE TABLE `involvement_histories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`campus_id` int(11) DEFAULT NULL,
`school_year_id` int(11) DEFAULT NULL,
`ministry_id` int(11) DEFAULT NULL,
`ministry_role_id` int(11) DEFAULT NULL,
`campus_involvement_id` int(11) DEFAULT NULL,
`ministry_involvement_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table ministries
# ------------------------------------------------------------
DROP TABLE IF EXISTS `ministries`;
CREATE TABLE `ministries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`zip` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`created_at` date DEFAULT NULL,
`updated_at` date DEFAULT NULL,
`ministries_count` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1225 DEFAULT CHARSET=utf8;
# Dump of table ministry_campuses
# ------------------------------------------------------------
DROP TABLE IF EXISTS `ministry_campuses`;
CREATE TABLE `ministry_campuses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ministry_id` int(11) DEFAULT NULL,
`campus_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_ministry_campuses_on_ministry_id_and_campus_id` (`ministry_id`,`campus_id`),
KEY `campus_id` (`campus_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10227 DEFAULT CHARSET=utf8;
# Dump of table ministry_involvements
# ------------------------------------------------------------
DROP TABLE IF EXISTS `ministry_involvements`;
CREATE TABLE `ministry_involvements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`ministry_id` int(11) DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`admin` tinyint(1) DEFAULT NULL,
`ministry_role_id` int(11) DEFAULT NULL,
`responsible_person_id` int(11) DEFAULT NULL,
`last_history_update_date` date DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `person_id` (`person_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5091 DEFAULT CHARSET=utf8;
# Dump of table ministry_role_permissions
# ------------------------------------------------------------
DROP TABLE IF EXISTS `ministry_role_permissions`;
CREATE TABLE `ministry_role_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`permission_id` int(11) DEFAULT NULL,
`ministry_role_id` int(11) DEFAULT NULL,
`created_at` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table ministry_roles
# ------------------------------------------------------------
DROP TABLE IF EXISTS `ministry_roles`;
CREATE TABLE `ministry_roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ministry_id` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`created_at` date DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`involved` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
# Dump of table news
# ------------------------------------------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`message` text,
`group_id` int(11) DEFAULT NULL,
`ministry_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`sticky` tinyint(1) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`staff` tinyint(1) DEFAULT NULL,
`students` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table news_comments
# ------------------------------------------------------------
DROP TABLE IF EXISTS `news_comments`;
CREATE TABLE `news_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`comment` text,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table people
# ------------------------------------------------------------
DROP TABLE IF EXISTS `people`;
CREATE TABLE `people` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`middle_name` varchar(255) DEFAULT NULL,
`preferred_name` varchar(255) DEFAULT NULL,
`gender` varchar(255) DEFAULT NULL,
`year_in_school` varchar(255) DEFAULT NULL,
`level_of_school` varchar(255) DEFAULT NULL,
`graduation_date` date DEFAULT NULL,
`major` varchar(255) DEFAULT NULL,
`minor` varchar(255) DEFAULT NULL,
`birth_date` date DEFAULT NULL,
`bio` text,
`image` varchar(255) DEFAULT NULL,
`created_at` date DEFAULT NULL,
`updated_at` date DEFAULT NULL,
`old_id` int(10) unsigned DEFAULT NULL,
`staff_notes` varchar(255) DEFAULT NULL,
`updated_by` varchar(11) DEFAULT NULL,
`created_by` varchar(11) DEFAULT NULL,
`url` varchar(2000) DEFAULT NULL,
`primary_campus_involvement_id` int(11) DEFAULT NULL,
`mentor_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_people_on_last_name_and_first_name` (`last_name`,`first_name`),
KEY `index_people_on_first_name` (`first_name`),
KEY `index_people_on_major_and_minor` (`major`,`minor`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=960346 DEFAULT CHARSET=utf8;
# Dump of table permissions
# ------------------------------------------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(1000) DEFAULT NULL,
`controller` varchar(255) DEFAULT NULL,
`action` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
# Dump of table person_news
# ------------------------------------------------------------
DROP TABLE IF EXISTS `person_news`;
CREATE TABLE `person_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`hidden` tinyint(1) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_person_news_on_person_id` (`person_id`),
KEY `index_person_news_on_news_id` (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table profile_pictures
# ------------------------------------------------------------
DROP TABLE IF EXISTS `profile_pictures`;
CREATE TABLE `profile_pictures` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`size` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`content_type` varchar(255) DEFAULT NULL,
`filename` varchar(255) DEFAULT NULL,
`thumbnail` varchar(255) DEFAULT NULL,
`uploaded_date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
# Dump of table schema_migrations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `schema_migrations`;
CREATE TABLE `schema_migrations` (
`version` varchar(255) NOT NULL,
UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table school_years
# ------------------------------------------------------------
DROP TABLE IF EXISTS `school_years`;
CREATE TABLE `school_years` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`level` varchar(255) DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
# Dump of table searches
# ------------------------------------------------------------
DROP TABLE IF EXISTS `searches`;
CREATE TABLE `searches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`options` text,
`query` text,
`tables` text,
`saved` tinyint(1) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`order` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
# Dump of table sessions
# ------------------------------------------------------------
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` varchar(255) NOT NULL,
`data` text,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_sessions_on_session_id` (`session_id`),
KEY `index_sessions_on_updated_at` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=560 DEFAULT CHARSET=utf8;
# Dump of table staff
# ------------------------------------------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ministry_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`created_at` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
# Dump of table states
# ------------------------------------------------------------
DROP TABLE IF EXISTS `states`;
CREATE TABLE `states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`abbreviation` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`country_code` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
# Dump of table stint_applications
# ------------------------------------------------------------
DROP TABLE IF EXISTS `stint_applications`;
CREATE TABLE `stint_applications` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`oldApplicationID` int(10) unsigned DEFAULT NULL,
`locationA` int(11) unsigned DEFAULT NULL,
`locationAExplanation` varchar(90) DEFAULT NULL,
`locationB` int(11) unsigned DEFAULT NULL,
`locationBExplanation` varchar(90) DEFAULT NULL,
`locationC` int(11) unsigned DEFAULT NULL,
`locationCExplanation` varchar(90) DEFAULT NULL,
`availableMonth` varchar(2) DEFAULT NULL,
`availableYear` varchar(4) DEFAULT NULL,
`hasMinistryConflict` int(10) DEFAULT NULL,
`ministryConflictExplanation` longtext,
`hasSpecificLocation` int(10) DEFAULT NULL,
`specificLocationRecruiterName` varchar(50) DEFAULT NULL,
`teamMembers` longtext,
`isDating` int(10) DEFAULT NULL,
`datingLocation` longtext,
`hasCampusPartnership` int(10) DEFAULT NULL,
`isDatingStint` int(10) DEFAULT NULL,
`datingStintName` longtext,
`language1` varchar(50) DEFAULT NULL,
`language1YearsStudied` varchar(20) DEFAULT NULL,
`language1Fluency` int(10) DEFAULT NULL,
`language2` varchar(50) DEFAULT NULL,
`language2YearsStudied` varchar(20) DEFAULT NULL,
`language2Fluency` int(10) DEFAULT NULL,
`previousMinistryExperience` longtext,
`ministryTraining` longtext,
`evangelismAttitude` longtext,
`isEvangelismTrainable` int(10) DEFAULT NULL,
`participationExplanation` longtext,
`isFamiliarFourSpiritualLaws` int(10) DEFAULT NULL,
`hasExperienceFourSpiritualLaws` int(10) DEFAULT NULL,
`confidenceFourSpiritualLaws` int(10) DEFAULT NULL,
`isFamiliarLifeAtLarge` int(10) DEFAULT NULL,
`hasExperienceLifeAtLarge` int(10) DEFAULT NULL,
`confidenceLifeAtLarge` int(10) DEFAULT NULL,
`isFamiliarPersonalTestimony` int(10) DEFAULT NULL,
`hasExperiencePersonalTestimony` int(10) DEFAULT NULL,
`confidencePersonalTestimony` int(10) DEFAULT NULL,
`isFamiliarExplainingGospel` int(10) DEFAULT NULL,
`hasExperienceExplainingGospel` int(10) DEFAULT NULL,
`confidenceExplainingGospel` int(10) DEFAULT NULL,
`isFamiliarSharingFaith` int(10) DEFAULT NULL,
`hasExperienceSharingFaith` int(10) DEFAULT NULL,
`confidenceSharingFaith` int(10) DEFAULT NULL,
`isFamiliarHolySpiritBooklet` int(10) DEFAULT NULL,
`hasExperienceHolySpiritBooklet` int(10) DEFAULT NULL,
`confidenceHolySpiritBooklet` int(10) DEFAULT NULL,
`isFamiliarFollowUp` int(10) DEFAULT NULL,
`hasExperienceFollowUp` int(10) DEFAULT NULL,
`confidenceFollowUp` int(10) DEFAULT NULL,
`isFamiliarHelpGrowInFaith` int(10) DEFAULT NULL,
`hasExperienceHelpGrowInFaith` int(10) DEFAULT NULL,
`confidenceHelpGrowInFaith` int(10) DEFAULT NULL,
`isFamiliarTrainShareFaith` int(10) DEFAULT NULL,
`hasExperienceTrainShareFaith` int(10) DEFAULT NULL,
`confidenceTrainShareFaith` int(10) DEFAULT NULL,
`isFamiliarOtherReligions` int(10) DEFAULT NULL,
`hasExperienceOtherReligions` int(10) DEFAULT NULL,
`confidenceOtherReligions` int(10) DEFAULT NULL,
`leadershipPositions` longtext,
`hasLedDiscipleshipGroup` int(10) DEFAULT NULL,
`discipleshipGroupSize` varchar(50) DEFAULT NULL,
`leadershipEvaluation` longtext,
`conversionMonth` int(10) DEFAULT NULL,
`conversionYear` int(10) DEFAULT NULL,
`memberChurchDenomination` varchar(75) DEFAULT NULL,
`memberChurchDuration` varchar(50) DEFAULT NULL,
`attendingChurchDenomination` varchar(50) DEFAULT NULL,
`attendingChurchDuration` varchar(50) DEFAULT NULL,
`attendingChurchInvolvement` longtext,
`quietTimeQuantity` longtext,
`quietTimeDescription` longtext,
`explanationOfSalvation` longtext,
`explanationOfSpiritFilled` longtext,
`hasInvolvementSpeakingTongues` int(10) DEFAULT NULL,
`differenceIndwellingFilled` longtext,
`hasCrimeConviction` int(10) DEFAULT NULL,
`crimeConvictionExplanation` longtext,
`hasDrugUse` int(10) DEFAULT NULL,
`isTobaccoUser` int(10) DEFAULT NULL,
`isWillingChangeHabits` int(10) DEFAULT NULL,
`authorityResponseExplanation` longtext,
`alcoholUseFrequency` longtext,
`alcoholUseDecision` longtext,
`isWillingRefrainAlcohol` int(10) DEFAULT NULL,
`unwillingRefrainAlcoholExplanation` longtext,
`drugUseExplanation` longtext,
`tobaccoUseExplanation` longtext,
`isWillingAbstainTobacco` int(10) DEFAULT NULL,
`hasRequestedPhoneCall` int(10) DEFAULT NULL,
`contactPhoneNumber` varchar(50) DEFAULT NULL,
`contactBestTime` varchar(50) DEFAULT NULL,
`contactTimeZone` varchar(50) DEFAULT NULL,
`sexualInvolvementExplanation` longtext,
`hasSexualGuidelines` int(10) DEFAULT NULL,
`sexualGuidelineExplanation` longtext,
`isCurrentlyDating` int(10) DEFAULT NULL,
`currentlyDatingLocation` longtext,
`hasHomosexualInvolvement` int(10) DEFAULT NULL,
`homosexualInvolvementExplanation` longtext,
`hasRecentPornographicInvolvement` int(10) DEFAULT NULL,
`pornographicInvolvementMonth` int(10) DEFAULT NULL,
`pornographicInvolvementYear` int(10) DEFAULT NULL,
`pornographicInvolvementExplanation` longtext,
`hasRecentSexualImmorality` int(10) DEFAULT NULL,
`sexualImmoralityMonth` int(10) DEFAULT NULL,
`sexualImmoralityYear` int(10) DEFAULT NULL,
`sexualImmoralityExplanation` longtext,
`hasOtherDateSinceImmorality` int(10) DEFAULT NULL,
`singleImmoralityResultsExplanation` longtext,
`marriedImmoralityResultsExplanation` longtext,
`immoralityLifeChangeExplanation` longtext,
`immoralityCurrentStrugglesExplanation` longtext,
`additionalMoralComments` longtext,
`isAwareMustRaiseSupport` int(10) DEFAULT NULL,
`isInDebt` int(10) DEFAULT NULL,
`debtNature1` varchar(50) DEFAULT NULL,
`debtTotal1` varchar(50) DEFAULT NULL,
`debtMonthlyPayment1` varchar(50) DEFAULT NULL,
`debtNature2` varchar(50) DEFAULT NULL,
`debtTotal2` varchar(50) DEFAULT NULL,
`debtMonthlyPayment2` varchar(50) DEFAULT NULL,
`debtNature3` varchar(50) DEFAULT NULL,
`debtTotal3` varchar(50) DEFAULT NULL,
`debtMonthlyPayment3` varchar(50) DEFAULT NULL,
`hasOtherFinancialResponsibility` int(10) DEFAULT NULL,
`otherFinancialResponsibilityExplanation` longtext,
`debtPaymentPlan` longtext,
`debtPaymentTimeframe` longtext,
`developingPartnersExplanation` longtext,
`isWillingDevelopPartners` int(10) DEFAULT NULL,
`unwillingDevelopPartnersExplanation` longtext,
`isCommittedDevelopPartners` int(10) DEFAULT NULL,
`uncommittedDevelopPartnersExplanation` longtext,
`personalTestimonyGrowth` longtext,
`internshipParticipationExplanation` longtext,
`internshipObjectives` longtext,
`currentMinistryDescription` longtext,
`personalStrengthA` longtext,
`personalStrengthB` longtext,
`personalStrengthC` longtext,
`personalDevelopmentA` longtext,
`personalDevelopmentB` longtext,
`personalDevelopmentC` longtext,
`personalDescriptionA` longtext,
`personalDescriptionB` longtext,
`personalDescriptionC` longtext,
`familyRelationshipDescription` longtext,
`electronicSignature` varchar(90) DEFAULT NULL,
`ssn` varchar(50) DEFAULT NULL,
`fk_ssmUserID` int(10) DEFAULT NULL,
`person_id` int(11) unsigned NOT NULL,
`isPaid` tinyint(1) DEFAULT NULL,
`appFee` decimal(18,0) DEFAULT NULL,
`dateAppLastChanged` datetime DEFAULT NULL,
`dateAppStarted` datetime DEFAULT NULL,
`dateSubmitted` datetime DEFAULT NULL,
`isSubmitted` tinyint(1) DEFAULT NULL,
`appStatus` varchar(15) DEFAULT NULL,
`assignedToProject` int(10) DEFAULT NULL,
`stint_location_id` decimal(10,0) DEFAULT NULL,
`siYear` varchar(50) DEFAULT NULL,
`submitDate` datetime DEFAULT NULL,
`status` varchar(22) DEFAULT NULL,
`appType` varchar(64) DEFAULT NULL,
`apply_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_PersonID` (`person_id`),
KEY `oldApplicationID` (`oldApplicationID`)
) ENGINE=MyISAM AUTO_INCREMENT=8962 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 532480 kB';
# Dump of table stint_locations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `stint_locations`;
CREATE TABLE `stint_locations` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`partnershipRegion` varchar(50) DEFAULT NULL,
`history` varchar(8000) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`details` varchar(8000) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`destinationGatewayCity` varchar(255) DEFAULT NULL,
`departDateFromGateCity` datetime DEFAULT NULL,
`arrivalDateAtLocation` datetime DEFAULT NULL,
`locationGatewayCity` varchar(255) DEFAULT NULL,
`departDateFromLocation` datetime DEFAULT NULL,
`arrivalDateAtGatewayCity` datetime DEFAULT NULL,
`flightBudget` int(10) DEFAULT NULL,
`gatewayCitytoLocationFlightNo` varchar(255) DEFAULT NULL,
`locationToGatewayCityFlightNo` varchar(255) DEFAULT NULL,
`inCountryContact` varchar(255) DEFAULT NULL,
`scholarshipAccountNo` varchar(255) DEFAULT NULL,
`operatingAccountNo` varchar(255) DEFAULT NULL,
`AOA` varchar(255) DEFAULT NULL,
`MPTA` varchar(255) DEFAULT NULL,
`staffCost` int(10) DEFAULT NULL,
`studentCost` int(10) DEFAULT NULL,
`studentCostExplaination` text,
`insuranceFormsReceived` tinyint(1) DEFAULT NULL,
`CAPSFeePaid` tinyint(1) DEFAULT NULL,
`adminFeePaid` tinyint(1) DEFAULT NULL,
`storiesXX` varchar(255) DEFAULT NULL,
`stats` varchar(255) DEFAULT NULL,
`secure` tinyint(1) DEFAULT NULL,
`projEvalCompleted` tinyint(1) DEFAULT NULL,
`evangelisticExposures` int(10) DEFAULT NULL,
`receivedChrist` int(10) DEFAULT NULL,
`jesusFilmExposures` int(10) DEFAULT NULL,
`jesusFilmReveivedChrist` int(10) DEFAULT NULL,
`coverageActivitiesExposures` int(10) DEFAULT NULL,
`coverageActivitiesDecisions` int(10) DEFAULT NULL,
`holySpiritDecisions` int(10) DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`destinationAddress` varchar(255) DEFAULT NULL,
`destinationPhone` varchar(255) DEFAULT NULL,
`siYear` varchar(255) DEFAULT NULL,
`fk_isCoord` int(11) DEFAULT NULL,
`fk_isAPD` int(11) DEFAULT NULL,
`fk_isPD` int(11) DEFAULT NULL,
`projectType` char(1) DEFAULT NULL,
`studentStartDate` datetime DEFAULT NULL,
`studentEndDate` datetime DEFAULT NULL,
`staffStartDate` datetime DEFAULT NULL,
`staffEndDate` datetime DEFAULT NULL,
`leadershipStartDate` datetime DEFAULT NULL,
`leadershipEndDate` datetime DEFAULT NULL,
`createDate` datetime DEFAULT NULL,
`lastChangedDate` binary(8) DEFAULT NULL,
`lastChangedBy` int(11) DEFAULT NULL,
`displayLocation` varchar(255) DEFAULT NULL,
`partnershipRegionOnly` tinyint(1) DEFAULT NULL,
`internCost` int(10) DEFAULT NULL,
`onHold` tinyint(1) DEFAULT NULL,
`maxNoStaffPMale` int(10) DEFAULT NULL,
`maxNoStaffPFemale` int(10) DEFAULT NULL,
`maxNoStaffPCouples` int(10) DEFAULT NULL,
`maxNoStaffPFamilies` int(10) DEFAULT NULL,
`maxNoStaffP` int(10) DEFAULT NULL,
`maxNoInternAMale` int(10) DEFAULT NULL,
`maxNoInternAFemale` int(10) DEFAULT NULL,
`maxNoInternACouples` int(10) DEFAULT NULL,
`maxNoInternAFamilies` int(10) DEFAULT NULL,
`maxNoInternA` int(10) DEFAULT NULL,
`maxNoInternPMale` int(10) DEFAULT NULL,
`maxNoInternPFemale` int(10) DEFAULT NULL,
`maxNoInternPCouples` int(10) DEFAULT NULL,
`maxNoInternPFamilies` int(10) DEFAULT NULL,
`maxNoInternP` int(10) DEFAULT NULL,
`maxNoStudentAMale` int(10) DEFAULT NULL,
`maxNoStudentAFemale` int(10) DEFAULT NULL,
`maxNoStudentACouples` int(10) DEFAULT NULL,
`maxNoStudentAFamilies` int(10) DEFAULT NULL,
`maxNoStudentA` int(10) DEFAULT NULL,
`maxNoStudentPMale` int(10) DEFAULT NULL,
`maxNoStudentPFemale` int(10) DEFAULT NULL,
`maxNoStudentPCouples` int(10) DEFAULT NULL,
`maxNoStudentPFamilies` int(10) DEFAULT NULL,
`maxNoStudentP` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1857 DEFAULT CHARSET=utf8;
# Dump of table summer_project_applications
# ------------------------------------------------------------
DROP TABLE IF EXISTS `summer_project_applications`;
CREATE TABLE `summer_project_applications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`summer_project_id` int(11) DEFAULT NULL,
`designation_number` int(11) DEFAULT NULL,
`year` int(11) DEFAULT NULL,
`status` varchar(50) DEFAULT NULL,
`preference1_id` int(11) DEFAULT NULL,
`preference2_id` int(11) DEFAULT NULL,
`preference3_id` int(11) DEFAULT NULL,
`preference4_id` int(11) DEFAULT NULL,
`preference5_id` int(11) DEFAULT NULL,
`current_project_queue_id` int(11) DEFAULT NULL,
`submitted_at` datetime DEFAULT NULL,
`completed_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`created_by_id` int(11) DEFAULT NULL,
`updated_by_id` int(11) DEFAULT NULL,
`old_id` int(10) unsigned DEFAULT NULL,
`apply_for_leadership` tinyint(1) DEFAULT NULL,
`withdrawn_at` datetime DEFAULT NULL,
`su_code` varchar(255) DEFAULT NULL,
`applicant_notified` tinyint(1) DEFAULT NULL,
`account_balance` int(11) DEFAULT NULL,
`accepted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_sp_applications_on_person_id` (`person_id`),
KEY `index_sp_applications_on_year` (`year`)
) ENGINE=InnoDB AUTO_INCREMENT=46577 DEFAULT CHARSET=utf8;
# Dump of table summer_projects
# ------------------------------------------------------------
DROP TABLE IF EXISTS `summer_projects`;
CREATE TABLE `summer_projects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pd_id` int(11) DEFAULT NULL,
`apd_id` int(11) DEFAULT NULL,
`opd_id` int(11) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`state` varchar(50) DEFAULT NULL,
`country` varchar(60) DEFAULT NULL,
`aoa` varchar(50) DEFAULT NULL,
`display_location` varchar(100) DEFAULT NULL,
`primary_partner` varchar(100) DEFAULT NULL,
`secondary_partner` varchar(100) DEFAULT NULL,
`partner_region_only` tinyint(1) DEFAULT NULL,
`report_stats_to` varchar(50) DEFAULT NULL,
`start_date` datetime DEFAULT NULL,
`end_date` datetime DEFAULT NULL,
`weeks` int(11) DEFAULT NULL,
`primary_ministry_focus_id` int(11) DEFAULT NULL,
`job` tinyint(1) DEFAULT NULL,
`description` text,
`operating_business_unit` varchar(50) DEFAULT NULL,
`operating_operating_unit` varchar(50) DEFAULT NULL,
`operating_department` varchar(50) DEFAULT NULL,
`operating_project` varchar(50) DEFAULT NULL,
`operating_designation` varchar(50) DEFAULT NULL,
`scholarship_business_unit` varchar(50) DEFAULT NULL,
`scholarship_operating_unit` varchar(50) DEFAULT NULL,
`scholarship_department` varchar(50) DEFAULT NULL,
`scholarship_project` varchar(50) DEFAULT NULL,
`scholarship_designation` varchar(50) DEFAULT NULL,
`staff_cost` int(11) DEFAULT NULL,
`intern_cost` int(11) DEFAULT NULL,
`student_cost` int(11) DEFAULT NULL,
`departure_city` varchar(60) DEFAULT NULL,
`date_of_departure` datetime DEFAULT NULL,
`destination_city` varchar(60) DEFAULT NULL,
`date_of_return` datetime DEFAULT NULL,
`in_country_contact` text,
`project_contact_name` varchar(50) DEFAULT NULL,
`project_contact_role` varchar(40) DEFAULT NULL,
`project_contact_phone` varchar(20) DEFAULT NULL,
`project_contact_email` varchar(100) DEFAULT NULL,
`max_student_men_applicants` int(11) NOT NULL DEFAULT '0',
`max_student_women_applicants` int(11) NOT NULL DEFAULT '0',
`housing_capacity_men` int(11) DEFAULT NULL,
`housing_capacity_women` int(11) DEFAULT NULL,
`ideal_staff_men` int(11) NOT NULL DEFAULT '0',
`ideal_staff_women` int(11) NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`created_by_id` int(11) DEFAULT NULL,
`updated_by_id` int(11) DEFAULT NULL,
`current_students_men` int(11) DEFAULT '0',
`current_students_women` int(11) DEFAULT '0',
`current_applicants_men` int(11) DEFAULT '0',
`current_applicants_women` int(11) DEFAULT '0',
`year` int(11) DEFAULT NULL,
`coordinator_id` int(11) DEFAULT NULL,
`old_id` int(11) DEFAULT NULL,
`project_status` varchar(255) DEFAULT NULL,
`latitude` double DEFAULT NULL,
`longitude` double DEFAULT NULL,
`url` varchar(1024) DEFAULT NULL,
`url_title` varchar(255) DEFAULT NULL,
`ds_project_code` varchar(50) DEFAULT NULL,
`show_on_website` tinyint(1) DEFAULT '1',
`apply_by_date` datetime DEFAULT NULL,
`version` int(11) DEFAULT NULL,
`use_provided_application` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `sp_projects_name_index` (`name`),
KEY `primary_partner` (`primary_partner`),
KEY `secondary_partner` (`secondary_partner`)
) ENGINE=InnoDB AUTO_INCREMENT=630 DEFAULT CHARSET=utf8;
# Dump of table test_table
# ------------------------------------------------------------
DROP TABLE IF EXISTS `test_table`;
CREATE TABLE `test_table` (
`test_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table timetables
# ------------------------------------------------------------
DROP TABLE IF EXISTS `timetables`;
CREATE TABLE `timetables` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
# Dump of table training_answers
# ------------------------------------------------------------
DROP TABLE IF EXISTS `training_answers`;
CREATE TABLE `training_answers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`training_question_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`completed_at` date DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`approved_by` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table training_categories
# ------------------------------------------------------------
DROP TABLE IF EXISTS `training_categories`;
CREATE TABLE `training_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`ministry_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
# Dump of table training_question_activations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `training_question_activations`;
CREATE TABLE `training_question_activations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ministry_id` int(11) DEFAULT NULL,
`training_question_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`mandate` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=953125642 DEFAULT CHARSET=utf8;
# Dump of table training_questions
# ------------------------------------------------------------
DROP TABLE IF EXISTS `training_questions`;
CREATE TABLE `training_questions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`activity` varchar(255) DEFAULT NULL,
`ministry_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`training_category_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
# Dump of table users
# ------------------------------------------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`last_login` date DEFAULT NULL,
`system_admin` tinyint(1) DEFAULT NULL,
`remember_token` varchar(255) DEFAULT NULL,
`remember_token_expires_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`guid` varchar(255) DEFAULT NULL,
`email_validated` tinyint(1) DEFAULT NULL,
`developer` tinyint(1) DEFAULT NULL,
`facebook_hash` varchar(255) DEFAULT NULL,
`facebook_username` varchar(255) DEFAULT NULL,
`fb_user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_users_on_guid` (`guid`)
) ENGINE=InnoDB AUTO_INCREMENT=853475 DEFAULT CHARSET=utf8;
# Dump of table view_columns
# ------------------------------------------------------------
DROP TABLE IF EXISTS `view_columns`;
CREATE TABLE `view_columns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`view_id` varchar(255) DEFAULT NULL,
`column_id` varchar(255) DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_view_columns_on_view_id` (`view_id`),
KEY `index_view_columns_on_column_id_and_view_id` (`column_id`,`view_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
# Dump of table views
# ------------------------------------------------------------
DROP TABLE IF EXISTS `views`;
CREATE TABLE `views` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`ministry_id` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`default_view` tinyint(1) DEFAULT NULL,
`select_clause` varchar(2000) DEFAULT NULL,
`tables_clause` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!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 */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment