$ActivityType->dropTable(); $ActivityType->createTable(); /* * StaffActivity Table * * Records details about some staff member's scheduled activity. * * staffactivity_id [INTEGER] unique id of the staff activity record * person_id [INTEGER] the id of the staff person associated with the activity * staffactivity_startdate [DATE] The start date of the activity * staffactivity_enddate [DATE] The end date of the activity. * staffactivity_contactPhone [STRING] The phone # where the staff member can be reached during the activity. * activitytype_id [INTEGER] The activity's type (i.e. "vacation") */ $StaffActivity = new RowManager_StaffActivityManager(); $StaffActivity->dropTable(); $StaffActivity->createTable(); /* * StaffScheduleType Table * * The HRDB schedule/form type. * * staffscheduletype_id [INTEGER] Unique ID for this form/schedule type * staffscheduletype_desc [STRING] Description of the staff form/schedule type. * staffscheduletype_startdate [DATE] The min. start date for the schedule/form context * staffscheduletype_enddate [DATE] The max ending date for the schedule/form. */ $StaffScheduleType = new RowManager_StaffScheduleTypeManager(); $StaffScheduleType->dropTable(); $StaffScheduleType->createTable(); /*
