New - Pastie

Language:

Click the checkbox to make this paste private

## mark a section (Learn more)

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;

Pastie Support Pastie or read my Pastie << self blog