Pastie Show Pastie some love or read my new blog

DROP TABLE IF EXISTS `person`;
DROP TABLE IF EXISTS `parents`;
DROP TABLE IF EXISTS `old_students`;
DROP TABLE IF EXISTS `phones`;
DROP TABLE IF EXISTS `medicals`;
DROP TABLE IF EXISTS `emails`;
DROP TABLE IF EXISTS `addresses`;
DROP TABLE IF EXISTS  `parents_students`;
DROP TABLE IF EXISTS `relationships`;
DROP TABLE IF EXISTS `auth_records`;
ALTER TABLE `parent` CHANGE `personID` `user_id` int(11) DEFAULT NULL ;
ALTER TABLE `parent` DROP `relationID`;
ALTER TABLE `parent` DROP `studentID`;
ALTER TABLE `parent` ADD `honorific` varchar(10) DEFAULT NULL;

RENAME TABLE `parent` TO `parents`;

RENAME TABLE `students` TO `old_students`;

RENAME TABLE `student` TO `students`;
ALTER TABLE `students` CHANGE `personID` `user_id` int(11) DEFAULT NULL ;
ALTER TABLE `students` CHANGE `studentID` `student_id` int(11) DEFAULT NULL ;
ALTER TABLE `students` CHANGE `schoolID` `site_id` int(11) DEFAULT NULL;
ALTER TABLE `students` ADD `kindergardenType` varchar(10) DEFAULT NULL ;
ALTER TABLE `students` CHANGE `flCanRegister` `fl_can_register` enum('true','false') NOT NULL DEFAULT "true" ;
ALTER TABLE `students` CHANGE `kindergardenType` `kindergarden_type` varchar(10) DEFAULT NULL;

RENAME TABLE `phone` TO `phones`;
ALTER TABLE `phones` CHANGE `phoneNumber` `phone_number` varchar(30) DEFAULT NULL;
ALTER TABLE `phones` CHANGE `personID` `user_id` int(11) DEFAULT NULL;

RENAME TABLE `medical` TO `medicals`;
ALTER TABLE `medicals` CHANGE `flFood` `fl_food` enum('true','false') NOT NULL DEFAULT "false";
ALTER TABLE `medicals` CHANGE `studentID` `student_id` int(11) UNSIGNED DEFAULT NULL;

RENAME TABLE `email` TO `emails`;
ALTER TABLE `emails` CHANGE `personID` `user_id` int(11) DEFAULT NULL;
ALTER TABLE `emails` CHANGE `flReceiveMailings` `fl_receive_mailings` enum('true','false') NOT NULL DEFAULT "false";
ALTER TABLE `emails` CHANGE `flPrimary` `fl_primary` enum('true','false') NOT NULL DEFAULT "false";
RENAME TABLE `authrecord` TO `auth_records`;
ALTER TABLE `auth_records` CHANGE `userID` `user_id` int(11) UNSIGNED NOT NULL DEFAULT "0";
ALTER TABLE `auth_records` CHANGE `flSelect` `fl_select` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `auth_records` CHANGE `flInsert` `fl_insert` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `auth_records` CHANGE `flUpdate` `fl_update` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `auth_records` CHANGE `flDelete` `fl_delete` enum('true','false') NOT NULL DEFAULT "false";

RENAME TABLE `address` TO `addresses`;
ALTER TABLE `addresses` CHANGE `personID` `user_id` int(11) DEFAULT NULL;
ALTER TABLE `addresses` CHANGE `flReceiveMailings` `fl_receive_mailings` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `addresses` CHANGE `flPrimary` `fl_primary` enum('true','false') NOT NULL DEFAULT "false";
# Dump of table parents_students
# ------------------------------------------------------------

CREATE TABLE `parents_students` (
  `id` int(11) NOT NULL auto_increment,
  `student_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  `fl_custodial` tinyint(4) default NULL,
  `relationship_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



# Dump of table relationships
# ------------------------------------------------------------

CREATE TABLE `relationships` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(20) default NULL,
`abbreviation` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;
INSERT INTO `relationships` (`id`,`title`,`abbreviation`) VALUES (NULL,"Custodial Parent","cp");
INSERT INTO `relationships` (`id`,`title`,`abbreviation`) VALUES (NULL,"Non-Custodial Parent","ncp");
INSERT INTO `relationships` (`id`,`title`,`abbreviation`) VALUES (NULL,"Grandparent","gp");
INSERT INTO `relationships` (`id`,`title`,`abbreviation`) VALUES (NULL,"Guardian","gar");
INSERT INTO `relationships` (`id`,`title`,`abbreviation`) VALUES (NULL,"Emergency Contact","ec");

# rename tables and columns to new standard
RENAME TABLE `aideoptions` TO `aide_options`;
ALTER TABLE `aide_options` CHANGE `shortName` `short_name` varchar(10) NOT NULL DEFAULT "";

RENAME TABLE `aideapp` TO `aide_apps`;

RENAME TABLE `applicationaccess` TO `application_accesses`;
ALTER TABLE `application_accesses` ADD `created` datetime DEFAULT NULL;
ALTER TABLE `application_accesses` ADD `modified` datetime DEFAULT NULL;
ALTER TABLE `application_accesses` CHANGE `username` `user_name` varchar(10) NOT NULL DEFAULT ""; 
ALTER TABLE `application_accesses` CHANGE `paymentFixer` `payment_fixer` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `application_accesses` CHANGE `enrollmentAdjust` `enrollment_adjust` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `application_accesses` CHANGE `passwordmanage` `password_manage` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `application_accesses` CHANGE `dataEntry` `data_entry` enum('true','false') NOT NULL DEFAULT "false";

RENAME TABLE `alerttext` TO `alert_texts`;

RENAME TABLE `camppayscale` TO `camp_payscales`;
ALTER TABLE `camp_payscales` CHANGE `studentsEnrolled` `students_enrolled` int(11) UNSIGNED NOT NULL DEFAULT "0"; 
ALTER TABLE `camp_payscales` CHANGE `payLevel` `pay_level` enum('Classified Level 1','Classified Level 2','Certified Level 1','Certified Level 2','Classified W/ Bach Level 1','Classified W/ Bach Level 2') NOT NULL DEFAULT "Classified Level 1" ;
ALTER TABLE `camp_payscales` CHANGE `minimumStaff` `minimum_staff` int(11) UNSIGNED DEFAULT NULL;

RENAME TABLE `careday` TO `care_days`;
ALTER TABLE `care_days` CHANGE `careyear_id` `care_year_id` int(11) DEFAULT NULL;
ALTER TABLE `care_days` CHANGE `careDayType_id` `care_day_type_id` int(11) UNSIGNED DEFAULT NULL;

RENAME TABLE `caredaytypes` TO `care_day_types`;
ALTER TABLE `care_day_types` CHANGE `sortOrder` `ordering` int(11) DEFAULT NULL;
ALTER TABLE `care_day_types` CHANGE `flActive` `fl_active` enum('true','false') NOT NULL DEFAULT "true"; 

RENAME TABLE `caremonth` TO `care_months`;
ALTER TABLE `care_months` CHANGE `careyear_id` `care_year_id` int(11) DEFAULT NULL;

RENAME TABLE `caremonth_fee` TO `care_month_fees`;
ALTER TABLE `care_month_fees` CHANGE `caremonthid` `care_month_id` int(11) DEFAULT NULL;
ALTER TABLE `care_month_fees` CHANGE `feeid` `fee_id` int(11) DEFAULT NULL;

RENAME TABLE `careyear` TO `care_years`;
ALTER TABLE `care_years` CHANGE `siteID` `site_id` int(11) DEFAULT NULL;
ALTER TABLE `care_years` CHANGE `CAREYear` `care_year` year(4) DEFAULT NULL;
ALTER TABLE `care_years` CHANGE `startDate` `start_date` date DEFAULT NULL;
ALTER TABLE `care_years` CHANGE `endDate` `end_date` date DEFAULT NULL ;
ALTER TABLE `care_years` CHANGE `laterate` `late_rate` int(11) NOT NULL DEFAULT "100";

RENAME TABLE `classpayscale` TO `class_payscales`;
ALTER TABLE `class_payscales` CHANGE `studentsEnrolled` `students_enrolled` int(11) UNSIGNED NOT NULL DEFAULT "0" ;
ALTER TABLE `class_payscales` CHANGE `minimumStaff` `minimum_staff` int(11) UNSIGNED NOT NULL DEFAULT "1"; 
ALTER TABLE `class_payscales` CHANGE `payLevel` `pay_level` enum('Classified Level 1','Classified Level 2','Certified Level 1','Certified Level 2','Classified W/ Bach Level 1','Classified W/ Bach Level 2') NOT NULL DEFAULT "Classified Level 1" ;

RENAME TABLE `commontext` TO `common_texts`;
ALTER TABLE `common_texts` CHANGE `shortName` `short_name` varchar(40) DEFAULT NULL;

RENAME TABLE `course_group` TO `course_groups`;
ALTER TABLE `course_groups` CHANGE `flActive` `fl_active` enum('true','false') NOT NULL DEFAULT "true"; 

ALTER TABLE `courses` CHANGE `gradeLevel` `grade` set('Pre-K','K','1','2','3','4','5','6','7','8','9','10','11','12','Adult') DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `courseYear` `course_year` year(4) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `startTime` `start_time` time DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `endTime` `end_time` time DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `startDate` `start_date` date DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `endDate` `end_date` date DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `materialFee` `material_fee` int(11) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `transportationFee` `transportation_fee` int(11) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `instructorID` `instructor_id` int(11) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `additionalInstructorIDs` `additional_instructor_id` varchar(20) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `maxStudents` `max_students` smallint(6) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `courseType` `course_type` enum('class','camp','special program','lunch') DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `dStartTime` `d_start_time` varchar(10) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `rTime` `r_time` varchar(20) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `dStartDate` `d_start_date` varchar(10) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `siteID` `site_id` int(11) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `sessionID` `session_id` int(11) DEFAULT NULL ;
ALTER TABLE `courses` CHANGE `transFeeOneWay` `trans_fee_one_way` int(11) NOT NULL DEFAULT "0" ;
ALTER TABLE `courses` CHANGE `transFeeTwoWay` `trans_fee_two_way` int(11) NOT NULL DEFAULT "0";
ALTER TABLE `courses` CHANGE `flDiscountable` `fl_discountable` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `courses` CHANGE `flCredit` `fl_credit` enum('true','false') NOT NULL DEFAULT "true"; 
ALTER TABLE `courses` CHANGE `flWebRegView` `fl_web_reg_view` enum('true','false') NOT NULL DEFAULT "true"; 
ALTER TABLE `courses` CHANGE `flDeleted` `fl_deleted` enum('true','false') NOT NULL DEFAULT "false"; 
ALTER TABLE `courses` CHANGE `flWaitlist` `fl_waitlist` enum('true','false') NOT NULL DEFAULT "false";

RENAME TABLE `dropped_course` TO `dropped_courses`;
ALTER TABLE `dropped_courses` CHANGE `studentID` `student_id` int(11) DEFAULT NULL ;
ALTER TABLE `dropped_courses` CHANGE `courseID` `course_id` int(11) DEFAULT NULL ;
ALTER TABLE `dropped_courses` CHANGE `dropsID` `drop_id` int(11) DEFAULT NULL ;
ALTER TABLE `dropped_courses` CHANGE `dropDate` `created` timestamp(14) DEFAULT NULL;

ALTER TABLE `drops` CHANGE `paymentID` `payment_id` int(11) DEFAULT NULL ;
ALTER TABLE `drops` CHANGE `refundID` `refund_id` int(11) DEFAULT NULL ;
ALTER TABLE `drops` CHANGE `dropFee` `drop_fee` int(11) DEFAULT NULL;

RENAME TABLE `emailtemplates` TO `email_templates`;

RENAME TABLE `enrolled_camp` TO `enrolled_camps`;
ALTER TABLE `enrolled_camps` CHANGE `paymentDate` `paymentDate` timestamp(14) DEFAULT NULL;

RENAME TABLE `enrolled_careday` TO `enrolled_care_days`;
ALTER TABLE `enrolled_care_days` CHANGE `caredayID` `care_day_id` int(11) UNSIGNED NOT NULL DEFAULT "0" ;
ALTER TABLE `enrolled_care_days` CHANGE `studentID` `student_id` int(11) UNSIGNED NOT NULL DEFAULT "0";
ALTER TABLE `enrolled_care_days` CHANGE `flPaid` `fl_paid` enum('true','false') NOT NULL DEFAULT "false";
ALTER TABLE `enrolled_care_days` CHANGE `registrationDate` `registration_date` timestamp(14) DEFAULT NULL;
ALTER TABLE `enrolled_care_days` CHANGE `enrollmentDate` `enrollment_date` timestamp(14) DEFAULT "00000000000000" ;
ALTER TABLE `enrolled_care_days` CHANGE `registrationID` `registration_id` int(10) UNSIGNED DEFAULT NULL;
ALTER TABLE `enrolled_care_days` CHANGE `flDropped` `fl_dropped` enum('true','false') NOT NULL DEFAULT "false";
ALTER TABLE `enrolled_care_days` CHANGE `droppedDate` `dropped_date` timestamp(14) DEFAULT "00000000000000" ;
ALTER TABLE `enrolled_care_days` CHANGE `prevRegistrationID` `prev_registration_id` int(11) UNSIGNED DEFAULT NULL ;
ALTER TABLE `enrolled_care_days` CHANGE `dropminutes` `drop_minutes` int(11) DEFAULT NULL;
ALTER TABLE `enrolled_care_days` CHANGE `pickupminutes` `pickup_minutes` int(11) DEFAULT NULL;
ALTER TABLE `enrolled_care_days` CHANGE `dayOption` `day_option` enum('Full','Half','') NOT NULL DEFAULT "";
ALTER TABLE `enrolled_care_days` CHANGE `hourRate` `hour_rate` int(11) DEFAULT NULL;
ALTER TABLE `enrolled_care_days` CHANGE `lateMinutes` `late_minutes` int(11) DEFAULT NULL;
ALTER TABLE `enrolled_care_days` CHANGE `enrollment_date` `created` datetime DEFAULT "00000000000000";

RENAME TABLE `enrolled_class` TO `enrolled_classes`;

RENAME TABLE `enrolled_course` TO `enrolled_courses`;
ALTER TABLE `enrolled_courses` CHANGE `courseID` `course_id` int(11) UNSIGNED NOT NULL DEFAULT "0";
ALTER TABLE `enrolled_courses` CHANGE `studentID` `student_id` int(11) UNSIGNED NOT NULL DEFAULT "0" ;
ALTER TABLE `enrolled_courses` CHANGE `flPaid` `fl_paid` enum('true','false') NOT NULL DEFAULT "false" ;
ALTER TABLE `enrolled_courses` CHANGE `registrationDate` `registration_date` timestamp(14) DEFAULT NULL;
ALTER TABLE `enrolled_courses` CHANGE `enrollmentDate` `enrollment_date` timestamp(14) DEFAULT "00000000000000";
ALTER TABLE `enrolled_courses` CHANGE `registrationID` `registration_id` int(10) UNSIGNED DEFAULT NULL ;
ALTER TABLE `enrolled_courses` CHANGE `flCareDiscount` `fl_care_discount` enum('true','false') NOT NULL DEFAULT "false";
ALTER TABLE `enrolled_courses` CHANGE `flDropped` `fl_dropped` enum('true','false') NOT NULL DEFAULT "false" ;
ALTER TABLE `enrolled_courses` CHANGE `droppedDate` `dropped_date` timestamp(14) DEFAULT "00000000000000" ;
ALTER TABLE `enrolled_courses` CHANGE `prevRegistrationID` `prev_registration_id` int(11) UNSIGNED DEFAULT NULL;
ALTER TABLE `enrolled_courses` CHANGE `flTransportation` `fl_transportation` enum('true','false') NOT NULL DEFAULT "true";
ALTER TABLE `enrolled_courses` CHANGE `transOptions` `trans_options` set('to','from') DEFAULT NULL;
ALTER TABLE `enrolled_courses` CHANGE `enrollment_date` `created` datetime DEFAULT "0000-00-00 00:00:00";

RENAME TABLE `fee` TO `fees`;
ALTER TABLE `fees` CHANGE `feeType` `fee_type` varchar(100) DEFAULT NULL;
ALTER TABLE `fees` CHANGE `feeTimestamp` `created` timestamp(14) DEFAULT NULL ;
ALTER TABLE `fees` CHANGE `registrationID` `registration_id` int(11) DEFAULT NULL;

RENAME TABLE `instructorapp` TO `instructor_apps`;
ALTER TABLE `instructor_apps` CHANGE `flTutor` `fl_tutor` enum('true','false') DEFAULT "false" ;

ALTER TABLE `notes` CHANGE `userID` `user_id` int(10) UNSIGNED DEFAULT NULL ;
ALTER TABLE `notes` CHANGE `noteTimeStamp` `created` timestamp(12) DEFAULT NULL;

ALTER TABLE `payments` CHANGE `paymentMethod` `payment_method` enum('cash','credit card','check','other') NOT NULL DEFAULT "cash";
ALTER TABLE `payments` CHANGE `paymentDate` `created` timestamp(14) DEFAULT NULL;
ALTER TABLE `payments` CHANGE `authorizationNumber` `authorization_number` varchar(11) DEFAULT NULL;
ALTER TABLE `payments` CHANGE `paymentType` `payment_type` varchar(20) DEFAULT NULL;
ALTER TABLE `payments` CHANGE `amountPaid` `amount_paid` int(11) NOT NULL DEFAULT "0" ;
ALTER TABLE `payments` CHANGE `expDate` `exp_date` varchar(9) DEFAULT NULL;
ALTER TABLE `payments` CHANGE `transactionNumber` `transaction_number` int(11) DEFAULT NULL;
ALTER TABLE `payments` CHANGE `registratorID` `registrator_id` int(11) UNSIGNED DEFAULT "0" ;
ALTER TABLE `payments` CHANGE `registrationID` `registration_id` int(11) UNSIGNED DEFAULT NULL ;
ALTER TABLE `payments` CHANGE `lastFirst` `last_first` varchar(40) DEFAULT NULL ;
ALTER TABLE `payments` CHANGE `amountDue` `amount_due` int(11) DEFAULT NULL;
ALTER TABLE `payments` CHANGE `paymentClass` `payment_class` enum('payment','refund') DEFAULT NULL;

RENAME TABLE `reciept` TO `reciepts`;
ALTER TABLE `reciepts` CHANGE `flDiscountable` `fl_discountable` enum('true','false') DEFAULT "false";
ALTER TABLE `reciepts` CHANGE `classFee` `class_fee` int(11) DEFAULT NULL;
ALTER TABLE `reciepts` CHANGE `materialFee` `material_fee` int(11) DEFAULT NULL ;
ALTER TABLE `reciepts` CHANGE `transportationFee` `transportation_fee` int(11) DEFAULT NULL;
ALTER TABLE `reciepts` CHANGE `instructorid` `instructor_id` int(11) DEFAULT NULL;

ALTER TABLE `refunds` CHANGE `poNumber` `po_number` int(11) DEFAULT NULL ;
ALTER TABLE `refunds` CHANGE `refundDate` `created` timestamp(14) DEFAULT NULL;

RENAME TABLE `registrationnote` TO `registration_notes`;
ALTER TABLE `registration_notes` CHANGE `registrationID` `registration_id` int(11) UNSIGNED DEFAULT NULL ;
ALTER TABLE `registration_notes` CHANGE `noteID` `note_id` int(11) UNSIGNED DEFAULT NULL;

ALTER TABLE `registrations` CHANGE `amountDue` `amount_due` int(11) NOT NULL DEFAULT "0" ;
ALTER TABLE `registrations` CHANGE `tShirtCosts` `t_shirt_costs` int(11) NOT NULL DEFAULT "0";
ALTER TABLE `registrations` CHANGE `feeWaiverAmount` `fee_waiver_amount` int(11) NOT NULL DEFAULT "0" ;
ALTER TABLE `registrations` CHANGE `feeWaiverPercent` `fee_waiver_percent` int(3) NOT NULL DEFAULT "0";
ALTER TABLE `registrations` CHANGE `multiClassDiscount` `multi_class_discount` int(11) NOT NULL DEFAULT "0";
ALTER TABLE `registrations` CHANGE `subTotal` `sub_total` int(11) NOT NULL DEFAULT "0" ;
ALTER TABLE `registrations` CHANGE `registrationFee` `registration_fee` int(11) NOT NULL DEFAULT "0" ;
ALTER TABLE `registrations` CHANGE `amountPaid` `amount_paid` int(11) NOT NULL DEFAULT "0" ;
ALTER TABLE `registrations` CHANGE `registratorID` `registrator_id` int(11) NOT NULL DEFAULT "0";
ALTER TABLE `registrations` CHANGE `dropFee` `drop_fee` int(11) NOT NULL DEFAULT "0";
ALTER TABLE `registrations` CHANGE `flEmergencyWaiver` `fl_emergency_waiver` enum('true','false') NOT NULL DEFAULT "false" ;
ALTER TABLE `registrations` CHANGE `registrationYear` `registration_year` year(4) DEFAULT "2005";
ALTER TABLE `registrations` CHANGE `date` `created` datetime DEFAULT NULL ;

ALTER TABLE `sessions` CHANGE `siteID` `site_id` set('1','2','3','4','5','6','7','8','9','10') DEFAULT "10" ;
ALTER TABLE `sessions` CHANGE `startDate` `start_date` date DEFAULT NULL ;
ALTER TABLE `sessions` CHANGE `endDate` `end_date` date DEFAULT NULL;
ALTER TABLE `sessions` CHANGE `beginRegistration` `begin_registration` datetime DEFAULT NULL;
ALTER TABLE `sessions` CHANGE `endRegistration` `end_registration` datetime DEFAULT NULL ;
ALTER TABLE `sessions` CHANGE `dayCount` `day_count` int(4) NOT NULL DEFAULT "0" ;
ALTER TABLE `sessions` CHANGE `courseYear` `course_year` year(4) DEFAULT "2004";
ALTER TABLE `sessions` CHANGE `beginCatalog` `begin_catalog` datetime DEFAULT NULL;
ALTER TABLE `sessions` CHANGE `endCatalog` `end_catalog` datetime DEFAULT NULL;
ALTER TABLE `sessions` CHANGE `sortOrder` `ordering` smallint(4) DEFAULT NULL;
ALTER TABLE `sessions` CHANGE `registrationFee` `registration_fee` int(11) NOT NULL DEFAULT "0"; 
ALTER TABLE `sessions` CHANGE `policyNote` `policy_note` text DEFAULT NULL; 
ALTER TABLE `sessions` CHANGE `gradeLevel` `grade` set('Pre-K','K','1','2','3','4','5','6','7','8','9','10','11','12','Adult') DEFAULT NULL; 
ALTER TABLE `sessions` CHANGE `flActive` `fl_active` enum('true','false') NOT NULL DEFAULT "true"; 
ALTER TABLE `sessions` CHANGE `flSummer` `fl_summer` enum('true','false') NOT NULL DEFAULT "false";

ALTER TABLE `sites` CHANGE `shortName` `name` varchar(30) DEFAULT NULL;
ALTER TABLE `sites` CHANGE `longName` `long_name` varchar(100) DEFAULT NULL;
ALTER TABLE `sites` CHANGE `startGrade` `start_grade` smallint(6) DEFAULT NULL;
ALTER TABLE `sites` CHANGE `endGrade` `end_grade` smallint(6) DEFAULT NULL;

RENAME TABLE `teacherpayreport` TO `teacher_pay_reports`;
ALTER TABLE `teacher_pay_reports` CHANGE `instructorId` `teacher_id` int(11) DEFAULT NULL;
ALTER TABLE `teacher_pay_reports` CHANGE `startTime` `start_time` time DEFAULT NULL;
ALTER TABLE `teacher_pay_reports` CHANGE `endTime` `end_time` time DEFAULT NULL;
ALTER TABLE `teacher_pay_reports` CHANGE `startDate` `start_date` date DEFAULT NULL;
ALTER TABLE `teacher_pay_reports` CHANGE `dStartTime` `d_start_time` varchar(10) DEFAULT NULL;
ALTER TABLE `teacher_pay_reports` CHANGE `sessionID` `session_id` int(11) NOT NULL DEFAULT "0";
ALTER TABLE `teacher_pay_reports` CHANGE `dayCount` `day_count` int(5) NOT NULL DEFAULT "0";
ALTER TABLE `teacher_pay_reports` CHANGE `payLevel` `pay_level` enum('Undefined','Classified Level 1','Classified Level 2','Classified w/Bach Level 1','Classified w/Bach Level 2','Certified Level 1','Certified Level 2') NOT NULL DEFAULT "Undefined";
ALTER TABLE `teacher_pay_reports` CHANGE `teachersLastFirst` `teachers_last_first` varchar(50) BINARY DEFAULT NULL;

ALTER TABLE `teachers` CHANGE `flFingerPrint` `fl_fingerprint` enum('true','false') DEFAULT NULL;
ALTER TABLE `teachers` CHANGE `payLevel` `pay_level` enum('Undefined','Classified Level 1','Classified Level 2','Certified Level 1','Certified Level 2','Classified W/ Bach Level 1','Classified W/ Bach Level 2') NOT NULL DEFAULT "Undefined" ;ALTER TABLE `teachers` CHANGE `gradeLevel` `grade` set('K','1','2','3','4','5','6','7','8','9','10','11','12','Adult','NA') NOT NULL DEFAULT "NA" ;ALTER TABLE `teachers` CHANGE `lastFirst` `last_first` varchar(100) DEFAULT NULL ;
ALTER TABLE `teachers` CHANGE `cryptPass` `crypt_pass` varchar(32) DEFAULT NULL;
ALTER TABLE `teachers` ADD `user_id` int DEFAULT NULL;

ALTER TABLE `users` CHANGE `userName` `user_name` varchar(10) NOT NULL DEFAULT "" ;
ALTER TABLE `users` CHANGE `firstName` `first_name` varchar(20) DEFAULT NULL;
ALTER TABLE `users` CHANGE `lastName` `last_name` varchar(20) DEFAULT NULL;
ALTER TABLE `users` CHANGE `cryptPass` `crypt_pass` varchar(32) DEFAULT NULL ;ALTER TABLE `users` CHANGE `type` `user_type_id` int(11) NOT NULL DEFAULT "0";

RENAME TABLE `waiver` TO `waivers`;
ALTER TABLE `waivers` CHANGE `studentID` `student_id` int(11) DEFAULT NULL ;
ALTER TABLE `waivers` CHANGE `sessionID` `session_id` int(11) DEFAULT NULL;
ALTER TABLE `waivers` CHANGE `entered` `created` timestamp(14) DEFAULT NULL;