/* * PriceRule Table * * A pricing rule (i.e. frosh discount) for a particular event. * * pricerules_id [INTEGER] Unique identifier for this pricing rule * event_id [INTEGER] Event identifier used to identify event associated with the pricing rule. * priceruletypes_id [INTEGER] Identifies the price rule type of the particular rule * pricerules_desc [STRING] Description of the pricing rule * fields_id [INTEGER] If not zero, refers to a form field identifier that affects the price for the event. * pricerules_value [STRING] A value that is used to determine when the price rule is applied (i.e. a date or a volume total, etc.) * pricerules_discount [INTEGER] The actual discount to be applied to the price based on this price rule. */ $PriceRule = new RowManager_PriceRuleManager(); $PriceRule->dropTable(); $PriceRule->createTable(); /* * EventAdminCampusAssignment Table * * Assigns the event admin privileges of some user to a particular campus. * * campusaccess_id [INTEGER] Identifier for a particular campus assignment to some event admin * eventadmin_id [INTEGER] Identifier of the event admin who will be assigned a campus * campus_id [INTEGER] The unique identifier that describes a particular university campus */ $EventAdminCampusAssignment = new RowManager_EventAdminCampusAssignmentManager(); $EventAdminCampusAssignment->dropTable(); $EventAdminCampusAssignment->createTable(); /* * CashTransaction Table *